public async Task <List <ItemExpenses> > GetExpensesForDateAsync(DateTime currentDate) { var expensesList = await Dal.GetAllAsync <Expense>(string.Format("select e.*, i.Name ItemName, i.Price ItemPrice from Expense e inner join Item i on e.ItemId = i.ItemId where MONTH(RelateToMonth) = {0} AND YEAR(RelateToMonth) = {1}", currentDate.Month, currentDate.Year)); var itemExpensesList = expensesList.GroupBy(a => new { a.ItemId, a.ItemName, a.ItemPrice }).Select(a => new ItemExpenses { ItemId = a.Key.ItemId ?? 0, ItemName = a.Key.ItemName, ItemPrice = a.Key.ItemPrice, ExpensesPrices = a.Where(i => i.Payed == true).Sum(i => i.Price), ItemExpensesList = a.ToList() }).ToList(); return(itemExpensesList); }
public async Task <List <User> > GetUsersAsync() { return(await Dal.GetAllAsync <User>("select * from [User]")); }
public async Task <List <Item> > GetItemsAsync() { return(await Dal.GetAllAsync <Item>("select * from Item")); }
public async Task <List <Expense> > GetExpensesAsync() { return(await Dal.GetAllAsync <Expense>("select * from Expense")); }
public async Task <List <Client> > GetClientsAsync() { return(await Dal.GetAllAsync <Client>("select * from Client")); }