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