public void populateSuppliers(UniDBContext ctx) { List <Supplier> suppliers = new List <Supplier>(); Supplier s1 = new Supplier() { SupplierCode = "ALPA", Address = "Blk 1128, Ang Mo Kio Industrial Park #02-1108 aNG mO kIO sTREET 62 sINGAPORE 622262", Priority = 1, ContactName = "Ms Irene Tan", PhoneNo = "4619928", FaxNo = "4612238", SupplierName = "ALPHA Office Supplies" }; Supplier s2 = new Supplier() { SupplierCode = "CHEP", Address = "Blk 34, Clementi Road #07-02 Ban Ban Soh Building Singapore 110525", Priority = 2, ContactName = "Mr Soh Kway Koh", PhoneNo = "3543234", FaxNo = "4742434", SupplierName = "Cheap Stationer" }; Supplier s3 = new Supplier() { SupplierCode = "BANE", Address = "Blk 124, Alexandra Road #03-04 Banes Building Singapore 550315", Priority = 3, ContactName = "Mr Loh Ah Pek", PhoneNo = "4781234", FaxNo = "4792434", SupplierName = "BANES Shop" }; Supplier s4 = new Supplier() { SupplierCode = "OMEG", Address = "Blk 11, Hillview Avenue #03-04, Singapore 679036", Priority = 4, ContactName = "Mr Ronnie ho", PhoneNo = "7671233", FaxNo = "7671234", SupplierName = "OMEGA Stationery Supplier" }; suppliers.Add(s1); suppliers.Add(s2); suppliers.Add(s3); suppliers.Add(s4); ctx.Suppliers.AddRange(suppliers); }
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(); }