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

namespace Saving.Applications.shrlon.dlg.w_dlg_printcont_ctrl
{
    public partial class w_dlg_printcont : PageWebDialog, WebDialog
    {
        string docno = "";
        [JsPostBack]
        public string postPrintBook { get; set; }
        [JsPostBack]
        public string jsSavePrint { get; set; }
        public void InitJsPostBack()
        {
            dsMain.InitDsMain(this);
             
        }

        public void WebDialogLoadBegin()
        {
            if (!IsPostBack)
            {
                // ds.DdMembGroup();
                docno = Request["lcontno"];

                if (docno == "")
                {
                    docno = wcf.NCommon.of_getnewdocno(state.SsWsPass, state.SsCoopId, "LNDOCNO");
                }
                else
                {
                    dsMain.RetrieveDsMain(docno);
                    if (dsMain.RowCount < 1)
                    {
                      //  dsMain. .InsertRow(0);
                    }
                }
                RetreiveDDDW();
                HdAccountNo.Value = docno;
                this.SetOnLoadedScript("sumAll();");
            }
        }

        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.SsCoopId + "','" + g.ToString() + "','" + TextBox1.Text + "' )");
                }
                RetreiveDDDW();
            }
        }
           public void RetreiveDDDW()
        {
            

            try
            {
               
                
                dsMain.DdType("type1");
                dsMain.DdType("recieve1");
                 
                dsMain.DdType("type2");
                dsMain.DdType("recieve2");
                
                dsMain.DdType("type3");
                dsMain.DdType("recieve3");
                
                dsMain.DdType("type4");
                dsMain.DdType("recieve4");
                
                
                dsMain.DdType("type5");
                dsMain.DdType("recieve5");
                
            }
            catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); }
        }

       

    
        public void WebDialogLoadEnd()
        {

        }
        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 = "";

 


            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,
dsMain.DATA[0].PAY_AMT2, dsMain.DATA[0].PAY_AMT1, dsMain.DATA[0].PAY_AMT3, dsMain.DATA[0].PAY_AMT4,
  dsMain.DATA[0].TYPE_PAY1, dsMain.DATA[0].TYPE_PAY2, dsMain.DATA[0].TYPE_PAY3, dsMain.DATA[0].TYPE_PAY4,
 dsMain.DATA[0].RECIEVE_AMT1, dsMain.DATA[0].RECIEVE_AMT2, dsMain.DATA[0].RECIEVE_AMT3, dsMain.DATA[0].RECIEVE_AMT4,
dsMain.DATA[0].RECIEVE_PAY1, dsMain.DATA[0].RECIEVE_PAY2, dsMain.DATA[0].RECIEVE_PAY3, dsMain.DATA[0].RECIEVE_PAY4,
dsMain.DATA[0].RECIEVE_LAND1, dsMain.DATA[0].RECIEVE_LAND2, dsMain.DATA[0].RECIEVE_LAND3, dsMain.DATA[0].RECIEVE_LAND4,
dsMain.DATA[0].RECIEVE1, dsMain.DATA[0].RECIEVE2, dsMain.DATA[0].RECIEVE3, dsMain.DATA[0].RECIEVE4, dsMain.DATA[0].TYPE_AMT1,
dsMain.DATA[0].TYPE_AMT2, dsMain.DATA[0].TYPE_AMT3, dsMain.DATA[0].TYPE_AMT4, dsMain.DATA[0].TYPE_LAND1, dsMain.DATA[0].TYPE_LAND2, dsMain.DATA[0].TYPE_LAND3,
dsMain.DATA[0].TYPE_LAND4, dsMain.DATA[0].TYPE4, dsMain.DATA[0].TYPE3, dsMain.DATA[0].TYPE2, dsMain.DATA[0].TYPE1, state.SsCoopId, reqdoc_no,
dsMain.DATA[0].PAY_AMT5, dsMain.DATA[0].TYPE_PAY5, dsMain.DATA[0].RECIEVE_AMT5, dsMain.DATA[0].RECIEVE_PAY5, dsMain.DATA[0].RECIEVE_LAND5, dsMain.DATA[0].RECIEVE5, dsMain.DATA[0].TYPE5, dsMain.DATA[0].PAY_AMT6, dsMain.DATA[0].PAY_AMT7,
dsMain.DATA[0].PAY_AMT8, dsMain.DATA[0].PAY_AMT9, dsMain.DATA[0].PAY_AMT10, dsMain.DATA[0].PAY_AMT11, dsMain.DATA[0].PAY_AMT12, dsMain.DATA[0].PAY_AMT13,
dsMain.DATA[0].PAY_AMT14, dsMain.DATA[0].PAY_AMT15, dsMain.DATA[0].PAY_AMT16, dsMain.DATA[0].PAY_AMT17, dsMain.DATA[0].PAY_AMT18, dsMain.DATA[0].PAY_AMT19);
            WebUtil.QuerySdt(sql21);
            this.SetOnLoadedScript(" parent.GetValueLoanRequest2(\"" + reqdoc_no + "\" ); parent.RemoveIFrame();");

            //*       end save printcont            */
        }



       }
}