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