public ActionResult Index() { var model = new ProfileViewModel { LastestForsale = db.ForSale.Where(x => x.Seller.Username == User.Identity.Name).OrderByDescending(x => x.When).Select(x => x).ToList(), LatestForfree = db.ForFree.Where(x => x.Donator.Username == User.Identity.Name).OrderByDescending(x => x.When).Select(x => x).ToList(), LatestWanted = db.Wanted.Where(x => x.Buyer.Username == User.Identity.Name).OrderByDescending(x => x.When).Select(x => x).ToList(), Profile = db.Profiles.Where(x => x.Username == User.Identity.Name).ToList() }; return View(model); }
public ActionResult Show(int? id) { var data = db.Profiles.Where(e => e.Id == id).Select(e => e); var username = db.Profiles.Where(e => e.Id == id).Select(e => e.Username).Single().ToString(); //If the id is not associated with a row in the database, return to index. Else, continue. if (data.Count() == 0) { return RedirectToAction("Index", "Home"); } else { var model = new ProfileViewModel { LastestForsale = db.ForSale.Where(x => x.Seller.Username == username).OrderByDescending(x => x.When).Select(x => x).ToList(), LatestForfree = db.ForFree.Where(x => x.Donator.Username == username).OrderByDescending(x => x.When).Select(x => x).ToList(), LatestWanted = db.Wanted.Where(x => x.Buyer.Username == username).OrderByDescending(x => x.When).Select(x => x).ToList(), Profile = db.Profiles.Where(x => x.Id == id).ToList() }; return View(model); } }