public bool DeleteTransactionForUser(int transactionId, int userId)
{
var transactionToBeRemoved =
_civMoneyContext.Transactions.Where(transaction => transaction.Id == transactionId).SingleOrDefault();
if (transactionToBeRemoved != null)
{
_civMoneyContext.Transactions.Remove(transactionToBeRemoved);
_civMoneyContext.SaveChanges();
return(true);
}
return(false);
}
public bool UpdateUserCurrency(int userId, string currency)
{
var user = _civMoneyContext.Users.Where(users => users.Id == userId).SingleOrDefault();
if (user != null)
{
user.Currency = currency;
user.TimeModified = DateTime.UtcNow;
_civMoneyContext.SaveChanges();
return(true);
}
return(false);
}
public int AddSingleTransaction(
decimal amount,
string description,
DateTime date,
int userId)
{
var transaction = new Transaction
{
Amount = amount,
Description = description,
Date = date,
UserId = userId
};
var transactionAdded = _civMoneyContext.Transactions.Add(transaction);
_civMoneyContext.SaveChanges();
return(transactionAdded.Id);
}
public int AddUser(string userName, string password, string currency)
{
if (_civMoneyContext.Users.Where(users => users.UserName == userName).Count() != 0)
{
return(-1);
}
var user = new User
{
UserName = userName,
PasswordHash = BCryptHelper.HashPassword(password, BCryptHelper.GenerateSalt()),
Currency = currency,
TimeModified = DateTime.UtcNow
};
_civMoneyContext.Users.Add(user);
_civMoneyContext.SaveChanges();
var userId = _civMoneyContext.Users.Where(users => users.UserName == userName).SingleOrDefault().Id;
return(userId);
}
