public async Task <User> GetUserByEmailAndPasswordAsync(string email, string password)
{
return(await Dal.GetByIdAsync <User>("select * from [User] where Email = '" + email + "' AND Password = '******'"));
}
public async Task <User> GetUserByIdAsync(int userId)
{
return(await Dal.GetByIdAsync <User>("select * from [User] where UserId = " + userId));
}
public async Task <Expense> GetExpenseByIdAsync(int expenseId)
{
return(await Dal.GetByIdAsync <Expense>("select * from Expense where ExpenseId = " + expenseId));
}
public async Task <Item> GetItemByIdAsync(int itemId)
{
return(await Dal.GetByIdAsync <Item>("select * from Item where ItemId = " + itemId));
}
public async Task <Client> GetClientByIdAsync(int clientId)
{
return(await Dal.GetByIdAsync <Client>("select * from Client where ClientId = " + clientId));
}
