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();
}
}
