public ActionResult ViewGardener(int id) { GardenerIndexViewModel model = new GardenerIndexViewModel(); Follow follow = (from data in context.Follows where data.ID == id select data).First(); follow.DateChecked = DateTime.Now; context.SaveChanges(); var user = (from data in context.Follows where data.ID == id select data.FollowedUser).First(); model.Blogs = (from data in context.BlogPosts where data.User.Id == user.Id select data).ToList(); model.CropEntries = (from data in context.CropEntries where data.User.Id == user.Id && data.IsPublic select data).ToList(); return(View(model)); }
public ActionResult Index() { var user = UserRetriever.RetrieveUser(User, context); var zone = (from data in context.UserAddresses.Include("Address") where data.User.Id == user.Id select data.Address.Zone).ToList(); GardenerIndexViewModel model = new GardenerIndexViewModel(); if (zone.Count > 0) { var refinedZone = int.Parse(zone[0].Replace("a", String.Empty).Replace("b", String.Empty)); model.Reccomentdations = (from data in context.PlantZones.Include("Plant") where data.Zone.ID == refinedZone select data.Plant).ToList(); model.Forcast = ForcastRetriever.GetForcast(User); } model.Blogs = (from data in context.BlogPosts where data.User.Id == user.Id select data).ToList(); model.CropEntries = (from data in context.CropEntries where data.User.Id == user.Id select data).ToList(); model.Follows = (from data in context.Follows.Include("FollowedUser") where data.User.Id == user.Id select data).ToList(); model.User = user; return(View(model)); }