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 ActivateAccount(string userId, int accountId)
{
var sql = "UPDATE Accounts SET IsActive = 0 WHERE UserID = {0} AND AccountId = {1}";
IAccountResult accountResult = null;
using (var conn = _connectionFactory.GetConnection())
{
var result = conn.Execute(string.Format(sql, userId, accountId));
accountResult = new AccountSuccessResult();
accountResult.AddData(string.Format("{0} account(s) activated.", result));
}
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);
}
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);
}
