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);
}
