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