public IActionResult GetSaleOrder(string options) { var result = _SaleHeaderService.Queryable().ToList(); int count = 0; switch (options) { case "day": count = result.Where(p => p.ModifiedDate.Date == DateTime.Today.Date).Count(); break; case "month": count = result.Where(p => p.ModifiedDate.Month == DateTime.Today.Month).Count(); break; case "year": count = result.Where(p => p.ModifiedDate.Year == DateTime.Today.Year).Count(); break; default: count = result.Where(p => p.ModifiedDate == DateTime.Today).Count(); break; } return(Ok(count)); }
public IActionResult GetSale(string key, int size) { key = string.IsNullOrEmpty(key)? "" :key; var sale_header = _SaleHeaderService.Queryable().ToList(); var customer = _CustomerService.Queryable().ToList(); var product = _ProductService.Queryable().ToList(); var result = from s in sale_header join c in customer on s.CustomerId equals c.CustomerId where c.CustomerName.Contains(key) || c.Phone.Contains(key) orderby c.CustomerName select new { s.SoId, c.CustomerName, c.Phone, s.TotalLine, s.ModifiedDate }; return(Ok(result.Take(size))); }