using System;
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.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
//using Saving.WcfCommon;
//using Saving.WcfDeposit;
using CoreSavingLibrary.WcfNDeposit; // new deposit
using CoreSavingLibrary.WcfNCommon; //new common
using System.Windows.Forms;
using System.Web.Services.Protocols;
using DataLibrary;
using CoreSavingLibrary;

namespace Saving.Applications.mbshr.dlg
{
    public partial class w_dlg_dp_printbook_new : PageWebDialog, WebDialog
    {

        // private DepositClient dep;
        private n_depositClient ndept; //new deposit
        private n_commonClient ncommon; //new common
        private String deptAccountNo;
        protected String postPrintBook;
        protected String jsPostPrintHeadCard;
        protected String postPrintBook2;

        #region WebDialog Members

        public void InitJsPostBack()
        {
            postPrintBook = WebUtil.JsPostBack(this, "postPrintBook");
            jsPostPrintHeadCard = WebUtil.JsPostBack(this, "jsPostPrintHeadCard");
            postPrintBook2 = WebUtil.JsPostBack(this, "postPrintBook2");
        }

        public void WebDialogLoadBegin()
        {
            ndept = wcf.NDeposit;
            this.ConnectSQLCA();
            DwNewBook.SetTransaction(sqlca);
            //DwStm.SetTransaction(sqlca);
            if (!IsPostBack)
            {
                HdIsPostBack.Value = "false";
                try
                {

                    HdAccountNo.Value = Request["mem_no"];
                    deptAccountNo = HdAccountNo.Value;
                    //DwStm.Retrieve(deptAccountNo, state.SsCoopControl);
                    //String xmlInitDwNewBook = dep.InitPrintBook(state.SsWsPass, deptAccountNo, state.SsCoopId);
                    DwPrintPrompt2.InsertRow(0);
                    //string smltest = DwPrintPrompt.Describe("Datawindow.Data.Xml");
                    //DwPrintPrompt.ImportString(xmlInitDwNewBook, Sybase.DataWindow.FileSaveAsType.Xml);
                    DwUtil.RetrieveDataWindow(DwPrintPrompt, "sl_contack.pbl", null, state.SsCoopControl, deptAccountNo);
                    DwUtil.RetrieveDataWindow(DwDetail, "sl_contack.pbl", null, state.SsCoopControl, deptAccountNo);
                    DwUtil.RetrieveDataWindow(DwPrintPrompt2, "sl_print_book.pbl", null, state.SsCoopControl, deptAccountNo);
                    DwPrintPrompt.SetItemDecimal(1, "lastrec_no", (DwPrintPrompt.GetItemDecimal(1, "last_stm_no")));
                }
                catch (SoapException ex)
                {
                    LtServerMessage.Text = WebUtil.ErrorMessage(WebUtil.SoapMessage(ex));
                    DwPrintPrompt.InsertRow(0);
                    DwPrintPrompt2.InsertRow(0);
                    //DwStm.InsertRow(0);
                }
                catch (Exception ex)
                {
                    LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message);
                    DwPrintPrompt.InsertRow(0);
                    DwPrintPrompt2.InsertRow(0);
                    //DwStm.InsertRow(0);
                }
            }
            else
            {
                HdIsPostBack.Value = "true";
                this.RestoreContextDw(DwPrintPrompt);
                this.RestoreContextDw(DwPrintPrompt2);
                //this.RestoreContextDw(DwStm);
            }
            this.deptAccountNo = HdAccountNo.Value;
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "postPrintBook")
            {
                try
                {
                    Int16 seq = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastrec_no"));
                    Int16 page = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastpage_no"));
                    Int16 line = Convert.ToInt16(DwPrintPrompt.GetItemDecimal(1, "lastline_no"));
                    String as_member_no = Request["mem_no"];


                    //XmlConfigService xml = new XmlConfigService();
                    int ai_status = 1;// xml.DepositPrintMode;
                    String as_xml_return = "";
                    String as_return = "";
                    string printset = state.SsPrinterSet;


                    /////////////////////////////อัปเดดตำแหน่งการพิมพ์////////////////////////////////////////
                    String check_print = DwPrintPrompt.GetItemString(1, "check_print");

                    /// String check_print2 = DwPrintPrompt.GetItemString(1, "check_print2");
                    Sta ta = new Sta(sqlca.ConnectionString);
                    String sql1, sql2, sql3, sql4, sql5, sql6;
                    if (state.SsCoopControl == "000101")
                    {
                        if (check_print == "left")
                        {
                            sql1 = @"UPDATE paprintingdetail set point_left = '250'  where printing_name = 'share_printbook' AND column_name = 'column_2'";
                            sql2 = @"UPDATE paprintingdetail set point_left = '65'  where printing_name = 'share_printbook' AND column_name = 'shritemtype_code'";
                            sql3 = @"UPDATE paprintingdetail set point_left = '115'  where printing_name = 'share_printbook' AND column_name = 't_cmp_bal'";
                            sql4 = @"UPDATE paprintingdetail set point_left = '50'  where printing_name = 'share_printbook' AND column_name = 't_cmp_dept'";
                            sql5 = @"UPDATE paprintingdetail set point_left = '50'  where printing_name = 'share_printbook' AND column_name = 't_cmp_withdraw'";
                            sql6 = @"UPDATE paprintingdetail set point_left = '8'  where printing_name = 'share_printbook' AND column_name = 't_date'";
                        }
                        else if (check_print == "right")
                        {
                            sql1 = @"UPDATE paprintingdetail set point_left = '510'  where printing_name = 'share_printbook' AND column_name = 'column_2'";
                            sql2 = @"UPDATE paprintingdetail set point_left = '325'  where printing_name = 'share_printbook' AND column_name = 'shritemtype_code'";
                            sql3 = @"UPDATE paprintingdetail set point_left = '360'  where printing_name = 'share_printbook' AND column_name = 't_cmp_bal'";
                            sql4 = @"UPDATE paprintingdetail set point_left = '310'  where printing_name = 'share_printbook' AND column_name = 't_cmp_dept'";
                            sql5 = @"UPDATE paprintingdetail set point_left = '310'  where printing_name = 'share_printbook' AND column_name = 't_cmp_withdraw'";
                            sql6 = @"UPDATE paprintingdetail set point_left = '268'  where printing_name = 'share_printbook' AND column_name = 't_date'";
                        }
                        else
                        {
                            sql1 = @"UPDATE paprintingdetail set point_left = '250'  where printing_name = 'share_printbook' AND column_name = 'column_2'";
                            sql2 = @"UPDATE paprintingdetail set point_left = '65'  where printing_name = 'share_printbook' AND column_name = 'shritemtype_code'";
                            sql3 = @"UPDATE paprintingdetail set point_left = '115'  where printing_name = 'share_printbook' AND column_name = 't_cmp_bal'";
                            sql4 = @"UPDATE paprintingdetail set point_left = '50'  where printing_name = 'share_printbook' AND column_name = 't_cmp_dept'";
                            sql5 = @"UPDATE paprintingdetail set point_left = '50'  where printing_name = 'share_printbook' AND column_name = 't_cmp_withdraw'";
                            sql6 = @"UPDATE paprintingdetail set point_left = '8'  where printing_name = 'share_printbook' AND column_name = 't_date'";
                        }
                        ta.Exe(sql1);
                        ta.Exe(sql2);
                        ta.Exe(sql3);
                        ta.Exe(sql4);
                        ta.Exe(sql5);
                        ta.Exe(sql6);
                        ta.Close();
                    }
                    else if (state.SsCoopControl == "000501")//แม่จัน
                    {
                        if (check_print == "left")
                        {
                            sql1 = @"UPDATE paprintingdetail set point_left = '255'  where printing_name = 'share_printbook' AND column_name = 'column_2'";
                            sql2 = @"UPDATE paprintingdetail set point_left = '40'  where printing_name = 'share_printbook' AND column_name = 'shritemtype_code'";
                            sql3 = @"UPDATE paprintingdetail set point_left = '90'  where printing_name = 'share_printbook' AND column_name = 't_cmp_bal'";
                            sql4 = @"UPDATE paprintingdetail set point_left = '25'  where printing_name = 'share_printbook' AND column_name = 't_cmp_dept'";
                            sql5 = @"UPDATE paprintingdetail set point_left = '25'  where printing_name = 'share_printbook' AND column_name = 't_cmp_withdraw'";
                            sql6 = @"UPDATE paprintingdetail set point_left = '0'  where printing_name = 'share_printbook' AND column_name = 't_date'";
                        }
                        else if (check_print == "right")
                        {
                            sql1 = @"UPDATE paprintingdetail set point_left = '490'  where printing_name = 'share_printbook' AND column_name = 'column_2'";
                            sql2 = @"UPDATE paprintingdetail set point_left = '305'  where printing_name = 'share_printbook' AND column_name = 'shritemtype_code'";
                            sql3 = @"UPDATE paprintingdetail set point_left = '355'  where printing_name = 'share_printbook' AND column_name = 't_cmp_bal'";
                            sql4 = @"UPDATE paprintingdetail set point_left = '290'  where printing_name = 'share_printbook' AND column_name = 't_cmp_dept'";
                            sql5 = @"UPDATE paprintingdetail set point_left = '290'  where printing_name = 'share_printbook' AND column_name = 't_cmp_withdraw'";
                            sql6 = @"UPDATE paprintingdetail set point_left = '245'  where printing_name = 'share_printbook' AND column_name = 't_date'";
                        }
                        else
                        {
                            sql1 = @"UPDATE paprintingdetail set point_left = '255'  where printing_name = 'share_printbook' AND column_name = 'column_2'";
                            sql2 = @"UPDATE paprintingdetail set point_left = '40'  where printing_name = 'share_printbook' AND column_name = 'shritemtype_code'";
                            sql3 = @"UPDATE paprintingdetail set point_left = '90'  where printing_name = 'share_printbook' AND column_name = 't_cmp_bal'";
                            sql4 = @"UPDATE paprintingdetail set point_left = '25'  where printing_name = 'share_printbook' AND column_name = 't_cmp_dept'";
                            sql5 = @"UPDATE paprintingdetail set point_left = '25'  where printing_name = 'share_printbook' AND column_name = 't_cmp_withdraw'";
                            sql6 = @"UPDATE paprintingdetail set point_left = '0'  where printing_name = 'share_printbook' AND column_name = 't_date'";
                        }



                        ta.Exe(sql1);
                        ta.Exe(sql2);
                        ta.Exe(sql3);
                        ta.Exe(sql4);
                        ta.Exe(sql5);
                        ta.Exe(sql6);
                        ta.Close();
                    }
                    //////////////////////////////////////////////////////////////////////////


                    ndept.of_print_bookshare(state.SsWsPass, as_member_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]);


                    HdIsNewBook.Value = rePage == 1 ? "true" : "false"; //เพิ่มเพื่อรับค่าจาก pb srv ว่าขึ้นเล่มใหม่
                    HdIsNewBook.Value = "true";

                    //if (ai_status == 1)
                    //{
                    //    Printing.Print(this, "Slip/ap_deposit/PrintBook.aspx", as_xml_return, 25);
                    //}
                    //else if (ai_status == 2)
                    //{
                    // Printing.SharePrintBook(this, as_xml_return);
                    Printing.PrintApplet(this, "share_printbook", as_xml_return);
                    //}
                    Retrivess();
                    // ooo.Attributes.Add("style", "display:none");
                    HdIsZeroPage.Value = "false";
                    //DwPrintPrompt.SetItemDecimal(1, "lastpage_no", DwPrintPrompt.GetItemDecimal(1, "lastpage_no"));
                    //DwPrintPrompt.SetItemDecimal(1, "lastrec_no", DwPrintPrompt.GetItemDecimal(1, "lastrec_no"));
                    //DwPrintPrompt.SetItemDecimal(1, "lastline_no", DwPrintPrompt.GetItemDecimal(1, "lastline_no"));

                    if (state.SsCoopControl != "000501")
                    {
                        HdIsZeroPage.Value = rePage == 0 ? "true" : "false";
                        this.SetOnLoadedScript("parent.ExitIFrame();");

                    }

                }
                catch (Exception ex)
                {
                    // DwPrintPrompt.SetItemDecimal(1, "lastpage_no_pb", 1);
                    LtServerMessage.Text = WebUtil.ErrorMessage(ex);
                }
            }
            else if (eventArg == "jsPostPrintHeadCard")
            {
                Printing.PrintHead_CardShare(this, HdAccountNo.Value, state.SsCoopControl);
            }
            else if (eventArg == "postPrintBook2")
            {
                try
                {
                    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_member_no = HdAccountNo.Value;// Request["mem_no"];

                    //   Int32 intlastline_no = 0;

                    //XmlConfigService xml = new XmlConfigService();
                    int ai_status = 1;// xml.DepositPrintMode;
                    String as_xml_return = "";
                    String as_return = "";
                    string printset = state.SsPrinterSet;





                    ndept.of_print_sharecard(state.SsWsPass, as_member_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]);

                    HdIsNewBook.Value = rePage == 1 ? "true" : "false"; //เพิ่มเพื่อรับค่าจาก pb srv ว่าขึ้นเล่มใหม่
                    HdIsNewBook.Value = "true";

                    //if (ai_status == 1)
                    //{
                    //    Printing.Print(this, "Slip/ap_deposit/PrintBook.aspx", as_xml_return, 25);
                    //}
                    //else if (ai_status == 2)
                    //{
                    // Printing.SharePrintBook(this, as_xml_return);
                    Printing.PrintApplet(this, "share_printcard", as_xml_return);

                    Sdt d = WebUtil.QuerySdt("select lastrec_no_card,lastline_no_card from shsharemaster where member_no = '" + as_member_no + "'");
                    if (d.Next())
                    {

                        DwPrintPrompt2.SetItemDecimal(1, "lastpage_no_card", 1);
                        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 shsharemaster set lastline_no_card = 1 where member_no='" + as_member_no + "' and coop_id = '" + state.SsCoopControl + "' ");
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "rePrintShareCard", "rePrintShareCard('" + as_member_no + "')", true);

                    }
                    else
                    {

                        if (state.SsCoopControl != "000501")
                        {
                            HdIsZeroPage.Value = rePage == 0 ? "true" : "false";
                            this.SetOnLoadedScript("parent.ExitIFrame();");

                        }

                    }
                    //}
                    Retrivess();
                    // ooo.Attributes.Add("style", "display:none");
                    HdIsZeroPage.Value = "false";
                    
                }
                catch (Exception ex)
                {
                    // DwPrintPrompt.SetItemDecimal(1, "lastpage_no_pb", 1);
                    LtServerMessage.Text = WebUtil.ErrorMessage(ex);
                }
            }
        }

        private void Retrivess()
        {
            try
            {

                HdAccountNo.Value = Request["mem_no"];
                deptAccountNo = HdAccountNo.Value;
                //DwStm.Retrieve(deptAccountNo, state.SsCoopControl);
                //String xmlInitDwNewBook = dep.InitPrintBook(state.SsWsPass, deptAccountNo, state.SsCoopId);
                DwPrintPrompt2.InsertRow(0);
                //string smltest = DwPrintPrompt.Describe("Datawindow.Data.Xml");
                //DwPrintPrompt.ImportString(xmlInitDwNewBook, Sybase.DataWindow.FileSaveAsType.Xml);
                DwUtil.RetrieveDataWindow(DwPrintPrompt, "sl_contack.pbl", null, state.SsCoopControl, deptAccountNo);
                DwUtil.RetrieveDataWindow(DwDetail, "sl_contack.pbl", null, state.SsCoopControl, deptAccountNo);
                DwUtil.RetrieveDataWindow(DwPrintPrompt2, "sl_print_book.pbl", null, state.SsCoopControl, deptAccountNo);
                DwPrintPrompt.SetItemDecimal(1, "lastrec_no", (DwPrintPrompt.GetItemDecimal(1, "last_stm_no")));
            }
            catch (SoapException ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(WebUtil.SoapMessage(ex));
                DwPrintPrompt.InsertRow(0);
                DwPrintPrompt2.InsertRow(0);
                //DwStm.InsertRow(0);
            }
            catch (Exception ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(ex.Message);
                DwPrintPrompt.InsertRow(0);
                DwPrintPrompt2.InsertRow(0);
                //DwStm.InsertRow(0);
            }
        }

        public void WebDialogLoadEnd()
        {
            DwPrintPrompt.SaveDataCache();
            DwPrintPrompt2.SaveDataCache();
        }

        #endregion
    }
}