Esempio n. 1
0
 private static View.AccessionSlideOrderViewCollection BuildAccessionSlideOrderViewCollection(XElement sourceElement)
 {
     View.AccessionSlideOrderViewCollection accessionSlideOrderViewCollection = new View.AccessionSlideOrderViewCollection();
     if (sourceElement != null)
     {
         foreach (XElement accessionSlideOrderViewElement in sourceElement.Elements("AccessionSlideOrderView"))
         {
             AccessionSlideOrderViewBuilder builder = new AccessionSlideOrderViewBuilder();
             builder.Build(accessionSlideOrderViewElement);
             if (builder.AccessionSlideOrderView != null)
             {
                 accessionSlideOrderViewCollection.Add(builder.AccessionSlideOrderView);
             }
         }
     }
     return(accessionSlideOrderViewCollection);
 }
        public static View.AccessionSlideOrderView GetAccessionSlideOrderViewBySlideOrderId(string slideOrderId)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Select ao.MasterAccessionNo, ao.PLastName, ao.PFirstName, ao.ClientId, ao.ClientName, ao.PhysicianId, ao.PhysicianName, pso.ReportNo,  " +
                "(Select slo.* from tblSlideOrder slo  where slo.SlideOrderId = asl.SlideOrderId for xml path('SlideOrder'), type) " +
                "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 " +
                "join tblAliquotOrder a on asl.AliquotOrderId = a.AliquotOrderId " +
                "join tblSpecimenOrder so on a.SpecimenOrderId = so.SpecimenOrderId " +
                "where asl.SlideOrderId = @slideOrderId " +
                "for xml path('AccessionSlideOrderView'), type";

            cmd.CommandType = System.Data.CommandType.Text;
            cmd.Parameters.Add("@SlideOrderId", System.Data.SqlDbType.VarChar).Value = slideOrderId;
            AccessionSlideOrderViewBuilder accessionSlideOrderViewBuilder = new AccessionSlideOrderViewBuilder();
            Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteXmlReaderCommand(cmd, Domain.Persistence.DataLocationEnum.ProductionData, accessionSlideOrderViewBuilder);
            return accessionSlideOrderViewBuilder.AccessionSlideOrderView;
        }
Esempio n. 3
0
        public static View.AccessionSlideOrderView GetAccessionSlideOrderViewBySlideOrderId(string slideOrderId)
        {
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Select ao.MasterAccessionNo, ao.PLastName, ao.PFirstName, ao.ClientId, ao.ClientName, ao.PhysicianId, ao.PhysicianName, pso.ReportNo,  " +
                              "(Select slo.* from tblSlideOrder slo  where slo.SlideOrderId = asl.SlideOrderId for xml path('SlideOrder'), type) " +
                              "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 " +
                              "join tblAliquotOrder a on asl.AliquotOrderId = a.AliquotOrderId " +
                              "join tblSpecimenOrder so on a.SpecimenOrderId = so.SpecimenOrderId " +
                              "where asl.SlideOrderId = @slideOrderId " +
                              "for xml path('AccessionSlideOrderView'), type";

            cmd.CommandType = System.Data.CommandType.Text;
            cmd.Parameters.Add("@SlideOrderId", System.Data.SqlDbType.VarChar).Value = slideOrderId;
            AccessionSlideOrderViewBuilder accessionSlideOrderViewBuilder = new AccessionSlideOrderViewBuilder();

            Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteXmlReaderCommand(cmd, Domain.Persistence.DataLocationEnum.ProductionData, accessionSlideOrderViewBuilder);
            return(accessionSlideOrderViewBuilder.AccessionSlideOrderView);
        }
 private static View.AccessionSlideOrderViewCollection BuildAccessionSlideOrderViewCollection(XElement sourceElement)
 {
     View.AccessionSlideOrderViewCollection accessionSlideOrderViewCollection = new View.AccessionSlideOrderViewCollection();
     if (sourceElement != null)
     {
         foreach (XElement accessionSlideOrderViewElement in sourceElement.Elements("AccessionSlideOrderView"))
         {
             AccessionSlideOrderViewBuilder builder = new AccessionSlideOrderViewBuilder();
             builder.Build(accessionSlideOrderViewElement);
             if (builder.AccessionSlideOrderView != null)
             {
                 accessionSlideOrderViewCollection.Add(builder.AccessionSlideOrderView);
             }
         }
     }
     return accessionSlideOrderViewCollection;
 }