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;
}
}
