?using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

/// <summary>
///BLLTravel 的摘要說明
/// </summary>
namespace corInfMan.BLL
{
    public class BLLTravel
    {
        public BLLTravel()
        {
            //
            //TODO: 在此處添加構造函數邏輯
            //
        }
        /// <summary>
        /// 信息提示 是否通過審核
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public string isCertified(string username)
        {
            string note;
            int check=new corInfMan.DAL.DALTravel().isCertified(username);
            switch (check)
            {
                case 0:
                    note = "您新申請的出差現在還沒通過審核";
                    break;
                case 1:
                    note = "您新申請的出差已通過審核";
                    break;
                case 2:
                    note = "您沒有新的出差等待審核";
                    break;
                case 3:
                    note = "您沒有申請過出差";
                    break;
                default:
                    note = "您沒有申請過出差";
                    break;
            }
            return note;
        }
        /// <summary>
        /// 提交非項目組出差的申請
        /// </summary>
        /// <param name="now"></param>
        /// <param name="start"></param>
        /// <param name="end"></param>
        /// <param name="moneyApply"></param>
        /// <param name="reason"></param>
        /// <param name="username"></param>
        public void submitApply(DateTime now,string  start,string end,int moneyApply,string reason,string username)
        {
            start +=" "+ DateTime.Now.TimeOfDay.ToString();
            end += " "+DateTime.Now.TimeOfDay.ToString();
            new corInfMan.DAL.DALTravel().submitApply(now,DateTime.Parse( start),DateTime.Parse( end), moneyApply, reason,0,username,0,0);
        }
        public void submitApply(DateTime now, string start, string end, int moneyApply, string reason, string username,string itemname)
        {
            start += " " + DateTime.Now.TimeOfDay.ToString();
            end += " " + DateTime.Now.TimeOfDay.ToString();
            new corInfMan.DAL.DALTravel().submitApply(now, DateTime.Parse(start), DateTime.Parse(end), moneyApply, reason, 0, username, 0, 0);
        }
        /// <summary>
        /// 還未通過審核的申請
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public DataTable travelTable(string username)
        {
            return new corInfMan.DAL.DALTravel().travelTable(username).Tables[0];
        }
        /// <summary>
        /// 已經通過的申請
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public DataTable travelOverTable(string username)
        {
            return new corInfMan.DAL.DALTravel().travelOverTable(username).Tables[0];
        }
        /// <summary>
        /// 部門經理審核的出差表    
        /// </summary>
        /// <returns></returns>
        public DataTable travelTableList()
        {
            
            DataTable dt;
            dt = new corInfMan.DAL.DALTravel().traveTableList().Tables[0];
            dt.Columns.Add("Certified",typeof(bool));
            for(int i=0;i<dt.Rows.Count;i++)
            {
                if (int.Parse(dt.Rows[i][7].ToString()) == 1)
                {
                    dt.Rows[i]["Certified"] = true;
                }
                else
                {
                    dt.Rows[i]["Certified"] = false;
                }
            }
            return dt;
        }
        /// <summary>
        /// 財務部審核的出差表
        /// </summary>
        /// <returns></returns>
        public DataTable travelTableAccountList()
        {
            DataTable dt;
            dt = new corInfMan.DAL.DALTravel().traveTableList().Tables[0];
            return dt;
        }
        /// <summary>
        /// 部門經理審核通過
        /// </summary>
        /// <param name="name"></param>
        /// <param name="check"></param>
        public void isCertified(string name,bool check)
        {
            int icheck;
            if (check)
            {
                icheck = 1;
                new corInfMan.DAL.DALContracteSub().isCertified(name, icheck);
            }
            else
            {
                icheck = 0;
            }
           
        }
        public void updateTravel(string name,string dts,string dte,string money,string reason)
        {
            DateTime dtstart = DateTime.Parse(dts);
            DateTime dtend = DateTime.Parse(dte);
            new corInfMan.DAL.DALTravel().updateTravel(name, dtstart, dtend, money, reason);
        }

        public void submitApply(string p, string p_2, int p_3, string p_4, string p_5)
        {
            throw new NotImplementedException();
        }
    }
}