public int Add(RawMaterialQCRedHoldDTO dto) { int returnID = -1; try { using (var context = new TPOMVCApplicationEntities()) { var newEntity = new TPO.DL.Models.RawMaterialQCRedHold(); newEntity.RawMaterialQCID = dto.RawMaterialQCID; newEntity.PlantID = dto.PlantID; newEntity.RawMaterialReceivedID = dto.RawMaterialReceivedID; newEntity.QCTechID = dto.QCTechID; newEntity.SupervisorID = dto.SupervisorID; newEntity.LeadOperatorID = dto.LeadOperatorID; newEntity.RedDate = dto.RedDate; newEntity.FailPropertyID = dto.FailPropertyID; newEntity.Zone = dto.Zone; newEntity.RedComments = dto.RedComments; newEntity.RedCorrectionAction = dto.RedCorrectionAction; newEntity.HoldDate = dto.HoldDate; newEntity.HoldLotNumber = dto.HoldLotNumber; newEntity.HoldComments = dto.HoldComments; newEntity.ManagerID = dto.ManagerID; newEntity.ManagerDate = dto.ManagerDate; newEntity.ManagerComments = dto.ManagerComments; newEntity.PrimeBoxCar = dto.PrimeBoxCar; newEntity.PrimeUOM = dto.PrimeUOM; newEntity.ReworkBoxCar = dto.ReworkBoxCar; newEntity.ReworkUOM = dto.ReworkUOM; newEntity.ScrapBoxCar = dto.ScrapBoxCar; newEntity.ScrapUOM = dto.ScrapUOM; newEntity.DateEntered = dto.DateEntered ?? DateTime.Now; newEntity.EnteredBy = dto.EnteredBy; newEntity.LastModified = dto.LastModified ?? DateTime.Now; newEntity.ModifiedBy = dto.ModifiedBy; context.RawMaterialQCRedHolds.Add(newEntity); context.SaveChanges(); //need to return the new record id //easy to do once we update to stored procs returnID = newEntity.ID; } } catch (DbEntityValidationException ex) { throw; } return(returnID); }
// GET: /RawMaterialQCRedHold/Edit/5 public ActionResult Edit(DateTime?holddate, DateTime?managerdate, DateTime?reddate, int?id) { RawMaterialQCRedHoldViewModel model = new Models.RawMaterialQCRedHoldViewModel(); try { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //RawMaterialQCRedHold rawmaterialqcredhold = db.RawMaterialQCRedHolds.Find(id); //Sloppy error handling, have to fix the null ID variable. RawMaterialQCRedHoldDTO dto = RawMaterialQCRedHoldRepo.GetByID(id ?? -1); if (dto == null) { return(HttpNotFound()); } else { model = MapRawMaterialQCRedHoldDTOtoViewModel(dto); //TODO: Rewrite after QC object has been refactored. GetQcFormDetail(ref model); model.ManagerDate = managerdate; model.HoldDate = holddate; model.RedDate = reddate; PrepareSelectLists(); ViewBag.RawMaterialReceivedID = new SelectList(db.RawMaterialReceiveds, "ID", "RawMaterialID"); } } catch (Exception ex) { ViewBag.ExceptionMessage = ex.Message; TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageFailNoRecord); TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeError); return(View(model)); } return(View(model)); }
public void Update(RawMaterialQCRedHoldDTO dto) { try { using (var context = new TPOMVCApplicationEntities()) { var toUpdate = context.RawMaterialQCRedHolds.Find(dto.ID); toUpdate.RawMaterialQCID = dto.RawMaterialQCID; toUpdate.PlantID = dto.PlantID; toUpdate.RawMaterialReceivedID = dto.RawMaterialReceivedID; toUpdate.QCTechID = dto.QCTechID; toUpdate.SupervisorID = dto.SupervisorID; toUpdate.LeadOperatorID = dto.LeadOperatorID; toUpdate.RedDate = dto.RedDate; toUpdate.FailPropertyID = dto.FailPropertyID; toUpdate.Zone = dto.Zone; toUpdate.RedComments = dto.RedComments; toUpdate.RedCorrectionAction = dto.RedCorrectionAction; toUpdate.HoldDate = dto.HoldDate; toUpdate.HoldLotNumber = dto.HoldLotNumber; toUpdate.HoldComments = dto.HoldComments; toUpdate.ManagerID = dto.ManagerID; toUpdate.ManagerDate = dto.ManagerDate; toUpdate.ManagerComments = dto.ManagerComments; toUpdate.PrimeBoxCar = dto.PrimeBoxCar; toUpdate.PrimeUOM = dto.PrimeUOM; toUpdate.ReworkBoxCar = dto.ReworkBoxCar; toUpdate.ReworkUOM = dto.ReworkUOM; toUpdate.ScrapBoxCar = dto.ScrapBoxCar; toUpdate.ScrapUOM = dto.ScrapUOM; toUpdate.DateEntered = dto.DateEntered ?? DateTime.Now; toUpdate.EnteredBy = dto.EnteredBy; toUpdate.LastModified = dto.LastModified ?? DateTime.Now; toUpdate.ModifiedBy = dto.ModifiedBy; context.Entry(toUpdate).State = EntityState.Modified; context.SaveChanges(); } } catch (Exception ex) { throw; } }
// GET: /RawMaterialQCRedHold/Create/QCID public ActionResult Create(DateTime?holddate, DateTime?managerdate, DateTime?reddate, int?id) { TPOWeb.Models.RawMaterialQCRedHoldViewModel model = new Models.RawMaterialQCRedHoldViewModel(); if (id == null) { TempData["ActionMessage"] = MessageRepository.GetStringValue(MessageKeys.ResponseMessageFailNoId); TempData["ActionMessageType"] = MessageRepository.GetStringValue(MessageKeys.ResponseTypeError); return(RedirectToAction("Index", "RawMaterialQC")); //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } else { //Sloppy error handling, have to fix the null ID variable. RawMaterialQCRedHoldDTO lookupObjByQCId = RawMaterialQCRedHoldRepo.GetByQCID(id ?? -1); //test to see if record already exists, if it does, switch to edit view if (lookupObjByQCId != null && lookupObjByQCId.ID >= 0) { return(RedirectToAction("Edit", "RawMaterialQCRedHold", new { ID = lookupObjByQCId.ID })); } //TODO: Rewrite after QC object has been refactored. TPO.DL.Models.RawMaterialQC qcLookupObj = db.RawMaterialQCs.Find(id); model.RawMaterialQCId = qcLookupObj.ID; model.QCTechId = qcLookupObj.QCTechUserID; model.PlantId = qcLookupObj.PlantID; model.BoxCarTested = qcLookupObj.BoxCarTested; model.RawMaterialReceived = qcLookupObj.RawMaterialReceived.RawMaterial.Code; model.LotNumber = qcLookupObj.RawMaterialReceived.LotNumber; model.RawMaterialReceivedId = qcLookupObj.RawMaterialReceivedID; model.ManagerDate = managerdate; model.HoldDate = holddate; model.RedDate = reddate; PrepareSelectLists(); ViewBag.RawMaterialReceivedID = new SelectList(db.RawMaterialReceiveds, "ID", "RawMaterialID"); } return(View(model)); }
public static RawMaterialQCRedHoldDTO MapToDTO(TPO.DL.Models.RawMaterialQCRedHold dbo) { RawMaterialQCRedHoldDTO dto = new RawMaterialQCRedHoldDTO { ID = dbo.ID, RawMaterialQCID = dbo.RawMaterialQCID ?? -1, PlantID = dbo.PlantID, RawMaterialReceivedID = dbo.RawMaterialReceivedID, QCTechID = dbo.QCTechID, SupervisorID = dbo.SupervisorID, LeadOperatorID = dbo.LeadOperatorID, RedDate = dbo.RedDate, FailPropertyID = dbo.FailPropertyID, Zone = dbo.Zone, RedComments = dbo.RedComments, RedCorrectionAction = dbo.RedCorrectionAction, HoldDate = dbo.HoldDate, HoldLotNumber = dbo.HoldLotNumber, HoldComments = dbo.HoldComments, ManagerID = dbo.ManagerID, ManagerDate = dbo.ManagerDate, ManagerComments = dbo.ManagerComments, PrimeBoxCar = (float)dbo.PrimeBoxCar, PrimeUOM = (float)dbo.PrimeUOM, ReworkBoxCar = (float)dbo.ReworkBoxCar, ReworkUOM = (float)dbo.ReworkUOM, ScrapBoxCar = (float)dbo.ScrapBoxCar, ScrapUOM = (float)dbo.ScrapUOM, DateEntered = dbo.DateEntered, EnteredBy = dbo.EnteredBy, LastModified = dbo.LastModified, ModifiedBy = dbo.ModifiedBy }; return(dto); }
private RawMaterialQCRedHoldDTO MapRawMaterialQCRedHoldViewModeltoDTO(RawMaterialQCRedHoldViewModel vm) { var dto = new RawMaterialQCRedHoldDTO { ID = vm.Id, RawMaterialQCID = vm.RawMaterialQCId, PlantID = vm.PlantId, RawMaterialReceivedID = vm.RawMaterialReceivedId, QCTechID = vm.QCTechId, SupervisorID = vm.SupervisorId, LeadOperatorID = vm.LeadOperatorId, RedDate = vm.RedDate, FailPropertyID = vm.FailPropertyId, Zone = vm.Zone, RedComments = vm.RedComments, RedCorrectionAction = vm.RedCorrectionAction, HoldDate = vm.HoldDate, HoldLotNumber = vm.HoldLotNumber, HoldComments = vm.HoldComments, ManagerID = vm.ManagerID, ManagerDate = vm.ManagerDate, ManagerComments = vm.ManagerComments, PrimeBoxCar = vm.PrimeBoxCar, PrimeUOM = vm.PrimeUOM, ReworkBoxCar = vm.ReworkBoxCar, ReworkUOM = vm.ReworkUOM, ScrapBoxCar = vm.ScrapBoxCar, ScrapUOM = vm.ScrapUOM, DateEntered = vm.DateEntered, EnteredBy = vm.EnteredBy, LastModified = vm.LastModified, ModifiedBy = vm.ModifiedBy }; return(dto); }
private RawMaterialQCRedHoldViewModel MapRawMaterialQCRedHoldDTOtoViewModel(RawMaterialQCRedHoldDTO dto) { var vm = new RawMaterialQCRedHoldViewModel { Id = dto.ID, RawMaterialQCId = dto.RawMaterialQCID, PlantId = dto.PlantID, RawMaterialReceivedId = dto.RawMaterialReceivedID, QCTechId = dto.QCTechID, SupervisorId = dto.SupervisorID, LeadOperatorId = dto.LeadOperatorID, RedDate = dto.RedDate, FailPropertyId = dto.FailPropertyID, Zone = dto.Zone, RedComments = dto.RedComments, RedCorrectionAction = dto.RedCorrectionAction, HoldDate = dto.HoldDate, HoldLotNumber = dto.HoldLotNumber, HoldComments = dto.HoldComments, ManagerID = dto.ManagerID, ManagerDate = dto.ManagerDate, ManagerComments = dto.ManagerComments, PrimeBoxCar = dto.PrimeBoxCar, PrimeUOM = dto.PrimeUOM, ReworkBoxCar = dto.ReworkBoxCar, ReworkUOM = dto.ReworkUOM, ScrapBoxCar = dto.ScrapBoxCar, ScrapUOM = dto.ScrapUOM, DateEntered = dto.DateEntered, EnteredBy = dto.EnteredBy, LastModified = dto.LastModified, ModifiedBy = dto.ModifiedBy }; return(vm); }