public List <ShowYears> GetShow_YearByShow_Year(short show_Year)
{
List <ShowYears> retVal = new List <ShowYears>();
try
{
ShowYearsBL showYears = new ShowYearsBL(_connString);
lkpShowYears = showYears.GetShow_YearByShow_Year(show_Year);
if (lkpShowYears != null && lkpShowYears.Rows.Count > 0)
{
foreach (DataRow row in lkpShowYears.Rows)
{
ShowYears showYear = new ShowYears(_connString, Utils.DBNullToInt(row["Show_Year_ID"]));
retVal.Add(showYear);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List<ShowYears> GetShow_YearByShow_Year(short show_Year)
{
List<ShowYears> showYearList = new List<ShowYears>();
ShowYearsBL showYears = new ShowYearsBL();
lkpShowYears = showYears.GetShow_YearByShow_Year(show_Year);
if (lkpShowYears != null && lkpShowYears.Count > 0)
{
foreach (sss.lkpShow_YearsRow row in lkpShowYears)
{
ShowYears showYear = new ShowYears(row.Show_Year_ID);
showYearList.Add(showYear);
}
}
return showYearList;
}
private void PopulateShowYears()
{
ShowYears showYears = new ShowYears();
List<ShowYears> lkpShowYears;
lkpShowYears = showYears.GetShow_Years();
lstShowYears.DataSource = lkpShowYears;
lstShowYears.DataBind();
}
private void PopulateListBoxes()
{
ShowTypes showTypes = new ShowTypes();
List<ShowTypes> lkpShowTypes;
lkpShowTypes = showTypes.GetShow_Types();
lstShowTypes.DataSource = lkpShowTypes;
lstShowTypes.DataBind();
ShowYears showYears = new ShowYears();
List<ShowYears> lkpShowYears;
lkpShowYears = showYears.GetShow_Years();
lstShowYears.DataSource = lkpShowYears;
lstShowYears.DataBind();
}