protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Session["supportUnit"] = null;
RetrieveFromDB rtrvDB = new RetrieveFromDB();
DataSet fiscalYears = rtrvDB.GetFiscalYears();
int lastRecord = fiscalYears.Tables[0].Rows.Count - 1;
String mostRecentFY = fiscalYears.Tables[0].Rows[lastRecord][0].ToString();
Session["MostRecentFY"] = mostRecentFY;
// CategoryDropDownList.Items.Insert(0, new ListItem("Historical Percent Change", "0"));
//CategoryDropDownList.Items[0].Attributes.Add("style", "color: silver");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable years = new DataTable();
years.Columns.Add("Text", typeof(String));
years.Columns.Add("Value", typeof(String));
DataRow row = years.NewRow();
row["Text"] = "Select";
row["Value"] = "Select";
years.Rows.Add(row);
for (int i = 0; i <= 10; i++)
{
int year = 2010;
DataRow row2 = years.NewRow();
row2["Text"] = (year + i).ToString();
row2["Value"] = (year + i).ToString();
years.Rows.Add(row2);
}
YearDropDownList.DataSource = years;
YearDropDownList.DataTextField = "Text";
YearDropDownList.DataValueField = "Value";
YearDropDownList.DataBind();
RetrieveFromDB rtrvDB = new RetrieveFromDB();
DataSet fiscalYears = rtrvDB.GetFiscalYears(); //RetriveFiscalYears("All");
// DataSet fiscalYearsByCategory = rtrvDB.RetriveFiscalYearsAllCategories();
for (int i = 0; i < YearDropDownList.Items.Count; i++)
{
foreach (DataRow row2 in fiscalYears.Tables[0].Rows)
{
String fiscalYear = row2[0].ToString();
if (fiscalYear.GetLast(4) == YearDropDownList.Items[i].Value.ToString())
{
// YearDropDownList.Items[i].Text = fiscalYear.GetLast(4) + " (draft)";
YearDropDownList.Items[i].Attributes.Add("style", "color: silver");
}
}
//foreach (DataRow row3 in fiscalYearsByCategory.Tables[0].Rows)
//{
// String fiscalYear = row3[0].ToString();
// if (fiscalYear.GetLast(4) == YearDropDownList.Items[i].Value.ToString())
// {
// // YearDropDownList.Items[i].Text = fiscalYear.GetLast(4) + " (completed)";
// YearDropDownList.Items[i].Attributes.Add("style", "color: silver");
// }
//}
}
}
}
