public DataTable GetDog_ClassesByEntrant_ID_Dog_ID(Guid entrant_ID, Guid dog_ID)
{
DataTable retVal = null;
string spName = "spGetDog_ClassesByEntrant_ID_Dog_ID";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Entrant_ID", SSSDatabaseInfo.ParameterType.Guid, entrant_ID),
new SSSDatabaseInfo.DatabaseParameter("Dog_ID", SSSDatabaseInfo.ParameterType.Guid, dog_ID),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Dog Classes. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Linked_Shows(Guid parent_Show_ID, Guid child_Show_ID, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_lnkLinked_Shows";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Parent_Show_ID", SSSDatabaseInfo.ParameterType.Guid, parent_Show_ID),
new SSSDatabaseInfo.DatabaseParameter("Child_Show_ID", SSSDatabaseInfo.ParameterType.Guid, child_Show_ID),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Linked Show. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Guarantors(Guid original_ID, Guid?show_ID, Guid?chairman_Person_ID, Guid?secretary_Person_ID, Guid?treasurer_Person_ID,
Guid?committee1_Person_ID, Guid?committee2_Person_ID, Guid?committee3_Person_ID, bool?deleted, Guid?user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblGuarantors";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Chairman_Person_ID", SSSDatabaseInfo.ParameterType.Guid, chairman_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Secretary_Person_ID", SSSDatabaseInfo.ParameterType.Guid, secretary_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Treasurer_Person_ID", SSSDatabaseInfo.ParameterType.Guid, treasurer_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Committee1_Person_ID", SSSDatabaseInfo.ParameterType.Guid, committee1_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Committee2_Person_ID", SSSDatabaseInfo.ParameterType.Guid, committee2_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Committee3_Person_ID", SSSDatabaseInfo.ParameterType.Guid, committee3_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Guid, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Guarantors. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Venues(Guid original_ID, string venue_Name, Guid?address_ID, Guid?venue_Contact, bool?deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblVenues";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Venue_Name", SSSDatabaseInfo.ParameterType.String, venue_Name),
new SSSDatabaseInfo.DatabaseParameter("Address_ID", SSSDatabaseInfo.ParameterType.Guid, address_ID),
new SSSDatabaseInfo.DatabaseParameter("Venue_Contact", SSSDatabaseInfo.ParameterType.Guid, venue_Contact),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Bool, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Venue. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Address(Guid original_ID, string address_1, string address_2, string address_Town,
string address_City, string address_County, string address_Postcode, bool deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblAddresses";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Address_1", SSSDatabaseInfo.ParameterType.String, address_1),
new SSSDatabaseInfo.DatabaseParameter("Address_2", SSSDatabaseInfo.ParameterType.String, address_2),
new SSSDatabaseInfo.DatabaseParameter("Address_Town", SSSDatabaseInfo.ParameterType.String, address_Town),
new SSSDatabaseInfo.DatabaseParameter("Address_City", SSSDatabaseInfo.ParameterType.String, address_City),
new SSSDatabaseInfo.DatabaseParameter("Address_County", SSSDatabaseInfo.ParameterType.String, address_County),
new SSSDatabaseInfo.DatabaseParameter("Address_Postcode", SSSDatabaseInfo.ParameterType.String, address_Postcode),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Bool, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.String, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Address. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Dog_Breeders(Guid original_ID, Guid dog_ID, Guid breeder_ID, bool deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_lnkDog_Breeders";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Dog_ID", SSSDatabaseInfo.ParameterType.Guid, dog_ID),
new SSSDatabaseInfo.DatabaseParameter("Breeder_ID", SSSDatabaseInfo.ParameterType.Guid, breeder_ID),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Bool, deleted),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Dog Breeder. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Show_Helpers(Guid?show_ID, Guid?person_ID, int?show_Role_ID, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblShow_Helpers";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_ID", SSSDatabaseInfo.ParameterType.Guid, person_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Role_ID", SSSDatabaseInfo.ParameterType.Int, show_Role_ID),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Show Helper. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Clubs(string club_Long_Name, string club_Short_Name, Guid?club_Contact, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblClubs";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Club_Long_Name", SSSDatabaseInfo.ParameterType.String, club_Long_Name),
new SSSDatabaseInfo.DatabaseParameter("Club_Short_Name", SSSDatabaseInfo.ParameterType.String, club_Short_Name),
new SSSDatabaseInfo.DatabaseParameter("Club_Contact", SSSDatabaseInfo.ParameterType.Guid, club_Contact),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Club. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Clubs(Guid original_ID, string club_Long_Name, string club_Short_Name, Guid?club_Contact, bool deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblClubs";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Club_Long_Name", SSSDatabaseInfo.ParameterType.String, club_Long_Name),
new SSSDatabaseInfo.DatabaseParameter("Club_Short_Name", SSSDatabaseInfo.ParameterType.String, club_Short_Name),
new SSSDatabaseInfo.DatabaseParameter("Club_Contact", SSSDatabaseInfo.ParameterType.Guid, club_Contact),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Bool, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Club. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Shows(Guid?club_ID, int?show_Year_ID, int?show_Type_ID, Guid?venue_ID, DateTime?show_Opens, DateTime?judging_Commences,
string show_Name, DateTime?closing_Date, short?maxClassesPerDog, bool?linked_Show, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblShows";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Club_ID", SSSDatabaseInfo.ParameterType.Guid, club_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Year_ID", SSSDatabaseInfo.ParameterType.Int, show_Year_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Type_ID", SSSDatabaseInfo.ParameterType.Int, show_Type_ID),
new SSSDatabaseInfo.DatabaseParameter("Venue_ID", SSSDatabaseInfo.ParameterType.Guid, venue_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Opens", SSSDatabaseInfo.ParameterType.DateTime, show_Opens),
new SSSDatabaseInfo.DatabaseParameter("Judging_Commences", SSSDatabaseInfo.ParameterType.DateTime, judging_Commences),
new SSSDatabaseInfo.DatabaseParameter("Show_Name", SSSDatabaseInfo.ParameterType.String, show_Name),
new SSSDatabaseInfo.DatabaseParameter("Closing_Date", SSSDatabaseInfo.ParameterType.DateTime, closing_Date),
new SSSDatabaseInfo.DatabaseParameter("MaxClassesPerDog", SSSDatabaseInfo.ParameterType.Short, maxClassesPerDog),
new SSSDatabaseInfo.DatabaseParameter("Linked_Show", SSSDatabaseInfo.ParameterType.Bool, linked_Show),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Show. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetShowsByClub_ID_And_Show_Year_ID(Guid club_ID, int show_Year_ID)
{
DataTable retVal = null;
string spName = "spGetShowsByClub_ID_And_Show_Year_ID";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Club_ID", SSSDatabaseInfo.ParameterType.Guid, club_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Year_ID", SSSDatabaseInfo.ParameterType.Int, show_Year_ID),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Shows. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetEntrantsByShow_IDAndDog_ID(Guid show_ID, Guid dog_ID, bool includeLinked)
{
DataTable retVal = null;
string spName = "spGetEntrantsByShow_IDAndDog_ID";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Dog_ID", SSSDatabaseInfo.ParameterType.Guid, dog_ID),
new SSSDatabaseInfo.DatabaseParameter("IncludeLinked", SSSDatabaseInfo.ParameterType.Bool, includeLinked),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Entrants. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Entrants(Guid?show_ID, bool?catalogue, bool?overnight_Camping, decimal?overpayment,
decimal?underpayment, bool?offer_Of_Help, string help_Details, bool?withold_Address, bool?send_Running_Order,
DateTime?entry_Date, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblEntrants";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Catalogue", SSSDatabaseInfo.ParameterType.Bool, catalogue),
new SSSDatabaseInfo.DatabaseParameter("Overnight_Camping", SSSDatabaseInfo.ParameterType.Bool, overnight_Camping),
new SSSDatabaseInfo.DatabaseParameter("Overpayment", SSSDatabaseInfo.ParameterType.Decimal, overpayment),
new SSSDatabaseInfo.DatabaseParameter("Underpayment", SSSDatabaseInfo.ParameterType.Decimal, underpayment),
new SSSDatabaseInfo.DatabaseParameter("Offer_Of_Help", SSSDatabaseInfo.ParameterType.Bool, offer_Of_Help),
new SSSDatabaseInfo.DatabaseParameter("Help_Details", SSSDatabaseInfo.ParameterType.String, help_Details),
new SSSDatabaseInfo.DatabaseParameter("Withold_Address", SSSDatabaseInfo.ParameterType.Bool, withold_Address),
new SSSDatabaseInfo.DatabaseParameter("Send_Running_Order", SSSDatabaseInfo.ParameterType.Bool, send_Running_Order),
new SSSDatabaseInfo.DatabaseParameter("Entry_Date", SSSDatabaseInfo.ParameterType.DateTime, entry_Date),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Entrant. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool PopulateOwnersDogsClassesListOrderByEntry_Date(Guid show_ID, Guid?show_Final_Class_ID)
{
bool retVal = false;
string spName = "spPopulateOwnersDogsClassesListOrderByEntry_Date";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Final_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Final_Class_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to populate Owners Dogs Classes Drawn list. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool PopulateSpecialRequestList(Guid show_ID, Guid?show_Entry_Class_ID, bool specialRequestsOnly)
{
bool retVal = false;
string spName = "spPopulateSpecialRequestList";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("SpecialRequestsOnly", SSSDatabaseInfo.ParameterType.Bool, specialRequestsOnly),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to populate Special Requests. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetSplitClassParts(Guid show_ID)
{
DataTable retVal = null;
string spName = "spGetSplitClassParts";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Show Final Classes. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Dog_Breeders(Guid dog_ID, Guid breeder_ID, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_lnkDog_Breeders";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Dog_ID", SSSDatabaseInfo.ParameterType.Guid, dog_ID),
new SSSDatabaseInfo.DatabaseParameter("Breeder_ID", SSSDatabaseInfo.ParameterType.Guid, breeder_ID),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Dog Breeder. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Show_Final_Classes(Guid?show_ID, Guid?show_Entry_Class_ID, string show_Final_Class_Description,
short show_Final_Class_No, Guid?judge_ID, DateTime?stay_Time, DateTime?lunch_Time, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblShow_Final_Classes";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Final_Class_Description", SSSDatabaseInfo.ParameterType.String, show_Final_Class_Description),
new SSSDatabaseInfo.DatabaseParameter("Show_Final_Class_No", SSSDatabaseInfo.ParameterType.Short, show_Final_Class_No),
new SSSDatabaseInfo.DatabaseParameter("Judge_ID", SSSDatabaseInfo.ParameterType.Guid, judge_ID),
new SSSDatabaseInfo.DatabaseParameter("Stay_Time", SSSDatabaseInfo.ParameterType.DateTime, stay_Time),
new SSSDatabaseInfo.DatabaseParameter("Lunch_Time", SSSDatabaseInfo.ParameterType.DateTime, lunch_Time),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Show Final Class. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Show_Helpers(Guid original_ID, Guid?show_ID, Guid?person_ID, int?show_Role_ID, bool?deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblShow_Helpers";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_ID", SSSDatabaseInfo.ParameterType.Guid, person_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Role_ID", SSSDatabaseInfo.ParameterType.Int, show_Role_ID),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Bool, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Show Helper. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Show_Final_Classes(Guid original_ID, Guid?show_ID, Guid?show_Entry_Class_ID, string show_Final_Class_Description,
short show_Final_Class_No, Guid?judge_ID, DateTime?stay_Time, DateTime?lunch_Time, bool?deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblShow_Final_Classes";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Final_Class_Description", SSSDatabaseInfo.ParameterType.String, show_Final_Class_Description),
new SSSDatabaseInfo.DatabaseParameter("Show_Final_Class_No", SSSDatabaseInfo.ParameterType.Short, show_Final_Class_No),
new SSSDatabaseInfo.DatabaseParameter("Judge_ID", SSSDatabaseInfo.ParameterType.Guid, judge_ID),
new SSSDatabaseInfo.DatabaseParameter("Stay_Time", SSSDatabaseInfo.ParameterType.DateTime, stay_Time),
new SSSDatabaseInfo.DatabaseParameter("Lunch_Time", SSSDatabaseInfo.ParameterType.DateTime, lunch_Time),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Bool, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Show Final Class. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Venues(string venue_Name, Guid?address_ID, Guid?venue_Contact, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblVenues";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Venue_Name", SSSDatabaseInfo.ParameterType.String, venue_Name),
new SSSDatabaseInfo.DatabaseParameter("Address_ID", SSSDatabaseInfo.ParameterType.Guid, address_ID),
new SSSDatabaseInfo.DatabaseParameter("Venue_Contact", SSSDatabaseInfo.ParameterType.Guid, venue_Contact),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Venue. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public int DeleteShowFinalClassesByShowEntryClass(Guid show_Entry_Class_ID)
{
int retVal = 0;
int rowsDeleted = 0;
string spName = "spDeleteShowFinalClassesByShowEntryClass";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("NumRowsChanged", SSSDatabaseInfo.ParameterType.Int, rowsDeleted, SSSDatabaseInfo.ParameterDirection.Output),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = rowsDeleted;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to delete Show Final Class. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Address(string address_1, string address_2, string address_Town,
string address_City, string address_County, string address_Postcode, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblAddresses";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Address_1", SSSDatabaseInfo.ParameterType.String, address_1),
new SSSDatabaseInfo.DatabaseParameter("Address_2", SSSDatabaseInfo.ParameterType.String, address_2),
new SSSDatabaseInfo.DatabaseParameter("Address_Town", SSSDatabaseInfo.ParameterType.String, address_Town),
new SSSDatabaseInfo.DatabaseParameter("Address_City", SSSDatabaseInfo.ParameterType.String, address_City),
new SSSDatabaseInfo.DatabaseParameter("Address_County", SSSDatabaseInfo.ParameterType.String, address_County),
new SSSDatabaseInfo.DatabaseParameter("Address_Postcode", SSSDatabaseInfo.ParameterType.String, address_Postcode),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Address. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Show_Entry_Classes(Guid?show_ID, int?class_Name_ID, short?class_No, short?gender, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblShow_Entry_Classes";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Class_Name_ID", SSSDatabaseInfo.ParameterType.Int, class_Name_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_Landline", SSSDatabaseInfo.ParameterType.Short, class_No),
new SSSDatabaseInfo.DatabaseParameter("Gender", SSSDatabaseInfo.ParameterType.Short, gender),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Show Entry Class. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool UpdateFinalClassNames(Guid show_Entry_Class_ID, string class_Name_Description, short class_No,
string show_Final_Class_Description, short entries, short orderBy)
{
bool retVal = false;
string spName = "spUpdateFinalClassNames";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("Class_Name_Description", SSSDatabaseInfo.ParameterType.String, class_Name_Description),
new SSSDatabaseInfo.DatabaseParameter("Class_No", SSSDatabaseInfo.ParameterType.Short, class_No),
new SSSDatabaseInfo.DatabaseParameter("Show_Final_Class_Description", SSSDatabaseInfo.ParameterType.String, show_Final_Class_Description),
new SSSDatabaseInfo.DatabaseParameter("Entries", SSSDatabaseInfo.ParameterType.Short, entries),
new SSSDatabaseInfo.DatabaseParameter("OrderBy", SSSDatabaseInfo.ParameterType.Short, orderBy),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Final Class Names. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Show_Entry_Classes(Guid original_ID, Guid?show_ID, int?class_Name_ID, short?class_No, short?gender, bool?deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblShow_Entry_Classes";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Class_Name_ID", SSSDatabaseInfo.ParameterType.Int, class_Name_ID),
new SSSDatabaseInfo.DatabaseParameter("Class_No", SSSDatabaseInfo.ParameterType.Short, class_No),
new SSSDatabaseInfo.DatabaseParameter("Gender", SSSDatabaseInfo.ParameterType.Short, gender),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Bool, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Show Entry Class. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Linked_Shows(Guid original_ID, Guid parent_Show_ID, Guid child_Show_ID, bool deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_lnkLinked_Shows";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Parent_Show_ID", SSSDatabaseInfo.ParameterType.Guid, parent_Show_ID),
new SSSDatabaseInfo.DatabaseParameter("Child_Show_ID", SSSDatabaseInfo.ParameterType.Guid, child_Show_ID),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Guid, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Linked Show. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetShowEntryClassByShowAndClassNo(Guid show_ID, int class_No)
{
DataTable retVal = null;
string spName = "spGetShowEntryClassByShowAndClassNo";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Class_No", SSSDatabaseInfo.ParameterType.Int, class_No),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Show Entry Class by Show ID and Class No. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Guarantors(Guid?show_ID, Guid?chairman_Person_ID, Guid?secretary_Person_ID, Guid?treasurer_Person_ID,
Guid?committee1_Person_ID, Guid?committee2_Person_ID, Guid?committee3_Person_ID, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblGuarantors";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
new SSSDatabaseInfo.DatabaseParameter("Chairman_Person_ID", SSSDatabaseInfo.ParameterType.Guid, chairman_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Secretary_Person_ID", SSSDatabaseInfo.ParameterType.Guid, secretary_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Treasurer_Person_ID", SSSDatabaseInfo.ParameterType.Guid, treasurer_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Committee1_Person_ID", SSSDatabaseInfo.ParameterType.Guid, committee1_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Committee2_Person_ID", SSSDatabaseInfo.ParameterType.Guid, committee2_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("Committee3_Person_ID", SSSDatabaseInfo.ParameterType.Guid, committee3_Person_ID),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Guarantors. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Dog_Classes(Guid?entrant_ID, Guid?dog_ID, Guid?show_Entry_Class_ID, int preferred_Part, Guid?handler_ID,
string special_Request, short?running_Order, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblDog_Classes";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Entrant_ID", SSSDatabaseInfo.ParameterType.Guid, entrant_ID),
new SSSDatabaseInfo.DatabaseParameter("Dog_ID", SSSDatabaseInfo.ParameterType.Guid, dog_ID),
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("Preferred_Part", SSSDatabaseInfo.ParameterType.Int, preferred_Part),
new SSSDatabaseInfo.DatabaseParameter("Handler_ID", SSSDatabaseInfo.ParameterType.Guid, handler_ID),
new SSSDatabaseInfo.DatabaseParameter("Special_Request", SSSDatabaseInfo.ParameterType.String, special_Request),
new SSSDatabaseInfo.DatabaseParameter("Running_Order", SSSDatabaseInfo.ParameterType.Short, running_Order),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Dog Class. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}