public async Task <ActionResult <BaseRespone> > GetTonSuDung(DoanhthuResquest resquest)
{
await _context.Database.ExecuteSqlCommandAsync("exec thongkesudung5 @from,@to,@idnl", new SqlParameter("@from", resquest.dateFrom.ToShortDateString()), new SqlParameter("@to", resquest.dateTo.ToShortDateString()), new SqlParameter("@idnl", resquest.idnguyenlieu));
//var a = await _context.ThongKeTonKhos.Where(x => x.id_nguyenlieu == resquest.idnguyenlieu).ToListAsync();
return(new BaseRespone(await _context.SuDungs.ToListAsync()));
}
public async Task <ActionResult <ThuChiRespone> > GetThuChi(DoanhthuResquest resquest)
{
return(new ThuChiRespone
{
tongchi = _context.DoanhThus.Sum(x => x.chi),
tongthu = _context.DoanhThus.Sum(x => x.thu),
maxchi = _context.DoanhThus.Max(x => x.chi),
maxthu = _context.DoanhThus.Max(x => x.thu)
});
}
public async Task <ActionResult <BaseRespone> > GetSoluongBan(DoanhthuResquest resquest)
{
await _context.Database.ExecuteSqlCommandAsync("exec thong_ke_so_luong_ban @from,@to", new SqlParameter("@from", resquest.dateFrom.ToShortDateString()), new SqlParameter("@to", resquest.dateTo.ToShortDateString()));
var data = await _context.ThongKeSoLuongs.GroupBy(x => x.ten_mon).Select(x => new ThongKeSoLuong
{
ten_mon = x.Key,
so_luong = x.Sum(t => t.so_luong)
}).ToListAsync();
return(new BaseRespone(data));
}
public async Task <ActionResult <BaseRespone> > GetDoanhThu(DoanhthuResquest resquest)
{
await _context.Database.ExecuteSqlCommandAsync("exec doanh_thu @from,@to", new SqlParameter("@from", resquest.dateFrom.ToShortDateString()), new SqlParameter("@to", resquest.dateTo.ToShortDateString()));
return(new BaseRespone(await _context.DoanhThus.AsNoTracking().ToListAsync()));
}
