public void setReps()
{
using (var ctx = new UniDBContext())
{
User e2 = ctx.Users.Where(u => u.Username == "cse2").FirstOrDefault();
Department csd = ctx.Departments.Where(d => d.DepartmentName == "CS").FirstOrDefault();
csd.Representative = e2;
User e4 = ctx.Users.Where(u => u.Username == "enge2").FirstOrDefault();
Department engd = ctx.Departments.Where(d => d.DepartmentName == "English").FirstOrDefault();
engd.Representative = e4;
ctx.SaveChanges();
}
}
public static void PopulatePoints(UniDBContext ctx)
{
PickUpPoint p1 = new PickUpPoint()
{
Location = "Stationery Store - Administration Building",
PickUpTime = "9:30 AM"
};
PickUpPoint p2 = new PickUpPoint()
{
Location = "Management school",
PickUpTime = "11:00 AM"
};
PickUpPoint p3 = new PickUpPoint()
{
Location = "Medical School",
PickUpTime = "9:30 AM"
};
PickUpPoint p4 = new PickUpPoint()
{
Location = "Engineering School",
PickUpTime = "11:00 AM"
};
PickUpPoint p5 = new PickUpPoint()
{
Location = "Science School",
PickUpTime = "9:30 AM"
};
PickUpPoint p6 = new PickUpPoint()
{
Location = "University Hostpital",
PickUpTime = "11:00 AM"
};
ctx.PickUpPoints.Add(p1);
ctx.PickUpPoints.Add(p2);
ctx.PickUpPoints.Add(p3);
ctx.PickUpPoints.Add(p4);
ctx.PickUpPoints.Add(p5);
ctx.PickUpPoints.Add(p6);
ctx.SaveChanges();
}
public void populateUsers(UniDBContext ctx)
{
ICollection <User> users = new List <User>();
User e1 = new User()
{
Name = "CS Employee 1",
Username = "******",
Password = "******",
Rank = (int)UserRank.Employee,
Email = "*****@*****.**"
};
User e2 = new User()
{
Name = "CS Employee 2",
Username = "******",
Password = "******",
Rank = (int)UserRank.Employee
};
User csHead = new User()
{
Name = "CS Head",
Username = "******",
Password = "******",
Rank = (int)UserRank.Head,
Email = "*****@*****.**"
};
User e3 = new User()
{
Name = "English Employee 1",
Username = "******",
Password = "******",
Rank = (int)UserRank.Employee
};
User e4 = new User()
{
Name = "English Employee 2",
Username = "******",
Password = "******",
Rank = (int)UserRank.Employee
};
User engHead = new User()
{
Name = "English Head",
Username = "******",
Password = "******",
Rank = (int)UserRank.Head
};
User storeClerk1 = new User()
{
Name = "Store Clerk 1",
Username = "******",
Password = "******",
Rank = (int)UserRank.Clerk
};
User storeClerk2 = new User()
{
Name = "Store Clerk 2",
Username = "******",
Password = "******",
Rank = (int)UserRank.Clerk
};
User storeClerk3 = new User()
{
Name = "Store Clerk 3",
Username = "******",
Password = "******",
Rank = (int)UserRank.Clerk
};
User storeManager = new User()
{
Name = "Store Manager",
Username = "******",
Password = "******",
Rank = (int)UserRank.Manager
};
User storeSupervisor = new User()
{
Name = "Store Supervisor",
Username = "******",
Password = "******",
Rank = (int)UserRank.Supervisor
};
Department csd = new Department()
{
DepartmentName = "CS",
};
Department engd = new Department()
{
DepartmentName = "English",
};
Department stored = new Department()
{
DepartmentName = "Store",
};
e1.Department = csd;
e2.Department = csd;
csHead.Department = csd;
e3.Department = engd;
e4.Department = engd;
engHead.Department = engd;
storeManager.Department = stored;
storeClerk1.Department = stored;
storeClerk2.Department = stored;
storeClerk3.Department = stored;
storeSupervisor.Department = stored;
ctx.Users.Add(e1);
ctx.Users.Add(e2);
ctx.Users.Add(csHead);
ctx.Departments.Add(csd);
ctx.Users.Add(e3);
ctx.Users.Add(e4);
ctx.Users.Add(engHead);
ctx.Departments.Add(engd);
ctx.Users.Add(storeClerk1);
ctx.Users.Add(storeClerk2);
ctx.Users.Add(storeClerk3);
ctx.Users.Add(storeSupervisor);
ctx.Users.Add(storeManager);
ctx.Departments.Add(stored);
ctx.SaveChanges();
}