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 void PopulateAssignedCategoryData(FinalProjectContext context,
Game game)
{
var allCategories = context.Category;
var gameCategories = new HashSet <int>(
game.GameCategories.Select(c => c.GameID));
AssignedCategoryDataList = new List <AssignedCategoryData>();
foreach (var cat in allCategories)
{
AssignedCategoryDataList.Add(new AssignedCategoryData
{
CategoryID = cat.ID,
Name = cat.CategoryName,
Assigned = gameCategories.Contains(cat.ID)
});
}
}
public void UpdateGameCategories(FinalProjectContext context,
string[] selectedCategories, Game gameToUpdate)
{
if (selectedCategories == null)
{
gameToUpdate.GameCategories = new List <GameCategory>();
return;
}
var selectedCategoriesHS = new HashSet <string>(selectedCategories);
var gameCategories = new HashSet <int>
(gameToUpdate.GameCategories.Select(c => c.Category.ID));
foreach (var cat in context.Category)
{
if (selectedCategoriesHS.Contains(cat.ID.ToString()))
{
if (!gameCategories.Contains(cat.ID))
{
gameToUpdate.GameCategories.Add(
new GameCategory
{
GameID = gameToUpdate.ID,
CategoryID = cat.ID
});
}
}
else
{
if (gameCategories.Contains(cat.ID))
{
GameCategory courseToRemove
= gameToUpdate
.GameCategories
.SingleOrDefault(i => i.CategoryID == cat.ID);
context.Remove(courseToRemove);
}
}
}
}
public DetailsModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
public IndexModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
public CreateModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
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();
}
}
public EditModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
public MembershipProfileModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
public SearchModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
public TrainerProfileModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
public ChangePlanModel(FinalProject.Models.FinalProjectContext context)
{
_context = context;
}
