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; }