public static YellowstonePathology.Business.Search.ReportSearchList GetReportSearchListByITAudit(YellowstonePathology.Business.Test.ITAuditPriorityEnum itAuditPriority)
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT a.MasterAccessionNo, pso.ReportNo, a.AccessionTime AccessionDate, pso.PanelSetId, " +
"concat(a.PFirstName, ' ', a.PLastName) AS PatientName, " +
"a.PLastName, a.PFirstName, a.ClientName, a.PhysicianName, a.PBirthdate, pso.FinalDate, pso.PanelSetName, su.UserName as OrderedBy, " +
"'' 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;";
cmd.Parameters.AddWithValue("@ITAuditPriority", (int)itAuditPriority);
Search.ReportSearchList reportSearchList = BuildReportSearchList(cmd);
return(reportSearchList);
}
public void GetReportSearchListByITAudit(YellowstonePathology.Business.Test.ITAuditPriorityEnum itAuditPriority)
{
this.m_ReportSearchList = YellowstonePathology.Business.Gateway.ReportSearchGateway.GetReportSearchListByITAudit(itAuditPriority);
this.NotifyPropertyChanged("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);
}
