private void DisplayRevenueExpenseSummaryReport()
{
ProjectionPercentages percentages = new ProjectionPercentages();
percentages = (ProjectionPercentages)ViewState["percentages"];
if (percentages == null)
{
percentages = CalculatePercentage();
}
String fiscalYear = (String)Session["MostRecentFY"];
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);
StoredProcedures sp = new StoredProcedures();
DataTable tbl = sp.DisplayProjections(fiscalYear);
ProjectionsLabel.Text = "Projections " + fiscalYear;
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));
tbl.Columns.Add("Percentage", typeof(System.Double));
tbl.Rows[0]["Year1"] = (Double.Parse(tbl.Rows[0][1].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][1].ToString());
tbl.Rows[0]["Year2"] = (Double.Parse(tbl.Rows[0][3].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][3].ToString());
tbl.Rows[0]["Year3"] = (Double.Parse(tbl.Rows[0][4].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][4].ToString());
tbl.Rows[0]["Year4"] = (Double.Parse(tbl.Rows[0][5].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][5].ToString());
tbl.Rows[0]["Percentage"] = percentages.grossCHG;
tbl.Rows[1]["Year1"] = (Double.Parse(tbl.Rows[1][1].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][1].ToString());
tbl.Rows[1]["Year2"] = (Double.Parse(tbl.Rows[1][3].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][3].ToString());
tbl.Rows[1]["Year3"] = (Double.Parse(tbl.Rows[1][4].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][4].ToString());
tbl.Rows[1]["Year4"] = (Double.Parse(tbl.Rows[1][5].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][5].ToString());
tbl.Rows[1]["Percentage"] = percentages.exportedCHG;
tbl.Rows[2]["Year1"] = (Double.Parse(tbl.Rows[2][1].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][1].ToString());
tbl.Rows[2]["Year2"] = (Double.Parse(tbl.Rows[2][3].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][3].ToString());
tbl.Rows[2]["Year3"] = (Double.Parse(tbl.Rows[2][4].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][4].ToString());
tbl.Rows[2]["Year4"] = (Double.Parse(tbl.Rows[2][5].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][5].ToString());
tbl.Rows[2]["Percentage"] = percentages.netCHG;
tbl.Rows[3]["Year1"] = (Double.Parse(tbl.Rows[3][1].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][1].ToString());
tbl.Rows[3]["Year2"] = (Double.Parse(tbl.Rows[3][3].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][3].ToString());
tbl.Rows[3]["Year3"] = (Double.Parse(tbl.Rows[3][4].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][4].ToString());
tbl.Rows[3]["Year4"] = (Double.Parse(tbl.Rows[3][5].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][5].ToString());
tbl.Rows[3]["Percentage"] = percentages.grossRevenue;
tbl.Rows[4]["Year1"] = (Double.Parse(tbl.Rows[4][1].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][1].ToString());
tbl.Rows[4]["Year2"] = (Double.Parse(tbl.Rows[4][3].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][3].ToString());
tbl.Rows[4]["Year3"] = (Double.Parse(tbl.Rows[4][4].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][4].ToString());
tbl.Rows[4]["Year4"] = (Double.Parse(tbl.Rows[4][5].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][5].ToString());
tbl.Rows[4]["Percentage"] = percentages.exportedRevenue;
tbl.Rows[5]["Year1"] = (Double.Parse(tbl.Rows[5][1].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][1].ToString());
tbl.Rows[5]["Year2"] = (Double.Parse(tbl.Rows[5][3].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][3].ToString());
tbl.Rows[5]["Year3"] = (Double.Parse(tbl.Rows[5][4].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][4].ToString());
tbl.Rows[5]["Year4"] = (Double.Parse(tbl.Rows[5][5].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][5].ToString());
tbl.Rows[5]["Percentage"] = percentages.netRevenue;
int columnIndex = 0;
DataRow row = tbl.Rows[6];
foreach (DataColumn column in tbl.Columns)
{
if (int.Parse(year) == 2015 && columnIndex == 3)
{
row[column] = 3712000;
}
else if (int.Parse(year) == 2015 && columnIndex == 4)
{
row[column] = 4800000;
}
else if (int.Parse(year) > 2015 && columnIndex >= 3)
{
row[column] = 4800000;
}
columnIndex++;
//tbl.Rows[6]["Year2"] = (Double.Parse(tbl.Rows[6][3].ToString()) * percentages.differentialRevenue) + Double.Parse(tbl.Rows[6][3].ToString());
//tbl.Rows[6]["Year3"] = (Double.Parse(tbl.Rows[6][4].ToString()) * percentages.differentialRevenue) + Double.Parse(tbl.Rows[6][4].ToString());
//tbl.Rows[6]["Year4"] = (Double.Parse(tbl.Rows[6][5].ToString()) * percentages.differentialRevenue) + Double.Parse(tbl.Rows[6][5].ToString());
//tbl.Rows[6]["Percentage"] = percentages.differentialRevenue;
}
tbl.Rows[7]["Year1"] = (Double.Parse(tbl.Rows[7][1].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][1].ToString());
tbl.Rows[7]["Year2"] = (Double.Parse(tbl.Rows[7][3].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][3].ToString());
tbl.Rows[7]["Year3"] = (Double.Parse(tbl.Rows[7][4].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][4].ToString());
tbl.Rows[7]["Year4"] = (Double.Parse(tbl.Rows[7][5].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][5].ToString());
tbl.Rows[7]["Percentage"] = percentages.assessments;
tbl.Rows[8]["Year1"] = (Double.Parse(tbl.Rows[8][1].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][1].ToString());
tbl.Rows[8]["Year2"] = (Double.Parse(tbl.Rows[8][3].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][3].ToString());
tbl.Rows[8]["Year3"] = (Double.Parse(tbl.Rows[8][4].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][4].ToString());
tbl.Rows[8]["Year4"] = (Double.Parse(tbl.Rows[8][5].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][5].ToString());
tbl.Rows[8]["Percentage"] = percentages.costDrivers;
tbl.Rows[9]["Year1"] = (Double.Parse(tbl.Rows[9][1].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][1].ToString());
tbl.Rows[9]["Year2"] = (Double.Parse(tbl.Rows[9][3].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][3].ToString());
tbl.Rows[9]["Year3"] = (Double.Parse(tbl.Rows[9][4].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][4].ToString());
tbl.Rows[9]["Year4"] = (Double.Parse(tbl.Rows[9][5].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][5].ToString());
tbl.Rows[9]["Percentage"] = percentages.expendetures;
tbl.Rows[10]["Year1"] = (Double.Parse(tbl.Rows[10][1].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][1].ToString());
tbl.Rows[10]["Year2"] = (Double.Parse(tbl.Rows[10][3].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][3].ToString());
tbl.Rows[10]["Year3"] = (Double.Parse(tbl.Rows[10][4].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][4].ToString());
tbl.Rows[10]["Year4"] = (Double.Parse(tbl.Rows[10][5].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][5].ToString());
tbl.Rows[10]["Percentage"] = percentages.surplus;
ProjectionsGridView.Columns[2].HeaderText = fiscalYear;
ProjectionsGridView.Columns[3].HeaderText = fiscalYear1;
ProjectionsGridView.Columns[4].HeaderText = fiscalYear2;
ProjectionsGridView.Columns[5].HeaderText = fiscalYear3;
ProjectionsGridView.Columns[6].HeaderText = fiscalYear4;
ProjectionsPanel.Visible = true;
ProjectionsGridView.DataSource = tbl;
ProjectionsGridView.DataBind();
}