public void ReturnsSqlException()
{
// Arrange -> Act
var sqlException = SqlClientUtil.CreateSqlException(message, errorCollection, innerException, conId);
// Assert
Assert.IsAssignableFrom <SqlException>(sqlException);
}
public void HasNoParams_ReturnsSqlErrorCollection()
{
// Arrange -> Act
var errorCollection = SqlClientUtil.CreateSqlErrorCollection();
// Assert
Assert.IsAssignableFrom <SqlErrorCollection>(errorCollection);
}
public void HasNoParams_ReturnsSqlException()
{
// Arrange -> Act
var ex = SqlClientUtil.CreateSqlException(message, innerException, conId);
// Assert
Assert.IsAssignableFrom <SqlException>(ex);
}
public void HasParams_ReturnsSqlErrorCollectionWithErrors()
{
// Arrange
var sqlError = SqlClientUtil.CreateSqlError(0);
// Act
var errorCollection = SqlClientUtil.CreateSqlErrorCollection(sqlError);
// Assert
Assert.Contains(sqlError, errorCollection.OfType <SqlError>());
}
public void HasParams_ReturnsSqlExceptionWithErrors()
{
// Arrange
var sqlError = SqlClientUtil.CreateSqlError(0);
// Act
var ex = SqlClientUtil.CreateSqlException(message, innerException, conId, sqlError);
// Assert
Assert.Contains(sqlError, ex.Errors.OfType <SqlError>());
}
public void ReturnsSqlError()
{
// Arrange
int infoNumber = 0;
// Act
var error = SqlClientUtil.CreateSqlError(infoNumber);
// Assert
Assert.IsAssignableFrom <SqlError>(error);
}
public void ExIsSqlCommandExceptionAndDoesNotContainSqlErrorWithNumberIs2_ReturnsFalse()
{
// Arrange
var sqlError = SqlClientUtil.CreateSqlError(0);
var sqlException = SqlClientUtil.CreateSqlException(sqlError);
var ex = new SqlCommandException(null, sqlException, null);
// Act
var isTransient = LeaderboardsStoreClient.IsTransient(ex);
// Assert
Assert.False(isTransient);
}
public void ReturnsSqlException()
{
// Arrange
var message = "myMessage";
var innerException = SqlClientUtil.CreateSqlException();
var commandText = "myCommandText";
var ex = new SqlCommandException(message, innerException, commandText);
// Act
var innerException2 = ex.InnerException;
// Assert
Assert.IsAssignableFrom <SqlException>(innerException2);
}
public void ReturnsSqlError()
{
// Arrange
int infoNumber = 0;
byte errorState = 0;
byte errorClass = 0;
string server = "server";
string errorMessage = "errorMessage";
string procedure = "procedure";
int lineNumber = 0;
uint win32ErrorCode = 0;
// Act
var error = SqlClientUtil.CreateSqlError(infoNumber, errorState, errorClass, server, errorMessage, procedure, lineNumber, win32ErrorCode);
// Assert
Assert.IsAssignableFrom <SqlError>(error);
}
public void AddsError()
{
// Arrange
var errorCollection = SqlClientUtil.CreateSqlErrorCollection();
int infoNumber = 0;
byte errorState = 0;
byte errorClass = 0;
string server = "server";
string errorMessage = "errorMessage";
string procedure = "procedure";
int lineNumber = 0;
uint win32ErrorCode = 0;
var error = SqlClientUtil.CreateSqlError(infoNumber, errorState, errorClass, server, errorMessage, procedure, lineNumber, win32ErrorCode);
// Act
errorCollection.Add(error);
// Assert
Assert.Same(error, errorCollection[0]);
}
public void Invoke(CreateInvoiceCommandModel commandModel)
{
// Initialize
_commandModel = commandModel;
if (_commandModel.InvoiceId == 0)
{
// Invoice header
var invHeader = GetInvHeaderEntity();
// Invoice items
foreach (var invItemModel in commandModel.InvoiceItems)
{
var invItem = GetInvItemEntity(invItemModel);
invHeader.ProductInvoiceDetails.Add(invItem);
}
// Create Invoice
_repository.Persist();
commandModel.Result = invHeader.Id.Value;
// Post update logic for stock (handled in stored proc)
var invoiceIDsParam = SqlClientUtil.CreateIntListParameter("@ProductInvoiceIDs", invHeader.Id.Value);
_repository.ExecuteStoredProcedure("[API].[spCompleteInvoices]", invoiceIDsParam);
}
else
{
// Updating Term
var invoice = _repository.GetQuery <Dto.ProductInvoiceHeader>(s => s.Id == _commandModel.InvoiceId).FirstOrDefault();
invoice.Comment = _commandModel.Comment;
invoice.TermId = _commandModel.TermId;
_repository.Persist();
}
}
