public async Task <DataTableResponse <ExpenditureModel> > GetPaginatedExpenditure(DataTableQuery dataTableQuery) { var skip = dataTableQuery != null && dataTableQuery.Skip.HasValue ? dataTableQuery?.Skip.Value : 0; var take = dataTableQuery != null && dataTableQuery.Take.HasValue ? dataTableQuery?.Take.Value : 10; var expenditure = await Expenditure.GetAllExpenditure(skip.Value, take.Value); return(new DataTableResponse <ExpenditureModel> { data = expenditure, draw = 0, recordsFiltered = expenditure.Count, recordsTotal = expenditure.Count }); }
public async Task <Dictionary <string, string> > GetDashboardData() { try { var result = new Dictionary <string, string>(); var today = DateTime.UtcNow; var startDateOfMonth = new DateTime(today.Year, today.Month, 1); var minSqlDate = SqlDateTime.MinValue; var invoices = await Invoice.GetAllInvoices(startDateOfMonth, today); var totalCost = invoices.Sum(i => long.Parse(i.TotalAmount)); result.Add("Total Month Cost", totalCost.ToString()); var newCustomers = await Customer.GetNewCustomers(startDateOfMonth, today); result.Add("New Customers", newCustomers.Count().ToString()); var allExpenditures = await Expenditure.GetAllExpenditure(DateTime.Parse(minSqlDate.ToString()), today); result.Add("Total Expenses", allExpenditures.Sum(e => e.Amount).ToString()); var monthExpenses = allExpenditures.Where(x => (x.BillDate >= startDateOfMonth && x.BillDate <= today) || (x.BillDate >= startDateOfMonth && x.BillDate <= today) || (startDateOfMonth >= x.BillDate && startDateOfMonth <= x.BillDate) || (today >= x.BillDate && today <= x.BillDate)); result.Add("Total Month Expense", monthExpenses.Sum(e => e.Amount).ToString()); return(result); } catch (Exception ex) { throw; } }
public async Task <List <ExpenditureModel> > GetAllExpenditure(DateTime fromDate, DateTime toDate) { var expenditures = await Expenditure.GetAllExpenditure(fromDate, toDate); return(expenditures); }