using System;
using System.Data;
using System.Data.SqlClient;
 
namespace infoWeb.WebModules.Forums.Business
{
	/// <summary>
	/// Summary description for Category.
	/// </summary>
	public sealed class Member : infoWeb.WebModules.Business.BizObject
	{	
		private Configuration.ModuleSettings settings;
		private int memberID;
		private int userID;
		private string name;
		private string email;
		private bool showEmail;
		private string signature;
		private string avatarUrl;
		private string homepage;
		private DateTime addedDate;
				
		// constructors
		public Member()
		{ 
			settings = Configuration.ModuleConfig.GetSettings();
			ResetProperties();
		}

		public Member(int existingMemberID)
		{			
			settings = Configuration.ModuleConfig.GetSettings();
			memberID = existingMemberID;
			LoadFromID();						
		}

		public Member(Member existingMember)
		{									
			settings = Configuration.ModuleConfig.GetSettings();
			memberID = existingMember.ID;
			LoadFromID();
		}
		
		// retrieve the values for the properties
		private void LoadFromID()
		{
			Data.Members members = new Data.Members(settings.ConnectionString);
			Data.MemberDetails details = members.GetDetails(memberID);

			memberID = details.MemberID;
			userID = details.UserID;
			name = details.Name;
			email = details.Email;
			showEmail = details.ShowEmail;
			signature = details.Signature;
			avatarUrl = details.AvatarUrl;
			homepage = details.Homepage;
			addedDate = details.AddedDate;
		}

		public int LoadFromID(int existingMemberID)
		{
			memberID = existingMemberID;
			LoadFromID();
			return memberID;
		}

		// load the member info from the specified userID
		public int LoadFromUser(int memberUserID)
		{
			Data.Members members = new Data.Members(settings.ConnectionString);
			memberID = members.GetMemberID(memberUserID);
			
			if (memberID == -1)
				ResetProperties();
			else
				LoadFromID();

			return memberID;
		}

		// reset the properties
		private void ResetProperties()
		{
			memberID = -1;
			userID = -1;
			name = "";
			email = "";
			showEmail = false;
			signature = "";
			avatarUrl = "";
			homepage = "";
			addedDate = new DateTime();
		}

		// create a new record
		public int Create(int memberUserID, string memberName, bool memberShowEmail, 
			string memberSignature, string memberAvatarUrl, string memberHomepage)
		{		
			Data.Members members = new Data.Members(settings.ConnectionString);
			memberID = members.Add(memberUserID, memberName, memberShowEmail, memberSignature,
				memberAvatarUrl, memberHomepage);
			LoadFromID();
			return memberID;
		}

		// update the record represented by this object
		public bool Update()
		{
			Data.Members members = new Data.Members(settings.ConnectionString);
			return members.Update(memberID, name, showEmail, signature, avatarUrl, homepage);
		}

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

		// return the members
		public static DataSet GetMembers()
		{
			Configuration.ModuleSettings settings = Configuration.ModuleConfig.GetSettings();
			Data.Members members = new Data.Members(settings.ConnectionString);
			return members.GetMembers();
		}

		// PROPERTIES DEFINED BELOW

		public int ID
		{
			get { return memberID; }
		}

		public int UserID
		{
			get { return userID; }
		}

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

		public string Email
		{
			get { return email; }
			set { email = value; }
		}

		public string Signature
		{
			get { return signature; }
			set { signature = value; }
		}

		public string AvatarUrl
		{
			get { return avatarUrl; }
			set { avatarUrl = value; }
		}

		public string Homepage
		{
			get { return homepage; }
			set { homepage = value; }
		}

		public bool ShowEmail
		{
			get { return showEmail; }
			set { showEmail = value; }
		}

		public DateTime AddedDate
		{
			get { return addedDate; }
		}

	}
}