public static View.AccessionSlideOrderViewCollection GetAccessionSlideOrderViewCollectionByBatchId(string batchId) { View.AccessionSlideOrderViewCollection result = new View.AccessionSlideOrderViewCollection(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "Select slo.* from tblSlideOrder slo join tblMaterialTrackingLog mtl on slo.SlideOrderId = mtl.MaterialId " + "join tblTestOrder t on slo.TestOrderId = t.TestOrderId " + "join tblPanelOrder po on t.PanelOrderId = po.PanelOrderId " + "where mtl.MaterialTrackingBatchId = @BatchId order by slo.SlideOrderId; " + "Select ao.MasterAccessionNo, ao.PLastName, ao.PFirstName, ao.ClientId, ao.ClientName, ao.PhysicianId, " + "ao.PhysicianName, po.ReportNo, asl.SlideOrderId " + "from tblAccessionOrder ao " + "join tblSpecimenOrder so on ao.MasterAccessionNo = so.MasterAccessionNo " + "join tblAliquotOrder a on so.specimenOrderId = a.SpecimenOrderId " + "join tblSlideOrder asl on a.AliquotOrderId = asl.AliquotOrderId " + "join tblMaterialTrackingLog astl on asl.SlideOrderId = astl.MaterialId " + "join tblTestOrder t on asl.TestOrderId = t.TestOrderId " + "join tblPanelOrder po on t.PanelOrderId = po.PanelOrderId " + "where astl.MaterialTrackingBatchId = @BatchId;"; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@BatchId", batchId); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { View.AccessionSlideOrderView accessionSlideOrderView = new View.AccessionSlideOrderView(); Slide.Model.SlideOrder slideOrder = new Slide.Model.SlideOrder(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(slideOrder, dr); sqlDataReaderPropertyWriter.WriteProperties(); accessionSlideOrderView.SlideOrder = slideOrder; result.Add(accessionSlideOrderView); } dr.NextResult(); while (dr.Read()) { string slideOrderId = dr["SlideOrderId"].ToString(); foreach (View.AccessionSlideOrderView accessionSlideOrderView in result) { if (accessionSlideOrderView.SlideOrder.SlideOrderId == slideOrderId) { YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(accessionSlideOrderView, dr); sqlDataReaderPropertyWriter.WriteProperties(); break; } } } } } return(result); }
public static View.AccessionSlideOrderView GetAccessionSlideOrderViewBySlideOrderId(string slideOrderId) { View.AccessionSlideOrderView result = null; MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "Select ao.MasterAccessionNo, ao.PLastName, ao.PFirstName, ao.ClientId, ao.ClientName, " + "ao.PhysicianId, ao.PhysicianName, pso.ReportNo " + "from tblSlideOrder asl " + "join tblTestOrder t on asl.TestOrderId = t.TestOrderId " + "join tblPanelOrder po on t.PanelOrderId = po.PanelOrderId " + "join tblPanelSetOrder pso on po.ReportNo = pso.ReportNo " + "join tblAccessionOrder ao on pso.MasterAccessionNo = ao.MasterAccessionNo " + "where asl.SlideOrderId = @SlideOrderId; " + "Select * from tblSlideOrder where SlideOrderId = @SlideOrderId;"; cmd.CommandType = System.Data.CommandType.Text; cmd.Parameters.AddWithValue("@SlideOrderId", slideOrderId); using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString)) { cn.Open(); cmd.Connection = cn; using (MySqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { result = new View.AccessionSlideOrderView(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(result, dr); sqlDataReaderPropertyWriter.WriteProperties(); } dr.NextResult(); while (dr.Read()) { Slide.Model.SlideOrder slideOrder = new Slide.Model.SlideOrder(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(slideOrder, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.SlideOrder = slideOrder; } } } return(result); }
public override object BuildNew() { YellowstonePathology.Business.Slide.Model.SlideOrder slideOrder = new Slide.Model.SlideOrder(); this.Build(slideOrder); return(slideOrder); }