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