public int?Insert_Dog_Breed(string dog_Breed_Description) { int?retVal = null; string spName = "spInsert_lkpDog_Breeds"; SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[] { new SSSDatabaseInfo.DatabaseParameter("Dog_Breed_Description", SSSDatabaseInfo.ParameterType.String, dog_Breed_Description), }; try { retVal = SSSDatabaseInfo.ExecuteScalarReturnInt(_connString, spName, p); } catch (Exception ex) { ErrorLog.LogMessage(string.Format("Failed to insert Dog Breeder. Error: {0}", ex.Message)); throw ex; } return(retVal); }
public int GetEntryCountByShow_Final_Class_ID(Guid show_Final_Class_ID) { int retVal = 0; string spName = "spGetEntryCountByShow_Final_Class_ID"; SSSDatabaseInfo.DatabaseParameter[] p = new SSSDatabaseInfo.DatabaseParameter[] { new SSSDatabaseInfo.DatabaseParameter("Show_Final_Class_ID", SSSDatabaseInfo.ParameterType.Guid, show_Final_Class_ID), }; try { retVal = SSSDatabaseInfo.ExecuteScalarReturnInt(_connString, spName, p); } catch (Exception ex) { ErrorLog.LogMessage(string.Format("Failed to get Class Entry Count. Error: {0}", ex.Message)); throw ex; } return(retVal); }