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 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 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 GetReportSearchListByITAudit(YellowstonePathology.Business.Test.ITAuditPriorityEnum itAuditPriority)
{
this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByITAudit(itAuditPriority);
this.NotifyPropertyChanged("ReportSearchList");
}
public void GetReportSearchListByAliquotOrderId(string aliquotOrderId)
{
this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByAliquotOrderId(aliquotOrderId);
this.NotifyPropertyChanged("ReportSearchList");
}
public void GetReportSearchListByPostDate(DateTime postDate)
{
this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPostDate(postDate);
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 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);
}
public void GetReportSearchListByPositiveHPylori(DateTime startDate, DateTime endDate)
{
this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByPositiveHPylori(startDate, endDate);
this.NotifyPropertyChanged("ReportSearchList");
}
