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 DataLibrary;
using Sybase.DataWindow;

namespace Saving.Criteria
{
    public partial class u_cri_acc_report_pl : PageWebSheet, WebSheet
    {
        protected String app;
        protected String gid;
        protected String rid;
        protected String pdf;
        protected String runProcess;
        protected String popupReport;
        private DwThDate tdw_criteria;
        protected String changeValue;
        public String outputProcess = "";

        #region WebSheet Members

        public void InitJsPostBack()
        {
            HdOpenIFrame.Value = "False";
            runProcess = WebUtil.JsPostBack(this, "runProcess");
            changeValue = WebUtil.JsPostBack(this, "changeValue");
            tdw_criteria = new DwThDate(dw_criteria, this);
            //tdw_criteria.Add("start_date", "start_tdate");
            //tdw_criteria.Add("end_date", "end_tdate");
            
        }

        //protected void Page_Load(object sender, EventArgs e)
        public void WebSheetLoadBegin()
        {

            this.ConnectSQLCA();
            dw_criteria.SetTransaction(sqlca);
            GetRetrieve();

            if (IsPostBack)
            {
                dw_criteria.RestoreContext();
            }
            else
            {
                //default values.
                dw_criteria.Reset();
                dw_criteria.InsertRow(0);
                DwUtil.RetrieveDDDW(dw_criteria, "moneysheet_code", "criteria.pbl", null);
                //tdw_criteria.Eng2ThaiAllRow();
            }

            try
            {
                app = Request["app"].ToString();
            }
            catch { }
            if (app == null || app == "")
            {
                app = state.SsApplication;
            }
            try
            {
                gid = Request["gid"].ToString();
            }
            catch { }
            try
            {
                rid = Request["rid"].ToString();
            }
            catch { }

            //Report Name.
            try
            {
                Sta ta = new Sta(state.SsConnectionString);
                String sql = "";
                sql = @"SELECT REPORT_NAME  
                    FROM WEBREPORTDETAIL  
                    WHERE ( GROUP_ID = '" + gid + @"' ) AND ( REPORT_ID = '" + rid + @"' )";
                Sdt dt = ta.Query(sql);
                ReportName.Text = dt.Rows[0]["REPORT_NAME"].ToString();
                ta.Close();
            }
            catch
            {
                ReportName.Text = "[" + rid + "]";
            }

            //Link back to the report menu.
            LinkBack.PostBackUrl = String.Format("~/ReportDefault.aspx?app={0}&gid={1}", app, gid);
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "runProcess")
            {
                RunProcess();
            }
            else if (eventArg == "popupReport")
            {
                PopupReport();
            }
            else if (eventArg == "changeValue")
            {
                changeSheet();
            }
        }
        public void SaveWebSheet()
        {
        }

        public void WebSheetLoadEnd()
        {
            if (dw_criteria.RowCount > 1)
            {
                dw_criteria.DeleteRow(dw_criteria.RowCount);
            }
            dw_criteria.SaveDataCache();
        }

        #endregion
        #region Report Process
        private void RunProcess()
        {
            //อ่านค่าจากหน้าจอใส่ตัวแปรรอไว้ก่อน.
            String coop_name = state.SsCoopName;

            String coop_id = state.SsCoopId;
            string str_year_1 = "";
            string str_year_2 = "";
            string str_period_1 = "";
            string str_period_2 = "";
            int flag = 0;
            // String branch_id = "000";
            //แปลง Criteria ให้อยู่ในรูปแบบมาตรฐาน.\
            ReportHelper lnv_helper = new ReportHelper();
            //---------------
            string str_sheet = HdSheetCode.Value.Trim();

            try
            {
                str_year_1 = dw_criteria.GetItemString(1, "year_1");
                str_period_1 = dw_criteria.GetItemString(1, "month_1_1");
                int li_year1 = Convert.ToInt16(str_year_1) - 543;
                if (Convert.ToInt16(str_period_1) < 4)
                {
                    li_year1 = li_year1 - 1;
                }
                DataTable dt = WebUtil.Query("select account_year from accaccountyear where account_year ='" + li_year1 + "'");
                if (dt.Rows.Count > 0)
                {
                    string acc_year1;
                    acc_year1 = dt.Rows[0]["account_year"].ToString();
                }
                else
                {
                    LtServerMessage.Text = WebUtil.ErrorMessage("ไม่พบข้อมูลในปี พ.ศ. " + str_year_1 + "");
                    flag = 1;
                }
            }
            catch
            {
                str_year_1 = "";
            }
            try
            {
                str_year_2 = dw_criteria.GetItemString(1, "year_2");
                str_period_2 = dw_criteria.GetItemString(1, "month_2_1");
                int li_year2 = Convert.ToInt16(str_year_2) - 543;
                if (Convert.ToInt16(str_period_2) < 4)
                {
                    li_year2 = li_year2 - 1;
                }
                DataTable dt2 = WebUtil.Query("select account_year from accaccountyear where account_year ='" + li_year2 + "'");
                if (dt2.Rows.Count > 0)
                {
                    string acc_year2;
                    acc_year2 = dt2.Rows[0]["account_year"].ToString();
                }
                else
                {
                    LtServerMessage.Text = WebUtil.ErrorMessage("ไม่พบข้อมูลในปี พ.ศ. " + str_year_2 + "");
                    flag = 1;
                }

            }
            catch
            {
                str_year_2 = "";
            }
            if (flag == 0)
            {

                string str_month_1 = dw_criteria.GetItemDecimal(1, "month_1").ToString();
                string str_month_2 = dw_criteria.GetItemDecimal(1, "month_2").ToString();
                string str_show_all = dw_criteria.GetItemDecimal(1, "show_all").ToString();
                string str_data_1 = dw_criteria.GetItemDecimal(1, "data_1").ToString();
                string str_data_2 = dw_criteria.GetItemDecimal(1, "data_2").ToString();
                string str_compare_b1_b3 = dw_criteria.GetItemDecimal(1, "compare_b1_b3").ToString();
                string str_show_remark = dw_criteria.GetItemDecimal(1, "show_remark").ToString();
                string str_total_show = dw_criteria.GetItemDecimal(1, "total_show").ToString();
                string percent_status = dw_criteria.GetItemDecimal(1, "percent_status").ToString();

                //--------------
                lnv_helper.AddArgument(str_sheet, ArgumentType.String);
                lnv_helper.AddArgument(str_year_1, ArgumentType.Number);
                lnv_helper.AddArgument(str_year_2, ArgumentType.Number);
                lnv_helper.AddArgument(str_month_1.ToString(), ArgumentType.Number);
                lnv_helper.AddArgument(str_month_2.ToString(), ArgumentType.Number);
                lnv_helper.AddArgument(str_show_all, ArgumentType.Number);
                lnv_helper.AddArgument(str_data_1, ArgumentType.Number);
                lnv_helper.AddArgument(str_data_2, ArgumentType.Number);
                lnv_helper.AddArgument(str_compare_b1_b3, ArgumentType.Number);
                lnv_helper.AddArgument(str_show_remark, ArgumentType.Number);
                lnv_helper.AddArgument(coop_id, ArgumentType.String);
                lnv_helper.AddArgument(str_total_show, ArgumentType.Number);
                lnv_helper.AddArgument(percent_status, ArgumentType.Number);
                //----------------------------------------------------

                if (str_compare_b1_b3 == "1")
                {
                    rid = "[ACM022]";
                }

                //ชื่อไฟล์ PDF = YYYYMMDDHHMMSS_<GID>_<RID>.PDF
                String pdfFileName = DateTime.Now.ToString("yyyyMMddHHmmss", WebUtil.EN);
                pdfFileName += "_" + gid + "_" + rid + ".pdf";
                pdfFileName = pdfFileName.Trim();

                //ส่งให้ ReportService สร้าง PDF ให้ {โดยปกติจะอยู่ใน C:\GCOOP\Saving\PDF\}.
                try
                {
                    //CoreSavingLibrary.WcfReport.ReportClient lws_report = wcf.Report;
                    String criteriaXML = lnv_helper.PopArgumentsXML();
                    //this.pdf = lws_report.GetPDFURL(state.SsWsPass) + pdfFileName;
                    string printer = dw_criteria.GetItemString(1, "printer");
                    outputProcess = WebUtil.runProcessingReport(state, app, gid, rid, criteriaXML, pdfFileName, printer);
                    //String li_return = lws_report.Run(state.SsWsPass, app, gid, rid, criteriaXML, pdfFileName);
                    //if (li_return == "true")
                    //{
                    //    HdOpenIFrame.Value = "True";
                    //}
                }
                catch (Exception ex)
                {
                    LtServerMessage.Text = WebUtil.ErrorMessage(ex);
                    return;
                }
            }
        }
        public void PopupReport()
        {
            //เด้ง Popup ออกรายงานเป็น PDF.
            String pop = "Gcoop.OpenPopup('" + pdf + "')";
            ClientScript.RegisterClientScriptBlock(this.GetType(), "DsReport", pop, true);
        }
        private void changeSheet()
        {
            dw_criteria.Retrieve(HdSheetCode.Value);
        }
        #endregion

        private void GetRetrieve()
        {
            try
            {
                dw_criteria.Reset();
                dw_criteria.Retrieve(HdSheetCode.Value);
                //Response.Write("<script> alert('XML = " + dw_main.GetItemString(1, "month_1_1") + "') </script>");
            }
            catch
            {
                HdSheetCode.Value = "";
            }
        }
    }
}