?using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using corInfMan.Utility;
using System.Data;
using System.Data.SqlClient;
namespace corInfMan.DAL
{
    public class DALUser
    {
        public DALUser() { }
        /// <summary>
        /// 是否公司職員
        /// </summary>
        /// <param name="id">員工ID</param>
        /// <param name="name">員工姓名</param>
        /// <returns></returns>
        public static bool isEmployee(int id,string name)
        {
            StringBuilder str = new StringBuilder();
            str.Append("select EmployeeName from aspnet_Employee where EmployeeID=@id ");
            SqlParameter[] parm = {new SqlParameter("@id", SqlDbType.Int)};
            parm[0].Value = id;
            if (SQLHelper.Exists(str.ToString(), parm))
            {
                string retName = SQLHelper.GetSingle(str.ToString(), parm).ToString();
                if (Object.Equals(retName.TrimEnd(new char[]{' '}), name))//從數據庫讀出時要注意字節長度
                    return true;
                else
                    return false;
                
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 將注冊信息寫入公司個人信息中
        /// </summary>
        /// <param name="id">員工ID</param>
        /// <param name="name">注冊名字</param>
        public void addtoEmployeeInf(string id,string name)
        {
            StringBuilder str = new StringBuilder();
            str.Append("update aspnet_Employee set RegName=@name where EmployeeID=@id ");
            SqlParameter[] parm={new SqlParameter("@name",SqlDbType.NChar),new SqlParameter("@id",SqlDbType.NChar)};
            parm[0].Value = name;
            parm[1].Value = id;
            SQLHelper.ExecuteSql(str.ToString(), parm);
        }
        /// <summary>
        /// 員工是否管理者
        /// </summary>
        /// <param name="id">員工ID</param>
        /// <returns></returns>
        public int isMan(string id)
        {
            string sqlStr = "select isMan from aspnet_Employee where EmployeeID=@id";
            SqlParameter[] parm = { new SqlParameter("@id", SqlDbType.NChar) };
            parm[0].Value = id;
            int man = int.Parse(SQLHelper.GetSingle(sqlStr, parm).ToString());
            return man;
        }
        //public string retUserID(string name)
        //{
        //    string sqlStr = "select UserID from aspnet_Users where UserName=@name";
        //    SqlParameter[] parm = { new SqlParameter("@name",SqlDbType.NVarChar)};
        //    parm[0].Value = name;
        //    return corInfMan.Utility.SQLHelper.GetSingle(sqlStr, parm).ToString();
        //}
        ///// <summary>
        /////將職位 寫入注冊信息
        ///// </summary>
        ///// <param name="man">職位</param>
        ///// <param name="username">注冊名字</param>
        //public void manToUsers(int man,string username)
        //{
        //    string sqlStr = "update aspnet_Users set IsMan=@man where UserName=@username";
        //    SqlParameter[] parm = { new SqlParameter("@man", SqlDbType.Int), new SqlParameter("@username", SqlDbType.NChar) };
        //    parm[0].Value = man;
        //    parm[1].Value = username;
        //    SQLHelper.ExecuteSql(sqlStr, parm);
            
        //}

        /// <summary>
        /// 用戶名檢測
        /// </summary>
        /// <param name="name">要注冊的用戶名</param>
        /// <returns></returns>
        public bool userNameCheck(string name)
        {
            string sqlStr = "select UserID from aspnet_Users where UserName=@name";
            SqlParameter[] parm = { new SqlParameter("@name",SqlDbType.NChar)};
            parm[0].Value = name;
            return SQLHelper.Exists(sqlStr, parm);
        }
        
        public string emplloyeeName(string regname)
        {
            string sqlStr = "select EmplloyeeName from aspnet_Emplloyee where RegName=@regname";
            SqlParameter[] parm = { new SqlParameter("@regname",SqlDbType.NChar)};
            parm[0].Value = regname;
            return corInfMan.Utility.SQLHelper.GetSingle(sqlStr, parm).ToString().TrimEnd();
        }

        /// <summary>
        /// 返回用戶所在部門
        /// </summary>
        /// <param name="regname">用戶注冊名</param>
        /// <returns></returns>
        public string sectorName(string regname)
        {
            string sqlStr = "select SectorName from aspnet_Employee where RegName=@regname";
            SqlParameter[] parm = { new SqlParameter("@regname", SqlDbType.NChar) };
            parm[0].Value = regname;
            return corInfMan.Utility.SQLHelper.GetSingle(sqlStr, parm).ToString().TrimEnd();
        }
    }

}