public Shows(Guid show_ID)
{
ShowsBL shows = new ShowsBL();
tblShows = shows.GetShowByShow_ID(show_ID);
Show_ID = tblShows[0].Show_ID;
Club_ID = tblShows[0].Club_ID;
Show_Year_ID = tblShows[0].Show_Year_ID;
if (!tblShows[0].IsShow_Type_IDNull())
Show_Type_ID = tblShows[0].Show_Type_ID;
if (!tblShows[0].IsVenue_IDNull())
Venue_ID = tblShows[0].Venue_ID;
if (!tblShows[0].IsShow_OpensNull())
Show_Opens = tblShows[0].Show_Opens;
if (!tblShows[0].IsJudging_CommencesNull())
Judging_Commences = tblShows[0].Judging_Commences;
if (!tblShows[0].IsShow_NameNull())
Show_Name = tblShows[0].Show_Name;
if (!tblShows[0].IsClosing_DateNull())
Closing_Date = tblShows[0].Closing_Date;
if (!tblShows[0].IsEntries_CompleteNull())
Entries_Complete = tblShows[0].Entries_Complete;
if (!tblShows[0].IsJudges_AllocatedNull())
Judges_Allocated = tblShows[0].Judges_Allocated;
if (!tblShows[0].IsSplit_ClassesNull())
Split_Classes = tblShows[0].Split_Classes;
if (!tblShows[0].IsRunning_Orders_AllocatedNull())
Running_Orders_Allocated = tblShows[0].Running_Orders_Allocated;
if (!tblShows[0].IsRing_Numbers_AllocatedNull())
Ring_Numbers_Allocated = tblShows[0].Ring_Numbers_Allocated;
if (!tblShows[0].IsLinked_ShowNull())
Linked_Show = (tblShows[0].IsLinked_ShowNull()) ? false : tblShows[0].Linked_Show;
if (!tblShows[0].IsMaxClassesPerDogNull())
MaxClassesPerDog = tblShows[0].MaxClassesPerDog;
}
public List<Shows> GetShowsByVenue_ID(Guid venue_ID)
{
List<Shows> showList = new List<Shows>();
ShowsBL shows = new ShowsBL();
tblShows = shows.GetShowsByVenue_ID(venue_ID);
if (tblShows != null && tblShows.Count > 0)
{
foreach (sss.tblShowsRow row in tblShows)
{
Shows show = new Shows(row.Show_ID);
showList.Add(show);
}
}
return showList;
}
public List<Shows> GetShowsLikeShow_Name(string show_Name)
{
List<Shows> showList = new List<Shows>();
ShowsBL shows = new ShowsBL();
tblShows = shows.GetShowsLikeShow_Name(show_Name);
if (tblShows != null && tblShows.Count > 0)
{
foreach (sss.tblShowsRow row in tblShows)
{
Shows show = new Shows(row.Show_ID);
showList.Add(show);
}
}
return showList;
}
public List<Shows> GetShowsByClub_ID_And_Show_Year_ID(Guid club_ID, int show_Year_ID)
{
List<Shows> showList = new List<Shows>();
ShowsBL shows = new ShowsBL();
tblShows = shows.GetShowsByClub_ID_And_Show_Year_ID(club_ID, show_Year_ID);
if (tblShows != null && tblShows.Count > 0)
{
foreach (sss.tblShowsRow row in tblShows)
{
Shows show = new Shows(row.Show_ID);
showList.Add(show);
}
}
return showList;
}
