public List <Shows> GetShowsLikeShow_Name(string show_Name)
{
List <Shows> retVal = new List <Shows>();
try
{
ShowsBL shows = new ShowsBL(_connString);
tblShows = shows.GetShowsLikeShow_Name(show_Name);
if (tblShows != null && tblShows.Rows.Count > 0)
{
foreach (DataRow row in tblShows.Rows)
{
Shows show = new Shows(_connString, Utils.DBNullToGuid(row["Show_ID"]));
retVal.Add(show);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
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> GetShowsByClub_ID_And_Show_Year_ID(Guid club_ID, int show_Year_ID)
{
List <Shows> retVal = new List <Shows>();
try
{
ShowsBL shows = new ShowsBL(_connString);
tblShows = shows.GetShowsByClub_ID_And_Show_Year_ID(club_ID, show_Year_ID);
if (tblShows != null && tblShows.Rows.Count > 0)
{
foreach (DataRow row in tblShows.Rows)
{
Shows show = new Shows(_connString, Utils.DBNullToGuid(row["Show_ID"]));
retVal.Add(show);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Shows(string connString, Guid show_ID)
{
_connString = connString;
try
{
ShowsBL shows = new ShowsBL(_connString);
tblShows = shows.GetShowByShow_ID(show_ID);
DataRow row = tblShows.Rows[0];
_show_ID = show_ID;
_club_ID = Utils.DBNullToGuid(row["Club_ID"]);
_show_Year_ID = Utils.DBNullToInt(row["Show_Year_ID"]);
_show_Type_ID = Utils.DBNullToInt(row["Show_Type_ID"]);
_venue_ID = Utils.DBNullToGuid(row["Venue_ID"]);
_show_Opens = Utils.DBNullToDate(row["Show_Opens"]);
_judging_Commences = Utils.DBNullToDate(row["Judging_Commences"]);
_show_Name = Utils.DBNullToString(row["Show_Name"]);
_closing_Date = Utils.DBNullToDate(row["Closing_Date"]);
_entries_Complete = Utils.DBNullToBool(row["Entries_Complete"]);
_judges_Allocated = Utils.DBNullToBool(row["Judges_Allocated"]);
_split_Classes = Utils.DBNullToBool(row["Split_Classes"]);
_running_Orders_Allocated = Utils.DBNullToBool(row["Running_Orders_Allocated"]);
_ring_Numbers_Allocated = Utils.DBNullToBool(row["Ring_Numbers_Allocated"]);
_linked_Show = Utils.DBNullToBool(row["Linked_Show"]);
_maxClassesPerDog = Utils.DBNullToShort(row["MaxClassesPerDog"]);
}
catch (Exception ex)
{
throw ex;
}
}
public Guid?Insert_Show(Guid user_ID)
{
Guid?retVal = null;
try
{
ShowsBL shows = new ShowsBL(_connString);
retVal = (Guid?)shows.Insert_Shows(_club_ID, _show_Year_ID, _show_Type_ID, _venue_ID, _show_Opens,
_judging_Commences, _show_Name, _closing_Date, _maxClassesPerDog, _linked_Show, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public bool Update_Show(Guid show_ID, Guid user_ID)
{
bool success = false;
try
{
ShowsBL shows = new ShowsBL(_connString);
success = shows.Update_Shows(show_ID, _club_ID, _show_Year_ID, _show_Type_ID, _venue_ID, _show_Opens,
_judging_Commences, _show_Name, _closing_Date, _entries_Complete, _judges_Allocated, _split_Classes,
_running_Orders_Allocated, _ring_Numbers_Allocated, _maxClassesPerDog, _linked_Show, _deleteShow, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(success);
}
public bool Update_Show(Guid show_ID, Guid user_ID)
{
bool success = false;
ShowsBL shows = new ShowsBL();
success = shows.Update_Shows(show_ID, Club_ID, Show_Year_ID, Show_Type_ID, Venue_ID, Show_Opens,
Judging_Commences, Show_Name, Closing_Date, Entries_Complete, Judges_Allocated, Split_Classes,
Running_Orders_Allocated, Ring_Numbers_Allocated, MaxClassesPerDog, Linked_Show, DeleteShow, user_ID);
return success;
}
public Guid? Insert_Show(Guid user_ID)
{
ShowsBL shows = new ShowsBL();
Guid? newID = (Guid?)shows.Insert_Shows(Club_ID, Show_Year_ID, Show_Type_ID, Venue_ID, Show_Opens,
Judging_Commences, Show_Name, Closing_Date, MaxClassesPerDog, Linked_Show, user_ID);
return newID;
}
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> 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> 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;
}