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