public int GetTotalRevenue(BillParams billParams)
{
var bills = _context.Bills.AsQueryable();
var total = 0;
if (billParams.year != 0)
{
bills = bills.Where(b => b.CreatedDate.Year == billParams.year);
}
if (billParams.month != 0)
{
bills = bills.Where(b => b.CreatedDate.Month == billParams.month);
}
if (billParams.day != 0)
{
bills = bills.Where(b => b.CreatedDate.Day == billParams.day);
}
foreach (var bill in bills)
{
total += bill.Value;
}
return(total);
}
public int GetTotalRevenue([FromQuery] BillParams billParams)
{
var bills = _repo.GetTotalRevenue(billParams);
// var billsForView = _mapper.Map<IEnumerable<BillForViewDto>>(bills);
// Response.AddPagination(bills.CurrentPage, bills.PageSize, bills.TotalCount, bills.TotalPages);
return(bills);
}
public async Task <IActionResult> GetBills([FromQuery] BillParams billParams)
{
var bills = await _repo.GetBills(billParams);
var billsForView = _mapper.Map <IEnumerable <BillForViewDto> >(bills);
Response.AddPagination(bills.CurrentPage, bills.PageSize, bills.TotalCount, bills.TotalPages);
return(Ok(billsForView));
}
public async Task <PagedList <Bill> > GetBills(BillParams billParams)
{
var bills = _context.Bills.AsQueryable();
if (billParams.year != 0)
{
bills = bills.Where(b => b.CreatedDate.Year == billParams.year);
}
if (billParams.month != 0)
{
bills = bills.Where(b => b.CreatedDate.Month == billParams.month);
}
if (billParams.day != 0)
{
bills = bills.Where(b => b.CreatedDate.Day == billParams.day);
}
return(await PagedList <Bill> .CreateAsync(bills, billParams.PageNumber, billParams.PageSize));
}
