public ReportModel() { nandmEntities mdb = new nandmEntities(); 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, "Meetings participated"); }
public ActionResult SampleData() { Random rnd = new Random(); nandmEntities db = new nandmEntities(); if (db.Departments.Count() == 0) { db.Departments.Add(new Departments() { DepartmentName = "Noy department" }); db.Departments.Add(new Departments() { DepartmentName = "Noy2 department" }); db.Departments.Add(new Departments() { DepartmentName = "Noy3 department" }); db.SaveChanges(); } if (db.TeamRoles.Count() == 0) { db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "Mechanical technitian" }); db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "Production worker" }); db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "Warehouse manager" }); db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "Maintenance manager" }); db.TeamRoles.Add(new TeamRoles() { TeamRoleName = "Dork worker" }); db.SaveChanges(); } #region names var firstNames = new string[30] { "maram", "noy", "Brumett", "Perron", "Akers", "Zorn", "Courter", "Younker", "Groseclose", "Telesco", "Easterly", "Rudie", "Monger", "Luoma", "Biondi", "Blalock", "Reasor", "Fenley", "Diniz", "Garrels", "Nivens", "Marcano", "Thoms", "Parman", "Holzworth", "Helstrom", "Silverstein", "Klausner", "Carra", "Shapiro" }; var lastNames = new string[30] { "Swan", "Amar", "Sherrell", "Lindsay", "Qiana", "Quincy", "Amanda", "Gerald", "Carla", "Danyelle", "Simona", "Nenita", "Shante", "Andres", "Dedra", "Ned", "Ching", "Cuc", "Malcom", "Aleta", "Marx", "Claire", "Henriette", "Heath", "Hung", "Rhea", "Gregg", "Shelba", "Alina", "Janice" }; #endregion 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), r_TeamRoleId = rnd.Next(1, 6), AdminNum = i%2+1 }); } db.SaveChanges(); } if (db.Teams.Count() == 0) { db.Teams.Add(new Teams() { TeamName = "Golda", TeamStatus = "Active", e_Employee_team_leader = "1" }); db.Teams.Add(new Teams() { TeamName = "BB", TeamStatus = "Closed", e_Employee_team_leader = "2" }); db.Teams.Add(new Teams() { TeamName = "Begin", TeamStatus = "InProc", e_Employee_team_leader = "3" }); db.Teams.Add(new Teams() { TeamName = "Kahana was right", TeamStatus = "Closed", e_Employee_team_leader = "4" }); db.SaveChanges(); } return View("Index"); }