public void DbConnectionTest() { List <MSH> msh; using (ExportQueueTable exp = new ExportQueueTable(GeneralHelper.ConnectionString, 0, ProcessStageFilterEnum.Lookup, ProcessStateFilterEnum.Failed, "ResolveHealthConditions")) { msh = BatchHelper.LoadBatches(exp.Items_ExportQueue); } }
public override List <MSH> GetMSH() { const int NO_OF_RECORDS = 25; using (ExportQueueTable exp = new ExportQueueTable(GeneralHelper.ConnectionString, 0, ProcessStageFilterEnum.Lookup, ProcessStateFilterEnum.Failed, "ResolveHealthConditions")) { // Return 25 for now return(BatchHelper.LoadBatches(exp.Items_ExportQueue.Take(NO_OF_RECORDS).ToList())); } }
public void SaveHealthCondition() { String _CodingSystem = "Anthrax"; String Key = "Anthrax"; String Name = "Anthrax"; using (ExportQueueTable exp = new ExportQueueTable(GeneralHelper.ConnectionString, 0, ProcessStageFilterEnum.Lookup, ProcessStateFilterEnum.Failed, "ResolveHealthConditions")) { var update_msh_id = 100; var exportQueueItem = exp.Items_ExportQueue.Where(eq => eq.MSH_ID == update_msh_id).FirstOrDefault(); var batchItem = HL7.Reportable.Common.Common.DeserializeXmlToObject <HL7.Reportable.Common.Business.HL7.ExportBatch>(exportQueueItem.Process_Message); var labReport = batchItem.LabReports.Where(lr => lr.MSH_ID == update_msh_id.ToString()).FirstOrDefault(); labReport.PHRED_Variables.PHRED_AssignmentNote = "The Note"; string obr_id = "108"; string obx_id = "110"; var obr = labReport.TestRequests.Where(tRequest => tRequest.OBR_ID == obr_id).FirstOrDefault(); var obx = obr.TestResults.Where(tResult => tResult.OBX_ID == obx_id).FirstOrDefault(); CodedElement ceHCC = new CodedElement() { Code = Key, Description = Name, CodingSystem = _CodingSystem }; CodedElement ceHC = new CodedElement() { Code = Key, Description = Name, CodingSystem = _CodingSystem }; obx.PHRED_AssignedHCManually = true; obx.PHRED_AssignerUserKey = "Active Directory Username"; obx.PHRED_AssignmentNote = "Another Note"; obx.PHRED_AssignedDtTm = DateTime.Now.ToString(); obx.PHRED_AssignedHCC = ceHCC; obx.PHRED_AssignedHC = ceHC; // Update the Status exportQueueItem.Process_State = ProcessStateEnum.Pending; exportQueueItem.Save(); // Revert it back //exportQueueItem.Process_Stage = ProcessStageEnum.Lookup; //exportQueueItem.Process_State = ProcessStateEnum.Failed; //exportQueueItem.Save(); } }
public void FirstSetupTest() { String dbConnection = ConfigurationManager.AppSettings["HL7ReportableDB"]; List <MSH> msh; using (ExportQueueTable exp = new ExportQueueTable(dbConnection, 0, ProcessStageFilterEnum.Lookup, ProcessStateFilterEnum.Failed, "ResolveHealthConditions")) { msh = BatchHelper.LoadBatches(exp.Items_ExportQueue); } var result = TreeViewHelper.Transform(msh); TreeViewData td = new TreeViewData() { MSHData = msh, TreeData = result }; }
public override bool Save(string Username, long MSH_ID, String Note, List <ChangeSetData> changeSet, out string errorMessage) { errorMessage = ""; try { using (ExportQueueTable exp = new ExportQueueTable(GeneralHelper.ConnectionString, 0, ProcessStageFilterEnum.Lookup, ProcessStateFilterEnum.Failed, "ResolveHealthConditions")) { var update_msh_id = MSH_ID; var exportQueueItem = exp.Items_ExportQueue.Where(eq => eq.MSH_ID == update_msh_id).FirstOrDefault(); if (exportQueueItem == null) { // Record was already saved by another user . So lets just ignore these changes errorMessage = " Already saved by another user"; return(true); } var batchItem = HL7.Reportable.Common.Common.DeserializeXmlToObject <HL7.Reportable.Common.Business.HL7.ExportBatch>(exportQueueItem.Process_Message); var labReport = batchItem.LabReports.Where(lr => lr.MSH_ID == update_msh_id.ToString()).FirstOrDefault(); labReport.PHRED_Variables.PHRED_AssignmentNote = Note; foreach (var item in changeSet) { UpdateReport(Username, labReport, item); } // Update the Status exportQueueItem.Process_State = ProcessStateEnum.Pending; exportQueueItem.Save(); } return(true); } catch (Exception ex) { errorMessage = ex.Message; return(false); } }