public ActionResult AddSpontaneous(DatasetInstanceModel model) { DatasetInstance datasetInstance = null; var datasetInstanceRepository = _unitOfWork.Repository <DatasetInstance>(); datasetInstance = datasetInstanceRepository .Queryable() .Include(di => di.Dataset) .Include("DatasetInstanceValues.DatasetInstanceSubValues.DatasetElementSub") .Include("DatasetInstanceValues.DatasetElement") .SingleOrDefault(di => di.Id == model.DatasetInstanceId); if (ModelState.IsValid) { if (datasetInstance == null) { ViewBag.Entity = "DatasetInstance"; return(View("NotFound")); } datasetInstance.Status = DatasetInstanceStatus.COMPLETE; var datasetElementIds = model.DatasetCategories.SelectMany(dc => dc.DatasetElements.Select(dse => dse.DatasetElementId)).ToArray(); var datasetElements = _unitOfWork.Repository <DatasetElement>() .Queryable() .Where(de => datasetElementIds.Contains(de.Id)) .ToDictionary(e => e.Id); var datasetElementSubs = datasetElements .SelectMany(de => de.Value.DatasetElementSubs) .ToDictionary(des => des.Id); try { for (int i = 0; i < model.DatasetCategories.Length; i++) { for (int j = 0; j < model.DatasetCategories[i].DatasetElements.Length; j++) { try { if (model.DatasetCategories[i].DatasetElements[j].DatasetElementType != "Table") { datasetInstance.SetInstanceValue(datasetElements[model.DatasetCategories[i].DatasetElements[j].DatasetElementId], model.DatasetCategories[i].DatasetElements[j].DatasetElementValue); } } catch (DatasetFieldSetException ex) { // Need to rename the key in order for the message to be bound to the correct control. throw new DatasetFieldSetException(string.Format("DatasetCategories[{0}].DatasetElements[{1}].DatasetElementValue", i, j), ex.Message); } } } datasetInstanceRepository.Update(datasetInstance); // Instantiate new instance of work flow var patientIdentifier = datasetInstance.GetInstanceValue(_unitOfWork.Repository <DatasetElement>().Queryable().SingleOrDefault(u => u.ElementName == "Identification Number")); if (String.IsNullOrWhiteSpace(patientIdentifier)) { patientIdentifier = datasetInstance.GetInstanceValue(_unitOfWork.Repository <DatasetElement>().Queryable().SingleOrDefault(u => u.ElementName == "Initials")); } var sourceIdentifier = datasetInstance.GetInstanceValue(_unitOfWork.Repository <DatasetElement>().Queryable().SingleOrDefault(u => u.ElementName == "Description of reaction")); _workflowService.CreateWorkFlowInstance("New Spontaneous Surveilliance Report", datasetInstance.DatasetInstanceGuid, patientIdentifier, sourceIdentifier); // Prepare medications List <ReportInstanceMedicationListItem> medications = new List <ReportInstanceMedicationListItem>(); var sourceProductElement = _unitOfWork.Repository <DatasetElement>().Queryable().SingleOrDefault(u => u.ElementName == "Product Information"); var destinationProductElement = _unitOfWork.Repository <DatasetElement>().Queryable().SingleOrDefault(u => u.ElementName == "Medicinal Products"); var sourceContexts = datasetInstance.GetInstanceSubValuesContext(sourceProductElement); foreach (Guid sourceContext in sourceContexts) { var drugItemValues = datasetInstance.GetInstanceSubValues(sourceProductElement, sourceContext); var drugName = drugItemValues.SingleOrDefault(div => div.DatasetElementSub.ElementName == "Product").InstanceValue; if (drugName != string.Empty) { var item = new ReportInstanceMedicationListItem() { MedicationIdentifier = drugName, ReportInstanceMedicationGuid = sourceContext }; medications.Add(item); } } _workflowService.AddOrUpdateMedicationsForWorkFlowInstance(datasetInstance.DatasetInstanceGuid, medications); _unitOfWork.Complete(); return(RedirectToAction("FormAdded", "Public")); } catch (DatasetFieldSetException dse) { ModelState.AddModelError(dse.Key, dse.Message); } } bool[] validCat; bool[] validMan; var rule = datasetInstance.Dataset.GetRule(DatasetRuleType.MandatoryFieldsProminent); if (rule.RuleActive) { validCat = new[] { true, false }; validMan = new[] { true, false }; } else { validCat = new[] { false }; validMan = new[] { true, false }; } var groupedDatasetCategoryElements = datasetInstance.Dataset.DatasetCategories.Where(dc => validCat.Contains(dc.System)).OrderBy(dc => dc.CategoryOrder) .SelectMany(dc => dc.DatasetCategoryElements).Where(dce => (rule.RuleActive && (dce.DatasetCategory.System == true && dce.DatasetElement.Field.Mandatory == true) || (dce.DatasetCategory.System == false && dce.DatasetElement.Field.Mandatory == false)) || (!rule.RuleActive && validMan.Contains(dce.DatasetElement.Field.Mandatory))).OrderBy(dce => dce.FieldOrder) .GroupBy(dce => dce.DatasetCategory) .ToList(); model.DatasetCategories = groupedDatasetCategoryElements .Select(dsc => new DatasetCategoryEditModel { DatasetCategoryId = dsc.Key.Id, DatasetCategoryDisplayName = String.IsNullOrWhiteSpace(dsc.Key.FriendlyName) ? dsc.Key.DatasetCategoryName : dsc.Key.FriendlyName, DatasetCategoryHelp = dsc.Key.Help, DatasetElements = dsc.Select(e => new DatasetElementEditModel { DatasetElementId = e.DatasetElement.Id, DatasetElementName = e.DatasetElement.ElementName, DatasetElementDisplayName = String.IsNullOrWhiteSpace(e.FriendlyName) ? e.DatasetElement.ElementName : e.FriendlyName, DatasetElementHelp = e.Help, DatasetElementRequired = e.DatasetElement.Field.Mandatory, DatasetElementDisplayed = true, DatasetElementChronic = false, DatasetElementType = e.DatasetElement.Field.FieldType.Description, DatasetElementValue = datasetInstance.GetInstanceValue(e.DatasetElement), DatasetElementSubs = e.DatasetElement.DatasetElementSubs.Select(es => new DatasetElementSubEditModel { DatasetElementSubId = es.Id, DatasetElementSubName = es.ElementName, DatasetElementSubRequired = es.Field.Mandatory, DatasetElementSubType = es.Field.FieldType.Description //, //DatasetElementSubValue = datasetInstance.GetInstanceSubValue(es) }).ToArray() }) .ToArray() }) .ToArray(); var selectTypeDatasetElements = model.DatasetCategories .SelectMany(dc => dc.DatasetElements) .Where(de => de.DatasetElementType == FieldTypes.Listbox.ToString() || de.DatasetElementType == FieldTypes.DropDownList.ToString()) .ToArray(); var yesNoDatasetElements = model.DatasetCategories .SelectMany(dc => dc.DatasetElements) .Where(de => de.DatasetElementType == FieldTypes.YesNo.ToString()) .ToArray(); var datasetElementRepository = _unitOfWork.Repository <DatasetElement>(); var datasetElementSubRepository = _unitOfWork.Repository <DatasetElementSub>(); foreach (var element in selectTypeDatasetElements) { var elementFieldValues = datasetElementRepository.Queryable() .SingleOrDefault(de => de.Id == element.DatasetElementId) .Field.FieldValues .ToList(); var elementFieldValueList = new List <SelectListItem> { { new SelectListItem { Value = "", Text = "" } } }; elementFieldValueList.AddRange(elementFieldValues.Select(ev => new SelectListItem { Value = ev.Value, Text = ev.Value, Selected = element.DatasetElementValue == ev.Value })); ViewData.Add(element.DatasetElementName, elementFieldValueList.ToArray()); } foreach (var element in yesNoDatasetElements) { var yesNo = new[] { new SelectListItem { Value = "", Text = "" }, new SelectListItem { Value = "No", Text = "No" }, new SelectListItem { Value = "Yes", Text = "Yes" } }; var selectedYesNo = yesNo.SingleOrDefault(yn => yn.Value == element.DatasetElementValue); if (selectedYesNo != null) { selectedYesNo.Selected = true; } ViewData.Add(element.DatasetElementName, yesNo); } return(View(model)); }