public void Add(Patient patient) { try { var memento = patient.GetMemento(); _context.Add(new Backend.Model.Users.Patient() { Jmbg = memento.Jmbg, Name = memento.Name, Surname = memento.Surname, IsGuest = true }); _context.SaveChanges(); _context.Add(new Backend.Model.Users.PatientCard() { PatientJmbg = memento.Jmbg, BloodType = memento.BloodType.ToBackendBloodType(), RhFactor = memento.RhFactor.ToBackendRhFactor(), Alergies = memento.Allergies, MedicalHistory = memento.MedicalHistory, HasInsurance = !String.IsNullOrWhiteSpace(memento.InsuranceNumber), Lbo = memento.InsuranceNumber }); _context.SaveChanges(); } catch (PatientServiceException) { throw; } catch (DbUpdateException e) { throw new ValidationException(e.Message); } catch (Exception e) { throw new DataStorageException(e.Message); } }
private void SeedExaminations(MyDbContext context) { Doctor doctor = context.Doctors.Find("8520147896320"); PatientCard patientCard = context.PatientCards.Find(2); Room room = context.Rooms.Where(r => r.Usage.Equals(TypeOfUsage.CONSULTING_ROOM)).First(); DateTime start = DateTime.Now.Date.AddDays(10).AddHours(7); DateTime end = DateTime.Now.Date.AddDays(13).AddHours(17); for (DateTime current = start; current < end; current = current.AddMinutes(30)) { if (CheckIfTimeValid(current)) { int examinationId = context.Examinations.Count(); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = current, IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.CREATED }); AddEquipmentInExamination(context, room.Id, examinationId); continue; } current = new DateTime(current.Year, current.Month, current.Day, 6, 30, 0); current = current.AddDays(1); } context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(-10).AddHours(8).AddMinutes(30), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.CANCELED }); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(-12).AddHours(10), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.CANCELED }); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(-15).AddHours(12).AddMinutes(30), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.CANCELED }); patientCard = context.PatientCards.Find(1); Doctor doctor1 = context.Doctors.Find("0606988520123"); Doctor doctor2 = context.Doctors.Find("0323970501235"); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(-15).AddHours(14), IsSurveyCompleted = true, ExaminationStatus = ExaminationStatus.FINISHED, Anamnesis = "Sinuzitis" }); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor1.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(-10).AddHours(9).AddMinutes(30), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.FINISHED, Anamnesis = "Upala uha" }); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor2.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(-5).AddHours(11).AddMinutes(30), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.FINISHED, Anamnesis = "Upala pluća" }); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor1.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(1).AddHours(10).AddMinutes(30), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.CREATED }); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(13).AddHours(7), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.CREATED }); context.Add(new Examination { Type = TypeOfExamination.GENERAL, DoctorJmbg = doctor1.Jmbg, IdPatientCard = patientCard.Id, IdRoom = room.Id, DateAndTime = DateTime.Now.Date.AddDays(-2).AddHours(10), IsSurveyCompleted = false, ExaminationStatus = ExaminationStatus.CANCELED }); context.SaveChanges(); }
public void SeedAll(MyDbContext context) { if (Verbose) { Console.WriteLine("Seeding countries."); } SeedCountries(context); if (Verbose) { Console.WriteLine("Seeding cities."); } SeedCities(context); if (Verbose) { Console.WriteLine("Seeding patients."); } SeedPatientsAndPatientsCard(context); if (Verbose) { Console.WriteLine("Seeding specialties."); } SeedSpecialties(context); if (Verbose) { Console.WriteLine("Seeding equipment."); } SeedEquipmentTypes(context); if (Verbose) { Console.WriteLine("Seeding rooms."); } SeedRooms(context); if (Verbose) { Console.WriteLine("Seeding doctors."); } SeedDoctors(context); if (Verbose) { Console.WriteLine("Seeding drugs."); } SeedDrugTypes(context); SeedDrugs(context); SeedDrugsInRooms(context); if (Verbose) { Console.WriteLine("Seeding examinations."); } SeedExaminations(context); if (Verbose) { Console.WriteLine("Seeding therapies."); } SeedTherapies(context); if (Verbose) { Console.WriteLine("Seeding pharmacies."); } SeedPharmacies(context); if (Verbose) { Console.WriteLine("Seeding drug consumptions."); } SeedDrugConsumptions(context); if (Verbose) { Console.WriteLine("Seeding feedback."); } SeedFeedback(context); if (Verbose) { Console.WriteLine("Seeding admins."); } SeedAdmins(context); if (Verbose) { Console.WriteLine("Seeding actions."); } SeedActionBenefits(context); if (Verbose) { Console.WriteLine("Seeding renovations."); } SeedRenovations(context); context.SaveChanges(); }
private void SeedDoctors(MyDbContext context) { context.Add(new Doctor() { Jmbg = "1234567891234", Name = "Mira", Surname = "Mirić", DateOfBirth = new DateTime(1950, 11, 27), Phone = "021457852", Email = "*****@*****.**", HomeAddress = "Maršala Tita 102", Username = "******", DateOfEmployment = new DateTime(2018, 05, 06), CityZipCode = 1, Gender = GenderType.F, NumberOfLicence = "11111111", Password = "******", DoctorsOfficeId = 9 }); context.Add(new Doctor() { Jmbg = "8520147896320", Name = "Dara", Surname = "Darić", DateOfBirth = new DateTime(1950, 11, 27), Phone = "021457852", Email = "*****@*****.**", HomeAddress = "Maršala Tita 102", Username = "******", DateOfEmployment = new DateTime(2010, 11, 15), CityZipCode = 1, Gender = GenderType.F, NumberOfLicence = "22222222", Password = "******", DoctorsOfficeId = 12 }); context.Add(new Doctor() { Jmbg = "0110983520145", Name = "Miloš", Surname = "Milošević", DateOfBirth = new DateTime(1983, 01, 10), Phone = "021852145", Email = "*****@*****.**", HomeAddress = "Balzakova 18", Username = "******", DateOfEmployment = new DateTime(2019, 04, 30), CityZipCode = 2, Gender = GenderType.M, NumberOfLicence = "11111111", Password = "******", DoctorsOfficeId = 20 }); context.Add(new Doctor() { Jmbg = "0323970501235", Name = "Žika", Surname = "Žikić", DateOfBirth = new DateTime(1970, 03, 23), Phone = "021752032", Email = "*****@*****.**", HomeAddress = "Narodnog Fronta 7", Username = "******", DateOfEmployment = new DateTime(2008, 10, 01), CityZipCode = 2, Gender = GenderType.M, NumberOfLicence = "11111111", Password = "******", DoctorsOfficeId = 25 }); context.Add(new Doctor() { Jmbg = "0606988520123", Name = "Marija", Surname = "Marić", DateOfBirth = new DateTime(1988, 06, 06), Phone = "021954201", Email = "*****@*****.**", HomeAddress = "Narodnog Fronta 45", Username = "******", DateOfEmployment = new DateTime(2020, 02, 05), CityZipCode = 1, Gender = GenderType.F, NumberOfLicence = "11111111", Password = "******", DoctorsOfficeId = 49 }); context.Add(new Doctor() { Jmbg = "2007975521021", Name = "Sara", Surname = "Sarić", DateOfBirth = new DateTime(1975, 07, 20), Phone = "021954201", Email = "*****@*****.**", HomeAddress = "Futoška 5", Username = "******", DateOfEmployment = new DateTime(2018, 05, 11), CityZipCode = 2, Gender = GenderType.F, NumberOfLicence = "11111111", Password = "******", DoctorsOfficeId = 51 }); context.SaveChanges(); context.Add(new DoctorSpecialty() { DoctorJmbg = "8520147896320", SpecialtyId = 1 }); context.Add(new DoctorSpecialty() { DoctorJmbg = "0110983520145", SpecialtyId = 1 }); context.Add(new DoctorSpecialty() { DoctorJmbg = "1234567891234", SpecialtyId = 2 }); context.Add(new DoctorSpecialty() { DoctorJmbg = "0323970501235", SpecialtyId = 2 }); context.Add(new DoctorSpecialty() { DoctorJmbg = "0606988520123", SpecialtyId = 3 }); context.Add(new DoctorSpecialty() { DoctorJmbg = "2007975521021", SpecialtyId = 4 }); context.SaveChanges(); }