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;
using DataLibrary;

namespace Saving.Applications.shrlon.ws_sl_sliploan_law_ctrl
{
    public partial class DsMain : DataSourceFormView
    {
        public DataSet1.SLSLIPPAYINDataTable DATA { get; set; }
        public string IsShow = "visible";

        public void InitDsMain(PageWeb pw)
        {
            css1.Visible = false;
            css2.Visible = false;
            DataSet1 ds = new DataSet1();
            this.DATA = ds.SLSLIPPAYIN;
            //this.EventItemChanged = "OnDsMainItemChanged";            
            this.InitDataSource(pw, FormView1, this.DATA, "dsMain");
            this.EventItemChanged = "OnDsMainItemChanged";
            this.EventClicked = "OnDsMainClicked";
            this.Register();
            this.Button.Add("b_memsearch");

            this.Button.Add("b_ref");
        }

        public void DdSliptype()
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @" 
              	     SELECT    SLUCFSLIPTYPE.SLIPTYPE_CODE AS SLIPTYPE_CODE,
                    SLUCFSLIPTYPE.SLIPTYPE_DESC,
                    SLUCFSLIPTYPE.SLIPTYPE_SORT,
                   CONCAT( SLUCFSLIPTYPE.SLIPTYPE_CODE, ' - ' , SLUCFSLIPTYPE.SLIPTYPE_DESC) as SLTYPE_DISPLAY 
                FROM SLUCFSLIPTYPE  
                WHERE slucfsliptype.slipmanual_flag = 1  
                 order by   SLUCFSLIPTYPE.SLIPTYPE_CODE
            ";

                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "SLIPTYPE_CODE", "SLTYPE_DISPLAY", "SLIPTYPE_CODE");
            }
            else
            {
                string sql = @" 
              	     SELECT    SLUCFSLIPTYPE.SLIPTYPE_CODE AS SLIPTYPE_CODE,
                    SLUCFSLIPTYPE.SLIPTYPE_DESC,
                    SLUCFSLIPTYPE.SLIPTYPE_SORT,
                   (SLUCFSLIPTYPE.SLIPTYPE_CODE|| ' - ' || SLUCFSLIPTYPE.SLIPTYPE_DESC) as SLTYPE_DISPLAY 
                FROM SLUCFSLIPTYPE  
                WHERE slucfsliptype.slipmanual_flag = 1  and SLUCFSLIPTYPE.SLIPTYPE_CODE ='PX'
                 order by   SLUCFSLIPTYPE.SLIPTYPE_CODE
            ";

                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "SLIPTYPE_CODE", "SLTYPE_DISPLAY", "SLIPTYPE_CODE");

            }
        }

        public void DdMoneyType()
        {
            if (Sta.IS_MYSQL_MODE)
            {
            string sql = @" 
                   SELECT MONEYTYPE_CODE,   
                          CONCAT(  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");
            }else{
                string sql = @" 
                   SELECT MONEYTYPE_CODE,   
                          (  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 DdFromAccId(string sliptype_code, string moneytype_code)
        {
            if (Sta.IS_MYSQL_MODE)
            {
                string sql = @"                         
                SELECT 
                        CMUCFTOFROMACCID.MONEYTYPE_CODE, 
			             CMUCFTOFROMACCID.ACCOUNT_ID,    
			             CONCAT(  CMUCFTOFROMACCID.ACCOUNT_ID ,'-',ACCMASTER.ACCOUNT_NAME) AS fromacc_display,
                  		 ACCMASTER.ACCOUNT_NAME  
                 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 + @"')
               order by CMUCFTOFROMACCID.ACCOUNT_ID
            ";
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "tofrom_accid", "fromacc_display", "account_id");
            }
            else
            {
                string sql = @"                         
                SELECT 
                        CMUCFTOFROMACCID.MONEYTYPE_CODE, 
			             CMUCFTOFROMACCID.ACCOUNT_ID,    
			              (  CMUCFTOFROMACCID.ACCOUNT_ID ||'-'||ACCMASTER.ACCOUNT_NAME) AS fromacc_display,
                  		 ACCMASTER.ACCOUNT_NAME  
                 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 + @"')
               order by CMUCFTOFROMACCID.ACCOUNT_ID
            ";
                DataTable dt = WebUtil.Query(sql);
                this.DropDownDataBind(dt, "tofrom_accid", "fromacc_display", "account_id");
            }
        }

        public void DdTofromAccBlank()
        {
            string sql = "select '' as fromacc_display,'' as account_id from dual";
            DataTable dt = WebUtil.Query(sql);
            this.DropDownDataBind(dt, "tofrom_accid", "fromacc_display", "account_id");
        }

        public void RetrieveMain(string payinslip_no)
        {
            String sql = @"SELECT SLSLIPPAYIN.MEMBGROUP_CODE,   
                         SLSLIPPAYIN.COOP_ID,  
                         SLSLIPPAYIN.DOCUMENT_NO,  
                         SLSLIPPAYIN.PAYINSLIP_NO,   
                         SLSLIPPAYIN.MEMBER_NO,   
                         SLSLIPPAYIN.SLIP_DATE,   
                         SLSLIPPAYIN.OPERATE_DATE,   
                         SLSLIPPAYIN.SLIPTYPE_CODE,   
                         MBMEMBMASTER.MEMB_NAME,   
                         MBMEMBMASTER.MEMB_SURNAME,   
                         MBUCFPRENAME.PRENAME_DESC,   
                         MBUCFMEMBGROUP.MEMBGROUP_DESC,   
                         SLSLIPPAYIN.SLIP_AMT,   
                         SLSLIPPAYIN.MONEYTYPE_CODE,   
                         SLSLIPPAYIN.ENTRY_ID,   
                         SLSLIPPAYIN.ACCID_FLAG,   
                         SLSLIPPAYIN.TOFROM_ACCID,   
                         SLSLIPPAYIN.SLIP_STATUS  
                    FROM SLSLIPPAYIN,   
                         MBMEMBMASTER,   
                         MBUCFMEMBGROUP,   
                         SLUCFSLIPTYPE,   
                         CMUCFMONEYTYPE,   
                         MBUCFPRENAME  
                   WHERE ( SLSLIPPAYIN.COOP_ID = MBMEMBMASTER.COOP_ID ) and  
                         ( SLSLIPPAYIN.MEMBER_NO = MBMEMBMASTER.MEMBER_NO ) and  
                         ( SLSLIPPAYIN.MEMBGROUP_CODE = MBUCFMEMBGROUP.MEMBGROUP_CODE (+)) and  
                         ( SLSLIPPAYIN.SLIPTYPE_CODE = SLUCFSLIPTYPE.SLIPTYPE_CODE ) and  
                         ( SLSLIPPAYIN.MONEYTYPE_CODE = CMUCFMONEYTYPE.MONEYTYPE_CODE ) and  
                         ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) and  
                         ( (SLSLIPPAYIN.COOP_ID={0} )and 
                           (SLSLIPPAYIN.PAYINSLIP_NO={1}) )";

            sql = WebUtil.SQLFormat(sql, state.SsCoopId, payinslip_no);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }
        public void RetrieveMemNo(string memno)
        {


            String sql = @"SELECT lnlawmbmaster.MEMBGROUP_CODE,   lnlawmbmaster.member_no,
                         lnlawmbmaster.COOP_ID, 'AUTO' as DOCUMENT_NO, 
                         (prename_desc||memb_name||'  '||memb_surname) as memb_name,   
                         MBUCFMEMBGROUP.MEMBGROUP_DESC  
                    FROM  
                         lnlawmbmaster,   
                         MBUCFMEMBGROUP , 
                         MBUCFPRENAME  
                   WHERE  
                         ( lnlawmbmaster.MEMBGROUP_CODE = MBUCFMEMBGROUP.MEMBGROUP_CODE ) and                           
                         ( MBUCFPRENAME.PRENAME_CODE = lnlawmbmaster.PRENAME_CODE ) and  
                         ( (lnlawmbmaster.COOP_ID={0} ) and 
                           (lnlawmbmaster.member_no={1}) )";

            sql = WebUtil.SQLFormat(sql, state.SsCoopId, memno);
            DataTable dt = WebUtil.Query(sql);
            this.ImportData(dt);
        }
    }
}