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

namespace Saving.Applications.shrlon.ws_sl_loan_edit_ctrl
{
    public partial class DsContdetail : DataSourceRepeater
    {
        public DataSet1.LNCONTMASTERDataTable DATA { get; set; }

        public void InitDsContdetail(PageWeb pw)
        {
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.LNCONTMASTER;
            this.InitDataSource(pw, Repeater2, this.DATA, "dsContdetail");
            this.EventItemChanged = "OnDsContdetailItemChanged";
            this.EventClicked = "OnDsContdetailClicked";
            this.Register();
        }

        public void Retrieve( string loancontract_no)
        {
            string sql = @" SELECT     LNCONTMASTER.LOANCONTRACT_NO ,   
        LNCONTMASTER.MEMBER_NO ,           LNCONTMASTER.LOANTYPE_CODE ,           LNCONTMASTER.LOANOBJECTIVE_CODE ,      
     LNCONTMASTER.LOANREQUEST_DOCNO ,           LNCONTMASTER.LOANREQUEST_AMT ,           LNCONTMASTER.LOANAPPROVE_DATE ,       
    LNCONTMASTER.LOANAPPROVE_AMT ,           LNCONTMASTER.WITHDRAWABLE_AMT ,           LNCONTMASTER.STARTCONT_DATE ,        
   LNCONTMASTER.PRINCIPAL_BALANCE ,           LNCONTMASTER.LOANPAYMENT_TYPE ,           LNCONTMASTER.PERIOD_PAYAMT ,      
     LNCONTMASTER.PERIOD_PAYMENT ,           LNCONTMASTER.PERIOD_PAYMENT_MAX ,           LNCONTMASTER.PAYMENT_STATUS ,     
      LNCONTMASTER.LAST_PERIODRCV ,           LNCONTMASTER.LAST_PERIODPAY ,           LNCONTMASTER.LASTRECEIVE_DATE ,    
       LNCONTMASTER.LASTPAYMENT_DATE ,           LNCONTMASTER.LASTCALINT_DATE ,           LNCONTMASTER.LASTKEEPING_DATE ,  
     LNCONTMASTER.LASTPROCESS_DATE ,           LNCONTMASTER.PRINCIPAL_ARREAR ,        
 case when  LNCONTMASTER.INTEREST_ARREAR > LNCONTMASTER.INTYEAR_ARREAR then LNCONTMASTER.INTEREST_ARREAR - LNCONTMASTER.INTYEAR_ARREAR 
  else 0 end as INTEREST_ARREAR ,
 case when  LNCONTMASTER.FINE_ARREAR > LNCONTMASTER.FINEYEAR_ARREAR then LNCONTMASTER.FINE_ARREAR - LNCONTMASTER.FINEYEAR_ARREAR 
  else 0 end as FINE_ARREAR, 
      LNCONTMASTER.INTMONTH_ARREAR ,           LNCONTMASTER.INTYEAR_ARREAR ,           LNCONTMASTER.INTEREST_ACCUM ,      
     LNCONTMASTER.INTACCUM_LASTYEAR ,           LNCONTMASTER.INTPAYMENT_AMT ,           LNCONTMASTER.INTEREST_RETURN ,  
         LNCONTMASTER.LAST_STM_NO ,           LNCONTMASTER.LAST_TRANSCONT_NO ,           LNCONTMASTER.TRANSFER_STATUS ,   
   LNCONTMASTER.PRINCIPAL_TRANS ,           LNCONTMASTER.TRNFROM_CONTNO ,           LNCONTMASTER.TRNFROM_MEMNO ,           LNCONTMASTER.CONTRACT_TIME ,           LNCONTMASTER.EXPIRECONT_DATE ,           LNCONTMASTER.CLOSECONT_DATE ,     

     LNCONTMASTER.EXPENSE_CODE ,           LNCONTMASTER.EXPENSE_BANK ,           LNCONTMASTER.EXPENSE_BRANCH ,           LNCONTMASTER.EXPENSE_ACCID ,  
         LNCONTMASTER.NKEEP_PRINCIPAL ,           LNCONTMASTER.NKEEP_INTEREST ,           LNCONTMASTER.RKEEP_PRINCIPAL ,           LNCONTMASTER.RKEEP_INTEREST ,
           LNCONTMASTER.COMPOUND_STATUS ,           LNCONTMASTER.COMPOUND_DATE ,           LNCONTMASTER.COMPOUND_PERIOD ,       
       LNCONTMASTER.STARTKEEP_PERIOD ,           LNCONTMASTER.BUYSHARE_AMT ,           LNCONTMASTER.RECEIVEPERIOD_FLAG ,       
    LNCONTMASTER.MISSPAY_AMT ,           LNCONTMASTER.PRNCBALBEGIN_AMT ,           LNCONTMASTER.OD_FLAG ,           LNCONTMASTER.CONTRACT_TYPE ,    
       LNCONTMASTER.CONTRACT_STATUS ,           LNCONTMASTER.APPROVE_ID ,                LNCONTMASTER.PRINCIPAL_RETURN ,  
             LNCONTMASTER.LASTACCESS_DATE ,           LNCONTMASTER.REMARK ,           LNCONTMASTER.SUMINT_LASTYEAR ,   
        LNCONTMASTER.STARTKEEP_DATE ,       
        LNCONTMASTER.FINEYEAR_ARREAR ,    BFPRINCIPALYEAR_ARREAR, BFINTERESTYEAR_ARREAR , BFFINEYEAR_ARREAR ,    
  INTCOMPENSATE_FLAG ,      
 0 as FINE_RETURN ,
    LNCONTMASTER.CONTCOUNT,  LNCONTMASTER.CONTCOUNT_END, 
 case  when   LNCONTMASTER.CONTRACT_INTEREST = -1 then (select lncfloanintratedet.interest_rate from lncfloanintratedet left join  lnloantype on lnloantype.inttabfix_code = lncfloanintratedet.loanintrate_code 
                left join lncontmaster on lncontmaster.loantype_code=lnloantype.loantype_code where lncontmaster.loancontract_no= LNCONTMASTER.loancontract_no  and rownum<=1 and  LNCONTMASTER.LOANCONTRACT_NO  = {1})                          
else  LNCONTMASTER.contract_interest end   as CONTRACT_INTEREST
 , LNLOANTYPE.USEMANGRT_COMAXVALUE  as SUBPERIOD_AMT
FROM LNCONTMASTER  inner join LNLOANTYPE  on   LNLOANTYPE.LOANTYPE_CODE  =  LNCONTMASTER.LOANTYPE_CODE     
  where  LNCONTMASTER.LOANCONTRACT_NO  = {1} and LNCONTMASTER.coop_id={0} ";
            sql = WebUtil.SQLFormat(sql, state.SsCoopControl,  loancontract_no);
            DataTable dt = WebUtil.Query(sql);

            this.ImportData(dt);

            //DdSuspect();
            //Ddlawtype();
            //Ddworkstep();
            //Dddebtclass();
            //Ddlawset();
        }
        public void DdLOANType()
        {
            string sql = @" 
              	     SELECT  LOANTYPE_CODE,LOANTYPE_CODE||' '||LOANTYPE_DESC as LOANTYPE_DESC ,1 as sorter 
                FROM lnloantype  
                 
                union
                select '' as LOANTYPE_CODE,'เลือกประเภทเงินกู้' as LOANTYPE_DESC,0 as sorter   from dual order by sorter, LOANTYPE_CODE 
            ";

            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "LOANTYPE_CODE", "LOANTYPE_DESC", "LOANTYPE_CODE");
        }
        public void DdObj()
        {
            string sql = @" 
              	     SELECT  LOANOBJECTIVE_CODE,LOANOBJECTIVE_DESC ,1 as sorter 
                FROM lnucfloanobjective  
                 
                union
                select '' as LOANOBJECTIVE_CODE,'เลือกประเภทเงินกู้' as LOANOBJECTIVE_DESC,0 as sorter   from dual order by sorter, LOANOBJECTIVE_CODE 
            ";

            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "LOANOBJECTIVE_CODE", "LOANOBJECTIVE_DESC", "LOANOBJECTIVE_CODE");
        }
       
 
  
    }
}