using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.Security;
using StudentManager.IDAL;
using StudentManager.SQLServer;
using StudentManager.DALFactory;
using StudentManager.Common;
using StudentManager.Model;


namespace StudentManager.BLL
{
    /// <summary>
    /// 部門業務邏輯層務層
    /// 創建者:余洪
    /// 時間:2008-3
    /// </summary>
    public class Department
    {
        #region 使用反射工廠多態實例化部門接口
        /// <summary>
        /// 使用反射工廠多態實例化部門接口
        /// </summary>
        private IDepartment department = DataAccess.CreateDepartment();
        #endregion

        #region 驗證登陸
        /// <summary>
        /// 驗證登陸
        /// </summary>
        /// <param name="dp_Id">部門ID</param>
        /// <param name="dp_Pwd">密碼</param>
        public void ValidDepartMentLogin(string dp_Id, string dp_Pwd)
        {
            if (department.ValidLogin(dp_Id, dp_Pwd))
            {
                FormsAuthentication.SetAuthCookie(dp_Id, false);
                if (!Roles.IsUserInRole(dp_Id, "Department"))
                {
                    Roles.AddUserToRole(dp_Id, "Department");
                }
                HttpContext.Current.Session["role"] = "department";
                JScript.RedirectUrl(@"~/Department/Default.aspx");
            }
            else
            {
                JScript.Alert("用戶信息錯誤!請重新輸入!");
                JScript.GoHistory(-1);
            }
        }
        #endregion

        #region  部門(學院)修改密碼
        /// <summary>
        /// 部門修改密碼
        /// </summary>
        /// <param name="dp_Id">ID</param>
        /// <param name="dp_OldPwd">原密碼</param>
        /// <param name="dp_NewPwd">新密碼</param>
        /// <param name="dp_ReNewPwd">重復密碼</param>
        /// <param name="lblMessage">返回信息</param>
        public void ChangePwd(string dp_Id, string dp_OldPwd, string dp_NewPwd, string dp_ReNewPwd, Label lblMessage)
        {
            int returnMessage = department.ChangePwd(dp_Id, dp_OldPwd, dp_NewPwd, dp_ReNewPwd);
            switch (returnMessage)
            {
                case -1: lblMessage.Text = "兩次輸入的密碼不一致!";
                    break;
                case -2: lblMessage.Text = "密碼錯誤!";
                    break;
                case 1: lblMessage.Text = "密碼修改成功!";
                    break;
                case 0: lblMessage.Text = "密碼修改失敗,請重試!";
                    break;
            }

        }
        #endregion

        #region 添加部門信息(包括學生信息)
        /// <summary>
        /// 添加部門信息(包括學生信息)
        /// </summary>
        /// <param name="dept">部門信息</param>
        /// <returns></returns>
        public void AddDept(DepartmentInf dept)
        {
            int returnMessage = department.AddDept(dept);
            switch (returnMessage)
            {
                case -1: JScript.Alert("該學院編號存在");
                    JScript.GoHistory(-1);
                    break;
                case 1: JScript.AlertAndRedirect("添加成功!", "Default.aspx");
                    break;
                case 0: JScript.Alert("添加失敗,請重試!");
                    JScript.GoHistory(-1);
                    break;
            }
        }
        #endregion

        #region  添加專業信息
        /// <summary>
        /// 添加專業信息
        /// </summary>
        /// <param name="sp_Id">專業編號</param>
        /// <param name="dp_Id">所屬學院</param>
        /// <param name="sp_Name">專業名字</param>
        /// <param name="sp_Remark">專業備注</param>
        /// <param name="sp_Grade">專業所屬年級</param>
        /// <returns></returns>
        public void AddSpeciality(string sp_Id, string dp_Id, string sp_Name, string sp_Remark, string sp_Grade)
        {
            int returnMessage = department.AddSpeciality(sp_Id, dp_Id, sp_Name, sp_Remark, sp_Grade);
            switch (returnMessage)
            {
                case -1: JScript.Alert("學院不存在");
                    JScript.GoHistory(-1);
                    break;
                case 1: JScript.AlertAndRedirect("添加成功!", "AddSpeciality.aspx");
                    break;
                case 0: JScript.Alert("添加失敗,請重試!");
                    JScript.GoHistory(-1);
                    break;
                case -2: JScript.Alert("專業編號已存在,請換其他編號!");
                    JScript.GoHistory(-1);
                    break;
            }
        }
        #endregion

        #region 綁定學院信息到下拉列表框
        /// <summary>
        /// 綁定學院信息到下拉列表框
        /// </summary>
        /// <param name="ddlCollege"></param>
        public void BindCollegeForDll(DropDownList ddlCollege)
        {
            ddlCollege.DataSource = department.GetCollege();
            ddlCollege.DataTextField = "dp_name";
            ddlCollege.DataValueField = "dp_id";
            ddlCollege.DataBind();
        }
        #endregion

        #region 綁定所有學院信息到GridView
        /// <summary>
        /// 綁定所有學院信息到GridView
        /// </summary>
        /// <param name="gvColleges"></param>
        public void BindColleges(GridView gvColleges)
        {
            gvColleges.DataSource = department.GetCollegeList();
            gvColleges.DataBind();
        }
        #endregion

        #region 重置密碼
        public void ReSetPwd(string objectstr, string number, string newpwd, Label lblMessage)
        {
            int result=department.ResetPwd(objectstr, number, newpwd);
            switch (result)
            {
                case -1: lblMessage.Text = "重置密碼失敗!";
                    break;
                case -2: lblMessage.Text = "學生或教師不存在!";
                    break;
                case 1: lblMessage.Text = "密碼重置成功!";
                    break;
            }
        }
        #endregion

        #region 刪除學院部門
        /// <summary>
        /// 刪除學院信息列表
        /// </summary>
        /// <returns></returns>
        public void  DeleteDept(string CurDp_ID, string dp_ID)
        {
            int returnMessage = department.DeleteDept(CurDp_ID, dp_ID);
            switch (returnMessage)
            {
                case -1: JScript.Alert("你沒有權限刪除學院或部門");
                    JScript.GoHistory(-1);
                    break;
                case 1: JScript.AlertAndRedirect("刪除成功!", "Colleges.aspx");
                    break;
                case 0:JScript.Alert("還有其它信息與學院關聯，請刪除與該學院相關聯的其它信息后再刪除該學院");
                    JScript.GoHistory(-1);
                    break;
            }
        }
        #endregion

        #region 刪除專業
        /// <summary>
        /// 刪除專業
        /// </summary>
        /// <returns></returns>
        public void DeleteSP(string CurDp_ID, string sp_ID)
        {
            int returnMessage = department.DeleteSP(CurDp_ID, sp_ID);
            switch (returnMessage)
            {
                case -1: JScript.Alert("你沒有權限刪除該專業");
                    JScript.GoHistory(-1);
                    break;
                case 1: JScript.AlertAndRedirect("刪除成功!", "Specialities.aspx");
                    break;
                case 0: JScript.Alert("還有其它信息與該專業關聯，請刪除與該專業相關聯的其它信息后在刪除該學院");
                    JScript.GoHistory(-1);
                    break;
            }
        }
        #endregion

        #region 刪除班級
        /// <summary>
        /// 刪除班級
        /// </summary>
        /// <returns></returns>
        public void  DeleteCL(string CurDp_ID, string cl_ID)
        {
            int returnMessage = department.DeleteCL(CurDp_ID, cl_ID);
            switch (returnMessage)
            {
                case -1: JScript.Alert("你沒有權限刪除該班級");
                    JScript.GoHistory(-1);
                    break;
                case 1: JScript.AlertAndRedirect("刪除成功!", "Classes.aspx");
                    break;
                case 0: JScript.Alert("還有其它信息與該班級關聯，請刪除該與該班級關聯的其它信息后再刪除該班級");
                    JScript.GoHistory(-1);
                    break;
            }
        }
        #endregion

        #region 刪除課程庫課程
        /// <summary>
        /// 刪除課程庫課程
        /// </summary>
        /// <returns></returns>
        public void  DeleteCourseLib(string CurDp_ID, string cb_ID)
        {
            int returnMessage = department.DeleteCourseLib(CurDp_ID, cb_ID);
            switch (returnMessage)
            {
                case -1: JScript.Alert("你沒有權限刪除該課程");
                    JScript.GoHistory(-1);
                    break;
                case 1: JScript.AlertAndRedirect("刪除成功!", "Courses.aspx");
                    break;
                case 0: JScript.Alert("還有其它信息與該課程關聯，請刪除與該課程關聯的其它信息后再刪除該課程");
                    JScript.GoHistory(-1);
                    break;
            }
        }
        #endregion

        #region 顯示學院詳細信息
        /// <summary>
        /// 顯示學院詳細信息
        /// </summary>
        /// <returns></returns>
        public void  DisplayDeptDetailsInf(string CurDp_ID,Label lblDeptID,Label lblDeptName,Label lblAddress,Label lblDeptTel,TextBox txtDeptRemark)
        {
            DataSet ds = department.DisplayDeptDetailsInf(CurDp_ID);
            if (ds != null)
            {
                lblDeptID.Text = ds.Tables[0].Rows[0]["dp_id"].ToString();
                lblDeptName.Text = ds.Tables[0].Rows[0]["dp_name"].ToString();
                lblAddress.Text = ds.Tables[0].Rows[0]["dp_address"].ToString();
                lblDeptTel.Text = ds.Tables[0].Rows[0]["dp_tel"].ToString();
                txtDeptRemark.Text = ds.Tables[0].Rows[0]["dp_remark"].ToString();
            }
        }
        #endregion

    }
}