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

namespace ASPNET.StarterKit.Communities.Links {


    //*********************************************************************
    //
    // LinksUtility Class
    //
    // Contains static utility methods used by the Links section. 
    //
    //*********************************************************************
	
	public class LinksUtility {


        //*********************************************************************
        //
        // AddLink Method
        //
        // Adds a new link to the database. 
        //
        //*********************************************************************

		public static int AddLink
		(
		  int sectionID,
		  string username,
		  string linkTitle, 
		  string linkUrl, 
		  string linkDescription,
		  int moderationStatus,
		  int topicID 
		 ) {
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_LinksAddLink", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
            cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@sectionID", sectionID);
			cmd.Parameters.Add("@username", username);
			cmd.Parameters.Add("@linkTitle", linkTitle.Trim());
			cmd.Parameters.Add("@linkUrl", linkUrl.Trim());
			cmd.Parameters.Add("@linkDescription", linkDescription.Trim());
			cmd.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(linkDescription));
			cmd.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(linkDescription));
			cmd.Parameters.Add("@moderationStatus", moderationStatus);
			cmd.Parameters.Add("@topicID", topicID);

			conPortal.Open();
			cmd.ExecuteNonQuery();
			int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;

            // Add Search Keys
            SearchUtility.AddSearchKeys(conPortal, sectionID, result, linkTitle, linkDescription);


			conPortal.Close();

			return result;
		}


        //*********************************************************************
        //
        // EditLink Method
        //
        // Edits an existing link in the database. 
        //
        //*********************************************************************

		public static void EditLink
		(
		  string username,
		  int sectionID,
		  int contentPageID,
		  string linkTitle, 
		  string linkUrl, 
		  string linkDescription,
		  int topicID 
		 ) {
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_LinksEditLink", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

            cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@contentPageID", contentPageID);
			cmd.Parameters.Add("@username", username);
			cmd.Parameters.Add("@linkTitle", linkTitle.Trim());
			cmd.Parameters.Add("@linkUrl", linkUrl.Trim());
			cmd.Parameters.Add("@linkDescription", linkDescription.Trim());
			cmd.Parameters.Add("@metaDescription", ContentPageUtility.CalculateMetaDescription(linkDescription));
			cmd.Parameters.Add("@metaKeys", ContentPageUtility.CalculateMetaKeys(linkDescription));
			cmd.Parameters.Add("@topicID", topicID);

			conPortal.Open();
			cmd.ExecuteNonQuery();
			
            // Edit Search Keys
            SearchUtility.EditSearchKeys(conPortal, sectionID, contentPageID, linkTitle, linkDescription);
			
			
			conPortal.Close();
		}


        //*********************************************************************
        //
        // GetLinks Method
        //
        // Retrieves all links for a particular section. 
        //
        //*********************************************************************

		public static ArrayList GetLinks(string username,int sectionID, int pageSize, int pageIndex, string sortOrder) {
		    ArrayList colLinks = new ArrayList();
		    
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_LinksGetLinks", 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())
			  colLinks.Add(new LinkInfo(dr));
			conPortal.Close();
			
			return colLinks;
		}

        //*********************************************************************
        //
        // GetLink Method
        //
        // Retrieves a particular link from the database. 
        //
        //*********************************************************************

		public static ContentInfo GetLink(string username, int contentPageID) {
		    LinkInfo _linkInfo = null;
		    
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_LinksGetLink", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

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


        //*********************************************************************
        //
        // GetLinkUrl Method
        //
        // Retrieves a particular link URL from the database and
        // records that the link has been visited. 
        //
        //*********************************************************************
		
		public static string GetLinkUrl(int contentPageID) {

			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_LinksGetLinkUrl", conPortal);
			cmd.CommandType = CommandType.StoredProcedure;

			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@contentPageID", contentPageID);
            
			conPortal.Open();
            string result = (string)cmd.ExecuteScalar();
			conPortal.Close();
			
			return result;
		}



		
	}
}