using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//using CoreSavingLibrary.WcfNShrlon;
using CoreSavingLibrary.WcfNShrlon;
using Sybase.DataWindow;
using System.Web.Services.Protocols;
using DataLibrary;
using System.Data;
using System.Globalization;

namespace Saving.Applications.shrlon
{
    public partial class ConvertStatement : PageWebSheet, WebSheet
    {
        Sta ta;
        public void InitJsPostBack()
        {

        }
        public void WebSheetLoadBegin()
        {

            try
            {
                this.ConnectSQLCA();
                ta = new Sta(sqlca.ConnectionString);
                sqlca = new DwTrans();
                sqlca.Connect();


              

                if (IsPostBack)
                {
                     

                }
                else
                {

                     
                }


            }
            catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex.ToString()); }
        }
        public void WebSheetLoadEnd()
        {
            
        }

      public void SaveWebSheet()
        {

        }
      public void CheckJsPostBack(string eventArg)
      {
      }

        protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {
                // update statement
//                Sdt d = WebUtil.QuerySdt(@"select bffine_arrear,bfint_preiod, fine_payment, bffineyear_amt ,loancontract_no,seq_no,
//                bffine_preiod, bfintarrear_amt ,interest_payment,bfintyeararr_amt from lncontstatement 
//                where 
//                bffine_arrear>0 or bfint_preiod>0 or fine_payment>0 or bffineyear_amt >0 or bffine_preiod>0 or bfintarrear_amt >0 or interest_payment>0 or bfintyeararr_amt>0");
                Sdt d = WebUtil.QuerySdt(@"select bffine_arrear,bfint_preiod, fine_payment, bffineyear_amt ,loancontract_no,seq_no,
                bffine_preiod, bfintarrear_amt ,interest_payment,bfintyeararr_amt from lncontstatement 
                where slip_date >= to_date('01062017','ddmmyyyy')            ");
               
                while (d.Next())
                {
                    decimal fine_arrear = 0, fine_period = 0, bffine_arrear = 0, fine_payment = 0, bffineyear_amt = 0, bffine_preiod = 0, bfintarrear_amt = 0, interest_payment = 0, bfintyeararr_amt = 0, interest_arrear = 0, bfint_preiod = 0, interest_period = 0;

                    bffine_arrear = d.GetDecimal("bffine_arrear");
                    bfint_preiod = d.GetDecimal("bfint_preiod");
                    fine_payment = d.GetDecimal("fine_payment");
                    bffineyear_amt = d.GetDecimal("bffineyear_amt");
                    bfintarrear_amt = d.GetDecimal("bfintarrear_amt");
                    interest_payment = d.GetDecimal("interest_payment");
                    bfintyeararr_amt = d.GetDecimal("bfintyeararr_amt");




                    //gen ปรับขาด
                    if (bffine_arrear <= 0)
                    {
                        fine_arrear = 0;
                    }
                    else
                    {
                        if (fine_payment > bffineyear_amt)
                        {
                            if (fine_payment > bffine_arrear)
                            {
                                fine_arrear = (bffine_arrear - bffineyear_amt);
                            }
                            else
                            {
                                fine_arrear = (fine_payment - bffineyear_amt);
                            }
                        }
                        else
                        {
                            fine_arrear = 0;
                        }
                    }
                    // End Gen ปรับขาด

                    //gen ปรับใหม่
                    if (bffine_preiod <= 0)
                    {
                        fine_period = 0;
                    }
                    else
                    {
                        if (fine_payment - bffine_arrear > 0)
                        {
                            fine_period = (fine_payment - bffine_arrear);
                        }
                        else
                        {
                            fine_period = 0;
                        }
                    }
                    // End Gen ปรับใหม่

                    //gen ดอกเบี้ยขาด
                    if (bfintarrear_amt <= 0)
                    {
                        interest_arrear = 0;
                    }
                    else
                    {
                        if (interest_payment > bfintyeararr_amt)
                        {
                            if (interest_payment > bfintarrear_amt)
                            {
                                interest_arrear = (bfintarrear_amt - bfintyeararr_amt);
                            }
                            else
                            {
                                interest_arrear = (interest_payment - bfintyeararr_amt);
                            }
                        }
                        else
                        {
                            interest_arrear = 0;

                        }
                    }// End Gen ดอกเบี้ยขาด

                    //Gen ดอกเบี้ยใหม่
                    if (bfint_preiod <= 0)
                    {
                        interest_period = 0;
                    }
                    else
                    {
                        if ((interest_payment - bfintarrear_amt) > 0)
                        {
                            interest_period = (interest_payment - bfintarrear_amt);
                        }
                        else
                        {
                            interest_period = 0;
                        }
                    }// End Gen ดอกเบี้ยใหม่

                    WebUtil.QuerySdt("update lncontstatement set interest_arrear = " + interest_arrear + "   , interest_period= " + interest_period + " , fine_arrear=" + fine_arrear + "  ,fine_period=" + fine_period + " where loancontract_no='" + d.GetString("loancontract_no") + "' and seq_no=" + d.GetInt32("seq_no") + " ");

                }
                LtServerMessage.Text = "สำเร็จ";
            }
            catch (Exception ex)
            {
                LtServerMessage.Text = " ผิดพลาด"+ex.ToString();
            }
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            string collmast_no = "";
            // update หลักทรัพย์
            
                Sdt c = WebUtil.QuerySdt("select * from lncolldetail   ");
            while (c.Next())
            {
                collmast_no= c.GetString("collmast_no");
                int size_rai = 0,  size_ngan = 0;
                decimal size_wa = 0, mortgage_count = 0, first_mrtg_amt = 0, secound_mrtg_amt = 0, old_mrtg_amt = 0, this_mrtg_amt = 0;
                //try
                //{
                //    size_rai = c.GetInt32("size_rai");
                //}
                //catch (Exception ew)
                //{
                //    size_rai = 0;
                //}
                //try
                //{
                //    size_wa = c.GetDecimal("size_wa");
                //}
                //catch (Exception ew)
                //{
                //    size_wa = 0;
                //}
                //try
                //{
                //    size_ngan = c.GetInt32("size_ngan");
                //}
                //catch (Exception ew)
                //{
                //    size_ngan = 0;
                //}
                //WebUtil.QuerySdt("update lncollmaster set size_rai = " + size_rai + "   , size_wa= " + size_wa + " , size_ngan=" + size_ngan + " where collmast_no='" + c.GetString("collmast_no") + "'  ");
            
                mortgage_count = c.GetDecimal("mortgage_count"); first_mrtg_amt = c.GetDecimal("first_mrtg_amt"); secound_mrtg_amt = c.GetDecimal("secound_mrtg_amt");
                old_mrtg_amt = c.GetDecimal("old_mrtg_amt"); this_mrtg_amt = c.GetDecimal("this_mrtg_amt");

                WebUtil.QuerySdt("update lncollmaster set mortgage_count = " + mortgage_count + ",first_mrtg_amt = " + first_mrtg_amt + ",secound_mrtg_amt = " + secound_mrtg_amt + " ,old_mrtg_amt = " + old_mrtg_amt + ",this_mrtg_amt = " + this_mrtg_amt + " where collmast_no='" + c.GetString("collmast_no") + "'  ");
            
                }
            
             
        }

        protected void Button3_Click(object sender, EventArgs e)
        {
            try
            {
                Sdt c = WebUtil.QuerySdt("select * from lnreqloan   where loanobjective_code1 is not null and loanobjective_amt1 is not null   ");
                while (c.Next())
                {


                    WebUtil.QuerySdt("insert into lncontobjective(coop_id,loancontract_no,loanrequest_docno,loanobjective_code,objective_amt) values " +
                        " ('" + state.SsCoopControl + "','" + c.GetString("loancontract_no") + "','" + c.GetString("loanrequest_docno") + "','" + c.GetString("loanobjective_code1") + "','" + c.GetDecimal("loanobjective_amt1") + "' ) ");
                    if (c.GetDecimal("loanobjective_amt2") > 0)
                    {
                        WebUtil.QuerySdt("insert into lncontobjective(coop_id,loancontract_no,loanrequest_docno,loanobjective_code,objective_amt) values " +
                       " ('" + state.SsCoopControl + "','" + c.GetString("loancontract_no") + "','" + c.GetString("loanrequest_docno") + "','" + c.GetString("loanobjective_code2") + "','" + c.GetDecimal("loanobjective_amt2") + "' ) ");
                    }
                    if (c.GetDecimal("loanobjective_amt3") > 0)
                    {
                        WebUtil.QuerySdt("insert into lncontobjective(coop_id,loancontract_no,loanrequest_docno,loanobjective_code,objective_amt) values " +
                       " ('" + state.SsCoopControl + "','" + c.GetString("loancontract_no") + "','" + c.GetString("loanrequest_docno") + "','" + c.GetString("loanobjective_code3") + "','" + c.GetDecimal("loanobjective_amt3") + "' ) ");
                    }
                   
                }

                WebUtil.QuerySdt(@"UPDATE lncontobjective
SET loanobjective_desc = (SELECT b.loanobjective_desc
                     FROM lnucfloanobjective b
                     WHERE   trim( lncontobjective.loanobjective_code) =  trim( b.loanobjective_code)   )
WHERE EXISTS (SELECT b.loanobjective_desc
              FROM lnucfloanobjective b
              WHERE    trim( lncontobjective.loanobjective_code) = trim(  b.loanobjective_code)  ) ");
                LtServerMessage.Text = "สำเร็จ";
            }
            catch (Exception ex)
            {
                LtServerMessage.Text = " ผิดพลาด" + ex.ToString();
            }
        }
    }
}