private static YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder BuildReportOrderAbsoluteCD4Count(string reportNo)
{
YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder reportAbsoluteCD4Count = null;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select * " +
"from tblAbsoluteCD4CountTestOrder ro " +
"join tblPanelSetOrder pso on ro.ReportNo = pso.ReportNo " +
"where ro.ReportNo = @ReportNo;";
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ReportNo", reportNo);
cmd.Connection = cn;
using (MySqlDataReader 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);
}
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 void UpdateReportOrderAbsoluteCD4Count(YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder reportOrderAbsoluteCD4Count)
{
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Update tblMolecularAnalysisTestOrder set ReportNo = @ReportNo, CD3Result = @CD3Result, CD4Result = @CD4Result, CD8Result = @CD8Result, CD4CD8Ratio = @CD4CD8Ratio, Interpretation = @Interpretation where ReportOrderAbsoluteCD4CountId = @ReportOrderAbsoluteCD4CountId";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@ReportNo", SqlDbType.VarChar).Value = reportOrderAbsoluteCD4Count.ReportNo;
cmd.Parameters.Add("@CD3Result", SqlDbType.VarChar).Value = reportOrderAbsoluteCD4Count.CD3Result;
cmd.Parameters.Add("@CD4Result", SqlDbType.VarChar).Value = reportOrderAbsoluteCD4Count.CD4Result;
cmd.Parameters.Add("@CD8Result", SqlDbType.VarChar).Value = reportOrderAbsoluteCD4Count.CD8Result;
cmd.Parameters.Add("@CD4CD8Ratio", SqlDbType.VarChar).Value = reportOrderAbsoluteCD4Count.CD4CD8Ratio;
cmd.Parameters.Add("@Interpretation", SqlDbType.VarChar).Value = reportOrderAbsoluteCD4Count.Interpretation;
cmd.Connection = cn;
cmd.ExecuteNonQuery();
}
}
public ReportOrderAbsoluteCD4CountDialog(YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder reportOrderAbsoluteCD4Count)
{
this.m_ReportOrder = reportOrderAbsoluteCD4Count;
InitializeComponent();
this.DataContext = this;
}
public ReportOrderAbsoluteCD4CountDialog(YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder reportOrderAbsoluteCD4Count)
{
this.m_ReportOrder = reportOrderAbsoluteCD4Count;
InitializeComponent();
this.DataContext = this;
}
public static void ShowDialog(YellowstonePathology.Business.Test.PanelSetOrder reportOrder)
{
if (reportOrder != null)
{
switch (reportOrder.PanelSetId)
{
case 51: //Fish Analysis
YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder reportOrderFishAnalysis = (YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder)reportOrder;
YellowstonePathology.UI.ReportOrder.ReportOrderFishAnalysisDialog reportOrderFishDialog = new ReportOrderFishAnalysisDialog(reportOrderFishAnalysis);
reportOrderFishDialog.ShowDialog();
break;
case 52: //Molecular Analysis
YellowstonePathology.Business.Test.MolecularAnalysis.MolecularAnalysisTestOrder reportOrderMolecularAnalysis = (YellowstonePathology.Business.Test.MolecularAnalysis.MolecularAnalysisTestOrder)reportOrder;
YellowstonePathology.UI.ReportOrder.ReportOrderMolecularAnalysisDialog reportOrderMolecularDialog = new ReportOrderMolecularAnalysisDialog(reportOrderMolecularAnalysis);
reportOrderMolecularDialog.ShowDialog();
break;
case 53: //Absolute CD4 Count
YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder reportOrderAbsolutCD4Count = (YellowstonePathology.Business.Test.AbsoluteCD4Count.AbsoluteCD4CountTestOrder)reportOrder;
YellowstonePathology.UI.ReportOrder.ReportOrderAbsoluteCD4CountDialog reportOrderAbsolutCD4CountDialog = new ReportOrderAbsoluteCD4CountDialog(reportOrderAbsolutCD4Count);
reportOrderAbsolutCD4CountDialog.ShowDialog();
break;
}
}
}
