public DbSeeder(StationeryContext dbcontext) { using (MD5 md5Hash = MD5.Create()) { string time1 = "9:30am"; string time2 = "11:00am"; CollectionPoint cp1 = new CollectionPoint(); cp1.Id = Guid.NewGuid().ToString(); cp1.Location = "Stationery Store - Administration Building"; cp1.Time = time1; dbcontext.Add(cp1); CollectionPoint cp2 = new CollectionPoint(); cp2.Id = Guid.NewGuid().ToString(); cp2.Location = "Management School"; cp2.Time = time2; dbcontext.Add(cp2); CollectionPoint cp3 = new CollectionPoint(); cp3.Id = Guid.NewGuid().ToString(); cp3.Location = "Medical School"; cp3.Time = time1; dbcontext.Add(cp3); CollectionPoint cp4 = new CollectionPoint(); cp4.Id = Guid.NewGuid().ToString(); cp4.Location = "Engineering School"; cp4.Time = time1; dbcontext.Add(cp4); CollectionPoint cp5 = new CollectionPoint(); cp5.Id = Guid.NewGuid().ToString(); cp5.Location = "Science School"; cp5.Time = time1; dbcontext.Add(cp5); CollectionPoint cp6 = new CollectionPoint(); cp6.Id = Guid.NewGuid().ToString(); cp6.Location = "University Hospital"; cp6.Time = time2; dbcontext.Add(cp6); ItemCategory category1 = new ItemCategory(); category1.Id = Guid.NewGuid().ToString(); category1.name = "Clip"; dbcontext.Add(category1); ItemCategory category2 = new ItemCategory(); category2.Id = Guid.NewGuid().ToString(); category2.name = "Envelope"; dbcontext.Add(category2); ItemCategory category3 = new ItemCategory(); category3.Id = Guid.NewGuid().ToString(); category3.name = "Eraser"; dbcontext.Add(category3); ItemCategory category4 = new ItemCategory(); category4.Id = Guid.NewGuid().ToString(); category4.name = "Exercise"; dbcontext.Add(category4); ItemCategory category5 = new ItemCategory(); category5.Id = Guid.NewGuid().ToString(); category5.name = "File"; dbcontext.Add(category5); ItemCategory category6 = new ItemCategory(); category6.Id = Guid.NewGuid().ToString(); category6.name = "Pen"; dbcontext.Add(category6); ItemCategory category7 = new ItemCategory(); category7.Id = Guid.NewGuid().ToString(); category7.name = "Puncher"; dbcontext.Add(category7); ItemCategory category8 = new ItemCategory(); category8.Id = Guid.NewGuid().ToString(); category8.name = "Pad"; dbcontext.Add(category8); ItemCategory category9 = new ItemCategory(); category9.Id = Guid.NewGuid().ToString(); category9.name = "Paper"; dbcontext.Add(category9); ItemCategory category10 = new ItemCategory(); category10.Id = Guid.NewGuid().ToString(); category10.name = "Ruler"; dbcontext.Add(category10); Inventory item1 = new Inventory(); item1.Id = Guid.NewGuid().ToString(); item1.ItemCategoryId = category1.Id; item1.itemCode = "C001"; item1.description = "Clips Double 1"; item1.stock = 500; item1.measurementUnit = "Dozen"; item1.location = "bin01"; item1.reorderLevel = 50; item1.reorderQty = 30; item1.price = 1; dbcontext.Add(item1); Inventory item2 = new Inventory(); item2.Id = Guid.NewGuid().ToString(); item2.ItemCategoryId = category1.Id; item2.itemCode = "C002"; item2.description = "Clips Double 2"; item2.stock = 500; item2.measurementUnit = "Dozen"; item2.location = "bin01"; item2.reorderLevel = 50; item2.reorderQty = 30; item2.price = 10; dbcontext.Add(item2); Inventory item3 = new Inventory(); item3.Id = Guid.NewGuid().ToString(); item3.ItemCategoryId = category1.Id; item3.itemCode = "C003"; item3.description = "Clips Double 3/4"; item3.stock = 500; item3.measurementUnit = "Dozen"; item3.location = "bin01"; item3.reorderLevel = 50; item3.reorderQty = 30; item3.price = 2; dbcontext.Add(item3); Inventory item4 = new Inventory(); item4.Id = Guid.NewGuid().ToString(); item4.ItemCategoryId = category1.Id; item4.itemCode = "C004"; item4.description = "Clips Paper Large"; item4.stock = 500; item4.measurementUnit = "Box"; item4.location = "bin01"; item4.reorderLevel = 50; item4.reorderQty = 30; item4.price = 3; dbcontext.Add(item4); Inventory item5 = new Inventory(); item5.Id = Guid.NewGuid().ToString(); item5.ItemCategoryId = category1.Id; item5.itemCode = "C005"; item5.description = "Clips Paper Medium"; item5.stock = 500; item5.measurementUnit = "Box"; item5.location = "bin01"; item5.reorderLevel = 50; item5.reorderQty = 30; item5.price = 1.5; dbcontext.Add(item5); Inventory item6 = new Inventory(); item6.Id = Guid.NewGuid().ToString(); item6.ItemCategoryId = category1.Id; item6.itemCode = "C006"; item6.description = "Clips Paper Small"; item6.stock = 500; item6.measurementUnit = "Box"; item6.location = "bin01"; item6.reorderLevel = 50; item6.reorderQty = 30; item6.price = 0.5; dbcontext.Add(item6); Inventory item7 = new Inventory(); item7.Id = Guid.NewGuid().ToString(); item7.ItemCategoryId = category2.Id; item7.itemCode = "E001"; item7.description = "Envelope Brown(3x6)"; item7.stock = 500; item7.measurementUnit = "Each"; item7.location = "bin02"; item7.reorderLevel = 600; item7.reorderQty = 400; item7.price = 0.7; dbcontext.Add(item7); Inventory item8 = new Inventory(); item8.Id = Guid.NewGuid().ToString(); item8.ItemCategoryId = category2.Id; item8.itemCode = "E002"; item8.description = "Envelope Brown(3x6) w/Window"; item8.stock = 500; item8.measurementUnit = "Each"; item8.location = "bin02"; item8.reorderLevel = 600; item8.reorderQty = 400; item8.price = 0.9; dbcontext.Add(item8); Inventory item9 = new Inventory(); item9.Id = Guid.NewGuid().ToString(); item9.ItemCategoryId = category2.Id; item9.itemCode = "E003"; item9.description = "Envelope Brown(5x7)"; item9.stock = 500; item9.measurementUnit = "Each"; item9.location = "bin02"; item9.reorderLevel = 600; item9.reorderQty = 400; item9.price = 0.8; dbcontext.Add(item9); Inventory item10 = new Inventory(); item10.Id = Guid.NewGuid().ToString(); item10.ItemCategoryId = category2.Id; item10.itemCode = "E004"; item10.description = "Envelope Brown(5x7) w/Window"; item10.stock = 500; item10.measurementUnit = "Each"; item10.location = "bin02"; item10.reorderLevel = 600; item10.reorderQty = 400; item10.price = 1.1; dbcontext.Add(item10); Inventory item11 = new Inventory(); item11.Id = Guid.NewGuid().ToString(); item11.ItemCategoryId = category7.Id; item11.itemCode = "P004"; item11.description = "Pancer Brown(5x7) w/Window"; item11.stock = 500; item11.measurementUnit = "Each"; item11.location = "bin07"; item11.reorderLevel = 600; item11.reorderQty = 400; item11.price = 1.1; dbcontext.Add(item11); Inventory item12 = new Inventory(); item12.Id = Guid.NewGuid().ToString(); item12.ItemCategoryId = category6.Id; item12.itemCode = "PE004"; item12.description = "Pen red"; item12.stock = 500; item12.measurementUnit = "Each"; item12.location = "bin07"; item12.reorderLevel = 600; item12.reorderQty = 400; item12.price = 1.1; dbcontext.Add(item12); Supplier supplier1 = new Supplier(); supplier1.Id = Guid.NewGuid().ToString(); supplier1.supplierCode = "ALPA"; supplier1.name = "ALPHA Office Supplies"; supplier1.address = "Blk 1128, Ang Mo Kio Industrial Park #02-1108 Ang Mo Kio Street 62 Singapore 622262"; supplier1.contactNo = 4619928; supplier1.faxNo = 4612238; dbcontext.Add(supplier1); Supplier supplier2 = new Supplier(); supplier2.Id = Guid.NewGuid().ToString(); supplier2.supplierCode = "CHEP"; supplier2.name = "Cheap Stationer"; supplier2.address = "Blk 34, Clementi Road #07-02 Ban Ban Soh Building Singapore 110525"; supplier2.contactNo = 3543234; supplier2.faxNo = 4742434; dbcontext.Add(supplier2); Supplier supplier3 = new Supplier(); supplier3.Id = Guid.NewGuid().ToString(); supplier3.supplierCode = "BANE"; supplier3.name = "BANES Shop"; supplier3.address = "Blk 124, Alexandra Road #03-04 Banes Building Singapore 550315"; supplier3.contactNo = 4781234; supplier3.faxNo = 4792434; dbcontext.Add(supplier3); Inventory_Supplier inventory_Supplier1 = new Inventory_Supplier(); inventory_Supplier1.Id = Guid.NewGuid().ToString(); inventory_Supplier1.InventoryItemId = item1.Id; inventory_Supplier1.SupplierId = supplier1.Id; inventory_Supplier1.qtyOrdered = 300; dbcontext.Add(inventory_Supplier1); Inventory_Supplier inventory_Supplier2 = new Inventory_Supplier(); inventory_Supplier2.Id = Guid.NewGuid().ToString(); inventory_Supplier2.InventoryItemId = item2.Id; inventory_Supplier2.SupplierId = supplier1.Id; inventory_Supplier2.qtyOrdered = 300; dbcontext.Add(inventory_Supplier2); Inventory_Supplier inventory_Supplier3 = new Inventory_Supplier(); inventory_Supplier3.Id = Guid.NewGuid().ToString(); inventory_Supplier3.InventoryItemId = item3.Id; inventory_Supplier3.SupplierId = supplier1.Id; inventory_Supplier3.qtyOrdered = 300; dbcontext.Add(inventory_Supplier3); Inventory_Supplier inventory_Supplier4 = new Inventory_Supplier(); inventory_Supplier4.Id = Guid.NewGuid().ToString(); inventory_Supplier4.InventoryItemId = item4.Id; inventory_Supplier4.SupplierId = supplier1.Id; inventory_Supplier4.qtyOrdered = 300; dbcontext.Add(inventory_Supplier4); Inventory_Supplier inventory_Supplier5 = new Inventory_Supplier(); inventory_Supplier5.Id = Guid.NewGuid().ToString(); inventory_Supplier5.InventoryItemId = item5.Id; inventory_Supplier5.SupplierId = supplier2.Id; inventory_Supplier5.qtyOrdered = 300; dbcontext.Add(inventory_Supplier5); Inventory_Supplier inventory_Supplier6 = new Inventory_Supplier(); inventory_Supplier6.Id = Guid.NewGuid().ToString(); inventory_Supplier6.InventoryItemId = item6.Id; inventory_Supplier6.SupplierId = supplier2.Id; inventory_Supplier6.qtyOrdered = 300; dbcontext.Add(inventory_Supplier6); Inventory_Supplier inventory_Supplier7 = new Inventory_Supplier(); inventory_Supplier7.Id = Guid.NewGuid().ToString(); inventory_Supplier7.InventoryItemId = item7.Id; inventory_Supplier7.SupplierId = supplier2.Id; inventory_Supplier7.qtyOrdered = 300; dbcontext.Add(inventory_Supplier7); Inventory_Supplier inventory_Supplier8 = new Inventory_Supplier(); inventory_Supplier8.Id = Guid.NewGuid().ToString(); inventory_Supplier8.InventoryItemId = item8.Id; inventory_Supplier8.SupplierId = supplier3.Id; inventory_Supplier8.qtyOrdered = 300; dbcontext.Add(inventory_Supplier8); Inventory_Supplier inventory_Supplier9 = new Inventory_Supplier(); inventory_Supplier9.Id = Guid.NewGuid().ToString(); inventory_Supplier9.InventoryItemId = item9.Id; inventory_Supplier9.SupplierId = supplier3.Id; inventory_Supplier9.qtyOrdered = 300; dbcontext.Add(inventory_Supplier9); Inventory_Supplier inventory_Supplier10 = new Inventory_Supplier(); inventory_Supplier10.Id = Guid.NewGuid().ToString(); inventory_Supplier10.InventoryItemId = item10.Id; inventory_Supplier10.SupplierId = supplier3.Id; inventory_Supplier10.qtyOrdered = 300; dbcontext.Add(inventory_Supplier10); Inventory_Supplier inventory_Supplier11 = new Inventory_Supplier(); inventory_Supplier11.Id = Guid.NewGuid().ToString(); inventory_Supplier11.InventoryItemId = item11.Id; inventory_Supplier11.SupplierId = supplier1.Id; inventory_Supplier11.qtyOrdered = 300; dbcontext.Add(inventory_Supplier11); Inventory_Supplier inventory_Supplier12 = new Inventory_Supplier(); inventory_Supplier12.Id = Guid.NewGuid().ToString(); inventory_Supplier12.InventoryItemId = item12.Id; inventory_Supplier12.SupplierId = supplier1.Id; inventory_Supplier12.qtyOrdered = 300; dbcontext.Add(inventory_Supplier12); Departments EN = new Departments(); EN.Id = Guid.NewGuid().ToString(); EN.DeptCode = "ENGL"; EN.DeptName = "English Dept"; EN.ContactName = "English"; EN.FaxNumber = 123456; EN.PhoneNumber = 112124; EN.CollectionPointId = cp1.Id; dbcontext.Add(EN); Departments CS = new Departments(); CS.Id = Guid.NewGuid().ToString(); CS.DeptCode = "CPSC"; CS.DeptName = "ComputerScience"; CS.ContactName = "Computer"; CS.FaxNumber = 111111; CS.PhoneNumber = 1165613; CS.CollectionPointId = cp3.Id; dbcontext.Add(CS); Departments Comm = new Departments(); Comm.Id = Guid.NewGuid().ToString(); Comm.DeptCode = "ENGL"; Comm.DeptName = "Commerce Dept"; Comm.ContactName = "Commerce"; Comm.FaxNumber = 22222; Comm.PhoneNumber = 112164; Comm.CollectionPointId = cp2.Id; dbcontext.Add(Comm); Departments regr = new Departments(); regr.Id = Guid.NewGuid().ToString(); regr.DeptCode = "Regr"; regr.DeptName = "Registra Dept"; regr.ContactName = "Registra"; regr.FaxNumber = 33333; regr.PhoneNumber = 112231; regr.CollectionPointId = cp5.Id; dbcontext.Add(regr); Departments StationeryDept = new Departments(); StationeryDept.Id = Guid.NewGuid().ToString(); StationeryDept.DeptCode = "STAT"; StationeryDept.DeptName = "Stationery Dept"; StationeryDept.ContactName = "Stationery"; StationeryDept.PhoneNumber = 69999; StationeryDept.FaxNumber = 4444; StationeryDept.CollectionPointId = cp1.Id; dbcontext.Add(StationeryDept); Employee employee1 = new Employee(); employee1.Id = Guid.NewGuid().ToString(); employee1.Name = "nhw"; employee1.Email = "*****@*****.**"; string emp1psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee1.Password = emp1psw; employee1.Role = Role.STORE_CLERK; employee1.DepartmentsId = StationeryDept.Id; dbcontext.Add(employee1); Employee employee2 = new Employee(); employee2.Id = Guid.NewGuid().ToString(); employee2.Name = "wpa"; employee2.Email = "*****@*****.**"; string emp2psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee2.Password = emp2psw; employee2.Role = Role.STORE_SUPERVISOR; employee2.DepartmentsId = StationeryDept.Id; dbcontext.Add(employee2); Employee employee3 = new Employee(); employee3.Id = Guid.NewGuid().ToString(); employee3.Name = "keith"; employee3.Email = "*****@*****.**"; string emp3psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee3.Password = emp3psw; employee3.Role = Role.STORE_MANAGER; employee3.DepartmentsId = StationeryDept.Id; dbcontext.Add(employee3); StationeryDept.DeptHead = employee3.Name; StationeryDept.Representative = employee2.Name; Employee employee4 = new Employee(); employee4.Id = Guid.NewGuid().ToString(); employee4.Name = "tom"; employee4.Email = "*****@*****.**"; string emp4psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee4.Password = emp4psw; employee4.Role = Role.DEPT_HEAD; employee4.DepartmentsId = EN.Id; dbcontext.Add(employee4); Employee employee5 = new Employee(); employee5.Id = Guid.NewGuid().ToString(); employee5.Name = "tessa"; employee5.Email = "*****@*****.**"; string emp5psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee5.Password = emp5psw; employee5.Role = Role.DEPT_REP; employee5.DepartmentsId = EN.Id; dbcontext.Add(employee5); EN.Representative = employee5.Name; EN.DeptHead = employee4.Name; Employee employee6 = new Employee(); employee6.Id = Guid.NewGuid().ToString(); employee6.Name = "kk"; employee6.Email = "*****@*****.**"; string emp6psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee6.Password = emp6psw; employee6.Role = Role.EMPLOYEE; employee6.DepartmentsId = EN.Id; dbcontext.Add(employee6); Employee employee7 = new Employee(); employee7.Id = Guid.NewGuid().ToString(); employee7.Name = "marine1"; employee7.Email = "*****@*****.**"; string emp7psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee7.Password = emp7psw; employee7.Role = Role.DEPT_HEAD; employee7.DepartmentsId = CS.Id; dbcontext.Add(employee7); Employee employee8 = new Employee(); employee8.Id = Guid.NewGuid().ToString(); employee8.Name = "noah"; employee8.Email = "*****@*****.**"; string emp8psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee8.Password = emp8psw; employee8.Role = Role.DEPT_REP; employee8.DepartmentsId = CS.Id; dbcontext.Add(employee8); CS.DeptHead = employee7.Name; CS.Representative = employee8.Name; Employee employee9 = new Employee(); employee9.Id = Guid.NewGuid().ToString(); employee9.Name = "liam"; employee9.Email = "*****@*****.**"; string emp9psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee9.Password = emp9psw; employee9.Role = Role.EMPLOYEE; employee9.DepartmentsId = CS.Id; dbcontext.Add(employee9); Employee employee10 = new Employee(); employee10.Id = Guid.NewGuid().ToString(); employee10.Name = "emma"; employee10.Email = "*****@*****.**"; string emp10psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee10.Password = emp10psw; employee10.Role = Role.DEPT_HEAD; employee10.DepartmentsId = Comm.Id; dbcontext.Add(employee10); Employee employee11 = new Employee(); employee11.Id = Guid.NewGuid().ToString(); employee11.Name = "willian"; employee11.Email = "*****@*****.**"; string emp11psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee11.Password = emp11psw; employee11.Role = Role.DEPT_REP; employee11.DepartmentsId = Comm.Id; dbcontext.Add(employee11); Comm.DeptHead = employee10.Name; Comm.Representative = employee11.Name; Employee employee12 = new Employee(); employee12.Id = Guid.NewGuid().ToString(); employee12.Name = "james"; employee12.Email = "*****@*****.**"; string emp12psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee12.Password = emp12psw; employee12.Role = Role.EMPLOYEE; employee12.DepartmentsId = Comm.Id; dbcontext.Add(employee12); Employee employee13 = new Employee(); employee13.Id = Guid.NewGuid().ToString(); employee13.Name = "ava"; employee13.Email = "*****@*****.**"; string emp13psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee13.Password = emp13psw; employee13.Role = Role.DEPT_HEAD; employee13.DepartmentsId = regr.Id; dbcontext.Add(employee13); Employee employee14 = new Employee(); employee14.Id = Guid.NewGuid().ToString(); employee14.Name = "isabella"; employee14.Email = "*****@*****.**"; string emp14psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee14.Password = emp14psw; employee14.Role = Role.DEPT_REP; employee14.DepartmentsId = regr.Id; dbcontext.Add(employee14); regr.DeptHead = employee13.Name; regr.Representative = employee14.Name; Employee employee15 = new Employee(); employee15.Id = Guid.NewGuid().ToString(); employee15.Name = "liam"; employee15.Email = "*****@*****.**"; string emp15psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee15.Password = emp15psw; employee15.Role = Role.EMPLOYEE; employee15.DepartmentsId = regr.Id; dbcontext.Add(employee15); PurchaseOrder po1 = new PurchaseOrder(); po1.Id = Guid.NewGuid().ToString(); po1.SupplierId = supplier1.Id; po1.EmployeeId = employee1.Id; po1.date = DateTime.Now; po1.status = POStatus.PENDING; dbcontext.Add(po1); PurchaseOrderDetails po1detail1 = new PurchaseOrderDetails(); po1detail1.Id = Guid.NewGuid().ToString(); po1detail1.PurchaseOrderId = po1.Id; po1detail1.InventoryId = item1.Id; po1detail1.quantity = 20; dbcontext.Add(po1detail1); PurchaseOrderDetails po1detail2 = new PurchaseOrderDetails(); po1detail2.Id = Guid.NewGuid().ToString(); po1detail2.PurchaseOrderId = po1.Id; po1detail2.InventoryId = item3.Id; po1detail2.quantity = 20; dbcontext.Add(po1detail2); PurchaseOrderDetails po1detail3 = new PurchaseOrderDetails(); po1detail3.Id = Guid.NewGuid().ToString(); po1detail3.PurchaseOrderId = po1.Id; po1detail3.InventoryId = item4.Id; po1detail3.quantity = 20; dbcontext.Add(po1detail3); PurchaseOrder po2 = new PurchaseOrder(); po2.Id = Guid.NewGuid().ToString(); po2.SupplierId = supplier2.Id; po2.EmployeeId = employee1.Id; po2.date = DateTime.Now.AddMonths(-1); po2.status = POStatus.PENDING; dbcontext.Add(po2); PurchaseOrderDetails po2detail1 = new PurchaseOrderDetails(); po2detail1.Id = Guid.NewGuid().ToString(); po2detail1.PurchaseOrderId = po2.Id; po2detail1.InventoryId = item2.Id; po2detail1.quantity = 20; dbcontext.Add(po2detail1); PurchaseOrderDetails po2detail2 = new PurchaseOrderDetails(); po2detail2.Id = Guid.NewGuid().ToString(); po2detail2.PurchaseOrderId = po2.Id; po2detail2.InventoryId = item7.Id; po2detail2.quantity = 20; dbcontext.Add(po2detail2); PurchaseOrderDetails po2detail3 = new PurchaseOrderDetails(); po2detail3.Id = Guid.NewGuid().ToString(); po2detail3.PurchaseOrderId = po2.Id; po2detail3.InventoryId = item5.Id; po2detail3.quantity = 20; dbcontext.Add(po2detail3); PurchaseOrderDetails po2detail4 = new PurchaseOrderDetails(); po2detail4.Id = Guid.NewGuid().ToString(); po2detail4.PurchaseOrderId = po2.Id; po2detail4.InventoryId = item11.Id; po2detail4.quantity = 10; dbcontext.Add(po2detail4); PurchaseOrderDetails po2detail5 = new PurchaseOrderDetails(); po2detail5.Id = Guid.NewGuid().ToString(); po2detail5.PurchaseOrderId = po2.Id; po2detail5.InventoryId = item12.Id; po2detail5.quantity = 15; dbcontext.Add(po2detail5); Requisition requisition1 = new Requisition(); requisition1.Id = EN.DeptCode + "_" + DateTime.Now.ToString("MM/dd/yyyy/HH:mm:ss"); requisition1.DepartmentId = EN.Id; requisition1.EmployeeId = employee6.Id; requisition1.ApprovedEmployeeId = employee4.Id; requisition1.DateSubmitted = DateTime.Now; requisition1.status = ReqStatus.APPROVED; requisition1.Remarks = "nothing"; dbcontext.Add(requisition1); RequisitionDetail requisition1Detail = new RequisitionDetail(); requisition1Detail.Id = Guid.NewGuid().ToString(); requisition1Detail.RequisitionId = requisition1.Id; requisition1Detail.InventoryId = item1.Id; requisition1Detail.RequestedQty = 20; requisition1Detail.DistributedQty = 0; dbcontext.Add(requisition1Detail); RequisitionDetail requisition1Detail2 = new RequisitionDetail(); requisition1Detail2.Id = Guid.NewGuid().ToString(); requisition1Detail2.RequisitionId = requisition1.Id; requisition1Detail2.InventoryId = item11.Id; requisition1Detail2.RequestedQty = 20; requisition1Detail2.DistributedQty = 0; dbcontext.Add(requisition1Detail2); RequisitionDetail requisition1Detail3 = new RequisitionDetail(); requisition1Detail3.Id = Guid.NewGuid().ToString(); requisition1Detail3.RequisitionId = requisition1.Id; requisition1Detail3.InventoryId = item10.Id; requisition1Detail3.RequestedQty = 20; requisition1Detail3.DistributedQty = 0; dbcontext.Add(requisition1Detail3); Requisition requisition2 = new Requisition(); requisition2.Id = CS.DeptCode + "_" + DateTime.Now.ToString("MM/dd/yyyy/HH:mm:ss"); requisition2.DepartmentId = CS.Id; requisition2.EmployeeId = employee9.Id; requisition2.ApprovedEmployeeId = employee7.Id; requisition2.DateSubmitted = DateTime.Now; requisition2.status = ReqStatus.OUTSTAND; requisition2.Remarks = "nothing"; dbcontext.Add(requisition2); RequisitionDetail requisition2Detail = new RequisitionDetail(); requisition2Detail.Id = Guid.NewGuid().ToString(); requisition2Detail.RequisitionId = requisition2.Id; requisition2Detail.InventoryId = item2.Id; requisition2Detail.RequestedQty = 20; requisition2Detail.DistributedQty = 0; dbcontext.Add(requisition2Detail); RequisitionDetail requisition2Detail2 = new RequisitionDetail(); requisition2Detail2.Id = Guid.NewGuid().ToString(); requisition2Detail2.RequisitionId = requisition2.Id; requisition2Detail2.InventoryId = item3.Id; requisition2Detail2.RequestedQty = 20; requisition2Detail2.DistributedQty = 0; dbcontext.Add(requisition2Detail2); //-------------------------------------------------------------Seeding for training model--------------------------------------------------------------------------------------> Inventory[] arrInv = new Inventory[] { item1, item2, item3, item4, item5, item6, item7, item8, item9, item10 }; Random rand = new Random(); int size = 10; for (int i = 0; i < size; i++) { DateTime randDate = DateTime.Now.AddDays(-rand.Next(1100)); int randomQty = rand.Next(1, 100); int randomStatus = rand.Next(0, 7); Requisition r1 = new Requisition(); r1.Id = EN.DeptCode + "_" + Guid.NewGuid().ToString(); r1.DepartmentId = EN.Id; r1.EmployeeId = employee6.Id; r1.ApprovedEmployeeId = employee4.Id; r1.DateSubmitted = randDate; r1.status = (ReqStatus)randomStatus; r1.Remarks = "nothing"; List <string> list = new List <string>(); List <RequisitionDetail> rLists = new List <RequisitionDetail>(); for (int j = 0; j < 3; j++) { RequisitionDetail rd1 = new RequisitionDetail(); rd1.Id = Guid.NewGuid().ToString(); int randomItem = rand.Next(arrInv.Length); string item = arrInv[randomItem].Id; while (list.FirstOrDefault(x => x.Contains(item)) != null) { randomItem = rand.Next(arrInv.Length); item = arrInv[randomItem].Id; } rd1.RequisitionId = r1.Id; rd1.Inventory = arrInv[randomItem]; //rd1.InventoryId = item; rd1.RequestedQty = randomQty; rd1.DistributedQty = 0; list.Add(arrInv[randomItem].Id); rLists.Add(rd1); } list.Clear(); dbcontext.AddRangeAsync(rLists); dbcontext.Add(r1); int randomPOStatus = rand.Next(0, 2); PurchaseOrder po11 = new PurchaseOrder(); po11.Id = Guid.NewGuid().ToString(); po11.SupplierId = supplier1.Id; po11.EmployeeId = employee1.Id; po11.date = randDate; po11.status = (POStatus)randomPOStatus; dbcontext.Add(po11); for (int k = 0; k < 5; k++) { int randomI = rand.Next(arrInv.Length); PurchaseOrderDetails pod1 = new PurchaseOrderDetails(); pod1.Id = Guid.NewGuid().ToString(); pod1.PurchaseOrderId = po11.Id; pod1.InventoryId = arrInv[randomI].Id; pod1.quantity = randomQty; dbcontext.Add(pod1); } } //-------------------------------------------------------------Seeding for training model--------------------------------------------------------------------------------------> Requisition requisition3 = new Requisition(); requisition3.Id = regr.DeptCode + "_" + DateTime.Now.ToString("MM/dd/yyyy/HH:mm:ss"); requisition3.DepartmentId = regr.Id; requisition3.EmployeeId = employee15.Id; requisition3.ApprovedEmployeeId = employee13.Id; requisition3.DateSubmitted = DateTime.Now; requisition3.status = ReqStatus.REJECTED; requisition3.Remarks = "nothing"; dbcontext.Add(requisition3); Requisition requisition4 = new Requisition(); requisition4.Id = regr.DeptCode + "/" + DateTime.Now; requisition4.DepartmentId = regr.Id; requisition4.EmployeeId = employee15.Id; requisition4.ApprovedEmployeeId = employee13.Id; requisition4.DateSubmitted = DateTime.Now; requisition4.status = ReqStatus.PROCESSING; requisition4.Remarks = "nothing"; dbcontext.Add(requisition4); AdjustmentVoucher vouncher = new AdjustmentVoucher(); vouncher.Id = Guid.NewGuid().ToString(); vouncher.EmEmployeeId = employee1.Id; vouncher.appEmEmployeeId = employee2.Id; vouncher.InventoryId = item1.Id; vouncher.status = Status.PENDING; vouncher.qty = -5; vouncher.reason = "missing"; dbcontext.Add(vouncher); Disbursement d1 = new Disbursement() { Id = Guid.NewGuid().ToString(), GeneratedDate = DateTime.Now, CollectionDate = DateTime.Now, status = DisbusementStatus.DELIVERED, storeClerk = employee1, Departments = EN }; dbcontext.Add(d1); DisbursementDetail d1detail1 = new DisbursementDetail(); d1detail1.Id = Guid.NewGuid().ToString(); d1detail1.DisbursementId = d1.Id; d1detail1.RequisitionDetailId = requisition1Detail.Id; d1detail1.disbursedQty = 20; requisition1Detail.DistributedQty = 20; dbcontext.Add(d1detail1); Disbursement d4 = new Disbursement() { Id = Guid.NewGuid().ToString(), GeneratedDate = DateTime.Now, CollectionDate = DateTime.Now, storeClerk = employee1, status = DisbusementStatus.COMPLETED, Departments = EN }; dbcontext.Add(d4); DisbursementDetail d4detail1 = new DisbursementDetail(); d4detail1.Id = Guid.NewGuid().ToString(); d4detail1.DisbursementId = d4.Id; d4detail1.RequisitionDetailId = requisition2Detail.Id; d4detail1.disbursedQty = 20; requisition2Detail.DistributedQty = 20; dbcontext.Add(d4detail1); dbcontext.SaveChanges(); } }
public DbSeeder(StationeryContext dbcontext) { using (MD5 md5Hash = MD5.Create()) { string time1 = "9:30am"; string time2 = "11:00am"; CollectionPoint cp1 = new CollectionPoint(); cp1.Id = Guid.NewGuid().ToString(); cp1.Location = "Stationery Store - Administration Building"; cp1.Time = time1; dbcontext.Add(cp1); CollectionPoint cp2 = new CollectionPoint(); cp2.Id = Guid.NewGuid().ToString(); cp2.Location = "Management School"; cp2.Time = time2; dbcontext.Add(cp2); CollectionPoint cp3 = new CollectionPoint(); cp3.Id = Guid.NewGuid().ToString(); cp3.Location = "Medical School"; cp3.Time = time1; dbcontext.Add(cp3); CollectionPoint cp4 = new CollectionPoint(); cp4.Id = Guid.NewGuid().ToString(); cp4.Location = "Engineering School"; cp4.Time = time1; dbcontext.Add(cp4); CollectionPoint cp5 = new CollectionPoint(); cp5.Id = Guid.NewGuid().ToString(); cp5.Location = "Science School"; cp5.Time = time1; dbcontext.Add(cp5); CollectionPoint cp6 = new CollectionPoint(); cp6.Id = Guid.NewGuid().ToString(); cp6.Location = "University Hospital"; cp6.Time = time2; dbcontext.Add(cp6); ItemCategory category1 = new ItemCategory(); category1.Id = Guid.NewGuid().ToString(); category1.name = "Clip"; dbcontext.Add(category1); ItemCategory category2 = new ItemCategory(); category2.Id = Guid.NewGuid().ToString(); category2.name = "Envelope"; dbcontext.Add(category2); ItemCategory category3 = new ItemCategory(); category3.Id = Guid.NewGuid().ToString(); category3.name = "Eraser"; dbcontext.Add(category3); ItemCategory category4 = new ItemCategory(); category4.Id = Guid.NewGuid().ToString(); category4.name = "Exercise"; dbcontext.Add(category4); ItemCategory category5 = new ItemCategory(); category5.Id = Guid.NewGuid().ToString(); category5.name = "File"; dbcontext.Add(category5); ItemCategory category6 = new ItemCategory(); category6.Id = Guid.NewGuid().ToString(); category6.name = "Pen"; dbcontext.Add(category6); ItemCategory category7 = new ItemCategory(); category7.Id = Guid.NewGuid().ToString(); category7.name = "Puncher"; dbcontext.Add(category7); ItemCategory category8 = new ItemCategory(); category8.Id = Guid.NewGuid().ToString(); category8.name = "Pad"; dbcontext.Add(category8); ItemCategory category9 = new ItemCategory(); category9.Id = Guid.NewGuid().ToString(); category9.name = "Paper"; dbcontext.Add(category9); ItemCategory category10 = new ItemCategory(); category10.Id = Guid.NewGuid().ToString(); category10.name = "Ruler"; dbcontext.Add(category10); Inventory item1 = new Inventory(); item1.Id = Guid.NewGuid().ToString(); item1.ItemCategoryId = category1.Id; item1.itemCode = "C001"; item1.description = "Clips Double 1"; item1.stock = 100; item1.measurementUnit = "Dozen"; item1.location = "bin01"; item1.reorderLevel = 50; item1.reorderQty = 30; item1.price = 1; dbcontext.Add(item1); Inventory item2 = new Inventory(); item2.Id = Guid.NewGuid().ToString(); item2.ItemCategoryId = category1.Id; item2.itemCode = "C002"; item2.description = "Clips Double 2"; item2.stock = 100; item2.measurementUnit = "Dozen"; item2.location = "bin01"; item2.reorderLevel = 50; item2.reorderQty = 30; item2.price = 10; dbcontext.Add(item2); Inventory item3 = new Inventory(); item3.Id = Guid.NewGuid().ToString(); item3.ItemCategoryId = category1.Id; item3.itemCode = "C003"; item3.description = "Clips Double 3/4"; item3.stock = 100; item3.measurementUnit = "Dozen"; item3.location = "bin01"; item3.reorderLevel = 50; item3.reorderQty = 30; item3.price = 2; dbcontext.Add(item3); Inventory item4 = new Inventory(); item4.Id = Guid.NewGuid().ToString(); item4.ItemCategoryId = category1.Id; item4.itemCode = "C004"; item4.description = "Clips Paper Large"; item4.stock = 100; item4.measurementUnit = "Box"; item4.location = "bin01"; item4.reorderLevel = 50; item4.reorderQty = 30; item4.price = 3; dbcontext.Add(item4); Inventory item5 = new Inventory(); item5.Id = Guid.NewGuid().ToString(); item5.ItemCategoryId = category1.Id; item5.itemCode = "C005"; item5.description = "Clips Paper Medium"; item5.stock = 100; item5.measurementUnit = "Box"; item5.location = "bin01"; item5.reorderLevel = 50; item5.reorderQty = 30; item5.price = 1.5; dbcontext.Add(item5); Inventory item6 = new Inventory(); item6.Id = Guid.NewGuid().ToString(); item6.ItemCategoryId = category1.Id; item6.itemCode = "C006"; item6.description = "Clips Paper Small"; item6.stock = 100; item6.measurementUnit = "Box"; item6.location = "bin01"; item6.reorderLevel = 50; item6.reorderQty = 30; item6.price = 0.5; dbcontext.Add(item6); Inventory item7 = new Inventory(); item7.Id = Guid.NewGuid().ToString(); item7.ItemCategoryId = category2.Id; item7.itemCode = "E001"; item7.description = "Envelope Brown(3x6)"; item7.stock = 1000; item7.measurementUnit = "Each"; item7.location = "bin02"; item7.reorderLevel = 600; item7.reorderQty = 400; item7.price = 0.7; dbcontext.Add(item7); Inventory item8 = new Inventory(); item8.Id = Guid.NewGuid().ToString(); item8.ItemCategoryId = category2.Id; item8.itemCode = "E002"; item8.description = "Envelope Brown(3x6) w/Window"; item8.stock = 1000; item8.measurementUnit = "Each"; item8.location = "bin02"; item8.reorderLevel = 600; item8.reorderQty = 400; item8.price = 0.9; dbcontext.Add(item8); Inventory item9 = new Inventory(); item9.Id = Guid.NewGuid().ToString(); item9.ItemCategoryId = category2.Id; item9.itemCode = "E003"; item9.description = "Envelope Brown(5x7)"; item9.stock = 1000; item9.measurementUnit = "Each"; item9.location = "bin02"; item9.reorderLevel = 600; item9.reorderQty = 400; item9.price = 0.8; dbcontext.Add(item9); Inventory item10 = new Inventory(); item10.Id = Guid.NewGuid().ToString(); item10.ItemCategoryId = category2.Id; item10.itemCode = "E004"; item10.description = "Envelope Brown(5x7) w/Window"; item10.stock = 1000; item10.measurementUnit = "Each"; item10.location = "bin02"; item10.reorderLevel = 600; item10.reorderQty = 400; item10.price = 1.1; dbcontext.Add(item10); Supplier supplier1 = new Supplier(); supplier1.Id = Guid.NewGuid().ToString(); supplier1.supplierCode = "ALPA"; supplier1.name = "ALPHA Office Supplies"; supplier1.address = "Blk 1128, Ang Mo Kio Industrial Park #02-1108 Ang Mo Kio Street 62 Singapore 622262"; supplier1.contactNo = 4619928; supplier1.faxNo = 4612238; dbcontext.Add(supplier1); Supplier supplier2 = new Supplier(); supplier2.Id = Guid.NewGuid().ToString(); supplier2.supplierCode = "CHEP"; supplier2.name = "Cheap Stationer"; supplier2.address = "Blk 34, Clementi Road #07-02 Ban Ban Soh Building Singapore 110525"; supplier2.contactNo = 3543234; supplier2.faxNo = 4742434; dbcontext.Add(supplier2); Supplier supplier3 = new Supplier(); supplier3.Id = Guid.NewGuid().ToString(); supplier3.supplierCode = "BANE"; supplier3.name = "BANES Shop"; supplier3.address = "Blk 124, Alexandra Road #03-04 Banes Building Singapore 550315"; supplier3.contactNo = 4781234; supplier3.faxNo = 4792434; dbcontext.Add(supplier3); Inventory_Supplier inventory_Supplier1 = new Inventory_Supplier(); inventory_Supplier1.Id = Guid.NewGuid().ToString(); inventory_Supplier1.InventoryItemId = item1.Id; inventory_Supplier1.SupplierId = supplier1.Id; inventory_Supplier1.qtyOrdered = 300; dbcontext.Add(inventory_Supplier1); Inventory_Supplier inventory_Supplier2 = new Inventory_Supplier(); inventory_Supplier2.Id = Guid.NewGuid().ToString(); inventory_Supplier2.InventoryItemId = item2.Id; inventory_Supplier2.SupplierId = supplier1.Id; inventory_Supplier2.qtyOrdered = 300; dbcontext.Add(inventory_Supplier2); Inventory_Supplier inventory_Supplier3 = new Inventory_Supplier(); inventory_Supplier3.Id = Guid.NewGuid().ToString(); inventory_Supplier3.InventoryItemId = item3.Id; inventory_Supplier3.SupplierId = supplier1.Id; inventory_Supplier3.qtyOrdered = 300; dbcontext.Add(inventory_Supplier3); Inventory_Supplier inventory_Supplier4 = new Inventory_Supplier(); inventory_Supplier4.Id = Guid.NewGuid().ToString(); inventory_Supplier4.InventoryItemId = item4.Id; inventory_Supplier4.SupplierId = supplier1.Id; inventory_Supplier4.qtyOrdered = 300; dbcontext.Add(inventory_Supplier4); Inventory_Supplier inventory_Supplier5 = new Inventory_Supplier(); inventory_Supplier5.Id = Guid.NewGuid().ToString(); inventory_Supplier5.InventoryItemId = item5.Id; inventory_Supplier5.SupplierId = supplier2.Id; inventory_Supplier5.qtyOrdered = 300; dbcontext.Add(inventory_Supplier5); Inventory_Supplier inventory_Supplier6 = new Inventory_Supplier(); inventory_Supplier6.Id = Guid.NewGuid().ToString(); inventory_Supplier6.InventoryItemId = item6.Id; inventory_Supplier6.SupplierId = supplier2.Id; inventory_Supplier6.qtyOrdered = 300; dbcontext.Add(inventory_Supplier6); Inventory_Supplier inventory_Supplier7 = new Inventory_Supplier(); inventory_Supplier7.Id = Guid.NewGuid().ToString(); inventory_Supplier7.InventoryItemId = item7.Id; inventory_Supplier7.SupplierId = supplier2.Id; inventory_Supplier7.qtyOrdered = 300; dbcontext.Add(inventory_Supplier7); Inventory_Supplier inventory_Supplier8 = new Inventory_Supplier(); inventory_Supplier8.Id = Guid.NewGuid().ToString(); inventory_Supplier8.InventoryItemId = item8.Id; inventory_Supplier8.SupplierId = supplier3.Id; inventory_Supplier8.qtyOrdered = 300; dbcontext.Add(inventory_Supplier8); Inventory_Supplier inventory_Supplier9 = new Inventory_Supplier(); inventory_Supplier9.Id = Guid.NewGuid().ToString(); inventory_Supplier9.InventoryItemId = item9.Id; inventory_Supplier9.SupplierId = supplier3.Id; inventory_Supplier9.qtyOrdered = 300; dbcontext.Add(inventory_Supplier9); Inventory_Supplier inventory_Supplier10 = new Inventory_Supplier(); inventory_Supplier10.Id = Guid.NewGuid().ToString(); inventory_Supplier10.InventoryItemId = item10.Id; inventory_Supplier10.SupplierId = supplier3.Id; inventory_Supplier10.qtyOrdered = 300; dbcontext.Add(inventory_Supplier10); Departments EN = new Departments(); EN.Id = Guid.NewGuid().ToString(); EN.DeptCode = "ENGL"; EN.DeptName = "English Dept"; EN.DeptHead = "marine"; EN.FaxNumber = 0000000; EN.PhoneNumber = 1121231231; EN.CollectionPointId = cp1.Id; dbcontext.Add(EN); Departments CS = new Departments(); CS.Id = Guid.NewGuid().ToString(); CS.DeptCode = "CPSC"; CS.DeptName = "ComputerScience"; CS.DeptHead = "tom"; CS.FaxNumber = 1111111; CS.PhoneNumber = 116561231; CS.CollectionPointId = cp3.Id; dbcontext.Add(CS); Departments Comm = new Departments(); Comm.Id = Guid.NewGuid().ToString(); Comm.DeptCode = "ENGL"; Comm.DeptName = "Commerce Dept"; Comm.DeptHead = "emma"; Comm.FaxNumber = 222222; Comm.PhoneNumber = 1121678231; Comm.CollectionPointId = cp2.Id; dbcontext.Add(Comm); Departments regr = new Departments(); regr.Id = Guid.NewGuid().ToString(); regr.DeptCode = "Regr"; regr.DeptName = "Registra Dept"; regr.DeptHead = "ava"; regr.FaxNumber = 3333333; regr.PhoneNumber = 112129955231; regr.CollectionPointId = cp5.Id; dbcontext.Add(regr); Departments StationeryDept = new Departments(); StationeryDept.Id = Guid.NewGuid().ToString(); StationeryDept.DeptCode = "STAT"; StationeryDept.DeptName = "Stationery Dept"; StationeryDept.DeptHead = "marine"; StationeryDept.PhoneNumber = 65899999; StationeryDept.FaxNumber = 444444; StationeryDept.CollectionPointId = cp1.Id; dbcontext.Add(StationeryDept); Employee employee1 = new Employee(); employee1.Id = Guid.NewGuid().ToString(); employee1.Name = "nhw"; employee1.Email = "*****@*****.**"; string emp1psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee1.Password = emp1psw; employee1.Role = Role.STORE_CLERK; employee1.DepartmentsId = StationeryDept.Id; dbcontext.Add(employee1); Employee employee2 = new Employee(); employee2.Id = Guid.NewGuid().ToString(); employee2.Name = "wpa"; employee2.Email = "*****@*****.**"; string emp2psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee2.Password = emp2psw; employee2.Role = Role.STORE_SUPERVISOR; employee2.DepartmentsId = StationeryDept.Id; dbcontext.Add(employee2); Employee employee3 = new Employee(); employee3.Id = Guid.NewGuid().ToString(); employee3.Name = "keith"; employee3.Email = "*****@*****.**"; string emp3psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee3.Password = emp3psw; employee3.Role = Role.STORE_MANAGER; employee3.DepartmentsId = StationeryDept.Id; dbcontext.Add(employee3); Employee employee4 = new Employee(); employee4.Id = Guid.NewGuid().ToString(); employee4.Name = "tom"; employee4.Email = "*****@*****.**"; string emp4psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee4.Password = emp4psw; employee4.Role = Role.DEPT_HEAD; employee4.DepartmentsId = EN.Id; dbcontext.Add(employee4); Employee employee5 = new Employee(); employee5.Id = Guid.NewGuid().ToString(); employee5.Name = "tessa"; employee5.Email = "*****@*****.**"; string emp5psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee5.Password = emp5psw; employee5.Role = Role.DEPT_REP; employee5.DepartmentsId = EN.Id; dbcontext.Add(employee5); Employee employee6 = new Employee(); employee6.Id = Guid.NewGuid().ToString(); employee6.Name = "kk"; employee6.Email = "*****@*****.**"; string emp6psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee6.Password = emp6psw; employee6.Role = Role.EMPLOYEE; employee6.DepartmentsId = EN.Id; dbcontext.Add(employee6); Employee employee7 = new Employee(); employee7.Id = Guid.NewGuid().ToString(); employee7.Name = "marine1"; employee7.Email = "*****@*****.**"; string emp7psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee7.Password = emp7psw; employee7.Role = Role.DEPT_HEAD; employee7.DepartmentsId = CS.Id; dbcontext.Add(employee7); Employee employee8 = new Employee(); employee8.Id = Guid.NewGuid().ToString(); employee8.Name = "noah"; employee8.Email = "*****@*****.**"; string emp8psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee8.Password = emp8psw; employee8.Role = Role.DEPT_REP; employee8.DepartmentsId = CS.Id; dbcontext.Add(employee8); Employee employee9 = new Employee(); employee9.Id = Guid.NewGuid().ToString(); employee9.Name = "liam"; employee9.Email = "*****@*****.**"; string emp9psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee9.Password = emp9psw; employee9.Role = Role.EMPLOYEE; employee9.DepartmentsId = CS.Id; dbcontext.Add(employee9); Employee employee10 = new Employee(); employee10.Id = Guid.NewGuid().ToString(); employee10.Name = "emma"; employee10.Email = "*****@*****.**"; string emp10psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee10.Password = emp10psw; employee10.Role = Role.DEPT_HEAD; employee10.DepartmentsId = Comm.Id; dbcontext.Add(employee10); Employee employee11 = new Employee(); employee11.Id = Guid.NewGuid().ToString(); employee11.Name = "willian"; employee11.Email = "*****@*****.**"; string emp11psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee11.Password = emp11psw; employee11.Role = Role.DEPT_REP; employee11.DepartmentsId = Comm.Id; dbcontext.Add(employee11); Employee employee12 = new Employee(); employee12.Id = Guid.NewGuid().ToString(); employee12.Name = "james"; employee12.Email = "*****@*****.**"; string emp12psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee12.Password = emp12psw; employee12.Role = Role.EMPLOYEE; employee12.DepartmentsId = Comm.Id; dbcontext.Add(employee12); Employee employee13 = new Employee(); employee13.Id = Guid.NewGuid().ToString(); employee13.Name = "ava"; employee13.Email = "*****@*****.**"; string emp13psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee13.Password = emp13psw; employee13.Role = Role.DEPT_HEAD; employee13.DepartmentsId = regr.Id; dbcontext.Add(employee13); Employee employee14 = new Employee(); employee14.Id = Guid.NewGuid().ToString(); employee14.Name = "isabella"; employee14.Email = "*****@*****.**"; string emp14psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee14.Password = emp14psw; employee14.Role = Role.DEPT_REP; employee14.DepartmentsId = regr.Id; dbcontext.Add(employee14); Employee employee15 = new Employee(); employee15.Id = Guid.NewGuid().ToString(); employee15.Name = "liam"; employee15.Email = "*****@*****.**"; string emp15psw = MD5Hash.GetMd5Hash(md5Hash, "123"); employee15.Password = emp15psw; employee15.Role = Role.EMPLOYEE; employee15.DepartmentsId = regr.Id; dbcontext.Add(employee15); Requisition requisition1 = new Requisition(); requisition1.Id = EN.DeptCode + "_" + DateTime.Now.ToString("MM/dd/yyyy/HH:mm:ss"); requisition1.DepartmentId = EN.Id; requisition1.EmployeeId = employee6.Id; requisition1.ApprovedEmployeeId = employee4.Id; requisition1.DateSubmitted = DateTime.Now; requisition1.status = ReqStatus.APPROVED; requisition1.Remarks = "nothing"; dbcontext.Add(requisition1); RequisitionDetail requisition1Detail = new RequisitionDetail(); requisition1Detail.Id = Guid.NewGuid().ToString(); requisition1Detail.RequisitionId = requisition1.Id; requisition1Detail.InventoryId = item1.Id; requisition1Detail.RequestedQty = 20; requisition1Detail.DistributedQty = 0; dbcontext.Add(requisition1Detail); RequisitionDetail requisition1Detail2 = new RequisitionDetail(); requisition1Detail2.Id = Guid.NewGuid().ToString(); requisition1Detail2.RequisitionId = requisition1.Id; requisition1Detail2.InventoryId = item2.Id; requisition1Detail2.RequestedQty = 20; requisition1Detail2.DistributedQty = 0; dbcontext.Add(requisition1Detail2); //----------------------------------------------------------------------------------------------------------------------------------> Keith Requisition requisition11 = new Requisition(); requisition11.Id = EN.DeptCode + "_" + DateTime.Now; requisition11.DepartmentId = EN.Id; requisition11.EmployeeId = employee6.Id; requisition11.ApprovedEmployeeId = employee4.Id; requisition11.DateSubmitted = DateTime.Now; requisition11.status = ReqStatus.APPROVED; requisition11.Remarks = "nothing"; dbcontext.Add(requisition11); RequisitionDetail requisition1Detail11 = new RequisitionDetail(); requisition1Detail.Id = Guid.NewGuid().ToString(); requisition1Detail.RequisitionId = requisition11.Id; requisition1Detail.InventoryId = item1.Id; requisition1Detail.RequestedQty = 20; requisition1Detail.DistributedQty = 0; dbcontext.Add(requisition1Detail); RequisitionDetail requisition1Detail12 = new RequisitionDetail(); requisition1Detail2.Id = Guid.NewGuid().ToString(); requisition1Detail2.RequisitionId = requisition11.Id; requisition1Detail2.InventoryId = item2.Id; requisition1Detail2.RequestedQty = 20; requisition1Detail2.DistributedQty = 0; dbcontext.Add(requisition1Detail2); //----------------------------------------------------------------------------------------------------------------------------------> Keith Requisition requisition2 = new Requisition(); requisition2.Id = CS.DeptCode + "_" + DateTime.Now.ToString("MM/dd/yyyy/HH:mm:ss"); requisition2.DepartmentId = CS.Id; requisition2.EmployeeId = employee9.Id; requisition2.ApprovedEmployeeId = employee7.Id; requisition2.DateSubmitted = DateTime.Now; requisition2.status = ReqStatus.OUTSTAND; requisition2.Remarks = "nothing"; dbcontext.Add(requisition2); Requisition requisition3 = new Requisition(); requisition3.Id = regr.DeptCode + "_" + DateTime.Now.ToString("MM/dd/yyyy/HH:mm:ss"); requisition3.DepartmentId = regr.Id; requisition3.EmployeeId = employee15.Id; requisition3.ApprovedEmployeeId = employee13.Id; requisition3.DateSubmitted = DateTime.Now; requisition3.status = ReqStatus.REJECTED; requisition3.Remarks = "nothing"; dbcontext.Add(requisition3); Requisition requisition4 = new Requisition(); requisition4.Id = regr.DeptCode + "_" + DateTime.Now; requisition4.DepartmentId = regr.Id; requisition4.EmployeeId = employee15.Id; requisition4.ApprovedEmployeeId = employee13.Id; requisition4.DateSubmitted = DateTime.Now; requisition4.status = ReqStatus.PROCESSING; requisition4.Remarks = "nothing"; dbcontext.Add(requisition4); /* Requisition rq1 = new Requisition(); * rq1.Id = Comm.DeptCode + "_" + DateTime.Now; * rq1.ApprovedEmployee = employee10; * rq1.DepartmentId = Comm.Id; * rq1.Employee = employee12; * rq1.DateSubmitted = DateTime.Today; * rq1.status = ReqStatus.APPROVED; * dbcontext.Add(rq1); * * * RequisitionDetail rqd1 = new RequisitionDetail(); * rqd1.Id = Guid.NewGuid().ToString(); * rqd1.Requisition = rq1; * rqd1.Inventory = item8; * rqd1.RequestedQty = 88; * dbcontext.Add(rqd1); * * RequisitionDetail rqd2 = new RequisitionDetail(); * rqd2.Id = Guid.NewGuid().ToString(); * rqd2.Requisition = rq1; * rqd2.Inventory = item7; * rqd2.RequestedQty = 77; * dbcontext.Add(rqd2); * * RequisitionDetail rqd3 = new RequisitionDetail(); * rqd3.Id = Guid.NewGuid().ToString(); * rqd3.Requisition = rq1; * rqd3.Inventory = item5; * rqd3.RequestedQty = 55; * dbcontext.Add(rqd3); * * Requisition rq2 = new Requisition(); * rq2.Id = Comm.DeptCode + "_" + DateTime.Now; * rq2.ApprovedEmployee = employee10; * rq2.DepartmentId = Comm.Id; * rq2.Employee = employee12; * rq2.DateSubmitted = DateTime.Today; * rq2.status = ReqStatus.APPROVED; * dbcontext.Add(rq2); * * RequisitionDetail rqd4 = new RequisitionDetail(); * rqd4.Id = Guid.NewGuid().ToString(); * rqd4.Requisition = rq2; * rqd4.Inventory = item4; * rqd4.RequestedQty = 44; * dbcontext.Add(rqd4); * * RequisitionDetail rqd5 = new RequisitionDetail(); * rqd5.Id = Guid.NewGuid().ToString(); * rqd5.Requisition = rq2; * rqd5.Inventory = item5; * rqd5.RequestedQty = 55; * dbcontext.Add(rqd5); * * RequisitionDetail rqd6 = new RequisitionDetail(); * rqd6.Id = Guid.NewGuid().ToString(); * rqd6.Requisition = rq2; * rqd6.Inventory = item7; * rqd6.RequestedQty = 30; * dbcontext.Add(rqd6); * * Requisition rq3 = new Requisition(); * rq3.Id = EN.DeptCode + "_" + DateTime.Now; * rq3.ApprovedEmployee = employee4; * rq3.DepartmentId = EN.Id; * rq3.Employee = employee6; * rq3.DateSubmitted = DateTime.Today; * rq3.status = ReqStatus.APPROVED; * dbcontext.Add(rq3); * * RequisitionDetail rqd7 = new RequisitionDetail(); * rqd7.Id = Guid.NewGuid().ToString(); * rqd7.Requisition = rq3; * rqd7.RequisitionId = rq3.Id; * rqd7.Inventory = item5; * rqd7.RequestedQty = 50; * dbcontext.Add(rqd7); * * RequisitionDetail rqd8 = new RequisitionDetail(); * rqd8.Id = Guid.NewGuid().ToString(); * rqd8.Requisition = rq3; * rqd8.RequisitionId = rq3.Id; * rqd8.Inventory = item4; * rqd8.RequestedQty = 50; * dbcontext.Add(rqd8); * * RequisitionDetail rqd9 = new RequisitionDetail(); * rqd9.Id = Guid.NewGuid().ToString(); * rqd9.Requisition = rq3; * rqd9.RequisitionId = rq3.Id; * rqd9.Inventory = item1; * rqd9.RequestedQty = 50; * dbcontext.Add(rqd8);*/ dbcontext.SaveChanges(); } }