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 })); }