protected void btnMasterLoad_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtMasterNo.Text)) { CustomerDetails oCustomerDetails = new CustomerDetails(); oCustomerDetails.MasterNo = txtMasterNo.Text; CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); Result oResult = new Result(); //ClearData(); oResult = oCustomerDetailsDAL.LoadByMasterID(oCustomerDetails); if (oResult.Status) { SetCustomerDetails(oCustomerDetails); hdTmpCustomerID.Value = ""; } else { ClearData(); } } StringBuilder sbUrl = new StringBuilder(); sbUrl.Append("<script> "); sbUrl.Append(" CustomerDetailPopup() "); sbUrl.Append("</script>"); Page.RegisterStartupScript("OpenWindows", sbUrl.ToString()); }
protected void btnMasterLoad_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtMasterNo.Text)) { CustomerDetails oCustomerDetails = new CustomerDetails(); oCustomerDetails.MasterNo = txtMasterNo.Text; CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); Result oResult = new Result(); ClearData(); oResult = oCustomerDetailsDAL.LoadByMasterID(oCustomerDetails); if (oResult.Status) { //txtCustomerID.Text = Convert.ToString(oCustomerDetails.CustomerID); //txtMasterNo.Text = oCustomerDetails.MasterNo; //txtCustomerName.Text = oCustomerDetails.CustomerName; //txtPhone.Text = oCustomerDetails.Phone; //txtAddress.Text = oCustomerDetails.Address; //txtDateofBirth.Text = oCustomerDetails.DateOfBirth.ToString(Constants.DATETIME_FORMAT); //ddlSex.Text = oCustomerDetails.Sex; //ddlResidenceStatus.Text = oCustomerDetails.ResidenceStatus; //txtNationalID.Text = oCustomerDetails.NationalID; //txtEmail.Text = oCustomerDetails.EmailAddress; //hdTmpCustomerID.Value = ""; SetCustomerDetails(oCustomerDetails); } } StringBuilder sbUrl = new StringBuilder(); sbUrl.Append("<script> "); sbUrl.Append(" CustomerDetailPopup() "); sbUrl.Append("</script>"); Page.RegisterStartupScript("OpenWindows", sbUrl.ToString()); }
protected void btnDelete_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdCustomerID.Value)) { CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); Result oResult = (Result)oCustomerDetailsDAL.Detete(hdCustomerID.Value); if (oResult.Status) { this.LoadList(); this.ClearTextValue(); hdCustomerID.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); } }
protected void btnMasterLoad_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request[txtMasterNo.UniqueID].Trim().ToUpper())) { CustomerDetails oCustomerDetails = new CustomerDetails(); oCustomerDetails.MasterNo = txtMasterNo.Text; CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); Result oResult = new Result(); ClearTextValue(); oResult = oCustomerDetailsDAL.LoadByID(oCustomerDetails); if (oResult.Status) { txtMasterNo.Text = oCustomerDetails.MasterNo; txtCustomerName.Text = oCustomerDetails.CustomerName; txtPhone.Text = oCustomerDetails.Phone; txtAddress.Text = oCustomerDetails.Address; txtNationalID.Text = oCustomerDetails.NationalID; txtEmail.Text = oCustomerDetails.EmailAddress; hdCustomerID.Value = ""; } } else { ucMessage.OpenMessage("Master ID cannot be null for this types of searching", Constants.MSG_TYPE_ERROR); } }
protected void btnSave_Click(object sender, EventArgs e) { CustomerDetails oCustomerDetails = new CustomerDetails(); CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); oCustomerDetails.CustomerID = Util.GetIntNumber(Request[hdCustomerID.UniqueID] == "" ? "-1" : Request[hdCustomerID.UniqueID].Trim().ToUpper()); txtCustomerID.Text = Request[hdCustomerID.UniqueID].Trim().ToUpper(); oCustomerDetails.CustomerName = txtCustomerName.Text; oCustomerDetails.Address = txtAddress.Text; oCustomerDetails.ForeignAddress = txtForignAddress.Text; oCustomerDetails.Phone = txtPhone.Text; oCustomerDetails.DateOfBirth = Util.GetDateTimeByString(txtDateofBirth.Text); oCustomerDetails.Sex = ddlSex.SelectedItem.Value; oCustomerDetails.Nationality = txtNationality.Text; oCustomerDetails.PassportNo = txtPassportNo.Text; oCustomerDetails.PassportNo_IssuedAt = txtIssueAt.Text; oCustomerDetails.NationalID = txtNationalID.Text; oCustomerDetails.BirthCertificateNo = txtBirthCertNo.Text; oCustomerDetails.EmailAddress = txtEmail.Text; oCustomerDetails.CustomerName2 = txtCustomerName2.Text; oCustomerDetails.Address2 = txtAddress2.Text; oCustomerDetails.ForeignAddress2 = txtForignAddress2.Text; oCustomerDetails.Phone2 = txtPhone2.Text; oCustomerDetails.DateOfBirth2 = Util.GetDateTimeByString(txtDateofBirth2.Text); oCustomerDetails.Sex2 = ddlSex2.SelectedItem.Value; oCustomerDetails.Nationality2 = txtNationality2.Text; oCustomerDetails.PassportNo2 = txtPassportNo2.Text; oCustomerDetails.IssuedAt2 = txtIssueAt2.Text; oCustomerDetails.NationalID2 = txtNationalID2.Text; oCustomerDetails.BirthCertificateNo2 = txtBirthCertNo2.Text; oCustomerDetails.EmailAddress2 = txtEmail2.Text; oCustomerDetails.UserDetails = ucUserDet.UserDetail; oCustomerDetails.UserDetails.MakeDate = DateTime.Now; ucUserDet.ResetData(); Result oResult = (Result)oCustomerDetailsDAL.Save(oCustomerDetails); if (oResult.Status) { this.LoadList(); this.ClearTextValue(); hdCustomerID.Value = string.Empty; ucMessage.OpenMessage(Constants.MSG_SUCCESS_SAVE, Constants.MSG_TYPE_SUCCESS); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_SAVE, Constants.MSG_TYPE_ERROR); } }
private void LoadDataByID(int sCustomerID) { CustomerDetails oCustomerDetails = new CustomerDetails(sCustomerID); CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); Result oResult = new Result(); oResult = oCustomerDetailsDAL.LoadByID(oCustomerDetails); if (oResult.Status) { oCustomerDetails = (CustomerDetails)oResult.Return; txtCustomerID.Text = oCustomerDetails.CustomerID.ToString(); txtCustomerID.ReadOnly = true; txtCustomerName.Text = oCustomerDetails.CustomerName; txtAddress.Text = oCustomerDetails.Address; txtForignAddress.Text = oCustomerDetails.ForeignAddress; txtPhone.Text = oCustomerDetails.Phone; txtDateofBirth.Text = oCustomerDetails.DateOfBirth.ToString(Constants.DATETIME_FORMAT); ddlSex.Text = oCustomerDetails.Sex.ToString(); txtNationality.Text = oCustomerDetails.Nationality; txtPassportNo.Text = oCustomerDetails.PassportNo; txtIssueAt.Text = oCustomerDetails.PassportNo_IssuedAt; txtNationalID.Text = oCustomerDetails.NationalID; txtBirthCertNo.Text = oCustomerDetails.BirthCertificateNo; txtEmail.Text = oCustomerDetails.EmailAddress; txtCustomerName2.Text = oCustomerDetails.CustomerName2; txtAddress2.Text = oCustomerDetails.Address2; txtForignAddress2.Text = oCustomerDetails.ForeignAddress2; txtPhone2.Text = oCustomerDetails.Phone2; txtDateofBirth2.Text = oCustomerDetails.DateOfBirth2.ToString(Constants.DATETIME_FORMAT); ddlSex2.Text = oCustomerDetails.Sex2.ToString(); txtNationality2.Text = oCustomerDetails.Nationality2; txtPassportNo2.Text = oCustomerDetails.PassportNo2; txtIssueAt2.Text = oCustomerDetails.IssuedAt2; txtNationalID2.Text = oCustomerDetails.NationalID2; txtBirthCertNo2.Text = oCustomerDetails.BirthCertificateNo2; txtEmail2.Text = oCustomerDetails.EmailAddress2; ucUserDet.UserDetail = oCustomerDetails.UserDetails; hdCustomerID.Value = sCustomerID.ToString(); } else { ucMessage.OpenMessage(Constants.MSG_ERROR_NOT_FOUND, Constants.MSG_TYPE_ERROR); } }
protected void btnCustomerLoad_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request[txtCustomerID.UniqueID].Trim().ToUpper())) { CustomerDetails oCustomerDetails = new CustomerDetails(Util.GetIntNumber(Request[txtCustomerID.UniqueID].Trim().ToUpper())); CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); Result oResult = new Result(); oResult = oCustomerDetailsDAL.LoadByID(oCustomerDetails); if (oResult.Status) { ClearTextValue(); oCustomerDetails = (CustomerDetails)oResult.Return; txtCustomerID.Text = oCustomerDetails.CustomerID.ToString(); txtCustomerName.Text = oCustomerDetails.CustomerName; txtAddress.Text = oCustomerDetails.Address; txtForignAddress.Text = oCustomerDetails.ForeignAddress; txtPhone.Text = oCustomerDetails.Phone; txtDateofBirth.Text = oCustomerDetails.DateOfBirth.ToString(Constants.DATETIME_FORMAT); ddlSex.Text = oCustomerDetails.Sex.ToString(); txtNationality.Text = oCustomerDetails.Nationality; txtPassportNo.Text = oCustomerDetails.PassportNo; txtIssueAt.Text = oCustomerDetails.PassportNo_IssuedAt; txtNationalID.Text = oCustomerDetails.NationalID; txtBirthCertNo.Text = oCustomerDetails.BirthCertificateNo; txtEmail.Text = oCustomerDetails.EmailAddress; txtCustomerName2.Text = oCustomerDetails.CustomerName2; txtAddress2.Text = oCustomerDetails.Address2; txtForignAddress2.Text = oCustomerDetails.ForeignAddress2; txtPhone2.Text = oCustomerDetails.Phone2; txtDateofBirth2.Text = oCustomerDetails.DateOfBirth2.ToString(Constants.DATETIME_FORMAT); ddlSex2.Text = oCustomerDetails.Sex2.ToString(); txtNationality2.Text = oCustomerDetails.Nationality2; txtPassportNo2.Text = oCustomerDetails.PassportNo2; txtIssueAt2.Text = oCustomerDetails.IssuedAt2; txtNationalID2.Text = oCustomerDetails.NationalID2; txtBirthCertNo2.Text = oCustomerDetails.BirthCertificateNo2; txtEmail2.Text = oCustomerDetails.EmailAddress2; hdCustomerID.Value = oCustomerDetails.CustomerID.ToString(); } } else { ucMessage.OpenMessage("Customer ID cannot be null for this types of searching", Constants.MSG_TYPE_ERROR); } }
public void LoadList() { Config oConfig = (Config)Session[Constants.SES_USER_CONFIG]; if (oConfig != null) { CustomerDetails oCustomerDetails = new CustomerDetails(); CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); Result oResult = oCustomerDetailsDAL.LoadUnapprovedList(oConfig.UserName, false); if (oResult.Status) { DataTable dtTmpDataList = (DataTable)oResult.Return; if (dtTmpDataList.Rows.Count > 0) { dtTmpDataList.Columns.Remove("MakerID"); gvList.DataSource = dtTmpDataList; gvList.DataBind(); Session[Constants.SES_CONFIG_UNAPPROVE_DATA] = dtTmpDataList; this.gvList.HeaderRow.Cells[1].Text = "Customer ID"; this.gvList.HeaderRow.Cells[2].Text = "Customer Name"; this.gvList.HeaderRow.Cells[3].Text = "Date of Birth"; this.gvList.HeaderRow.Cells[4].Text = "Address"; this.gvList.HeaderRow.Cells[5].Text = "Phone"; this.gvList.HeaderRow.Cells[6].Text = "Email"; this.gvList.HeaderRow.Cells[7].Text = "Make Date"; } 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); } }
protected void gvCustomerDetail_RowCommand(object sender, GridViewCommandEventArgs e) { GridViewRow gvRow = (GridViewRow)((Button)e.CommandSource).NamingContainer; if (((Button)e.CommandSource).Text.Equals("Select")) { CustomerDetailsDAL oCustDetlDAL = new CustomerDetailsDAL(); CustomerDetails oCustDetl = new CustomerDetails(); oCustDetl.CustomerID = Convert.ToInt32(gvRow.Cells[1].Text); oCustDetl.isViewOnly = true; Result oResult = oCustDetlDAL.LoadOnlyMainByID(oCustDetl); if (oResult.Status) { CustomerDetail.SetCustomerDetails(oResult.Return as CustomerDetails); } } }
protected void btnApprove_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(hdCustomerID.Value)) { CustomerDetails oCustomerDetails = new CustomerDetails(Convert.ToInt32(hdCustomerID.Value == "" ? "-1" : hdCustomerID.Value)); CustomerDetailsDAL oCustomerDetailsDAL = new CustomerDetailsDAL(); oCustomerDetails.UserDetails = ucUserDet.UserDetail; Result oResult = (Result)oCustomerDetailsDAL.Approve(oCustomerDetails); 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); } }
protected void txtPDAccDraftNo_TextChanged(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtPDAccDraftNo.Text)) { if (txtPDAccDraftNo.Text.Length < 13) { ucMessage.OpenMessage("Account no. must be 13 digits (with currency code)", Constants.MSG_TYPE_INFO); ScriptManager.RegisterStartupScript(this.UpdatePanel3, typeof(string), Constants.POPUP_WINDOW, Util.OpenPopup("info"), true); txtAccountName.Text = string.Empty; return; } CustomerDetailsDAL oCDDal = new CustomerDetailsDAL(); Result oResult = oCDDal.LoadDataFromBDDB2ByAccountNo(txtPDAccDraftNo.Text); if (oResult.Status) { DataTable dt = (DataTable)oResult.Return; if (dt.Rows.Count != 0) { txtAccountName.Text = Convert.ToString(dt.Rows[0]["AciAccName"]); } else { txtAccountName.Text = string.Empty; } } else { txtAccountName.Text = string.Empty; } } else { txtAccountName.Text = string.Empty; } }
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 } } }