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); }