/// <summary> /// convert contingType model to domain /// </summary> /// <param name="model"></param> /// <returns></returns> public CoatingType ConvertToDomain(CoatingTypeViewModel model) { CoatingType coatingType = new CoatingType(); coatingType.CoatingTypeId = model.CoatingTypeId; coatingType.Description = model.CoatingTypeDescription; coatingType.IsActive = model.IsActive; return(coatingType); }
// // GET: /CoatingType/Details/5 public ActionResult Details(int id = 0) { CoatingType coatingtype = db.CoatingTypes.Find(id); if (coatingtype == null) { return(HttpNotFound()); } return(View(coatingtype)); }
/// <summary> /// convert coatingType to view model /// </summary> /// <param name="coatingType"></param> /// <returns></returns> public CoatingTypeViewModel ConvertToView(CoatingType coatingType) { CoatingTypeViewModel model = new CoatingTypeViewModel(); model.CoatingTypeId = coatingType.CoatingTypeId; model.CoatingTypeDescription = (!string.IsNullOrEmpty(coatingType.Description)) ? coatingType.Description : "N/A"; model.IsActive = coatingType.IsActive; return(model); }
public ActionResult DeleteConfirmed(int id) { CoatingType coatingtype = db.CoatingTypes.Find(id); db.CoatingTypes.Remove(coatingtype); db.SaveChanges(); if (Insert_CodeLookUp_Audit("Coating Type", "Delete", coatingtype.CoatingTypeItem, "")) { //nothing to do at this point. } return(RedirectToAction("Index")); }
public ActionResult Edit(CoatingType coatingtype) { if (ModelState.IsValid) { db.Entry(coatingtype).State = EntityState.Modified; db.SaveChanges(); if (Insert_CodeLookUp_Audit("Coating Type", "Edit", Session["CodeLookUpAduit_Oldvalue"].ToString(), coatingtype.CoatingTypeItem)) { //nothing to do at this point. } return(RedirectToAction("Index")); } return(View(coatingtype)); }
/// <summary> /// get coating type by nullable id /// </summary> /// <param name="coatingTypeId"></param> /// <returns></returns> public CoatingType GetCoatingType(Guid?coatingTypeId) { var coatingType = new CoatingType(); try { coatingType = _db.CoatingType.FirstOrDefault(x => x.CoatingTypeId == coatingTypeId); } catch (Exception ex) { logger.ErrorFormat("Error getting coating type: {0} ", ex.ToString()); } return(coatingType); }
/// <summary> /// get coating type by description /// </summary> /// <param name="description"></param> /// <returns></returns> public CoatingType GetCoatingType(string description) { var coatingType = new CoatingType(); try { coatingType = _db.CoatingType.FirstOrDefault(x => x.Description.Replace(" ", string.Empty).ToLower() == description.Replace(" ", string.Empty).ToLower()); } catch (Exception ex) { logger.ErrorFormat("Error getting coating type: {0} ", ex.ToString()); } return(coatingType); }
public ActionResult Create(CoatingType coatingtype) { if (ModelState.IsValid) { db.CoatingTypes.Add(coatingtype); db.SaveChanges(); if (Insert_CodeLookUp_Audit("Coating Type", "Create", "", coatingtype.CoatingTypeItem)) { //nothing to do at this point. } return(RedirectToAction("Index")); } return(View(coatingtype)); }
// // GET: /CoatingType/Delete/5 public ActionResult Delete(int id = 0) { CoatingType coatingtype = db.CoatingTypes.Find(id); var coatingfeatiures = (from vf in db.ValveSectionFeatures where vf.CoatingTypeID == coatingtype.CoatingTypeID select new { vf }).ToList(); if (coatingfeatiures.Count > 0) { ModelState.AddModelError("CoatingTypeItem", "This Coating Type is assigned to Circuit feature(s) and cannot be deleted."); ViewBag.HasError = "True"; } if (coatingtype == null) { return(HttpNotFound()); } return(View(coatingtype)); }
// // GET: /CoatingType/Edit/5 public ActionResult Edit(int id = 0) { CoatingType coatingtype = db.CoatingTypes.Find(id); var coatingfeatiures = (from vf in db.ValveSectionFeatures where vf.CoatingTypeID == coatingtype.CoatingTypeID select new { vf }).ToList(); if (coatingfeatiures.Count > 0) { ModelState.AddModelError("CoatingTypeItem", "Warning! This Coating Type is assigned to Circuit feature(s)."); ViewBag.HasError = "True"; } if (coatingtype == null) { return(HttpNotFound()); } Session["CodeLookUpAduit_Oldvalue"] = coatingtype.CoatingTypeItem; return(View(coatingtype)); }
/// <summary> /// update coating type /// </summary> /// <param name="coatingType"></param> /// <returns></returns> public OperationResult UpdateCoatingType(CoatingType coatingType) { var operationResult = new OperationResult(); var existingCoatingType = GetCoatingType(coatingType.CoatingTypeId); if (existingCoatingType != null) { logger.Debug("CoatingType is being updated."); try { _db.CoatingType.Attach(existingCoatingType); _db.Entry(existingCoatingType).CurrentValues.SetValues(coatingType); _db.SaveChanges(); operationResult.Success = true; operationResult.Message = "Success"; } catch (Exception ex) { operationResult.Success = false; operationResult.Message = "Error"; logger.ErrorFormat("Error while updating coating type: { 0} ", ex.ToString()); } } else { operationResult.Success = false; operationResult.Message = "Unable to find selected coating type."; } return(operationResult); }
/// <summary> /// save new coating type /// </summary> /// <param name="newCoatingType"></param> /// <returns></returns> public OperationResult SaveCoatingType(CoatingType newCoatingType) { var operationResult = new OperationResult(); try { var existingCoatingType = _db.CoatingType.FirstOrDefault(x => x.Description.ToLower() == newCoatingType.Description.ToLower()); if (existingCoatingType == null) { logger.Debug("CoatingType is being created..."); newCoatingType.IsActive = true; _db.CoatingType.Add(newCoatingType); _db.SaveChanges(); operationResult.Success = true; operationResult.Message = "Success"; } else { operationResult.Success = false; operationResult.Message = "Duplicate Entry"; } } catch (Exception ex) { operationResult.Success = false; operationResult.Message = "Error"; logger.ErrorFormat("Error saving new coating type: {0} ", ex.ToString()); } return(operationResult); }
public JsonResult Edit(RfqViewModel model) { var operationResult = new OperationResult(); var existingCoatingType = _coatingTypeRepository.GetCoatingType(model.CoatingType); if (existingCoatingType == null) { var newCoatingType = new CoatingType(); { newCoatingType.Description = model.CoatingType; newCoatingType.IsActive = true; } operationResult = _coatingTypeRepository.SaveCoatingType(newCoatingType); existingCoatingType = _coatingTypeRepository.GetCoatingType(model.CoatingType); } var existingSpecificationMaterial = _specificationMaterialRepository.GetSpecificationMaterial(model.SpecificationMaterialDescription.ToLower().Replace(" ", string.Empty)); if (existingSpecificationMaterial == null) { var newSpecificationMaterial = new SpecificationMaterial(); { newSpecificationMaterial.Description = model.SpecificationMaterialDescription; newSpecificationMaterial.IsActive = true; } operationResult = _specificationMaterialRepository.SaveSpecificationMaterial(newSpecificationMaterial); existingSpecificationMaterial = _specificationMaterialRepository.GetSpecificationMaterial(model.SpecificationMaterialDescription); } var rfqToUpdate = _rfqRepository.GetRfq(model.RfqId); rfqToUpdate = new RfqConverter().ConvertToDomain(model); var projectToUpdate = _projectRepository.GetProject(model.ProjectId); if (model.Status != null) { if (model.IsOpen) { projectToUpdate.IsOpen = true; } else { projectToUpdate.IsOpen = false; } if (model.IsHold) { projectToUpdate.IsHold = true; projectToUpdate.HoldExpirationDate = model.HoldExpirationDate; projectToUpdate.HoldNotes = model.HoldNotes; } else { projectToUpdate.IsHold = false; projectToUpdate.HoldExpirationDate = null; projectToUpdate.HoldNotes = null; } if (model.IsCanceled) { projectToUpdate.IsCanceled = true; projectToUpdate.CancelNotes = model.CancelNotes; } else { projectToUpdate.IsCanceled = false; projectToUpdate.CancelNotes = null; } } operationResult = _rfqRepository.UpdateRfq(rfqToUpdate); if (operationResult.Success) { model.Success = true; model.IsHold = rfqToUpdate.IsHold; model.IsCanceled = rfqToUpdate.IsCanceled; operationResult = _projectRepository.UpdateProject(projectToUpdate); if (model.RfqParts != null && model.RfqParts.Count() > 0) { foreach (var rfqPart in model.RfqParts) { if (rfqPart.ProjectPartId != Guid.Empty) { var partToUpdate = new ProjectPartConverter().ConvertToDomain(rfqPart); partToUpdate.RfqId = model.RfqId; partToUpdate.ProjectId = model.ProjectId; partToUpdate.MaterialSpecificationId = existingSpecificationMaterial.SpecificationMaterialId; partToUpdate.MaterialId = rfqPart.MaterialId; partToUpdate.CoatingTypeId = existingCoatingType.CoatingTypeId; operationResult = _projectPartRepository.UpdateProjectPart(partToUpdate); } else { var newProjectPart = new ProjectPartConverter().ConvertToDomain(rfqPart); newProjectPart.RfqId = model.RfqId; newProjectPart.ProjectId = model.ProjectId; newProjectPart.MaterialId = rfqPart.MaterialId; newProjectPart.MaterialSpecificationId = existingSpecificationMaterial.SpecificationMaterialId; newProjectPart.CoatingTypeId = existingCoatingType.CoatingTypeId; operationResult = _projectPartRepository.SaveProjectPart(newProjectPart); } } } var existingProjectParts = _projectPartRepository.GetProjectParts().Where(x => x.ProjectId == model.ProjectId).ToList(); if (existingProjectParts != null && existingProjectParts.Count > 0) { foreach (var existingProjectPart in existingProjectParts) { var projectPart = model.RfqParts.FirstOrDefault(x => x.PartNumber == existingProjectPart.Number); if (projectPart == null) { operationResult = _projectPartRepository.DeleteProjectPart(existingProjectPart.ProjectPartId); } } } if (!operationResult.Success) { model.Success = false; model.Message = operationResult.Message; } } else { model.Success = false; model.Message = operationResult.Message; } return(Json(model, JsonRequestBehavior.AllowGet)); }
public JsonResult Create(RfqViewModel model) { var operationResult = new OperationResult(); var existingCoatingType = _coatingTypeRepository.GetCoatingType(model.CoatingType); if (existingCoatingType == null) { var newCoatingType = new CoatingType(); { newCoatingType.Description = model.CoatingType; newCoatingType.IsActive = true; } operationResult = _coatingTypeRepository.SaveCoatingType(newCoatingType); existingCoatingType = _coatingTypeRepository.GetCoatingType(model.CoatingType); } var existingSpecificationMaterial = _specificationMaterialRepository.GetSpecificationMaterial(model.SpecificationMaterialDescription); if (existingSpecificationMaterial == null) { var newSpecificationMaterial = new SpecificationMaterial(); { newSpecificationMaterial.Description = model.SpecificationMaterialDescription; newSpecificationMaterial.IsActive = true; } operationResult = _specificationMaterialRepository.SaveSpecificationMaterial(newSpecificationMaterial); existingSpecificationMaterial = _specificationMaterialRepository.GetSpecificationMaterial(model.SpecificationMaterialDescription); } var project = _projectRepository.GetProject(model.ProjectName); if (project == null) { var newProject = new ProjectConverter().ConvertToCreate(model); operationResult = _projectRepository.SaveProject(newProject); model.ProjectId = operationResult.ReferenceId; } else { model.ProjectId = project.ProjectId; } var newRfq = new RfqConverter().ConvertToDomain(model); newRfq.ProjectId = model.ProjectId; operationResult = _rfqRepository.SaveRfq(newRfq); newRfq.RfqId = operationResult.ReferenceId; if (operationResult.Success && model != null) { foreach (var rfqPart in model.RfqParts) { var newProjectPart = new ProjectPartConverter().ConvertToDomain(rfqPart); newProjectPart.RfqId = operationResult.ReferenceId; newProjectPart.ProjectId = model.ProjectId; newProjectPart.MaterialId = rfqPart.MaterialId; newProjectPart.MaterialSpecificationId = existingSpecificationMaterial.SpecificationMaterialId; newProjectPart.CoatingTypeId = existingCoatingType.CoatingTypeId; operationResult = _projectPartRepository.SaveProjectPart(newProjectPart); } } operationResult.ReferenceId = newRfq.RfqId; return(Json(operationResult, JsonRequestBehavior.AllowGet)); }