bookutility.cs

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

namespace ASPNET.StarterKit.Communities.Books {

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


    //*********************************************************************
    //
    // BookUtility Class
    //
    // Contains static utility methods used by the Books section. 
    //
    //*********************************************************************

	public class BookUtility {
    

        //*********************************************************************
        //
        // AddBook Method
        //
        // Adds a new book to the database. 
        //
        //*********************************************************************

		public static int AddBook
		(
		  string username, 
		  int sectionID,
		  int moderationStatus, 
		  string bookTitle, 
		  string bookBriefDescription, 
		  string bookFullDescription, 
		  string bookAuthor, 
		  string bookISBN, 
		  string bookPurchaseLink, 
		  decimal bookPrice,
		  DateTime bookPublicationDate,
		  string bookPublisher,
		  string bookPublisherLink,
		  int topicID
		){
			// Update Database with new Book
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdAdd = new SqlCommand("Community_BooksAddBook", conPortal);
			cmdAdd.CommandType = CommandType.StoredProcedure;

            cmdAdd.Parameters.Add("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;			
			cmdAdd.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdAdd.Parameters.Add("@username", username);
			cmdAdd.Parameters.Add("@sectionID", sectionID);
			cmdAdd.Parameters.Add("@moderationStatus", moderationStatus);
			cmdAdd.Parameters.Add("@bookTitle", bookTitle);
			cmdAdd.Parameters.Add("@bookBriefDescription", bookBriefDescription);
			cmdAdd.Parameters.Add("@bookFullDescription", SqlDbType.NText);
			cmdAdd.Parameters[ "@bookFullDescription" ].Value = bookFullDescription;
			
			cmdAdd.Parameters.Add("@bookAuthor", bookAuthor);
			cmdAdd.Parameters.Add("@bookPrice", bookPrice);
			cmdAdd.Parameters.Add("@bookISBN", bookISBN);
			cmdAdd.Parameters.Add("@bookPurchaseLink", bookPurchaseLink);
			cmdAdd.Parameters.Add("@bookPublicationDate", bookPublicationDate);
			cmdAdd.Parameters.Add("@bookPublisher", bookPublisher);
			cmdAdd.Parameters.Add("@bookPublisherLink", bookPublisherLink);
			cmdAdd.Parameters.Add("@bookMetaDescription", ContentPageUtility.CalculateMetaDescription(bookBriefDescription));
			cmdAdd.Parameters.Add("@bookMetaKeys", ContentPageUtility.CalculateMetaKeys(bookBriefDescription));
			cmdAdd.Parameters.Add("@topicID", topicID);

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


            // Add Search Keys
            SearchUtility.AddSearchKeys(conPortal, sectionID, result, bookTitle, bookBriefDescription);


			conPortal.Close();
			
			return result;
 	    }


        //*********************************************************************
        //
        // EditBook Method
        //
        // Edits an existing book in the database. 
        //
        //*********************************************************************

		public static void EditBook
		(
		  string username,
		  int sectionID, 
		  int contentPageID, 
		  string bookTitle, 
		  string bookBriefDescription, 
		  string bookFullDescription, 
		  string bookAuthor, 
		  string bookISBN, 
		  string bookPurchaseLink, 
		  decimal bookPrice,
		  DateTime bookPublicationDate,
		  string bookPublisher,
		  string bookPublisherLink,
		  int topicID 
		) {
			// Update Book information in database
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdEdit = new SqlCommand("Community_BooksEditBook", conPortal);
			cmdEdit.CommandType = CommandType.StoredProcedure;
			
			cmdEdit.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdEdit.Parameters.Add("@username", username);
			cmdEdit.Parameters.Add("@contentPageID", contentPageID);
			cmdEdit.Parameters.Add("@bookTitle", bookTitle);
			cmdEdit.Parameters.Add("@bookBriefDescription", bookBriefDescription);
			cmdEdit.Parameters.Add("@bookFullDescription", SqlDbType.NText);
			cmdEdit.Parameters[ "@bookFullDescription" ].Value = bookFullDescription;
			cmdEdit.Parameters.Add("@bookAuthor", bookAuthor);
			cmdEdit.Parameters.Add("@bookPrice", bookPrice);
			cmdEdit.Parameters.Add("@bookISBN", bookISBN);
			cmdEdit.Parameters.Add("@bookPurchaseLink", bookPurchaseLink);
			cmdEdit.Parameters.Add("@bookPublicationDate", bookPublicationDate);
			cmdEdit.Parameters.Add("@bookPublisher", bookPublisher);
			cmdEdit.Parameters.Add("@bookPublisherLink", bookPublisherLink);
			cmdEdit.Parameters.Add("@bookMetaDescription", ContentPageUtility.CalculateMetaDescription(bookBriefDescription));
			cmdEdit.Parameters.Add("@bookMetaKeys", ContentPageUtility.CalculateMetaKeys(bookBriefDescription));
			cmdEdit.Parameters.Add("@topicID", topicID );

			conPortal.Open();
			cmdEdit.ExecuteNonQuery();
			
            // Edit Search Keys
            SearchUtility.EditSearchKeys(conPortal, sectionID, contentPageID, bookTitle, bookBriefDescription);
			
			conPortal.Close();
 	    }


        //*********************************************************************
        //
        // GetBooks Method
        //
        // Retrieves a list of books from the database. 
        //
        //*********************************************************************

		public static ArrayList GetBooks(string username, int sectionID, int pageSize,int pageIndex, string sortOrder) {
            ArrayList colBooks = new ArrayList();

			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdGet = new SqlCommand( "Community_BooksGetBooks", conPortal);
			cmdGet.CommandType = CommandType.StoredProcedure;
			cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdGet.Parameters.Add("@username", username);
			cmdGet.Parameters.Add("@sectionID", sectionID);
			cmdGet.Parameters.Add("@sortOrder", sortOrder);
			cmdGet.Parameters.Add("@pageSize", pageSize);
			cmdGet.Parameters.Add("@pageIndex", pageIndex);
			
			conPortal.Open();
			SqlDataReader dr = cmdGet.ExecuteReader();
			while (dr.Read())
			 colBooks.Add(new BookInfo(dr));
			conPortal.Close();
			
			return colBooks;
		}


        //*********************************************************************
        //
        // GetBookInfo Method
        //
        // Gets a particular book from the database. 
        //
        //*********************************************************************

		public static ContentInfo GetBookInfo(string username, int contentPageID)
		{
            BookInfo objBookInfo = null;
			SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
			SqlCommand cmdGet = new SqlCommand( "Community_BooksGetBook", conPortal);

			// Add Parameters
			cmdGet.CommandType = CommandType.StoredProcedure;
			cmdGet.Parameters.Add("@communityID", CommunityGlobals.CommunityID);
			cmdGet.Parameters.Add("@username", username);
			cmdGet.Parameters.Add("@contentPageID", contentPageID);

			conPortal.Open();
			SqlDataReader dr = cmdGet.ExecuteReader();
            if (dr.Read())
                objBookInfo = new BookInfo(dr);
			conPortal.Close();
			return objBookInfo;
		}


        
        
	}
}