public static YellowstonePathology.Business.Client.Model.ClientGroupCollection GetClientGroupCollection()
{
YellowstonePathology.Business.Client.Model.ClientGroupCollection result = new Client.Model.ClientGroupCollection();
YellowstonePathology.Business.Mongo.Server server = new Business.Mongo.TestServer(YellowstonePathology.Business.Mongo.MongoTestServer.LISDatabaseName);
MongoCollection collection = server.Database.GetCollection<BsonDocument>("ClientGroup");
MongoCursor cursor = collection.FindAllAs<BsonDocument>();
foreach (BsonDocument bsonDocument in cursor)
{
YellowstonePathology.Business.Client.Model.ClientGroup clientGroup = new Client.Model.ClientGroup();
YellowstonePathology.Business.Mongo.BSONPropertyWriter.Write(bsonDocument, clientGroup);
result.Add(clientGroup);
}
return result;
}
public static YellowstonePathology.Business.Client.Model.ClientGroupCollection GetClientGroupCollection()
{
#if MONGO
return PhysicianClientGatewayMongo.GetClientGroupCollection();
#else
YellowstonePathology.Business.Client.Model.ClientGroupCollection result = new Client.Model.ClientGroupCollection();
SqlCommand cmd = new SqlCommand("select * from tblClientGroup order by GroupName");
cmd.CommandType = CommandType.Text;
using (SqlConnection cn = new SqlConnection(YellowstonePathology.Business.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
YellowstonePathology.Business.Client.Model.ClientGroup clientGroup = new Client.Model.ClientGroup();
YellowstonePathology.Business.Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(clientGroup, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.Add(clientGroup);
}
}
}
return result;
#endif
}
