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;
}
private void TextBoxReferringProviderClient_KeyUp(object sender, KeyEventArgs e)
{
if (this.TextBoxReferringProviderClient.Text.Length > 0)
{
string[] splitName = this.TextBoxReferringProviderClient.Text.Split(' ');
if (splitName.Length > 1)
{
string providerName = splitName[0].Trim();
string clientName = splitName[1].Trim();
this.m_ReferringProviderClientCollection = YellowstonePathology.Business.Gateway.PhysicianClientGateway.GetPhysicianClientNameCollectionV2(clientName, providerName);
NotifyPropertyChanged("ReferringProviderClientCollection");
}
}
}
public void GetPhysicianClientNameCollection2Test()
{
YellowstonePathology.Business.Client.Model.PhysicianClientNameCollection result = YellowstonePathology.Business.Gateway.PhysicianClientGatewayMongo.GetPhysicianClientNameCollection("5650");
Assert.IsTrue(result.Count == 6);
}
