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 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 DataTable GetPeopleBySurnameForenameEmail(string person_Surname, string person_Forename, string person_Email)
{
DataTable retVal = null;
string spName = "spGetPeopleBySurnameForenameEmail";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Person_Surname", SSSDatabaseInfo.ParameterType.String, person_Surname),
new SSSDatabaseInfo.DatabaseParameter("Person_Forename", SSSDatabaseInfo.ParameterType.String, person_Forename),
new SSSDatabaseInfo.DatabaseParameter("Person_Email", SSSDatabaseInfo.ParameterType.String, person_Email),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get People. 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);
}
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 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 DataTable GetDog_Gender()
{
DataTable retVal = null;
string spName = "spGetDog_Gender";
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, null);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Dog Gender. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetEntrants()
{
DataTable retVal = null;
string spName = "spGetEntrants";
SSSDatabaseInfo.DatabaseParameter[] p = null;
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 DataTable GetDog_GenderLikeDog_Gender(string dog_Gender)
{
DataTable retVal = null;
string spName = "spGetDog_GenderLikeDog_Gender";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Dog_Gender", SSSDatabaseInfo.ParameterType.String, dog_Gender),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Dog Gender. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetGuarantorByGuarantor_ID(Guid guarantor_ID)
{
DataTable retVal = null;
string spName = "spGetGuarantorByGuarantor_ID";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Guarantor_ID", SSSDatabaseInfo.ParameterType.Guid, guarantor_ID),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Guarantors. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetFinalClassNamesByOrderBy(short orderBy)
{
DataTable retVal = null;
string spName = "spGetFinalClassNamesByOrderBy";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("OrderBy", SSSDatabaseInfo.ParameterType.Short, orderBy),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Final Class Names. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetDogsWhereBreed_IDInList(string breed_IDs)
{
DataTable retVal = null;
string spName = "spGetDogsWhereDog_Breed_IDInList";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("breed_IDs", SSSDatabaseInfo.ParameterType.String, breed_IDs),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Dogs. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetAddressesLikeAddress_2(string address_2)
{
DataTable retVal = null;
string spName = "spGetAddressesLikeAddress_2";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Address_2", SSSDatabaseInfo.ParameterType.String, address_2),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Addresses. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetDog_BreedsByDog_Breed_ID(int dog_Breed_ID)
{
DataTable retVal = null;
string spName = "spGetDog_BreedByDog_Breed_ID";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Dog_Breed_ID", SSSDatabaseInfo.ParameterType.Int, dog_Breed_ID),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Dog Breed. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetShow_RolesByShow_Role_Description(string show_Role_Description)
{
DataTable retVal = null;
string spName = "spGetShow_RolesLikeShow_Role_Description";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Show_Role_Description", SSSDatabaseInfo.ParameterType.String, show_Role_Description),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Show Roles. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}
public DataTable GetClubsLikeClub_Short_Name(string club_Short_Name)
{
DataTable retVal = null;
string spName = "spGetClubsByClub_Short_Name";
SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[]
{
new SSSDatabaseInfo.DatabaseParameter("Club_Short_Name", SSSDatabaseInfo.ParameterType.String, club_Short_Name),
};
try
{
DataSet ds = SSSDatabaseInfo.ExecuteDataSet(_connString, spName, p);
retVal = ds.Tables[0];
}
catch (Exception ex)
{
ErrorLog.LogMessage(string.Format("Failed to get Clubs. Error: {0}", ex.Message));
throw ex;
}
return(retVal);
}