public ActionResult Show(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CityScenicSpotViewModel vm2 = new CityScenicSpotViewModel();
//vm.City = from c in db.Cities where c.CityId == id select c;
vm2.ScenicSpot = from s in db.ScenicSpots
where s.ScenicSpotId == id
select s;
vm2.Review = from r in db.Reviews
join s in db.ScenicSpots
on r.ScenicSpotId equals s.ScenicSpotId
where r.ScenicSpotId == id
select r;
if (vm2.ScenicSpot == null)
{
return(HttpNotFound());
}
return(View(vm2));
}
public ActionResult Show(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CityScenicSpotViewModel vm = new CityScenicSpotViewModel();
vm.City = from c in db.Cities where c.CityId == id select c;
vm.ScenicSpot = from s in db.ScenicSpots
join c in db.Cities
on s.CityId equals c.CityId
orderby s.ScenicSpotName ascending
where id == s.CityId
select s;
if (vm.City == null)
{
return(HttpNotFound());
}
return(View(vm));
}
