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

namespace Saving.Applications.trading.dlg.w_dlg_regis_ctrl
{
    public partial class w_dlg_regis : PageWebDialog, WebDialog
    {
   
        [JsPostBack]
        public string PostDistrict { get; set; }
        [JsPostBack]
        public string PostTumbol { get; set; }
        [JsPostBack]
        public string save_data { get; set; }
        [JsPostBack]
        public string PostDropdown { get; set; }
        TradingService _TradService = new TradingService();

        string store_id = string.Empty;
        string terminal_no = "001";
        string coop_id = string.Empty;    
        public void InitJsPostBack()
        {
            dsMain.InitdsMain(this);

        }

        public void WebDialogLoadBegin()
        {
            coop_id = state.SsCoopId;
            store_id = state.SsStoreId;
            if (!IsPostBack)
            {
                    dsMain.DdDebtfromtype();
                    dsMain.Ddregis();
                    dsMain.DATA[0].DEBTFROMTYPE_CODE = "001";
                    dsMain.DATA[0].DEBT_STATUS = "1";              
                    of_debtfrom();
                    Site_desc.Enabled = false;
                    if (Request.QueryString["debttype_code"] != null)
                    {
                        dsMain.DATA[0].debttypecode = Request.QueryString["debttype_code"];
                    }
                    decimal chk = _TradService.GetLoanFlag(coop_id, dsMain.DATA[0].debttypecode);
                    if (chk == 0)
                    {
                        dsMain.DATA[0].CREDIT_AMT = 999999999;
                        dsMain.DATA[0].CREDITBALANCE_AMT = 999999999;
                    }
                  
                
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
                

            if (eventArg == save_data)
            {
                SaveWebDialog();
            }
            
        }

        public void SaveWebDialog()
        {
            if (dsMain.DATA[0].DEBT_NO != "")
            {               
                    try
                    {
                       
                        string COOP_ID = state.SsCoopId
                            , DEBT_NAME = dsMain.DATA[0].DEBT_NAME
                            , DEBT_ADDR = dsMain.DATA[0].DEBT_ADDR
                            , DEBT_NO = dsMain.DATA[0].DEBT_NO
                            , DEBT_TAX_NO = dsMain.DATA[0].DEBT_TAX_NO
                            , DEBTFROMTYPE_CODE = "001"
                            , DEBT_TUMBON_CODE = dsMain.DATA[0].DEBT_TUMBON
                            , DEBT_AMPHUR_CODE = dsMain.DATA[0].DEBT_AMPHUR
                            , DEBT_PROVINCE_CODE = dsMain.DATA[0].DEBT_PROVINCE
                            //ปั้มแก้ยิงเบส
                            , DEBT_TUMBON = dsMain.DATA[0].DEBT_TUMBON
                            , DEBT_AMPHUR = dsMain.DATA[0].DEBT_AMPHUR
                            , DEBT_PROVINCE = dsMain.DATA[0].DEBT_PROVINCE
                            , REFDEBT_NO = dsMain.DATA[0].REFDEBT_NO
                            , DEBT_POSTCODE = dsMain.DATA[0].DEBT_POSTCODE
                            , DEBT_STATUS = dsMain.DATA[0].DEBT_STATUS
                            , DEBT_PHONE = dsMain.DATA[0].DEBT_PHONE
                            , STORE_ID = store_id
                             , companybranch_desc = string.Empty
                             , DEBT_MOO = dsMain.DATA[0].DEBT_MOO
                             , debt_road = dsMain.DATA[0].debt_road
                             , DEBTTYPE_CODE = dsMain.DATA[0].debttypecode;
                        decimal lastno = _TradService.of_getcontractno(coop_id, "DDEBTNO");

                        decimal
                              CREDIT_AMT = dsMain.DATA[0].CREDIT_AMT
                            , BF_FEEAMT = dsMain.DATA[0].BF_FEEAMT
                            , BFDEBT_AMT = dsMain.DATA[0].BFDEBT_AMT
                            , DEBT_AMT = dsMain.DATA[0].DEBT_AMT
                            , CREDITBALANCE_AMT = dsMain.DATA[0].CREDITBALANCE_AMT;

                        dsMain.DATA[0].DEBTFROMTYPE_CODE = "001";
                        if (COMPANYBRANCH_FLAG.SelectedValue == "0")
                        {
                            companybranch_desc = "ไม่ระบุ";
                        }
                        else if (COMPANYBRANCH_FLAG.SelectedValue == "1")
                        {
                            companybranch_desc = "สำนักงานใหญ่";
                        }
                        else
                        {
                            companybranch_desc = Site_desc.Text.Trim();
                        }

                        ExecuteDataSource exe = new ExecuteDataSource(this);
                        try
                        {
                            string sql1 = @"INSERT INTO STDEBTMASTER (COOP_ID, DEBT_NO ,DEBT_NAME, DEBT_ADDR,DEBTTYPE_CODE,DEBT_TAX_NO,DEBTFROMTYPE_CODE,DEBT_TUMBON,
                                DEBT_AMPHUR, DEBT_PROVINCE, REFDEBT_NO, DEBT_POSTCODE, DEBT_STATUS, DEBT_PHONE, CREDIT_AMT, BF_FEEAMT, BFDEBT_AMT, DEBT_AMT, CREDITBALANCE_AMT,STORE_ID,DEBT_MOO,debt_road,Site_id,Site_desc,entry_date,entry_id) 
                                VALUES ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{24},{25})";
                            sql1 = WebUtil.SQLFormat(sql1, COOP_ID, DEBT_NO, DEBT_NAME, DEBT_ADDR, DEBTTYPE_CODE, DEBT_TAX_NO, DEBTFROMTYPE_CODE, DEBT_TUMBON,
                                DEBT_AMPHUR, DEBT_PROVINCE, DEBT_NO, DEBT_POSTCODE, DEBT_STATUS, DEBT_PHONE, CREDIT_AMT, BF_FEEAMT, BFDEBT_AMT, DEBT_AMT, CREDITBALANCE_AMT, store_id,  DEBT_MOO, debt_road, COMPANYBRANCH_FLAG.SelectedValue, companybranch_desc,DateTime.Now,state.SsUsername);
                            string sql2 = @"update CMDOCUMENTCONTROL set last_documentno = '" + lastno + "' where document_code= 'DDEBTNO'";
                            exe.SQL.Add(sql1);
                            exe.SQL.Add(sql2);
                            exe.Execute();
                            exe.SQL.Clear();                       
                            LtServerMessage.Text = WebUtil.CompleteMessage("บันทึกสำเร็จ");
                        }
                        catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); }
                    }
                    catch (Exception ex) { LtServerMessage.Text = WebUtil.ErrorMessage(ex); }
                
            }
            else { LtServerMessage.Text = WebUtil.ErrorMessage("กรุณาตรวจสอบข้อมูล"); }
        }

        public void WebDialogLoadEnd()
        {
            //throw new NotImplementedException();
        }

        public void of_debtfrom()
        {          
                if (dsMain.DATA[0].DEBTFROMTYPE_CODE == "001")
                {
                    decimal lastno = _TradService.of_getcontractno(coop_id, "DDEBTNO");
                    string last_debtno = Convert.ToString(lastno);
                    if (last_debtno.Length == 1)
                    {
                        last_debtno = "0F00000" + last_debtno;
                    }
                    else if (last_debtno.Length == 2)
                    {
                        last_debtno = "0F0000" + last_debtno;
                    }
                    else if (last_debtno.Length == 3)
                    {
                        last_debtno = "0F000" + last_debtno;
                    }
                    else if (last_debtno.Length == 4)
                    {
                        last_debtno = "0F00" + last_debtno;
                    }
                    else if (last_debtno.Length == 5)
                    {
                        last_debtno = "0F0" + last_debtno;
                    }
                    else if (last_debtno.Length == 6)
                    {
                        last_debtno = "0F" + last_debtno;
                    }
                    else if (last_debtno.Length == 7)
                    {
                        last_debtno = "0" + last_debtno;
                    }
                    dsMain.DATA[0].DEBT_NO = last_debtno;
                }            
        }
        


        protected void hdMode_ValueChanged(object sender, EventArgs e)
        {

        }

        
    }
}