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