public void Print(YellowstonePathology.Business.Search.ReportSearchList caseList, string description, DateTime printDate) { Microsoft.Office.Interop.Excel.Application xlApp; xlApp = new Microsoft.Office.Interop.Excel.Application(); xlApp.Visible = false; Microsoft.Office.Interop.Excel.Workbook wb = xlApp.Workbooks.Add(@"\\CFileServer\documents\ReportTemplates\MolecularTesting\CaseList.xlt"); Microsoft.Office.Interop.Excel.Worksheet ws = (Microsoft.Office.Interop.Excel.Worksheet)wb.Worksheets[1]; ws.Cells[3, 1] = "Batch: " + description + " - " + printDate.ToShortDateString(); int rowPosition = 6; for (int i = caseList.Count - 1; i > -1; i--) { ws.Cells[rowPosition, 1] = caseList[i].ReportNo; ws.Cells[rowPosition, 2] = caseList[i].PanelSetName; ws.Cells[rowPosition, 3] = caseList[i].PatientName; ws.Cells[rowPosition, 4] = caseList[i].PhysicianName + " - " + caseList[i].ClientName; ws.Cells[rowPosition, 5] = caseList[i].OrderedBy; rowPosition++; } Object oMissing = Type.Missing; Object oFalse = false; ws.PrintOut(Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); wb.Close(oFalse, oMissing, oMissing); xlApp.Quit(); }
public SearchEngine() { m_Parameters = new List <object>(); m_SearchFillEnum = YellowstonePathology.Business.Search.ReportSearchFillEnum.None; this.m_ReportSearchList = new YellowstonePathology.Business.Search.ReportSearchList(); this.m_AutomatedOrderList = new YellowstonePathology.Business.AutomatedOrderList(); }
public void FillSearchList() { switch (this.m_SearchFillEnum) { case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByAccessionDate: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByAccessionDate(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByDateRangeBatchLocation: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByDateRangeBatchLocation(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByDateRange: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByDateRange(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByTodayLocation: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByDateRangeLocation(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByReportNo: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByReportNo(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotDistributed: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotDistributed(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotFinalLoacation: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotFinalLocation(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotFinalPanelId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotFinalPanelId(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByInHouseMolecularPending: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByInHouseMolecularPending(); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByUnBatchedBatchTypeId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByUnBatchedBatchTypeId(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByBatchId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByBatchId(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByPatientName: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByPatientName(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByMasterAccessionNo: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByMasterAccessionNo(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotAudited: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotAudited(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByPatientId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByPatientId(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotVerified: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotVerified(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByPanelSetId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByPanelSetId(m_Parameters); break; default: break; } if (this.m_ReportSearchList == null) this.m_ReportSearchList = new YellowstonePathology.Business.Search.ReportSearchList(); }
public SearchEngine() { m_Parameters = new List<object>(); m_SearchFillEnum = YellowstonePathology.Business.Search.ReportSearchFillEnum.None; this.m_ReportSearchList = new YellowstonePathology.Business.Search.ReportSearchList(); this.m_AutomatedOrderList = new YellowstonePathology.Business.AutomatedOrderList(); }
private void ButtonNext_Click(object sender, RoutedEventArgs e) { if (this.TextBoxMasterAccessionNo.Text.Length >= 1) { Surgical.TextSearchHandler textSearchHandler = new Surgical.TextSearchHandler(this.TextBoxMasterAccessionNo.Text); object textSearchObject = textSearchHandler.GetSearchObject(); if (textSearchObject is YellowstonePathology.Business.MasterAccessionNo) { YellowstonePathology.Business.MasterAccessionNo masterAccessionNo = (YellowstonePathology.Business.MasterAccessionNo)textSearchObject; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByMasterAccessionNo(masterAccessionNo.Value); if (reportSearchList.Count > 0) { this.Next(this, new CustomEventArgs.MasterAccessionNoReturnEventArgs(masterAccessionNo.Value)); } else { MessageBox.Show("Unable to find the Accession."); } } else { MessageBox.Show("Enter a Master Accession Number."); } } else { MessageBox.Show("Enter a Master Accession Number."); } }
public void GetReportSearchListByPatientName(YellowstonePathology.Business.PatientName patientName) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPatientName(new List <object>() { patientName.LastName, patientName.FirstName }); this.NotifyPropertyChanged("ReportSearchList"); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByInHouseMolecularPending() { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "gwAccessionOrderListByInHouseMolecularPending"; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public void GetReportSearchList() { List <int> panelSetIdList = YellowstonePathology.Business.PanelSet.Model.PanelSetCollection.GetPanelSetIdList(this.m_CurrentCaseType); panelSetIdList.Add(131); this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByAccessionDate(this.m_AccessionOrderDate, panelSetIdList); this.NotifyPropertyChanged("ReportSearchList"); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByNotVerified(List <object> parameters) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "gwAccessionOrderListByNotVerified"; cmd.Parameters.Add("@PanelSetId", SqlDbType.Int).Value = parameters[0]; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public CaseListReport(YellowstonePathology.Business.Search.ReportSearchList reportSearchList) { this.m_ReportSearchList = reportSearchList; YellowstonePathology.Document.Xps.PlainHeader header = new YellowstonePathology.Document.Xps.PlainHeader("Case List"); YellowstonePathology.Document.Xps.PlainFooter footer = new YellowstonePathology.Document.Xps.PlainFooter(string.Empty); this.m_ReportDocument = new YellowstonePathology.Document.Xps.ReportDocument(header, footer); this.SetGrid(); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByDateRange(List <object> parameters) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "gwAccessionOrderListByCurrentMonthFill"; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = parameters[0]; cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = parameters[1]; cmd.Parameters.Add("@PanelSetId", SqlDbType.VarChar).Value = parameters[2]; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByAccessionDate(List <object> parameters) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "gwAccessionOrderListByAccessionDateBatchTypeIdFillV2"; cmd.Parameters.Add("@AccessionDate", SqlDbType.VarChar).Value = ((DateTime)parameters[0]).ToShortDateString(); cmd.Parameters.Add("@BatchTypeId", SqlDbType.Int).Value = parameters[1]; cmd.Parameters.Add("@FacilityId", SqlDbType.VarChar).Value = parameters[2]; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public TecanImportExportPage(YellowstonePathology.Business.Search.ReportSearchList caseList, Visibility nextButtonVisibility, Visibility closeButtonVisibility) { this.m_CaseList = caseList; this.m_NextButtonVisibility = nextButtonVisibility; this.m_CloseButtonVisibility = closeButtonVisibility; this.m_UserPreference = YellowstonePathology.Business.User.UserPreferenceInstance.Instance.UserPreference; this.BuildFileList(); InitializeComponent(); DataContext = this; }
public void FillSearchList() { switch (this.m_SearchFillEnum) { case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByDateRange: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByDateRange(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByReportNo: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByReportNo(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotDistributed: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotDistributed(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotFinalPanelId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotFinalPanelId(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByInHouseMolecularPending: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByInHouseMolecularPending(); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByPatientName: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByPatientName(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByMasterAccessionNo: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByMasterAccessionNo(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByNotAudited: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByNotAudited(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByPatientId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByPatientId(m_Parameters); break; case YellowstonePathology.Business.Search.ReportSearchFillEnum.ByPanelSetId: this.m_ReportSearchList = Gateway.ReportSearchGateway.GetReportSearchListByPanelSetId(m_Parameters); break; default: break; } if (this.m_ReportSearchList == null) { this.m_ReportSearchList = new YellowstonePathology.Business.Search.ReportSearchList(); } }
public NeogenomicsResultAccessionPage(YellowstonePathology.Business.NeogenomicsResult neogenomicsResult) { this.m_NeogenomicsResult = neogenomicsResult; List<object> parameterList = new List<object>(); parameterList.Add(neogenomicsResult.PLastName); parameterList.Add(neogenomicsResult.PFirstName); this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPatientName(parameterList); this.NotifyPropertyChanged("ReportSearchList"); InitializeComponent(); this.DataContext = this; }
public NeogenomicsResultAccessionPage(YellowstonePathology.Business.NeogenomicsResult neogenomicsResult) { this.m_NeogenomicsResult = neogenomicsResult; List <object> parameterList = new List <object>(); parameterList.Add(neogenomicsResult.PLastName); parameterList.Add(neogenomicsResult.PFirstName); this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPatientName(parameterList); this.NotifyPropertyChanged("ReportSearchList"); InitializeComponent(); this.DataContext = this; }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByNotPosted() { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT pso.[MasterAccessionNo], pso.[ReportNo], a.AccessionTime [AccessionDate], pso.[PanelSetId], a.[PFirstName] + ' ' + a.[PLastName] AS [PatientName], " + "a.[PLastName], a.[PFirstName], a.[ClientName], a.[PhysicianName], a.[PBirthdate], pso.[OriginatingLocation], pso.[FinalDate], pso.PanelSetName, su.UserName as [OrderedBy], " + "a.ColorCode, '' ForeignAccessionNo, pso.IsPosted " + "FROM tblAccessionOrder a JOIN tblPanelSetOrder pso ON a.[MasterAccessionNo] = pso.[MasterAccessionNo] " + "Left Outer Join tblSystemUser su on pso.OrderedById = su.UserId " + "WHERE pso.Final = 1 and pso.IsPosted = 0 and pso.OrderDate >= '1/1/2014' and pso.IsBillable = 1 Order By pso.FinalDate, pso.PanelSetId, a.AccessionTime " + "for xml path('ReportSearchItem'), type, root('ReportSearchList')"; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByITAudit(YellowstonePathology.Business.Test.ITAuditPriorityEnum itAuditPriority) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT a.[MasterAccessionNo], pso.[ReportNo], a.AccessionTime [AccessionDate], pso.[PanelSetId], a.[PFirstName] + ' ' + a.[PLastName] AS [PatientName], " + "a.[PLastName], a.[PFirstName], a.[ClientName], a.[PhysicianName], a.[PBirthdate], pso.[OriginatingLocation], pso.[FinalDate], pso.PanelSetName, su.UserName as [OrderedBy], " + "a.ColorCode, '' ForeignAccessionNo, pso.IsPosted " + "FROM tblAccessionOrder a " + "Left outer JOIN tblPanelSetOrder pso ON a.[MasterAccessionNo] = pso.[MasterAccessionNo] " + "Left Outer JOIN tblSystemUser su on pso.OrderedById = su.UserId " + "WHERE a.ITAuditRequired = 1 and a.ITAudited = 0 and a.ITAuditPriority = @ITAuditPriority " + "for xml path('ReportSearchItem'), type, root('ReportSearchList')"; cmd.Parameters.Add("@ITAuditPriority", SqlDbType.Int).Value = (int)itAuditPriority; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByPatientName(List <object> parameters) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "pReportSearchListByPatientName"; cmd.Parameters.Add("@PLastName", SqlDbType.VarChar).Value = parameters[0].ToString(); if (parameters[1] == null) { cmd.Parameters.Add("@PFirstName", SqlDbType.VarChar).Value = DBNull.Value; } else { cmd.Parameters.Add("@PFirstName", SqlDbType.VarChar).Value = parameters[1].ToString(); } YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByPostDate(DateTime postDate) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT distinct pso.[MasterAccessionNo], pso.[ReportNo], a.AccessionTime [AccessionDate], pso.[PanelSetId], a.[PFirstName] + ' ' + a.[PLastName] AS [PatientName], " + "a.[PLastName], a.[PFirstName], a.[ClientName], a.[PhysicianName], a.[PBirthdate], pso.[OriginatingLocation], pso.[FinalDate], pso.PanelSetName, su.UserName as [OrderedBy], " + "a.ColorCode, '' ForeignAccessionNo, pso.IsPosted " + "FROM tblAccessionOrder a " + "JOIN tblPanelSetOrder pso ON a.[MasterAccessionNo] = pso.[MasterAccessionNo] " + "join tblPanelSetOrderCPTCodeBill psocpt on pso.ReportNo = psocpt.ReportNo " + "Left Outer Join tblSystemUser su on pso.OrderedById = su.UserId " + "WHERE pso.IsPosted = 1 and psocpt.PostDate = @PostDate Order By pso.FinalDate, pso.PanelSetId, a.AccessionTime " + "for xml path('ReportSearchItem'), type, root('ReportSearchList')"; cmd.Parameters.Add("@PostDate", SqlDbType.DateTime).Value = postDate; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByAliquotOrderId(string aliquotOrderId) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT pso.[MasterAccessionNo], pso.[ReportNo], a.AccessionTime [AccessionDate], pso.[PanelSetId], a.[PFirstName] + ' ' + a.[PLastName] AS [PatientName], " + "a.[PLastName], a.[PFirstName], a.[ClientName], a.[PhysicianName], a.[PBirthdate], pso.[OriginatingLocation], pso.[FinalDate], pso.PanelSetName, su.UserName as [OrderedBy], " + "a.ColorCode, '' ForeignAccessionNo, pso.IsPosted " + "FROM tblAccessionOrder a " + "JOIN tblPanelSetOrder pso ON a.[MasterAccessionNo] = pso.[MasterAccessionNo] " + "Left Outer Join tblSystemUser su on pso.OrderedById = su.UserId " + "WHERE a.MasterAccessionNo in " + "(Select MasterAccessionNo from tblSpecimenOrder so join tblAliquotOrder ao on so.SpecimenOrderId = ao.SpecimenOrderId where ao.AliquotOrderId = @AliquotOrderId) " + "for xml path('ReportSearchItem'), type, root('ReportSearchList')"; cmd.Parameters.Add("@AliquotOrderId", SqlDbType.VarChar).Value = aliquotOrderId; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByAccessionDate(DateTime accessionDate, List <int> panelSetIdList) { string panelSetIdString = YellowstonePathology.Business.Helper.IdListHelper.ToIdString(panelSetIdList); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT pso.[MasterAccessionNo], pso.[ReportNo], a.AccessionTime [AccessionDate], pso.[PanelSetId], a.[PFirstName] + ' ' + a.[PLastName] AS [PatientName], " + "a.[PLastName], a.[PFirstName], a.[ClientName], a.[PhysicianName], a.[PBirthdate], pso.[OriginatingLocation], pso.[FinalDate], pso.PanelSetName, su.UserName as [OrderedBy], " + "a.ColorCode, '' ForeignAccessionNo, pso.IsPosted " + "FROM tblAccessionOrder a JOIN tblPanelSetOrder pso ON a.[MasterAccessionNo] = pso.[MasterAccessionNo] " + "Left Outer Join tblSystemUser su on pso.OrderedById = su.UserId " + "WHERE a.AccessionDate = @AccessionDate " + "And pso.PanelSetId in (" + panelSetIdString + ")" + "ORDER BY AccessionTime desc " + "for xml path('ReportSearchItem'), type, root('ReportSearchList')"; cmd.Parameters.Add("@AccessionDate", SqlDbType.VarChar).Value = accessionDate; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByPositiveHPylori(DateTime startDate, DateTime endDate) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT distinct pso.[MasterAccessionNo], pso.[ReportNo], a.AccessionTime [AccessionDate], pso.[PanelSetId], a.[PFirstName] + ' ' + a.[PLastName] AS [PatientName], " + "a.[PLastName], a.[PFirstName], a.[ClientName], a.[PhysicianName], a.[PBirthdate], pso.[OriginatingLocation], pso.[FinalDate], pso.PanelSetName, su.UserName as [OrderedBy], " + "a.ColorCode, '' ForeignAccessionNo, pso.IsPosted " + "FROM tblAccessionOrder a " + "join tblPanelSetOrder pso ON a.[MasterAccessionNo] = pso.[MasterAccessionNo] " + "join tblPanelOrder po on pso.ReportNo = po.ReportNo " + "join tblTestOrder t on po.panelOrderId = t.panelOrderId " + "join tblStainResult sr on t.TestOrderId = sr.TestOrderId " + "Left Outer Join tblSystemUser su on pso.OrderedById = su.UserId " + "where t.TestId = 107 and sr.Result = 'Positive' and a.AccessionDate between @StartDate and @EndDate " + "for xml path('ReportSearchItem'), type, root('ReportSearchList')"; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = startDate; cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = endDate; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListBySpecimenKeyword(string specimenDescription, DateTime startDate, DateTime endDate) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT pso.[MasterAccessionNo], pso.[ReportNo], a.AccessionTime [AccessionDate], pso.[PanelSetId], a.[PFirstName] + ' ' + a.[PLastName] AS [PatientName], " + "a.[PLastName], a.[PFirstName], a.[ClientName], a.[PhysicianName], a.[PBirthdate], pso.[OriginatingLocation], pso.[FinalDate], pso.PanelSetName, su.UserName as [OrderedBy], " + "a.ColorCode, '' ForeignAccessionNo, pso.IsPosted " + "FROM tblAccessionOrder a " + "JOIN tblPanelSetOrder pso ON a.[MasterAccessionNo] = pso.[MasterAccessionNo] " + "Left Outer Join tblSystemUser su on pso.OrderedById = su.UserId " + "WHERE a.MasterAccessionNo in " + "(Select MasterAccessionNo from tblSpecimenOrder so where so.masterAccessionNo = a.masterAccessionNo " + "and charindex(@SpecimenDescription, so.Description) > 0) " + "and a.AccessionDate between @StartDate and @EndDate " + "for xml path('ReportSearchItem'), type, root('ReportSearchList')"; cmd.Parameters.Add("@SpecimenDescription", SqlDbType.VarChar).Value = specimenDescription; cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = startDate; cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = endDate; YellowstonePathology.Business.Search.ReportSearchList reportSearchList = Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteCollectionCommand <YellowstonePathology.Business.Search.ReportSearchList>(cmd, Domain.Persistence.DataLocationEnum.ProductionData); return(reportSearchList); }
public void GetReportSearchListBySpecimenKeyword(string specimenDesription, DateTime startDate, DateTime endDate) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListBySpecimenKeyword(specimenDesription, startDate, endDate); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByTest(int panelSetId, DateTime startDate, DateTime endDate) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByTest(panelSetId, startDate, endDate); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByPostDate(DateTime postDate) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPostDate(postDate); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByReportNo(string reportNo) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByReportNo(reportNo); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByPatientName(YellowstonePathology.Business.PatientName patientName) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPatientName(new List<object>(){patientName.LastName, patientName.FirstName}); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByPositiveHPylori(DateTime startDate, DateTime endDate) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPositiveHPylori(startDate, endDate); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByDrKurtzman() { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByDrKurtzman(); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByITAudit(YellowstonePathology.Business.Test.ITAuditPriorityEnum itAuditPriority) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByITAudit(itAuditPriority); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchList() { List<int> panelSetIdList = YellowstonePathology.Business.PanelSet.Model.PanelSetCollection.GetPanelSetIdList(this.m_CurrentCaseType); panelSetIdList.Add(131); this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByAccessionDate(this.m_AccessionOrderDate, panelSetIdList); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByAliquotOrderId(string aliquotOrderId) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByAliquotOrderId(aliquotOrderId); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByPendingTests() { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPendingTests(); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByClientAccessioned() { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByClientAccessioned(); this.NotifyPropertyChanged("ReportSearchList"); }
public void GetReportSearchListByMasterAccessionNo(string masterAccessionNo) { this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByMasterAccessionNo(masterAccessionNo); this.NotifyPropertyChanged("ReportSearchList"); }
public void PrintCaseList(string description, DateTime printDate, YellowstonePathology.Business.Search.ReportSearchList selectedItemList) { YellowstonePathology.Business.MolecularTesting.CaseList report = new YellowstonePathology.Business.MolecularTesting.CaseList(); report.Print(selectedItemList, description, printDate); }