using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CoreSavingLibrary;
using CoreSavingLibrary.WcfNDeposit;
using DataLibrary;
using CoreSavingLibrary.WcfNCommon;

namespace Saving.Applications.shrlon.dlg
{
    public partial class w_dlg_sl_printcont : PageWebDialog, WebDialog
    {
        protected String postPrintBook;
        protected String jsSavePrint;
        Sta ta;
        String pbl = "sl_loanreq_ksmk.pbl";
        string docno = "";
        public void InitJsPostBack()
        {
            postPrintBook = WebUtil.JsPostBack(this, "postPrintBook");
            jsSavePrint = WebUtil.JsPostBack(this, "jsSavePrint"); 
         
        }
        public void WebDialogLoadBegin()
        {
            this.ConnectSQLCA();
            dw_printcont.SetTransaction(sqlca);

            ta = new Sta(sqlca.ConnectionString);
            sqlca = new DwTrans();
            sqlca.Connect();


            if (!IsPostBack)
            {

                dw_printcont.Reset();
                dw_printcont.InsertRow(0);
                docno = Request["lcontno"];
               
                if (docno == "")
                {
                    docno = wcf.NCommon.of_getnewdocno(state.SsWsPass, state.SsCoopId, "LNDOCNO");
                }
                else
                {
                    string[] arg2 = new string[2] { docno, state.SsCoopId };
                    try { DwUtil.RetrieveDataWindow(dw_printcont, pbl, null, arg2); }
                    catch (Exception ex) { ex.ToString(); }
                    if (dw_printcont.RowCount < 1)
                    {
                        dw_printcont.InsertRow(0);
                    }
                }
                HdAccountNo.Value = docno;
            }
            else
            {
                this.RestoreContextDw(dw_printcont);


            }
             

        }
        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "postPrintBook")
            {
                savePrintcont(HdAccountNo.Value);
            }
            else if (eventArg == "jsSavePrint")
            {
                Sdt d = WebUtil.QuerySdt("select max(loanobjective_code) as loanobjective_code from lnucfobjectrecieve ");
                if (d.Next())
                {
                    int g = Convert.ToInt32(d.GetString("loanobjective_code")) + 1;
                    WebUtil.QuerySdt("insert into lnucfobjectrecieve(coop_id, loanobjective_code,loanobjective_desc) values ('" + state.SsCoopControl + "','" + g.ToString() + "','" + TextBox1.Text + "' )");
                }
                RetreiveDDDW();
               // this.SetFocusScript(Hdfeild.Value);
            }   
        }


     
        public void WebDialogLoadEnd()
        {

            dw_printcont.SaveDataCache();

        }

        private void savePrintcont(string reqdoc_no)
        {
            /*****รับค่าจาก dw_printcont  */
            Decimal PAY_AMT2 = 0, PAY_AMT1 = 0, PAY_AMT3 = 0, PAY_AMT4 = 0,
                PAY_AMT5 = 0,
  RECIEVE_AMT1 = 0, RECIEVE_AMT2 = 0, RECIEVE_AMT3 = 0, RECIEVE_AMT4 = 0, RECIEVE_AMT5 = 0,
 RECIEVE_PAY1 = 0, RECIEVE_PAY2 = 0, RECIEVE_PAY3 = 0, RECIEVE_PAY4 = 0, RECIEVE_PAY5 = 0,
RECIEVE_LAND1 = 0, RECIEVE_LAND2 = 0, RECIEVE_LAND3 = 0, RECIEVE_LAND4 = 0, RECIEVE_LAND5 = 0,
TYPE_AMT1 = 0,
TYPE_AMT2 = 0, TYPE_AMT3 = 0, TYPE_AMT4 = 0, TYPE_LAND1 = 0, TYPE_LAND2 = 0, TYPE_LAND3 = 0, TYPE_AMT5 = 0,
 TYPE_LAND4 = 0, TYPE_LAND5 = 0, PAY_AMT11 = 0, PAY_AMT12 = 0, PAY_AMT13 = 0;


            string TYPE4 = "", TYPE5 = "", TYPE3 = "", TYPE2 = "", TYPE1 = "", RECIEVE1 = "", RECIEVE2 = "", RECIEVE3 = "", RECIEVE4 = "", RECIEVE5 = "",
                 TYPE_PAY1 = "", TYPE_PAY2 = "", TYPE_PAY3 = "", TYPE_PAY4 = "",PAY_AMT19="", TYPE_PAY5 = "", PAY_AMT6 = "", PAY_AMT7 = "", PAY_AMT8 = "", PAY_AMT9 = "", PAY_AMT10 = "", PAY_AMT14 = "", PAY_AMT15 = "", PAY_AMT16 = "", PAY_AMT17 = "", PAY_AMT18 = "";


            if (dw_printcont.IsItemNull(1, "TYPE1")) { TYPE1 = "-"; }
            else
            {
                TYPE1 = dw_printcont.GetItemString(1, "TYPE1");
            }
            if (dw_printcont.IsItemNull(1, "TYPE2")) { TYPE2 = "-"; }
            else
            {
                TYPE2 = dw_printcont.GetItemString(1, "TYPE2");
            }
            if (dw_printcont.IsItemNull(1, "TYPE3")) { TYPE3 = "-"; }
            else
            {
                TYPE3 = dw_printcont.GetItemString(1, "TYPE3");
            }
            if (dw_printcont.IsItemNull(1, "TYPE4")) { TYPE4 = "-"; }
            else
            {
                TYPE4 = dw_printcont.GetItemString(1, "TYPE4");
            }
            if (dw_printcont.IsItemNull(1, "TYPE5")) { TYPE5 = "-"; }
            else
            {
                TYPE5 = dw_printcont.GetItemString(1, "TYPE5");
            }

            if (dw_printcont.IsItemNull(1, "TYPE_LAND1")) { TYPE_LAND1 = 0; }
            else
            {
                TYPE_LAND1 = dw_printcont.GetItemDecimal(1, "TYPE_LAND1");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_LAND2")) { TYPE_LAND2 = 0; }
            else
            {
                TYPE_LAND2 = dw_printcont.GetItemDecimal(1, "TYPE_LAND2");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_LAND3")) { TYPE_LAND3 = 0; }
            else
            {
                TYPE_LAND3 = dw_printcont.GetItemDecimal(1, "TYPE_LAND3");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_LAND4")) { TYPE_LAND4 = 0; }
            else
            {
                TYPE_LAND4 = dw_printcont.GetItemDecimal(1, "TYPE_LAND4");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_LAND5")) { TYPE_LAND5 = 0; }
            else
            {
                TYPE_LAND5 = dw_printcont.GetItemDecimal(1, "TYPE_LAND5");
            }

            if (dw_printcont.IsItemNull(1, "PAY_AMT2")) { PAY_AMT2 = 0; }
            else
            {
                PAY_AMT2 = dw_printcont.GetItemDecimal(1, "PAY_AMT2");
            }

            if (dw_printcont.IsItemNull(1, "PAY_AMT1")) { PAY_AMT1 = 0; }
            else
            {
                PAY_AMT1 = dw_printcont.GetItemDecimal(1, "PAY_AMT1");
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT3")) { PAY_AMT3 = 0; }
            else
            {
                PAY_AMT3 = dw_printcont.GetItemDecimal(1, "PAY_AMT3");
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT4")) { PAY_AMT4 = 0; }
            else
            {
                PAY_AMT4 = dw_printcont.GetItemDecimal(1, "PAY_AMT4");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_PAY1")) { TYPE_PAY1 = "-"; }
            else
            {
                TYPE_PAY1 = dw_printcont.GetItemString(1, "TYPE_PAY1");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_PAY2")) { TYPE_PAY2 = "-"; }
            else
            {
                TYPE_PAY2 = dw_printcont.GetItemString(1, "TYPE_PAY2");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_PAY3")) { TYPE_PAY3 = "-"; }
            else
            {
                TYPE_PAY3 = dw_printcont.GetItemString(1, "TYPE_PAY3");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_PAY4")) { TYPE_PAY4 = "-"; }
            else
            {
                TYPE_PAY4 = dw_printcont.GetItemString(1, "TYPE_PAY4");
            }

            if (dw_printcont.IsItemNull(1, "TYPE_PAY5")) { TYPE_PAY5 = "-"; }
            else
            {
                TYPE_PAY5 = dw_printcont.GetItemString(1, "TYPE_PAY5");
            }

            if (dw_printcont.IsItemNull(1, "RECIEVE_AMT1")) { RECIEVE_AMT1 = 0; }
            else
            {
                RECIEVE_AMT1 = dw_printcont.GetItemDecimal(1, "RECIEVE_AMT1");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_AMT2")) { RECIEVE_AMT2 = 0; }
            else
            {
                RECIEVE_AMT2 = dw_printcont.GetItemDecimal(1, "RECIEVE_AMT2");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_AMT3")) { RECIEVE_AMT3 = 0; }
            else
            {
                RECIEVE_AMT3 = dw_printcont.GetItemDecimal(1, "RECIEVE_AMT3");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_AMT4")) { RECIEVE_AMT4 = 0; }
            else
            {
                RECIEVE_AMT4 = dw_printcont.GetItemDecimal(1, "RECIEVE_AMT4");
            }

            if (dw_printcont.IsItemNull(1, "RECIEVE_AMT5")) { RECIEVE_AMT5 = 0; }
            else
            {
                RECIEVE_AMT5 = dw_printcont.GetItemDecimal(1, "RECIEVE_AMT5");
            }



            if (dw_printcont.IsItemNull(1, "RECIEVE_PAY1")) { RECIEVE_PAY1 = 0; }
            else
            {
                RECIEVE_PAY1 = dw_printcont.GetItemDecimal(1, "RECIEVE_PAY1");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_PAY2")) { RECIEVE_PAY2 = 0; }
            else
            {
                RECIEVE_PAY2 = dw_printcont.GetItemDecimal(1, "RECIEVE_PAY2");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_PAY3")) { RECIEVE_PAY3 = 0; }
            else
            {
                RECIEVE_PAY3 = dw_printcont.GetItemDecimal(1, "RECIEVE_PAY3");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_PAY4")) { RECIEVE_PAY4 = 0; }
            else
            {
                RECIEVE_PAY4 = dw_printcont.GetItemDecimal(1, "RECIEVE_PAY4");
            }

            if (dw_printcont.IsItemNull(1, "RECIEVE_PAY5")) { RECIEVE_PAY5 = 0; }
            else
            {
                RECIEVE_PAY5 = dw_printcont.GetItemDecimal(1, "RECIEVE_PAY5");
            }

            if (dw_printcont.IsItemNull(1, "RECIEVE_LAND1")) { RECIEVE_LAND1 = 0; }
            else
            {
                RECIEVE_LAND1 = dw_printcont.GetItemDecimal(1, "RECIEVE_LAND1");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_LAND2")) { RECIEVE_LAND2 = 0; }
            else
            {
                RECIEVE_LAND2 = dw_printcont.GetItemDecimal(1, "RECIEVE_LAND2");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_LAND3")) { RECIEVE_LAND3 = 0; }
            else
            {
                RECIEVE_LAND3 = dw_printcont.GetItemDecimal(1, "RECIEVE_LAND3");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_LAND4")) { RECIEVE_LAND4 = 0; }
            else
            {
                RECIEVE_LAND4 = dw_printcont.GetItemDecimal(1, "RECIEVE_LAND4");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE_LAND5")) { RECIEVE_LAND5 = 0; }
            else
            {
                RECIEVE_LAND5 = dw_printcont.GetItemDecimal(1, "RECIEVE_LAND5");
            }

            if (dw_printcont.IsItemNull(1, "RECIEVE5")) { RECIEVE5 = "-"; }
            else
            {
                RECIEVE5 = dw_printcont.GetItemString(1, "RECIEVE5");
            }

            if (dw_printcont.IsItemNull(1, "RECIEVE1")) { RECIEVE1 = "-"; }
            else
            {
                RECIEVE1 = dw_printcont.GetItemString(1, "RECIEVE1");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE2")) { RECIEVE2 = "-"; }
            else
            {
                RECIEVE2 = dw_printcont.GetItemString(1, "RECIEVE2");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE3")) { RECIEVE3 = "-"; }
            else
            {
                RECIEVE3 = dw_printcont.GetItemString(1, "RECIEVE3");
            }
            if (dw_printcont.IsItemNull(1, "RECIEVE4")) { RECIEVE4 = "-"; }
            else
            {
                RECIEVE4 = dw_printcont.GetItemString(1, "RECIEVE4");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_AMT1")) { TYPE_AMT1 = 0; }
            else
            {
                TYPE_AMT1 = dw_printcont.GetItemDecimal(1, "TYPE_AMT1");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_AMT2")) { TYPE_AMT2 = 0; }
            else
            {
                TYPE_AMT2 = dw_printcont.GetItemDecimal(1, "TYPE_AMT2");
            }
            if (dw_printcont.IsItemNull(1, "TYPE_AMT3")) { TYPE_AMT3 = 0; }
            else
            {
                try
                {
                    TYPE_AMT3 = dw_printcont.GetItemDecimal(1, "TYPE_AMT3");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "TYPE_AMT4")) { TYPE_AMT4 = 0; }
            else
            {
                try
                {
                    TYPE_AMT4 = dw_printcont.GetItemDecimal(1, "TYPE_AMT4");
                }
                catch { }
            }

            if (dw_printcont.IsItemNull(1, "TYPE_AMT5")) { TYPE_AMT5 = 0; }
            else
            {
                try
                {
                    TYPE_AMT5 = dw_printcont.GetItemDecimal(1, "TYPE_AMT5");
                }
                catch { }
            }

            if (dw_printcont.IsItemNull(1, "PAY_AMT6")) { PAY_AMT6 = ""; }
            else
            {
                try
                {
                    PAY_AMT6 = dw_printcont.GetItemString(1, "PAY_AMT6");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT7")) { PAY_AMT7 = ""; }
            else
            {
                try
                {
                    PAY_AMT7 = dw_printcont.GetItemString(1, "PAY_AMT7");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT8")) { PAY_AMT8 = ""; }
            else
            {
                try
                {
                    PAY_AMT8 = dw_printcont.GetItemString(1, "PAY_AMT8");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT9")) { PAY_AMT9 = ""; }
            else
            {
                try
                {
                    PAY_AMT9 = dw_printcont.GetItemString(1, "PAY_AMT9");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT10")) { PAY_AMT10 = ""; }
            else
            {
                try
                {
                    PAY_AMT10 = dw_printcont.GetItemString(1, "PAY_AMT10");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT11")) { PAY_AMT11 = 0; }
            else
            {
                try
                {
                    PAY_AMT11 = dw_printcont.GetItemDecimal(1, "PAY_AMT11");
                }
                catch { }
            }

            if (dw_printcont.IsItemNull(1, "PAY_AMT12"))
            {
                PAY_AMT12 = 0;
            }
            else
            {

                PAY_AMT12 = dw_printcont.GetItemDecimal(1, "PAY_AMT12");

            }

            if (dw_printcont.IsItemNull(1, "PAY_AMT13")) { PAY_AMT13 = 0; }
            else
            {
                PAY_AMT13 = dw_printcont.GetItemDecimal(1, "PAY_AMT13");
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT14")) { PAY_AMT14 = ""; }
            else
            {
                PAY_AMT14 = dw_printcont.GetItemString(1, "PAY_AMT14");
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT15")) { PAY_AMT15 = ""; }
            else
            {
                try
                {
                    PAY_AMT15 = dw_printcont.GetItemString(1, "PAY_AMT15");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT16")) { PAY_AMT16 = ""; }
            else
            {
                try
                {
                    PAY_AMT16 = dw_printcont.GetItemString(1, "PAY_AMT16");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT17")) { PAY_AMT17 = ""; }
            else
            {
                try
                {
                    PAY_AMT17 = dw_printcont.GetItemString(1, "PAY_AMT17");
                }
                catch { }
            }
            if (dw_printcont.IsItemNull(1, "PAY_AMT18")) { PAY_AMT18 = ""; }
            else
            {
                try
                {
                    PAY_AMT18 = dw_printcont.GetItemString(1, "PAY_AMT18");
                }
                catch { }
            } if (dw_printcont.IsItemNull(1, "PAY_AMT19")) { PAY_AMT19 = ""; }
            else
            {
                try
                {
                    PAY_AMT19 = dw_printcont.GetItemString(1, "PAY_AMT19");
                }
                catch { }
            }



            WebUtil.QuerySdt("delete from LNPRINTCONT where loanrequest_docno ='" + reqdoc_no + "' and coop_id='" + state.SsCoopId + "'");


            //บันทึก LNPRINTCONT
            string sql21 = @"insert into LNPRINTCONT(PAY_AMT2,PAY_AMT1,PAY_AMT3, PAY_AMT4,   
          TYPE_PAY1,            TYPE_PAY2,           TYPE_PAY3,            TYPE_PAY4,   
         RECIEVE_AMT1,            RECIEVE_AMT2,            RECIEVE_AMT3,            RECIEVE_AMT4,   
        RECIEVE_PAY1,             RECIEVE_PAY2,            RECIEVE_PAY3,            RECIEVE_PAY4,   
       RECIEVE_LAND1,            RECIEVE_LAND2,        RECIEVE_LAND3,          RECIEVE_LAND4,   
     RECIEVE1,          RECIEVE2,           RECIEVE3,           RECIEVE4,           TYPE_AMT1,   
       TYPE_AMT2,          TYPE_AMT3,           TYPE_AMT4,           TYPE_LAND1,         TYPE_LAND2,            TYPE_LAND3,   
        TYPE_LAND4,         TYPE4,           TYPE3,          TYPE2,            TYPE1,coop_id,loanrequest_docno
,PAY_AMT5,TYPE_PAY5,RECIEVE_AMT5,RECIEVE_PAY5,RECIEVE_LAND5,RECIEVE5,TYPE5,PAY_AMT6,PAY_AMT7,PAY_AMT8,PAY_AMT9,PAY_AMT10,PAY_AMT11,PAY_AMT12,PAY_AMT13,PAY_AMT14,PAY_AMT15,PAY_AMT16,PAY_AMT17,PAY_AMT18,PAY_AMT19) values
                ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25},{26},{27},{28},{29},{30},{31},{32},{33},{34},{35},{36},{37},{38},{39},{40},{41},{42},{43},
                {44},{45},{46},{47},{48},{49},{50},{51},{52},{53},{54},{55},{56},{57},{58})";

            sql21 = WebUtil.SQLFormat(sql21,
PAY_AMT2, PAY_AMT1, PAY_AMT3, PAY_AMT4,
  TYPE_PAY1, TYPE_PAY2, TYPE_PAY3, TYPE_PAY4,
 RECIEVE_AMT1, RECIEVE_AMT2, RECIEVE_AMT3, RECIEVE_AMT4,
RECIEVE_PAY1, RECIEVE_PAY2, RECIEVE_PAY3, RECIEVE_PAY4,
RECIEVE_LAND1, RECIEVE_LAND2, RECIEVE_LAND3, RECIEVE_LAND4,
RECIEVE1, RECIEVE2, RECIEVE3, RECIEVE4, TYPE_AMT1,
TYPE_AMT2, TYPE_AMT3, TYPE_AMT4, TYPE_LAND1, TYPE_LAND2, TYPE_LAND3,
TYPE_LAND4, TYPE4, TYPE3, TYPE2, TYPE1, state.SsCoopId, reqdoc_no,
PAY_AMT5, TYPE_PAY5, RECIEVE_AMT5, RECIEVE_PAY5, RECIEVE_LAND5, RECIEVE5, TYPE5, PAY_AMT6, PAY_AMT7, PAY_AMT8, PAY_AMT9, PAY_AMT10, PAY_AMT11, PAY_AMT12, PAY_AMT13, PAY_AMT14, PAY_AMT15, PAY_AMT16, PAY_AMT17, PAY_AMT18, PAY_AMT19);
            WebUtil.QuerySdt(sql21);
            this.SetOnLoadedScript(" parent.GetValueLoanRequest2(\"" + reqdoc_no + "\" ); parent.RemoveIFrame();");
             
            //*       end save printcont            */
        }



        /// <summary>
        ///  retreive datawindows dropdown
        /// </summary>
        public void RetreiveDDDW()
        {
            

            try
            {
               
                
                DwUtil.RetrieveDDDW(dw_printcont, "type1", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "recieve1", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type_pay1", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type2", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "recieve2", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type_pay2", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type3", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "recieve3", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type_pay3", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type4", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "recieve4", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type_pay4", pbl, null);
                WebUtil.RetrieveDDDW(dw_printcont, "type1", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type5", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "recieve5", pbl, null);
                DwUtil.RetrieveDDDW(dw_printcont, "type_pay5", pbl, null);
            }
            catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); }
        }

       

    }
}