public async Task <IHttpActionResult> PostUserDerivedNote(tUserDerivedNote tUserDerivedNote) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tUserDerivedNotes.Add(tUserDerivedNote); await db.SaveChangesAsync(); return(Ok(tUserDerivedNote)); }
public async Task <IHttpActionResult> SoftDeletetDerivedNote(int id, int status) { tUserDerivedNote tDerivedNote = await db.tUserDerivedNotes.FindAsync(id); if (tDerivedNote == null) { return(NotFound()); } tDerivedNote.SystemStatusID = status; await db.SaveChangesAsync(); return(Ok(tDerivedNote)); }
public async Task <IHttpActionResult> DeletetUserDerivedNote(int id) { tUserDerivedNote tUserDerivedNote = await db.tUserDerivedNotes.FindAsync(id); if (tUserDerivedNote == null) { return(NotFound()); } db.tUserDerivedNotes.Remove(tUserDerivedNote); await db.SaveChangesAsync(); return(Ok(tUserDerivedNote)); }
public async Task <IHttpActionResult> GetUserDataWithNotes(int categoryid, string category) { Models.UserData.UserDataWithNote _retval = new Models.UserData.UserDataWithNote(); tUserDerivedNote _tUserDerivedNote = null; switch (category) { case "Allergies": #region Allergies tUserAllergy _userAllergy = await db.tUserAllergies.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userAllergy.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userAllergy.ID, EndDateTime = _userAllergy.EndDateTime, StartDateTime = _userAllergy.StartDateTime, AllergenID = _userAllergy.AllergenID, ReactionID = _userAllergy.ReactionID, SeverityID = _userAllergy.SeverityID, StatusID = _userAllergy.StatusID, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Care Plans": #region Care Plans tUserCarePlan _userCarePlan = await db.tUserCarePlans.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userCarePlan.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userCarePlan.ID, EndDateTime = _userCarePlan.EndDateTime, StartDateTime = _userCarePlan.StartDateTime, CarePlanTypeID = _userCarePlan.TypeID, CarePlanSpecialtyID = _userCarePlan.SpecialtyID, CarePlanName = _userCarePlan.Name, CarePlanText = _userCarePlan.Text, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Encounters": #region Encounters tUserEncounter _userEncounters = await db.tUserEncounters.FindAsync(categoryid); tUserInstruction _FollowUpIns = await db.tUserInstructions.FindAsync(_userEncounters.FollowUpInstructionID); tUserInstruction _PatientIns = await db.tUserInstructions.FindAsync(_userEncounters.PatientInstructionID); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userEncounters.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userEncounters.ID, EncounterDateTime = _userEncounters.EncounterDateTime, ProviderID = _userEncounters.ProviderID, VisitTypeID = _userEncounters.VisitTypeID, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty, FollowUpInstruction = _FollowUpIns, PatientInstruction = _PatientIns }; #endregion break; case "Functional Statuses": #region Functional Statuses tUserFunctionalStatus _userFunctionalStatus = await db.tUserFunctionalStatuses.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userFunctionalStatus.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userFunctionalStatus.ID, EndDateTime = _userFunctionalStatus.EndDateTime, StartDateTime = _userFunctionalStatus.StartDateTime, Name = _userFunctionalStatus.Name, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Immunizations": #region Immunizations tUserImmunization _userImmunization = await db.tUserImmunizations.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userImmunization.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userImmunization.ID, Name = _userImmunization.Name, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Instructions": #region Instruction tUserInstruction _userInstruction = await db.tUserInstructions.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userInstruction.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userInstruction.ID, Name = _userInstruction.Name, Text = _userInstruction.Text, StartDateTime = _userInstruction.StartDateTime, EndDateTime = _userInstruction.EndDateTime, InstructionTypeID = _userInstruction.InstructionTypeID, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Narratives": #region Narratives tUserNarrative _userNarrative = await db.tUserNarratives.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userNarrative.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userNarrative.ID, ProviderID = _userNarrative.ProviderID, StartDateTime = _userNarrative.StartDateTime, EndDateTime = _userNarrative.EndDateTime, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Prescriptions": #region Prescriptions tUserPrescription _userPrescription = await db.tUserPrescriptions.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userPrescription.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, ParentId = _userPrescription.ID, ProviderID = _userPrescription.ProviderID, MedFormID = _userPrescription.MedFormID, FrequencyUOMID = _userPrescription.FrequencyUOMID, StrengthUOMID = _userPrescription.StrengthUOMID, RouteID = _userPrescription.RouteID, PharmacyID = _userPrescription.PharmacyID, Name = _userPrescription.Name, Instructions = _userPrescription.Instructions, ProductName = _userPrescription.ProductName, BrandName = _userPrescription.BrandName, DosageText = _userPrescription.DosageText, DosageValue = _userPrescription.DosageValue, FrequencyValue = _userPrescription.FrequencyValue, StrengthValue = _userPrescription.StrengthValue, RefillsRemaining = _userPrescription.RefillsRemaining, RefillsTotal = _userPrescription.RefillsTotal, ExpirationDateTime = _userPrescription.ExpirationDateTime, StartDateTime = _userPrescription.StartDateTime, EndDateTime = _userPrescription.EndDateTime, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Problems": #region Problems tUserProblem _userProblem = await db.tUserProblems.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userProblem.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, Name = _userProblem.Name, ParentId = _userProblem.ID, StartDateTime = _userProblem.StartDateTime, EndDateTime = _userProblem.EndDateTime, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Procedures": #region Procedures tUserProcedure _userProcedure = await db.tUserProcedures.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userProcedure.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, Name = _userProcedure.Name, ParentId = _userProcedure.ID, PerformingOrganizationID = _userProcedure.PerformingOrganizationID, DeviceID = _userProcedure.DeviceID, SpecimenID = _userProcedure.SpecimenID, StartDateTime = _userProcedure.StartDateTime, EndDateTime = _userProcedure.EndDateTime, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Test Results": #region Test Results tUserTestResult _userTestResult = await db.tUserTestResults.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userTestResult.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, Name = _userTestResult.Name, Comments = _userTestResult.Comments, Narrative = _userTestResult.Narrative, Impression = _userTestResult.Impression, Transcriptions = _userTestResult.Transcriptions, ParentId = _userTestResult.ID, ProviderID = _userTestResult.OrderingProviderID, StatusID = _userTestResult.StatusID, ResultDateTime = _userTestResult.ResultDateTime, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; case "Vitals": #region Test Results tUserVital _userVital = await db.tUserVitals.FindAsync(categoryid); _tUserDerivedNote = db.tUserDerivedNotes.FirstOrDefault(a => a.fkObjectID == _userVital.ObjectID); _retval = new Models.UserData.UserDataWithNote() { ID = _tUserDerivedNote != null ? _tUserDerivedNote.ID : -1, Name = _userVital.Name, Value = _userVital.Value, ParentId = _userVital.ID, ProviderID = _userVital.ProviderID, UOMID = _userVital.UOMID, ResultDateTime = _userVital.ResultDateTime, Note = _tUserDerivedNote != null ? _tUserDerivedNote.Note : string.Empty }; #endregion break; default: break; } return(Ok(_retval)); }
public List <Models.UserData.UserDataWithNote> GetUserDataByCategoryWithNotes(int userId, string category) { // System status Id == 1 - Valid Entry List <Models.UserData.UserDataWithNote> retVal = new List <Models.UserData.UserDataWithNote>(); switch (category) { case "Allergies": #region Allergies List <tUserAllergy> allUserAllergies = db.tUserAllergies .Include("tAllergen") .Include("tReaction") .Include("tAllergySeverity") .Include("tAllergyStatus") .Include("tUserSourceService.tSourceService") .Include("tSourceOrganization.tOrganization") .Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserAllergy item in allUserAllergies) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, Allergen = item.tAllergen.Name, Reaction = item.tReaction != null ? item.tReaction.Name : string.Empty, Severity = item.tAllergySeverity != null ? item.tAllergySeverity.Severity : string.Empty, Status = item.tAllergyStatus.Status, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Care Plans": #region Care Plans List <tUserCarePlan> allUserCarePlans = db.tUserCarePlans.Include("tUserCarePlanSpecialty").Include("tUserCarePlanType").Include("tUserSourceService.tSourceService").Include("tSourceOrganization.tOrganization").Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserCarePlan item in allUserCarePlans) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, CarePlanSpecialtyName = item.tUserCarePlanSpecialty != null ? item.tUserCarePlanSpecialty.Name : "", CarePlanTypeName = item.tUserCarePlanType != null ? item.tUserCarePlanType.Name : "", CarePlanText = item.Text, CarePlanName = item.Name, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Encounters": #region Encounters List <tUserEncounter> allUserEncounter = db.tUserEncounters.Include("tProvider").Include("tVisitType").Include("tUserSourceService.tSourceService").Include("tSourceOrganization.tOrganization").Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserEncounter item in allUserEncounter) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, EncounterDateTime = item.EncounterDateTime, ProviderName = item.ProviderID != null ? item.tProvider.Name : "", VisitTypeName = item.VisitTypeID != null ? item.tVisitType.Name : "", Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Functional Statuses": #region Functional Statuses List <tUserFunctionalStatus> allUserFunctionalStatus = db.tUserFunctionalStatuses.Include("tUserSourceService.tSourceService").Include("tSourceOrganization.tOrganization").Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserFunctionalStatus item in allUserFunctionalStatus) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, Name = item.Name, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Immunizations": #region Immunizations List <tUserImmunization> allUserImmunization = db.tUserImmunizations.Include("tUserSourceService.tSourceService").Include("tSourceOrganization.tOrganization").Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserImmunization item in allUserImmunization) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, Name = item.Name, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Instructions": #region Instructions List <tUserInstruction> allUserInstructions = db.tUserInstructions.Include("tInstructionType").Include("tUserSourceService.tSourceService").Include("tSourceOrganization.tOrganization").Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserInstruction item in allUserInstructions) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, Name = item.Name, Text = item.Text, InstructionTypeName = item.InstructionTypeID != null ? item.tInstructionType.Name : "", StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Narratives": #region Narratives List <tUserNarrative> allUserNarratives = db.tUserNarratives.Include("tProvider").Include("tUserSourceService.tSourceService").Include("tSourceOrganization.tOrganization").Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserNarrative item in allUserNarratives) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, ProviderName = item.tProvider != null ? item.tProvider.Name : string.Empty, StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Prescriptions": #region Prescriptions List <tUserPrescription> allUserPrescriptions = db.tUserPrescriptions.Include("tProvider") .Include("tUserSourceService.tSourceService") .Include("tMedicationForm") .Include("tUnitsOfMeasure") .Include("tUnitsOfMeasure1") .Include("tMedicationRoute") .Include("tPharmacy") .Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserPrescription item in allUserPrescriptions) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, ProviderName = item.tProvider != null ? item.tProvider.Name : string.Empty, MedFormName = item.tMedicationForm != null ? item.tMedicationForm.ShortName : string.Empty, FrequencyUOMName = item.tUnitsOfMeasure != null ? item.tUnitsOfMeasure.UnitOfMeasure : string.Empty, StrengthUOMName = item.tUnitsOfMeasure1 != null ? item.tUnitsOfMeasure1.UnitOfMeasure : string.Empty, RouteName = item.tMedicationRoute != null ? item.tMedicationRoute.ShortName : string.Empty, PharmacyName = item.tPharmacy != null ? item.tPharmacy.Name : string.Empty, Name = item.Name, Instructions = item.Instructions, ProductName = item.ProductName, BrandName = item.BrandName, DosageText = item.DosageText, DosageValue = item.DosageValue, FrequencyValue = item.FrequencyValue, StrengthValue = item.StrengthValue, RefillsRemaining = item.RefillsRemaining, RefillsTotal = item.RefillsTotal, ExpirationDateTime = item.ExpirationDateTime, StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Problems": #region Problems List <tUserProblem> allUserProblems = db.tUserProblems.Include("tUserSourceService.tSourceService").Include("tSourceOrganization.tOrganization").Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserProblem item in allUserProblems) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, Name = item.Name, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Procedures": #region Procedures List <tUserProcedure> allUserProcedures = db.tUserProcedures .Include("tUserSourceService.tSourceService") .Include("tSourceOrganization.tOrganization") .Include("tSourceOrganization1.tOrganization") .Include("tUserProcedureDevice") .Include("tUserSpecimen") .Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserProcedure item in allUserProcedures) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, StartDateTime = item.StartDateTime, EndDateTime = item.EndDateTime, Name = item.Name, PerformingOrganizationName = item.PerformingOrganizationID != null ? item.tSourceOrganization1.tOrganization.Name : "", DeviceName = item.DeviceID != null ? item.tUserProcedureDevice.Name : "", SpecimenName = item.SpecimenID != null ? item.tUserSpecimen.Specimen : "", Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Test Results": #region Test Results List <tUserTestResult> allUserTestResult = db.tUserTestResults .Include("tUserSourceService.tSourceService") .Include("tSourceOrganization.tOrganization") .Include("tProvider") .Include("tTestResultStatus") .Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserTestResult item in allUserTestResult) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, ResultDateTime = item.ResultDateTime, Name = item.Name, Comments = item.Comments, Narrative = item.Narrative, Impression = item.Impression, Transcriptions = item.Transcriptions, ProviderName = item.OrderingProviderID != null ? item.tProvider.Name : "", Status = item.StatusID != null ? item.tTestResultStatus.Status : "", Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; case "Vitals": #region Vitals List <tUserVital> allUserVitals = db.tUserVitals .Include("tUserSourceService.tSourceService") .Include("tSourceOrganization.tOrganization") .Include("tProvider") .Include("tUnitsOfMeasure") .Where(a => a.UserID == userId && a.SystemStatusID == 1).ToList(); foreach (tUserVital item in allUserVitals) { tUserDerivedNote _userNote = db.tUserDerivedNotes.ToList().FirstOrDefault(a => a.fkObjectID == item.ObjectID); string _source = string.Empty; if (item.SourceOrganizationID == null) { _source = item.tUserSourceService != null ? item.tUserSourceService.tSourceService.ServiceName : ""; } else { _source = item.tSourceOrganization.tOrganization.Name; } Models.UserData.UserDataWithNote _item = new Models.UserData.UserDataWithNote() { ID = _userNote != null ? _userNote.ID : -1, Note = _userNote != null ? _userNote.Note : string.Empty, ResultDateTime = item.ResultDateTime, Name = item.Name, Value = item.Value, ProviderName = item.ProviderID != null ? item.tProvider.Name : "", UOMName = item.tUnitsOfMeasure.UnitOfMeasure, Source = _source, ParentId = item.ID }; retVal.Add(_item); } #endregion break; default: break; } return(retVal); }