private async Task LinkMedicationsToClinicalEvent(Patient patientFromRepo, DateTime?onsetDate, Guid patientClinicalEventGuid)
{
var weeks = await GetNumberOfWeeksToCheckAsync();
// Prepare medications
List <ReportInstanceMedicationListItem> medications = new List <ReportInstanceMedicationListItem>();
foreach (var med in patientFromRepo.PatientMedications.Where(m => m.Archived == false &&
(m.EndDate == null && m.StartDate.AddDays(weeks * -7) <= onsetDate) ||
(m.EndDate != null && m.StartDate.AddDays(weeks * -7) <= onsetDate && Convert.ToDateTime(m.EndDate).AddDays(weeks * 7) >= onsetDate))
.OrderBy(m => m.Concept.ConceptName))
{
var item = new ReportInstanceMedicationListItem()
{
MedicationIdentifier = med.DisplayName,
ReportInstanceMedicationGuid = med.PatientMedicationGuid
};
medications.Add(item);
}
await _workFlowService.AddOrUpdateMedicationsForWorkFlowInstanceAsync(patientClinicalEventGuid, medications);
}
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));
}
