public int Add(ErrorInfo errorInfo)
{
var db = new SqlDb(_connection);
var com = StoredProcedureFactory.Create(_errorLoggingProcedure,
new SqlParameter("@OffendingURL", errorInfo.OffendingUrl),
new SqlParameter("@OccuredDate", errorInfo.ErrorDate),
new SqlParameter("@ErrorTitle", errorInfo.ErrorTitle),
new SqlParameter("@ErrorDescription", errorInfo.ErrorDescription),
new SqlParameter("@CurrentLogin", errorInfo.UserId),
new SqlParameter("@ApplicationName", errorInfo.ApplicationName));
return db.ExecuteAndReturnScalar(com, "There was a problem logging the error to the database.").ToInt();
}
public void ExecuteAndReturnScalar_ThrowsADBCommandExceptionWhenProcedureFails()
{
var database = new SqlDb(_testConn);
// don't pass params to cause a failure
var testProcedure = StoredProcedureFactory.Create("SqlDb_ExecuteAndReturnScalarTestProcedure1");
database.ExecuteAndReturnScalar(testProcedure, "ExecuteAndReturnScalar test failed.");
Assert.AreEqual(0, 0);
}
public void ExecuteAndReturnScalar_InsertsItemAndReturnsIdOfAddedField()
{
const int expectedValue = 1;
var database = new SqlDb(_testConn);
var testProcedure = StoredProcedureFactory.Create("SqlDb_ExecuteAndReturnScalarTestProcedure1",
new SqlParameter("@Param1", "Testing123"));
object actualObject = database.ExecuteAndReturnScalar(testProcedure, "ExecuteAndReturnScalar test failed.");
var actualValue = Convert.ToInt32(actualObject);
Assert.AreEqual(expectedValue, actualValue);
}
