public ReportModel()
{
MichelleDBEntities mdb = new MichelleDBEntities();
Teams = mdb.Teams.ToList();
AvailableReports = new Dictionary<int, string>();
AvailableReports.Add(1, "Status of the team");
AvailableReports.Add(2, "Applying quantitative methods");
AvailableReports.Add(3, "Applying quantitative methods");
}
public ActionResult SampleData()
{
Random rnd = new Random();
MichelleDBEntities db = new MichelleDBEntities();
db.Database.ExecuteSqlCommand("TruncateAll");
if (db.Departments.Count() == 0)
{
db.Departments.Add(new Departments() { DepartmentName = "Department a" });
db.Departments.Add(new Departments() { DepartmentName = "Department b" });
db.Departments.Add(new Departments() { DepartmentName = "Department c" });
db.SaveChanges();
}
if (db.TeamRoles.Count() == 0)
{
db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "MARKETING TECHNOLOGIST" });
db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "SEO CONSULTANT" });
db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "GROWTH HACKER" });
db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "CONTENT STRATEGIST" });
db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "UX DESIGNER" });
db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "FRONT-END DEVELOPER" });
db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "MOBILE DEVELOPER" });
db.SaveChanges();
}
var firstNames = new string[20] {
"Wilmer", "Bryon", "Terrence", "Schumaker", "Danuta", "Rosy", "Luann",
"Tabatha", "Thurman", "Deandrea", "Ned", "Isabell", "Marlon",
"Janee", "Bok", "Wan", "Karry", "Macy", "Twila", "Jada"
};
var lastNames = new string[20] {
"Frisch", "Aoki", "Bergevin", "Delsie", "Seder", "Castaldo", "Weast",
"Moreira", "Wheatley", "Craft", "Jines", "Brannon", "Kahler",
"Stansbury", "Mccreery", "Madia", "Mossman", "Bitner", "Luiz", "Daniels"
};
if (db.Employees.Count() == 0)
{
for (int i=0; i < firstNames.Length; i++)
{
db.Employees.Add(new Employees()
{
EmployeeId = (i+1).ToString(),
FirstName = firstNames[i],
FamilyName = lastNames[i],
d_DepartmentId = rnd.Next(1, 4),
BeginningOfWork = new DateTime(rnd.Next(2012, 2016), rnd.Next(1, 13), rnd.Next(1, 29)),
r_TeamRoleId = rnd.Next(1, 8),
AdminType = i%2+1
});
}
db.SaveChanges();
}
if (db.Teams.Count() == 0)
{
db.Teams.Add(new Teams()
{
TeamName = "The Sun",
TeamStatus = "Active",
e_Employee_team_leader = "1"
});
db.Teams.Add(new Teams()
{
TeamName = "Mercury",
TeamStatus = "Active",
e_Employee_team_leader = "2"
});
db.Teams.Add(new Teams()
{
TeamName = "Venus",
TeamStatus = "Active",
e_Employee_team_leader = "3"
});
db.Teams.Add(new Teams()
{
TeamName = "Earth",
TeamStatus = "Active",
e_Employee_team_leader = "4"
});
db.Teams.Add(new Teams()
{
TeamName = "Mars",
TeamStatus = "Active",
e_Employee_team_leader = "5"
});
db.Teams.Add(new Teams()
{
TeamName = "Jupiter",
TeamStatus = "Active",
e_Employee_team_leader = "6"
});
db.Teams.Add(new Teams()
{
TeamName = "Saturn",
TeamStatus = "Active",
e_Employee_team_leader = "7"
});
db.Teams.Add(new Teams()
{
TeamName = "Uranus",
TeamStatus = "Active",
e_Employee_team_leader = "8"
});
db.Teams.Add(new Teams()
{
TeamName = "Neptune",
TeamStatus = "Active",
e_Employee_team_leader = "9"
});
db.SaveChanges();
}
return View("Index");
/*
*/
}
