protected void ddlSpType_SelectedIndexChanged(object sender, EventArgs e) { string sSPTypeID = ddlSpType.SelectedValue; TotalClear(); if (!string.IsNullOrEmpty(sSPTypeID)) { ddlSpType.Text = sSPTypeID; LoadCurrencyBySPType(ddlSpType.SelectedValue); SPTypeDAL oSPTypeDAL = new SPTypeDAL(); Result oResult = oSPTypeDAL.GetCurrencyBySPTypeID(ddlSpType.SelectedValue); if (oResult.Status) { SPType oSPType = oResult.Return as SPType; ViewState[_BASE_CURRENCY] = oSPType.Currency.CurrencyID; } if (ddlSpType.SelectedValue.Equals(Constants.SP_TYPE_DIB) || ddlSpType.SelectedValue.Equals(Constants.SP_TYPE_DPB)) { txtCovRateToBC.Enabled = true; txtCovRateToBC.Text = "1.0000"; } else { txtCovRateToBC.Text = "1.0000"; txtCovRateToBC.Enabled = false; } } //txtReimConvRate.Text = string.Empty; txtReimConvRate.Enabled = true; txtBBReferenceNo.Focus(); }
private void LoadSPType() { SPTypeDAL oSPTypeDAL = new SPTypeDAL(); Result oResult = (Result)oSPTypeDAL.GetDDLDenomList(ddlSPType.SelectedValue); if (oResult.Status) { ddlDenomination.Items.Clear(); DataTable dtGetDenomID = (DataTable)oResult.Return; if (dtGetDenomID.Rows.Count > 0) { DDListUtil.Assign(ddlDenomination, dtGetDenomID, true); txtSeries.Text = string.Empty; txtFrom.Text = string.Empty; txtTo.Text = string.Empty; txtQuantity.Text = string.Empty; txtDnmAmount.Text = string.Empty; txtDrawerNumber.Text = string.Empty; txtCabinetNumber.Text = string.Empty; gvReceiveDetail.DataSource = null; gvReceiveDetail.DataBind(); } } }
protected void btnSearch_Click(object sender, EventArgs e) { SPType oSPType = new SPType(); SPTypeDAL oSPTypeDAL = new SPTypeDAL(); Result oResult = oSPTypeDAL.SearchList(txtSPTypeID.Text, txtDescription.Text, txtDenom.Text, txtReOrderLevel.Text); DataTable dtTmpList = null; ScriptManager.RegisterStartupScript(this.upSuccess, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchSPType_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; }
private void ReloadList(SPTypeDAL oSPTypeDAL, string sSPTpyeID) { Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; spTypeList = new SPTypeList(); Result oRslSPTypeList = oSPTypeDAL.LoadList(oConfig.UserName); spTypeList = (SPTypeList)oRslSPTypeList.Return; Session[Constants.SES_SPTYPELIST] = spTypeList; LoadSPDataList(spTypeList); LoadDenomDataListBySPTypeID(sSPTpyeID, spTypeList); }
protected void btnSave_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdDataType.Value)) { SPType oSPType = (SPType)Session[Constants.SES_SPTYPE]; if (oSPType == null) { oSPType = new SPType(); } SPTypeDAL oSPTypeDAL = new SPTypeDAL(); oSPType.SPTypeID = Request[txtSpTypeId.UniqueID].Trim().ToUpper(); oSPType.TypeDesc = txtDescription.Text.Trim().ToUpper(); if (!string.IsNullOrEmpty(ddlCurrency.SelectedValue)) { oSPType.Currency.CurrencyID = ddlCurrency.SelectedValue; } oSPType.UserDetails = ucUserDet.UserDetail; oSPType.UserDetails.MakeDate = DateTime.Now; ucUserDet.ResetData(); Result oResult = (Result)oSPTypeDAL.Save(oSPType); if (oResult.Status) { ReloadList(oSPTypeDAL, oSPType.SPTypeID); ClearTextValue(); ResetDenom(); hdDenomID.Value = string.Empty; hdSPTypeID.Value = string.Empty; ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR); } } else { ucMessage.OpenMessage(Constants.MSG_APPROVED_SAVE_DATA, Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); ClearTextValue(); ResetDenom(); hdDenomID.Value = string.Empty; hdSPTypeID.Value = string.Empty; } }
protected void SetDenominationBySPTypeID(SPTypeDAL oSPTypeDAL) { if (oSPTypeDAL == null) { oSPTypeDAL = new SPTypeDAL(); } Result oResult = (Result)oSPTypeDAL.GetDDLDenomList(ddlSPType.SelectedValue); if (oResult.Status) { ddlDenomination.Items.Clear(); DataTable dtGetDenomID = (DataTable)oResult.Return; DDListUtil.Assign(ddlDenomination, dtGetDenomID); } }
protected void btnApprove_Click(object sender, EventArgs e) { SPTypeDAL oSPTypeDAL = new SPTypeDAL(); SPType oSPType = new SPType(hdSPTypeID.Value); oSPType.UserDetails = ucUserDet.UserDetail; Result oResult = (Result)oSPTypeDAL.Approve(oSPType); if (oResult.Status) { ucMessage.OpenMessage(Constants.MSG_SUCCESS_APPROVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_APPROVE, Constants.MSG_TYPE_ERROR); } }
public void SPLoadAction(string sSPTypeID) { if (!string.IsNullOrEmpty(sSPTypeID)) { SPTypeDAL oSpTypeDal = new SPTypeDAL(); Result oResult = oSpTypeDal.LoadByID(sSPTypeID); if (oResult.Status) { SPType oSpType = (SPType)oResult.Return; if (oSpType != null) { hdDataType.Value = oResult.Message; SetSPType(oSpType); Session[Constants.SES_SPTYPE] = oSpType; } } } }
protected void ddlDenomination_SelectedIndexChanged(object sender, EventArgs e) { SPTypeDAL oSPTypeDAL = new SPTypeDAL(); if (!string.IsNullOrEmpty(ddlDenomination.SelectedValue)) { Result oResult = (Result)oSPTypeDAL.GetSeriesName(ddlSPType.SelectedValue, ddlDenomination.SelectedValue); if (oResult.Status) { DataTable dtSeries = (DataTable)oResult.Return; if (dtSeries.Rows.Count > 0) { txtSeries.Text = Convert.ToString(dtSeries.Rows[0]["SPSeries"]); hdDigitsInSlNo.Value = Convert.ToString(dtSeries.Rows[0]["DigitsInSlNo"]); } } } }
protected void btnDelete_Click(object sender, EventArgs e) { if (hdDataType.Value != "M") { SPTypeDAL oSPTypeDAL = new SPTypeDAL(); if (hdSPTypeID.Value != "") { Result oResult = (Result)oSPTypeDAL.Detete(hdSPTypeID.Value); if (oResult.Status) { ReloadList(oSPTypeDAL, string.Empty); ClearTextValue(); ResetDenom(); hdDenomID.Value = string.Empty; hdSPTypeID.Value = string.Empty; 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); } } else { ucMessage.OpenMessage(Constants.MSG_APPROVED_DELETE_DATA, Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel2, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); ClearTextValue(); } }
private void InitializeData() { // Dropdown load SPType DDListUtil.LoadDDLFromDB(ddlSPType, "SPTypeID", "TypeDesc", "SPMS_SPType", true); DDListUtil.LoadDDLFromXML(ddlScriptFormat, "ScriptFormatMapping", "ReportType", "SP", true); gvList.PageSize = (int)Constants.PAGING_UNAPPROVED; SPTypeDAL oSPTypeDAL = new SPTypeDAL(); SetDenominationBySPTypeID(oSPTypeDAL); string sPTypeID = Request.QueryString[OBJ_SPTYPE_ID]; string sDenomID = Request.QueryString[OBJ_DENOM_ID]; string sPageID = Request.QueryString[OBJ_PAGE_ID]; if (!string.IsNullOrEmpty(sPTypeID)) { sPTypeID = oCrypManager.GetDecryptedString(sPTypeID, Constants.CRYPT_PASSWORD_STRING); } if (!string.IsNullOrEmpty(sDenomID)) { sDenomID = oCrypManager.GetDecryptedString(sDenomID, Constants.CRYPT_PASSWORD_STRING); } if (!string.IsNullOrEmpty(sPageID)) { sPageID = oCrypManager.GetDecryptedString(sPageID, Constants.CRYPT_PASSWORD_STRING); } Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; if (!string.IsNullOrEmpty(sPTypeID) && !string.IsNullOrEmpty(sDenomID) && !string.IsNullOrEmpty(sPageID)) { string sOperationType = sPageID.Substring(4, 1); if (Constants.OPERATION_TYPE_APPROVAL.Equals(sOperationType)) { LoadDataByID(sPTypeID, sDenomID); // general Control Util.ControlEnabled(ddlSPType, false); Util.ControlEnabled(ddlDenomination, false); Util.ControlEnabled(ddlScriptFormat, false); // user Detail Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), true); // button Util.ControlEnabled(btnReject, true); Util.ControlEnabled(btnApprove, true); Util.ControlEnabled(btnBack, true); Util.ControlEnabled(btnReset, false); Util.ControlEnabled(btnSave, false); Util.ControlEnabled(btnDelete, false); Util.ControlEnabled(btnSearch, false); #region User-Detail. UserDetails oUserDetails = ucUserDet.UserDetail; oUserDetails.CheckerID = oConfig.UserName; oUserDetails.CheckDate = DateTime.Now; ucUserDet.UserDetail = oUserDetails; #endregion User-Detail. fsList.Visible = false; } } else { // button Util.ControlEnabled(btnReject, false); Util.ControlEnabled(btnApprove, false); Util.ControlEnabled(btnBack, false); Util.ControlEnabled(btnReset, true); Util.ControlEnabled(btnSave, true); Util.ControlEnabled(btnDelete, true); Util.ControlEnabled(btnSearch, true); Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), false); #region User-Detail. UserDetails oUserDetails = new UserDetails(); oUserDetails.MakerID = oConfig.UserName; oUserDetails.MakeDate = DateTime.Now; ucUserDet.UserDetail = oUserDetails; #endregion User-Detail. fsList.Visible = true; LoadList(); } }
private void InitializeData() { Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; gvList.PageSize = (int)Constants.PAGING_UNAPPROVED; if (Session[Constants.SES_SPTYPELIST] == null) { Session.Add(Constants.SES_SPTYPELIST, new SPTypeList()); } else { Session[Constants.SES_SPTYPELIST] = new SPTypeList(); } if (Session[Constants.SES_SPTYPE] == null) { Session.Add(Constants.SES_SPTYPE, new SPType()); } else { Session[Constants.SES_SPTYPE] = new SPType(); } SPTypeDAL spTypeDal = new SPTypeDAL(); spTypeList = new SPTypeList(); Result oRslSPTypeList = spTypeDal.LoadList(oConfig.UserName); spTypeList = (SPTypeList)oRslSPTypeList.Return; Session[Constants.SES_SPTYPELIST] = spTypeList; gvDenom.DataSource = null; gvDenom.DataBind(); hdDataType.Value = ""; // Dropdown load DDListUtil.LoadDDLFromDB(ddlCurrency, "CurrencyID", "CurrencyCode", "SPMS_Currency", true); string sPTypeID = Request.QueryString[OBJ_SPTYPE_ID]; string sPageID = Request.QueryString[OBJ_PAGE_ID]; if (!string.IsNullOrEmpty(sPTypeID)) { sPTypeID = oCrypManager.GetDecryptedString(sPTypeID, Constants.CRYPT_PASSWORD_STRING).Trim(); } if (!string.IsNullOrEmpty(sPageID)) { sPageID = oCrypManager.GetDecryptedString(sPageID, Constants.CRYPT_PASSWORD_STRING).Trim(); } if (!string.IsNullOrEmpty(sPTypeID) && !string.IsNullOrEmpty(sPageID)) { string sOperationType = sPageID.Substring(4, 1); if (Constants.OPERATION_TYPE_APPROVAL.Equals(sOperationType)) { if (spTypeList.ListOfSPType.Count > 0) { LoadDenomDataListBySPTypeID(sPTypeID.Trim(), spTypeList); LoadSPDetailData(sPTypeID.Trim(), spTypeList); } // general Control Util.ControlEnabled(txtSpTypeId, false); Util.ControlEnabled(txtDescription, false); Util.ControlEnabled(ddlCurrency, false); Util.ControlEnabled(txtDenomination, false); Util.ControlEnabled(txtReOrderLevel, false); Util.ControlEnabled(txtSeries, false); Util.ControlEnabled(txtNoOfDigitInSeries, false); // user Detail Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), true); // button Util.ControlEnabled(btnReject, true); Util.ControlEnabled(btnApprove, true); Util.ControlEnabled(btnBack, true); Util.ControlEnabled(btnReset, false); Util.ControlEnabled(btnSave, false); Util.ControlEnabled(btnDelete, false); Util.ControlEnabled(btnLoad, false); Util.ControlEnabled(btnSaveDenom, false); Util.ControlEnabled(btnDenomReset, false); #region User-Detail. UserDetails oUserDetails = ucUserDet.UserDetail; oUserDetails.CheckerID = oConfig.UserName; oUserDetails.CheckDate = DateTime.Now; ucUserDet.UserDetail = oUserDetails; #endregion User-Detail. fsList.Visible = false; fsDenom.Visible = true; } } else { // button Util.ControlEnabled(btnReject, false); Util.ControlEnabled(btnApprove, false); Util.ControlEnabled(btnBack, false); Util.ControlEnabled(btnReset, true); Util.ControlEnabled(btnSave, true); Util.ControlEnabled(btnDelete, true); Util.ControlEnabled(btnLoad, true); Util.ControlEnabled(btnSaveDenom, true); Util.ControlEnabled(btnDenomReset, true); Util.ControlEnabled(ucUserDet.FindControl("txtCheckerComments"), false); #region User-Detail. UserDetails oUserDetails = new UserDetails(); oUserDetails.MakerID = oConfig.UserName; oUserDetails.MakeDate = DateTime.Now; ucUserDet.UserDetail = oUserDetails; #endregion User-Detail. fsList.Visible = true; fsDenom.Visible = true; LoadSPDataList(spTypeList); } }
protected void btnSaveDenom_Click(object sender, EventArgs e) { SPType oSPType = (SPType)Session[Constants.SES_SPTYPE]; Result oResult = new Result(); bool isExist = false; // need to check first for adding can be possible or not... SPTypeDAL oSPTypeDAL = new SPTypeDAL(); if (oSPType.ListOfDenomination.Denomination.Count > 0) { Denomination oDenomSerRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.Series.Equals(txtSeries.Text)).SingleOrDefault(); Denomination oDenomRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(txtDenomination.Text))).SingleOrDefault(); if (oDenomSerRemove != null && oDenomRemove == null) { isExist = true; } } if (!isExist) { oResult = oSPTypeDAL.IsExistSeriesName(txtSeries.Text); if (oResult.Status) { isExist = (bool)oResult.Return; } } if (!isExist) { if (oSPType != null) { if (oSPType.ListOfDenomination.Denomination.Count > 0) { Denomination oDenomRemove = oSPType.ListOfDenomination.Denomination.Where(d => d.DenominationID.Equals(Convert.ToInt32(txtDenomination.Text))).SingleOrDefault(); if (oDenomRemove != null) { oSPType.ListOfDenomination.Denomination.Remove(oDenomRemove); } } } else { oSPType = new SPType(); } Denomination oDenomination = new Denomination(); oDenomination.DenominationID = Util.GetIntNumber(txtDenomination.Text); oDenomination.NoOfDigitsInSeries = Util.GetIntNumber(txtNoOfDigitInSeries.Text); oDenomination.ReOrderLevel = Util.GetIntNumber(txtReOrderLevel.Text); oDenomination.Series = txtSeries.Text.Trim().ToUpper(); oDenomination.SPType.SPTypeID = hdSPTypeID.Value.Trim(); oDenomination.UserDetail = ucUserDet.UserDetail; oSPType.ListOfDenomination.Denomination.Add(oDenomination); Session[Constants.SES_SPTYPE] = oSPType; ReloadDenomTmpListFromSession(); ResetDenom(); } else { ucMessage.OpenMessage("This Series " + txtSeries.Text + " all ready exist for other Denotation !", Constants.MSG_TYPE_ERROR); ScriptManager.RegisterStartupScript(this.UpdatePanel1, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); } }
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 } } }