public ActionResult Edit(Guid?id) { ConsumerLogInInfo consumerLogInInfo = db.ConsumerLogInInfoes.FirstOrDefault(a => a.ConsumerTouchPointID == id); LoadSpinners(); return(View(consumerLogInInfo)); }
public ActionResult DeleteConsumer(Guid?id) { ConsumerLogInInfo consumerLogInInfo = db.ConsumerLogInInfoes.FirstOrDefault(a => a.ConsumerTouchPointID == id); //try //{ //Remove all products associated records IQueryable <ConsumerProduct> consumerProducts = db.ConsumerProducts.Where(a => a.ConsumerTouchPointID == id); foreach (var product in consumerProducts) { var purchaseReason = db.ConsumerPurchaseReasons.FirstOrDefault(a => a.ConsumerProductID == product.ConsumerProductID); db.ConsumerPurchaseReasons.Remove(purchaseReason); db.PurchaseDynamics.Remove(product.PurchaseDynamic); foreach (var satisfaction in product.ProductSatisfactions) { db.ProductSatisfactions.Remove(satisfaction); } db.ProductSatisfactionOlds.Remove(product.ProductSatisfactionOld); db.ConsumerProducts.Remove(product); } //Remove all consumer associated records foreach (var consumerDemography in db.ConsumerDemographics.Where(a => a.ConsumerTouchPointID == id)) { db.ConsumerDemographics.Remove(consumerDemography); } //Remove consumer db.ConsumerLogInInfoes.Remove(db.ConsumerLogInInfoes.FirstOrDefault(a => a.ConsumerTouchPointID == id)); //commit db.SaveChanges(); //} // catch (Exception exception) // { //Exception // } return(RedirectToAction("Index", "Home")); }
public ActionResult Edit(ConsumerLogInInfo consumerLogInInfo) { if (ModelState.IsValid) { ConsumerLogInInfo consumer = db.ConsumerLogInInfoes.FirstOrDefault(a => a.ConsumerTouchPointID == consumerLogInInfo.ConsumerTouchPointID); if (consumer == null) { return(HttpNotFound()); } //db.Entry(consumerLogInInfo).State=EntityState.Modified; try { consumer.ConsumerTouchPointProfile.NameLast = consumerLogInInfo.ConsumerTouchPointProfile.NameLast; consumer.ConsumerTouchPointProfile.NameFirst = consumerLogInInfo.ConsumerTouchPointProfile.NameFirst; consumer.UserID = consumerLogInInfo.UserID; consumer.ConsumerTouchPointProfile.ConsumerDemographic.Street = consumerLogInInfo.ConsumerTouchPointProfile.ConsumerDemographic.Street; consumer.ConsumerTouchPointProfile.ConsumerDemographic.City = consumerLogInInfo.ConsumerTouchPointProfile.ConsumerDemographic.City; consumer.ConsumerTouchPointProfile.ConsumerDemographic.PostCode = consumerLogInInfo.ConsumerTouchPointProfile.ConsumerDemographic.PostCode; consumer.ConsumerTouchPointProfile.ConsumerDemographic.PhoneHome = consumerLogInInfo.ConsumerTouchPointProfile.ConsumerDemographic.PhoneHome; if (consumerLogInInfo.DisplayName == null) { ModelState.AddModelError(string.Empty, "Display Name cannot be empty"); throw new DbEntityValidationException(); } consumer.DisplayName = consumerLogInInfo.DisplayName; db.SaveChanges(); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { ModelState.AddModelError(string.Empty, validationError.ErrorMessage); } } LoadSpinners(); return(View("Edit", consumerLogInInfo)); } catch (DuplicateKeyException exception) { ModelState.AddModelError(string.Empty, exception.InnerException.Message); LoadSpinners(); return(View("Edit", consumerLogInInfo)); } catch (Exception exception) { ModelState.AddModelError(string.Empty, exception.Message + "Error updating database. Please contact IT"); LoadSpinners(); return(View("Edit", consumerLogInInfo)); } LoadSpinners(); ViewBag.successEditUser = true; return(View("Edit", consumerLogInInfo)); } LoadSpinners(); return(View("Edit", consumerLogInInfo)); //return View(consumerLogInInfo); }