using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Globalization;
using DataLibrary;
using System.Data;

namespace Saving.Applications.shrlon
{
    public partial class ws_sl_reprint2 : PageWebSheet, WebSheet
    {
        [JsPostBack]
        public string PostRetrieve { get; set; }
        [JsPostBack]
        public string PostPrint { get; set; }
        [JsPostBack]
        public string PostPrint2 { get; set; }
        string coop_kong = "000401";

        public void InitJsPostBack()
        {
            dsMain.InitDsMain(this);
            dsList.InitDsList(this);
        }

        public void WebSheetLoadBegin()
        {
            if (!IsPostBack)
            {
                dsMain.DdCode();
                dsMain.DATA[0].SLIP_DATE_E = state.SsWorkDate;
                dsMain.DATA[0].SLIP_DATE_S = state.SsWorkDate;
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == PostRetrieve)
            {
                try
                {
                    string member_no = "";
                    string entry_id = "";
                    string sliptype_code = "";
                    string document_no_s = "";
                    string document_no_e = "";
                    DateTime slip_date_s = dsMain.DATA[0].SLIP_DATE_S;
                    DateTime slip_date_e = dsMain.DATA[0].SLIP_DATE_E;

                    member_no = dsMain.DATA[0].MEMBER_NO;
                    entry_id = dsMain.DATA[0].ENTRY_ID;
                    sliptype_code = dsMain.DATA[0].SLIPTYPE_CODE;
                    document_no_s = dsMain.DATA[0].document_no_e;
                    document_no_e = dsMain.DATA[0].document_no_e;
                    if (dsMain.DATA[0].MONEYTYPE_CODE == "0" || dsMain.DATA[0].MONEYTYPE_CODE == "")
                    {

                        dsList.Retrieve(member_no, entry_id, sliptype_code, document_no_s, document_no_e, slip_date_s, slip_date_e);
                    }
                    else
                    {
                        dsList.RetrieveOUT(member_no, entry_id, sliptype_code, document_no_s, document_no_e, slip_date_s, slip_date_e);
                    }
                    int row = dsList.RowCount;
                    for (int i = 0; i < row; i++)
                    {
                        decimal slip_status = dsList.DATA[i].SLIP_STATUS;
                        if (slip_status < 0)
                        {
                            dsList.FindTextBox(i, "slipitem_desc").BackColor = System.Drawing.Color.DarkGray;
                            dsList.FindTextBox(i, "document_no").BackColor = System.Drawing.Color.DarkGray;
                            dsList.FindTextBox(i, "slip_date").BackColor = System.Drawing.Color.DarkGray;
                            dsList.FindTextBox(i, "item_payamt").BackColor = System.Drawing.Color.DarkGray;
                            dsList.FindTextBox(i, "member_no").BackColor = System.Drawing.Color.DarkGray;
                            dsList.FindTextBox(i, "cancel_id").BackColor = System.Drawing.Color.DarkGray;
                            dsList.FindTextBox(i, "entry_id").BackColor = System.Drawing.Color.DarkGray;
                        }
                    }
                }
                catch { }
            } 
            else if (eventArg == PostPrint)
            {
                string rslip = "";
                int[] prt_arr = new int[dsList.RowCount];


                for (int i = 0; i < dsList.RowCount; i++)
                {
                    if (dsList.DATA[i].checkselect == 1)
                    {
                       
                       
                string sql = @"select si.member_no ,
               ( mp.PRENAME_DESC || mb.MEMB_NAME || '   ' || mb.MEMB_SURNAME  )as mem_name ,
mb.membgroup_code,mg.membgroup_desc,
 ft_cnvtdate(si.slip_date,3)as slip_date ,si.payinslip_no
,'ลูกหนี้พิพากษา' LOANTYPE_DESC,sid.LOANCONTRACT_NO,
NVL(sid.PRINCIPAL_PAYAMT,0) as PRINCIPAL_PAYAMT
,NVL(sid.INTEREST_PAYAMT,0) as INTEREST_PAYAMT , NVL(sid.INTEREST_PERIOD,0) as INTEREST_PERIOD
, NVL(sid.ITEM_PAYAMT,0) as ITEM_PAYAMT , NVL(sid.ITEM_BALANCE,0) as ITEM_BALANCE
,sid.CALINT_FROM as int_date, NVL(sid.FINE_PERIOD,0) as FINE_PERIOD , ls.calint_from,ls.calint_to,
 NVL(ls.finearr_payment,0) as  fineyear_arrear , NVL(ls.bffineyear_amt ,0) as bffineyear_amt ,NVL(ls.fine_arrear,0) as fine_arrear 
,
 NVL(ls.bffine_arrear,0) as bffine_arrear, NVL(ls.fine_period ,0) as fine_period  , NVL(ls.bffine_period,0) as bffine_preiod 
,FTREADTBAHT(ITEM_PAYAMT) as pthai ,
 NVL(ls.bfintyeararr_amt,0) as bfintyeararr_amt , NVL(sid.inyear_arrear,0) as inyear_arrear , NVL(ls.bfinterest_arrear,0) as bfinterest_arrear ,NVL(sid.intarrear_payamt,0) as interest_arrear 
,NVL(ls.bfint_period,0) as bfint_preiod 
,(NVL(sid.INTEREST_PERIOD,0)  + NVL(sid.intarrear_payamt,0)) as interest_pay ,
  ( NVL(ls.bfint_period,0)+NVL(ls.bfinterest_arrear,0) )-(NVL(sid.INTEREST_PERIOD,0)  + NVL(ls.interest_arrear,0)) as interest_balance
                from  slslippayinlaw si ,slslippayindetlaw sid,lnlawmbmaster mb,mbucfprename mp,mbucfmembgroup mg  ,lnlawmaster,lnlawstatement ls

                where  si.coop_id = {1} and si.payinslip_no ={0} and
                si.payinslip_no = sid.payinslip_no
                and si.coop_id = sid.coop_id
                and si.member_no=mb.member_no
                and si.coop_id=mb.coop_id
                and mb.prename_code=mp.prename_code
                and mb.membgroup_code = mg.membgroup_code
                and sid.LOANCONTRACT_NO= lnlawmaster.loancontract_no
                and lnlawmaster.loancontract_no = ls.loancontract_no
                 and sid.payinslip_no = ls.ref_slipno
                and mb.coop_id = mg.coop_id and
                sid.SLIPITEMTYPE_CODE='LON'  

               group by si.member_no ,
mp.prename_desc,ls.interest_arrear,
mb.memb_name,
mb.memb_surname ,
mb.membgroup_code,mg.membgroup_desc,
si.slip_date ,si.payinslip_no ,sid.LOANCONTRACT_NO,sid.PRINCIPAL_PAYAMT
,sid.INTEREST_PAYAMT,sid.INTEREST_PERIOD
,sid.ITEM_PAYAMT,sid.ITEM_BALANCE
,sid.CALINT_FROM,sid.FINE_PERIOD, ls.calint_from,ls.calint_to,ls.finearr_payment,ls.bffineyear_amt,ls.fine_arrear,ls.bffine_arrear,ls.fine_period,ls.bffine_period,
ls.bfintyeararr_amt , sid.inyear_arrear , ls.bfinterest_arrear ,sid.intarrear_payamt ,ls.bfint_period
                    ";
                sql = WebUtil.SQLFormat(sql, dsList.DATA[i].PAYINSLIP_NO, state.SsCoopId);
                DataTable data = WebUtil.Query(sql);
                Printing.PrintAppletPB(this, "RECEIPT3", data);
                         
                    }
                }
               
            }
        }

        private static string XmlReadVar(string responseData, string szVar)
        {
            int i1stLoc = responseData.IndexOf("<" + szVar + ">");
            if (i1stLoc < 0)
                return string.Empty;
            int ilstLoc = responseData.IndexOf("</" + szVar + ">");
            if (ilstLoc < 0)
                return string.Empty;
            int len = szVar.Length;
            return responseData.Substring(i1stLoc + len + 2, ilstLoc - i1stLoc - len - 2);
        }

        public void SaveWebSheet()
        {

        }

        public void WebSheetLoadEnd()
        {

        }
    }
}