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.shrlon.ws_sl_law_cancle_ctrl
{
    public partial class DsContlist : DataSourceRepeater
    {
        public DataSet1.DT_CONTLISTDataTable DATA { get; set; }

        public void InitDsContlist(PageWeb pw)
        {
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.DT_CONTLIST;
            this.EventItemChanged = "OnDsContlistItemChanged";
            this.EventClicked = "OnDsContlistClicked";
            this.InitDataSource(pw, Repeater1, this.DATA, "dsContlist");
            this.TableName = "LNNPLTRACKINGCONT";
            
            this.Register();
        }

        public void Retrieve(string tracking_no)
        {
            String sql = @"select lnnpltrackingcont.*,
                                    lncontmaster.principal_balance
                            from lnnpltrackingcont,   
                                 lncontmaster  
                            where ( lnnpltrackingcont.coop_id = lncontmaster.coop_id ) and  
                                  ( lnnpltrackingcont.loancontract_no = lncontmaster.loancontract_no ) and
                             (lnnpltrackingcont.coop_id = {0}) and
                             (lnnpltrackingcont.tracking_no = {1})";
            sql = WebUtil.SQLFormat(sql, state.SsCoopControl, tracking_no);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }
    }
}