public static YellowstonePathology.Business.Client.Model.ClientCollection GetClientsByClientName(string clientName)
{
YellowstonePathology.Business.Client.Model.ClientCollection result = new YellowstonePathology.Business.Client.Model.ClientCollection();
YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName);
MongoCollection collection = server.Database.GetCollection <BsonDocument>("Client");
MongoCursor cursor = collection.FindAs <BsonDocument>(Query.Matches("ClientName", BsonRegularExpression.Create("^" + clientName + ".*", "i")));
foreach (BsonDocument bsonDocument in cursor)
{
YellowstonePathology.Business.Client.Model.Client client = (YellowstonePathology.Business.Client.Model.Client)YellowstonePathology.Business.Mongo.BSONObjectBuilder.Build(bsonDocument, typeof(YellowstonePathology.Business.Client.Model.Client));
result.Add(client);
}
return(result);
}
public static YellowstonePathology.Business.Client.Model.ClientCollection GetAllClients()
{
YellowstonePathology.Business.Client.Model.ClientCollection result = new YellowstonePathology.Business.Client.Model.ClientCollection();
YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName);
MongoCollection collection = server.Database.GetCollection<BsonDocument>("Client");
MongoCursor cursor = collection.FindAllAs<BsonDocument>();
foreach (BsonDocument bsonDocument in cursor)
{
YellowstonePathology.Business.Client.Model.Client client = new YellowstonePathology.Business.Client.Model.Client();
YellowstonePathology.Business.Mongo.BSONPropertyWriter.Write(bsonDocument, client);
result.Add(client);
}
return result;
}
public static YellowstonePathology.Business.Client.Model.ClientCollection GetAllClients()
{
YellowstonePathology.Business.Client.Model.ClientCollection result = new YellowstonePathology.Business.Client.Model.ClientCollection();
YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName);
MongoCollection collection = server.Database.GetCollection <BsonDocument>("Client");
MongoCursor cursor = collection.FindAllAs <BsonDocument>();
foreach (BsonDocument bsonDocument in cursor)
{
YellowstonePathology.Business.Client.Model.Client client = new YellowstonePathology.Business.Client.Model.Client();
YellowstonePathology.Business.Mongo.BSONPropertyWriter.Write(bsonDocument, client);
result.Add(client);
}
return(result);
}
public static YellowstonePathology.Business.Client.Model.ClientCollection GetClientsByClientName(string clientName)
{
YellowstonePathology.Business.Client.Model.ClientCollection result = new YellowstonePathology.Business.Client.Model.ClientCollection();
YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName);
MongoCollection collection = server.Database.GetCollection<BsonDocument>("Client");
MongoCursor cursor = collection.FindAs<BsonDocument>(Query.Matches("ClientName", BsonRegularExpression.Create("^" + clientName + ".*", "i")));
foreach (BsonDocument bsonDocument in cursor)
{
YellowstonePathology.Business.Client.Model.Client client = (YellowstonePathology.Business.Client.Model.Client)YellowstonePathology.Business.Mongo.BSONObjectBuilder.Build(bsonDocument, typeof(YellowstonePathology.Business.Client.Model.Client));
result.Add(client);
}
return result;
}
private static YellowstonePathology.Business.Client.Model.ClientCollection BuildClientCollection(XElement sourceElement)
{
YellowstonePathology.Business.Client.Model.ClientCollection clientCollection = new YellowstonePathology.Business.Client.Model.ClientCollection();
if (sourceElement != null)
{
foreach (XElement clientElement in sourceElement.Elements("Client"))
{
ClientBuilder builder = new ClientBuilder();
builder.Build(clientElement);
YellowstonePathology.Business.Client.Model.Client client = builder.Client;
clientCollection.Add(client);
}
}
return clientCollection;
}
/*private static YellowstonePathology.Business.Client.Model.ProviderClient BuildHomeBaseProviderClient(XElement providerElement)
{
YellowstonePathology.Business.Client.Model.ProviderClient result = new Client.Model.ProviderClient();
YellowstonePathology.Business.Domain.Physician physician = new Domain.Physician();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriterP = new Persistence.XmlPropertyWriter(providerElement, physician);
xmlPropertyWriterP.Write();
result.Physician = physician;
XElement clientElement = providerElement.Element("Client");
if (clientElement != null)
{
YellowstonePathology.Business.Client.Model.Client client = new Client.Model.Client();
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriterC = new Persistence.XmlPropertyWriter(clientElement, client);
xmlPropertyWriterC.Write();
result.Client = client;
}
XElement providerClientElement = providerElement.Element("ProviderClient");
if (providerClientElement != null)
{
YellowstonePathology.Business.Persistence.XmlPropertyWriter xmlPropertyWriterPC = new Persistence.XmlPropertyWriter(providerClientElement, result);
xmlPropertyWriterPC.Write();
}
return result;
}*/
private static YellowstonePathology.Business.Client.Model.ProviderClientCollection BuildProviderClientCollection(SqlCommand cmd)
{
YellowstonePathology.Business.Client.Model.ProviderClientCollection result = new Client.Model.ProviderClientCollection();
YellowstonePathology.Business.Client.Model.ClientCollection clientCollection = new YellowstonePathology.Business.Client.Model.ClientCollection();
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.KeyInfo))
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ProviderClient providerClient = new Client.Model.ProviderClient();
YellowstonePathology.Business.Domain.Physician physician = new Domain.Physician();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(physician, dr);
sqlDataReaderPropertyWriter.WriteProperties();
providerClient.Physician = physician;
result.Add(providerClient);
}
dr.NextResult();
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.Client client = new YellowstonePathology.Business.Client.Model.Client();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(client, dr);
sqlDataReaderPropertyWriter.WriteProperties();
clientCollection.Add(client);
}
dr.NextResult();
while (dr.Read())
{
string providerClientId = dr["PhysicianClientId"].ToString();
string physicianObjectId = dr["ProviderId"].ToString();
foreach(Client.Model.ProviderClient providerClient in result)
{
if(providerClient.Physician.ObjectId == physicianObjectId)
{
providerClient.PhysicianClientId = providerClientId;
break;
}
}
}
}
}
foreach (Client.Model.ProviderClient providerClient in result)
{
foreach (Client.Model.Client client in clientCollection)
{
if (client.ClientId == providerClient.Physician.HomeBaseClientId)
{
providerClient.Client = client;
break;
}
}
}
return result;
}