adminutility.cs

C#邮件代码库,用于邮件发送

			cmdEdit.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdEdit.Parameters.Add("@messageName", messageName);
			cmdEdit.Parameters.Add("@messageTitle", messageTitle);
			cmdEdit.Parameters.Add("@messageBody", messageBody);
            
			conPortal.Open();
			cmdEdit.ExecuteNonQuery();
			conPortal.Close();
		}


		// *********************************************************************
		//  Edit Service Methods
		// *********************************************************************

		public static void DeleteService(string name)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminDeleteService", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@name", name);
            
			conPortal.Open();
			cmd.ExecuteNonQuery();
			conPortal.Close();
		}

		public static void RefreshService(string name)
		{
			ServiceUtility.UpdateServiceRefreshDate(name,System.DateTime.Parse("1/1/1966"));
		}



		public static int AddService(ServiceInfo service)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminAddService", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@name", service.Name);
			cmd.Parameters.Add("@url", service.Url);
			cmd.Parameters.Add("@type", service.Type);
			cmd.Parameters.Add("@refreshRate", service.RefreshRate);
			cmd.Parameters.Add("@maximumItems", service.MaximumItems);
			cmd.Parameters.Add("@password", service.Password);
            
			conPortal.Open();
			cmd.ExecuteNonQuery();
			int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
			conPortal.Close();
            
			return result;
		}

		public static int EditService(ServiceInfo service)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminEditService", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@id", service.ID);
			cmd.Parameters.Add("@name", service.Name);
			cmd.Parameters.Add("@url", service.Url);
			cmd.Parameters.Add("@type", service.Type);
			cmd.Parameters.Add("@refreshRate", service.RefreshRate);
			cmd.Parameters.Add("@maximumItems", service.MaximumItems);
			cmd.Parameters.Add("@password", service.Password);
            
			conPortal.Open();
			cmd.ExecuteNonQuery();
			int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
			conPortal.Close();
            
			return result;
		}


		// *********************************************************************
		//  Edit Service Subscriptions Methods
		// *********************************************************************

		public static int AddServiceSubscription(ServiceSubscriptionInfo service) 
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminAddServiceSubscription", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@name", service.Name);
			cmd.Parameters.Add("@url", service.Url);
			cmd.Parameters.Add("@password", service.Password);
            
			conPortal.Open();
			cmd.ExecuteNonQuery();
			int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
			conPortal.Close();
            
			return result;
		}


		public static int EditServiceSubscription(ServiceSubscriptionInfo service) 
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminEditServiceSubscription", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@id", service.ID);
			cmd.Parameters.Add("@name", service.Name);
			cmd.Parameters.Add("@url", service.Url);
			cmd.Parameters.Add("@password", service.Password);
            
			conPortal.Open();
			cmd.ExecuteNonQuery();
			int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
			conPortal.Close();
            
			return result;
		}


		public static void DeleteServiceSubscription(string subscriptionName)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminDeleteServiceSubscription", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@subscriptionName", subscriptionName);
            
			conPortal.Open();
			cmd.ExecuteNonQuery();
			conPortal.Close();
		}

		public static void RefreshServiceSubscription(string subscriptionName)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminRefreshServiceSubscription", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@subscriptionName", subscriptionName);
            
			conPortal.Open();
			cmd.ExecuteNonQuery();
			conPortal.Close();
		}


		// *********************************************************************
		//  Newsletter Methods
		// *********************************************************************

		public static int AddNewsletterTemplate
			(
			string templateName,
			string newsletterSubject,
			string newsletterBody,
			int newsletterBodyFormat
			)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminAddNewsletterTemplate", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@templateName", templateName);
			cmd.Parameters.Add("@newsletterSubject", newsletterSubject);
			cmd.Parameters.Add("@newsletterBody", newsletterBody);
			cmd.Parameters.Add("@newsletterBodyFormat", newsletterBodyFormat);
        
			conPortal.Open();
			cmd.ExecuteNonQuery();
			int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
			conPortal.Close();        
        
			return result;
		}

		public static void EditNewsletterTemplate
			(
			int templateID,
			string templateName,
			string newsletterSubject,
			string newsletterBody,
			int newsletterBodyFormat
			)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminEditNewsletterTemplate", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@templateID", templateID);
			cmd.Parameters.Add("@templateName", templateName);
			cmd.Parameters.Add("@newsletterSubject", newsletterSubject);
			cmd.Parameters.Add("@newsletterBody", newsletterBody);
			cmd.Parameters.Add("@newsletterBodyFormat", newsletterBodyFormat);
        
			conPortal.Open();
			cmd.ExecuteNonQuery();
			conPortal.Close();        
		}


		public static void DeleteTemplate
			(
			int templateID
			)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminDeleteNewsletterTemplate", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@templateID", templateID);

			conPortal.Open();
			cmd.ExecuteNonQuery();
			conPortal.Close();        
		}



		public static SqlDataReader GetNewsletterTemplateNames()
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmdGet = new SqlCommand( "Community_AdminGetNewsletterTemplateNames", conPortal );
			cmdGet.CommandType = CommandType.StoredProcedure;

			cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            
			conPortal.Open();
			SqlDataReader dr = cmdGet.ExecuteReader(CommandBehavior.CloseConnection);
			return dr;
		}


		public static DataSet GetNewsletterSubjects()
		{
			SqlDataAdapter dadGet = new SqlDataAdapter( "Community_AdminGetNewsletterSubjects", CommunityGlobals.ConnectionString );
			dadGet.SelectCommand.CommandType = CommandType.StoredProcedure;
			dadGet.SelectCommand.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            
			DataSet dstNewsletters = new DataSet();
			dadGet.Fill(dstNewsletters);
            
			return dstNewsletters;
		}



		public static SqlDataReader GetNewsletterTemplate(int templateID)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmdGet = new SqlCommand( "Community_AdminGetNewsletterTemplate", conPortal );
			cmdGet.CommandType = CommandType.StoredProcedure;

			cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdGet.Parameters.Add("@templateID", templateID);
            
			conPortal.Open();
			SqlDataReader dr = cmdGet.ExecuteReader(CommandBehavior.CloseConnection);
			return dr;
		}

		public static int AddNewsletter
			(
			string newsletterSubject,
			string newsletterBody,
			int newsletterBodyFormat
			)
		{
			SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
			SqlCommand cmd = new SqlCommand( "Community_AdminAddNewsletter", conPortal );
			cmd.CommandType = CommandType.StoredProcedure;
            
			cmd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
			cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add("@newsletterSubject", newsletterSubject);
			cmd.Parameters.Add("@newsletterBody", newsletterBody);
			cmd.Parameters.Add("@newsletterBodyFormat", newsletterBodyFormat);
        
			conPortal.Open();
			cmd.ExecuteNonQuery();
			int result = (int)cmd.Parameters["@RETURN_VALUE"].Value;
			conPortal.Close();        
        
			return result;
		}



		// *********************************************************************
		//  Delete Community Content
		// *********************************************************************

		public static void DeleteCommunityContent(string username, bool deleteContent, bool deleteSections, bool deleteUsers) 
		{
			SqlConnection con = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmd = new SqlCommand("Community_AdminDeleteContent", con);
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.Parameters.Add( "@communityID", CommunityGlobals.CommunityID);
			cmd.Parameters.Add( "@username", username);
			cmd.Parameters.Add( "@content", deleteContent);
			cmd.Parameters.Add( "@sections", deleteSections);
			cmd.Parameters.Add( "@users", deleteUsers);
            
			con.Open(); 
			cmd.ExecuteNonQuery();
			con.Close();

			// Remove Sections from Cache
			if (deleteSections)
				HttpContext.Current.Cache.Remove( CommunityGlobals.CacheKey("Sections") );
		}
    }
}