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 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_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_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_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 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 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_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 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 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 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 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);
}
public Guid?Insert_User_Person(Guid user_ID, Guid person_ID, Guid userID)
{
Guid?retVal = null;
string spName = "spInsert_lnkUser_Person";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_ID", SSSDatabaseInfo.ParameterType.Guid, person_ID),
new SSSDatabaseInfo.DatabaseParameter("UserID", SSSDatabaseInfo.ParameterType.Guid, userID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert User Person. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_People(string person_Title, string person_Surname, string person_Forename, Guid?address_ID, string person_Mobile,
string person_Landline, string person_Email, Guid user_ID, long person_OE_Owner_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblPeople";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
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("User_ID", SSSDatabaseInfo.ParameterType.Guid, user_ID),
new SSSDatabaseInfo.DatabaseParameter("Person_OE_Owner_ID", SSSDatabaseInfo.ParameterType.Long, person_OE_Owner_ID),
};
try
{
retVal = SSSDatabaseInfo.ExecuteScalarReturnGuid(_connString, spName, p);
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to insert Person. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public Guid?Insert_Dogs(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, Guid user_ID)
{
Guid?retVal = null;
string spName = "spInsert_tblDogs";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
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("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. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}