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