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