news.cs

wrox c#高级编程

using System;
using System.Data;
using System.Data.SqlClient;
 
namespace Wrox.WebModules.NewsManager.Business
{
	/// <summary>
	/// Summary description for News.
	/// </summary>
	public sealed class News : Wrox.WebModules.Business.BizObject
	{	
		private Configuration.ModuleSettings settings;
		private int newsID;
		private int categoryID;
		private string title;
		private string body;
		private DateTime releaseDate;
		private DateTime expireDate;
		private DateTime addedDate;
		private bool approved;
		private int userID;
		private string userName;
		private string userEmail;

		// constructors		
		public News()
		{ 
			settings = Configuration.ModuleConfig.GetSettings();
			ResetProperties();
		}

		public News(int existingNewsID)
		{			
			settings = Configuration.ModuleConfig.GetSettings();
			newsID = existingNewsID;
			LoadFromID();						
		}

		public News(News existingNews)
		{									
			settings = Configuration.ModuleConfig.GetSettings();
			newsID = existingNews.ID;
			LoadFromID();
		}
		
		// retrieve the values for the properties
		private void LoadFromID()
		{
			Data.News news = new Data.News(settings.ConnectionString);
			Data.NewsDetails details = news.GetDetails(newsID);

			newsID = details.NewsID;
			categoryID = details.CategoryID;
			title = details.Title;
			body = details.Body;
			releaseDate = details.ReleaseDate;
			expireDate = details.ExpireDate;
			addedDate = details.AddedDate;
			approved = details.Approved;
			userID = details.UserID;
			userName = details.UserName;
			userEmail = details.UserEmail;
		}

		public int LoadFromID(int existingNewsID)
		{
			newsID = existingNewsID;
			LoadFromID();
			return newsID;
		}

		// reset the properties
		private void ResetProperties()
		{
			newsID = -1;
			categoryID = -1;
			title = "";
			body = "";
			releaseDate = new DateTime();
			expireDate = new DateTime();
			addedDate = new DateTime();
			approved = false;
			userID = -1;
			userName = "";
			userEmail = "";
		}

		// create a new record
		public int Create(int newsCategoryID, string newsTitle, string newsBody, 
			DateTime newsReleaseDate, DateTime newsExpireDate, bool newsApproved, int newsUserID)
		{		
			Data.News news = new Data.News(settings.ConnectionString);
			newsID = news.Add(newsCategoryID, newsTitle, newsBody, 
				newsReleaseDate, newsExpireDate, newsApproved, newsUserID);
			LoadFromID();
			return newsID;
		}

		// update the record represented by this object
		public bool Update()
		{
			Data.News news = new Data.News(settings.ConnectionString);
			return news.Update(newsID, title, body, releaseDate, expireDate, approved);
		}

		// delete the record represented by this object
		public bool Delete()
		{
			Data.News news = new Data.News(settings.ConnectionString);
			bool ret = news.Delete(newsID);
			ResetProperties();
			return ret;
		}

		// PROPERTIES DEFINED BELOW

		public int CategoryID
		{
			get { return categoryID; }
		}

		public Business.Category Category
		{
			get { return new Category(categoryID); }
		}

		public int ID
		{
			get { return newsID; }
		}

		public string Title
		{
			get { return title; }
			set { title = value; }
		}

		public string Body
		{
			get { return body; }
			set { body = value; }
		}

		public bool Approved
		{
			get { return approved; }
			set { approved = value; }
		}

		public DateTime ReleaseDate
		{
			get { return releaseDate; }
			set { releaseDate = value; }
		}

		public DateTime ExpireDate
		{
			get { return expireDate; }
			set { expireDate = value; }
		}

		public DateTime AddedDate
		{
			get { return addedDate; }
		}

		public int UserID
		{
			get { return userID; }
		}

		public string UserName
		{
			get { return userName; }
		}

		public string UserEmail
		{
			get { return userEmail; }
		}
	}
}