public void Sync(DataTable dataTable, string reportNo) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string testOrderReportDistributionLogId = dataTableReader["TestOrderReportDistributionLogId"].ToString(); string distributionReportNo = dataTableReader["ReportNo"].ToString(); TestOrderReportDistributionLog testOrderReportDistributionLog = null; if (this.Exists(testOrderReportDistributionLogId) == true) { testOrderReportDistributionLog = this.Get(testOrderReportDistributionLogId); } else if (reportNo == distributionReportNo) { testOrderReportDistributionLog = new TestOrderReportDistributionLog(); this.Add(testOrderReportDistributionLog); } if (testOrderReportDistributionLog != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(testOrderReportDistributionLog, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void SyncAliquot(DataTable dataTable, string aliquotOrderId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string testOrderId = dataTableReader["TestOrderId"].ToString(); string testAliquotOrderId = dataTableReader["AliquotOrderId"].ToString(); TestOrder testOrder = null; if (this.ExistsByTestOrderId(testOrderId) == true) { testOrder = this.GetTestOrder(testOrderId); } else if (testAliquotOrderId == aliquotOrderId) { testOrder = new TestOrder(); this.Add(testOrder); } if (testOrder != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(testOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable, string reportNo) { //this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string panelOrderId = dataTableReader["PanelOrderId"].ToString(); string panelReportNo = dataTableReader["ReportNo"].ToString(); PanelOrder panelOrder = null; if (this.Exists(panelOrderId) == true) { panelOrder = this.GetByPanelOrderId(panelOrderId); } else if (panelReportNo == reportNo) { int panelId = (int)dataTableReader["PanelId"]; Panel.Model.Panel panel = Panel.Model.PanelCollection.GetAll().GetPanel(panelId); panelOrder = Test.PanelOrderFactory.GetPanelOrder(panel); this.Add(panelOrder); } if (panelOrder != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(panelOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable, string reportNo) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string flowMarkerId = dataTableReader["FlowMarkerId"].ToString(); string markerReportNo = dataTableReader["ReportNo"].ToString(); FlowMarkerItem flowMarkerItem = null; if (this.Exists(flowMarkerId) == true) { flowMarkerItem = this.Get(flowMarkerId); } else if (reportNo == markerReportNo) { flowMarkerItem = new FlowMarkerItem(); this.Add(flowMarkerItem); } if (flowMarkerItem != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(flowMarkerItem, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable, string surgicalSpecimenId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string icd9BillingId = dataTableReader["Icd9BillingId"].ToString(); string icd9SurgicalSpecimenId = dataTableReader["SurgicalSpecimenId"].ToString(); ICD9BillingCode icd9BillingCode = null; if (this.Exists(icd9BillingId) == true) { icd9BillingCode = this.Get(icd9BillingId); } else if (surgicalSpecimenId == icd9SurgicalSpecimenId) { icd9BillingCode = new ICD9BillingCode(); this.Add(icd9BillingCode); } if (icd9BillingCode != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(icd9BillingCode, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable, string surgicalSpecimenId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string icd9BillingId = dataTableReader["IntraoperativeConsultationResultId"].ToString(); string icSurgicalSpecimenId = dataTableReader["SurgicalSpecimenId"].ToString(); IntraoperativeConsultationResult intraoperativeConsultationResult = null; if (this.Exists(icd9BillingId) == true) { intraoperativeConsultationResult = this.Get(icd9BillingId); } else if (surgicalSpecimenId == icSurgicalSpecimenId) { intraoperativeConsultationResult = new IntraoperativeConsultationResult(); this.Add(intraoperativeConsultationResult); } if (intraoperativeConsultationResult != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(intraoperativeConsultationResult, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void SyncForTestOrder(DataTable dataTable, string testOrderId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string slideOrderId = dataTableReader["SlideOrderId"].ToString(); string slideTestOrderId = dataTableReader["TestOrderId"].ToString(); SlideOrder slideOrder = null; if (this.Exists(slideOrderId) == true) { slideOrder = this.Get(slideOrderId); } else if (slideTestOrderId == testOrderId) { slideOrder = new SlideOrder(); this.Add(slideOrder); } if (slideOrder != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(slideOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public override void Sync(DataTable dataTable, string panelOrderId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string testOrderId = dataTableReader["TestOrderId"].ToString(); string testPanelOrderId = dataTableReader["PanelOrderId"].ToString(); TestOrder testOrder = null; if (this.Exists(testOrderId) == true) { testOrder = this.Get(testOrderId); } else if (testPanelOrderId == panelOrderId) { testOrder = new TestOrder(); this.Add(testOrder); } if (testOrder != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(testOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string taskOrderId = dataTableReader["TaskOrderId"].ToString(); TaskOrder taskOrder = null; if (this.Exists(taskOrderId) == true) { taskOrder = this.GetTaskOrder(taskOrderId); } else { taskOrder = new TaskOrder(); this.Add(taskOrder); } YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(taskOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } }
private void HandleSlideOrderTestOrder(DataTable dataTable) { DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string testOrderId = dataTableReader["TestOrderId"].ToString(); YellowstonePathology.Business.Test.Model.TestOrder_Base testOrder = null; foreach (Business.Specimen.Model.SpecimenOrder specimenOrder in this.m_AccessionOrder.SpecimenOrderCollection) { foreach (Business.Test.AliquotOrder aliquotOrder in specimenOrder.AliquotOrderCollection) { foreach (Business.Slide.Model.SlideOrder slideOrder in aliquotOrder.SlideOrderCollection) { if (slideOrder.TestOrderId == testOrderId) { if (slideOrder.TestOrder == null) { testOrder = new Test.Model.TestOrder(); slideOrder.TestOrder = testOrder; } else { testOrder = slideOrder.TestOrder; } YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(testOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } } } } }
private void HandleTestOrderAliquotOrder(DataTable dataTable) { DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string aliquotOrderId = dataTableReader["AliquotOrderId"].ToString(); YellowstonePathology.Business.Test.AliquotOrder_Base aliquotOrder = null; foreach (Business.Test.PanelSetOrder panelSetOrder in this.m_AccessionOrder.PanelSetOrderCollection) { foreach (Business.Test.PanelOrder panelOrder in panelSetOrder.PanelOrderCollection) { foreach (Business.Test.Model.TestOrder testOrder in panelOrder.TestOrderCollection) { if (testOrder.AliquotOrderId == aliquotOrderId) { if (testOrder.AliquotOrder == null) { aliquotOrder = new Test.AliquotOrder(); testOrder.AliquotOrder = aliquotOrder; } else { aliquotOrder = testOrder.AliquotOrder; } YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(aliquotOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } } } } }
public void Sync(DataTable dataTable, string reportNo) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string panelSetOrderCPTCodeId = dataTableReader["PanelSetOrderCPTCodeId"].ToString(); string cptCodeReportNo = dataTableReader["ReportNo"].ToString(); PanelSetOrderCPTCode panelSetOrderCPTCode = null; if (this.Exists(panelSetOrderCPTCodeId) == true) { panelSetOrderCPTCode = this.Get(panelSetOrderCPTCodeId); } else if (reportNo == cptCodeReportNo) { panelSetOrderCPTCode = new PanelSetOrderCPTCode(); this.Add(panelSetOrderCPTCode); } if (panelSetOrderCPTCode != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(panelSetOrderCPTCode, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
private void HandleTestOrderAliquotOrder(DataTable dataTable) { DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string aliquotOrderId = dataTableReader["AliquotOrderId"].ToString(); YellowstonePathology.Business.Test.AliquotOrder_Base aliquotOrder = null; foreach(Business.Test.PanelSetOrder panelSetOrder in this.m_AccessionOrder.PanelSetOrderCollection) { foreach(Business.Test.PanelOrder panelOrder in panelSetOrder.PanelOrderCollection) { foreach(Business.Test.Model.TestOrder testOrder in panelOrder.TestOrderCollection) { if (testOrder.AliquotOrderId == aliquotOrderId) { if (testOrder.AliquotOrder == null) { aliquotOrder = new Test.AliquotOrder(); testOrder.AliquotOrder = aliquotOrder; } else { aliquotOrder = testOrder.AliquotOrder; } YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(aliquotOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } } } } }
private void HandleSlideOrderTestOrder(DataTable dataTable) { DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string testOrderId = dataTableReader["TestOrderId"].ToString(); YellowstonePathology.Business.Test.Model.TestOrder_Base testOrder = null; foreach (Business.Specimen.Model.SpecimenOrder specimenOrder in this.m_AccessionOrder.SpecimenOrderCollection) { foreach (Business.Test.AliquotOrder aliquotOrder in specimenOrder.AliquotOrderCollection) { foreach (Business.Slide.Model.SlideOrder slideOrder in aliquotOrder.SlideOrderCollection) { if (slideOrder.TestOrderId == testOrderId) { if (slideOrder.TestOrder == null) { testOrder = new Test.Model.TestOrder(); slideOrder.TestOrder = testOrder; } else { testOrder = slideOrder.TestOrder; } YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(testOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } } } } }
public void Sync(DataTable dataTable, string taskOrderId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string taskOrderDetailId = dataTableReader["TaskOrderDetailId"].ToString(); string taskOrderDetailTaskOrderId = dataTableReader["TaskOrderId"].ToString(); string taskId = dataTableReader["TaskId"].ToString(); TaskOrderDetail taskOrderDetail = null; if (this.Exists(taskOrderDetailId) == true) { taskOrderDetail = this.Get(taskOrderDetailId); } else if (taskOrderId == taskOrderDetailTaskOrderId) { taskOrderDetail = TaskOrderDetailFactory.GetTaskOrderDetail(taskId); this.Add(taskOrderDetail); } if (taskOrderDetail != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(taskOrderDetail, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable, string reportNo) { this.RemoveDeleted(dataTable, reportNo); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string id = dataTableReader["RetrospectiveReviewTestOrderDetailId"].ToString(); string detailReportNo = dataTableReader["ReportNo"].ToString(); RetrospectiveReviewTestOrderDetail rsrd = null; if (this.Exists(id) == true) { rsrd = this.Get(id); } else { if (detailReportNo == reportNo) { rsrd = new RetrospectiveReviewTestOrderDetail(); this.Add(rsrd); } } if (rsrd != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(rsrd, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable, string specimenOrderId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string aliquotOrderId = dataTableReader["AliquotOrderId"].ToString(); string aliquotSpecimenOrderId = dataTableReader["SpecimenOrderId"].ToString(); Business.Test.AliquotOrder aliquotOrder = null; if (this.Exists(aliquotOrderId) == true) { aliquotOrder = this.GetByAliquotOrderId(aliquotOrderId); } else if (aliquotSpecimenOrderId == specimenOrderId) { aliquotOrder = new Business.Test.AliquotOrder(); this.Add(aliquotOrder); } if (aliquotOrder != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(aliquotOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable) { this.IsLoading = true; this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string specimenOrderId = dataTableReader["SpecimenOrderId"].ToString(); Business.Specimen.Model.SpecimenOrder specimenOrder = null; if (this.Exists(specimenOrderId) == true) { specimenOrder = this.GetSpecimenOrder(specimenOrderId); } else { specimenOrder = new Business.Specimen.Model.SpecimenOrder(); this.Add(specimenOrder); } YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(specimenOrder, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } this.IsLoading = false; }
public void Sync(DataTable dataTable, string surgicalAuditId) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string surgicalSpecimenAuditId = dataTableReader["SurgicalSpecimenAuditId"].ToString(); string specimenSurgicalAuditId = dataTableReader["SurgicalAuditId"].ToString(); SurgicalSpecimenAudit surgicalSpecimenAudit = null; if (this.Exists(surgicalSpecimenAuditId) == true) { surgicalSpecimenAudit = this.Get(surgicalSpecimenAuditId); } else if (surgicalAuditId == specimenSurgicalAuditId) { surgicalSpecimenAudit = new SurgicalSpecimenAudit(); this.Add(surgicalSpecimenAudit); } if (surgicalSpecimenAudit != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(surgicalSpecimenAudit, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }
public void Sync(DataTable dataTable) { this.RemoveDeleted(dataTable); DataTableReader dataTableReader = new DataTableReader(dataTable); while (dataTableReader.Read()) { string amendmentId = dataTableReader["AmendmentId"].ToString(); Amendment amendment = null; if (this.Exists(amendmentId) == true) { amendment = this.GetAmendment(amendmentId); } else { amendment = new Amendment(); this.Add(amendment); } if (amendment != null) { YellowstonePathology.Business.Persistence.SqlDataTableReaderPropertyWriter sqlDataTableReaderPropertyWriter = new Persistence.SqlDataTableReaderPropertyWriter(amendment, dataTableReader); sqlDataTableReaderPropertyWriter.WriteProperties(); } } }