private static YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder BuildReportOrderFishAnalysis(string reportNo)
{
YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder reportFishAnalysis = null;
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "Select * " +
"from tblFishAnalysisTestOrder 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())
{
reportFishAnalysis = new YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(reportFishAnalysis, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return(reportFishAnalysis);
}
public ReportOrderFishAnalysisDialog(YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder reportOrderFishAnalaysis)
{
this.m_ReportOrderFishAnalysis = reportOrderFishAnalaysis;
InitializeComponent();
this.DataContext = this;
}
public ReportOrderFishAnalysisDialog(YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder reportOrderFishAnalaysis)
{
this.m_ReportOrderFishAnalysis = reportOrderFishAnalaysis;
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;
}
}
}
private static YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder BuildReportOrderFishAnalysis(string reportNo)
{
YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder reportFishAnalysis = null;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * " +
"from tblFishAnalysisTestOrder 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())
{
reportFishAnalysis = new YellowstonePathology.Business.Test.FishAnalysis.FishAnalysisTestOrder();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(reportFishAnalysis, dr);
sqlDataReaderPropertyWriter.WriteProperties();
}
}
}
return reportFishAnalysis;
}
