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