using System;
using CoreSavingLibrary;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
//using CoreSavingLibrary.WcfNCommon;
//using CoreSavingLibrary.WcfDeposit;
using CoreSavingLibrary.WcfNDeposit;  // new deposit
using CoreSavingLibrary.WcfNCommon; // new common
using System.Web.Services.Protocols;
using DataLibrary;

namespace Saving.Applications.ap_deposit
{
    public partial class w_sheet_dp_deptedit : PageWebSheet, WebSheet
    {
        [JsPostBack]
        public String Checkcount { get; set; }

        protected String postAccountNo;
        //private DepositClient depServ;
        private n_depositClient ndept; // new deposit
        protected String testControls;
        private DwThDate thDwMain;
        private DwThDate thDwTab1;
        private DwThDate thDwTab2;
        private String pblFileName = "dp_deptedit.pbl";
        protected String CheckCoop;
        protected String postNew;
        protected String CoopName;
        protected Decimal CrossFlg;
        protected String setCoopname;


        private void JsPostAccountNo()
        {
            try
            {

                String dwAccNo = DwMain.GetItemString(1, "deptaccount_no");
                 //dwAccNo = depServ.BaseFormatAccountNo(state.SsWsPass, dwAccNo);
                 dwAccNo = wcf.NDeposit.of_analizeaccno(state.SsWsPass, dwAccNo); //new
                //ใช้ interpreter เช็คว่าเป็นบาร์โค้ดหรือไม่ ถ้าเป็นบาร์โค้ดจะไป select เลขที่บัญชีกลับมา , ถ้าไม่เจออะไรจะคืนค่า dwAccNo เดิม
                //dwAccNo = wcf.InterPreter.DeptBarcodeToDeptAccount(state.SsConnectionIndex, state.SsCoopControl, dwAccNo);

              //  String accNo = depServ.BaseFormatAccountNo(state.SsWsPass, dwAccNo);
                //object[] argsDwMain = new object[2] { HfCoopcontrol.Value, accNo };
                try
                {
                    DwUtil.RetrieveDataWindow(DwMain, pblFileName, thDwMain, state.SsCoopControl, dwAccNo);
                }
                catch { }
                try
                {
                    DwTab1.Reset();
                    DwUtil.RetrieveDataWindow(DwTab1, pblFileName, thDwTab1, state.SsCoopControl, dwAccNo);
                }
                catch { }
                try
                {
                    DwTab2.Reset();
                    DwUtil.RetrieveDataWindow(DwTab2, pblFileName, thDwTab2, state.SsCoopControl, dwAccNo);
                }
                catch { }
                try
                {
                    DwTab3.Reset();
                    DwUtil.RetrieveDataWindow(DwTab3, pblFileName, null, state.SsCoopControl, dwAccNo);
                }
                catch { }
                try
                {
                    DwTab4.Reset();
                    DwUtil.RetrieveDataWindow(DwTab4, pblFileName, null, state.SsCoopControl, dwAccNo);
                }
                catch { }
                if (DwMain.RowCount < 1)
                {
                    throw new Exception("ไม่พบเลขบัญชีดังกล่าว");
                }
                //String accFormat = depServ.ViewAccountNoFormat(state.SsWsPass, DwMain.GetItemString(1, "deptaccount_no"));
                String accFormat = WebUtil.ViewAccountNoFormat(DwMain.GetItemString(1, "deptaccount_no")); //new
                DwMain.SetItemString(1, "deptaccount_no", accFormat);
                //     DwMain.SetItemDecimal(1, "cross_coopflag", CrossFlg);
                //     DwMain.SetItemString(1, "dwcrosscoop", HfCoopid.Value);
            }
            catch (SoapException ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(WebUtil.SoapMessage(ex));
            }
            catch (Exception ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message);
            }
        }

        #region WebSheet Members

        public void InitJsPostBack()
        {
            postAccountNo = WebUtil.JsPostBack(this, "postAccountNo");
            CheckCoop = WebUtil.JsPostBack(this, "CheckCoop");
            postNew = WebUtil.JsPostBack(this, "postNew");
            setCoopname = WebUtil.JsPostBack(this, "setCoopname");
            //----------------------------------------------------------------
            thDwMain = new DwThDate(DwMain, this);
            thDwMain.Add("deptopen_date", "deptopen_tdate");
            thDwMain.Add("lastcalint_date", "lastcalint_tdate");
            //----------------------------------------------------------------
            thDwTab1 = new DwThDate(DwTab1, this);
            thDwTab1.Add("entry_date", "entry_tdate");
            thDwTab1.Add("operate_date", "operate_tdate");
            //----------------------------------------------------------------
            thDwTab2 = new DwThDate(DwTab2, this);
            thDwTab2.Add("prnc_date", "prnc_tdate");
            thDwTab2.Add("prncdue_date", "prncdue_tdate");
            thDwTab2.Add("lastcalint_date", "lastcalint_tdate");
            //----------------------------------------------------------------
        }

        public void WebSheetLoadBegin()
        {
            //depServ = wcf.Deposit;
            ndept = wcf.NDeposit;
            this.ConnectSQLCA();
            if (IsPostBack)
            {
                this.RestoreContextDw(DwMain);
                this.RestoreContextDw(DwListCoop);
                this.RestoreContextDw(DwTab1);
                this.RestoreContextDw(DwTab2);
                this.RestoreContextDw(DwTab3);
                this.RestoreContextDw(DwTab4);

            }
            else
            {
                DwMain.InsertRow(0);
                DwListCoop.InsertRow(0);
                DwTab1.InsertRow(0);
                DwTab2.InsertRow(0);
                DwTab3.InsertRow(0);
                DwTab4.InsertRow(0);
                HfCoopid.Value = state.SsCoopId;
                HfCoopcontrol.Value = state.SsCoopControl;
                ////HdIsPostBack.Value = "false";
                //string coop_control = state.SsCoopControl;
                //DwUtil.RetrieveDDDW(DwMain, "dwcrosscoop", pblFileName, coop_control);
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "postAccountNo")
            {
                JsPostAccountNo();
            }
            else if (eventArg == "CheckCoop")
            {
                checkCoop();
            }
            else if (eventArg == "postNew")
            {
                JspostNew();
            }
            else if (eventArg == "setCoopname")
            {
                JsSetCoopname();
            }
            else if (eventArg == Checkcount)
            {
                int i = 1;
                int CountMember = 0;
                String deptaccount_no = null;
                String sqlsummember = "SELECT Deptaccount_No FROM dpdeptmaster where Deptaccount_No  like '%" + DwMain.GetItemString(1, "deptaccount_no") + "%' ";
                DataTable dt = WebUtil.Query(sqlsummember);
                CountMember = dt.Rows.Count;
             
                    deptaccount_no = DwMain.GetItemString(1, "deptaccount_no");
        
                Page.ClientScript.RegisterStartupScript(this.GetType(), "CheckCountMemberNo", "CheckCountMemberNo(" + CountMember + "," + deptaccount_no + ")", true);
            }
        }

        public void SaveWebSheet()
        {
        }

        public void WebSheetLoadEnd()
        {
            try
            {
                DwTab1.PageNavigationBarSettings.Visible = (DwTab1.RowCount > 10);
                DwTab2.PageNavigationBarSettings.Visible = (DwTab2.RowCount > 10);
                DwTab3.PageNavigationBarSettings.Visible = (DwTab3.RowCount > 10);
                DwTab4.PageNavigationBarSettings.Visible = (DwTab4.RowCount > 10);
                if (DwMain.RowCount <= 0)
                {
                    DwMain.InsertRow(0);
                }
            }
            catch { }
            DwMain.SaveDataCache();
            DwListCoop.SaveDataCache();
            DwTab1.SaveDataCache();
            DwTab2.SaveDataCache();
            DwTab3.SaveDataCache();
            DwTab4.SaveDataCache();
        }

        #endregion
        private void checkCoop()
        {

            decimal i = 0;
            decimal crossflag = DwListCoop.GetItemDecimal(1, "cross_coopflag");
            if (crossflag == 1)
            {
                try
                {
                    i = DwListCoop.GetItemDecimal(1, "cross_coopflag");
                }
                catch
                { }

                JspostNew();
                DwUtil.RetrieveDDDW(DwListCoop, "dddwcoopname", "cm_constant_config.pbl", state.SsCoopId, state.SsCoopControl);
            }
            else
            {
                try
                {
                    JspostNew();
                    HfCoopid.Value = state.SsCoopId + "";
                }
                catch
                { }
            }

        }

        private void JspostNew()
        {
            DwMain.Reset();
            DwTab1.Reset();
            DwTab2.Reset();
            DwTab3.Reset();
            DwTab4.Reset();

            DwMain.InsertRow(0);
            DwTab1.InsertRow(0);
            DwTab2.InsertRow(0);
            DwTab3.InsertRow(0);
            DwTab4.InsertRow(0);
            HdIsPostBack.Value = "false";
            //string coop_control = state.SsCoopControl;
            //DwUtil.RetrieveDDDW(DwMain, "dwcrosscoop",pblFileName, coop_control);
        }

        private void JsSetCoopname()
        {
            String Coopid = HfCoopid.Value;
            String Coopname;
            DataTable dt = WebUtil.Query("select coop_name from cmcoopmaster where coop_id ='" + Coopid + "'");
            if (dt.Rows.Count > 0)
            {
                Coopname = dt.Rows[0]["coop_name"].ToString();
                DwListCoop.SetItemDecimal(1, "cross_coopflag", 1);
                DwUtil.RetrieveDDDW(DwListCoop, "dddwcoopname", "cm_constant_config.pbl", state.SsCoopId, state.SsCoopControl);
                DwListCoop.SetItemString(1, "dddwcoopname", Coopname);
            }

            JsPostAccountNo();
        }
    }
}