using System;
using System.Data;
using System.Data.SqlClient;
 
namespace infoWeb.WebModules.Forums.Business
{
	/// <summary>
	/// Summary description for Category.
	/// </summary>
	public sealed class Category :  infoWeb.WebModules.Business.BizObject
	{	
		private Configuration.ModuleSettings settings;
		private int categoryID;
		private string name;
		private string imageUrl;
		private int position;
		
		// constructors
		public Category()
		{ 
			settings = Configuration.ModuleConfig.GetSettings();
			ResetProperties();
		}

		public Category(int existingCategoryID)
		{			
			settings = Configuration.ModuleConfig.GetSettings();
			categoryID = existingCategoryID;
			LoadFromID();						
		}

		public Category(Category existingCategory)
		{									
			settings = Configuration.ModuleConfig.GetSettings();
			categoryID = existingCategory.ID;
			LoadFromID();
		}
		
		// retrieve the values for the properties
		private void LoadFromID()
		{
			Data.Categories categories = new Data.Categories(settings.ConnectionString);
			Data.CategoryDetails details = categories.GetDetails(categoryID);

			categoryID = details.CategoryID;
			name = details.Name;
			imageUrl = details.ImageUrl;
			position = details.Position;
		}

		public int LoadFromID(int existingCategoryID)
		{
			categoryID = existingCategoryID;
			LoadFromID();
			return categoryID;
		}

		// reset the properties
		private void ResetProperties()
		{
			categoryID = -1;
			name = "";
			imageUrl = "";
			position = 0;
		}

		// create a new record
		public int Create(string categoryName, string categoryImageUrl, int categoryPosition)
		{		
			Data.Categories categories = new Data.Categories(settings.ConnectionString);
			categoryID = categories.Add(categoryName, categoryImageUrl, categoryPosition);
			LoadFromID();
			return categoryID;
		}

		// update the record represented by this object
		public bool Update()
		{
			Data.Categories categories = new Data.Categories(settings.ConnectionString);
			return categories.Update(categoryID, name, imageUrl, position);
		}

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

		// return the categories
		public static DataSet GetCategories()
		{
			Configuration.ModuleSettings settings = Configuration.ModuleConfig.GetSettings();
			Data.Categories categories = new Data.Categories(settings.ConnectionString);
			return categories.GetCategories();
		}
		
		// return the child forums
		public DataSet GetForums()
		{
			Data.Forums forums = new Data.Forums(settings.ConnectionString);
			return forums.GetForums(categoryID);
		}

		// add a new child forum
		public Forum AddForum(string forumName, string forumDescription, int forumPosition)
		{
			Business.Forum forum = new Business.Forum();
			forum.Create(categoryID, forumName, forumDescription, forumPosition);
			return forum;
		}


		// PROPERTIES DEFINED BELOW

		public int ID
		{
			get { return categoryID; }
		}

    public string Name
		{
			get { return name; }
			set { name = value; }
		}

		public string ImageUrl
		{
			get { return imageUrl; }
			set { imageUrl = value; }
		}

		public int Position
		{
			get { return position; }
			set { position = value; }
		}

	}
}