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();
            }
        }
Exemple #2
0
        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();
            }
        }