示例#1
0
        private static void SeedDatabase(ClinicsDB db)
        {
            var proc1 = new Procedure() { Name = "Blood test", Price = 50.00m };
            var proc2 = new Procedure() { Name = "MRI", Price = 1000.00m };

            var specialty = new Specialty() { Name = "Internist" };

            var specialist = new Specialist()
            {
                FirstName = "Gregory",
                LastName = "House",
                SpecialtyId = specialty.Id
            };

            var manip = new Manipulation()
            {
                Date = DateTime.Now,
                SpecialistId = specialist.Id
            };

            manip.Procedures.Add(proc1);
            manip.Procedures.Add(proc2);

            db.Procedures.Add(proc1);
            db.Procedures.Add(proc2);
            db.Specialties.Add(specialty);
            db.Specialists.Add(specialist);
            db.Manipulations.Add(manip);

            SaveChanges(db);
        }
示例#2
0
        private void ImportInSql(IClinicsData data, string name, decimal price, string information)
        {
            var exists = data.Procedures.All()
                .Where(p => p.Name.Equals(name))
                .FirstOrDefault();

            if (exists == null)
            {
                Procedure procedure = new Procedure
                {
                    Id = Guid.NewGuid(),
                    Name = name,
                    Price = price,
                    Information = information
                };

                data.Procedures.Add(procedure);
            }
        }
示例#3
0
        private void InportInMongo(string name, decimal price, string information)
        {
            var procedures = mongoDb.GetCollection<BsonDocument>("Procedures");

            var exists = procedures.FindAll().Where(p => p["Name"].Equals(name)).FirstOrDefault();

            if (exists == null)
            {
                Procedure procedure = new Procedure
                {
                    Id = Guid.NewGuid(),
                    Name = name,
                    Price = price,
                    Information = information
                };

                procedures.Insert<Procedure>(procedure);
            }
        }
        private void ImportProcedures(IClinicsData data)
        {
            var allProcedures = mongoDb.GetCollection<BsonDocument>("Procedures").FindAll();

            foreach (var procedure in allProcedures)
            {
                var idGuid = procedure["_id"].AsGuid;
                var name = this.GetValue(procedure, "Name");
                var price = decimal.Parse(this.GetValue(procedure, "Price"));
                var information = this.GetValue(procedure, "Information");

                var existingRecord = data.Procedures.All()
                    .Where(p => p.Name.Equals(name))
                    .FirstOrDefault();

                if (existingRecord == null)
                {
                    Procedure newProcedure = new Procedure
                    {
                        Id = idGuid,
                        Name = name,
                        Price = price,
                        Information = information
                    };

                    data.Procedures.Add(newProcedure);
                }
                else
                {
                    existingRecord.Name = name;
                    existingRecord.Price = price;
                    existingRecord.Information = information;
                }
            }
        }