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