private void PopulateGrossExported()
{
StoredProcedures sp = new StoredProcedures();
TextBox tb = new TextBox();
String fiscalYear = (String)Session["FiscalYear"];
DataSet ds = sp.GetCHG(fiscalYear);
for (int row = 0; row < GrossCHGGridView.Rows.Count; row++)
{
tb = (TextBox)GrossCHGGridView.Rows[row].FindControl("UndergradCHGTextBox");
tb.Text = ds.Tables[0].Rows[row + 4][4].ToString();
tb = (TextBox)GrossCHGGridView.Rows[row].FindControl("UndergradRateTextBox");
tb.Text = ds.Tables[0].Rows[row + 4][5].ToString();
tb = (TextBox)GrossCHGGridView.Rows[row].FindControl("GradCHGTextBox");
tb.Text = ds.Tables[0].Rows[row][4].ToString();
tb = (TextBox)GrossCHGGridView.Rows[row].FindControl("GradRateTextBox");
tb.Text = ds.Tables[0].Rows[row][5].ToString();
}
for (int row = 0; row < NetCHGGridView.Rows.Count; row++)
{
tb = (TextBox)NetCHGGridView.Rows[row].FindControl("UndergradCHGTextBox");
tb.Text = ds.Tables[1].Rows[row + 4][4].ToString();
tb = (TextBox)NetCHGGridView.Rows[row].FindControl("UndergradRateTextBox");
tb.Text = ds.Tables[1].Rows[row + 4][5].ToString();
tb = (TextBox)NetCHGGridView.Rows[row].FindControl("GradCHGTextBox");
tb.Text = ds.Tables[1].Rows[row][4].ToString();
tb = (TextBox)NetCHGGridView.Rows[row].FindControl("GradRateTextBox");
tb.Text = ds.Tables[1].Rows[row][5].ToString();
}
for (int row = 0; row < ExportedCHGGridView.Rows.Count; row++)
{
tb = (TextBox)ExportedCHGGridView.Rows[row].FindControl("UndergradCHGTextBox");
tb.Text = ds.Tables[2].Rows[row + 4][4].ToString();
tb = (TextBox)ExportedCHGGridView.Rows[row].FindControl("UndergradRateTextBox");
tb.Text = ds.Tables[2].Rows[row + 4][5].ToString();
tb = (TextBox)ExportedCHGGridView.Rows[row].FindControl("GradCHGTextBox");
tb.Text = ds.Tables[2].Rows[row][4].ToString();
tb = (TextBox)ExportedCHGGridView.Rows[row].FindControl("GradRateTextBox");
tb.Text = ds.Tables[2].Rows[row][5].ToString();
}
tb = (TextBox)DifferentialRevenueGridView.Rows[0].FindControl("UndergradCHGTextBox");
tb.Text = ds.Tables[3].Rows[1][2].ToString();
tb = (TextBox)DifferentialRevenueGridView.Rows[0].FindControl("UndergradRateTextBox");
tb.Text = ds.Tables[3].Rows[1][3].ToString();
tb = (TextBox)DifferentialRevenueGridView.Rows[0].FindControl("NumberGradStudentsTextBox");
tb.Text = ds.Tables[3].Rows[0][2].ToString();
tb = (TextBox)DifferentialRevenueGridView.Rows[0].FindControl("GradRateTextBox");
tb.Text = ds.Tables[3].Rows[0][3].ToString();
}
protected void PopulateNetCHG()
{
string fiscalYear = (string)ViewState["MostRecentFiscalYear"];
DataSet ds;
if (ViewState["NetCHG"] != null)
{
ds = (DataSet)ViewState["NetCHG"];
}
else
{
StoredProcedures sp = new StoredProcedures();
ds = sp.GetCHG(fiscalYear);
ViewState["NetCHG"] = ds;
}
SSIICHGGradTextBox.Text = ds.Tables[1].Rows[0][4].ToString();
SSIIRateGradTextBox.Text = ds.Tables[1].Rows[0][5].ToString();
SSIICHGUndergradTextBox.Text = ds.Tables[1].Rows[4][4].ToString();
SSIIRateUndergradTextBox.Text = ds.Tables[1].Rows[4][5].ToString();
FallCHGGradTextBox.Text = ds.Tables[1].Rows[1][4].ToString();
FallRateGradTextBox.Text = ds.Tables[1].Rows[1][5].ToString();
FallCHGUndergradTextBox.Text = ds.Tables[1].Rows[5][4].ToString();
FallRateUndergradTextBox.Text = ds.Tables[1].Rows[5][5].ToString();
SpringCHGGradTextBox.Text = ds.Tables[1].Rows[2][4].ToString();
SpringRateGradTextBox.Text = ds.Tables[1].Rows[2][5].ToString();
SpringCHGUndergradTextBox.Text = ds.Tables[1].Rows[6][4].ToString();
SpringRateUndergradTextBox.Text = ds.Tables[1].Rows[6][5].ToString();
SSICHGGradTextBox.Text = ds.Tables[1].Rows[3][4].ToString();
SSIRateGradTextBox.Text = ds.Tables[1].Rows[3][5].ToString();
SSICHGUndergradTextBox.Text = ds.Tables[1].Rows[7][4].ToString();
SSIRateUndergradTextBox.Text = ds.Tables[1].Rows[7][5].ToString();
}