namespace ASPNET.StarterKit.Communities.Downloads {

    using System;
    using System.Collections;
    using System.Data;
    using System.Data.SqlClient;
    using ASPNET.StarterKit.Communities;


    //*********************************************************************
    //
    // DownloadsUtility Class
    //
    // Contains static utility methods used by the Downloads section. 
    //
    //*********************************************************************
	
	public class DownloadsUtility {
	
	

        //*********************************************************************
        //
        // AddDownload Method
        //
        // Adds a new download to the database. 
        //
        //*********************************************************************
	
		public static int AddDownload
		(
		  string username, 
		  int sectionID, 
		  ModerationStatus moderationStatus,
		  string downloadTitle, 
		  string downloadBriefDescription, 
		  string downloadFullDescription,
		  int topicID,
		  string fileName, 
		  byte[] fileData
		) {
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_DownloadsAddDownload", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
            cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmd.Parameters.Add("@username", username);
            cmd.Parameters.Add("@sectionID", sectionID);
            cmd.Parameters.Add("@moderationStatus", (int)moderationStatus);
            cmd.Parameters.Add("@downloadTitle", downloadTitle);
            cmd.Parameters.Add("@downloadBriefDescription", downloadBriefDescription);
            cmd.Parameters.Add("@downloadFullDescription", SqlDbType.NText);
			cmd.Parameters["@downloadFullDescription"].Value = downloadFullDescription;
            cmd.Parameters.Add("@downloadMetaDescription", ContentPageUtility.CalculateMetaDescription(downloadBriefDescription));
            cmd.Parameters.Add("@downloadMetaKeys", ContentPageUtility.CalculateMetaKeys(downloadBriefDescription));
            cmd.Parameters.Add("@topicID", topicID);
            cmd.Parameters.Add("@downloadFileName", fileName);
            cmd.Parameters.Add("@downloadFile", SqlDbType.Image).Value = fileData;
            
            conPortal.Open();
            cmd.ExecuteNonQuery();
            int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;


            // Add Search Keys
            SearchUtility.AddSearchKeys(conPortal, sectionID, result, downloadTitle, downloadBriefDescription);

            conPortal.Close();
            
            return result;
		}



        //*********************************************************************
        //
        // EditDownload Method
        //
        // Edits an existing download the database. 
        //
        //*********************************************************************

		public static void EditDownload
		(
		  string username, 
		  int sectionID,
		  int contentPageID, 
		  string downloadTitle, 
		  string downloadBriefDescription, 
		  string downloadFullDescription,
		  int topicID,
		  string fileName, 
		  byte[] fileData
		) {
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_DownloadsEditDownload", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmd.Parameters.Add("@username", username);
            cmd.Parameters.Add("@contentPageID", contentPageID);
            cmd.Parameters.Add("@downloadTitle", downloadTitle);
            cmd.Parameters.Add("@downloadBriefDescription", downloadBriefDescription);
            cmd.Parameters.Add("@downloadFullDescription", SqlDbType.NText);
			cmd.Parameters["@downloadFullDescription"].Value = downloadFullDescription;
			cmd.Parameters.Add("@downloadMetaDescription", ContentPageUtility.CalculateMetaDescription(downloadBriefDescription));
            cmd.Parameters.Add("@downloadMetaKeys", ContentPageUtility.CalculateMetaKeys(downloadBriefDescription));
            cmd.Parameters.Add("@topicID", topicID);
            cmd.Parameters.Add("@downloadFileName", fileName);
            cmd.Parameters.Add("@downloadFile", SqlDbType.Image).Value = fileData;
            
            conPortal.Open();
            cmd.ExecuteNonQuery();
            
			
            // Edit Search Keys
            SearchUtility.EditSearchKeys(conPortal, sectionID, contentPageID, downloadTitle, downloadBriefDescription);
            
            
            conPortal.Close();
		}


	

        //*********************************************************************
        //
        // GetDownloads Method
        //
        // Gets downloads for this section from the database. 
        //
        //*********************************************************************

		public static ArrayList GetDownloads(string username, int sectionID, int pageSize, int pageIndex, string sortOrder) {
		    ArrayList colDownloads = new ArrayList();
		
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_DownloadsGetDownloads", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@username", username);
			cmd.Parameters.Add("@sectionID", sectionID);
			cmd.Parameters.Add("@pageSize", pageSize);
			cmd.Parameters.Add("@pageIndex", pageIndex);
			cmd.Parameters.Add("@sortOrder", sortOrder);
            
            conPortal.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
                colDownloads.Add(new DownloadInfo(dr));
            conPortal.Close();
            
            return colDownloads;
		}


	

        //*********************************************************************
        //
        // GetDownloadInfo Method
        //
        // Gets a particular download from the database. 
        //
        //*********************************************************************

		public static ContentInfo GetDownloadInfo(string username, int contentPageID) {
		    DownloadInfo _downloadInfo = null;
		
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_DownloadsGetDownload", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@username", username);
			cmd.Parameters.Add("@contentPageID", contentPageID);
            
            conPortal.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
                _downloadInfo = new DownloadInfo(dr);
            conPortal.Close();
            
            return _downloadInfo;
		}


	

        //*********************************************************************
        //
        // GetFile Method
        //
        // Retrives download file to the database. 
        //
        //*********************************************************************

		public static SqlDataReader GetFile(int contentPageID) {
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_DownloadsGetFile", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@contentPageID", contentPageID);

			conPortal.Open();
			return cmd.ExecuteReader(CommandBehavior.CloseConnection);
		}
	}
}