using System;
using System.Data.SqlClient;
using System.Web;
using System.Web.Security;
using alcvt.Data;

namespace alcvt.Data.Components
{

	/// <summary>
	/// This object represents the properties and methods of a tmp_useredit.
	/// </summary>
	public class UserEdit
	{
	
		#region private properties
	
		protected int _uid;
		protected int _fid;
		protected string _last_name = String.Empty;
		protected string _first_name = String.Empty;
		protected bool _member_bit;
		protected bool _official_bit;
		protected bool _active;
		protected int _cid;
		protected int _ustid;
		protected string _work_phone = String.Empty;
		protected string _ext = String.Empty;
		protected bool _gender_bit;
		protected DateTime _birth_date;
		protected int _schid;
		protected int _fmstid;
		protected bool _student_bit;
		protected string _suffix_name = String.Empty;
		protected string _email_addr = String.Empty;
		protected string _familiar_name = String.Empty;
		protected string _jobtitle = String.Empty;
		protected string _u_interests = String.Empty;
		protected string _u_history = String.Empty;
		protected string _mobile_phone = String.Empty;
		protected DateTime _entered_date;
		protected int _entered_by_id;
		protected string _username = String.Empty;
		protected string _password = String.Empty;
		protected string _picname = String.Empty;
		protected string _picpath = String.Empty;
		protected DateTime _picdate;
	
		#endregion
		
		#region Constructors and LoadFromReader
		
		public UserEdit()
		{
		}
		
		public UserEdit(int uid)
		{
			SqlDataReader reader = SQLHelper.ExecuteReader("SELECT * FROM v_user_edit WHERE uid = " + uid);
			
			if (reader.Read()) 
			{
				this.LoadFromReader(reader);
				reader.Close();
			}
			else
			{
				if (!reader.IsClosed) reader.Close();
				throw new ApplicationException("tmp_useredit does not exist.");
			}
		}
		

		protected void LoadFromReader(SqlDataReader reader)
		{
			if (reader != null && !reader.IsClosed)
			{
				_uid = reader.GetInt32(0);
				if (!reader.IsDBNull(1)) _fid = reader.GetInt32(1);
				if (!reader.IsDBNull(2)) _last_name = reader.GetString(2);
				if (!reader.IsDBNull(3)) _first_name = reader.GetString(3);
				if (!reader.IsDBNull(4)) _member_bit = reader.GetBoolean(4);
				if (!reader.IsDBNull(5)) _official_bit = reader.GetBoolean(5);
				if (!reader.IsDBNull(6)) _active = reader.GetBoolean(6);
				if (!reader.IsDBNull(7)) _cid = reader.GetInt32(7);
				if (!reader.IsDBNull(8)) _ustid = reader.GetInt32(8);
				if (!reader.IsDBNull(9)) _work_phone = reader.GetString(9);
				if (!reader.IsDBNull(10)) _ext = reader.GetString(10);
				if (!reader.IsDBNull(11)) _gender_bit = reader.GetBoolean(11);
				if (!reader.IsDBNull(12)) _birth_date = reader.GetDateTime(12);
				if (!reader.IsDBNull(13)) _schid = reader.GetInt32(13);
				if (!reader.IsDBNull(14)) _fmstid = reader.GetInt32(14);
				if (!reader.IsDBNull(15)) _student_bit = reader.GetBoolean(15);
				if (!reader.IsDBNull(16)) _suffix_name = reader.GetString(16);
				if (!reader.IsDBNull(17)) _email_addr = reader.GetString(17);
				if (!reader.IsDBNull(18)) _familiar_name = reader.GetString(18);
				if (!reader.IsDBNull(19)) _jobtitle = reader.GetString(19);
				if (!reader.IsDBNull(20)) _u_interests = reader.GetString(20);
				if (!reader.IsDBNull(21)) _u_history = reader.GetString(21);
				if (!reader.IsDBNull(22)) _mobile_phone = reader.GetString(22);
				if (!reader.IsDBNull(23)) _entered_date = reader.GetDateTime(23);
				if (!reader.IsDBNull(24)) _entered_by_id = reader.GetInt32(24);
				if (!reader.IsDBNull(25)) _username = reader.GetString(25);
				if (!reader.IsDBNull(26)) _password = reader.GetString(26);
				if (!reader.IsDBNull(27)) _picname = reader.GetString(27);
				if (!reader.IsDBNull(28)) _picpath = reader.GetString(28);
				if (!reader.IsDBNull(29)) _picdate = reader.GetDateTime(29);
			}
		}

		#endregion
		
		#region Public Properties
		public int uid
		{
			get {return _uid;}
			set {_uid = value;}
		}
		
		public int fid
		{
			get {return _fid;}
			set {_fid = value;}
		}

		public string last_name
		{
			get {return _last_name;}
			set {_last_name = value;}
		}

		public string first_name
		{
			get {return _first_name;}
			set {_first_name = value;}
		}

		public bool member_bit
		{
			get {return _member_bit;}
			set {_member_bit = value;}
		}

		public bool official_bit
		{
			get {return _official_bit;}
			set {_official_bit = value;}
		}

		public bool active
		{
			get {return _active;}
			set {_active = value;}
		}

		public int cid
		{
			get {return _cid;}
			set {_cid = value;}
		}

		public int ustid
		{
			get {return _ustid;}
			set {_ustid = value;}
		}

		public string work_phone
		{
			get {return _work_phone;}
			set {_work_phone = value;}
		}

		public string ext
		{
			get {return _ext;}
			set {_ext = value;}
		}

		public bool gender_bit
		{
			get {return _gender_bit;}
			set {_gender_bit = value;}
		}

		public DateTime birth_date
		{
			get {return _birth_date;}
			set {_birth_date = value;}
		}

		public int schid
		{
			get {return _schid;}
			set {_schid = value;}
		}

		public int fmstid
		{
			get {return _fmstid;}
			set {_fmstid = value;}
		}

		public bool student_bit
		{
			get {return _student_bit;}
			set {_student_bit = value;}
		}

		public string suffix_name
		{
			get {return _suffix_name;}
			set {_suffix_name = value;}
		}

		public string email_addr
		{
			get {return _email_addr;}
			set {_email_addr = value;}
		}

		public string familiar_name
		{
			get {return _familiar_name;}
			set {_familiar_name = value;}
		}

		public string jobtitle
		{
			get {return _jobtitle;}
			set {_jobtitle = value;}
		}

		public string u_interests
		{
			get {return _u_interests;}
			set {_u_interests = value;}
		}

		public string u_history
		{
			get {return _u_history;}
			set {_u_history = value;}
		}

		public string mobile_phone
		{
			get {return _mobile_phone;}
			set {_mobile_phone = value;}
		}

		public DateTime entered_date
		{
			get {return _entered_date;}
			set {_entered_date = value;}
		}

		public int entered_by_id
		{
			get {return _entered_by_id;}
			set {_entered_by_id = value;}
		}

		public string username
		{
			get {return _username;}
			set {_username = value;}
		}

		public string password
		{
			get {return _password;}
			set {_password = value;}
		}

		public string picname
		{
			get {return _picname;}
			set {_picname = value;}
		}

		public string picpath
		{
			get {return _picpath;}
			set {_picpath = value;}
		}

		public DateTime picdate
		{
			get {return _picdate;}
			set {_picdate = value;}
		}
		#endregion
		
		public static UserEdit Instance(int uid)
		{
			UserEdit useredit = new UserEdit(uid);
			return useredit;
		}
	}

}