using System;
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.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
//using Saving.WcfCommon;
//using Saving.WcfDeposit;
using CoreSavingLibrary.WcfNDeposit; // new deposit
using CoreSavingLibrary.WcfNCommon; //new common
using Sybase.DataWindow;
using DataLibrary;
using CoreSavingLibrary;

namespace Saving.Applications.mbshr.dlg
{
    public partial class w_dlg_dp_booknew : PageWebDialog, WebDialog
    {
        protected String newClear;
        protected String postSubmit;
        protected String filterBookNO;
        private n_depositClient ndept; //new deposit
        private n_commonClient ncommon; //new common

        public void InitJsPostBack()
        {
            newClear = WebUtil.JsPostBack(this, "newClear");
            postSubmit = WebUtil.JsPostBack(this, "postSubmit");
            filterBookNO = WebUtil.JsPostBack(this, "filterBookNO");
        }

        public void WebDialogLoadBegin()
        {
            ndept = wcf.NDeposit;
            HdCloseDlg.Value = "false";
            if (!IsPostBack)
            {
                Hdmem_no.Value = Request["member_no"].Trim();
                DwMain.InsertRow(0);
                try
                {
                    HdLastSeqNo.Value = int.Parse(Request["seqNo"]).ToString();
                }
                catch (Exception ex)
                {
                    LtServerMessage.Text = WebUtil.ErrorMessage("ไม่พบเลขลำดับรายการ");
                }

            }
            else
            {
                this.RestoreContextDw(DwMain);
            }
        }

        public void CheckJsPostBack(string eventArg)
        {
            if (eventArg == "newClear")
            {
                JsNewClear();
            }
            else if (eventArg == "postSubmit")
            {
                JsPostSubmit();
            }
            else if (eventArg == "filterBookNO")
            {
                JsFilterBookNO();
            }
        }

        public void WebDialogLoadEnd()
        {
            try
            {
                DwUtil.RetrieveDDDW(DwMain, "as_bookreson", "dp_slip.pbl", null);
            }
            catch
            {
            }
            DwMain.SaveDataCache();
        }

        private void JsNewClear()
        {
            String oldBook = "";
            String deptTypeCode = "";
            String bookBase = "";
            String bookGrp = "";
            if (IsPostBack)
            {
                DwMain.Reset();
            }
            DwMain.InsertRow(0);
            deptTypeCode = Request["deptTypeCode"];
            DataTable dt = WebUtil.Query("select book_stmbase as bookBase, book_group as bookGrp from dpdepttype where depttype_code='" + deptTypeCode + "'");
            if (dt.Rows.Count > 0)
            {
                bookBase = dt.Rows[0]["bookBase"].ToString().Trim();
                bookGrp = dt.Rows[0]["bookGrp"].ToString().Trim();
            }
            try
            {
                oldBook = Request["deptPassBookNo"];
                if (oldBook != "" || oldBook != null)
                {
                    DwMain.SetItemString(1, "as_oldbook", oldBook);
                }
                DwUtil.RetrieveDDDW(DwMain, "as_bookno", "dp_slip.pbl", state.SsCoopId, deptTypeCode);
                DwUtil.RetrieveDDDW(DwMain, "as_bookreson", "dp_slip.pbl", null);
                String sql = "select min(Book_No) as mBN  from DPDEPTBOOKHIS,DPDEPTTYPE where DPDEPTBOOKHIS.Book_Status = '8' and DPDEPTBOOKHIS.Coop_Id = '" + state.SsCoopId + "' and (DPDEPTTYPE.BOOK_GROUP = DPDEPTBOOKHIS.BOOK_GRP) and DPDEPTTYPE.DEPTTYPE_CODE = '" + deptTypeCode + "'";
                DataTable dt2 = WebUtil.Query(sql);
                string as_bookno = dt2.Rows[0]["mBN"].ToString().Trim();
                DwMain.SetItemString(1, "as_bookno", as_bookno);
                DataWindowChild bookNo = DwMain.GetChild("as_bookno");
                bookNo.SetFilter("( book_type ='" + bookBase + "' ) and ( book_grp ='" + bookGrp + "' )");
                bookNo.Filter();

                //try
                //{
                //    if (DwSaving.GetItemString(1, "book_stmbase") != null)
                //    {
                //        String bookType = DwSaving.GetItemString(1, "book_stmbase");
                //        DataWindowChild dc2 = DwSaving.GetChild("book_group");
                //        dc2.SetTransaction(sqlca);
                //        dc2.Retrieve();
                //        dc2.SetFilter("book_type = '" + bookType + "'");
                //        dc2.Filter();
                //    }
                //}
                //catch (Exception)
                //{

                //}
            }
            catch { }
        }

        private void JsPostSubmit()
        {
            int lastSeqNo = -1;
            try
            {
                lastSeqNo = int.Parse(HdLastSeqNo.Value);
            }
            catch
            {
                LtServerMessage.Text = WebUtil.ErrorMessage("ไม่พบเลขลำดับรายการ");
                return;
            }
            //DepositClient dep = wcf.Deposit;
            String apvId = state.SsUsername;
            String bookNo = DwUtil.GetString(DwMain, 1, "as_bookno");
            String reason = DwUtil.GetString(DwMain, 1, "as_bookreson");
            int normFlag = 1;
            try
            {
                
                int printStatus = 1;
                string xml_return = "", xml_return_bf = "";
                int reprint = 0;
                string as_member_no = Hdmem_no.Value;
                DateTime adtm_date = state.SsWorkDate;
                string as_xml_return = "";
                String as_entryid = "";
                //short ai_reprint = 1;
                String as_newpassbook_no = DwMain.GetItemString(1,"as_bookno");
                String as_reson =DwMain.GetItemString(1,"as_bookreson");

                //String resonCode = DwMain.GetItemString(1, "");    // edit by mike ไม่ได้ใช้งาน และทำให้เกิด error
                ndept.of_print_bookshare_firstpage(state.SsWsPass, as_member_no, state.SsWorkDate, as_entryid, ref as_xml_return, 1, as_newpassbook_no, as_reson);
                if (as_xml_return != "" && printStatus == 1)
                {
                    //ndept.UpdateNewBookLast(state.SsWsPass, Hdmem_no.Value, lastSeqNo);
                    //Printing.Shareprintbookfristpage(this, as_xml_return);
                }
                HdCloseDlg.Value = "true";
            }
            catch (Exception ex)
            {
                Label1.Text = WebUtil.ErrorMessage(ex);
            }
        }

        private void JsFilterBookNO()
        {
        }
    }
}