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); }
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; }
public YellowstonePathology.Business.Client.Model.PhysicianCollection GetPhysiciansByClientId(int clientId) { YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection = this.m_ClientOrderChannel.GetPhysiciansByClientId(clientId); return(physicianCollection); }
public PhysicianCollectionView(YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection) { this.m_Source = physicianCollection; this.SortByLastName(); }
public PhysicianCollectionView(YellowstonePathology.Business.Client.Model.PhysicianCollection physicianCollection) { this.m_Source = physicianCollection; this.SortByLastName(); }