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 Test.ThinPrepPap.AcidWashList GetAcidWashList(DateTime startDate)
{
Test.ThinPrepPap.AcidWashList result = new Test.ThinPrepPap.AcidWashList();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "Select pso.MasterAccessionNo, po.ReportNo, po.OrderTime, po.Accepted, a.PLastName, a.PFirstName, a.PMiddleInitial, po.Comment, su.UserName " +
"from tblPanelOrder po " +
"join tblSystemUser su on po.OrderedById = su.UserId " +
"join tblPanelSetOrder pso on po.ReportNo = pso.ReportNo " +
"join tblAccessionOrder a on pso.MasterAccessionNo = a.MasterAccessionNo where po.PanelId = 39 and po.OrderTime >= @StartDate " +
"order by po.OrderTime Desc;";
cmd.Parameters.AddWithValue("@StartDate", startDate);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader 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);
}
}
}
result.SetState();
return(result);
}
