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

namespace Saving.CriteriaIReport.checkcalintto
{
    public partial class checkcalintto : PageWebReport, WebReport
    {

        public void InitJsPostBack()
        {
            dsMain.InitDsMain(this);
        }

        public void WebSheetLoadBegin()
        {
            if (!IsPostBack)
            {
                dsMain.DdCoopId();
                dsMain.DATA[0].adtm_calto = state.SsWorkDate;
            }
        }

        public void CheckJsPostBack(string eventArg)
        {

        }

        public void RunReport()
        {

            //CREATE TABLE report_check_calintto (loancontract_no varchar(10) NOT NULL, seq_no varchar(3) NOT NULL, calinto_master date , calintto_statement date ) ;


            try
            {

                string sqldelete = @"delete  from report_check_calintto";
                sqldelete = WebUtil.SQLFormat(sqldelete);
                WebUtil.QuerySdt(sqldelete);


                string sql2_master = @"select * from  lncontmaster where  principal_balance >0";
                sql2_master = WebUtil.SQLFormat(sql2_master);
                Sdt dt_master = WebUtil.QuerySdt(sql2_master);
                while (dt_master.Next())
                {

                    string sql = @"select   loancontract_no,max(seq_no) as seq_no  from lncontstatement
                               where loanitemtype_code not in ('B/F') and  item_status =1 and loancontract_no={0} group by loancontract_no";

                    sql = WebUtil.SQLFormat(sql, dt_master.GetString("loancontract_no"));
                    Sdt dt = WebUtil.QuerySdt(sql);



                    if (dt.Next())
                    {

                        string sql_statement = "select loancontract_no,seq_no,calint_to from  lncontstatement where  loancontract_no ={0} and seq_no={1}";

                        sql_statement = WebUtil.SQLFormat(sql_statement, dt.GetString("loancontract_no"), dt.GetString("seq_no"));
                        Sdt dt_statement = WebUtil.QuerySdt(sql_statement);

                        if (dt_statement.Next())
                        {

                            string loancontract_no = dt_statement.GetString("loancontract_no");
                            string sql2 = @"select * from  lncontmaster where  loancontract_no ={0}";
                            sql2 = WebUtil.SQLFormat(sql2, dt_statement.GetString("loancontract_no"));
                            Sdt dt2 = WebUtil.QuerySdt(sql2);

                            if (dt2.Next())
                            {
                                if (dt_statement.GetDate("calint_to") != dt2.GetDate("lastcalint_date"))
                                {
                                    string insert = @"insert into report_check_calintto(loancontract_no,seq_no,calinto_master,calintto_statement) values({0},{1},{2},{3})";
                                    insert = WebUtil.SQLFormat(insert, dt_statement.GetString("loancontract_no"), dt_statement.GetString("seq_no"), dt2.GetDate("lastcalint_date"), dt_statement.GetDate("calint_to"));
                                    WebUtil.QuerySdt(insert);
                                }

                            }

                        }
                    }
                }

            }
            catch { 
            
            
            }

        
            //try
            //{
            //    String coop_id = state.SsCoopId;
            //    DateTime adtm_calto = dsMain.DATA[0].adtm_calto;
              
            //    iReportArgument arg = new iReportArgument();

            //    arg.Add("coop_id", iReportArgumentType.String, coop_id);
            //    arg.Add("adtm_calto", iReportArgumentType.Date, adtm_calto);


            //    iReportBuider report = new iReportBuider(this, arg);
            //    report.Retrieve();
            //}
            //catch (Exception ex)
            //{
            //    LtServerMessage.Text = WebUtil.ErrorMessage(ex);
            //}

        }

        public void WebSheetLoadEnd()
        {

        }
    }
}