protected void ReportApply_Click(object sender, EventArgs e) { StoredProcedures sp = new StoredProcedures(); ExpendutersTotalsPanel.Visible = false; String fiscalYear = (String)Session["FiscalYear"]; DataSet result = Utils.getDataSetFromExcel(ReportFileUpload, Server); sp.DeleteExpendetures(fiscalYear); if (result != null) { foreach (DataRow row in result.Tables[0].Rows) { int account = 0; if (row[0].ToString() != String.Empty) { int.TryParse(row[0].ToString().Substring(0, 4), out account); } if (account >= 6500 && account <= 6701) { String expenseType = row[0].ToString(); double budget = double.Parse(row[3].ToString()); sp.UpdateCompensationExpenduters("NonInstractional", fiscalYear, expenseType, budget, 0); } } foreach (DataRow row in result.Tables[0].Rows) { int account = 0; if (row[0].ToString() != String.Empty) { int.TryParse(row[0].ToString().Substring(0, 4), out account); } if (account >= 6001 && account < 6500) { String expenseType = row[0].ToString(); double budget = double.Parse(row[3].ToString()); sp.UpdateCompensationExpenduters("Instractional", fiscalYear, expenseType, budget, 0); } } foreach (DataRow row in result.Tables[0].Rows) { int account = 0; if (row[0].ToString() != String.Empty) { int.TryParse(row[0].ToString().Substring(0, 4), out account); } if (account >= 7001 && account != 7902) { String expenseType = row[0].ToString(); double budget = double.Parse(row[3].ToString()); sp.UpdateNonCompensationExpenduters("NonCompensation", fiscalYear, expenseType, budget); } } } PopulateGridView(); }