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