public List<CountryCustomers_Result> GetCountryCustomers(string Country, DateTime FromDate, DateTime ToDate) { var northwind = new NorthwindEntities(); var result = northwind.CountryCustomers(Country, FromDate.ToString("yyyyMMdd"), ToDate.ToString("yyyyMMdd")); return result.ToList(); }
public int GetCountryCustomersTotal(string Country, DateTime FromDate, DateTime ToDate) { var northwind = new NorthwindEntities(); int result = northwind.CountryCustomers(Country, FromDate.ToString("yyyyMMdd"), ToDate.ToString("yyyyMMdd")).ToList().Count(); return result; }
public ActionResult CountryCustomers(string Country, DateTime FromDate, DateTime ToDate) { var northwind = new NorthwindEntities(); var result = northwind.CountryCustomers(Country, FromDate.ToString("yyyyMMdd"), ToDate.ToString("yyyyMMdd")); return Json(result, JsonRequestBehavior.AllowGet); }