using System;
using CoreSavingLibrary;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DataLibrary;
using System.Drawing;
using CoreSavingLibrary.WcfNShrlon;
using System.Data;
using System.IO;

namespace Saving.Applications.shrlon.ws_sl_lawcontract_ctrl
{
    public partial class ws_sl_lawcontract : PageWebSheet, WebSheet
    {
        [JsPostBack]
        public string PostMemberNo { get; set; }
        [JsPostBack]
        public string PrintCont { get; set; }
        [JsPostBack]
        public string PrintColl { get; set; }
        [JsPostBack]
        public string PrintIns { get; set; }
        [JsPostBack]
        public string PrintContSpc { get; set; }
        [JsPostBack]
        public string bSearch { get; set; }
        [JsPostBack]
        public string PrintCont3 { get; set; }
        [JsPostBack]
        public string PrintCont4 { get; set; }
        [JsPostBack]
        public string PrintCont5 { get; set; }
        [JsPostBack]
        public string PostDate { get; set; }
        [JsPostBack]
        public string CheckPrint { get; set; }
        [JsPostBack]




        public string PostPrintFlag { get; set; }
        static string apvlist = "";
        public void InitJsPostBack()
        {
            dsMain.InitDsMain(this);
            dsList.InitDsList(this);
        }

        public void WebSheetLoadBegin()
        {
            if (!IsPostBack)
            {
                dsMain.DATA[0].status = "=1";
                dsMain.DATA[0].contsdate = state.SsWorkDate;
                dsMain.DATA[0].contedate = state.SsWorkDate;
                dsMain.RetriveEntryid();
                dsList.RetrieveFirst(state.SsWorkDate, dsMain.DATA[0].status);
 
            }
            else
            {
                string k = dsMain.DATA[0].status;
            }

        }
         

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == PostMemberNo)
            {
                string memb_no = WebUtil.MemberNoFormat(dsMain.DATA[0].member_no);
                dsList.Retrieve(memb_no, dsMain.DATA[0].status);
                //dsMain.DATA[0].member_no = memb_no;
                //dsMain.DATA[0].membname = dsList.DATA[0].fullname;
                //dsMain.DATA[0].entry_id = dsList.DATA[0].entry_id;
            }
            else if (eventArg == PostDate)
            {
                String sql = "";
                if (dsMain.DATA[0].member_no != "")
                {
                    sql += " and lr.member_no like '%" + dsMain.DATA[0].member_no + "%'  ";
                }
                else if (dsMain.DATA[0].membname != "")
                {
                    String s1 = "", s2 = "";
                    int u = dsMain.DATA[0].membname.Length;
                    int y = dsMain.DATA[0].membname.IndexOf(" ");
                    if (y > 0)
                    {
                        s1 = dsMain.DATA[0].membname.Substring(0, y);
                        try
                        {
                            u = u - y;
                            s2 = dsMain.DATA[0].membname.Substring(y, u);
                        }
                        catch (Exception e) { s2 = ""; }
                        sql += "and rownum <= 50  and mb.memb_name like '%" + s1 + "%' or mb.memb_surname like '%" + s2 + "%' ";
                    }
                    else
                    {
                        sql += "and rownum <= 50  and mb.memb_name like '%" + dsMain.DATA[0].membname + "%' or mb.memb_surname like '%" + dsMain.DATA[0].membname + "%' ";
                    }
                }
                else if (dsMain.DATA[0].entry_id != "")
                {
                    sql += " and  lr.approve_id = " + dsMain.DATA[0].entry_id + "  ";
                }
                else if (dsMain.DATA[0].contsdate != null && dsMain.DATA[0].contedate != null)
                {
                    sql += " and lr.startcont_date BETWEEN  to_date('" + dsMain.DATA[0].contsdate.ToShortDateString() + "','mm/dd/yyyy') and to_date('" + dsMain.DATA[0].contedate.ToShortDateString() + "','mm/dd/yyyy') ";
                }
                
                else if (dsMain.DATA[0].loancontract_no != "")
                {
                    sql += " and  lr.loancontract_no like '%" + dsMain.DATA[0].loancontract_no.Trim() + "%'  ";
                }


                string ordercheck = "";
                
                    ordercheck = "ORDER By lr.loancontract_no,lr.startcont_date desc";
         

                dsList.RetrieveSearch(sql, dsMain.DATA[0].status, ordercheck);

                LtServerMessage.Text = WebUtil.ErrorMessage(sql);
            }
           

            else if (eventArg == bSearch)
            {
                try
                {

                    String sql = "";
                    if (dsMain.DATA[0].member_no != "")
                    {
                        sql += " and lr.member_no like '%" + dsMain.DATA[0].member_no + "%'  ";
                    }
                    else if (dsMain.DATA[0].membname != "")
                    {
                        String s1 = "", s2 = "";
                        int u = dsMain.DATA[0].membname.Length;

                        if (dsMain.DATA[0].membsurname != "")
                        {

                            try
                            {

                                s2 = dsMain.DATA[0].membsurname;
                            }
                            catch (Exception e) { s2 = ""; }
                            sql += "and rownum <= 50 and (mb.memb_name like '%" + dsMain.DATA[0].membname + "%' or mb.memb_surname like '%" + s2 + "%') ";
                        }
                        else
                        {
                            sql += "and rownum <= 50 and (mb.memb_name like '%" + dsMain.DATA[0].membname + "%' or mb.memb_surname like '%" + dsMain.DATA[0].membname + "%') ";
                        }

                    }
                    else if (dsMain.DATA[0].entry_id != "")
                    {
                        sql += " and  lr.approve_id = " + dsMain.DATA[0].entry_id + "  ";
                    }
                    else if (dsMain.DATA[0].loancontract_no != "")
                    {
                        sql += " and  lr.loancontract_no like '%" + dsMain.DATA[0].loancontract_no.Trim() + "%'  ";
                    }
                    else if (dsMain.DATA[0].contsdate != null && dsMain.DATA[0].contedate != null)
                    {
                        sql += " and lr.startcont_date BETWEEN  to_date('" + dsMain.DATA[0].contsdate.ToShortDateString() + "','mm/dd/yyyy') and to_date('" + dsMain.DATA[0].contedate.ToShortDateString() + "','mm/dd/yyyy') ";
                    }
                     
                    string ordercheck = "";
                     
                        ordercheck = "ORDER By lr.loancontract_no,lr.startcont_date desc";
             

                    dsList.RetrieveSearch(sql, dsMain.DATA[0].status, ordercheck);
                    LtServerMessage.Text = WebUtil.ErrorMessage(sql);
                }
                catch (Exception e) { LtServerMessage.Text = WebUtil.ErrorMessage(e); }
            }
                 
            else if (eventArg == PostPrintFlag)
            {
                Int32 row = Convert.ToInt32(hdrow.Value.ToString().Trim());
                decimal flag = dsList.DATA[row].print_flag;
                if (flag == 1)
                {
                    dsList.DATA[row].print_flag = 1;
                }
                else if (flag == 0)
                {
                    dsList.DATA[row].print_flag = 0;
                }

            }


        }

        public void SaveWebSheet()
        {

        }

        public void WebSheetLoadEnd()
        {
            Decimal no = 0;
            no = dsList.RowCount;
            Decimal sum = 0;
            for (int i = 0; i < no; i++)
            {
                sum += dsList.DATA[i].principal_balance;
            }
             

            LtServerMessage.Text = WebUtil.CompleteMessage(" มีรายการ สัญญา ทั้งหมด :" + no + " รายการ   ******    รวมเป็นเงิน:" + sum.ToString("#,##0.00") + "   บาท");
        }
      
    }
}