protected void btnDelete_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdBankID.Value)) { BankDAL oBankDAL = new BankDAL(); Result oResult = (Result)oBankDAL.Detete(hdBankID.Value); if (oResult.Status) { LoadList(); ClearTextValue(); hdBankID.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 static List <BankSubsidiary> GetBankSubsidiary(NameValueCollection querystring) { string criteria = querystring.Get("Criteria"); int branchID = int.TryParse(querystring.Get("BranchID"), out branchID) ? branchID : 0; return(BankDAL.GetBankSubsidiary(branchID, criteria)); }
public DataSet ReadDetails() { DataSet set = new DataSet(); BankDAL bankDAL = new BankDAL(); var data = bankDAL.GetListOfBanks(); set.Tables.Add(data); return(set); }
private void LoadDataByID(string sBankID) { Bank oBank = new Bank(sBankID); BankDAL oBankDAL = new BankDAL(); Result oResult = new Result(); oResult = oBankDAL.LoadByID(oBank); if (oResult.Status) { oBank = (Bank)oResult.Return; txtBankID.Text = oBank.BankID.Trim(); txtBankID.ReadOnly = true; txtDivisionName.Text = oBank.DivisionName; txtBdBankCode.Text = oBank.BBCode; txtAddress.Text = oBank.Address; txtZipCode.Text = oBank.ZipCode; txtPhoneNumber.Text = oBank.Phone; txtEmailID.Text = oBank.Email; txtFaxNumber.Text = oBank.Fax; txtSWIFTBIC.Text = oBank.SWIFTBIC; if (string.IsNullOrEmpty(hdDataType.Value)) { //When Loading from Approver End UserDetails userDetails = ucUserDet.UserDetail; userDetails.MakerID = oBank.UserDetails.MakerID; userDetails.MakeDate = oBank.UserDetails.MakeDate; ucUserDet.UserDetail = userDetails; } else if (hdDataType.Value.Equals("T")) { //When loading from temp table UserDetails userDetails = ucUserDet.UserDetail; userDetails.CheckerID = oBank.UserDetails.CheckerID; userDetails.CheckDate = oBank.UserDetails.CheckDate; userDetails.CheckerComment = oBank.UserDetails.CheckerComment; ucUserDet.UserDetail = userDetails; } DDListUtil.Assign(ddlBranchCode, oBank.Branch.BranchID); DDListUtil.Assign(ddlToMonth, oBank.FiscalToMonth.ToString()); DDListUtil.Assign(ddlFromMonth, oBank.FiscalFormMonth.ToString()); DDListUtil.Assign(ddlCountryName, oBank.Country.ToString()); hdBankID.Value = sBankID; } else { ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR); } }
protected void btnSave_Click(object sender, EventArgs e) { Bank oBank = new Bank(); BankDAL oBankDAL = new BankDAL(); oBank.BankID = Request[txtBankID.UniqueID].Trim().ToUpper(); if (!string.IsNullOrEmpty(ddlBranchCode.SelectedItem.Value)) { oBank.Branch.BranchID = ddlBranchCode.SelectedItem.Value; } oBank.DivisionName = txtDivisionName.Text; oBank.BBCode = txtBdBankCode.Text; oBank.Address = txtAddress.Text; oBank.ZipCode = txtZipCode.Text; oBank.Phone = txtPhoneNumber.Text; if (!string.IsNullOrEmpty(ddlCountryName.SelectedItem.Value)) { oBank.Country = ddlCountryName.SelectedItem.Value; } oBank.Email = txtEmailID.Text; oBank.Fax = txtFaxNumber.Text; oBank.SWIFTBIC = txtSWIFTBIC.Text; if (!string.IsNullOrEmpty(ddlFromMonth.SelectedItem.Value)) { oBank.FiscalFormMonth = Convert.ToInt16(ddlFromMonth.SelectedItem.Value); } if (!string.IsNullOrEmpty(ddlToMonth.SelectedItem.Value)) { oBank.FiscalToMonth = Convert.ToInt16(ddlToMonth.SelectedItem.Value); } oBank.UserDetails = ucUserDet.UserDetail; oBank.UserDetails.MakeDate = DateTime.Now; ucUserDet.ResetData(); Result oResult = (Result)oBankDAL.Save(oBank); if (oResult.Status) { LoadList(); ClearTextValue(); hdBankID.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(); Result oResult = new Result(); if (Type.Equals("BankSearch")) { BankDAL oBDAL = new BankDAL(); oResult = oBDAL.AppSearchList(txtID.Text, txtName.Text); } else if (Type.Equals("DivisionSearch")) { DivisionDAL oDivisionDAL = new DivisionDAL(); oResult = oDivisionDAL.AppSearchList(txtID.Text, txtName.Text); } else if (Type.Equals("CurrencySearch")) { CurrencyDAL oCurrencyDAL = new CurrencyDAL(); oResult = oCurrencyDAL.AppSearchList(txtID.Text, txtName.Text); } else if (Type.Equals("BranchSearch")) { BranchDAL oBranchDAL = new BranchDAL(); oResult = oBranchDAL.AppSearchList(txtID.Text, txtName.Text); } ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchConfComm_lblProgress') ", true); if (oResult.Status) { DataTable dtTmpCustomerTypeList = (DataTable)oResult.Return; if (dtTmpCustomerTypeList.Rows.Count > 0) { gvSearchList.DataSource = dtTmpCustomerTypeList; gvSearchList.DataBind(); } else { gvSearchList.DataSource = null; gvSearchList.DataBind(); } Session[Constants.SES_CONFIG_APPROVE_DATA] = dtTmpCustomerTypeList; } ScriptManager.RegisterStartupScript(this.upGv, typeof(string), Constants.POPUP_WINDOW, " HideProgressStatus('ctl00_cphDet_ucSearchConfComm_lblProgress') ", true); }
public void LoadList() { Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; if (oConfig != null) { Bank oBank = new Bank(); BankDAL oBankDAL = new BankDAL(); Result oResult = oBankDAL.LoadUnapprovedList(oConfig.UserName, false); if (oResult.Status) { DataTable dtTmpList = (DataTable)oResult.Return; if (dtTmpList.Rows.Count > 0) { dtTmpList.Columns.Remove("MakerID"); gvBankList.DataSource = dtTmpList; gvBankList.DataBind(); Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpList; } else { gvBankList.DataSource = null; gvBankList.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); } }
protected void btnApprove_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdBankID.Value)) { Bank oBank = new Bank(hdBankID.Value); BankDAL oBankDAL = new BankDAL(); oBank.UserDetails = ucUserDet.UserDetail; Result oResult = (Result)oBankDAL.Approve(oBank); 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_APPROVE, Constants.MSG_TYPE_ERROR); } }
public static string ManageBank(NameValueCollection querystring) { int integerParse; Boolean boolParser; UserProfile userProfile = WebCommon.GetUserProfile(); var bankSubsidiary = new BankSubsidiary { BankID = int.TryParse(querystring.Get("BankID"), out integerParse) ? integerParse : 0, BankAccountName = querystring.Get("BankAccountName"), BankAccountNO = querystring.Get("BankAccountNo"), Bank = querystring.Get("Bank"), intIDmasLocation = int.TryParse(querystring.Get("intIDMasLocation"), out integerParse) ? integerParse : 0, IsActive = Boolean.TryParse(querystring.Get("IsActive"), out boolParser) ? boolParser : false, intIDMasBankAccount = int.TryParse(querystring.Get("intIDMasBankAccount"), out integerParse) ? integerParse : 0, }; string isInsert = querystring.Get("TransType"); string param = WebCommon.ToXML(bankSubsidiary); return(BankDAL.ManageBank(param, isInsert)); }
public BankBO() { bankDAL = new BankDAL(); }
public BankBL() { accountDal = new BankDAL(); }
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 } } }
public static List <string> GetBankList() { return(BankDAL.GetBankList()); }