public User Authenticate(string email, string password)
{
password = CrossCutting.ExtensionMethods.PasswordExtensions.GenerateSHA1(password);
string query = $@"SELECT * FROM [User]
WHERE Email = @email
AND Password = @password
AND Active = 1";
return(db.GetFirsOrDefault <User>(query, new { email, password }));
}
public CheckingAccount GetByAccountNumber(long accountNumber)
{
return(db.GetFirsOrDefault <CheckingAccount>($@"SELECT * FROM [CheckingAccount] WHERE AccountNumber = @accountNumber AND Active = 1", new { accountNumber }));
}
public Transaction GetById(Guid id)
{
return(db.GetFirsOrDefault <Transaction>($@"SELECT * FROM [Transaction] WHERE Id = @id AND Active = 1", new { id }));
}