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

namespace Saving.Applications.mbshr.ws_mbshr_member_detail_ctrl
{
    public partial class DsEtcpaymonth : DataSourceRepeater
    {
        public DataSet1.DT_ETCPAYMONTHDataTable DATA { get; set; }

        public void InitDsEtepaymonth(PageWeb pw)
        {
            cp_receipt_no.Text = "";
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.DT_ETCPAYMONTH;
            this.EventItemChanged = "OnDsEtcpaymonthItemChanged";
            this.EventClicked = "OnDsEtcpaymonthClicked";
            this.InitDataSource(pw, Repeater1, this.DATA, "dsEtcpaymonth");
            this.Register();
        }

        public void RetrieveEtepaymonth(String ls_member_no, String ls_recvpd)
        {
            String sql = @"  
                  SELECT KPTEMPRECEIVEDET.MEMBER_NO,   
                         KPTEMPRECEIVE.RECEIPT_NO,   
                         KPTEMPRECEIVEDET.RECV_PERIOD,  
                         KPTEMPRECEIVEDET.KEEPITEMTYPE_CODE,   
                         KPTEMPRECEIVEDET.DESCRIPTION,   
                         KPTEMPRECEIVEDET.PERIOD,   
                         KPTEMPRECEIVEDET.PRINCIPAL_PAYMENT,   
                         KPTEMPRECEIVEDET.INTEREST_PAYMENT,   
                         KPTEMPRECEIVEDET.ITEM_PAYMENT,   
                         KPTEMPRECEIVEDET.LOANCONTRACT_NO,   
                         KPTEMPRECEIVE.KEEPING_STATUS,   
                         KPTEMPRECEIVEDET.KEEPITEM_STATUS,   
                         KPTEMPRECEIVEDET.REF_MEMBNO,   
                         KPTEMPRECEIVE.MEMBER_NO,   
                         KPUCFKEEPITEMTYPE.SORT_IN_RECEIVE,   
                         KPTEMPRECEIVEDET.ITEM_BALANCE,   
                         KPTEMPRECEIVEDET.SHRLONTYPE_CODE,   
                         KPUCFKEEPITEMTYPE.SIGN_FLAG  
                    FROM KPTEMPRECEIVE,   
                         KPTEMPRECEIVEDET,   
                         KPUCFKEEPITEMTYPE  
                   WHERE ( KPTEMPRECEIVE.KPSLIP_NO = KPTEMPRECEIVEDET.KPSLIP_NO ) and  
                         ( KPTEMPRECEIVEDET.KEEPITEMTYPE_CODE = KPUCFKEEPITEMTYPE.KEEPITEMTYPE_CODE ) and  
                         ( KPTEMPRECEIVE.COOP_ID = KPTEMPRECEIVEDET.COOP_ID ) and  
                         ( KPTEMPRECEIVE.COOP_ID = KPUCFKEEPITEMTYPE.COOP_ID ) and  
                         ( ( kptempreceive.member_no = {0} ) AND  
                         ( kptempreceivedet.keepitemtype_code <> 'ETN' ) )   
		                AND kptempreceive.recv_period = {1}";

            sql = WebUtil.SQLFormat(sql, ls_member_no, ls_recvpd);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
            if (ls_recvpd != "")
            {
                cp_receipt_no.Text = this.DATA[0].cp_receipt_no;
            }
            else
            {
                cp_receipt_no.Text = "";
            }

        }

        public TextBox TContract
        {
            get { return this.cp_sum_principal_payment; }
        }
        public TextBox TContract2
        {
            get { return this.cp_sum_interest_payment; }
        }
        public TextBox TContract3
        {
            get { return this.cp_sum_item_payment; }
        }
    }
}