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 }