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_npl_sue_baac_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.DT_MAINDataTable DATA { get; set; }

        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.DT_MAIN;
            this.InitDataSource(pw, FormView1, this.DATA, "dsMain");
            this.EventItemChanged = "OnDsMainItemChanged";
            this.EventClicked = "OnDsMainClicked";
            this.TableName = "LNNPLSUE";
            this.Button.Add("b_search");
            this.Register();
        }

        public void Retrieve()
        {
            string sql = @" select  mbucfprename.prename_desc ,
                                    mbmembmaster.memb_name ,
                                    mbmembmaster.memb_surname ,
                                    lnnplsue.coop_id ,
                                    lnnplsue.sue_no ,
                                    lnnplsue.memcoop_id ,
                                    lnnplsue.member_no ,
                                    lnnplsue.sue_date ,
                                    lnnplsue.lawset_status,
                                    lnnplsue.mav_status ,
                                    lnnplsue.mavtrn_status,
                                    lnnplsue.tracking_no
                                from lnnplsue ,
                                    mbmembmaster ,
                                    mbucfprename
                                where ( lnnplsue.memcoop_id = mbmembmaster.coop_id ) and
                                    ( lnnplsue.member_no = mbmembmaster.member_no ) and
                                    ( mbucfprename.prename_code = mbmembmaster.prename_code ) and
                                    ( lnnplsue.sue_no = {1} and lnnplsue.coop_id = {0})";
            sql = WebUtil.SQLFormat(sql, state.SsCoopControl, this.DATA[0].SUE_NO);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
           // Ddlawset();
            DdTracking();
            //Ddlawtype();
            //Ddworkstep();
            //Dddebtclass();
        }

//        public void Ddlawset()
//        {
//            string sql = @"select
//                           contlaw_status, contlaw_status||'  '||contlaw_desc as display, 1 as sorter
//                           from lnucfcontlaw
//                           union
//                           select 0,'',0 from dual order by sorter, contlaw_status";
//            DataTable dt = WebUtil.Query(sql);
//            this.DropDownDataBind(dt, "lawset_status", "display", "contlaw_status");

//        }

        public void DdTracking()
        {
            string sql = @"select
                           tracking_no, 1 as sorter
                           from lnnpltracking where memcoop_id = {0} and member_no = {1}
                           union
                           select '',0 from dual order by sorter, tracking_no";
            sql = WebUtil.SQLFormat(sql,state.SsCoopControl,WebUtil.MemberNoFormat(this.DATA[0].MEMBER_NO));
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "tracking_no", "tracking_no", "tracking_no");

        }

//        public void Ddworkstep()
//        {
//            string sql = @"select
//                                workstep_code, workstep_code||'  '||workstep_desc as display, 1 as sorter
//                                from lnucfnplworkstep
//                                union
//                                select '','',0 from dual order by sorter, workstep_code";
//            DataTable dt = WebUtil.Query(sql);
//            this.DropDownDataBind(dt, "workstep_code", "display", "workstep_code");

//        }

//        public void Dddebtclass()
//        {
//            string sql = @"select
//                                debtclass_code, debtclass_code||'  '||debtclass_desc as display, 1 as sorter
//                                from lnucfnpldebtclass
//                                union
//                                select '','',0 from dual order by sorter, debtclass_code";
//            DataTable dt = WebUtil.Query(sql);
//            this.DropDownDataBind(dt, "debtclass_code", "display", "debtclass_code");

//        }

    }
}