private IntermediateStandardCreateViewModel SetIntermediateStandard(IntermediateStandardCreateViewModel model) { var department = _uow.GetUserDepartment(); var units = _uow.UnitRepository.Get(); var devices = _uow.DeviceRepository.Get().Where(item => item.Department.DepartmentId == department.DepartmentId).ToList(); var items = _uow.InventoryItemRepository.Get() .Where(item => item.Department == department) .GroupBy(i => new { i.StockReagent, i.StockStandard, i.IntermediateStandard }) .Select(g => g.First()) .ToList(); model.WeightUnits = units.Where(item => item.UnitType.Equals("Weight")).ToList(); model.VolumetricUnits = units.Where(item => item.UnitType.Equals("Volume")).ToList(); model.OtherUnit = units.Where(item => item.UnitType.Equals("Other")).FirstOrDefault(); model.IntermediateStandards = items.Where(item => item.IntermediateStandard != null && item.Department == department).ToList(); model.StockStandards = items.Where(item => item.StockStandard != null && item.Department == department).ToList(); model.StockReagents = items.Where(item => item.StockReagent != null && item.Department == department).ToList(); model.Department = department; model.BalanceDevices = devices.Where(item => item.DeviceType.Equals("Balance") && item.Department == department && !item.IsArchived).ToList(); model.VolumetricDevices = devices.Where(item => item.DeviceType.Equals("Volumetric") && item.Department == department && !item.IsArchived).ToList(); return(model); }
// GET: /IntermediateStandard/Create public ActionResult Create() { var model = new IntermediateStandardCreateViewModel(); SetIntermediateStandard(model); return(View(model)); }
public ActionResult Create([Bind(Include = "IntermediateStandardId,IntermediateStandardName,TotalVolume,UsedFor,FinalConcentration,TotalAmount,ExpiryDate,SafetyNotes,IsExpiryDateBasedOnDays,DaysUntilExpired,OtherUnitExplained,ConcentrationOtherUnitExplained")] IntermediateStandardCreateViewModel 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()); SetIntermediateStandard(model); return(View(model)); } if (PrepListItemTypes == null || PrepListItemAmounts == null || PrepListItemLotNumbers == null) { ModelState.AddModelError("", "The creation of the Intermediate Standard failed. Make sure the Prep List table is complete."); SetIntermediateStandard(model); return(View(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 Intermediate Standard failed. Make sure the Prep List table is complete."); SetIntermediateStandard(model); return(View(model)); } //setting the devices used var devicesUsed = Request.Form["Devices"]; if (devicesUsed == null) { ModelState.AddModelError("", "You must select a device that was used."); SetIntermediateStandard(model); return(View(model)); } if (devicesUsed.Contains(",")) { model.DeviceOne = _uow.DeviceRepository.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[0])).FirstOrDefault(); model.DeviceTwo = _uow.DeviceRepository.Get().Where(item => item.DeviceCode.Equals(devicesUsed.Split(',')[1])).FirstOrDefault(); } else { model.DeviceOne = _uow.DeviceRepository.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 teh units to amount and concentration var user = _uow.GetCurrentUser(); var department = _uow.GetUserDepartment(); var numOfItems = _uow.InventoryItemRepository.Get().Count(); //retrieving all table rows from recipe builder - replace with view model in the future var prepListViewModel = new IntermediateStandardPrepListItemsViewModel() { AmountsWithUnits = PrepListItemAmounts }; prepListViewModel.LotNumbers = PrepListItemLotNumbers; prepListViewModel.Types = PrepListItemTypes; var reagentAndStandardContainer = new List <object>(); var 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 = _uow.InventoryItemRepository.Get().Where(x => x != null && 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; _uow.InventoryItemRepository.Update(invItem); prepItems.Add(new PrepListItem() { StockReagent = reagent, AmountTaken = prepListViewModel.AmountsWithUnits[counter] }); } else if (item is StockStandard) { var standard = item as StockStandard; var invItem = _uow.InventoryItemRepository.Get().Where(x => x != null && 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; _uow.InventoryItemRepository.Update(invItem); prepItems.Add(new PrepListItem() { StockStandard = standard, AmountTaken = prepListViewModel.AmountsWithUnits[counter] }); } else if (item is IntermediateStandard) { var intStandard = item as IntermediateStandard; var invItem = _uow.InventoryItemRepository.Get().Where(x => x.IntermediateStandard == intStandard).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; _uow.InventoryItemRepository.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 intermediate standard IntermediateStandard intermediatestandard = new IntermediateStandard() { TotalVolume = model.TotalAmount.ToString() + " " + model.TotalAmountUnits, FinalConcentration = model.FinalConcentration.ToString() + " " + model.FinalConcentrationUnits, FinalVolume = model.FinalVolume, IdCode = department.Location.LocationCode + "-" + (_uow.InventoryItemRepository.Get().Count() + 1) + "-" + user.Department.SubDepartment,// + "/",//append number of bottles? PrepList = model.PrepList, SafetyNotes = model.SafetyNotes, CreatedBy = user.UserName, DateCreated = DateTime.Today, ExpiryDate = model.ExpiryDate, DaysUntilExpired = model.DaysUntilExpired, IntermediateStandardName = model.IntermediateStandardName, Replaces = !string.IsNullOrEmpty(model.Replaces) ? model.Replaces : "N/A", ReplacedBy = !string.IsNullOrEmpty(model.ReplacedBy) ? model.ReplacedBy : "N/A" }; InventoryItem inventoryItem = new InventoryItem() { Department = department, IntermediateStandard = intermediatestandard, Type = "Intermediate 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 intermediate standard _uow.PrepListRepository.Create(prepList); intermediatestandard.InventoryItems.Add(inventoryItem); _uow.IntermediateStandardRepository.Create(intermediatestandard); var result = _uow.Commit(); switch (result) { case CheckModelState.Invalid: ModelState.AddModelError("", "The creation of " + intermediatestandard.IdCode + " failed. Please double check all inputs and try again."); SetIntermediateStandard(model); return(View(model)); case CheckModelState.DataError: ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists please contact your system administrator."); SetIntermediateStandard(model); return(View(model)); case CheckModelState.Error: ModelState.AddModelError("", "There was an error. Please try again."); SetIntermediateStandard(model); return(View(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."); SetIntermediateStandard(model); return(View(model)); } }