public ActionResult Edit([Bind(Include = "WorkingStandardId,WorkingStandardName,IdCode,MaxxamId,ExpiryDate")] WorkingStandardEditViewModel workingStandard) { if (ModelState.IsValid) { InventoryItemRepository inventoryRepo = _uow.InventoryItemRepository; var user = _uow.GetCurrentUser(); InventoryItem invItem = inventoryRepo.Get() .Where(item => item.WorkingStandard != null && item.WorkingStandard.WorkingStandardId == workingStandard.WorkingStandardId) .FirstOrDefault(); WorkingStandard updateStandard = invItem.WorkingStandard; updateStandard.IdCode = workingStandard.IdCode; updateStandard.WorkingStandardName = workingStandard.WorkingStandardName; updateStandard.LastModifiedBy = user.UserName; updateStandard.DateModified = DateTime.Today; updateStandard.ExpiryDate = workingStandard.ExpiryDate; _uow.WorkingStandardRepository.Update(updateStandard); //_uow.Commit(); return(RedirectToAction("Index")); } return(View(workingStandard)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkingStandard Workingstandard = _uow.WorkingStandardRepository.Get(id); if (Workingstandard == null) { return(HttpNotFound()); } WorkingStandardEditViewModel model = new WorkingStandardEditViewModel() { WorkingStandardId = Workingstandard.WorkingStandardId, IdCode = Workingstandard.IdCode, WorkingStandardName = Workingstandard.WorkingStandardName }; foreach (var item in Workingstandard.InventoryItems) { if (item.WorkingStandard.WorkingStandardId == model.WorkingStandardId) { model.ExpiryDate = item.WorkingStandard.ExpiryDate; } } return(View(model)); }
public ActionResult DeleteConfirmed(int id) { WorkingStandard Workingstandard = _uow.WorkingStandardRepository.Get(id); _uow.WorkingStandardRepository.Delete(id); _uow.Commit(); return(RedirectToAction("Index")); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } WorkingStandard Workingstandard = _uow.WorkingStandardRepository.Get(id); if (Workingstandard == null) { return(HttpNotFound()); } return(View(Workingstandard)); }
public ActionResult PerformAudit([Bind(Include = "IdCode,Type")] PerformAuditViewModel model) { if (!ModelState.IsValid) { return(View("Index")); } AuditViewModel auditViewModel; if (model.Type == "ws") { WorkingStandard workingStandard = _uow.WorkingStandardRepository.Get().Where(w => w.IdCode == model.IdCode).FirstOrDefault(); if (workingStandard == null) { ViewBag.ErrorMessage = "The compound you have searched for was not found."; return(View("Index")); } auditViewModel = new AuditViewModel { ChemType = "WorkingStandard", Id = workingStandard.WorkingStandardId, IdCode = workingStandard.IdCode }; auditViewModel.Parents = GetAllParents(workingStandard.PrepList.PrepListItems); } else if (model.Type == "is") { IntermediateStandard intermediatestandard = _uow.IntermediateStandardRepository.Get().Where(i => i.IdCode == model.IdCode).FirstOrDefault(); if (intermediatestandard == null) { ViewBag.ErrorMessage = "The compound you have searched for was not found."; return(View("Index")); } auditViewModel = new AuditViewModel { ChemType = "IntermediateStandard", Id = intermediatestandard.IntermediateStandardId, IdCode = intermediatestandard.IdCode }; auditViewModel.Parents = GetAllParents(intermediatestandard.PrepList.PrepListItems); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } return(View(auditViewModel)); }
public ActionResult Create([Bind(Include = "WorkingStandardId,WorkingStandardName,TotalVolume,UsedFor,FinalConcentration,TotalAmount,ExpiryDate,SafetyNotes,IsExpiryDateBasedOnDays,DaysUntilExpired,OtherUnitExplained,ConcentrationOtherUnitExplained")] WorkingStandardCreateViewModel model, string[] PrepListItemTypes, string[] PrepListAmountTakenUnits, string[] PrepListItemAmounts, string[] PrepListItemLotNumbers, string[] TotalAmountUnits, string[] FinalConcentrationUnits, string submit) { if (!ModelState.IsValid) { var errors = ModelState.Where(item => item.Value.Errors.Any()); return(View(SetWorkingStandard(model))); } if (PrepListItemTypes == null || PrepListItemAmounts == null || PrepListItemLotNumbers == null) { ModelState.AddModelError("", "The creation of the Working Standard failed. Make sure the Prep List table is complete."); return(View(SetWorkingStandard(model))); } //if all 3 arrays are not of equal length, return to view with an error message if (!(PrepListItemAmounts.Length == PrepListItemLotNumbers.Length) || !(PrepListItemLotNumbers.Length == PrepListItemTypes.Length)) { ModelState.AddModelError("", "The creation of the Working Standard failed. Make sure the Prep List table is complete."); return(View(SetWorkingStandard(model))); } //setting the devices used var devicesUsed = Request.Form["Devices"]; var deviceRepo = _uow.DeviceRepository; if (devicesUsed == null) { ModelState.AddModelError("", "You must select a device that was used."); return(View(SetWorkingStandard(model))); } if (devicesUsed.Contains(",")) { model.DeviceOne = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[0])).FirstOrDefault(); model.DeviceTwo = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[1])).FirstOrDefault(); } else { model.DeviceOne = deviceRepo.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[0])).FirstOrDefault(); } //finsihed setting the devices used //setting the units to amount and concentration model.TotalAmountUnits = TotalAmountUnits[0]; model.FinalConcentrationUnits = FinalConcentrationUnits[0]; if (TotalAmountUnits.Length > 1) { model.TotalAmountUnits += "/" + TotalAmountUnits[1]; } if (FinalConcentrationUnits.Length > 1) { model.FinalConcentrationUnits += "/" + FinalConcentrationUnits[1]; } //finished setting the units to amount and concentration var user = _uow.GetCurrentUser(); var invRepo = _uow.InventoryItemRepository; var numOfItems = invRepo.Get().Count(); //retrieving all table rows from recipe builder - replace with view model in the future WorkingStandardPrepListItemsViewModel prepListViewModel = new WorkingStandardPrepListItemsViewModel() { AmountsWithUnits = PrepListItemAmounts }; prepListViewModel.LotNumbers = PrepListItemLotNumbers; prepListViewModel.Types = PrepListItemTypes; List <object> reagentAndStandardContainer = new List <object>(); List <PrepListItem> prepItems = new List <PrepListItem>(); //go through all types and sort out what they are, instantiate, and build list of objects foreach (var lotNumber in prepListViewModel.LotNumbers) { foreach (var type in prepListViewModel.Types) { if (type.Equals("Reagent")) { var add = _uow.StockReagentRepository .Get() .Where(x => x.LotNumber.Equals(lotNumber)) .FirstOrDefault(); if (add != null) { reagentAndStandardContainer.Add(add); break; } } else if (type.Equals("Standard")) { var add = _uow.StockStandardRepository .Get() .Where(x => x.LotNumber.Equals(lotNumber)) .FirstOrDefault(); if (add != null) { reagentAndStandardContainer.Add(add); break; } } else if (type.Equals("Intermediate Standard")) { var add = _uow.IntermediateStandardRepository .Get() .Where(x => x.IdCode.Equals(lotNumber)) .FirstOrDefault(); if (add != null) { reagentAndStandardContainer.Add(add); break; } } } } //loop through all items used and list all items as "opened" if they're not already open //if the expiry date hasn't been set yet, set it with the "days until expired" property provided from the "Create" form //building the prep list with the desired prep list items int counter = 0; foreach (var item in reagentAndStandardContainer) { if (item is StockReagent) { var reagent = item as StockReagent; var invItem = invRepo.Get().Where(x => x.CatalogueCode != null && x.CatalogueCode.Equals(reagent.CatalogueCode)).First(); if (invItem.StockReagent.DateOpened == null) { invItem.StockReagent.DateOpened = DateTime.Today; } if (invItem.StockReagent.ExpiryDate == null) { invItem.StockReagent.ExpiryDate = DateTime.Today.AddDays(Convert.ToInt32(invItem.StockReagent.DaysUntilExpired)); } invItem.StockReagent.LastModifiedBy = user.UserName; invItem.StockReagent.DateModified = DateTime.Today; invRepo.Update(invItem); prepItems.Add(new PrepListItem() { StockReagent = reagent, AmountTaken = prepListViewModel.AmountsWithUnits[counter] }); } else if (item is StockStandard) { var standard = item as StockStandard; var invItem = invRepo.Get().Where(x => x.CatalogueCode != null && x.CatalogueCode.Equals(standard.CatalogueCode)).First(); if (invItem.StockStandard.DateOpened == null) { invItem.StockStandard.DateOpened = DateTime.Today; } if (invItem.StockStandard.ExpiryDate == null) { invItem.StockStandard.ExpiryDate = DateTime.Today.AddDays(Convert.ToInt32(invItem.StockStandard.DaysUntilExpired)); } invItem.StockStandard.LastModifiedBy = user.UserName; invItem.StockStandard.DateModified = DateTime.Today; invRepo.Update(invItem); prepItems.Add(new PrepListItem() { StockStandard = standard, AmountTaken = prepListViewModel.AmountsWithUnits[counter] }); } else if (item is IntermediateStandard) { var intStandard = item as IntermediateStandard; var invItem = intStandard.InventoryItems.First(); if (invItem.IntermediateStandard.DateOpened == null) { invItem.IntermediateStandard.DateOpened = DateTime.Today; } if (invItem.IntermediateStandard.ExpiryDate == null) { invItem.IntermediateStandard.ExpiryDate = DateTime.Today.AddDays(Convert.ToInt32(invItem.IntermediateStandard.DaysUntilExpired)); } invItem.IntermediateStandard.LastModifiedBy = user.UserName; invItem.IntermediateStandard.DateModified = DateTime.Today; invRepo.Update(invItem); prepItems.Add(new PrepListItem() { IntermediateStandard = intStandard, AmountTaken = prepListViewModel.AmountsWithUnits[counter] }); } _uow.Commit(); counter++; } PrepList prepList = new PrepList() { PrepListItems = prepItems }; model.PrepList = prepList; //building the Working standard WorkingStandard Workingstandard = new WorkingStandard() { TotalVolume = model.TotalAmount.ToString() + " " + model.TotalAmountUnits, FinalConcentration = model.FinalConcentration.ToString() + " " + model.FinalConcentrationUnits, IdCode = user.Department.Location.LocationCode + "-" + (invRepo.Get().Count() + 1),// + "-" + model.MaxxamId,// + "/",//append number of bottles? PrepList = model.PrepList, SafetyNotes = model.SafetyNotes, CreatedBy = user.UserName, DateCreated = DateTime.Today, ExpiryDate = model.ExpiryDate, WorkingStandardName = model.WorkingStandardName, DaysUntilExpired = model.DaysUntilExpired }; InventoryItem inventoryItem = new InventoryItem() { Department = user.Department, WorkingStandard = Workingstandard, Type = "Working Standard", StorageRequirements = model.StorageRequirements, UsedFor = model.UsedFor, FirstDeviceUsed = model.DeviceOne, SecondDeviceUsed = model.DeviceTwo, OtherUnitExplained = model.OtherUnitExplained, SupplierName = "Maxxam", ConcentrationOtherUnitExplained = model.ConcentrationOtherUnitExplained, InitialAmount = model.TotalAmount.ToString() + " " + model.TotalAmountUnits }; //creating the prep list and the Working standard _uow.PrepListRepository.Create(prepList); Workingstandard.InventoryItems.Add(inventoryItem); _uow.WorkingStandardRepository.Create(Workingstandard); var result = _uow.Commit(); switch (result) { case CheckModelState.Invalid: ModelState.AddModelError("", "The creation of " + Workingstandard.IdCode + " failed. Please double check all inputs and try again."); return(View(SetWorkingStandard(model))); case CheckModelState.DataError: ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists please contact your system administrator."); return(View(SetWorkingStandard(model))); case CheckModelState.Error: ModelState.AddModelError("", "There was an error. Please try again."); return(View(SetWorkingStandard(model))); case CheckModelState.Valid: if (!string.IsNullOrEmpty(submit) && submit.Equals("Save")) { //save pressed return(RedirectToAction("Index")); } else { //save & new pressed return(RedirectToAction("Create")); } default: ModelState.AddModelError("", "An unknown error occurred."); return(View(SetWorkingStandard(model))); } }