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 CoreSavingLibrary.WcfCommon;
using DataLibrary;
using CoreSavingLibrary.WcfMis;
using System.Globalization;

namespace Saving.Applications.mis
{
    public partial class w_sheet_gph_payloan_month : PageWebSheet, WebSheet
    {
        private MisClient MisService;
        protected String postMonthRetrieve;
        protected String postQuarterRetrieve;
        protected String postHalfRetrieve;
        protected String postYearRetrieve;




        private void YearRetrieve()
        {
            Int16 li_startyear, li_endyear;

            li_startyear = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "start_year"));
            li_endyear = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "end_year"));

            li_startyear = Convert.ToInt16(li_startyear - 543);
            li_endyear = Convert.ToInt16(li_endyear - 543);

            string[] gph = MisService.InitGphPayOutLoanYear(state.SsWsPass, li_startyear, li_endyear);

            //dw_graph_quar.SetTransaction(SQLCA);
            //dw_graph_quar.Retrieve(li_startyear, li_startquar, li_endyear, li_endquar);
            dw_graph_year.Reset();
            dw_graph_year.ImportString(gph[0], Sybase.DataWindow.FileSaveAsType.Xml);

            //dw_data_quar.SetTransaction(SQLCA);
            //dw_data_quar.Retrieve(li_startyear, li_startquar, li_endyear, li_endquar);
            dw_data_year.Reset();
            dw_data_year.ImportString(gph[1], Sybase.DataWindow.FileSaveAsType.Xml);

            LtChangeTap.Text = "<script>showTabPage('" + HdCurrentTap.Value + "')</script>";
        }

        private void HalfRetrieve()
        {
            Int16 li_startyear, li_endyear;
            Int16 li_starthalf, li_endhalf;

            li_startyear = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "start_year"));
            li_starthalf = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "start_quar"));
            li_endyear = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "end_year"));
            li_endhalf = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "end_quar"));

            li_startyear = Convert.ToInt16(li_startyear - 543);
            li_endyear = Convert.ToInt16(li_endyear - 543);

            string[] gph = MisService.InitGphPayOutLoanHalf(state.SsWsPass, li_starthalf, li_startyear, li_endhalf, li_endyear);

            //dw_graph_quar.SetTransaction(SQLCA);
            //dw_graph_quar.Retrieve(li_startyear, li_startquar, li_endyear, li_endquar);
            dw_graph_half.Reset();
            dw_graph_half.ImportString(gph[0], Sybase.DataWindow.FileSaveAsType.Xml);

            //dw_data_quar.SetTransaction(SQLCA);
            //dw_data_quar.Retrieve(li_startyear, li_startquar, li_endyear, li_endquar);
            dw_data_half.Reset();
            dw_data_half.ImportString(gph[1], Sybase.DataWindow.FileSaveAsType.Xml);

            LtChangeTap.Text = "<script>showTabPage('" + HdCurrentTap.Value + "')</script>";
        }

        private void QuarterRetrieve()
        {
            Int16 li_startyear, li_endyear;
            Int16 li_startquar, li_endquar;

            li_startyear = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "start_year"));
            li_startquar = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "start_quar"));
            li_endyear = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "end_year"));
            li_endquar = Convert.ToInt16(dw_cri_quar.GetItemDecimal(1, "end_quar"));

            li_startyear = Convert.ToInt16(li_startyear - 543);
            li_endyear = Convert.ToInt16(li_endyear - 543);

            string[] gph = MisService.InitGphPayOutLoanQuar(state.SsWsPass, li_startquar, li_startyear, li_endquar, li_endyear);

            //dw_graph_quar.SetTransaction(SQLCA);
            //dw_graph_quar.Retrieve(li_startyear, li_startquar, li_endyear, li_endquar);
            dw_graph_quar.Reset();
            dw_graph_quar.ImportString(gph[0], Sybase.DataWindow.FileSaveAsType.Xml);

            //dw_data_quar.SetTransaction(SQLCA);
            //dw_data_quar.Retrieve(li_startyear, li_startquar, li_endyear, li_endquar);
            dw_data_quar.Reset();
            dw_data_quar.ImportString(gph[1], Sybase.DataWindow.FileSaveAsType.Xml);

            LtChangeTap.Text = "<script>showTabPage('" + HdCurrentTap.Value + "')</script>";
        }

        private void MonthRetrieve()
        {
            //criteria.
            Int16 li_startyear, li_endyear;
            Int16 li_startmonth, li_endmonth;

            li_startyear = Convert.ToInt16(dw_cri_month.GetItemDecimal(1, "start_year"));
            li_startmonth = Convert.ToInt16(dw_cri_month.GetItemDecimal(1, "start_month"));
            li_endyear = Convert.ToInt16(dw_cri_month.GetItemDecimal(1, "end_year"));
            li_endmonth = Convert.ToInt16(dw_cri_month.GetItemDecimal(1, "end_month"));

            li_startyear = Convert.ToInt16(li_startyear - 543);
            li_endyear = Convert.ToInt16(li_endyear - 543);

            string[] gph = MisService.InitGphPayOutLoanMonth(state.SsWsPass, li_startmonth, li_startyear, li_endmonth, li_endyear);

            //ข้อมูลใส่กราฟ.           
            //dw_graph.SetTransaction(SQLCA);
            //dw_graph.Retrieve(li_startyear, li_startmonth, li_endyear, li_endmonth);
            dw_graph_month.Reset();
            dw_graph_month.ImportString(gph[0], Sybase.DataWindow.FileSaveAsType.Xml);

            ////ดึงข้อมูลใส่ตาราง.           
            //dw_data.SetTransaction(SQLCA);
            //dw_data.Retrieve(li_startyear, li_startmonth, li_endyear, li_endmonth);
            dw_data_month.Reset();
            dw_data_month.ImportString(gph[1], Sybase.DataWindow.FileSaveAsType.Xml);
        }

        #region WebSheet Members

        public void InitJsPostBack()
        {
            postMonthRetrieve = WebUtil.JsPostBack(this, "postMonthRetrieve");
            postQuarterRetrieve = WebUtil.JsPostBack(this, "postQuarterRetrieve");
            postHalfRetrieve = WebUtil.JsPostBack(this, "postHalfRetrieve");
            postYearRetrieve = WebUtil.JsPostBack(this, "postYearRetrieve");
        }

        public void WebSheetLoadBegin()
        {
            MisService = wcf.Mis;

            if (!IsPostBack)
            {
                //Initial values.    
                dw_cri_month.InsertRow(0);
                dw_cri_month.SetItemDecimal(1, "start_year", 2552);
                dw_cri_month.SetItemDecimal(1, "end_year", 2553);
                dw_cri_month.SetItemDecimal(1, "start_month", 1);
                dw_cri_month.SetItemDecimal(1, "end_month", 6);

                dw_cri_quar.InsertRow(0);
                dw_cri_quar.SetItemDecimal(1, "start_year", 2553);
                dw_cri_quar.SetItemDecimal(1, "end_year", 2553);
                dw_cri_quar.SetItemDecimal(1, "start_quar", 1);
                dw_cri_quar.SetItemDecimal(1, "end_quar", 4);

                dw_cri_half.InsertRow(0);
                dw_cri_half.SetItemDecimal(1, "start_half", 1);
                dw_cri_half.SetItemDecimal(1, "start_year", 2552);
                dw_cri_half.SetItemDecimal(1, "end_half", 2);
                dw_cri_half.SetItemDecimal(1, "end_year", 2553);

                dw_cri_year.InsertRow(0);
                dw_cri_year.SetItemDecimal(1, "start_year", 2552);
                dw_cri_year.SetItemDecimal(1, "end_year", 2553);
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "postMonthRetrieve")
            {
                MonthRetrieve();
            }
            else if (eventArg == "postQuarterRetrieve")
            {
                QuarterRetrieve();
            }
            else if (eventArg == "postHalfRetrieve")
            {
                HalfRetrieve();
            }
            else if (eventArg == "postYearRetrieve")
            {
                YearRetrieve();
            }
        }

        public void SaveWebSheet()
        {
            throw new NotImplementedException();
        }

        public void WebSheetLoadEnd()
        {
            dw_cri_month.SaveDataCache();
            dw_cri_quar.SaveDataCache();
            dw_cri_half.SaveDataCache();
            dw_cri_year.SaveDataCache();

            dw_data_month.SaveDataCache();
            dw_data_quar.SaveDataCache();
            dw_data_half.SaveDataCache();
            dw_data_year.SaveDataCache();

            dw_graph_month.SaveDataCache();
            dw_graph_quar.SaveDataCache();
            dw_graph_half.SaveDataCache();
            dw_graph_year.SaveDataCache();
        }

        #endregion
    }
}