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