public static void Initialize(IServiceProvider serviceProvider) { using (var context = new FinalProjectContext( serviceProvider.GetRequiredService < DbContextOptions <FinalProjectContext> >())) { // Look for any students. if (context.Student.Any()) { return; // DB has been seeded } context.Student.AddRange( new Student { Name = "Example", EventPref = "100M Dash", Grade = 12, Phone = "(719)555-5555" } ); context.SaveChanges(); if (context.Student.Any()) { return; // DB has been seeded. } // Look for any students. if (context.Results.Any()) { return; // DB has been seeded } context.Results.AddRange( new Result { MeetName = "Example", Athlete = "John Doe", Event = "Long Jump", Mark = "20'1" } ); context.SaveChanges(); if (context.Results.Any()) { return; // DB has been seeded. } } }
public IActionResult OnPost() { Membership = _context.Membership.Find(ChangePlanForm.MemberId); if (!ModelState.IsValid) { return(Page()); } _context.Attach(Membership).State = EntityState.Modified; // UPDATE THE MEMBER RETRIEVED FROM THE DATABASE Membership.PlanID = ChangePlanForm.PlanID; // TELL THE DATABASE TO SAVE WHATEVER CHANGES WE MADE _context.SaveChanges(); return(RedirectToPage("/Memberships/details", new { id = Membership.PlanID })); }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new FinalProjectContext(serviceProvider.GetRequiredService <DbContextOptions <FinalProjectContext> >())) { // CLIENTS if (context.Clients.Any()) { //leave, there is already data in the database return; } var clients = new List <Client> { new Client { FirstName = "Jimmie", LastName = "Ramos", CompanyName = "ACME", Email = "*****@*****.**", Phone = "555-555-5555" }, new Client { FirstName = "Kristy", LastName = "Miles", CompanyName = "World Wide Industries", Email = "*****@*****.**", Phone = "555-555-5555" }, new Client { FirstName = "Shelley", LastName = "Walker", CompanyName = "Big Money Inc", Email = "*****@*****.**", Phone = "555-555-5555" } }; context.AddRange(clients); context.SaveChanges(); // CLIENTS if (context.Members.Any()) { //leave, there is already data in the database return; } var members = new List <Member> { new Member { FirstName = "Mamie", LastName = "Santiago", Major = "CIS", Email = "*****@*****.**", Phone = "555-555-5555" }, new Member { FirstName = "Pete", LastName = "Perez", Major = "CIS", Email = "*****@*****.**", Phone = "555-555-5555" }, new Member { FirstName = "Flora", LastName = "Williamson", Major = "CIS", Email = "*****@*****.**", Phone = "555-555-5555" }, new Member { FirstName = "Laverne", LastName = "Wolfe", Major = "CIS", Email = "*****@*****.**", Phone = "555-555-5555" }, new Member { FirstName = "Delia", LastName = "Bridges", Major = "CIS", Email = "*****@*****.**", Phone = "555-555-5555" }, new Member { FirstName = "Rebecca", LastName = "Morton", Major = "CIS", Email = "*****@*****.**", Phone = "555-555-5555" }, new Member { FirstName = "Franklin", LastName = "Arnold", Major = "CIS", Email = "*****@*****.**", Phone = "555-555-5555" } }; context.AddRange(members); context.SaveChanges(); // PROJECTS if (context.Projects.Any()) { //leave, there is already data in the database return; } var projects = new List <Project> { new Project { ProjectName = "The Big One", ProjectDescription = "The One Project to rule them all" }, new Project { ProjectName = "Awesome", ProjectDescription = "This project is awesome" }, new Project { ProjectName = "Easy Project", ProjectDescription = "This project is so easy, it completes itself" } }; context.AddRange(projects); context.SaveChanges(); //PROJECT ROSTER BRIDGE TABLE - THERE MUST BE PROJECTS AND PARTICIPANTS MADE FIRST if (context.ProjectRoster.Any()) { //leave, there is already data in the database return; } //quickly grab the recent records added to the DB to get the IDs var projectsFromDb = context.Projects.ToList(); var clientsFromDb = context.Clients.ToList(); var membersFromDb = context.Members.ToList(); var projectroster = new List <ProjectRoster> { //take the first project from above, the first client from above, and the first three students from above. new ProjectRoster { ProjectID = projectsFromDb.ElementAt(0).ID.ToString(), Project = projectsFromDb.ElementAt(0), ProjectParticipantID = clientsFromDb.ElementAt(0).ID.ToString(), ProjectParticipant = clientsFromDb.ElementAt(0) }, new ProjectRoster { ProjectID = projectsFromDb.ElementAt(0).ID.ToString(), Project = projectsFromDb.ElementAt(0), ProjectParticipantID = membersFromDb.ElementAt(0).ID.ToString(), ProjectParticipant = membersFromDb.ElementAt(0) }, new ProjectRoster { ProjectID = projectsFromDb.ElementAt(0).ID.ToString(), Project = projectsFromDb.ElementAt(0), ProjectParticipantID = membersFromDb.ElementAt(1).ID.ToString(), ProjectParticipant = membersFromDb.ElementAt(1) }, new ProjectRoster { ProjectID = projectsFromDb.ElementAt(0).ID.ToString(), Project = projectsFromDb.ElementAt(0), ProjectParticipantID = membersFromDb.ElementAt(2).ID.ToString(), ProjectParticipant = membersFromDb.ElementAt(2) }, }; context.AddRange(projectroster); context.SaveChanges(); } }