Пример #1
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        CustomerTypeWiseSPLimit    oCTWiseSPLimit    = new CustomerTypeWiseSPLimit();
        CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();

        oCTWiseSPLimit.SPType.SPTypeID             = ddlSPType.SelectedItem.Value.Trim();
        oCTWiseSPLimit.CustomerType.CustomerTypeID = ddlCustType.SelectedItem.Value.Trim();

        oCTWiseSPLimit.MinimumLimit = Convert.ToInt32(txtMinLim.Text.Trim());
        oCTWiseSPLimit.MaximumLimit = Convert.ToInt32(txtMaxLim.Text.Trim());

        oCTWiseSPLimit.UserDetails          = ucUserDet.UserDetail;
        oCTWiseSPLimit.UserDetails.MakeDate = DateTime.Now;
        ucUserDet.ResetData();
        Result oResult = (Result)oCTWiseSPLimitDAL.Save(oCTWiseSPLimit);

        if (oResult.Status)
        {
            ClearTextValue();
            this.LoadList();
            hdCustomerID.Value = "";

            ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS);
        }
        else
        {
            ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR);
        }
    }
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            CustomerType oCustomerType = new CustomerType();
            CustomerTypeWiseSPLimitDAL oCustTypeWiseSPLmtDAL = new CustomerTypeWiseSPLimitDAL();

            Result    oResult   = oCustTypeWiseSPLmtDAL.SearchList(ddlCustType.SelectedValue, ddlSPType.SelectedValue);
            DataTable dtTmpList = null;

            ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchCustTypeWiseSPLimit_lblProgress') ", true);
            if (oResult.Status)
            {
                dtTmpList = (DataTable)oResult.Return;
                if (dtTmpList.Rows.Count > 0)
                {
                    gvSearchList.DataSource = dtTmpList;
                    gvSearchList.DataBind();
                }
                else
                {
                    gvSearchList.DataSource = null;
                    gvSearchList.DataBind();
                }
            }
            Session[Constants.SES_CONFIG_APPROVE_DATA] = dtTmpList;
        }
Пример #3
0
 protected void btnDelete_Click(object sender, EventArgs e)
 {
     if (!string.IsNullOrEmpty(hdCustomerID.Value))
     {
         CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
         Result oResult = (Result)oCTWiseSPLimitDAL.Detete(hdCustomerID.Value == "" ? "0" : hdCustomerID.Value, hdSPTypeID.Value == "" ? "0" : hdSPTypeID.Value);
         if (oResult.Status)
         {
             ClearTextValue();
             this.LoadList();
             hdCustomerID.Value = "";
             ucMessage.OpenMessage(Constants.MSG_SUCCESS_DELETE, Constants.MSG_TYPE_SUCCESS);
         }
         else
         {
             if (oResult.Message.Equals(Constants.TABLE_MAIN))
             {
                 ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_ERROR);
             }
             else
             {
                 ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
             }
         }
     }
     else
     {
         ucMessage.OpenMessage(Constants.MSG_ERROR_DELETE, Constants.MSG_TYPE_ERROR);
     }
 }
        public void SetData(string sSpTypeID, string sCustomerType, string sMasterNo)
        {
            CustomerTypeWiseSPLimit    oCTWiseSPLimit    = new CustomerTypeWiseSPLimit(sCustomerType, sSpTypeID);
            CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
            Result oResult = new Result();

            oResult = oCTWiseSPLimitDAL.LoadByID(oCTWiseSPLimit);
            if (oResult.Status)
            {
                oCTWiseSPLimit       = (CustomerTypeWiseSPLimit)oResult.Return;
                txtSPType.Text       = sSpTypeID;
                txtCustomerType.Text = sCustomerType;
                txtMaximumLimit.Text = oCTWiseSPLimit.MinimumLimit.ToString();
                txtMinimumLimit.Text = oCTWiseSPLimit.MaximumLimit.ToString();
            }

            // Load Grid Data
            oResult = oCTWiseSPLimitDAL.CheckUserLimit(sSpTypeID, sMasterNo);
            if (oResult.Status)
            {
                DataTable dtLimit = (DataTable)oResult.Return;
                if (dtLimit != null)
                {
                    if (dtLimit.Rows.Count > 0)
                    {
                        dtLimit.Rows[0]["Allowed Limit"] = (Util.GetDecimalNumber(dtLimit.Rows[0]["IssueAmount"].ToString()) - Util.GetDecimalNumber(txtMaximumLimit.Text)).ToString();
                    }
                }
                gvSearchList.DataSource = dtLimit;
                gvSearchList.DataBind();
                decimal tfsHours = (decimal)dtLimit.Compute("Sum(IssueAmount)", "");
                txtTotalAmount.Text = tfsHours.ToString("N2");
            }
        }
Пример #5
0
        private void LoadCustomerTypeBySpType(string sSPType)
        {
            CustomerTypeWiseSPLimitDAL oCustTypeWiseSPLimit = new CustomerTypeWiseSPLimitDAL();
            Result oResult = (Result)oCustTypeWiseSPLimit.GetCustomerTypeBySpType(sSPType);

            if (oResult.Status)
            {
                ddlCustomerType.Items.Clear();
                DataTable dtGetCustomerTypeID = (DataTable)oResult.Return;
                DDListUtil.Assign(ddlCustomerType, dtGetCustomerTypeID);
            }
        }
Пример #6
0
    private void LoadDataByID(string sCustomerID, string sSPTypeID)
    {
        CustomerTypeWiseSPLimit    oCTWiseSPLimit    = new CustomerTypeWiseSPLimit(sCustomerID, sSPTypeID);
        CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();

        Result oResult = new Result();

        oResult = oCTWiseSPLimitDAL.LoadByID(oCTWiseSPLimit);
        if (oResult.Status)
        {
            oCTWiseSPLimit = (CustomerTypeWiseSPLimit)oResult.Return;
            DDListUtil.Assign(ddlSPType, oCTWiseSPLimit.SPType.SPTypeID.Trim());
            DDListUtil.Assign(ddlCustType, oCTWiseSPLimit.CustomerType.CustomerTypeID.Trim());
            ddlCustType.Enabled = false;
            ddlSPType.Enabled   = false;
            txtMinLim.Text      = oCTWiseSPLimit.MinimumLimit.ToString();
            txtMaxLim.Text      = oCTWiseSPLimit.MaximumLimit.ToString();
            if (string.IsNullOrEmpty(hdDataType.Value))
            {
                //When Loading from Approver End
                UserDetails userDetails = ucUserDet.UserDetail;
                userDetails.MakerID  = oCTWiseSPLimit.UserDetails.MakerID;
                userDetails.MakeDate = oCTWiseSPLimit.UserDetails.MakeDate;
                ucUserDet.UserDetail = userDetails;
            }
            else if (hdDataType.Value.Equals("T"))
            {
                //When loading from temp table
                UserDetails userDetails = ucUserDet.UserDetail;
                userDetails.CheckDate      = oCTWiseSPLimit.UserDetails.CheckDate;
                userDetails.CheckerID      = oCTWiseSPLimit.UserDetails.CheckerID;
                userDetails.CheckDate      = oCTWiseSPLimit.UserDetails.CheckDate;
                userDetails.CheckerComment = oCTWiseSPLimit.UserDetails.CheckerComment;
                ucUserDet.UserDetail       = userDetails;
            }

            hdCustomerID.Value = oCTWiseSPLimit.CustomerType.CustomerTypeID;
            hdSPTypeID.Value   = oCTWiseSPLimit.SPType.SPTypeID;
        }
        else
        {
            ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
        }
    }
Пример #7
0
    protected void btnApprove_Click(object sender, EventArgs e)
    {
        if (!string.IsNullOrEmpty(hdCustomerID.Value))
        {
            CustomerTypeWiseSPLimit    oCTWiseSPLimit    = new CustomerTypeWiseSPLimit(hdCustomerID.Value == "" ? "0" : hdCustomerID.Value, hdSPTypeID.Value == "" ? "0" : hdSPTypeID.Value);
            CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
            oCTWiseSPLimit.UserDetails = ucUserDet.UserDetail;

            Result oResult = (Result)oCTWiseSPLimitDAL.Approve(oCTWiseSPLimit);
            if (oResult.Status)
            {
                ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS);
            }
            else
            {
                ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR);
            }
        }
        else
        {
            ucMessage.OpenMessage(Constants.MSG_ERROR_REJECT, Constants.MSG_TYPE_ERROR);
        }
    }
Пример #8
0
    public void LoadList()
    {
        Config oConfig = (Config)Session[Constants.SES_USER_CONFIG];

        if (oConfig != null)
        {
            CustomerTypeWiseSPLimit    oCTWiseSPLimit    = new CustomerTypeWiseSPLimit();
            CustomerTypeWiseSPLimitDAL oCTWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();

            Result oResult = oCTWiseSPLimitDAL.LoadUnapprovedList(oConfig.UserName, false);

            if (oResult.Status)
            {
                DataTable dtTmpDataList = (DataTable)oResult.Return;
                DataTable dtTmp         = new DataTable();
                dtTmp = dtTmpDataList.Copy();
                if (dtTmpDataList.Rows.Count > 0)
                {
                    dtTmpDataList.Columns.Remove("CustomerTypeID");
                    dtTmpDataList.Columns.Remove("MakerID");

                    gvList.DataSource = dtTmpDataList;
                    gvList.DataBind();

                    this.gvList.HeaderRow.Cells[1].Text = "Customer Type";
                    this.gvList.HeaderRow.Cells[2].Text = "SP Type";
                    this.gvList.HeaderRow.Cells[3].Text = "Minimum Limit";
                    this.gvList.HeaderRow.Cells[4].Text = "Maximum Limit";
                    this.gvList.HeaderRow.Cells[5].Text = "Make Date";


                    int iStart = gvList.PageIndex * gvList.PageSize;
                    int iEnd   = iStart + gvList.PageSize;
                    if (iEnd >= gvList.Rows.Count)
                    {
                        iEnd = gvList.Rows.Count;
                    }
                    for (int i = iStart; i < iEnd; i++)
                    {
                        HiddenField oHdCust = ((HiddenField)gvList.Rows[i].FindControl("hdCustTypeID"));
                        if (oHdCust != null)
                        {
                            oHdCust.Value = dtTmp.Rows[i]["CustomerTypeID"].ToString();
                        }
                    }

                    Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmp;
                }
                else
                {
                    gvList.DataSource = null;
                    gvList.DataBind();
                }
            }
            else
            {
                ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
            }
        }
        else
        {
            ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR);
        }
    }
Пример #9
0
    public void SearchAction()
    {
        string sType = Request.QueryString["pType"];

        gvData.DataSource = null;
        gvData.DataBind();

        if (!string.IsNullOrEmpty(sType))
        {
            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = new DataTable();

            if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BRANCH).PadLeft(5, '0')))
            {
                #region BRANCH
                lgText.InnerHtml = "Branch Approval Queue List";
                BranchDAL       oBranchDAL = new BranchDAL();
                TemplateBuilder tbGvData   = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Branch' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oBranchDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Branch ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Branch Name";
                            this.gvData.HeaderRow.Cells[3].Text = "BB Code";
                            this.gvData.HeaderRow.Cells[4].Text = "Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion BRANCH
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BD_BANKADDRESS).PadLeft(5, '0')))
            {
                #region Bangladesh Bank Address
                lgText.InnerHtml = "Bangladesh Bank Address Approval Queue List";

                BBAddressDAL    oBBAddressDAL = new BBAddressDAL();
                TemplateBuilder tbGvData      = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Bangladesh Bank Address' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oBBAddressDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet Address";
                            this.gvData.HeaderRow.Cells[3].Text = "Commission Claim Address";
                            this.gvData.HeaderRow.Cells[4].Text = "Interest Claim Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim Address";
                            this.gvData.HeaderRow.Cells[6].Text = "Reinvestment Address";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[8].Text = "Make Date";
                        }
                    }
                }
                #endregion Bangladesh Bank Address
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY).PadLeft(5, '0')))
            {
                #region Currency
                lgText.InnerHtml = "Currency Approval Queue List";
                CurrencyDAL     oCurrencyDAL = new CurrencyDAL();
                TemplateBuilder tbGvData     = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Currency' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCurrencyDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Currency Symbol";
                            this.gvData.HeaderRow.Cells[4].Text = "Currency Description";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion Currency
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CURRENCY_WISE_ACCOUNT_MAPPING).PadLeft(5, '0')))
            {
                #region Currency Wise Account Mapping
                lgText.InnerHtml = "Currency Wise Account Mapping Approval Queue List";
                CurrencyWiseAccountMappingDAL oCurrencyWiseAccountMappingDAL = new CurrencyWiseAccountMappingDAL();
                TemplateBuilder tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Currency Wise Account Mapping ' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCurrencyWiseAccountMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            // for adding seperator....
                            alAddSeperatorIndex = new ArrayList();
                            alAddSeperatorIndex.Add(3);
                            alAddSeperatorIndex.Add(4);
                            alAddSeperatorIndex.Add(5);
                            alAddSeperatorIndex.Add(6);
                            alAddSeperatorIndex.Add(7);

                            dtTmpList.Columns.Remove("SuspenseAccName");
                            dtTmpList.Columns.Remove("ForeignExchangeAccName");
                            dtTmpList.Columns.Remove("BranchFxAccName");
                            dtTmpList.Columns.Remove("BranchExFxAccName");
                            dtTmpList.Columns.Remove("BangladesgBankAccName");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Currency Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Suspense Acc";
                            this.gvData.HeaderRow.Cells[4].Text = "Foreign Exchange Acc";
                            this.gvData.HeaderRow.Cells[5].Text = "Branch Fx Acc";
                            this.gvData.HeaderRow.Cells[6].Text = "Branch Ex Fx Acc";
                            this.gvData.HeaderRow.Cells[7].Text = "Bangladesg Bank Acc";
                            this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[9].Text = "Make Date";
                        }
                    }
                }
                #endregion Currency Wise Account Mapping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_DETAIL).PadLeft(5, '0')))
            {
                #region Customer Detail
                lgText.InnerHtml = "Customer Detail Approval Queue List";
                CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL();
                TemplateBuilder    tbGvData            = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Customer Detail' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCustomerDetailsDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Customer Name";
                            this.gvData.HeaderRow.Cells[3].Text = "Date of Birth";
                            this.gvData.HeaderRow.Cells[4].Text = "Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Phone";
                            this.gvData.HeaderRow.Cells[6].Text = "Email";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[8].Text = "Make Date";
                        }
                    }
                }
                #endregion Customer Detail
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE).PadLeft(5, '0')))
            {
                #region Customer Type
                lgText.InnerHtml = "Customer Type Approval Queue List";
                CustomerTypeDAL oCustomerTypeDAL = new CustomerTypeDAL();
                TemplateBuilder tbGvData         = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Customer Type' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCustomerTypeDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Customer Type Description";
                            this.gvData.HeaderRow.Cells[3].Text = "Max Members";
                            this.gvData.HeaderRow.Cells[4].Text = "Is Organization";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion Customer Type
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.CUSTOMER_TYPE_WISE_SP_LIMIT).PadLeft(5, '0')))
            {
                #region Customer Type wise SP Type Maping
                lgText.InnerHtml = "Customer Type wise SP Type Maping Approval Queue List";

                CustomerTypeWiseSPLimitDAL oCustomerTypeWiseSPLimitDAL = new CustomerTypeWiseSPLimitDAL();
                TemplateBuilder            tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Customer Type wise Sp Type Maping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCustomerTypeWiseSPLimitDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer Type ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Customer Type";
                            this.gvData.HeaderRow.Cells[3].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[4].Text = "Minimum Limit";
                            this.gvData.HeaderRow.Cells[5].Text = "Maximum Limit";
                            this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[7].Text = "Make Date";
                        }
                    }
                }
                #endregion Customer Type wise SP Type Maping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.DIVISION).PadLeft(5, '0')))
            {
                #region Area Approval
                lgText.InnerHtml = "Area Approval Queue List";
                DivisionDAL     oDivisionDAL = new DivisionDAL();
                TemplateBuilder tbGvData     = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Area' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oDivisionDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList.Columns.Remove("BranchID");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Area ID";
                            this.gvData.HeaderRow.Cells[2].Text = "BB Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Area Name";
                            this.gvData.HeaderRow.Cells[4].Text = "Address";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[6].Text = "Make Date";
                        }
                    }
                }
                #endregion Area Approval
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_CERTIFICATE).PadLeft(5, '0')))
            {
                #region Script Mapping Certificate
                lgText.InnerHtml = "Script Mapping Certificate Approval Queue List";
                ScripMappingDAL oScripMappingDAL = new ScripMappingDAL();
                TemplateBuilder tbGvData         = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Script Mapping Certificate' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oScripMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList = DDListUtil.MapTableWithXML(dtTmpList, "ScriptFormatMapping", "ReportType", "SP", 2);

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Denomination";
                            this.gvData.HeaderRow.Cells[3].Text = "Script Format";
                            this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[5].Text = "Maker Date";
                        }
                    }
                }
                #endregion Script Mapping Certificate
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_POLICY).PadLeft(5, '0')))
            {
                #region SP Policy
                lgText.InnerHtml = "SP Policy Approval Queue List";
                SPPolicyDAL     oSPPolicyDAL = new SPPolicyDAL();
                TemplateBuilder tbGvData     = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'SP Policy' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPPolicyDAL.LoadUnapprovedList(null, true);
                if (oResult != null)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList.Columns.Remove("CheckerID");
                            dtTmpList.Columns.Remove("CheckDate");
                            dtTmpList.Columns.Remove("CheckerComment");
                            dtTmpList.Columns.Remove("PolicyEffectDate");
                            dtTmpList.Columns.Remove("IsSPDurationInMonth");
                            dtTmpList.Columns.Remove("SPInterestType");
                            dtTmpList.Columns.Remove("InterestTypeAfterIntPayment");
                            dtTmpList.Columns.Remove("PreMaturityInterestType");
                            dtTmpList.Columns.Remove("PreMatIntTypeAfterIntPayment");
                            dtTmpList.Columns.Remove("IsNomineePerScripRequired");
                            dtTmpList.Columns.Remove("IsBondHolderRequired");
                            dtTmpList.Columns.Remove("IsFoeignAddressRequired");
                            dtTmpList.Columns.Remove("SupportedSex");
                            dtTmpList.Columns.Remove("PartiallyEncashable");
                            dtTmpList.Columns.Remove("ReinvestmentSuported");
                            dtTmpList.Columns.Remove("InterestReinvestable");
                            dtTmpList.Columns.Remove("PartiallyEncashedReinvestable");
                            dtTmpList.Columns.Remove("MaxNoOfReinvestment");
                            dtTmpList.Columns.Remove("NonOrgCommission");
                            dtTmpList.Columns.Remove("NonOrgCommissionType");
                            dtTmpList.Columns.Remove("OrgCommission");
                            dtTmpList.Columns.Remove("OrgCommissionType");
                            dtTmpList.Columns.Remove("Levi");
                            dtTmpList.Columns.Remove("LeviType");
                            dtTmpList.Columns.Remove("IncomeTax");
                            dtTmpList.Columns.Remove("IncomeTaxType");
                            dtTmpList.Columns.Remove("IncomeTaxApplyAmount");
                            dtTmpList.Columns.Remove("IncomeTaxYearlyYN");
                            dtTmpList.Columns.Remove("IsOrganizationLeviTax");
                            dtTmpList.Columns.Remove("InterestRemuneration");
                            dtTmpList.Columns.Remove("InterestRemunerationType");
                            dtTmpList.Columns.Remove("Remuneration");
                            dtTmpList.Columns.Remove("RemunerationType");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Policy ID";
                            this.gvData.HeaderRow.Cells[2].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[3].Text = "SP Duration";
                            this.gvData.HeaderRow.Cells[4].Text = "No Of Coupons";
                            this.gvData.HeaderRow.Cells[5].Text = "Minimum Age";
                            this.gvData.HeaderRow.Cells[6].Text = "Maximum Age";
                            this.gvData.HeaderRow.Cells[7].Text = "Is Approved";
                            this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[9].Text = "Make Date";
                        }
                    }
                }
                #endregion SP Policy
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_REPORT).PadLeft(5, '0')))
            {
                #region Report Mapping
                lgText.InnerHtml = "Report Mapping Approval Queue List";
                SPReportMappingDAL oSPReportMappingDAL = new SPReportMappingDAL();
                TemplateBuilder    tbGvData            = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Report Mapping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPReportMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            DataTable dtMappedData = null;

                            dtMappedData = DDListUtil.MapTableWithXML(dtTmpList, "ReportFormatMapping", "ReportType", "SS", 1);
                            dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "CC", 2);
                            dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "IC", 3);
                            dtMappedData = DDListUtil.MapTableWithXML(dtMappedData, "ReportFormatMapping", "ReportType", "EC", 4);

                            gvData.DataSource = dtMappedData;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtMappedData;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Sales Statemet";
                            this.gvData.HeaderRow.Cells[3].Text = "Commission Claim";
                            this.gvData.HeaderRow.Cells[4].Text = "Interest Claim ";
                            this.gvData.HeaderRow.Cells[5].Text = "Encashment Claim";
                            this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker Date";
                        }
                    }
                }
                #endregion Report Mapping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_TYPE).PadLeft(5, '0')))
            {
                #region Sanchaya Patra Type
                lgText.InnerHtml = "Sanchaya Patra Type Approval Queue List";
                SPTypeDAL       oSPTypeDAL = new SPTypeDAL();
                TemplateBuilder tbGvData   = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Sanchaya Patra Type' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPTypeDAL.LoadTmpDataTableList();
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SP Type";
                            this.gvData.HeaderRow.Cells[2].Text = "Type Description";
                            this.gvData.HeaderRow.Cells[3].Text = "Currency Code";
                            this.gvData.HeaderRow.Cells[4].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[5].Text = "Make Date";
                        }
                    }
                }
                #endregion Sanchaya Patra Type
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SP_WISEA_CCOUNT).PadLeft(5, '0')))
            {
                #region Sanchaya Patra wise Account Mapping
                lgText.InnerHtml = "Sanchaya Patra wise Account Mapping Approval Queue List";
                SPTypeWiseAccountMappingDAL oSPTypeWiseAccountMappingDAL = new SPTypeWiseAccountMappingDAL();
                TemplateBuilder             tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Sanchaya Patra wise Account Mapping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSPTypeWiseAccountMappingDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            // for adding seperator....
                            alAddSeperatorIndex = new ArrayList();
                            alAddSeperatorIndex.Add(2);
                            alAddSeperatorIndex.Add(3);
                            alAddSeperatorIndex.Add(4);
                            alAddSeperatorIndex.Add(5);
                            alAddSeperatorIndex.Add(6);
                            alAddSeperatorIndex.Add(7);

                            dtTmpList.Columns.Remove("StockInHandAccName");
                            dtTmpList.Columns.Remove("LiabilityOnStockAccName");
                            dtTmpList.Columns.Remove("HoldingAccName");
                            dtTmpList.Columns.Remove("AccruedInterestAccName");
                            dtTmpList.Columns.Remove("AdvAgainstInterestAccName");
                            dtTmpList.Columns.Remove("AdvAgainstPrincipalAccName");
                            dtTmpList.Columns.Remove("CheckerID");
                            dtTmpList.Columns.Remove("CheckDate");
                            dtTmpList.Columns.Remove("CheckerComment");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "SPType ID";
                            this.gvData.HeaderRow.Cells[2].Text = "Stock In Hand Acc";
                            this.gvData.HeaderRow.Cells[3].Text = "Liability On  Stock Acc";
                            this.gvData.HeaderRow.Cells[4].Text = "Holding Acc";
                            this.gvData.HeaderRow.Cells[5].Text = "Accrued Interest Acc";
                            this.gvData.HeaderRow.Cells[6].Text = "AdvAgainst Interest Acc";
                            this.gvData.HeaderRow.Cells[7].Text = "Adv Against Principal Acc";
                            this.gvData.HeaderRow.Cells[8].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[9].Text = "Make Date";
                        }
                    }
                }
                #endregion Sanchaya Patra wise Account Mapping
            }
            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.SYSTEM_CONFIG).PadLeft(5, '0')))
            {
                #region System Configuration
                lgText.InnerHtml = "System Configuration Approval Queue List";
                SystemConfigurationDAL oSCDAL   = new SystemConfigurationDAL();
                TemplateBuilder        tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'System Configuration' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oSCDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            dtTmpList.Columns.Remove("Dr_Code");
                            dtTmpList.Columns.Remove("Cr_Code");

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Customer Data File";
                            this.gvData.HeaderRow.Cells[2].Text = "Originator ID";
                            this.gvData.HeaderRow.Cells[3].Text = "Row Type Header";
                            this.gvData.HeaderRow.Cells[4].Text = "Row Type Footer";
                            this.gvData.HeaderRow.Cells[5].Text = "Dr Transaction Code";
                            this.gvData.HeaderRow.Cells[6].Text = "Cr Transaction Code";
                            this.gvData.HeaderRow.Cells[7].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[8].Text = "Make Date";
                        }
                    }
                }
                #endregion System Configuration
            }

            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.COMMON_MAPPING).PadLeft(5, '0')))
            {
                #region Common Mapping
                lgText.InnerHtml = "Common Mapping Approval Queue List";
                CommonMappingDAL oCmAL    = new CommonMappingDAL();
                TemplateBuilder  tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Common Mapping' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oCmAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            alAddSeperatorIndex = new ArrayList();
                            alAddSeperatorIndex.Add(3);

                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;

                            this.gvData.HeaderRow.Cells[1].Text = "Currency ID";
                        }
                    }
                }
                #endregion Common Mapping
            }

            else if (sType.Equals(Convert.ToString((int)Constants.PAGEINDEX_CONFIG.BANK).PadLeft(5, '0')))
            {
                #region Common Mapping
                lgText.InnerHtml = "Bank Setup Approval Queue List";
                BankDAL         oBankDAL = new BankDAL();
                TemplateBuilder tbGvData = new TemplateBuilder();
                tbGvData.AppendLiteralString("No 'Bank Setup' record found");
                gvData.EmptyDataTemplate = tbGvData;

                Result oResult = oBankDAL.LoadUnapprovedList(null, true);
                if (oResult.Status)
                {
                    DataTable dtTmpList = (DataTable)oResult.Return;
                    if (dtTmpList != null)
                    {
                        if (dtTmpList.Rows.Count > 0)
                        {
                            gvData.DataSource = dtTmpList;
                            gvData.DataBind();

                            this.gvData.HeaderRow.Cells[1].Text = "Bank ID";
                            this.gvData.HeaderRow.Cells[2].Text = "BB Code";
                            this.gvData.HeaderRow.Cells[3].Text = "Bank Name";
                            this.gvData.HeaderRow.Cells[4].Text = "Branch ID";
                            this.gvData.HeaderRow.Cells[5].Text = "Address";
                            this.gvData.HeaderRow.Cells[6].Text = "Maker ID";
                            this.gvData.HeaderRow.Cells[7].Text = "Make Date";

                            Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList;
                        }
                    }
                }
                #endregion Common Mapping
            }
        }
    }