private void BindPeriodYear()
{
DropDownListPeriodYear.DataSource = PeriodYear.GetPeriodYearList();
DropDownListPeriodYear.DataTextField = "Description";
DropDownListPeriodYear.DataValueField = "PeriodYearId";
DropDownListPeriodYear.DataBind();
DropDownListPeriodYear.Items.Insert(0, new ListItem("Please select", "0"));
}
public static List <PeriodYear> GetPeriodYearList()
{
List <PeriodYear> list = new List <PeriodYear>();
Database db = DatabaseFactory.CreateDatabase("ProfitPlan");
string sqlCommand = "GetPeriodYearList";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
PeriodYear PeriodYear = new PeriodYear();
PeriodYear.PeriodYearId = Convert.ToInt32(dataReader["redPeriodYearId"]);
PeriodYear.Description = dataReader["Year"].ToString();
list.Add(PeriodYear);
}
}
return(list);
}
