using System;
using CoreSavingLibrary;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using CoreSavingLibrary.WcfNDeposit;
using CoreSavingLibrary.WcfNCommon;
using CoreWebServiceLibrary;
using DataLibrary;

namespace Saving.ConstantConfig
{
    public class DepositConfig
    {
        private WebState state;
        private n_depositClient depService;
        private String tbName = "deposit";

        public DepositConfig(n_depositClient depService)
        {
            state = new WebState();
            this.depService = depService;
        }
        public String GetDpDeptConstant(String wsPass, String column)
        {
            Security security = new Security(wsPass);
            Sta ta = new Sta(security.ConnectionString);
            String result = "";
            try
            {
                Sdt dt = ta.Query("select " + column + " from DPDEPTCONSTANT");
                if (!dt.Next())
                {
                    //ta.Close();
                    throw new Exception("ไม่มีข้อมูล column " + column);
                }
                result = dt.GetString(0);
            }
            catch { }
            ta.Close();
            return result;
        }

        public String ViewAccountNoFormat(String wsPass, String deptAccountNo)
        {
            Security security = new Security(wsPass);
            Sta ta = new Sta(security.ConnectionString);
            Sdt dt = ta.Query("select deptcode_mask from DPDEPTCONSTANT");
            if (!dt.Next())
            {
                ta.Close();
                throw new Exception("ไม่สามารถติดต่อกับ Database ได้");
            }
            else
            {
                ta.Close();
            }
            String format = dt.GetString(0).ToUpper();//"X-XX-XXXXXXX";
            char[] fc = format.ToCharArray();
            char[] ac = deptAccountNo.ToCharArray();
            String accNo = "";
            int j = 0;
            for (int i = 0; i < fc.Length; i++)
            {
                if (fc[i] != 'X')
                {
                    accNo += fc[i].ToString();
                }
                else
                {
                    try
                    {
                        accNo += ac[j++];
                    }
                    catch { accNo += ""; }
                }
            }
            return accNo;
        }

        public String ViewCardMemberFormat(String wsPass, String memberCard)
        {
            String format = "X-XXXX-XXXXX-XX-X";//"X-XX-XXXXXXX";
            char[] fc = format.ToCharArray();
            char[] ac = memberCard.ToCharArray();
            String cardNo = "";
            int j = 0;
            for (int i = 0; i < fc.Length; i++)
            {
                if (fc[i] != 'X')
                {
                    cardNo += fc[i].ToString();
                }
                else
                {
                    try
                    {
                        cardNo += ac[j++];
                    }
                    catch { cardNo += ""; }
                }
            }
            return cardNo;
        }

        public String DeptCodeMask
        {
            get { return GetDpDeptConstant(state.SsWsPass, "deptcode_mask"); }
        }

        public int DayPassChq
        {
            get { return int.Parse(GetDpDeptConstant(state.SsWsPass, "daypasschq")); }
        }

        public int PrintSlipStatus
        {
            get { return int.Parse(GetDpDeptConstant(state.SsWsPass, "printslip_status")); }
        }

        public String CnvDeptAccountFormat(String deptAccountNo)
        {
            return ViewAccountNoFormat(state.SsWsPass, deptAccountNo);
        }
    }
}