Пример #1
0
        private void UpdateInstructorCourses(string[] selectedServices, Employee employeeToUpdate)
        {
            if (selectedServices == null)
            {
                employeeToUpdate.ServiceAssignments = new List <ServiceAssignment>();
                return;
            }

            var selectedServicesHS = new HashSet <string>(selectedServices);
            var employeeServices   = new HashSet <int>(employeeToUpdate.ServiceAssignments.Select(c => c.Service.ServiceID));

            foreach (var service in _context.Services)
            {
                if (selectedServicesHS.Contains(service.ServiceID.ToString()))
                {
                    if (!employeeServices.Contains(service.ServiceID))
                    {
                        employeeToUpdate.ServiceAssignments.Add(new ServiceAssignment {
                            EmployeeID = employeeToUpdate.ID, ServiceID = service.ServiceID
                        });
                    }
                }
                else
                {
                    if (employeeServices.Contains(service.ServiceID))
                    {
                        ServiceAssignment courseToRemove = employeeToUpdate.ServiceAssignments.FirstOrDefault(i => i.ServiceID == service.ServiceID);
                        _context.Remove(courseToRemove);
                    }
                }
            }
        }
Пример #2
0
        public async Task <IActionResult> Create(Employee employee, string[] selectedServices)
        {
            if (selectedServices != null)
            {
                employee.ServiceAssignments = new List <ServiceAssignment>();
                foreach (var service in selectedServices)
                {
                    var serviceToAdd = new ServiceAssignment {
                        EmployeeID = employee.ID, ServiceID = int.Parse(service)
                    };
                    employee.ServiceAssignments.Add(serviceToAdd);
                }
            }
            if (ModelState.IsValid)
            {
                _context.Add(employee);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            PopulateAssignedServiceData(employee);
            return(View(employee));
        }
Пример #3
0
        public static void Initialize(UserContext context)
        {
            //context.Database.EnsureCreated();

            //// Look for any users.
            //if (context.Users.Any())
            //{
            //    return;   // DB has been seeded
            //}

            //var users = new User[]
            //{
            //    new User{UserName="******",Email="*****@*****.**",JoinDate=DateTime.Now},
            //    new User{UserName="******",Email="*****@*****.**",JoinDate=DateTime.Now},
            //    new User{UserName="******",Email="*****@*****.**",JoinDate=DateTime.Now},
            //    new User{UserName="******",Email="*****@*****.**",JoinDate=DateTime.Now}
            //};

            //foreach (User user in users)
            //{
            //    context.Users.Add(user);
            //}
            //context.SaveChanges();

            //var services = new Service[]
            //{
            //    new Service{ServiceID=1000,ServiceName="Grammateket", Cost=29.99},
            //    new Service{ServiceID=1001,ServiceName="MatematikLegFlex", Cost=49.99},
            //    new Service{ServiceID=1002,ServiceName="IntoWords", Cost=99.99}
            //};

            //foreach (Service service in services)
            //{
            //    context.Services.Add(service);
            //}
            //context.SaveChanges();
            context.Database.EnsureCreated();
            User[]    users    = new User[4];
            Service[] services = new Service[5];

            if (!context.Services.Any())
            {
                services = new Service[]
                {
                    new Service {
                        ServiceName = "Grammateket", Cost = 29.99
                    },
                    new Service {
                        ServiceName = "MatematikLegFlex", Cost = 49.99
                    },
                    new Service {
                        ServiceName = "IntoWords", Cost = 99.99
                    },
                    new Service {
                        ServiceName = "OutroWords", Cost = 99.99
                    },
                    new Service {
                        ServiceName = "Outrotek", Cost = 39.99
                    }
                };

                foreach (Service s in services)
                {
                    context.Services.Add(s);
                }
                //context.SaveChanges();
            }

            // Look for any users.
            if (!context.Users.Any())
            {
                users = new User[]
                {
                    new User {
                        UserName = "******", Email = "*****@*****.**", JoinDate = DateTime.Now
                    },
                    new User {
                        UserName = "******", Email = "*****@*****.**", JoinDate = DateTime.Now
                    },
                    new User {
                        UserName = "******", Email = "*****@*****.**", JoinDate = DateTime.Now
                    },
                    new User {
                        UserName = "******", Email = "*****@*****.**", JoinDate = DateTime.Now
                    }
                };

                foreach (User user in users)
                {
                    context.Users.Add(user);
                }
                //context.SaveChanges();
            }


            if (!context.ServiceAssignments.Any())
            {
                var serviceAssignments = new ServiceAssignment[]
                {
                    new ServiceAssignment {
                        ServiceID = services.Single(s => s.ServiceName == "Grammateket").ServiceID,
                        UserID    = users.Single(u => u.UserName == "Bob").UserID
                    },
                    new ServiceAssignment {
                        ServiceID = services.Single(s => s.ServiceName == "MatematikLegFlex").ServiceID,
                        UserID    = users.Single(u => u.UserName == "Bob").UserID
                    },
                    new ServiceAssignment {
                        ServiceID = services.Single(s => s.ServiceName == "IntoWords").ServiceID,
                        UserID    = users.Single(u => u.UserName == "Bob").UserID
                    },
                    new ServiceAssignment {
                        ServiceID = services.Single(s => s.ServiceName == "MatematikLegFlex").ServiceID,
                        UserID    = users.Single(u => u.UserName == "John").UserID
                    },
                    new ServiceAssignment {
                        ServiceID = services.Single(s => s.ServiceName == "Grammateket").ServiceID,
                        UserID    = users.Single(u => u.UserName == "John").UserID
                    },
                    new ServiceAssignment {
                        ServiceID = services.Single(s => s.ServiceName == "IntoWords").ServiceID,
                        UserID    = users.Single(u => u.UserName == "Jim").UserID
                    },
                    new ServiceAssignment {
                        ServiceID = services.Single(s => s.ServiceName == "OutroWords").ServiceID,
                        UserID    = users.Single(u => u.UserName == "Gurlie").UserID
                    },
                };

                foreach (ServiceAssignment serviceAssignemt in serviceAssignments)
                {
                    context.ServiceAssignments.Add(serviceAssignemt);
                }
                context.SaveChanges();
            }
        }
Пример #4
0
        public static void Initialize(ScheduleContext context)
        {
            context.Database.EnsureCreated();

            // Verifica se existe algum paciente
            if (context.Patients.Any())
            {
                return; // banco de dados foi semeado;
            }

            var patients = new Patient[]
            {
                new Patient {
                    FirstName = "Ana Lúcia", LastName = "Arcieri Calasans da Silva", BirthDate = DateTime.Parse("2003-05-15"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Brenda", LastName = "De Jesus da Silva", BirthDate = DateTime.Parse("1995-10-09"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Katharina Lúcia", LastName = "De Almeida Moraes Fraga", BirthDate = DateTime.Parse("1993-09-12"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Maria Eliana", LastName = "Santos da Costa", BirthDate = DateTime.Parse("1963-09-30"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Camila", LastName = "Vitoria Santos", BirthDate = DateTime.Parse("2004-08-22"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Jocenia", LastName = "Alves Santos", BirthDate = DateTime.Parse("1969-02-03"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Cláudia", LastName = "De Oliveira Santos", BirthDate = DateTime.Parse("1982-07-18"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Daniela", LastName = "Maria Gomes Carvalho", BirthDate = DateTime.Parse("2000-05-01"), Genre = Genre.FEMININO
                },
                new Patient {
                    FirstName = "Lidia Carla", LastName = "Souza de Oliveira", BirthDate = DateTime.Parse("1996-10-14"), Genre = Genre.FEMININO
                }
            };

            foreach (Patient p in patients)
            {
                context.Patients.Add(p);
            }
            context.SaveChanges();

            var employees = new Employee[]
            {
                new Employee {
                    FirstName = "Júlio", LastName = "César", HireDate = DateTime.Parse("2004-03-29")
                },
                new Employee {
                    FirstName = "Emília", LastName = "Correia", HireDate = DateTime.Parse("2004-03-29")
                },
                new Employee {
                    FirstName = "Márcio", LastName = "Liula", HireDate = DateTime.Parse("2004-03-29")
                },
                new Employee {
                    FirstName = "Júlia", LastName = "Mangaba", HireDate = DateTime.Parse("2004-03-29")
                },
                new Employee {
                    FirstName = "Carla", LastName = "Porto", HireDate = DateTime.Parse("2014-09-12")
                },
                new Employee {
                    FirstName = "Jammily", LastName = "Pancratto", HireDate = DateTime.Parse("2014-09-12")
                },
                new Employee {
                    FirstName = "Fabio", LastName = "Guerra", HireDate = DateTime.Parse("2004-03-29")
                }
            };

            foreach (Employee e in employees)
            {
                context.Employees.Add(e);
            }
            context.SaveChanges();

            var departments = new Department[]
            {
                new Department {
                    Name = "Enfermagem", Category = Category.NURSING
                },
                new Department {
                    Name = "Medicina", Category = Category.MEDICINE
                }
            };

            foreach (Department d in departments)
            {
                context.Departments.Add(d);
            }
            context.SaveChanges();

            var services = new Service[]
            {
                new Service {
                    ServiceID = 1020, Title = "Consulta Pré-Natal Enfermagem", DepartmentID = departments.Single(s => s.Name == "Enfermagem").DepartmentID
                },
                new Service {
                    ServiceID = 1025, Title = "Consulta Hipertenso-Diabético", DepartmentID = departments.Single(s => s.Name == "Medicina").DepartmentID
                },
                new Service {
                    ServiceID = 1035, Title = "Consulta Puericultura", DepartmentID = departments.Single(s => s.Name == "Medicina").DepartmentID
                },
                new Service {
                    ServiceID = 1040, Title = "Consulta Papanicolau", DepartmentID = departments.Single(s => s.Name == "Enfermagem").DepartmentID
                },
                new Service {
                    ServiceID = 1045, Title = "Consulta Acupuntura", DepartmentID = departments.Single(s => s.Name == "Enfermagem").DepartmentID
                },
                new Service {
                    ServiceID = 1050, Title = "Consulta Saúde Mental", DepartmentID = departments.Single(s => s.Name == "Medicina").DepartmentID
                },
                new Service {
                    ServiceID = 1055, Title = "Visita Domiciliar Enfermagem", DepartmentID = departments.Single(s => s.Name == "Enfermagem").DepartmentID
                },
            };

            foreach (Service s in services)
            {
                context.Services.Add(s);
            }
            context.SaveChanges();

            var officeAssignments = new OfficeAssignment[]
            {
                new OfficeAssignment {
                    EmployeeID = employees.Single(i => i.LastName == "César").ID,
                    Location   = "Consultório 01"
                },
                new OfficeAssignment {
                    EmployeeID = employees.Single(i => i.LastName == "Correia").ID,
                    Location   = "Consultório 02"
                },
                new OfficeAssignment {
                    EmployeeID = employees.Single(i => i.LastName == "Liula").ID,
                    Location   = "Consultório 03"
                },
                new OfficeAssignment {
                    EmployeeID = employees.Single(i => i.LastName == "Mangaba").ID,
                    Location   = "Consultório 04"
                },
                new OfficeAssignment {
                    EmployeeID = employees.Single(i => i.LastName == "Porto").ID,
                    Location   = "Consultório 05"
                },
                new OfficeAssignment {
                    EmployeeID = employees.Single(i => i.LastName == "Pancratto").ID,
                    Location   = "Consultório 06"
                },
                new OfficeAssignment {
                    EmployeeID = employees.Single(i => i.LastName == "Guerra").ID,
                    Location   = "Consultório 07"
                },
            };

            foreach (OfficeAssignment o in officeAssignments)
            {
                context.OfficeAssignments.Add(o);
            }
            context.SaveChanges();

            var serviceEmployees = new ServiceAssignment[]
            {
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Pré-Natal Enfermagem").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "César").ID
                },
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Puericultura").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "Pancratto").ID
                },
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Papanicolau").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "César").ID
                },
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Acupuntura").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "Pancratto").ID
                },
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Puericultura").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "Guerra").ID
                },
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Saúde Mental").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "Mangaba").ID
                },
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Saúde Mental").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "Mangaba").ID
                },
                new ServiceAssignment {
                    ServiceID  = services.Single(c => c.Title == "Consulta Acupuntura").ServiceID,
                    EmployeeID = employees.Single(i => i.LastName == "Guerra").ID
                },
            };

            foreach (ServiceAssignment ci in serviceEmployees)
            {
                context.ServiceAssignments.Add(ci);
            }
            context.SaveChanges();

            var schedulings = new Schedule[]
            {
                new Schedule {
                    ServiceID = 1020, PatientID = 1, Date = DateTime.Parse("2021-03-25"), Group = Group.PREGNANT
                },
                new Schedule {
                    ServiceID = 1040, PatientID = 2, Date = DateTime.Parse("2021-03-25"), Group = Group.FERTIL_AGE_WOMEN
                },
                new Schedule {
                    ServiceID = 1040, PatientID = 3, Date = DateTime.Parse("2021-03-25"), Group = Group.FERTIL_AGE_WOMEN
                },
                new Schedule {
                    ServiceID = 1040, PatientID = 3, Date = DateTime.Parse("2021-03-25"), Group = Group.FERTIL_AGE_WOMEN
                },
                new Schedule {
                    ServiceID = 1020, PatientID = 3, Date = DateTime.Parse("2021-04-25"), Group = Group.PREGNANT
                },
                new Schedule {
                    ServiceID = 1020, PatientID = 3, Date = DateTime.Parse("2021-04-25"), Group = Group.PREGNANT
                },
                new Schedule {
                    ServiceID = 1020, PatientID = 3, Date = DateTime.Parse("2021-04-29"), Group = Group.PREGNANT
                },
                new Schedule {
                    ServiceID = 1050, PatientID = 3, Date = DateTime.Parse("2021-05-19"), Group = Group.FERTIL_AGE_WOMEN
                },
                new Schedule {
                    ServiceID = 1050, PatientID = 3, Date = DateTime.Parse("2021-05-15"), Group = Group.FERTIL_AGE_WOMEN
                },
            };

            foreach (Schedule s in schedulings)
            {
                context.Schedules.Add(s);
            }
            context.SaveChanges();
        }