public async Task <ActionResult <SalesReturnsbyDayDto> > GetSalesbyDay([FromBody] DateTime time) { if (time == null) { return(BadRequest("the value has been null")); } var salestotal = await _context.SalesTotalByDayView.Where(x => x.RegDt.Value.Date == time.Date).ToListAsync(); var returnstotal = await _context.ReturnTotalByDayView.Where(x => x.RegDt.Value.Date == time.Date).ToListAsync(); SalesReturnsbyDayDto result = _mapper.Map <SalesReturnsbyDayDto>(salestotal.FirstOrDefault()); if (result == null) { return new SalesReturnsbyDayDto() { RegDt = time } } ; if (returnstotal.Count > 0) { result.ReturnCost = returnstotal.FirstOrDefault().ReturnCost; } return(result); } }
public async Task <SalesReturnsbyDayDto> Get() { SalesReturnsbyDayDto result = new SalesReturnsbyDayDto(); var salestotal = await _context.SalesTotalByDayView.Where(x => x.RegDt.Value.Date == DateTime.Now.Date).ToListAsync(); var returnstotal = await _context.ReturnTotalByDayView.Where(x => x.RegDt.Value.Date == DateTime.Now.Date).ToListAsync(); if (salestotal.FirstOrDefault() != null) { result = _mapper.Map <SalesReturnsbyDayDto>(salestotal.FirstOrDefault()); } if (returnstotal.Count > 0) { result.ReturnCost = returnstotal.FirstOrDefault().ReturnCost; } if (User.IsInRole("admin")) { var profit = await _context.AvProfit.AsNoTracking().FirstOrDefaultAsync(); if (profit != null) { result.AvProfit = profit; } } else { result.IncomeCost = 0; } return(result); }