private void BindCustomerMFAlertGrid() { DataTable dtCustomerMFAlerts = new DataTable(); DataRow drMFAlerts; //int count; try { dsCustomerMFAlerts = alertsBo.GetCustomerMFAlerts(customerVo.CustomerId); //Session["SystemAlerts"] = dsSystemAlerts; //if (count > 0) //{ // lblTotalRows.Text = hdnRecordCount.Value = count.ToString(); // tblPager.Visible = true; //} if (dsCustomerMFAlerts.Tables[0].Rows.Count > 0) { lblMessage.Visible = false; dtCustomerMFAlerts.Columns.Add("SchemeId"); dtCustomerMFAlerts.Columns.Add("AccountId"); dtCustomerMFAlerts.Columns.Add("Scheme"); dtCustomerMFAlerts.Columns.Add("SIPReminder"); dtCustomerMFAlerts.Columns.Add("SIPConfirmation"); dtCustomerMFAlerts.Columns.Add("MFAbsoluteStopLoss"); dtCustomerMFAlerts.Columns.Add("MFAbsoluteProfitBooking"); dtCustomerMFAlerts.Columns.Add("SWPReminder"); dtCustomerMFAlerts.Columns.Add("SWPConfirmation"); dtCustomerMFAlerts.Columns.Add("ELSSMaturity"); dtCustomerMFAlerts.Columns.Add("DivTranxOccur"); foreach (DataRow dr in dsCustomerMFAlerts.Tables[0].Rows) { drMFAlerts = dtCustomerMFAlerts.NewRow(); drMFAlerts[0] = dr["MFALT_SchemeId"].ToString(); drMFAlerts[1] = dr["MFALT_AccountId"].ToString(); drMFAlerts[2] = dr["MFALT_SchemeName"].ToString().Trim(); if (dr["MFALT_SIPReminder"].ToString() != null) { drMFAlerts[3] = dr["MFALT_SIPReminder"].ToString(); } if (dr["MFALT_SIPConfirmation"].ToString() != null) { drMFAlerts[4] = dr["MFALT_SIPConfirmation"].ToString(); } if (dr["MFALT_MFAbsoluteStopLoss"].ToString() != null) { drMFAlerts[5] = dr["MFALT_MFAbsoluteStopLoss"].ToString(); } if (dr["MFALT_MFAbsoluteProfitBooking"].ToString() != null) { drMFAlerts[6] = dr["MFALT_MFAbsoluteProfitBooking"].ToString(); } if (dr["MFALT_SWPReminder"].ToString() != null) { drMFAlerts[7] = dr["MFALT_SWPReminder"].ToString().Trim(); } if (dr["MFALT_SWPConfirmation"].ToString() != null) { drMFAlerts[8] = dr["MFALT_SWPConfirmation"].ToString(); } if (dr["MFALT_ELSSMaturity"].ToString() != null) { drMFAlerts[9] = dr["MFALT_ELSSMaturity"].ToString(); } if (dr["MFALT_DivTranx"].ToString() != null) { drMFAlerts[10] = dr["MFALT_DivTranx"].ToString().Trim(); } dtCustomerMFAlerts.Rows.Add(drMFAlerts); } gvMFAlerts.DataSource = dtCustomerMFAlerts; gvMFAlerts.DataBind(); gvMFAlerts.Visible = true; //this.GetPageCount(); } else { lblMessage.Visible = true; lblDisclaimer.Visible = false; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "CustomerMFAlert.ascx:BindCustomerMFAlertGrid()"); object[] objects = new object[0]; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }