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); } }
public String CreateNewFiscalYear(String fiscalYear) { String message = String.Empty; RetrieveFromDB rtrv = new RetrieveFromDB(); UpdateDatabase updDB = new UpdateDatabase(); DataSet ds = rtrv.CheckCategoriesBeforeNewFiscalYear(fiscalYear); if (int.Parse(ds.Tables[0].Rows[4][1].ToString()) != 0) { message = "Fiscal year " + fiscalYear + " already exists."; } else if (int.Parse(ds.Tables[0].Rows[3][1].ToString()) != 0 & int.Parse(ds.Tables[0].Rows[2][1].ToString()) != 0 && int.Parse(ds.Tables[0].Rows[1][1].ToString()) != 0 && int.Parse(ds.Tables[0].Rows[0][1].ToString())!= 0 ) { message = "1"; updDB.UpdateNulls(fiscalYear); updDB.RevenueSummaryInsert(fiscalYear); } else { if (int.Parse(ds.Tables[0].Rows[3][1].ToString()) == 0) { message = "CHG"; } if (int.Parse(ds.Tables[0].Rows[1][1].ToString()) == 0) { if (message == String.Empty) { message = "Assessments"; } else { message = message + ", Assessments"; } } if (int.Parse(ds.Tables[0].Rows[2][1].ToString()) == 0) { if (message == String.Empty) { message = "Expendutries"; } else { message = message + ", Expendutries"; } } if (int.Parse(ds.Tables[0].Rows[0][1].ToString()) == 0) { if (message == String.Empty) { message = "Allocated Costs"; } else { message = message + ", Allocated Costs"; } } message = "Fiscal year " + fiscalYear + " has not been created. In order to create the fiscal year please submit " + message + "."; } return message; }