C# (CSharp) YellowstonePathology.Business.Client.Model.PhysicianCollection Exemples

Exemple #1

        public static YellowstonePathology.Business.Client.Model.PhysicianCollection GetPhysiciansByClientId(int clientId)
        {
            YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection = null;

            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = "Select ph.* " +
                              "from tblPhysician ph " +
                              "join tblPhysicianClient pc on ph.PhysicianId = pc.PhysicianId " +
                              "join tblClient c on pc.ClientId = c.ClientId " +
                              "where c.ClientId = @ClientId for xml path('Physician'), root('PhysicianCollection')";
            cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
            cmd.CommandType = System.Data.CommandType.Text;

            try
            {
                //physicianCollection = YellowstonePathology.Business.Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteXmlCommand<YellowstonePathology.YpiConnect.Contract.Domain.PhysicianCollection>(cmd, Business.Domain.Persistence.DataLocationEnum.ProductionData);
            }
            catch (Exception)
            {
                physicianCollection = new YellowstonePathology.Business.Client.Model.PhysicianCollection();
            }

            return(physicianCollection);
        }

Exemple #2

Fichier : ClientOrderGateway.cs Projet : ericramses/YPILIS

        public static YellowstonePathology.Business.Client.Model.PhysicianCollection GetPhysiciansByClientId(int clientId)
        {
            YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection = null;

            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "Select ph.* " +
                "from tblPhysician ph " +
                "join tblPhysicianClient pc on ph.PhysicianId = pc.PhysicianId " +
                "join tblClient c on pc.ClientId = c.ClientId " +
                "where c.ClientId = @ClientId for xml path('Physician'), root('PhysicianCollection')";
            cmd.Parameters.Add("@ClientId", SqlDbType.Int).Value = clientId;
            cmd.CommandType = System.Data.CommandType.Text;

            try
            {
                //physicianCollection = YellowstonePathology.Business.Domain.Persistence.SqlXmlPersistence.CrudOperations.ExecuteXmlCommand<YellowstonePathology.YpiConnect.Contract.Domain.PhysicianCollection>(cmd, Business.Domain.Persistence.DataLocationEnum.ProductionData);
            }
            catch (Exception)
            {
                physicianCollection = new YellowstonePathology.Business.Client.Model.PhysicianCollection();
            }

            return physicianCollection;
        }

Exemple #3

Fichier : ClientOrderServiceProxy.cs Projet : waffle-iron/YPILIS

 public YellowstonePathology.Business.Client.Model.PhysicianCollection GetPhysiciansByClientId(int clientId)
 {
     YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection = this.m_ClientOrderChannel.GetPhysiciansByClientId(clientId);
     return(physicianCollection);
 }

Exemple #4

Fichier : PhysicianCollectionView.cs Projet : WilliamCopland/YPILIS

 public PhysicianCollectionView(YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection)
 {
     this.m_Source = physicianCollection;
     this.SortByLastName();
 }

Exemple #5

Fichier : PhysicianCollectionView.cs Projet : waffle-iron/YPILIS

 public PhysicianCollectionView(YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection)
 {
     this.m_Source = physicianCollection;
     this.SortByLastName();
 }