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