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