public void LoadGridview(int portfolioId) { List <GovtSavingsVo> govtSavingsList = new List <GovtSavingsVo>(); int count = 0; try { govtSavingsList = govtSavingsBo.GetGovtSavingsNPList(portfolioId, mypager.CurrentPage, hdnSort.Value, out count); //if (count > 0) //{ // lblTotalRows.Text = hdnRecordCount.Value = count.ToString(); // tblPager.Visible = true; //} if (govtSavingsList != null) { //lblMsg.Visible = false; tblMessage.Visible = false; ErrorMessage.Visible = false; btnExportFilteredData.Visible = true; ErrorMessage.InnerText = "No Records Found...!"; GovtSavingsVo govtSavingsVo; DataTable dtGovtSavings = new DataTable(); dtGovtSavings.Columns.Add("SI.No"); dtGovtSavings.Columns.Add("GovtSavingId"); dtGovtSavings.Columns.Add("Category"); dtGovtSavings.Columns.Add("Particulars"); dtGovtSavings.Columns.Add("Deposit Date", typeof(DateTime)); dtGovtSavings.Columns.Add("Maturity Date", typeof(DateTime)); dtGovtSavings.Columns.Add("Deposit Amount", typeof(double)); dtGovtSavings.Columns.Add("Rate Of Interest", typeof(double)); dtGovtSavings.Columns.Add("Current Value", typeof(double)); dtGovtSavings.Columns.Add("Maturity Value", typeof(double)); dtGovtSavings.Columns.Add("Amount", typeof(double)); dtGovtSavings.Columns.Add("ModeOfPayment"); dtGovtSavings.Columns.Add("PaymentInstrumentNumber"); dtGovtSavings.Columns.Add("PaymentInstrumentDate", typeof(DateTime)); dtGovtSavings.Columns.Add("BankName"); dtGovtSavings.Columns.Add("BankBranch"); dtGovtSavings.Columns.Add("Nomniee"); dtGovtSavings.Columns.Add("JointHolderName"); DataRow drGovtSavings; for (int i = 0; i < govtSavingsList.Count; i++) { drGovtSavings = dtGovtSavings.NewRow(); govtSavingsVo = new GovtSavingsVo(); govtSavingsVo = govtSavingsList[i]; drGovtSavings[0] = (i + 1).ToString(); drGovtSavings[1] = govtSavingsVo.GoveSavingsPortfolioId.ToString(); drGovtSavings[2] = govtSavingsVo.AssetInstrumentCategoryName.ToString(); drGovtSavings[3] = govtSavingsVo.Name.ToString(); if (govtSavingsVo.PurchaseDate != DateTime.MinValue) { drGovtSavings[4] = govtSavingsVo.PurchaseDate.ToShortDateString().ToString(); } if (govtSavingsVo.MaturityDate != DateTime.MinValue) { drGovtSavings[5] = govtSavingsVo.MaturityDate.ToShortDateString().ToString(); } // if (govtSavingsVo.DepositAmt != null) drGovtSavings[6] = govtSavingsVo.DepositAmt.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); //if (govtSavingsVo.InterestRate != null) drGovtSavings[7] = govtSavingsVo.InterestRate.ToString(); //if (govtSavingsVo.CurrentValue != null) drGovtSavings[8] = govtSavingsVo.CurrentValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); //if(govtSavingsVo.MaturityValue != null) drGovtSavings[9] = govtSavingsVo.MaturityValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); drGovtSavings[10] = govtSavingsVo.Amount.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); drGovtSavings[11] = govtSavingsVo.ModeOfPayment.ToString(); drGovtSavings[12] = govtSavingsVo.PaymentInstrumentNumber.ToString(); if (govtSavingsVo.PaymentInstrumentDate != DateTime.MinValue) { drGovtSavings[13] = govtSavingsVo.PaymentInstrumentDate.ToString(); } drGovtSavings[14] = govtSavingsVo.BankName; drGovtSavings[15] = govtSavingsVo.BankBranch; drGovtSavings[16] = govtSavingsVo.Nomniee; drGovtSavings[17] = govtSavingsVo.JontHolderName; dtGovtSavings.Rows.Add(drGovtSavings); } if (dtGovtSavings.Rows.Count > 0) { if (Cache["gvGovtSavings" + customerVo.CustomerId] == null) { Cache.Insert("gvGovtSavings" + customerVo.CustomerId, dtGovtSavings); } else { Cache.Remove("gvGovtSavings" + customerVo.CustomerId); Cache.Insert("gvGovtSavings" + customerVo.CustomerId, dtGovtSavings); } gvGovtSavings.DataSource = dtGovtSavings; gvGovtSavings.DataBind(); gvGovtSavings.Visible = true; // this.GetPageCount(); } } else { //lblMsg.Visible = true; tblMessage.Visible = true; ErrorMessage.Visible = true; ErrorMessage.InnerText = "No Records Found...!"; gvGovtSavings.DataSource = null; gvGovtSavings.DataBind(); gvGovtSavings.Visible = false; } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewGovtSavings.ascx.cs:LoadGridview()"); object[] objects = new object[2]; objects[0] = govtSavingsList; objects[1] = portfolioId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
public void LoadGridview(int portfolioId) { List <GovtSavingsVo> govtSavingsList = new List <GovtSavingsVo>(); int count = 0; try { govtSavingsList = govtSavingsBo.GetGovtSavingsNPList(portfolioId, mypager.CurrentPage, hdnSort.Value, out count); if (count > 0) { lblTotalRows.Text = hdnRecordCount.Value = count.ToString(); tblPager.Visible = true; } if (govtSavingsList != null) { lblMsg.Visible = false; GovtSavingsVo govtSavingsVo; DataTable dtGovtSavings = new DataTable(); dtGovtSavings.Columns.Add("SI.No"); dtGovtSavings.Columns.Add("GovtSavingId"); dtGovtSavings.Columns.Add("Category"); dtGovtSavings.Columns.Add("Particulars"); dtGovtSavings.Columns.Add("Deposit Date"); dtGovtSavings.Columns.Add("Maturity Date"); dtGovtSavings.Columns.Add("Deposit Amount"); dtGovtSavings.Columns.Add("Rate Of Interest"); dtGovtSavings.Columns.Add("Current Value"); dtGovtSavings.Columns.Add("Maturity Value"); DataRow drGovtSavings; for (int i = 0; i < govtSavingsList.Count; i++) { drGovtSavings = dtGovtSavings.NewRow(); govtSavingsVo = new GovtSavingsVo(); govtSavingsVo = govtSavingsList[i]; drGovtSavings[0] = (i + 1).ToString(); drGovtSavings[1] = govtSavingsVo.GoveSavingsPortfolioId.ToString(); drGovtSavings[2] = govtSavingsVo.AssetInstrumentCategoryName.ToString(); drGovtSavings[3] = govtSavingsVo.Name.ToString(); if (govtSavingsVo.PurchaseDate != DateTime.MinValue) { drGovtSavings[4] = govtSavingsVo.PurchaseDate.ToShortDateString().ToString(); } if (govtSavingsVo.MaturityDate != DateTime.MinValue) { drGovtSavings[5] = govtSavingsVo.MaturityDate.ToShortDateString().ToString(); } // if (govtSavingsVo.DepositAmt != null) drGovtSavings[6] = govtSavingsVo.DepositAmt.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); //if (govtSavingsVo.InterestRate != null) drGovtSavings[7] = govtSavingsVo.InterestRate.ToString(); //if (govtSavingsVo.CurrentValue != null) drGovtSavings[8] = govtSavingsVo.CurrentValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); //if(govtSavingsVo.MaturityValue != null) drGovtSavings[9] = govtSavingsVo.MaturityValue.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); dtGovtSavings.Rows.Add(drGovtSavings); } gvrGovtSavings.DataSource = dtGovtSavings; gvrGovtSavings.DataBind(); gvrGovtSavings.Visible = true; this.GetPageCount(); } else { lblMsg.Visible = true; gvrGovtSavings.DataSource = null; gvrGovtSavings.DataBind(); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "ViewGovtSavings.ascx.cs:LoadGridview()"); object[] objects = new object[2]; objects[0] = govtSavingsList; objects[1] = portfolioId; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }