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 DataTable GetOwnersDogsClassesDrawn(bool display)
{
DataTable retVal = null;
string spName = "";
if (display)
{
spName = "spGetOwnersDogsClassesDrawnList";
}
else
{
spName = "spGetOwnersDogsClassesDrawnListOrderByEntry_Date";
}
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, null);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Owners Dogs Classes Drawn list. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
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);
}
