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

namespace Saving.Applications.shrlon.dlg.w_dlg_loan_receive_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.SLSLIPPAYOUTDataTable DATA { get; set; }
        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.SLSLIPPAYOUT;
            this.EventItemChanged = "OnDsMainItemChanged";
            this.EventClicked = "OnDsMainClicked";
            this.InitDataSource(pw, FormView2, this.DATA, "dsMain");
            this.Button.Add("b_sbranch");
            this.Register();
        }

        public void RetrieveMemberName(String member_no)
        {
            string sql = @"  ";
            sql = WebUtil.SQLFormat(sql, state.SsCoopControl, member_no);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }

        public void DdLoanType()
        {
            string sql = @" 
                SELECT LOANTYPE_CODE,   
                       LOANTYPE_DESC,
                        LOANTYPE_CODE || ' - ' || LOANTYPE_DESC as LOANTYPE_DISPLAY
                  FROM LNLOANTYPE order by  LOANTYPE_CODE
            ";
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "shrlontype_code", "LOANTYPE_DISPLAY", "LOANTYPE_CODE");

        }

        public void DdMoneyType()
        {
            string sql = @" 
                   SELECT MONEYTYPE_CODE,   
                          MONEYTYPE_DESC,   
                          SORT_ORDER  ,
                          MONEYTYPE_CODE || ' - '|| MONEYTYPE_DESC as MONEYTYPE_DISPLAY
                     FROM CMUCFMONEYTYPE order by MONEYTYPE_CODE
            ";
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "MONEYTYPE_CODE", "MONEYTYPE_DISPLAY", "MONEYTYPE_CODE");

        }

        public void DdBankDesc()
        {
            string sql = @"
            select  bank_code,bank_code|| ' '||bank_desc  as bank_desc, 1 as sorter from cmucfbank 
            union 
            select '','', 0 from dual order by sorter, bank_desc
            ";
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "expense_bank", "bank_desc", "bank_code");
        }

        public void DdBranch(string bank_code)
        {
            string sql = @"
            select bank_code,branch_id, branch_name, 1 as sorter from cmucfbankbranch where bank_code = {0} 
            union
            select '', '','', 0 from dual order by sorter, branch_name
            ";
            sql = WebUtil.SQLFormat(sql, bank_code);
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "expense_branch", "branch_name", "branch_id");
        }

        public void DdBranchLike(string bank_code, string branch_name)
        {
            string sql = @"
            select bank_code,branch_id, branch_name from cmucfbankbranch where bank_code = {0} and branch_name like {1}
            union
            select '', '','' from dual order by branch_name
            ";
            sql = WebUtil.SQLFormat(sql, bank_code, "%" + branch_name + "%");
            DataTable dt = WebUtil.Query(sql);
            
            this.DropDownDataBind(dt, "expense_branch", "branch_name", "branch_id");            
            this.SetItem(0, "expense_branch", Convert.ToString(dt.Rows[0]["branch_id"]));
        }
        public void DdAccount(string dept_code, string coop_id)
        {
            string sql = @"
            select deptaccount_no from dpdeptmaster where coop_id = {0} and member_no = {1} and deptclose_status=0
            union
            select '' from dual order by deptaccount_no
            ";
            sql = WebUtil.SQLFormat(sql, coop_id, dept_code);
            DataTable dt = WebUtil.Query(sql);

            this.DropDownDataBind(dt, "expense_accid", "deptaccount_no", "deptaccount_no");
            this.SetItem(0, "expense_accid", Convert.ToString(dt.Rows[0]["deptaccount_no"]));
        }

        public void DdFromAccId(string sliptype_code, string moneytype_code)
        {
            string sql = @"
                   SELECT 
                        CMUCFTOFROMACCID.MONEYTYPE_CODE, 
			             CMUCFTOFROMACCID.ACCOUNT_ID,    
			             CMUCFTOFROMACCID.ACCOUNT_ID ||'-'||ACCMASTER.ACCOUNT_NAME AS fromacc_display,
                  		 ACCMASTER.ACCOUNT_NAME  ,  
                         1 as sorter
                 FROM ACCMASTER,   
        		      CMUCFTOFROMACCID  
                 WHERE 
		              ( ACCMASTER.COOP_ID = CMUCFTOFROMACCID.COOP_ID )  
                 and  (CMUCFTOFROMACCID.ACCOUNT_ID =ACCMASTER.ACCOUNT_ID)
                 and (CMUCFTOFROMACCID.SLIPTYPE_CODE = '" + sliptype_code + "') and (CMUCFTOFROMACCID.MONEYTYPE_CODE = '" + moneytype_code + @"')
                union select '','','','',0 from dual order by sorter";
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "tofrom_accid", "fromacc_display", "ACCOUNT_ID");
        }
    }
}