adminutility.cs

一个ASP.NET下的中文内容管理和社区系统

        // *********************************************************************
        //  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)
        {
            SqlConnection conPortal = new SqlConnection( CommunityGlobals.ConnectionString );
            SqlCommand cmd = new SqlCommand( "Community_AdminRefreshService", conPortal );
            cmd.CommandType = CommandType.StoredProcedure;
            
            cmd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmd.Parameters.Add("@name", name);
            
            conPortal.Open();
            cmd.ExecuteNonQuery();
            conPortal.Close();
        }



        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") );
        }


    }
}