private void Build(YellowstonePathology.Business.Task.Model.TaskOrder taskOrder)
{
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
this.m_SQLCommand.Connection = cn;
using (MySqlDataReader dr = this.m_SQLCommand.ExecuteReader(CommandBehavior.KeyInfo))
{
while (dr.Read())
{
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(taskOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Task.Model.TaskOrderDetail taskOrderDetail = new Task.Model.TaskOrderDetail();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(taskOrderDetail, dr);
sqlDataReaderPropertyWriter.WriteProperties();
taskOrder.TaskOrderDetailCollection.Add(taskOrderDetail);
}
}
}
}
private static YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder BuildReportOrderAbsoluteCD4Count(string reportNo)
{
YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder reportAbsoluteCD4Count = null;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * " +
"from tblAbsoluteCD4CountTestOrder ro " +
"join tblPanelSetOrder pso on ro.ReportNo = pso.ReportNo " +
"where ro.ReportNo = @ReportNo";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ReportNo", SqlDbType.VarChar).Value = reportNo;
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
reportAbsoluteCD4Count = new YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(reportAbsoluteCD4Count, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return reportAbsoluteCD4Count;
}
public static Flow.FlowMarkerCollection GetFlowMarkerCollectionByPanelId(string reportNo, int panelId)
{
Flow.FlowMarkerCollection result = new Flow.FlowMarkerCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select @ReportNo as ReportNo, mp.MarkerName as Name, mp.Intensity, mp.Interpretation, 'true' as MarkerUsed " +
"from tblFlowMarkerPanel mp left outer join tblMarkers m on mp.MarkerName = m.MarkerName where PanelId = @PanelId " +
"order by m.OrderFlag, m.MarkerName;";
cmd.Parameters.AddWithValue("@ReportNo", reportNo);
cmd.Parameters.AddWithValue("@PanelId", panelId);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Flow.FlowMarkerItem flowMarkerItem = new Flow.FlowMarkerItem();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(flowMarkerItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(flowMarkerItem);
}
}
}
return(result);
}
private void BuildWebServiceAccount(YellowstonePathology.Business.WebService.WebServiceAccount webServiceAccount)
{
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
this.m_SQLCommand.Connection = cn;
using (MySqlDataReader dr = this.m_SQLCommand.ExecuteReader(CommandBehavior.KeyInfo))
{
while (dr.Read())
{
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(webServiceAccount, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
if (dr.IsClosed == false)
{
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.WebService.WebServiceAccountClient webServiceAccountClient = new YellowstonePathology.Business.WebService.WebServiceAccountClient();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(webServiceAccountClient, dr);
sqlDataReaderPropertyWriter.WriteProperties();
webServiceAccountClient.ClientName = dr["ClientName"].ToString();
webServiceAccount.WebServiceAccountClientCollection.Add(webServiceAccountClient);
}
}
}
}
}
public YellowstonePathology.Business.Search.PathologistSearchResult PathologistAliquotOrderIdSearch(string aliquotOrderId, int panelSetId)
{
SqlCommand cmd = new SqlCommand("pPathologistAliquotOrderIdSearch_4");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AliquotOrderId", SqlDbType.VarChar).Value = aliquotOrderId;
cmd.Parameters.Add("@PanelSetId", SqlDbType.Int).Value = panelSetId;
YellowstonePathology.Business.Search.PathologistSearchResult result = null;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result = new Search.PathologistSearchResult();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderProperyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderProperyWriter.WriteProperties();
}
}
}
return result;
}
public static YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistributionCollection GetReportDistributionCollectionByDateRangeTumorRegistry(DateTime startDate, DateTime endDate, string distributionType)
{
YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistributionCollection result = new YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistributionCollection();
string sql = "Select * from tblTestOrderReportDistribution where TimeOfLastDistribution between @StartDate and @EndDate and DistributionType = @DistributionType";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = startDate;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = endDate;
cmd.Parameters.Add("@DistributionType", SqlDbType.VarChar).Value = distributionType;
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistribution testOrderReportDistribution = new YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistribution();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(testOrderReportDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(testOrderReportDistribution);
}
}
}
return result;
}
public static Test.ThinPrepPap.AcidWashList GetAcidWashList(DateTime startDate)
{
Test.ThinPrepPap.AcidWashList result = new Test.ThinPrepPap.AcidWashList();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select pso.MasterAccessionNo, po.ReportNo, po.OrderDate, po.Accepted, a.PLastName, a.PFirstName, a.PMiddleInitial from tblPanelOrder po join tblPanelSetOrder pso on po.ReportNo = pso.ReportNo " +
" join tblAccessionOrder a on pso.MasterAccessionNo = a.MasterAccessionNo where po.PanelId = 39 and po.OrderDate >= @StartDate order by po.OrderDate Desc";
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = startDate;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Test.ThinPrepPap.AcidWashListItem acidWashLIstItem = new Test.ThinPrepPap.AcidWashListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(acidWashLIstItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(acidWashLIstItem);
}
}
}
return result;
}
public static YellowstonePathology.Business.Client.PhysicianClientDistributionCollection GetPhysicianClientDistributionCollection(int physicianId, int clientId)
{
YellowstonePathology.Business.Client.PhysicianClientDistributionCollection result = new Client.PhysicianClientDistributionCollection();
string sql = "Select c.ClientId, c.ClientName, ph.PhysicianId, ph.DisplayName [PhysicianName], c.DistributionType, c.Fax [FaxNumber], c.LongDistance " +
"from tblPhysicianClient pc " +
"join tblPhysicianClientDistribution pcd on pc.PhysicianClientId = pcd.PhysicianClientId " +
"join tblPhysicianClient pc2 on pcd.DistributionId = pc2.PhysicianClientId " +
"join tblClient c on pc2.ClientId = c.ClientId " +
"join tblPhysician ph on pc2.Physicianid = ph.PhysicianId " +
"where pc.ClientId = @ClientId and pc.PhysicianId = @PhysicianId";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
cmd.Parameters.Add("@PhysicianId", SqlDbType.Int).Value = physicianId;
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
string distributionType = dr["DistributionType"].ToString();
YellowstonePathology.Business.Client.PhysicianClientDistribution physicianClientDistribution = YellowstonePathology.Business.Client.PhysicianClientDistributionFactory.GetPhysicianClientDistribution(distributionType);
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientDistribution);
}
}
}
return result;
}
public static YellowstonePathology.Business.Test.AccessionOrderView GetAccessionOrderView(string masterAccessionNo)
{
#if MONGO
return AccessionOrderGatewayMongo.GetAccessionOrderView(masterAccessionNo);
#else
YellowstonePathology.Business.Test.AccessionOrderView result = null;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblAccessionOrder where MasterAccessionNo = @MasterAccessionNo";
cmd.Parameters.Add("@MasterAccessionNo", SqlDbType.VarChar).Value = masterAccessionNo;
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result = new Test.AccessionOrderView();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return result;
#endif
}
private void BuildClientSupplyOrder(YellowstonePathology.Business.Client.Model.ClientSupplyOrder clientSupplyOrder)
{
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
this.m_SQLCommand.Connection = cn;
using (SqlDataReader dr = this.m_SQLCommand.ExecuteReader(CommandBehavior.KeyInfo))
{
while (dr.Read())
{
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientSupplyOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail clientSupplyOrderDetail = new YellowstonePathology.Business.Client.Model.ClientSupplyOrderDetail();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientSupplyOrderDetail, dr);
sqlDataReaderPropertyWriter.WriteProperties();
clientSupplyOrder.ClientSupplyOrderDetailCollection.Add(clientSupplyOrderDetail);
}
}
}
}
private void BuildClient(YellowstonePathology.Business.Client.Model.Client client)
{
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
this.m_SQLCommand.Connection = cn;
using (MySqlDataReader dr = this.m_SQLCommand.ExecuteReader(CommandBehavior.KeyInfo))
{
while (dr.Read())
{
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(client, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
if (dr.IsClosed == false)
{
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientLocation, dr);
sqlDataReaderPropertyWriter.WriteProperties();
client.ClientLocationCollection.Add(clientLocation);
}
}
}
}
}
public static XElement GetSpecimenOrder(string masterAccessionNo)
{
XElement result = new XElement("SpecimenOrders");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblSpecimenOrder where MasterAccessionno = '" + masterAccessionNo + "' order by SpecimenNumber";
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Specimen.Model.SpecimenOrder specimenOrder = new Specimen.Model.SpecimenOrder();
XElement specimenOrderElement = new XElement("SpecimenOrder");
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(specimenOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
YellowstonePathology.Business.Persistence.XmlPropertyReader xmlPropertyReader = new Persistence.XmlPropertyReader(specimenOrder, specimenOrderElement);
xmlPropertyReader.Write();
result.Add(specimenOrderElement);
}
}
}
return result;
}
private void BuildClient(YellowstonePathology.Business.Client.Model.Client client)
{
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
this.m_SQLCommand.Connection = cn;
using (SqlDataReader dr = this.m_SQLCommand.ExecuteReader(CommandBehavior.KeyInfo))
{
while (dr.Read())
{
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(client, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
if (dr.IsClosed == false)
{
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientLocation, dr);
sqlDataReaderPropertyWriter.WriteProperties();
client.ClientLocationCollection.Add(clientLocation);
}
}
}
}
}
public static YellowstonePathology.Business.ClientOrder.Model.ClientOrder BuildClientOrder(SqlDataReader dr)
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = null;
Nullable<int> panelSetId = null;
while (dr.Read())
{
if (dr["PanelSetId"] != DBNull.Value)
{
panelSetId = Convert.ToInt32(dr["PanelSetId"].ToString());
}
}
clientOrder = YellowstonePathology.Business.ClientOrder.Model.ClientOrderFactory.GetClientOrder(panelSetId);
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrder, dr);
propertyWriter.WriteProperties();
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(clientLocation, dr);
propertyWriter.WriteProperties();
clientOrder.ClientLocation = clientLocation;
}
return clientOrder;
}
public static YellowstonePathology.Business.Client.Model.PhysicianCollection GetPhysiciansByClientId(int clientId)
{
YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection = new Client.Model.PhysicianCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select ph.* " +
"from tblPhysician ph " +
"join tblPhysicianClient pc on ph.PhysicianId = pc.PhysicianId " +
"join tblClient c on pc.ClientId = c.ClientId " +
"where c.ClientId = @ClientId";
cmd.Parameters.AddWithValue("@ClientId", clientId);
cmd.CommandType = System.Data.CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Client.Model.Physician physician = new Client.Model.Physician();
Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physician, dr);
sqlDataReaderPropertyWriter.WriteProperties();
physicianCollection.Add(physician);
}
}
}
return(physicianCollection);
}
public static YellowstonePathology.Business.User.SystemUserCollection GetSystemUserCollection()
{
/*SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select su.UserId, su.Active, su.UserName, su.FirstName, su.LastName, su.Initials, su.Signature, su.DisplayName, su.EmailAddress, su.NationalProviderId, (select sr.* from tblSystemUserRole sr where sr.UserId = su.UserId " +
"for xml Path('SystemUserRole'), type) [SystemUserRoleCollection] from tblSystemUser su order by su.UserName for xml Path('SystemUser'), root('SystemUserCollection')";
cmd.CommandType = System.Data.CommandType.Text;
YellowstonePathology.Business.User.SystemUserCollection systemUserCollection = Persistence.SqlCommandHelper.ExecuteCollectionCommand<YellowstonePathology.Business.User.SystemUserCollection>(cmd);
return systemUserCollection;*/
Type t = typeof(YellowstonePathology.Business.User.SystemUserCollection);
ConstructorInfo ci = t.GetConstructor(BindingFlags.Instance | BindingFlags.NonPublic, null, new Type[0], null);
YellowstonePathology.Business.User.SystemUserCollection systemUserCollection = (YellowstonePathology.Business.User.SystemUserCollection)ci.Invoke(null);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select UserId, Active, UserName, FirstName, LastName, Initials, Signature, DisplayName, " +
"EmailAddress, NationalProviderId from tblSystemUser order by UserName " +
"select * from tblSystemUserRole";
cmd.CommandType = System.Data.CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUser systemUser = new SystemUser();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUser, dr);
sqlDataReaderPropertyWriter.WriteProperties();
systemUserCollection.Add(systemUser);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUserRole systemUserRole = new SystemUserRole();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUserRole, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (SystemUser systemUser in systemUserCollection)
{
if (systemUser.UserId == systemUserRole.UserID)
{
systemUser.SystemUserRoleCollection.Add(systemUserRole);
break;
}
}
}
}
}
return systemUserCollection;
}
private void Build(YellowstonePathology.Business.Test.AliquotOrder aliquotOrder)
{
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
this.m_SQLCommand.Connection = cn;
using (SqlDataReader dr = this.m_SQLCommand.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(aliquotOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
}
private void Build(object o)
{
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
m_SQLCommand.Connection = cn;
using (SqlDataReader dr = m_SQLCommand.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(o, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
}
public void BuildClientOrder()
{
while (this.m_DataReader.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(this.m_ClientOrder, this.m_DataReader);
propertyWriter.WriteProperties();
}
this.m_DataReader.NextResult();
while (this.m_DataReader.Read())
{
YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(clientLocation, this.m_DataReader);
propertyWriter.WriteProperties();
this.m_ClientOrder.ClientLocation = clientLocation;
}
}
public YellowstonePathology.Business.Search.PathologistSearchResult PathologistAliquotOrderIdSearch(string aliquotOrderId, int panelSetIdHint)
{
SqlCommand cmd = new SqlCommand("pPathologistAliquotOrderIdSearch_5");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AliquotOrderId", SqlDbType.VarChar).Value = aliquotOrderId;
List<YellowstonePathology.Business.Search.PathologistSearchResult> resultList = new List<Search.PathologistSearchResult>();
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Search.PathologistSearchResult result = new Search.PathologistSearchResult();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderProperyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderProperyWriter.WriteProperties();
resultList.Add(result);
}
}
}
if(resultList.Count == 0)
{
return null;
}
else if(resultList.Count == 1)
{
return resultList[0];
}
else
{
foreach (YellowstonePathology.Business.Search.PathologistSearchResult item in resultList)
{
if (item.PanelSetId == panelSetIdHint) return item;
}
return resultList[0];
}
}
private object ExcuteCommandAndBuild(SqlCommand cmd, Type topLevelType)
{
object result = null;
using (SqlConnection cn = new SqlConnection("Data Source=TestSQL;Initial Catalog=YPIData;Integrated Security=True"))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result = Activator.CreateInstance(topLevelType);
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return result;
}
public static Reports.POCRetensionReportData GetPOCRetensionReport(DateTime startDate, DateTime endDate)
{
Reports.POCRetensionReportData result = new Reports.POCRetensionReportData();
MySqlCommand cmd = new MySqlCommand("prcPOCRetensionReport_1");
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("StartDate", startDate);
cmd.Parameters.AddWithValue("EndDate", endDate);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result.StartDate = (DateTime)dr[0];
}
dr.NextResult();
while (dr.Read())
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pocRetensionReportDataItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
}
}
if (result.POCRetensionReportDataItems.Count == 0)
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
pocRetensionReportDataItem.Status = "No Cases Found.";
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
return(result);
}
public static Reports.POCRetensionReportData GetPOCRetensionReport(DateTime startDate, DateTime endDate)
{
Reports.POCRetensionReportData result = new Reports.POCRetensionReportData();
SqlCommand cmd = new SqlCommand("prcPOCRetensionReport_1");
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@StartDate", System.Data.SqlDbType.DateTime).Value = startDate;
cmd.Parameters.Add("@EndDate", System.Data.SqlDbType.DateTime).Value = endDate;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result.StartDate = (DateTime)dr[0];
}
dr.NextResult();
while (dr.Read())
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pocRetensionReportDataItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
}
}
if (result.POCRetensionReportDataItems.Count == 0)
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
pocRetensionReportDataItem.Status = "No Cases Found.";
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
return result;
}
private static Flow.FlowLogList BuildFlowLogList(MySqlCommand cmd)
{
Flow.FlowLogList result = new Flow.FlowLogList();
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Flow.FlowLogListItem flowLogListItem = new Flow.FlowLogListItem();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(flowLogListItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(flowLogListItem);
}
}
}
return(result);
}
public static YellowstonePathology.Business.ClientOrder.Model.ShipmentReturnResult GetShipment(string shipmentId)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "ws_GetShipment";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ShipmentId", SqlDbType.VarChar).Value = shipmentId;
YellowstonePathology.Business.ClientOrder.Model.ShipmentReturnResult shipmentReturnResult = new YellowstonePathology.Business.ClientOrder.Model.ShipmentReturnResult();
YellowstonePathology.Business.ClientOrder.Model.Shipment shipment = new YellowstonePathology.Business.ClientOrder.Model.Shipment();
YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailCollection clientOrderDetailCollection = new YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailCollection();
shipmentReturnResult.Shipment = shipment;
shipmentReturnResult.ClientOrderDetailCollection = clientOrderDetailCollection;
using (SqlConnection cn = new SqlConnection(ServerSqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(shipment, dr);
propertyWriter.WriteProperties();
}
dr.NextResult();
BuildClientOrderDetailCollection(clientOrderDetailCollection, dr);
}
}
return(shipmentReturnResult);
}
public void BuildClientOrder()
{
while (this.m_DataReader.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(this.m_ClientOrder, this.m_DataReader);
propertyWriter.WriteProperties();
}
this.m_DataReader.NextResult();
while (this.m_DataReader.Read())
{
YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(clientLocation, this.m_DataReader);
propertyWriter.WriteProperties();
this.m_ClientOrder.ClientLocation = clientLocation;
}
}
public static YellowstonePathology.Business.Billing.Model.EODProcessStatusCollection GetBillingEODProcessStatusHistory()
{
YellowstonePathology.Business.Billing.Model.EODProcessStatusCollection result = new Billing.Model.EODProcessStatusCollection();
MySqlCommand cmd = new MySqlCommand("Select * from tblBillingEODProcess where ProcessDate >= @ProcessDate order by ProcessDate desc;");
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ProcessDate", DateTime.Today.AddDays(-30));
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Billing.Model.EODProcessStatus status = new Billing.Model.EODProcessStatus();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(status, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(status);
}
}
}
return(result);
}
public static YellowstonePathology.Business.Client.Model.ClientGroupCollection GetClientGroupCollection()
{
#if MONGO
return PhysicianClientGatewayMongo.GetClientGroupCollection();
#else
YellowstonePathology.Business.Client.Model.ClientGroupCollection result = new Client.Model.ClientGroupCollection();
SqlCommand cmd = new SqlCommand("select * from tblClientGroup order by GroupName");
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientGroup clientGroup = new Client.Model.ClientGroup();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientGroup, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(clientGroup);
}
}
}
return result;
#endif
}
public static YellowstonePathology.Business.Client.Model.ClientSupplyCollection GetClientSupplyCollection(string supplyCategory)
{
YellowstonePathology.Business.Client.Model.ClientSupplyCollection result = new Client.Model.ClientSupplyCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblClientSupply where supplycategory = @SupplyCategory order by supplyname";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@SupplyCategory", SqlDbType.VarChar).Value = supplyCategory;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientSupply clientSupply = new Client.Model.ClientSupply();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientSupply, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(clientSupply);
}
}
}
return result;
}
private static View.PhysicianClientView BuildPhysicianClientView(SqlCommand cmd)
{
View.PhysicianClientView result = new View.PhysicianClientView();
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.Client client = new YellowstonePathology.Business.Client.Model.Client();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(client, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Clients.Add(client);
}
}
}
return result;
}
public static XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportData GetClientBillingDetailReport(DateTime postDateStart, DateTime postDateEnd, string clientGroupId)
{
XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportData result = new XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportData();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "prcGetClientBillingDetailReport_2";
cmd.Parameters.AddWithValue("StartDate", postDateStart);
cmd.Parameters.AddWithValue("EndDate", postDateEnd);
cmd.Parameters.AddWithValue("ClientGroupId", clientGroupId);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataAccessionOrder clientBillingDetailReportDataAccessionOrder = new XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataAccessionOrder();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientBillingDetailReportDataAccessionOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(clientBillingDetailReportDataAccessionOrder);
}
dr.NextResult();
while (dr.Read())
{
XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataReport clientBillingDetailReportDataReport = new XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataReport();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientBillingDetailReportDataReport, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataAccessionOrder clientBillingDetailReportDataAccessionOrder in result)
{
if (clientBillingDetailReportDataReport.MasterAccessionNo == clientBillingDetailReportDataAccessionOrder.MasterAccessionNo)
{
clientBillingDetailReportDataAccessionOrder.ClientBillingDetailReportDataReports.Add(clientBillingDetailReportDataReport);
break;
}
}
}
dr.NextResult();
while (dr.Read())
{
Test.PanelSetOrderCPTCode panelSetOrderCPTCode = new Test.PanelSetOrderCPTCode();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(panelSetOrderCPTCode, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataAccessionOrder clientBillingDetailReportDataAccessionOrder in result)
{
bool added = false;
foreach (XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataReport clientBillingDetailReportDataReport in clientBillingDetailReportDataAccessionOrder.ClientBillingDetailReportDataReports)
{
if (panelSetOrderCPTCode.ReportNo == clientBillingDetailReportDataReport.ReportNo)
{
clientBillingDetailReportDataReport.PanelSetOrderCPTCodes.Add(panelSetOrderCPTCode);
added = true;
break;
}
}
if (added)
{
break;
}
}
}
dr.NextResult();
while (dr.Read())
{
Test.PanelSetOrderCPTCodeBill panelSetOrderCPTCodeBill = new Test.PanelSetOrderCPTCodeBill();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(panelSetOrderCPTCodeBill, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataAccessionOrder clientBillingDetailReportDataAccessionOrder in result)
{
bool added = false;
foreach (XPSDocument.Result.ClientBillingDetailReportResult.ClientBillingDetailReportDataReport clientBillingDetailReportDataReport in clientBillingDetailReportDataAccessionOrder.ClientBillingDetailReportDataReports)
{
if (panelSetOrderCPTCodeBill.ReportNo == clientBillingDetailReportDataReport.ReportNo)
{
clientBillingDetailReportDataReport.PanelSetOrderCPTCodeBills.Add(panelSetOrderCPTCodeBill);
added = true;
break;
}
}
if (added)
{
break;
}
}
}
}
}
return(result);
}
public static List <WebService.WebServiceAccountView> GetWebServiceAccountViewList()
{
List <WebService.WebServiceAccountView> result = new List <WebService.WebServiceAccountView>();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select c.ClientName, w.WebServiceAccountId, w.PrimaryClientId, w.DisplayName, w.InitialPage from tblClient c join tblWebServiceAccount w on c.ClientId = w.PrimaryClientId order by w.DisplayName;";
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
WebService.WebServiceAccountView webServiceAccountView = new WebService.WebServiceAccountView();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlServerDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(webServiceAccountView, dr);
sqlServerDataReaderPropertyWriter.WriteProperties();
result.Add(webServiceAccountView);
}
}
}
return(result);
}
public static YellowstonePathology.Business.Client.Model.PhysicianClientDistributionList GetPhysicianClientDistributionCollection(int physicianId, int clientId)
{
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionList result = new Client.Model.PhysicianClientDistributionList();
string sql = "Select c.ClientId, c.ClientName, ph.PhysicianId, ph.DisplayName PhysicianName, pcd.DistributionType, " +
"c.Fax FaxNumber " +
"from tblPhysicianClient pc " +
"join tblPhysicianClientDistribution pcd on pc.PhysicianClientId = pcd.PhysicianClientId " +
"join tblPhysicianClient pc2 on pcd.DistributionId = pc2.PhysicianClientId " +
"join tblClient c on pc2.ClientId = c.ClientId " +
"join tblPhysician ph on pc2.PhysicianId = ph.PhysicianId " +
"where pc.ClientId = @ClientId and pc.PhysicianId = @PhysicianId;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@PhysicianId", physicianId);
cmd.Parameters.AddWithValue("@ClientId", clientId);
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
string distributionType = dr["DistributionType"].ToString();
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionListItem physicianClientDistribution = YellowstonePathology.Business.Client.Model.PhysicianClientDistributionFactory.GetPhysicianClientDistribution(distributionType);
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientDistribution);
}
}
}
return(result);
}
public static WebService.WebServiceAccountCollection GetWebServiceAccounts()
{
WebService.WebServiceAccountCollection result = new WebService.WebServiceAccountCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select * from tblWebServiceAccount;";
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
WebService.WebServiceAccount webServiceAccount = new WebService.WebServiceAccount();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlServerDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(webServiceAccount, dr);
sqlServerDataReaderPropertyWriter.WriteProperties();
result.Add(webServiceAccount);
}
}
}
return(result);
}
public YellowstonePathology.Business.PreviousResultCollection GetPreviousResultsByTestFinal(int panelSetId, DateTime startDate, DateTime endDate, string tableName)
{
PreviousResultCollection result = new PreviousResultCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = this.m_TableDictionary[tableName];
cmd.CommandText = cmd.CommandText.Replace("table_name", tableName);
cmd.Parameters.AddWithValue("@PanelSetId", panelSetId);
cmd.Parameters.AddWithValue("@StartDate", startDate);
cmd.Parameters.AddWithValue("@EndDate", endDate);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
PreviousResult previousResult = new PreviousResult();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(previousResult, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(previousResult);
}
}
}
return(result);
}
public static YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistributionCollection GetReportDistributionCollectionByDateRangeTumorRegistry(DateTime startDate, DateTime endDate, string distributionType)
{
YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistributionCollection result = new YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistributionCollection();
string sql = "Select * from tblTestOrderReportDistribution where TimeOfLastDistribution between @StartDate and @EndDate and " +
"DistributionType = @DistributionType;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@StartDate", startDate);
cmd.Parameters.AddWithValue("@EndDate", endDate);
cmd.Parameters.AddWithValue("@DistributionType", distributionType);
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistribution testOrderReportDistribution = new YellowstonePathology.Business.ReportDistribution.Model.TestOrderReportDistribution();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(testOrderReportDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(testOrderReportDistribution);
}
}
}
return(result);
}
public static List <YellowstonePathology.Business.Search.CytologyScreeningSearchResult> GetCytologyScreeningSearchResultsByAtLoggerheads(int assignedToId)
{
List <YellowstonePathology.Business.Search.CytologyScreeningSearchResult> result = new List <Search.CytologyScreeningSearchResult>();
string sqlStatement = "Select ao.MasterAccessionNo, " +
"pso.ReportNo, " +
"concat(ao.PFirstName, ' ', ao.PLastName) PatientName, " +
"ao.AccessionTime, " +
"cpo.ScreeningType, " +
"su.DisplayName OrderedByName, " +
"cpo.ScreenedByName, " +
"su1.DisplayName AssignedToName, " +
"po.AcceptedTime ScreeningFinalTime, " +
"pso.FinalTime CaseFinalTime, " +
"cpo.Reconciled " +
"from tblAccessionOrder ao " +
"join tblPanelSetOrder pso on ao.MasterAccessionNo = pso.MasterAccessionNo " +
"join tblPanelOrder po on pso.ReportNo = po.ReportNo " +
"join tblPanelOrderCytology cpo on po.PanelOrderId = cpo.PanelORderId " +
"left outer join tblSystemUser su on po.OrderedById = su.UserId " +
"left outer join tblSystemUser su1 on po.AssignedToId = su1.UserId " +
"where ao.AccessionDate >= date_add(curdate(), Interval -30 Day) " +
"and po.AssignedToId = @AssignedToId " +
"and pso.ResultCode <> po.ResultCode;";
MySqlCommand cmd = new MySqlCommand(sqlStatement);
cmd.Parameters.AddWithValue("@AssignedToId", assignedToId);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Search.CytologyScreeningSearchResult cytologyScreeningSearchResult = new Search.CytologyScreeningSearchResult();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(cytologyScreeningSearchResult, dr);
propertyWriter.WriteProperties();
result.Add(cytologyScreeningSearchResult);
}
}
}
return(result);
}
private static Domain.Physician GetPhysicianFromCommand(SqlCommand cmd)
{
Domain.Physician result = null;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result = new Domain.Physician();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return result;
}
private void Build(object o)
{
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
m_MySqlCommand.Connection = cn;
using (MySqlDataReader dr = m_MySqlCommand.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(o, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
}
public static List <YellowstonePathology.Business.Search.CytologyScreeningSearchResult> GetCytologyScreeningSearchResults(string sqlStatement)
{
List <YellowstonePathology.Business.Search.CytologyScreeningSearchResult> result = new List <Search.CytologyScreeningSearchResult>();
MySqlCommand cmd = new MySqlCommand(sqlStatement);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Search.CytologyScreeningSearchResult cytologyScreeningSearchResult = new Search.CytologyScreeningSearchResult();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(cytologyScreeningSearchResult, dr);
propertyWriter.WriteProperties();
result.Add(cytologyScreeningSearchResult);
}
}
}
return(result);
}
/* public static Domain.PhysicianCollection GetPhysiciansByClientId(int clientId)
{
#if MONGO
return PhysicianClientGatewayMongo.GetPhysiciansByClientId(clientId);
#else
Domain.PhysicianCollection result = new Domain.PhysicianCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select ph.* " +
"from tblPhysician ph " +
"join tblPhysicianClient pc on ph.PhysicianId = pc.PhysicianId " +
"where pc.ClientId = @ClientId order by ph.LastName";
cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
cmd.CommandType = CommandType.Text;
result = PhysicianClientGateway.GetPhysicianCollectionFromCommand(cmd);
return result;
#endif
}*/
private static Domain.PhysicianCollection GetPhysicianCollectionFromCommand(SqlCommand cmd)
{
Domain.PhysicianCollection result = new Domain.PhysicianCollection();
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Domain.Physician physician = new Domain.Physician();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physician, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physician);
}
}
}
return result;
}
public static YellowstonePathology.Business.View.StVClientDOHReportViewCollection GetReportDistributionCollectionByDateTumorRegistryStVClients(DateTime startDate, DateTime endDate)
{
YellowstonePathology.Business.View.StVClientDOHReportViewCollection result = new YellowstonePathology.Business.View.StVClientDOHReportViewCollection();
string sql = "select tord.ReportNo, ao.ClientName, tord.ClientName ReportedTo, tord.TimeOfLastDistribution from tblTestOrderReportDistribution tord " +
"join tblPanelSetOrder pso on tord.ReportNo = pso.ReportNo " +
"join tblAccessionOrder ao on ao.MasterAccessionNo = pso.MasterAccessionNo " +
"join tblClientGroupClient cgc on ao.ClientId = cgc.ClientId " +
"where tord.DateAdded between @StartDate and @EndDate and tord.DistributionType in('MTDOH', 'WYDOH') and cgc.ClientGroupId = 1;";
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@StartDate", startDate);
cmd.Parameters.AddWithValue("@EndDate", endDate);
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.View.StVClientDOHReportView view = new YellowstonePathology.Business.View.StVClientDOHReportView();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(view, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(view);
}
}
}
return(result);
}
public static YellowstonePathology.Business.Client.Model.ClientGroupClientCollection GetClientGroupClientCollectionByClientGroupId(int clientGroupId)
{
YellowstonePathology.Business.Client.Model.ClientGroupClientCollection result = new Client.Model.ClientGroupClientCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblClientGroupClient where ClientGroupId = @ClientGroupId";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ClientGroupId", SqlDbType.Int).Value = clientGroupId;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientGroupClient clientGroupClient = new Client.Model.ClientGroupClient();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientGroupClient, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(clientGroupClient);
}
}
}
return result;
}
public static SystemRoleCollection GetAllSystemRoles()
{
SystemRoleCollection result = new User.SystemRoleCollection();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "select * from tblSystemRole Order by RoleName;";
cmd.CommandType = System.Data.CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SystemRole role = new SystemRole();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(role, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(role);
}
}
}
return(result);
}
public static Domain.ClientCollection GetClientsByProviderId(string objectId)
{
Domain.ClientCollection result = new Domain.ClientCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select c.* " +
"from tblClient c " +
"join tblPhysicianClient pc on c.ClientId = pc.ClientId " +
"where pc.ProviderId = @ObjectId order by ClientName ";
cmd.Parameters.Add("@ObjectId", SqlDbType.VarChar).Value = objectId;
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.Client client = new YellowstonePathology.Business.Client.Model.Client();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(client, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(client);
}
}
}
return result;
}
public static YellowstonePathology.Business.User.SystemUserCollection GetSystemUserCollection()
{
Type t = typeof(YellowstonePathology.Business.User.SystemUserCollection);
ConstructorInfo ci = t.GetConstructor(BindingFlags.Instance | BindingFlags.NonPublic, null, new Type[0], null);
YellowstonePathology.Business.User.SystemUserCollection systemUserCollection = (YellowstonePathology.Business.User.SystemUserCollection)ci.Invoke(null);
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "select UserId, Active, UserName, FirstName, LastName, MiddleInitial, Initials, Signature, DisplayName, " +
"EmailAddress, NationalProviderId from tblSystemUser order by UserName; " +
"select * from tblSystemUserRole;";
cmd.CommandType = System.Data.CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUser systemUser = new SystemUser();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUser, dr);
sqlDataReaderPropertyWriter.WriteProperties();
systemUserCollection.Add(systemUser);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.User.SystemUserRole systemUserRole = new SystemUserRole();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(systemUserRole, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (SystemUser systemUser in systemUserCollection)
{
if (systemUser.UserId == systemUserRole.UserID)
{
systemUser.SystemUserRoleCollection.Add(systemUserRole);
break;
}
}
}
}
}
return(systemUserCollection);
}
public static YellowstonePathology.Business.Client.Model.ClientCollection GetClientCollectionByClientGroupId(int clientGroupId)
{
YellowstonePathology.Business.Client.Model.ClientCollection result = new Client.Model.ClientCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select c.* " +
"from tblClientGroup cg " +
"join tblClientGroupClient cgc on cg.ClientGroupId = cgc.ClientGroupId " +
"join tblclient c on cgc.ClientId = c.ClientId " +
"where cgc.ClientGroupId = @ClientGroupId order by c.ClientName";
cmd.Parameters.Add("@ClientGroupId", SqlDbType.Int).Value = clientGroupId;
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.Client client = new YellowstonePathology.Business.Client.Model.Client();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(client, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(client);
}
}
}
return result;
}
public static YellowstonePathology.Business.Client.Model.PhysicianClientDistributionCollection GetPhysicianClientDistributionByPhysicianClientId(string physicianClientId)
{
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionCollection result = new Client.Model.PhysicianClientDistributionCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblPhysicianClientDistribution where PhysicianClientId = @PhysicianClientId";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@PhysicianClientId", SqlDbType.VarChar).Value = physicianClientId;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.PhysicianClientDistribution physicianClientDistribution = new Client.Model.PhysicianClientDistribution();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientDistribution);
}
}
}
return result;
}
public void BuildClientOrderDetailCollection(YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailCollection clientOrderDetailCollection)
{
int clientOrderDetailCount = 0;
while (this.m_DataReader.Read())
{
clientOrderDetailCount = Convert.ToInt32(this.m_DataReader["ClientOrderDetailCount"].ToString());
}
if (clientOrderDetailCount > 0)
{
for (int i = 0; i < clientOrderDetailCount; i++)
{
this.m_DataReader.NextResult();
string orderTypeCode = null;
while (this.m_DataReader.Read())
{
orderTypeCode = this.m_DataReader["OrderTypeCode"].ToString();
}
this.m_DataReader.NextResult();
YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail = YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailFactory.GetClientOrderDetail(orderTypeCode, Persistence.PersistenceModeEnum.UpdateChangedProperties);
while (this.m_DataReader.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrderDetail, this.m_DataReader);
propertyWriter.WriteProperties();
clientOrderDetailCollection.Add(clientOrderDetail);
}
}
}
else
{
this.m_DataReader.NextResult();
this.m_DataReader.NextResult();
}
}
public static List<YellowstonePathology.Business.Client.Model.PhysicianClientDistributionView> GetPhysicianClientDistributionsV2(string physicianClientId)
{
List<YellowstonePathology.Business.Client.Model.PhysicianClientDistributionView> result = new List<YellowstonePathology.Business.Client.Model.PhysicianClientDistributionView>();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select pcd.*, c.ClientId, c.ClientName, ph.PhysicianId, ph.ObjectId as ProviderId, ph.DisplayName [PhysicianName], c.DistributionType " +
"from tblPhysicianClient pc " +
"join tblPhysicianClientDistribution pcd on pc.PhysicianClientId = pcd.PhysicianClientId " +
"join tblPhysicianClient pc2 on pcd.DistributionId = pc2.PhysicianClientId " +
"join tblClient c on pc2.ClientId = c.ClientId " +
"join tblPhysician ph on pc2.ProviderId = ph.ObjectId " +
"where pc.PhysicianClientId = @PhysicianClientId ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@PhysicianClientId", SqlDbType.VarChar).Value = physicianClientId;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.PhysicianClientDistribution physicianClientDistribution = new YellowstonePathology.Business.Client.Model.PhysicianClientDistribution();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistribution, dr);
sqlDataReaderPropertyWriter.WriteProperties();
YellowstonePathology.Business.Client.Model.PhysicianClientDistributionView physicianClientDistributionView = new YellowstonePathology.Business.Client.Model.PhysicianClientDistributionView(physicianClientDistribution);
sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientDistributionView, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientDistributionView);
}
}
}
return result;
}
private object ExcuteCommandAndBuild(MySqlCommand cmd, Type topLevelType)
{
object result = null;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result = Activator.CreateInstance(topLevelType);
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return(result);
}
public static YellowstonePathology.Business.Client.PhysicianClientCollection GetPhysicianClientListByPhysicianLastNameV2(string physicianLastName)
{
YellowstonePathology.Business.Client.PhysicianClientCollection result = new Client.PhysicianClientCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select pp.PhysicianClientId, c.ClientId, c.ClientName, ph.PhysicianId, ph.ObjectId [ProviderId], ph.DisplayName [PhysicianName], c.DistributionType, c.Fax [FaxNumber], c.Telephone, c.LongDistance, c.FacilityType, ph.NPI " +
"from tblClient c " +
"join tblPhysicianClient pp on c.clientid = pp.clientid " +
"Join tblPhysician ph on pp.ProviderId = ph.ObjectId " +
"where ph.LastName like @LastName + '%' order by ph.LastName, ph.FirstName, c.ClientName";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(@"LastName", SqlDbType.VarChar, 50).Value = physicianLastName;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.PhysicianClient physicianClient = new Client.PhysicianClient();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClient, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClient);
}
}
}
return result;
}
public static YellowstonePathology.Business.Billing.Model.EODProcessStatus GetBillingEODProcessStatus(DateTime processDate)
{
YellowstonePathology.Business.Billing.Model.EODProcessStatus result = new Billing.Model.EODProcessStatus();
MySqlCommand cmd = new MySqlCommand("Select * from tblBillingEODProcess where ProcessDate = @ProcessDate;");
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ProcessDate", processDate);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return(result);
}
public static YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection GetPhysicianClientNameCollectionV2(string physicianClientId)
{
YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection result = new YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select pc.PhysicianClientId, pc.ClientId, pc.PhysicianId, pc.ProviderId, c.ClientName, p.FirstName, p.LastName, c.Telephone, c.Fax " +
"from tblPhysicianClient pc join tblClient c on pc.ClientId = c.ClientId " +
"join tblPhysician p on pc.ProviderId = p.ObjectId " +
"where p.ObjectId = (select ProviderId from tblPhysicianClient where PhysicianClientId = @PhysicianClientId) order by c.ClientName";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@PhysicianClientId", SqlDbType.VarChar).Value = physicianClientId;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.PhysicianClientName physicianClientName = new YellowstonePathology.Business.Client.Model.PhysicianClientName();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientName, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianClientName);
}
}
}
return result;
}
private static CDMCollection Load()
{
CDMCollection result = new CDMCollection();
MySqlCommand cmd = new MySqlCommand("Select CDMCode, CPTCode, ProcedureName, CDMClient from tblCDM;");
cmd.CommandType = CommandType.Text;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
CDM cdms = new Model.CDM();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(cdms, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(cdms);
}
}
}
return(result);
}
public static YellowstonePathology.Business.Client.Model.PhysicianNameViewCollection GetPhysicianNameViewCollectionByPhysicianLastNameV2(string physicianLastName)
{
YellowstonePathology.Business.Client.Model.PhysicianNameViewCollection result = new YellowstonePathology.Business.Client.Model.PhysicianNameViewCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select ph.PhysicianId, ph.ObjectId as ProviderId, ph.FirstName, ph.LastName, c.Telephone [HomeBasePhone], c.Fax [HomeBaseFax] " +
"from tblPhysician ph " +
"left outer join tblClient c on ph.HomeBaseClientId = c.ClientId " +
"where ph.LastName like @LastName + '%' order by ph.FirstName ";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = physicianLastName;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.PhysicianNameView physicianNameView = new YellowstonePathology.Business.Client.Model.PhysicianNameView();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianNameView, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(physicianNameView);
}
}
}
return result;
}
public static YellowstonePathology.Business.Client.Model.ClientGroupClientCollection GetClientGroupClientCollectionByClientGroupId(List<int> clientGroupIds)
{
string inClause = YellowstonePathology.Business.Helper.IdListHelper.ToIdString(clientGroupIds);
YellowstonePathology.Business.Client.Model.ClientGroupClientCollection result = new Client.Model.ClientGroupClientCollection();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblClientGroupClient where ClientGroupId in (" + inClause + ")";
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientGroupClient clientGroupClient = new Client.Model.ClientGroupClient();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientGroupClient, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(clientGroupClient);
}
}
}
return result;
}
public static YellowstonePathology.Business.Reports.LabOrderSheetData GetOrdersToAcknowledge(string panelOrderIds)
{
Reports.LabOrderSheetData result = new Reports.LabOrderSheetData();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "pGetXmlOrdersToAcknowledge_A2";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("PanelOrderIdString", panelOrderIds);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Reports.LabOrderSheetDataReport labOrderSheetDataReport = new Reports.LabOrderSheetDataReport();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(labOrderSheetDataReport, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(labOrderSheetDataReport);
}
dr.NextResult();
while (dr.Read())
{
Reports.LabOrderSheetDataPanelOrder labOrderSheetDataPanelOrder = new Reports.LabOrderSheetDataPanelOrder();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(labOrderSheetDataPanelOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (Reports.LabOrderSheetDataReport labOrderSheetDataReport in result)
{
if (labOrderSheetDataReport.ReportNo == labOrderSheetDataPanelOrder.ReportNo)
{
labOrderSheetDataReport.LabOrderSheetDataPanelOrders.Add(labOrderSheetDataPanelOrder);
break;
}
}
}
dr.NextResult();
while (dr.Read())
{
Reports.LabOrderSheetDataTestOrder labOrderSheetDataTestOrder = new Reports.LabOrderSheetDataTestOrder();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(labOrderSheetDataTestOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
foreach (Reports.LabOrderSheetDataReport labOrderSheetDataReport in result)
{
bool added = false;
foreach (Reports.LabOrderSheetDataPanelOrder labOrderSheetDataPanelOrder in labOrderSheetDataReport.LabOrderSheetDataPanelOrders)
{
if (labOrderSheetDataPanelOrder.PanelOrderId == labOrderSheetDataTestOrder.PanelOrderId)
{
labOrderSheetDataPanelOrder.LabOrderSheetDataTestOrders.Add(labOrderSheetDataTestOrder);
added = true;
break;
}
}
if (added == true)
{
break;
}
}
}
}
}
return(result);
}
public static YellowstonePathology.Business.ClientOrder.Model.ClientOrder BuildClientOrder(MySqlDataReader dr)
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrder clientOrder = null;
Nullable <int> panelSetId = null;
while (dr.Read())
{
if (dr["PanelSetId"] != DBNull.Value)
{
panelSetId = Convert.ToInt32(dr["PanelSetId"].ToString());
}
}
clientOrder = YellowstonePathology.Business.ClientOrder.Model.ClientOrderFactory.GetClientOrder(panelSetId);
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrder, dr);
propertyWriter.WriteProperties();
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientLocation clientLocation = new YellowstonePathology.Business.Client.Model.ClientLocation();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter(clientLocation, dr);
propertyWriter.WriteProperties();
clientOrder.ClientLocation = clientLocation;
}
return(clientOrder);
}
public static YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail BuildClientOrderDetail(MySqlCommand cmd)
{
YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail clientOrderDetail = null;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
string orderTypeCode = null;
while (dr.Read())
{
orderTypeCode = dr["OrderTypeCode"].ToString();
}
if (string.IsNullOrEmpty(orderTypeCode) == false)
{
dr.NextResult();
clientOrderDetail = YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetailFactory.GetClientOrderDetail(orderTypeCode, Persistence.PersistenceModeEnum.UpdateChangedProperties);
while (dr.Read())
{
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrderDetail, dr);
propertyWriter.WriteProperties();
}
}
else
{
dr.NextResult();
while (dr.Read())
{
clientOrderDetail = new YellowstonePathology.Business.ClientOrder.Model.ClientOrderDetail();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter propertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientOrderDetail, dr);
propertyWriter.WriteProperties();
}
}
}
}
return(clientOrderDetail);
}
