public static YellowstonePathology.Business.Slide.Model.SlideOrderCollection_Base GetSlideOrdersWithPrintRequest()
{
YellowstonePathology.Business.Slide.Model.SlideOrderCollection_Base result = new Slide.Model.SlideOrderCollection_Base();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblSlideOrder where [Status] = 'PrintRequested'";
cmd.CommandType = System.Data.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.Slide.Model.SlideOrder_Base slideOrder = new Slide.Model.SlideOrder_Base();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(slideOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(slideOrder);
}
}
}
return result;
}
public static YellowstonePathology.Business.Slide.Model.SlideOrderCollection_Base GetSlideOrdersWithPrintRequest()
{
YellowstonePathology.Business.Slide.Model.SlideOrderCollection_Base result = new Slide.Model.SlideOrderCollection_Base();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select * from tblSlideOrder where [Status] = 'PrintRequested'";
cmd.CommandType = System.Data.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.Slide.Model.SlideOrder_Base slideOrder = new Slide.Model.SlideOrder_Base();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(slideOrder, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(slideOrder);
}
}
}
return(result);
}
