using System;
using CoreSavingLibrary;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using CoreSavingLibrary.WcfNCommon;
using CoreSavingLibrary.WcfNShrlon;
using Sybase.DataWindow;
using DataLibrary;

namespace Saving.Applications.shrlon
{
    public partial class w_sheet_ln_loan_edit : PageWebSheet, WebSheet
    {
        protected String initLnPause;
        private n_shrlonClient shrlonSrv;
        private DwThDate dwMainThDate;
        protected String jsGetMemberInfo;

        Sta ta;
        String pbl = "sl_loan_edit.pbl";
     
      
        public void InitJsPostBack()
        {
            initLnPause = WebUtil.JsPostBack(this, "initLnPause");
            jsGetMemberInfo = WebUtil.JsPostBack(this, "jsGetMemberInfo");
            //dwMainThDate = new DwThDate(dw_main, this);
            //dwMainThDate.Add("pauseloan_date", "pauseloan_tdate");
        }

        public void WebSheetLoadBegin()
        {
            try
            {
                shrlonSrv = wcf.NShrlon;
            }
            catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); }

            if (IsPostBack)
            {
                dw_main.RestoreContext();
               
            }
            else
            {
                this.InitDataWindow();
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "jsGetMemberInfo")
            {

                // clear_periodpayment();
                JsPostmember();

            }

        }
        public void JsPostmember()
        {
            string member_no = dw_main.GetItemString(1, "member_no");
            member_no = selectMemNo(member_no);
            DwUtil.RetrieveDataWindow(dw_main, pbl,null, member_no);
            DwUtil.RetrieveDataWindow(dw_list, pbl, null, member_no);
            //// DwUtil.RetrieveDDDW(dw_main, "member_no", member_no);
            //DwUtil.RetrieveDDDW(dw_list, "member_no", pbl, member_no);
//            try
//            {
//                String sqlSt = @"   SELECT MBMEMBMASTER.MEMBER_NO,   
//         MBUCFPRENAME.PRENAME_DESC,   
//         MBMEMBMASTER.MEMB_NAME,   
//         MBMEMBMASTER.MEMB_SURNAME,   
//         MBMEMBMASTER.MEMBGROUP_CODE,   
//         MBUCFMEMBGROUP.MEMBGROUP_DESC,   
//         MBMEMBMASTER.MEMBTYPE_CODE,   
//         MBUCFMEMBTYPE.MEMBTYPE_DESC,   
//         MBMEMBMASTER.ACCUM_INTEREST,   
//         MBMEMBMASTER.MEMBER_STATUS  
//    FROM MBMEMBMASTER,   
//         MBUCFMEMBGROUP,   
//         MBUCFMEMBTYPE,   
//         MBUCFPRENAME  
//   WHERE ( MBUCFMEMBGROUP.MEMBGROUP_CODE = MBMEMBMASTER.MEMBGROUP_CODE ) and  
//         ( MBUCFMEMBTYPE.MEMBTYPE_CODE = MBMEMBMASTER.MEMBTYPE_CODE ) and  
//         ( MBUCFPRENAME.PRENAME_CODE = MBMEMBMASTER.PRENAME_CODE ) and  
//         ( ( mbmembmaster.member_no = '" + member_no + "' ) ) ";
//                sqlSt = WebUtil.SQLFormat(sqlSt, state.SsCoopControl);

//                Sdt dt1 = WebUtil.QuerySdt(sqlSt);
//                String msg = "", MEMNAME = "", MEMTYPE = "", MEMGROUP = "";
//                Decimal accum_interest = 0;
//                if (dt1.Next())
//                {
//                   MEMNAME= dt1.GetString("PRENAME_DESC") + dt1.GetString("MEMB_NAME") + "  " + dt1.GetString("MEMB_SURNAME");
//                   MEMTYPE= dt1.GetString("MEMBTYPE_CODE") + "  " + dt1.GetString("MEMBTYPE_DESC");
//                   accum_interest = dt1.GetDecimal("ACCUM_INTEREST");
//                    MEMGROUP= dt1.GetString("MEMBGROUP_CODE") + "  " + dt1.GetString("MEMBGROUP_DESC");
//                    Decimal ii = dt1.GetDecimal("MEMBER_STATUS");
                   
//                    if (ii == 1)
//                    {
//                        msg = "ปกติ";
//                    }
//                    else
//                    {
//                        msg = "ลาออก";
//                    }
                   
//                }
//                dw_main.SetItemString(1, "memname", MEMNAME);
//                dw_main.SetItemString(1, "MEMTYPE", MEMTYPE);
//                dw_main.SetItemDecimal(1, "accum_interest", accum_interest);
//                dw_main.SetItemString(1, "MEMGROUP", MEMGROUP);
//                dw_main.SetItemString(1, "memstatus", msg);

//                String sqlStr = @"select loantype_code,loancontract_no,principal_balance
//                from lncontmaster 
//                where coop_id = {0}
//	            and member_no = '" + member_no + "'";
//                sqlStr = WebUtil.SQLFormat(sqlStr, state.SsCoopControl);

//                Sdt dt11 = WebUtil.QuerySdt(sqlStr);
//                int row = 1;
//                if (dt11.Next())
//                {
//                    Decimal loantype_code = dt11.GetDecimal("loantype_code");
//                    String loancontract_no = dt11.GetString("loancontract_no");
//                    Decimal principal_balance = dt11.GetDecimal("principal_balance");
                    
//                    row = row + 1;
//                }
//            }catch(Exception e){}
//            dw_list.SetItemString(1, "loantype_code", "ss");
//            dw_list.SetItemString(1, "loancontract_no", "aaa");
//            dw_list.SetItemDecimal(1, "principal_balance", 4512);
        }
        public String selectMemNo(String member_no)
        {
            String member = "";
            String sqlStr2 = @"select member_no
                from mbmembmaster 
                where mbmembmaster.coop_id = {0}
	            and mbmembmaster.member_no like '%" + member_no + "' and ROWNUM <= 1  order by member_no desc";
            sqlStr2 = WebUtil.SQLFormat(sqlStr2, state.SsCoopControl);

            Sdt dt121 = WebUtil.QuerySdt(sqlStr2);

            if (dt121.Next())
            {
                member = dt121.GetString("member_no");
            }
            return member;
        }

        public void SaveWebSheet()
        {
            //str_lnpause strLnPause = new str_lnpause();
            //strLnPause.entry_id = state.SsUsername;
            //strLnPause.loanpause_date = dw_main.GetItemDateTime(1, "pauseloan_date");
            //strLnPause.member_no = WebUtil.StringFormat(dw_main.GetItemString(1, "member_no"), "000000");
            //strLnPause.xml_pause = dw_main.Describe("DataWindow.Data.XML");
            //strLnPause.xml_pausedet = dw_list.Describe("DataWindow.Data.XML");
            //try
            //{
            //    int result = shrlonSrv.of_savereq_lnpause(state.SsWsPass, ref strLnPause);
            //    if (result == 1)
            //    {
            //        LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกสำเร็จ");
            //        dw_main.Reset();
            //        dw_list.Reset();
            //        InitDataWindow();

            //    }
            //    else
            //    {
            //        LtServerMessage.Text = WebUtil.ErrorMessage("บันทึกไม่สำเร็จ");
            //    }
            //}
            //catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); }
        }

        public void WebSheetLoadEnd()
        {
            dwMainThDate.Eng2ThaiAllRow();
        }

       

        private void InitDataWindow()
        {
            dw_main.InsertRow(0);
            dw_main.SetItemDateTime(1, "pauseloan_date", state.SsWorkDate);
        }

        private void InitLnPause()
        {
            //str_lnpause strLnPause = new str_lnpause();
            //strLnPause.entry_id = state.SsUsername;
            //strLnPause.loanpause_date = dw_main.GetItemDateTime(1, "pauseloan_date");
            //strLnPause.member_no = WebUtil.StringFormat(dw_main.GetItemString(1, "member_no"), "00000000");
            ////  shrlonSrv.of_initreq_lnpause(state.SsWsPass, ref strLnPause);
            //try
            //{
            //    shrlonSrv.of_initreq_lnpause(state.SsWsPass, ref strLnPause);
            //    dw_main.Reset();
            //    DwUtil.ImportData(strLnPause.xml_pause, dw_main, dwMainThDate, FileSaveAsType.Xml);
            //    //DwUtil.ImportData(strLnPause.xml_pause, dw_main,);
            //    //dw_main.ImportString(strLnPause.xml_pause, FileSaveAsType.Xml);
            //    DwUtil.DeleteLastRow(dw_main);
            //}
            //catch (Exception ex)
            //{
            //    LtServerMessage.Text = WebUtil.ErrorMessage(ex);
            //    dw_main.Reset();
            //}
            //try
            //{
            //    dw_list.Reset();
            //    DwUtil.ImportData(strLnPause.xml_pausedet, dw_list, dwMainThDate, FileSaveAsType.Xml);
            //    // DwUtil.ImportData(strLnPause.xml_pausedet, dw_list, null);
            //    // dw_list.ImportString(strLnPause.xml_pausedet, FileSaveAsType.Xml);
            //}
            //catch (Exception ex)
            //{
            //    LtServerMessage.Text = WebUtil.ErrorMessage(ex);
            //    dw_list.Reset();
            //}
        }
    }
}