using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace PMS.DesktopModules.TransferMng
{
	/// <summary>
	/// AddTransfer 的摘要說明。
	/// </summary>
	public partial class AddTransfer : System.Web.UI.Page
	{
	
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此處放置用戶代碼以初始化頁面
			///判斷用戶是否登陸
			if(Session["UserID"] == null)
			{
				Response.Redirect("~/Default.aspx");
			}
			///判斷用戶是否是超級管理員或普通管理員
			if(Components.User.IsAuthority(Session["UserID"].ToString()) != Components.User.USERTYPESUPERADMIN && Components.User.IsAuthority(Session["UserID"].ToString()) != Components.User.USERTYPEADMIN)
			{
				Response.Write("<script>alert(\"你沒有權限，請與管理員聯系！\")</script>");
				Response.Write("<script>history.back();</script>");
			}
			else
			{
				if(!Page.IsPostBack)
				{
					BindEmployeeList();
					BindDepartmentList();
					if(EmployeeList.Items.Count > 0)
					{
						EmployeeList.SelectedIndex = 0;
						EmployeeID.Text = EmployeeList.SelectedItem.Text.Trim();
						PMS.Components.Employee Employee = new PMS.Components.Employee();
						DataTable DT = Employee.GetEmployee();
						OldDepart.Text = GetOldDepartmentName(EmployeeID.Text.Trim());
					}
				}
			}
			
					
		}

		private void BindEmployeeList()
		{
			///定義獲取數據的類
			PMS.Components.Employee Employee = new PMS.Components.Employee();
			DataTable DT = Employee.GetEmployee();

			///設定控件的數據源
			EmployeeList.DataSource = DT;
			
			///設定控件的Text屬性和Value屬性
			EmployeeList.DataTextField = "EmployeeID";
			EmployeeList.DataValueField = "EmployeeID";

			///綁定控件的數據
			EmployeeList.DataBind();

		}
		private void BindDepartmentList()
		{
			///定義獲取數據的類
			PMS.Components.Department Department = new PMS.Components.Department();
			DataTable DT = Department.GetDepartment();

			///設定控件的數據源
			DepartmentList.DataSource = DT;
			
			///設定控件的Text屬性和Value屬性
			DepartmentList.DataTextField = "DepartName";
			DepartmentList.DataValueField = "DepartID";

			///綁定控件的數據
			DepartmentList.DataBind();

		}
		private string GetOldDepartmentID(string EmployeeID)
		{
			PMS.Components.Employee Employee = new PMS.Components.Employee();
			DataTable DT1 = Employee.GetEmployee(EmployeeID);
			string OldDepartID = DT1.Rows[0]["DepartID"].ToString();
			return OldDepartID;
		}
		private string GetOldDepartmentName(string EmployeeID)
		{
			string OldDepartID = GetOldDepartmentID(EmployeeID);
			PMS.Components.Department Department = new PMS.Components.Department();
			DataTable DT2 = Department.GetDepartment(OldDepartID);
			string OldDepartName = DT2.Rows[0]["DepartName"].ToString();
			return OldDepartName;
		}


		#region Web 窗體設計器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void ReturnBtn_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("TransferMng.aspx");
		}

		protected void AddBtn_Click(object sender, System.EventArgs e)
		{
			if(Page.IsValid == true)
			{
				///定義類
				PMS.Components.Transfer Transfer = new PMS.Components.Transfer();
				string OldDepartID = GetOldDepartmentID(EmployeeID.Text.Trim());
				try
				{
					///添加操作
					string str = "insert into [Transfer]([Position],OldDepart,NewDepart,Pubdate,Reason,EmployeeID,Remark ) values('"+NewPosition.Text.Trim()
					+ "','" + OldDepartID + "','" + DepartmentList.SelectedValue.Trim() + "','" + Convert.ToDateTime(PubDate.Text.Trim())
					+ "','" + Reason.Text.Trim() + "','" + EmployeeList.SelectedValue.Trim() + "','" + Remark.Text.Trim() +"' )";
					
					if(Transfer.AddTransfer(str))
					{
						///顯示操作結果信息
						Response.Write ("<script>window.alert('" + "添加數據子項成功！！！" + "')</script>");
						Response.Redirect("TransferMng.aspx",false);   
					}
					
					
				}
				catch(Exception ex)
				{			
					///顯示添加操作中的失敗、錯誤信息
					PMS.Common.SystemError.SystemLog(ex.Message) ;
					Response.Redirect(ex.Message) ;
				}
			}
		}

		

		protected void EmployeeList_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(EmployeeList.SelectedIndex > -1)
			{
				EmployeeID.Text = EmployeeList.SelectedItem.Text.Trim();
				OldDepart.Text = GetOldDepartmentName(EmployeeID.Text.Trim());

			}
			else
			{
				///顯示操作結果信息
				Response.Write ("<script>window.alert('" + "請選擇操作的數據子項！！！" + "')</script>");
			}		
		}
	}
}