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 ShowYears(int show_Year_ID)
{
ShowYearsBL showYears = new ShowYearsBL();
lkpShowYears = showYears.GetShow_YearByShow_Year_ID(show_Year_ID);
Show_Year_ID = show_Year_ID;
ShowYear = lkpShowYears[0].Show_Year;
Show_Year = ShowYear.ToString();
}
public ShowYears(string connString)
{
_connString = connString;
try
{
ShowYearsBL showYears = new ShowYearsBL(_connString);
lkpShowYears = showYears.GetShow_Years();
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
public ShowYears(string connString, int show_Year_ID)
{
_connString = connString;
try
{
ShowYearsBL showYears = new ShowYearsBL(_connString);
lkpShowYears = showYears.GetShow_YearByShow_Year_ID(show_Year_ID);
DataRow row = lkpShowYears.Rows[0];
_show_Year_ID = show_Year_ID;
_showYear = Utils.DBNullToShort(row["Show_Year"]);
_show_Year = _showYear.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
public ShowYears()
{
ShowYearsBL showYears = new ShowYearsBL();
lkpShowYears = showYears.GetShow_Years();
}
