public ActionResult Delete(int?id, bool?saveChangesError = false) { if (id == null) { return(BadRequest()); } if (saveChangesError.GetValueOrDefault()) { ViewBag.ErrorMessage = "Delete failed.Try again, and if the problem persists see your system administrator."; } string userName = User.Identity.Name; FavCollege favCollegeToDelete = dbContext.FavColleges.FirstOrDefault(c => c.Id == id && c.UserName.Equals(userName)); if (favCollegeToDelete == null) { return(RedirectToAction(nameof(HomeController.Index), "Home")); } return(View(favCollegeToDelete)); }
public ActionResult Delete(int id) { string userName = User.Identity.Name; try { FavCollege favCollegeToRemove = dbContext.FavColleges.Single(c => c.Id == id && c.UserName.Equals(userName)); dbContext.FavColleges.Remove(favCollegeToRemove); dbContext.SaveChanges(); } catch (InvalidOperationException exception) //need to log this exception { return(RedirectToAction(nameof(HomeController.Delete), "Home", new { id = id, saveChangesError = true })); } IEnumerable <FavCollege> favColleges = (from c in dbContext.FavColleges where c.UserName.Equals(userName) select c).ToList(); return(View("ManageFavColleges", favColleges)); }
public ActionResult SaveConfirm(int id) { College college = dbContext.Colleges.Find(id); string userName = User.Identity.Name; if (college != null) { FavCollege favCollege = new FavCollege() { Id = college.Id, Name = college.Name, City = college.City, State = college.State, ZipCode = college.ZipCode, Website = college.Website, AdmissionRate = college.AdmissionRate, Tuition_In_State = college.Tuition_In_State, Tuition_Out_State = college.Tuition_Out_State, AverageSAT = college.AverageSAT, UserName = userName }; IEnumerable <FavCollege> listOfCollegesWithTheSameId = (from c in dbContext.FavColleges where c.Id == favCollege.Id && c.UserName.Equals(userName) select c).ToList(); if (listOfCollegesWithTheSameId == null || listOfCollegesWithTheSameId.Count() == 0) { dbContext.FavColleges.Add(favCollege); dbContext.SaveChanges(); } } IEnumerable <FavCollege> favCollegesForDisplay = (from savedCollege in dbContext.FavColleges where String.Equals(savedCollege.UserName, userName) select savedCollege).ToList(); return(View("ManageFavColleges", favCollegesForDisplay)); }