using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DataLibrary;
using System.Drawing;
using CoreSavingLibrary.WcfNShrlon;
using System.Data;
using System.IO;
using CoreSavingLibrary.WcfNDeposit; // new deposit

namespace Saving.Applications.shrlon.ws_sl_printcard_ctrl
{
    public partial class ws_sl_printcard : PageWebSheet, WebSheet
    {
        
        [JsPostBack]
        public string PostShowData { get; set; }
        [JsPostBack]
        public string PostMemberNo { get; set; }
        [JsPostBack]
        public string deleteContract { get; set; }
        [JsPostBack]
        public string jsPrintslip { get; set; }

        [JsPostBack]
        public string JsCallIreport { get; set; }
        [JsPostBack]
        public string jsPrintBookCard2 { get; set; }
         [JsPostBack]
        public string jsPostcovercard { get; set; }
          [JsPostBack]
         public string SetColors { get; set; }
        


        private n_depositClient ndept; //new deposit
       
        public void InitJsPostBack()
        {
            dsMain.InitDsMain(this);
            dsList.InitDsList(this);
        }

        public void WebSheetLoadBegin()
        {
            //    dsMain.RetriveEntryid();
            
            ndept = wcf.NDeposit;


            this.ConnectSQLCA();
             
            sqlca = new DwTrans();
            sqlca.Connect();



            if (!IsPostBack)
            {
                dsMain.DATA[0].EDATE = state.SsWorkDate;
                dsMain.DATA[0].SDATE =   state.SsStartAccountYear_date;
                dsMain.memgroup();
                dsMain.end_memgroup();
                dsMain.lnloantypes();
                string[] mimax = ReportUtil.GetMinMaxMembgroup();

                dsMain.DATA[0].SGROUP = mimax[0];
                dsMain.DATA[0].EGROUP = mimax[1];

                HdRow2.Value = "";
                //String sql = "  select accstart_date from cmaccountyear where accsyscls_status=0 and coop_id = '"+state.SsCoopControl+"' ";
                //Sdt d = WebUtil.QuerySdt(sql);
                //if (d.Next())
                //{
                //    dsMain.DATA[0].SLIP_DATE = d.GetDate("accstart_date");
                //}
                // dsMain.DATA[0].e = state.SsWorkDate.AddMonths(-1);

                //  dsMain.DATA[0].SLIP_DATE = state.SsWorkDate;
                //  dsMain.DATA[0].GROUP = "0";
                // dsList.RetrieveList("%", dsMain.DATA[0].SLIP_DATE);
            }
            else
            {
                this.RestoreContextDw(DwPrintPrompt2);
            }
        }

        public void CheckJsPostBack(string eventArg)
        {

           
            if (eventArg == PostShowData)
            {
                string member_no = "", entry = "",loantype="";
                HdRow2.Value ="";
                if (dsMain.DATA[0].MEMB_NO == "")
                {
                    member_no = "%";
                }
                else
                {
                    member_no = "%" + dsMain.DATA[0].MEMB_NO + "%";
                }
                if (dsMain.DATA[0].LOANTYPE == "")
                {
                    loantype = "%";
                }
                else
                {
                    loantype = dsMain.DATA[0].LOANTYPE;
                }

                dsList.RetrieveList(dsMain.DATA[0].SGROUP, dsMain.DATA[0].SGROUP, dsMain.DATA[0].SDATE, dsMain.DATA[0].EDATE, member_no, loantype, dsMain.DATA[0].TYPE);
                LtServerMessage.Text = WebUtil.CompleteMessage("มีจำนวนทั้งหมด  "+dsList.RowCount.ToString("#,##0")+" สัญญา");

            }
            else if (eventArg == jsPostcovercard)
            {
                int roi=0;
                roi = Convert.ToInt32(HdRow2.Value);
                string memno = dsList.DATA[roi].LOANCONTRACT_NO;// dw_data_1.GetItemString(1, "loancontract_no");
               
                Printing.PrintHeadCardLoan(this, memno, state.SsCoopControl);
            }
            else if (eventArg == SetColors)
            {
                setcolordefault();
                int row = Convert.ToInt32(HdRow2.Value);
                setcolor_row(row);
                dsMain.DATA[row].LOAN_NO = dsList.DATA[row].LOANCONTRACT_NO;
                DwUtil.RetrieveDataWindow(DwPrintPrompt2, "sl_print_book.pbl", null, state.SsCoopControl, dsList.DATA[row].LOANCONTRACT_NO);
                DwUtil.RetrieveDataWindow(dw_data_2, "LOANCONTRACT_NO", null, dsList.DATA[row].LOANCONTRACT_NO);
                if (dsMain.DATA[0].TYPE == "01")
                {
                    String sql = "select seq_no from lncontstatement where loancontract_no ='" + dsList.DATA[row].LOANCONTRACT_NO + "'   and coop_id ='" + state.SsCoopControl + "' and loanitemtype_code = 'B/F' and slip_date between {0} and {1}";
                    sql = WebUtil.SQLFormat(sql, dsMain.DATA[0].SDATE, dsMain.DATA[0].EDATE);
                    Sdt ds = WebUtil.QuerySdt(sql);
                    if (ds.Next())
                    {
                        DwPrintPrompt2.SetItemDecimal(1, "lastrec_no_card", ds.GetDecimal("seq_no"));
                      //  printcard();
                    }
                }
            }
                

            else if (eventArg == jsPrintBookCard2)
            {
                printcard();

            }
            else if (eventArg == PostMemberNo)
            {
                //Convert.ToInt32(HdRow.Value);
               
                int row = 0;
                if (HdRow2.Value == "")
                {
                    row = 0;
                }
                else
                {
                    if (Convert.ToInt32(HdRow2.Value) == 0)
                    {
                        row = 1;
                        setcolordefault(row-1);
                    }
                    else
                    {
                        row = Convert.ToInt32(HdRow2.Value)+1;
                        setcolordefault(row-1);
                    }
                }
                 
                setcolor_row(row);
                DwUtil.RetrieveDataWindow(DwPrintPrompt2, "sl_print_book.pbl", null, state.SsCoopControl, dsList.DATA[row].LOANCONTRACT_NO);
                DwUtil.RetrieveDataWindow(dw_data_2, "LOANCONTRACT_NO", null, dsList.DATA[row].LOANCONTRACT_NO);
                HdRow2.Value = Convert.ToString( row);
                dsMain.DATA[0].LOAN_NO = dsList.DATA[row].LOANCONTRACT_NO;
                if (dsMain.DATA[0].TYPE == "01")
                {
                    String sql = "select seq_no from lncontstatement where loancontract_no ='"+dsList.DATA[row].LOANCONTRACT_NO+"'   and coop_id ='"+state.SsCoopControl+"' and loanitemtype_code = 'LTA' and slip_date between {0} and {1}";
                    sql = WebUtil.SQLFormat(sql,dsMain.DATA[0].SDATE.AddMonths(-1),dsMain.DATA[0].EDATE);
                    Sdt ds = WebUtil.QuerySdt(sql);
                    if (ds.Next())
                    {
                        DwPrintPrompt2.SetItemDecimal(1, "lastrec_no_card", ds.GetDecimal("seq_no"));
                        printcard(); 
                    }
                }
                else if (dsMain.DATA[0].TYPE == "02")
                {
                    int roi = 0;
                    roi = Convert.ToInt32(HdRow2.Value);
                    string memno = dsList.DATA[roi].LOANCONTRACT_NO;// dw_data_1.GetItemString(1, "loancontract_no");

                    Printing.PrintHeadCardLoan(this, memno, state.SsCoopControl);

                }
                else if (dsMain.DATA[0].TYPE == "03")
                {
                    String sql = "select seq_no from lncontstatement where loancontract_no ='" + dsList.DATA[row].LOANCONTRACT_NO + "'   and coop_id ='" + state.SsCoopControl + "' and loanitemtype_code = 'B/F' and slip_date between {0} and {1}";
                    sql = WebUtil.SQLFormat(sql, dsMain.DATA[0].SDATE, dsMain.DATA[0].EDATE);
                    Sdt ds = WebUtil.QuerySdt(sql);
                    if (ds.Next())
                    {
                        DwPrintPrompt2.SetItemDecimal(1, "lastrec_no_card", ds.GetDecimal("seq_no"));
                        printcard();
                    }
                }
               
            }
           
        }

        private void printcard()
        {

            try
            {
                int rw = 0;
                rw = Convert.ToInt32(HdRow2.Value);
                Int16 seq = Convert.ToInt16(DwPrintPrompt2.GetItemDecimal(1, "lastrec_no_card"));
                Int16 page = Convert.ToInt16(DwPrintPrompt2.GetItemDecimal(1, "lastpage_no_card"));
                Int16 line = Convert.ToInt16(DwPrintPrompt2.GetItemDecimal(1, "lastline_no_card"));
                String as_loan_no = dsList.DATA[rw].LOANCONTRACT_NO;


                //XmlConfigService xml = new XmlConfigService();
                int ai_status = 1;// xml.DepositPrintMode;
                String as_xml_return = "";
                String as_return = "";
                string printset = state.SsPrinterSet;
                ndept.of_printloanbook_card(state.SsWsPass, as_loan_no, seq, page, line, true, ref as_xml_return, ref as_return);
                String[] re = as_return.Split('@');
                int rePage = int.Parse(re[0]);
                int reReq = int.Parse(re[1]);


               // WebUtil.QuerySdt("update lncontmaster set lastrec_no_card = " + DwPrintPrompt2.GetItemDecimal(1, "lastrec_no_card") + "    where loancontract_no='" + as_loan_no + "' and coop_id = '" + state.SsCoopControl + "' ");
                Printing.PrintApplet(this, "loan_bookcard", as_xml_return);
                //  Printing.PrintApplet(this, "loan_printbook", as_xml_return);


                Sdt d = WebUtil.QuerySdt("select lastpage_no_card,lastrec_no_card,lastline_no_card from lncontmaster where loancontract_no = '" + as_loan_no + "'");
                if (d.Next())
                {

                    DwPrintPrompt2.SetItemDecimal(1, "lastpage_no_card", d.GetDecimal("lastpage_no_card"));
                    DwPrintPrompt2.SetItemDecimal(1, "lastrec_no_card", d.GetDecimal("lastrec_no_card"));
                    DwPrintPrompt2.SetItemDecimal(1, "lastline_no_card", d.GetDecimal("lastline_no_card"));
                }
                if (rePage > 0)
                {
                    DwPrintPrompt2.SetItemDecimal(1, "lastrec_no_card", reReq);
                    DwPrintPrompt2.SetItemDecimal(1, "lastline_no_card", 1);
                    WebUtil.QuerySdt("update lncontmaster set lastline_no_card = 1 where loancontract_no='" + as_loan_no + "' and coop_id = '" + state.SsCoopControl + "' ");
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "rePrintBookCard", "rePrintBookCard('" + as_loan_no + "')", true);

                }


            }
            catch (Exception ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(ex);
            }

        }
        private void setcolordefault()
        {
            Color myRgbColor = new Color();
            myRgbColor = Color.FromArgb(255, 255, 255);
            for (int index_row = 0; index_row < dsList.RowCount; index_row++)
            {
                dsList.FindTextBox(index_row, "MEMBER_NO").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "MEMB_NAME").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "LOANCONTRACT_NO").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "LOANTYPE_CODE").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "PRINCIPAL_BALANCE").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "STARTCONT_DATE").BackColor = myRgbColor;
            }
        }

        private void setcolordefault(int index_row)
        {
            Color myRgbColor = new Color();
            myRgbColor = Color.FromArgb(255, 255, 255);
             
                dsList.FindTextBox(index_row, "MEMBER_NO").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "MEMB_NAME").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "LOANCONTRACT_NO").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "LOANTYPE_CODE").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "PRINCIPAL_BALANCE").BackColor = myRgbColor;
                dsList.FindTextBox(index_row, "STARTCONT_DATE").BackColor = myRgbColor;
             
        }
        


        private void setcolor_row(int index_row)
        {
            Color myRgbColor = new Color();
            myRgbColor = Color.FromArgb(92, 172, 238);

            dsList.FindTextBox(index_row, "MEMBER_NO").BackColor = myRgbColor;
            dsList.FindTextBox(index_row, "MEMB_NAME").BackColor = myRgbColor;
            dsList.FindTextBox(index_row, "LOANCONTRACT_NO").BackColor = myRgbColor;
            dsList.FindTextBox(index_row, "LOANTYPE_CODE").BackColor = myRgbColor;
            dsList.FindTextBox(index_row, "PRINCIPAL_BALANCE").BackColor = myRgbColor;
            dsList.FindTextBox(index_row, "STARTCONT_DATE").BackColor = myRgbColor;
            
        }

        public void SaveWebSheet()
        {
        }

        public void WebSheetLoadEnd()
        {
            LtServerMessage.Text = WebUtil.CompleteMessage("มีจำนวนทั้งหมด  " + dsList.RowCount.ToString("#,##0") + " สัญญา");
        }
    }
}