private void DisplayRevenueExpenseSummaryReport()
{
Double percentage = 0;
String fiscalYear = "FY2014";//(String)Session["MostRecentFY"];
RetrieveFromDB rtrvDB = new RetrieveFromDB();
DataTable tbl = rtrvDB.DisplayRevenueExpenseSummaryReport(fiscalYear);
if (Percentage.Text != String.Empty)
{
percentage = Double.Parse(Percentage.Text) / 100;
}
else
{
percentage = 0;
}
tbl.Columns.Add("Year1", typeof(System.Double));
tbl.Columns.Add("Year2", typeof(System.Double));
tbl.Columns.Add("Year3", typeof(System.Double));
tbl.Columns.Add("Year4", typeof(System.Double));
foreach (DataRow dr in tbl.Rows)
{
dr["Year1"] = (Double.Parse(dr[1].ToString()) * percentage) + Double.Parse(dr[1].ToString());
dr["Year2"] = (Double.Parse(dr[3].ToString()) * percentage) + Double.Parse(dr[3].ToString());
dr["Year3"] = (Double.Parse(dr[4].ToString()) * percentage) + Double.Parse(dr[4].ToString());
dr["Year4"] = (Double.Parse(dr[5].ToString()) * percentage) + Double.Parse(dr[5].ToString());
}
string year = fiscalYear.GetLast(4);
String fiscalYear1 = "FY" + (int.Parse(year)+ 1);
String fiscalYear2 = "FY" + (int.Parse(year) + 2);
String fiscalYear3 = "FY" + (int.Parse(year) + 3);
String fiscalYear4 = "FY" + (int.Parse(year) + 4);
SummaryReportGridView.Columns[1].HeaderText = fiscalYear;
SummaryReportGridView.Columns[2].HeaderText = fiscalYear1;
SummaryReportGridView.Columns[3].HeaderText = fiscalYear2;
SummaryReportGridView.Columns[4].HeaderText = fiscalYear3;
SummaryReportGridView.Columns[5].HeaderText = fiscalYear4;
SummaryReportPanel.Visible = true;
SummaryReportGridView.DataSource = tbl;
SummaryReportGridView.DataBind();
}
