private static void AddUser() { using (var context = new MedAllEntities2()) { var user = new User { Email = "admin", Password = "******", }; var role = new Role { Name = "admin" }; user.Role = role; role.Users.Add(user); context.Roles.Add(role); context.Users.Add(user); context.SaveChanges(); } }
private static void AddData() { using (var context = new MedAllEntities2()) { var patient = new Patient { FirstName = "Andrew", LastName = "Doe", Email = "*****@*****.**", PhoneNumer = "0754511254", }; var room = new Room { Name = "Internal med room" }; var appoinment = new Appointment { Date = "12345", }; appoinment.Room = room; var doctor = new Doctor { FirstName = "Joe", LastName = "jones", Email = "*****@*****.**", PhoneNumber = "1234564784", Specialization = "internal medicine" }; doctor.Rooms.Add(room); doctor.Appointment = appoinment; //appoinment.Doctor = doctor; patient.Appointment = appoinment; patient.Doctors.Add(doctor); //appoinment.Patient = patient; //doctor.Patients.Add(patient); context.Appointments.Add(appoinment); context.Patients.Add(patient); context.Doctors.Add(doctor); try { context.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } Console.WriteLine(e); throw; } } }