public IAccountResult CreateItem(IAccount model)
{
IAccountResult accountResult;
var conn = _connectionFactory.GetConnection();
model.DateCreated = DateTime.Now;
var sql = "INSERT INTO Accounts (UserId, Name, Description, DateCreated, IsActive) " +
"VALUES (@UserId, @Name, @Description, @DateCreated, @IsActive);" +
"SELECT CAST(SCOPE_IDENTITY() AS INT)";
var temp = conn.Query <int>(sql, model).Single();
model.AccountId = temp;
if (temp > 0)
{
accountResult = new AccountSuccessResult();
accountResult.Item = model;
}
else
{
accountResult = new AccountFailureResult();
}
return(accountResult);
}
public IAccountResult DeleteItem(IAccount model)
{
IAccountResult accountResult;
using (var conn = _connectionFactory.GetConnection())
{
var result = conn.Delete(model);
if (result == true)
{
accountResult = new AccountSuccessResult();
}
else
{
accountResult = new AccountFailureResult();
}
}
return(accountResult);
}
protected IAccountResult CreateItem(IAccount model)
{
IAccountResult result;
var validationErrors = _validator.Validate(model).ToList();
if (validationErrors.Count == 0)
{
result = _repository.CreateItem(model);
}
else
{
result = new AccountFailureResult()
{
Item = model
};
((List <string>)result.Data).AddRange(validationErrors);
}
return(result);
}
public IAccountResult UpdateItem(IAccount model)
{
IAccountResult accountResult;
using (var conn = _connectionFactory.GetConnection())
{
var result = conn.Update(model);
if (result == true)
{
accountResult = new AccountSuccessResult();
accountResult.Item = model;
}
else
{
accountResult = new AccountFailureResult();
accountResult.AddData("Unable to update account Id " + model.AccountId);
}
}
return(accountResult);
}
public IAccountResult GetItem(int key)
{
IAccountResult accountResult;
using (var conn = _connectionFactory.GetConnection())
{
var result = conn.Get <IAccount>(new AccountDTO {
AccountId = key
});
if (result != null)
{
accountResult = new AccountSuccessResult();
accountResult.Item = result;
}
else
{
accountResult = new AccountFailureResult();
accountResult.AddData("Unable to locate account Id " + key);
}
}
return(accountResult);
}
