protected void CreateFiscalYearButton_Click(object sender, EventArgs e)
{
ArrayList fiscalYearData = (ArrayList)Session["FiscalYearData"];
String fiscalYear = fiscalYearData[0].ToString();
ArrayList chg =(ArrayList)fiscalYearData[1];
UpdateDatabase updtDB = new UpdateDatabase();
DataTable tbl = (DataTable)Session["CostDriversTbl"];
foreach (DataRow row in tbl.Rows)
{
updtDB.InsertAllocatedCosts(fiscalYear, row[0].ToString(), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString(), row[5].ToString());
}
if (Session["FiscalYear"] == null)
{
updtDB.RevenueSummaryInsert(fiscalYear);
}
else
{
updtDB.RevenueSummaryUpdate(fiscalYear);
}
}
protected void SubmitCostDriverButton_Click(object sender, EventArgs e)
{
Alert.Visible = false;
Error.Visible = false;
DataTable costDriversTbl = (DataTable)Session["CostDriversTbl"];
TextBox tbox = new TextBox();
for (int row = 0; row < SubmitCostDriverGridView.Rows.Count; row++)
{
String fiscalYear = (String)Session["FiscalYear"];
UpdateDatabase updtDB = new UpdateDatabase();
String costDriver = SelectCostDriverDropDownList.SelectedValue;
String metricType = SubmitCostDriverGridView.Rows[row].Cells[0].Text;
tbox = (TextBox)SubmitCostDriverGridView.Rows[row].Cells[1].FindControl("PercentageTextBox");
String rate = String.Empty;
if (tbox.Text != "")
{
rate = (Double.Parse(tbox.Text) / 100).ToString();
}
else
{
rate = tbox.Text;
}
tbox = (TextBox)SubmitCostDriverGridView.Rows[row].Cells[2].FindControl("TotalMetricTextBox");
String totalMetric = tbox.Text;
tbox = (TextBox)SubmitCostDriverGridView.Rows[row].Cells[3].FindControl("MetricsTextBox");
String metrics = tbox.Text;
String costToAllocate = CostToAllocateTextBox.Text;
updtDB.InsertAllocatedCosts(fiscalYear, costDriver, metricType, rate, totalMetric, metrics, costToAllocate);
}
AddedCostDrivers();
}
