// GET: Distributors
public ActionResult Index()
{
using (var db = new DataEntities())
{
return View(db.Distributors.Include("Address").ToList());
}
}
public ActionResult DistributorsLocations()
{
using (var db = new DataEntities())
{
List<object> distributorsWithLocations = new List<object>();
var distributors = db.Distributors.Include("Address").Where(d => !d.IsInactive).ToList();
foreach (var distributor in distributors)
{
var distributorWithLocation = new
{
distributor.Name,
distributor.Address.Route,
distributor.Address.StreetNumber,
distributor.Address.PostalCode,
distributor.Address.Locality,
distributor.Website,
distributor.IsWholesaler,
distributor.Address.Longitude,
distributor.Address.Latitude
};
distributorsWithLocations.Add(distributorWithLocation);
}
return Json(distributorsWithLocations, JsonRequestBehavior.AllowGet);
}
}
