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_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 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 bool Update_People(Guid original_ID, string person_Title, string person_Surname, string person_Forename, Guid?address_ID, string person_Mobile,
string person_Landline, string person_Email, bool?deleted, Guid user_ID, long person_OE_Owner_ID)
{
bool retVal = false;
string spName = "spUpdate_tblPeople";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_Title", SSSDatabaseInfo.ParameterType.String, person_Title),
new SSSDatabaseInfo.DatabaseParameter("Person_Surname", SSSDatabaseInfo.ParameterType.String, person_Surname),
new SSSDatabaseInfo.DatabaseParameter("Person_Forename", SSSDatabaseInfo.ParameterType.String, person_Forename),
new SSSDatabaseInfo.DatabaseParameter("Address_ID", SSSDatabaseInfo.ParameterType.Guid, address_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_Mobile", SSSDatabaseInfo.ParameterType.String, person_Mobile),
new SSSDatabaseInfo.DatabaseParameter("Person_Landline", SSSDatabaseInfo.ParameterType.String, person_Landline),
new SSSDatabaseInfo.DatabaseParameter("Person_Email", SSSDatabaseInfo.ParameterType.String, person_Email),
new SSSDatabaseInfo.DatabaseParameter("Deleted", SSSDatabaseInfo.ParameterType.Bool, deleted),
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_OE_Owner_ID", SSSDatabaseInfo.ParameterType.Long, person_OE_Owner_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to update Person. 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 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_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 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 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 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_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 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 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_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_Shows(Guid original_ID, 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, bool?entries_Complete, bool?judges_Allocated, bool?split_Classes, bool?running_Orders_Allocated,
bool?ring_Numbers_Allocated, short?maxClassesPerDog, bool?linked_Show, bool?deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblShows";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
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("Entries_Complete", SSSDatabaseInfo.ParameterType.Bool, entries_Complete),
new SSSDatabaseInfo.DatabaseParameter("Judges_Allocated", SSSDatabaseInfo.ParameterType.Bool, judges_Allocated),
new SSSDatabaseInfo.DatabaseParameter("Split_Classes", SSSDatabaseInfo.ParameterType.Bool, split_Classes),
new SSSDatabaseInfo.DatabaseParameter("Running_Orders_Allocated", SSSDatabaseInfo.ParameterType.Bool, running_Orders_Allocated),
new SSSDatabaseInfo.DatabaseParameter("Ring_Numbers_Allocated", SSSDatabaseInfo.ParameterType.Bool, ring_Numbers_Allocated),
new SSSDatabaseInfo.DatabaseParameter("MaxClassesPerDog", SSSDatabaseInfo.ParameterType.Short, maxClassesPerDog),
new SSSDatabaseInfo.DatabaseParameter("Linked_Show", SSSDatabaseInfo.ParameterType.Bool, linked_Show),
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 Person. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool DeleteOwnersDogsClassesList()
{
bool retVal = false;
string spName = "spDeleteOwnersDogsClassesList";
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, null);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to delete Owners Dogs Classes Drawn list. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public void InsertRecordForShowEntryClass(Guid show_Entry_Class_ID)
{
string spName = "spInsert_Judge_Record_For_Show_Entry_Class";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to Insert Judges record for Show Entry Class. Error: {0}", ex.Message));
throw ex;
}
}
public bool ClearFinalClassNames()
{
bool retVal = false;
string spName = "spClearFinalClassNames";
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, null);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to clear Final Class Names. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public void UpdateJudges(Guid show_Entry_Class_ID, string primary_Judge, string reserve_Judge)
{
string spName = "spUpdate_tblJudges";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_Entry_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Entry_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("Primary_Judge", SSSDatabaseInfo.ParameterType.String, primary_Judge),
new SSSDatabaseInfo.DatabaseParameter("Reserve_Judge", SSSDatabaseInfo.ParameterType.String, reserve_Judge),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to Update Judges record for Show Entry Class. Error: {0}", ex.Message));
throw ex;
}
}
public bool Update_Dogs(Guid original_ID, string dog_KC_Name, string dog_Pet_Name, int?dog_Breed_ID, int?dog_Gender_ID,
string reg_No, DateTime?date_Of_Birth, short?year_Of_Birth,
short?merit_Points, bool?nLWU, string breeder, string sire, string dam, bool?deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblDogs";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
new SSSDatabaseInfo.DatabaseParameter("Dog_KC_Name", SSSDatabaseInfo.ParameterType.String, dog_KC_Name),
new SSSDatabaseInfo.DatabaseParameter("Dog_Pet_Name", SSSDatabaseInfo.ParameterType.String, dog_Pet_Name),
new SSSDatabaseInfo.DatabaseParameter("Dog_Breed_ID", SSSDatabaseInfo.ParameterType.Int, dog_Breed_ID),
new SSSDatabaseInfo.DatabaseParameter("Dog_Gender_ID", SSSDatabaseInfo.ParameterType.Int, dog_Gender_ID),
new SSSDatabaseInfo.DatabaseParameter("Reg_No", SSSDatabaseInfo.ParameterType.String, reg_No),
new SSSDatabaseInfo.DatabaseParameter("Date_Of_Birth", SSSDatabaseInfo.ParameterType.DateTime, date_Of_Birth),
new SSSDatabaseInfo.DatabaseParameter("Year_Of_Birth", SSSDatabaseInfo.ParameterType.Short, year_Of_Birth),
new SSSDatabaseInfo.DatabaseParameter("Merit_Points", SSSDatabaseInfo.ParameterType.Short, merit_Points),
new SSSDatabaseInfo.DatabaseParameter("NLWU", SSSDatabaseInfo.ParameterType.Bool, nLWU),
new SSSDatabaseInfo.DatabaseParameter("Breeder", SSSDatabaseInfo.ParameterType.String, breeder),
new SSSDatabaseInfo.DatabaseParameter("Sire", SSSDatabaseInfo.ParameterType.String, sire),
new SSSDatabaseInfo.DatabaseParameter("Dam", SSSDatabaseInfo.ParameterType.String, dam),
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 Dog. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Entrants(Guid original_ID, 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, bool?deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblEntrants";
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("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("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 Entrant. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool Update_Dog_Classes(Guid original_ID, Guid?entrant_ID, Guid?dog_ID, Guid?show_Entry_Class_ID, int preferred_Part,
Guid?show_Final_Class_ID, Guid?handler_ID, short?ring_No, short?running_Order, string special_Request,
bool deleted, Guid user_ID)
{
bool retVal = false;
string spName = "spUpdate_tblDog_Classes";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Original_ID", SSSDatabaseInfo.ParameterType.Guid, original_ID),
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("Show_Final_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Final_Class_ID == new Guid() ? null : show_Final_Class_ID),
new SSSDatabaseInfo.DatabaseParameter("Handler_ID", SSSDatabaseInfo.ParameterType.Guid, handler_ID),
new SSSDatabaseInfo.DatabaseParameter("Ring_No", SSSDatabaseInfo.ParameterType.Short, ring_No),
new SSSDatabaseInfo.DatabaseParameter("Running_Order", SSSDatabaseInfo.ParameterType.Short, running_Order),
new SSSDatabaseInfo.DatabaseParameter("Special_Request", SSSDatabaseInfo.ParameterType.String, special_Request),
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 Dog Class. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool PopulateCatalogueListByRingNumber(Guid show_ID)
{
bool retVal = false;
string spName = "spPopulateCatalogueListByRingNumber";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_ID", SSSDatabaseInfo.ParameterType.Guid, show_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Catalogue List. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public bool PopulateOwnersDogsClassesHandlers(Guid owner_ID)
{
bool retVal = false;
string spName = "spPopulateOwnersDogsClassesHandlers";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Owner_ID", SSSDatabaseInfo.ParameterType.Guid, owner_ID),
};
try
{
SSSDatabaseInfo.ExecuteNonQuery(_connString, spName, p);
retVal = true;
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to populate Owners Dogs Classes. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}