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

namespace Saving.CriteriaIReport.u_cri_loancontract
{
    public partial class u_cri_loancontract : PageWebReport, WebReport
    {
        protected String app;
        protected String gid;
        protected String rid;
        [JsPostBack]
        public string ShowData { get; set; }
        CultureInfo th = System.Globalization.CultureInfo.GetCultureInfo("th-TH");
        public void InitJsPostBack()
        {
            
        }

        public void WebSheetLoadBegin()
        {
            //--- Page Arguments
            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 + "]";
            }

            if (!IsPostBack)
            {
                

            }
            

        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "ShowData")
            {
                Sdt d = WebUtil.QuerySdt(@"select mbmembmaster.member_no, 
                                 mbucfprename.prename_desc||   
                                 mbmembmaster.memb_name||' '||
                                 mbmembmaster.memb_surname as cp_name
                                 
                            from mbmembmaster,   
                                 mbucfprename ,lncontmaster
                           where ( mbucfprename.prename_code = mbmembmaster.prename_code ) and  
                                 ( mbmembmaster.member_no = lncontmaster.member_no )and                              
                                 ( ( lncontmaster.loancontract_no = '" + Hdloan.Value + "' ) )  ");
                if (d.Next())
                {
                    TextBox2.Text = d.GetString("cp_name");
                }
                TextBox1.Text = Hdloan.Value;
            }
        }

        public void RunReport()
        {
            try
            {
                iReportArgument arg = new iReportArgument();
                arg.Add("loancontract_no", iReportArgumentType.String, TextBox1.Text);
                iReportBuider report = new iReportBuider(this, arg);
                report.Retrieve();
            }
            catch (Exception ex)
            {
                LtServerMessage.Text = WebUtil.ErrorMessage(ex);
            }


        }
       
     
        public void WebSheetLoadEnd()
        {

        }
    }
}