moderationutility.cs

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

namespace ASPNET.StarterKit.Communities.Moderation {

    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Collections;


    //*********************************************************************
    //
    // ModerationUtility Class
    //
    // Contains static utility methods for moderating content. 
    //
    //*********************************************************************

    public class ModerationUtility {



        //*********************************************************************
        //
        // GetTotalRecords Method
        //
        // Gets count of items needing moderation. 
        //
        //*********************************************************************

        public static int GetTotalRecords(int sectionID) {
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdGetTotal = new SqlCommand("Community_ModerationGetTotalRecords", conPortal);
            cmdGetTotal.CommandType = CommandType.StoredProcedure;
            cmdGetTotal.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
            cmdGetTotal.Parameters.Add("@sectionID", sectionID);
            conPortal.Open();
            cmdGetTotal.ExecuteNonQuery();
            int totalRecords = (int)cmdGetTotal.Parameters["@RETURN_VALUE"].Value;                      
            conPortal.Close();
            return totalRecords;  
        }      


        //*********************************************************************
        //
        // GetContent Method
        //
        // Gets the content requiring moderation. 
        //
        //*********************************************************************
        
        public static ArrayList GetContent(string username, int sectionID, int pageSize, int pageIndex, string sortOrder) {
            ArrayList colContent = new ArrayList();
            
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdGet = new SqlCommand("Community_ModerationGetContent", conPortal);
            cmdGet.CommandType = CommandType.StoredProcedure;

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


        //*********************************************************************
        //
        // GetContent Method
        //
        // Returns a single content item. 
        //
        //*********************************************************************

        public static ContentInfo GetContentInfo(int contentPageID) {
            ContentInfo contentInfo = null;
            
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdGet = new SqlCommand("Community_ModerationGetContentInfo", conPortal);
            cmdGet.CommandType = CommandType.StoredProcedure;

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


        //*********************************************************************
        //
        // ApproveContent Method
        //
        // Approve content. 
        //
        //*********************************************************************

        public static void ApproveContent(string username, int contentPageID) {
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdUpdate = new SqlCommand("Community_ModerationApproveContent", conPortal);
            cmdUpdate.CommandType = CommandType.StoredProcedure;
            
            // Add Parameters
            cmdUpdate.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdUpdate.Parameters.Add("@contentPageID", contentPageID);
            cmdUpdate.Parameters.Add("@username", username);
            
            // Execute
            conPortal.Open();
            cmdUpdate.ExecuteNonQuery();
            conPortal.Close();
        }


        //*********************************************************************
        //
        // RejectContent Method
        //
        // Deletes content from database. 
        //
        //*********************************************************************

        public static void RejectContent(string username, int contentPageID) {
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdUpdate = new SqlCommand("Community_ModerationRejectContent", conPortal);
            cmdUpdate.CommandType = CommandType.StoredProcedure;
            
            // Add Parameters
            cmdUpdate.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdUpdate.Parameters.Add("@contentPageID", contentPageID);
            cmdUpdate.Parameters.Add("@username", username);
            
            // Execute
            conPortal.Open();
            cmdUpdate.ExecuteNonQuery();
            conPortal.Close();
        }


        //*********************************************************************
        //
        // ModerationUtility Constructor
        //
        // Private constructor for static class. 
        //
        //*********************************************************************

        private ModerationUtility() {}


    }
}