using System;
using CoreSavingLibrary;
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.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using Sybase.DataWindow;
using DataLibrary;
using CoreSavingLibrary.WcfNKeeping;
using CoreSavingLibrary.WcfNShrlon;
using System.Web.Services.Protocols;
using System.Globalization;


namespace Saving.Applications.keeping
{
    public partial class w_sheet_kp_proc_gen_book : PageWebSheet, WebSheet
    {
        CultureInfo th = System.Globalization.CultureInfo.GetCultureInfo("th-TH");
        //ประกาศตัวแปร
        #region Variable
        //private n_keepingClient KeepingService;
        private n_shrlon NshrlonService;
        protected String postNewClear;
        protected String postRefresh;
        private DwThDate tDwOption;
        [JsPostBack]
        public String postGenbook { get; set; }


        //mikekong new process
        public string outputProcess;
        #endregion
        //============================================

        #region Websheet Members
        public void InitJsPostBack()
        {
            tDwOption = new DwThDate(Dw_option, this);
            tDwOption.Add("calintto_date", "calintto_tdate");
            tDwOption.Add("sendbook_date", "sendbook_tdate");
            tDwOption.Add("start_date", "start_tdate");



            //=========================================
            postNewClear = WebUtil.JsPostBack(this, "postNewClear");
            postRefresh = WebUtil.JsPostBack(this, "postRefresh");
            postGenbook = WebUtil.JsPostBack(this, "postGenbook");
        }

        public void WebSheetLoadBegin()
        {
            Hd_process.Value = "false";
            if (!IsPostBack)
            {
                JspostNewClear();
                WebUtil.RetrieveDDDW(Dw_option, "start_group", "sl_shlnproc", state.SsCoopControl);
                WebUtil.RetrieveDDDW(Dw_option, "end_group", "sl_shlnproc", state.SsCoopControl);
                WebUtil.RetrieveDDDW(Dw_option, "mem_start", "sl_shlnproc", null);
                WebUtil.RetrieveDDDW(Dw_option, "mem_end", "sl_shlnproc", state.SsCoopControl);
            }
            else
            {
                this.RestoreContextDw(Dw_option);
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
            // Event ที่เกิดจาก JavaScript
            /*switch (eventArg)
            {
                case "postNewClear":
                    JspostNewClear();
                    break;
                case "postRefresh":
                    //Refresh();
                    break;
                case "postGenbook":
                    JspostGenbook();
                    break;
            }*/

            if (eventArg == "postNewClear")
            {
                JspostNewClear();

            }
            else if (eventArg == "postRefresh")
            {

            }
            else if (eventArg == "postGenbook")
            {
                JspostGenbook();
            }
        }

        public void SaveWebSheet()
        {

        }

        public void WebSheetLoadEnd()
        {
            Dw_option.SaveDataCache();
        }
        #endregion
        //=============================================
        // function เคลียร์หน้าจอ
        private void JspostNewClear()
        {
            string manager = "";

            Dw_option.Reset();
            Dw_option.InsertRow(0);
            

            string sql = @"select manager
                from cmcoopconstant";

            sql = WebUtil.SQLFormat(sql);
            Sdt dt = WebUtil.QuerySdt(sql);
            if (dt.Next())
            {
                manager = dt.GetString("manager");
  
            }

            Dw_option.SetItemString(1, "manager", manager);
            Dw_option.SetItemString(1, "position", "ผู้จัดการ");
            Dw_option.SetItemDate(1, "calintto_date", state.SsWorkDate);
            Dw_option.SetItemDate(1, "sendbook_date", state.SsWorkDate);
            Dw_option.SetItemDate(1, "start_date", state.SsWorkDate);


            /*CultureInfo th = System.Globalization.CultureInfo.GetCultureInfo("th-TH");
            DateTime today = Convert.ToDateTime(state.SsWorkDate);
            //DateTime day = state.SsWorkDate;
            String dayss = "31/03/" + today.Year;

            today = DateTime.ParseExact(dayss, "dd/MM/yyyy", CultureInfo.InvariantCulture);

            Dw_option.SetItemString(1, "calintto_tdate", (today).ToString("ddMMyyyy", th));
            Dw_option.SetItemString(1, "sendbook_tdate", (today).ToString("ddMMyyyy", th));
            Dw_option.SetItemString(1, "start_tdate", (today).ToString("ddMMyyyy", th));*/


            tDwOption.Eng2ThaiAllRow();

        }


        private void JspostGenbook()
        {


            try
            {
                NshrlonService = wcf.NShrlon;
                String dwMain_XML = Dw_option.Describe("DataWindow.Data.XML");
                int r = wcf.NShrlon.of_proc_genbookloan(state.SsWsPass, state.SsCoopControl, dwMain_XML);
                if (r > 0)
                {
                    LtServerMessage.Text = WebUtil.CompleteMessage("ผ่าน");

                }
                else
                {

                    LtServerMessage.Text = WebUtil.ErrorMessage("ไม่ผ่าน");
                }

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

        
    }
}