namespace ASPNET.StarterKit.Communities.PhotoGallery {

    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Collections;
    using ASPNET.StarterKit.Communities;
    using System.Text.RegularExpressions;
    using System.IO;


    //*********************************************************************
    //
    // PhotoUtility Class
    //
    // Contains static utility methods used by the PhotoGallery section. 
    //
    //*********************************************************************

	public class PhotoUtility {


        //*********************************************************************
        //
        // AddPhoto Method
        //
        // Adds a new image to the database. 
        //
        //*********************************************************************
	
		public static int AddPhoto
		(
		     string username, 
		     int sectionID,  
		     int moderationStatus, 
		     string title,
		     string briefDescription,
		     string fullDescription,
		     int topicID
		) {
			 SqlConnection conPortal=new SqlConnection(CommunityGlobals.ConnectionString);
			 SqlCommand cmdAdd = new SqlCommand("Community_PhotoGalleryAddPhoto", conPortal);
			 cmdAdd.CommandType = CommandType.StoredProcedure;

             cmdAdd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
             cmdAdd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
             cmdAdd.Parameters.Add("@username", username);
             cmdAdd.Parameters.Add("@sectionID", sectionID);
             cmdAdd.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(briefDescription) );
             cmdAdd.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(briefDescription) );
             cmdAdd.Parameters.Add("@moderationStatus", moderationStatus);
             cmdAdd.Parameters.Add("@topicID", topicID);
             cmdAdd.Parameters.Add("@title", title);
             cmdAdd.Parameters.Add("@briefDescription", briefDescription);
			 cmdAdd.Parameters.Add("@fullDescription", SqlDbType.NText);
			 cmdAdd.Parameters[ "@fullDescription" ].Value = fullDescription;
             
             conPortal.Open();
             cmdAdd.ExecuteNonQuery();
             int result = (int)cmdAdd.Parameters["@RETURN_VALUE"].Value;

             // Add Search Keys
             SearchUtility.AddSearchKeys(conPortal, sectionID, result, title, briefDescription);

             conPortal.Close();
             
             return result;
		}


        //*********************************************************************
        //
        // EditPhoto Method
        //
        // Edits an existing photo in the database. 
        //
        //*********************************************************************

		public static void EditPhoto
		(
		     string username,
		     int sectionID, 
		     int contentPageID,  
		     string title,
		     string briefDescription,
		     string fullDescription,
		     int topicID
		) {
			 SqlConnection conPortal=new SqlConnection(CommunityGlobals.ConnectionString);
			 SqlCommand cmdAdd = new SqlCommand("Community_PhotoGalleryEditPhoto", conPortal);
			 cmdAdd.CommandType = CommandType.StoredProcedure;

             cmdAdd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
             cmdAdd.Parameters.Add("@username", username);
             cmdAdd.Parameters.Add("@contentPageID", contentPageID);
             cmdAdd.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(briefDescription) );
             cmdAdd.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(briefDescription) );
             cmdAdd.Parameters.Add("@topicID", topicID);
             cmdAdd.Parameters.Add("@title", title);
             cmdAdd.Parameters.Add("@briefDescription", briefDescription);
			 cmdAdd.Parameters.Add("@fullDescription", SqlDbType.NText);
			 cmdAdd.Parameters[ "@fullDescription" ].Value = fullDescription;
             
             conPortal.Open();
             cmdAdd.ExecuteNonQuery();
             
              // Edit Search Keys
             SearchUtility.EditSearchKeys(conPortal, sectionID, contentPageID, title, briefDescription);
             
             conPortal.Close();
		}


        //*********************************************************************
        //
        // GetPhotos Method
        //
        // Retrieves all photos for a particular section. 
        //
        //*********************************************************************

		public static ArrayList GetPhotos(string username, int sectionID, int pageSize, int pageIndex, string sortOrder) {
		    ArrayList colImages = new ArrayList();
			
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdGet = new SqlCommand("Community_PhotoGalleryGetPhotos", conPortal);
			cmdGet.CommandType=CommandType.StoredProcedure;

			cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdGet.Parameters.Add("@username", username);
			cmdGet.Parameters.Add("@sectionID", sectionID);
			cmdGet.Parameters.Add("@pageSize", pageSize);
			cmdGet.Parameters.Add("@pageIndex", pageIndex);
			cmdGet.Parameters.Add("@sortOrder", sortOrder);

			conPortal.Open();
			SqlDataReader dr = cmdGet.ExecuteReader();
			while (dr.Read())
			 colImages.Add(new PhotoInfo(dr));
			conPortal.Close();
			return colImages;
		}


        //*********************************************************************
        //
        // GetPhoto Method
        //
        // Gets a particular photo from the database. 
        //
        //*********************************************************************
		
		public static ContentInfo GetPhoto(string username, int contentPageID) {
		    PhotoInfo objPhotoInfo = null;
		
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdGet = new SqlCommand("Community_PhotoGalleryGetPhoto", conPortal);
			cmdGet.CommandType = CommandType.StoredProcedure;

            cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdGet.Parameters.Add("@username", username);
            cmdGet.Parameters.Add("@contentPageID", contentPageID);
            
            conPortal.Open();
            SqlDataReader dr = cmdGet.ExecuteReader();
            if (dr.Read())
                objPhotoInfo = new PhotoInfo(dr);
            conPortal.Close();
            
            return (ContentInfo)objPhotoInfo;
		}



        //*********************************************************************
        //
        // GetNewPhotos Method
        //
        // Retrieves new photos from the database. 
        //
        //*********************************************************************

		// rs mod added userName
		
		public static ArrayList GetNewPhotos() 
		{
			return GetNewPhotos("");
		}

		public static ArrayList GetNewPhotos(string userName) 
		{
			ArrayList colImages = new ArrayList();
			
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdGet = new SqlCommand("Community_PhotoGalleryGetNewPhotos", conPortal);
			cmdGet.CommandType=CommandType.StoredProcedure;
			
			cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdGet.Parameters.Add("@userName", userName);

			conPortal.Open();
			SqlDataReader dr = cmdGet.ExecuteReader();
			while (dr.Read())
				colImages.Add(new PhotoInfo(dr));
			conPortal.Close();
			return colImages;
		}

		// end rs

        //*********************************************************************
        //
        // GetPopularPhotos Method
        //
        // Gets popular photos from the database. 
        //
        //*********************************************************************

		// rs mod added userName

		public static ArrayList GetPopularPhotos() 
		{
			return GetPopularPhotos("");
		}

		public static ArrayList GetPopularPhotos(string userName) 
		{
			ArrayList colImages = new ArrayList();
			
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdGet = new SqlCommand("Community_PhotoGalleryGetPopularPhotos", conPortal);
			cmdGet.CommandType=CommandType.StoredProcedure;

			cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdGet.Parameters.Add("@userName", userName);
            
			conPortal.Open();
			SqlDataReader dr = cmdGet.ExecuteReader();
			while (dr.Read())
				colImages.Add(new PhotoInfo(dr));
			conPortal.Close();
			return colImages;
		}

		// end rs






		
	}
}