private void ButtonAddReferringProviderClient_Click(object sender, RoutedEventArgs e) { if (this.ListBoxReferringProviders.SelectedItem != null) { YellowstonePathology.Business.Client.Model.PhysicianClientName physicianClientName = (YellowstonePathology.Business.Client.Model.PhysicianClientName) this.ListBoxReferringProviders.SelectedItem; this.m_Client.ReferringProviderClientId = physicianClientName.PhysicianClientId; this.m_Client.ReferringProviderClientName = physicianClientName.DisplayName; this.m_Client.HasReferringProvider = true; } }
public static YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection GetPhysicianClientNameCollection(string clientName, string physicianName) { YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection result = new YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection(); YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection physicianClientCollection = server.Database.GetCollection <BsonDocument>("PhysicianClient"); MongoCollection physicianCollection = server.Database.GetCollection <BsonDocument>("Physician"); MongoCollection clientCollection = server.Database.GetCollection <BsonDocument>("Client"); MongoCursor clientCursor = clientCollection.FindAs <BsonDocument>(Query.Matches("ClientName", BsonRegularExpression.Create("^" + clientName + ".*", "i"))).SetSortOrder(SortBy.Ascending("ClientName")); string physicianClientId = string.Empty; long count = clientCursor.Count(); foreach (BsonDocument clientDocument in clientCursor) { BsonValue clientId = clientDocument.GetValue("ClientId"); MongoCursor physicianClientCursor = physicianClientCollection.FindAs <BsonDocument>(Query.EQ("ClientId", clientId)); List <BsonValue> physicianIdList = new List <BsonValue>(); foreach (BsonDocument physicianClientDocument in physicianClientCursor) { physicianIdList.Add(physicianClientDocument.GetValue("PhysicianId")); } MongoCursor physicianCursor = physicianCollection.FindAs <BsonDocument>(Query.And(Query.In("PhysicianId", physicianIdList), Query.Matches("LastName", BsonRegularExpression.Create("^" + physicianName + ".*", "i")))).SetSortOrder(SortBy.Ascending("LastName", "FirstName")); foreach (BsonDocument physicianDocument in physicianCursor) { foreach (BsonDocument physicianClientDocument in physicianClientCursor) { if (physicianClientDocument.GetValue("PhysicianId").Equals(physicianDocument.GetValue("PhysicianId")) && physicianClientDocument.GetValue("ClientId").Equals(clientId)) { physicianClientId = Mongo.ValueHelper.GetStringValue(physicianClientDocument.GetValue("PhysicianClientId")); break; } } YellowstonePathology.Business.Client.Model.PhysicianClientName physicianClientName = new YellowstonePathology.Business.Client.Model.PhysicianClientName(); physicianClientName.ClientId = clientId.AsInt32; physicianClientName.ClientName = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("ClientName")); physicianClientName.Fax = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Fax")); physicianClientName.FirstName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("FirstName")); physicianClientName.LastName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("LastName")); physicianClientName.PhysicianClientId = physicianClientId; physicianClientName.PhysicianId = physicianDocument.GetValue("PhysicianId").AsInt32; physicianClientName.Telephone = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Telephone")); result.Add(physicianClientName); } } return(result); }
public static YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection GetPhysicianClientNameCollection(string physicianClientId) { YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection result = new YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection(); YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection physicianClientCollection = server.Database.GetCollection <BsonDocument>("PhysicianClient"); MongoCollection physicianCollection = server.Database.GetCollection <BsonDocument>("Physician"); MongoCollection clientCollection = server.Database.GetCollection <BsonDocument>("Client"); BsonDocument pcDocument = physicianClientCollection.FindOneAs <BsonDocument>(Query.EQ("PhysicianClientId", physicianClientId)); BsonValue physicianId = pcDocument.GetValue("PhysicianId"); BsonDocument physicianDocument = physicianCollection.FindOneAs <BsonDocument>(Query.EQ("PhysicianId", physicianId)); MongoCursor physicianClientCursor = physicianClientCollection.FindAs <BsonDocument>(Query.EQ("PhysicianId", physicianId)); List <BsonValue> clientIdList = new List <BsonValue>(); foreach (BsonDocument physicianClientDocument in physicianClientCursor) { clientIdList.Add(physicianClientDocument.GetValue("ClientId")); } MongoCursor clientCursor = clientCollection.FindAs <BsonDocument>(Query.In("ClientId", clientIdList)).SetSortOrder(SortBy.Ascending("ClientName")); foreach (BsonDocument clientDocument in clientCursor) { foreach (BsonDocument physicianClientDocument in physicianClientCursor) { if (physicianClientDocument.GetValue("ClientId").Equals(clientDocument.GetValue("ClientId"))) { physicianClientId = Mongo.ValueHelper.GetStringValue(physicianClientDocument.GetValue("PhysicianClientId")); break; } } YellowstonePathology.Business.Client.Model.PhysicianClientName physicianClientName = new YellowstonePathology.Business.Client.Model.PhysicianClientName(); physicianClientName.ClientId = clientDocument.GetValue("ClientId").AsInt32; physicianClientName.ClientName = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("ClientName")); physicianClientName.Fax = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Fax")); physicianClientName.FirstName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("FirstName")); physicianClientName.LastName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("LastName")); physicianClientName.PhysicianClientId = physicianClientId; physicianClientName.PhysicianId = physicianDocument.GetValue("PhysicianId").AsInt32; physicianClientName.Telephone = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Telephone")); result.Add(physicianClientName); } return(result); }
public static YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection GetPhysicianClientNameCollection(string physicianClientId) { YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection result = new YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection(); YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection physicianClientCollection = server.Database.GetCollection<BsonDocument>("PhysicianClient"); MongoCollection physicianCollection = server.Database.GetCollection<BsonDocument>("Physician"); MongoCollection clientCollection = server.Database.GetCollection<BsonDocument>("Client"); BsonDocument pcDocument = physicianClientCollection.FindOneAs<BsonDocument>(Query.EQ("PhysicianClientId", physicianClientId)); BsonValue physicianId = pcDocument.GetValue("PhysicianId"); BsonDocument physicianDocument = physicianCollection.FindOneAs<BsonDocument>(Query.EQ("PhysicianId", physicianId)); MongoCursor physicianClientCursor = physicianClientCollection.FindAs<BsonDocument>(Query.EQ("PhysicianId", physicianId)); List<BsonValue> clientIdList = new List<BsonValue>(); foreach(BsonDocument physicianClientDocument in physicianClientCursor) { clientIdList.Add(physicianClientDocument.GetValue("ClientId")); } MongoCursor clientCursor = clientCollection.FindAs<BsonDocument>(Query.In("ClientId", clientIdList)).SetSortOrder(SortBy.Ascending("ClientName")); foreach(BsonDocument clientDocument in clientCursor) { foreach (BsonDocument physicianClientDocument in physicianClientCursor) { if (physicianClientDocument.GetValue("ClientId").Equals(clientDocument.GetValue("ClientId"))) { physicianClientId = Mongo.ValueHelper.GetStringValue(physicianClientDocument.GetValue("PhysicianClientId")); break; } } YellowstonePathology.Business.Client.Model.PhysicianClientName physicianClientName = new YellowstonePathology.Business.Client.Model.PhysicianClientName(); physicianClientName.ClientId = clientDocument.GetValue("ClientId").AsInt32; physicianClientName.ClientName = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("ClientName")); physicianClientName.Fax = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Fax")); physicianClientName.FirstName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("FirstName")); physicianClientName.LastName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("LastName")); physicianClientName.PhysicianClientId = physicianClientId; physicianClientName.PhysicianId = physicianDocument.GetValue("PhysicianId").AsInt32; physicianClientName.Telephone = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Telephone")); result.Add(physicianClientName); } return result; }
public static YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection GetPhysicianClientNameCollection(string clientName, string physicianName) { YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection result = new YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection(); YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName); MongoCollection physicianClientCollection = server.Database.GetCollection<BsonDocument>("PhysicianClient"); MongoCollection physicianCollection = server.Database.GetCollection<BsonDocument>("Physician"); MongoCollection clientCollection = server.Database.GetCollection<BsonDocument>("Client"); MongoCursor clientCursor = clientCollection.FindAs<BsonDocument>(Query.Matches("ClientName", BsonRegularExpression.Create("^" + clientName + ".*", "i"))).SetSortOrder(SortBy.Ascending("ClientName")); string physicianClientId = string.Empty; long count = clientCursor.Count(); foreach (BsonDocument clientDocument in clientCursor) { BsonValue clientId = clientDocument.GetValue("ClientId"); MongoCursor physicianClientCursor = physicianClientCollection.FindAs<BsonDocument>(Query.EQ("ClientId", clientId)); List<BsonValue> physicianIdList = new List<BsonValue>(); foreach (BsonDocument physicianClientDocument in physicianClientCursor) { physicianIdList.Add(physicianClientDocument.GetValue("PhysicianId")); } MongoCursor physicianCursor = physicianCollection.FindAs<BsonDocument>(Query.And(Query.In("PhysicianId", physicianIdList), Query.Matches("LastName", BsonRegularExpression.Create("^" + physicianName + ".*", "i")))).SetSortOrder(SortBy.Ascending("LastName", "FirstName")); foreach (BsonDocument physicianDocument in physicianCursor) { foreach (BsonDocument physicianClientDocument in physicianClientCursor) { if (physicianClientDocument.GetValue("PhysicianId").Equals(physicianDocument.GetValue("PhysicianId")) && physicianClientDocument.GetValue("ClientId").Equals(clientId)) { physicianClientId = Mongo.ValueHelper.GetStringValue(physicianClientDocument.GetValue("PhysicianClientId")); break; } } YellowstonePathology.Business.Client.Model.PhysicianClientName physicianClientName = new YellowstonePathology.Business.Client.Model.PhysicianClientName(); physicianClientName.ClientId = clientId.AsInt32; physicianClientName.ClientName = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("ClientName")); physicianClientName.Fax = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Fax")); physicianClientName.FirstName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("FirstName")); physicianClientName.LastName = Mongo.ValueHelper.GetStringValue(physicianDocument.GetValue("LastName")); physicianClientName.PhysicianClientId = physicianClientId; physicianClientName.PhysicianId = physicianDocument.GetValue("PhysicianId").AsInt32; physicianClientName.Telephone = Mongo.ValueHelper.GetStringValue(clientDocument.GetValue("Telephone")); result.Add(physicianClientName); } } return result; }
public static YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection GetPhysicianClientNameCollectionV2(string physicianClientId) { YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection result = new YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "select pc.PhysicianClientId, pc.ClientId, pc.PhysicianId, pc.ProviderId, c.ClientName, p.FirstName, p.LastName, c.Telephone, c.Fax " + "from tblPhysicianClient pc join tblClient c on pc.ClientId = c.ClientId " + "join tblPhysician p on pc.ProviderId = p.ObjectId " + "where p.ObjectId = (select ProviderId from tblPhysicianClient where PhysicianClientId = @PhysicianClientId) order by c.ClientName"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@PhysicianClientId", SqlDbType.VarChar).Value = physicianClientId; using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.BaseData.SqlConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.Client.Model.PhysicianClientName physicianClientName = new YellowstonePathology.Business.Client.Model.PhysicianClientName(); YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physicianClientName, dr); sqlDataReaderPropertyWriter.WriteProperties(); result.Add(physicianClientName); } } } return result; }