ratingutility.cs

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

namespace ASPNET.StarterKit.Communities {

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


    //*********************************************************************
    //
    // RatingUtility Class
    //
    // Contains static methods for rating community content.
    //
    //*********************************************************************

    public class RatingUtility {



        //*********************************************************************
        //
        // AddRating Method
        //
        // Adds a new rating to a content item to the database.
        //
        //*********************************************************************

        public static int AddRating(string username, int contentPageID, int rating) {
            // Initialize SPROC
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdAdd = new SqlCommand("Community_RatingsAddRating", conPortal);
            cmdAdd.CommandType = CommandType.StoredProcedure;
            
            // Add Parameters
            cmdAdd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
            cmdAdd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
            cmdAdd.Parameters.Add("@username", username);
            cmdAdd.Parameters.Add("@contentPageID", contentPageID);
            cmdAdd.Parameters.Add("@rating", rating);    
            
            // Execute
            conPortal.Open();
            cmdAdd.ExecuteNonQuery();
            int result = (int)cmdAdd.Parameters["@RETURN_VALUE"].Value;
            conPortal.Close();
            
            return result;
        }


        //*********************************************************************
        //
        // RatingUtility Constructor
        //
        // Private constructor for class with static methods.
        //
        //*********************************************************************

        private RatingUtility() {}

    }
}