public SpecificationViewModel Update(int id, SpecificationViewModel item) { var currentrecord = db.Specifications .Where(x => x.SpecificationId == id) .FirstOrDefault(); if (!(String.IsNullOrWhiteSpace(item.Description))) { currentrecord.Description = item.Description; } db.SaveChanges(); return currentrecord; }
public SpecificationViewModel Create(SpecificationViewModel item) { string stringTitleCase = helper.ConvertToTitleCase(item.Description); var existingItem = CheckForDuplicates(stringTitleCase); if (existingItem == null) { var newRecord = new SpecificationViewModel { Description = stringTitleCase, Status = "Active" }; db.Specifications.Add(newRecord); db.SaveChanges(); return newRecord; } return null; }
public ActionResult RevertArchive(SpecificationViewModel item) { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Admin" role exists if not it returns a null value var role = db.Roles.SingleOrDefault(m => m.Name == "Admin"); if (User.IsInRole("Admin")) { //Runs a query to determine if the user is actually an "Admin" if not it returns a null value //var userInRole = db.Users.Where(m => m.Roles.Any(r => r.UserId == userId)).FirstOrDefault(); //if (userInRole != null) //{ var specId = item.SpecificationId; if (specId < 1) { RedirectToAction("RetrieveArchives", new { message = ManageMessageId.Error }); } if (item == null) { RedirectToAction("RetrieveArchives", new { message = ManageMessageId.Error }); } _repository.RevertArchive(specId); // return RedirectToAction("Retrieve"); return RedirectToAction("RetrieveArchives", new { message = ManageMessageId.RestoreSuccess }); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }
// GET: Specification/Edit/5 public ActionResult Update(int id) { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Admin" role exists if not it returns a null value var role = db.Roles.SingleOrDefault(m => m.Name == "Admin"); if (User.IsInRole("Admin")) { //Runs a query to determine if the user is actually an "Admin" if not it returns a null value //var userInRole = db.Users.Where(m => m.Roles.Any(r => r.UserId == userId)).FirstOrDefault(); //if (userInRole != null) //{ SpecificationViewModel itemToUpdate = new SpecificationViewModel(); if (id < 1) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Invalid Identifier"); } itemToUpdate = _repository.Get(id); if (itemToUpdate == null) { return HttpNotFound(); } GetNewSupplierActivation(); GetNewModelsActivation(); return View(itemToUpdate); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }
public ActionResult Create(SpecActionViewModel item) { try { bool specificationExist = true; string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Admin" role exists if not it returns a null value var role = db.Roles.SingleOrDefault(m => m.Name == "Admin"); if (User.IsInRole("Admin")) { //Runs a query to determine if the user is actually an "Admin" if not it returns a null value //var userInRole = db.Users.Where(m => m.Roles.Any(r => r.UserId == userId)).FirstOrDefault(); //if (userInRole != null) //{ if (item == null) { return RedirectToAction("Retrieve", new { message = ManageMessageId.Error }); } if (!String.IsNullOrEmpty(item.Description)) { item.Description = helper.ConvertToTitleCase(item.Description); var existingSpec = CheckForDuplicates(item.Description); if (existingSpec == null) { specificationExist = false; } else { var specificationId = db.Specifications.Where(s => s.Description == item.Description).FirstOrDefault().SpecificationId; var recordInProducSpec = db.ProductSpecs.Where(p => p.ProductId == item.ProductId && p.SpecificationId == specificationId).FirstOrDefault(); if (recordInProducSpec == null) { var newProductSpecRecord = new ProductSpecViewModel() { ProductId = item.ProductId, SpecificationId = specificationId }; db.ProductSpecs.Add(newProductSpecRecord); db.SaveChanges(); } specificationExist = true; } } if (specificationExist == false) { var spec = new SpecificationViewModel() { SpecialCatId = item.SpecialCatId, Status = "Active", Description = item.Description }; var productSpec = new ProductSpecViewModel() { ProductId = item.ProductId, SpecificationId = -1 }; if (ModelState.IsValid) { db.Specifications.Add(spec); db.SaveChanges(); productSpec.SpecificationId = spec.SpecificationId; db.ProductSpecs.Add(productSpec); db.SaveChanges(); return RedirectToAction("Retrieve", new { message = ManageMessageId.AddSuccess }); } ViewBag.TagId = new SelectList(db.SpecialCategories, "SpecialCatId", "Description", spec.SpecialCatId); return View(item); } return RedirectToAction("Retrieve"); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }
public ActionResult Create(SpecActionViewModel item) { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } if (User.IsInRole("Supplier")) { //Runs a query to determine if the user is actually an "Admin" if not it returns a null value //var userInRole = db.Users.Where(m => m.Roles.Any(r => r.UserId == userId)).FirstOrDefault(); //if (userInRole != null) //{ if (item == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Item cannot be null!"); } // var newItem = _repository.Create(item); var spec = new SpecificationViewModel() { SpecialCatId = item.SpecialCatId, Status = "Active", Description = item.Description }; var productSpec = new ProductSpecViewModel() { ProductId = item.ProductId, SpecificationId = -1 }; if (ModelState.IsValid) { db.Specifications.Add(spec); db.SaveChanges(); productSpec.SpecificationId = spec.SpecificationId; db.ProductSpecs.Add(productSpec); db.SaveChanges(); return RedirectToAction("Retrieve"); } ViewBag.TagId = new SelectList(db.SpecialCategories, "SpecialCatId", "Description", spec.SpecialCatId); return View(item); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }