public IActionResult getDTNVTrongNgay_Linq([FromBody] DateReq req) { var res = new SingleRsp(); res.Data = _svc.GetDoanhThuNhanVien_linq(req.date); return(Ok(res)); }
public IActionResult DoanhThuNhanVien([FromBody] DateReq req) { var res = new SingleRsp(); res.Data = _svc.GetDoanhThuNhanVien(req.date); return(Ok(res)); }
public IActionResult getDSDonHangDe5_Linq([FromBody] DateReq req) { var res = new SingleRsp(); res.Data = _svc.GetDSDonHangDe5_Linq(req.date); return(Ok(res)); }
/// <summary> đề 4 câu 4 /// </summary> /// <param name="req"></param> /// <returns>Doanh thu shipper</returns> public SingleRsp DoanhThuShipper(DateReq req) { var res = from s in Context.Shippers join o in Context.Orders on s.ShipperId equals o.ShipVia where o.OrderDate.Value.Month == req.Month && o.OrderDate.Value.Year == req.Year select new { s.ShipperId, o.Freight }; SingleRsp result = new SingleRsp(); result.Data = from r in res group r by new { r.ShipperId } into e select new { e.Key.ShipperId, DoanhThu = e.Sum(x => x.Freight).ToString() }; return(result); }
public SingleRsp DoanhThuShipper(DateReq req) { return(_rep.DoanhThuShipper(req)); }
public IActionResult DoanhThuShipper(DateReq req) { var res = _svc.DoanhThuShipper(req); return(Ok(res)); }