public Message actionCreateCollectionPoint(CollectionPoint objIn)
{
try
{
data.CollectionPoints.AddObject(objIn);
return this.getNewDefaultMessageForDBOperations(data.SaveChanges() == 1);
}
catch (Exception e)
{
return this.getNewDefaultMessageForException(e);
}
}
public Message actionUpdateCollectionPoint(CollectionPoint objIn)
{
try
{
objIn.EntityKey = data.CollectionPoints.Where(o => o.id == objIn.id).Single().EntityKey;
data.CollectionPoints.ApplyCurrentValues(objIn);
return this.getNewDefaultMessageForDBOperations(data.SaveChanges() == 1);
}
catch (Exception e)
{
return this.getNewDefaultMessageForException(e);
}
}
public DBSeeder(InventoryManagementSystemContext db,
IWebHostEnvironment environment,
ProductService pService,
DepartmentService dService,
ProductCategoryService pcService,
DisbursementFormService dfService,
StationeryRetrievalFormService srfService,
EmployeeTypeService etService,
EmployeeService empService,
RequisitionService rfService,
DelegationService delService,
SupplierService supService,
SupplierProductService spService,
InventoryTransactionService itService)
{
_hostingEnvironment = environment;
var uploads = Path.Combine(_hostingEnvironment.WebRootPath, "uploads");
string filePath6 = Path.Combine(uploads, "ProductCategory.csv");
string jsonString6 = ReadCSVFileUtil.ReadCSVFile(filePath6);
List <CSVProductCategory> productCategories = (List <CSVProductCategory>)JsonConvert.DeserializeObject(jsonString6, (typeof(List <CSVProductCategory>)));
pcService.SaveProductCategoryFromCSV(productCategories);
string filePath7 = Path.Combine(uploads, "Supplier.csv");
string jsonString7 = ReadCSVFileUtil.ReadCSVFile(filePath7);
List <CSVSupplier> suppliers = (List <CSVSupplier>)JsonConvert.DeserializeObject(jsonString7, (typeof(List <CSVSupplier>)));
supService.SaveSuppliersFromCSV(suppliers);
string filePath3 = Path.Combine(uploads, "EmployeeType.csv");
string jsonString3 = ReadCSVFileUtil.ReadCSVFile(filePath3);
List <CSVEmployeeType> employeeTypes = (List <CSVEmployeeType>)JsonConvert.DeserializeObject(jsonString3, (typeof(List <CSVEmployeeType>)));
etService.SaveEmployeeTypesFromCSV(employeeTypes);
ProductCategory pc1 = pcService.findProductCategory("Clip");
ProductCategory pc2 = pcService.findProductCategory("Envelope");
ProductCategory pc3 = pcService.findProductCategory("Eraser");
ProductCategory pc4 = pcService.findProductCategory("Exercise");
ProductCategory pc5 = pcService.findProductCategory("File");
ProductCategory pc6 = pcService.findProductCategory("Pen");
ProductCategory pc7 = pcService.findProductCategory("Puncher");
ProductCategory pc8 = pcService.findProductCategory("Pad");
ProductCategory pc9 = pcService.findProductCategory("Paper");
ProductCategory pc10 = pcService.findProductCategory("Ruler");
ProductCategory pc11 = pcService.findProductCategory("Scissors");
ProductCategory pc12 = pcService.findProductCategory("Tape");
ProductCategory pc13 = pcService.findProductCategory("Sharpener");
ProductCategory pc14 = pcService.findProductCategory("Shorthand");
ProductCategory pc15 = pcService.findProductCategory("Stapler");
ProductCategory pc16 = pcService.findProductCategory("Tacks");
ProductCategory pc17 = pcService.findProductCategory("Tparency");
ProductCategory pc18 = pcService.findProductCategory("Tray");
string filePath1 = Path.Combine(uploads, "Product.csv");
string jsonString = ReadCSVFileUtil.ReadCSVFile(filePath1);
List <CSVProduct> products = (List <CSVProduct>)JsonConvert.DeserializeObject(jsonString, (typeof(List <CSVProduct>)));
pService.SaveProductsFromCSV(products);
string filePath9 = Path.Combine(uploads, "SupplierProduct.csv");
string jsonString9 = ReadCSVFileUtil.ReadCSVFile(filePath9);
List <CSVSupplierProduct> supplierProducts = (List <CSVSupplierProduct>)JsonConvert.DeserializeObject(jsonString9, (typeof(List <CSVSupplierProduct>)));
spService.SaveSupplierProductsFromCSV(supplierProducts);
//save the images under images folder to database
var imagefolder = Path.Combine(_hostingEnvironment.WebRootPath, "images");
DirectoryInfo Folder = new DirectoryInfo(imagefolder);
FileInfo[] Images = Folder.GetFiles();
List <String> imagesList = new List <String>();
foreach (var image in Images)
{
imagesList.Add(String.Format(@"{0}", image.Name));
}
pService.SaveProductImages(imagesList);
EmployeeType empType1 = etService.FindEmployeeTypeByEmployeeTypeName("Store Clerk");
EmployeeType empType2 = etService.FindEmployeeTypeByEmployeeTypeName("Store Supervisor");
EmployeeType empType3 = etService.FindEmployeeTypeByEmployeeTypeName("Store Manager");
EmployeeType empType4 = etService.FindEmployeeTypeByEmployeeTypeName("Employee");
EmployeeType empType5 = etService.FindEmployeeTypeByEmployeeTypeName("Department Head");
EmployeeType empType6 = etService.FindEmployeeTypeByEmployeeTypeName("Department Representative");
EmployeeType empType7 = etService.FindEmployeeTypeByEmployeeTypeName("Warehouse Packer");
EmployeeType empType8 = etService.FindEmployeeTypeByEmployeeTypeName("Temporary Department Head");
CollectionPoint cp1 = new CollectionPoint()
{
CollectionName = "Stationery Store - Administration Building"
};
CollectionPoint cp2 = new CollectionPoint()
{
CollectionName = "Management School"
};
CollectionPoint cp3 = new CollectionPoint()
{
CollectionName = "Medical School"
};
CollectionPoint cp4 = new CollectionPoint()
{
CollectionName = "Engineering School"
};
CollectionPoint cp5 = new CollectionPoint()
{
CollectionName = "Science School"
};
CollectionPoint cp6 = new CollectionPoint()
{
CollectionName = "University Hospital"
};
db.Add(cp1);
db.Add(cp2);
db.Add(cp3);
db.Add(cp4);
db.Add(cp5);
db.Add(cp6);
Department dept1 = new Department()
{
DepartmentName = "Store", DeptCode = "STOR", CollectionPoint = cp1, PhoneNumber = "12345678"
};
Department dept2 = new Department()
{
DepartmentName = "English Department", DeptCode = "ENDP", CollectionPoint = cp2, PhoneNumber = "98765432"
};
Department dept3 = new Department()
{
DepartmentName = "Chinese Department", DeptCode = "CHSL", CollectionPoint = cp2, PhoneNumber = "87654321"
};
Department dept4 = new Department()
{
DepartmentName = "Engineering Department", DeptCode = "ENGD", CollectionPoint = cp1, PhoneNumber = "76543219"
};
Department dept5 = new Department()
{
DepartmentName = "Arts Department", DeptCode = "ARTD", CollectionPoint = cp3, PhoneNumber = "53046012"
};
Department dept6 = new Department()
{
DepartmentName = "Business Department", DeptCode = "BIZD", CollectionPoint = cp4, PhoneNumber = "15397864"
};
Department dept7 = new Department()
{
DepartmentName = "Science Department", DeptCode = "SCID", CollectionPoint = cp5, PhoneNumber = "68425397"
};
Department dept8 = new Department()
{
DepartmentName = "Management Department", DeptCode = "MNGD", CollectionPoint = cp6, PhoneNumber = "86957412"
};
Department dept9 = new Department()
{
DepartmentName = "HQ Department", DeptCode = "HQDP", CollectionPoint = cp3, PhoneNumber = "32540325"
};
Department dept10 = new Department()
{
DepartmentName = "Music Department", DeptCode = "MSDP", CollectionPoint = cp4, PhoneNumber = "78954120"
};
db.Add(dept1);
db.Add(dept2);
db.Add(dept3);
db.Add(dept4);
db.Add(dept5);
db.Add(dept6);
db.Add(dept7);
db.Add(dept8);
db.Add(dept9);
db.Add(dept10);
db.SaveChanges();
string filePath4 = Path.Combine(uploads, "Employee.csv");
string jsonString4 = ReadCSVFileUtil.ReadCSVFile(filePath4);
List <CSVEmployee> employees = (List <CSVEmployee>)JsonConvert.DeserializeObject(jsonString4, (typeof(List <CSVEmployee>)));
empService.SaveEmployeesFromCSV(employees);
empService.SaveEmployeesSupervisedByFromCSV(employees);
Employee emp1 = empService.GetEmployee("thinn");
Employee emp2 = empService.GetEmployee("arjun");
Employee emp3 = empService.GetEmployee("rohan");
Employee emp4 = empService.GetEmployee("darell");
Employee emp5 = empService.GetEmployee("yamone");
Employee emp6 = empService.GetEmployee("sheryl");
Employee emp7 = empService.GetEmployee("xinqi");
Employee emp8 = empService.GetEmployee("yanbin");
Employee emp9 = empService.GetEmployee("darellmgr2");
Employee emp10 = empService.GetEmployee("thinn2");
Product pr1 = pService.FindProductById(1);
Product pr2 = pService.FindProductById(2);
Product pr3 = pService.FindProductById(3);
Product pr4 = pService.FindProductById(4);
Product pr5 = pService.FindProductById(5);
Product pr6 = pService.FindProductById(6);
DateTime dd1 = new DateTime(2020, 8, 13, 8, 30, 20);
DateTime dd2 = new DateTime(2020, 8, 14, 8, 30, 20);
DateTime dd3 = new DateTime(2020, 8, 12, 8, 40, 20);
DateTime dd4 = new DateTime(2020, 8, 10, 8, 30, 20);
DateTime dd13 = new DateTime(2020, 8, 15, 8, 30, 20);
RequisitionForm rq1 = new RequisitionForm()
{
RFCode = "RF/" + emp1.Department.DeptCode + "/" + dd1.ToString("ddMMyy") + "/1", Employee = emp1, RFStatus = Enums.RFStatus.Approved, RFDate = dd1, RFApprovalDate = dd1, RFComments = "", RFApprovalBy = emp9
};
RequisitionForm rq2 = new RequisitionForm()
{
RFCode = "RF/" + emp1.Department.DeptCode + "/" + dd2.ToString("ddMMyy") + "/1", Employee = emp1, RFStatus = Enums.RFStatus.Ongoing, RFDate = dd2, RFApprovalDate = dd1, RFComments = "", RFApprovalBy = emp9
};
//RequisitionForm rq3 = new RequisitionForm() { RFCode = "RF/" + emp2.Department.DeptCode + "/" + dd3.ToString("ddMMyy") + "/1", Employee = emp2, RFStatus = Enums.RFStatus.Approved, RFDate = dd3, RFApprovalDate = dd1, RFComments = "", RFApprovalBy = emp9 };
RequisitionForm rq4 = new RequisitionForm()
{
RFCode = "RF/" + emp1.Department.DeptCode + "/" + dd1.ToString("ddMMyy") + "/2", Employee = emp1, RFStatus = Enums.RFStatus.Submitted, RFDate = dd1
};
RequisitionForm rq5 = new RequisitionForm()
{
RFCode = "RF/" + emp1.Department.DeptCode + "/" + dd2.ToString("ddMMyy") + "/2", Employee = emp1, RFStatus = Enums.RFStatus.Submitted, RFDate = dd2
};
db.Add(rq1);
db.Add(rq2);
//db.Add(rq3);
db.Add(rq4);
db.Add(rq5);
RequisitionFormsProduct rq1_p1 = new RequisitionFormsProduct()
{
RequisitionForm = rq1, Product = pr1, ProductRequested = 10, ProductApproved = 10
};
RequisitionFormsProduct rq1_p2 = new RequisitionFormsProduct()
{
RequisitionForm = rq1, Product = pr2, ProductRequested = 10, ProductApproved = 10
};
RequisitionFormsProduct rq2_p1 = new RequisitionFormsProduct()
{
RequisitionForm = rq2, Product = pr1, ProductRequested = 5, ProductApproved = 5
};
RequisitionFormsProduct rq2_p2 = new RequisitionFormsProduct()
{
RequisitionForm = rq2, Product = pr2, ProductRequested = 3, ProductApproved = 2
};
//RequisitionFormsProduct rq3_p1 = new RequisitionFormsProduct() { RequisitionForm = rq3, Product = pr1, ProductRequested = 10, ProductApproved = 5 };
//RequisitionFormsProduct rq3_p2 = new RequisitionFormsProduct() { RequisitionForm = rq3, Product = pr2, ProductRequested = 10, ProductApproved = 7 };
RequisitionFormsProduct rq4_p1 = new RequisitionFormsProduct()
{
RequisitionForm = rq1, Product = pr4, ProductRequested = 10, ProductApproved = 10
};
RequisitionFormsProduct rq5_p1 = new RequisitionFormsProduct()
{
RequisitionForm = rq1, Product = pr5, ProductRequested = 10, ProductApproved = 1
};
db.Add(rq1);
db.Add(rq2);
//db.Add(rq3);
db.Add(rq1_p1);
db.Add(rq1_p2);
db.Add(rq2_p1);
db.Add(rq2_p2);
//db.Add(rq3_p1);
//db.Add(rq3_p2);
db.Add(rq4_p1);
db.Add(rq5_p1);
//db.SaveChanges();
/*For Testing*/
StationeryRetrieval sr1 = new StationeryRetrieval()
{
SRCode = "SR/" + dd1.ToString("ddMMyy") + "/1", SRStatus = Enums.SRStatus.PendingAssignment, SRComments = "Pending Assignment", SRDate = dd1, StoreClerk = emp1, WarehousePacker = emp7, SRRetrievalDate = dd2
};
StationeryRetrieval sr2 = new StationeryRetrieval()
{
SRCode = "SR/" + dd1.ToString("ddMMyy") + "/2", SRStatus = Enums.SRStatus.Assigned, SRComments = "Assigned", SRDate = dd1, StoreClerk = emp1, WarehousePacker = emp7, SRRetrievalDate = dd2, SRAssignedDate = dd13
};
//StationeryRetrieval sr3 = new StationeryRetrieval() { SRCode = "SR/" + dd1.ToString("ddMMyy") + "/3", SRStatus = Enums.SRStatus.Open, SRComments = "Open", SRDate = dd1, StoreClerk = emp1 };
db.Add(sr1);
db.Add(sr2);
//db.Add(sr3);
db.SaveChanges();
StationeryRetrievalProduct srpr1 = new StationeryRetrievalProduct()
{
Product = pr1, ProductRequestedTotal = 5, StationeryRetrieval = sr1, ProductReceivedTotal = 4
};
StationeryRetrievalProduct srpr2 = new StationeryRetrievalProduct()
{
Product = pr2, ProductRequestedTotal = 10, StationeryRetrieval = sr1, ProductReceivedTotal = 10
};
StationeryRetrievalProduct srpr3 = new StationeryRetrievalProduct()
{
Product = pr1, ProductRequestedTotal = 5, StationeryRetrieval = sr2
};
StationeryRetrievalProduct srpr4 = new StationeryRetrievalProduct()
{
Product = pr2, ProductRequestedTotal = 10, StationeryRetrieval = sr2
};
db.Add(srpr1);
db.Add(srpr2);
db.Add(srpr3);
db.Add(srpr4);
//db.Add(srpr5);
//db.Add(srpr6);
db.SaveChanges();
StationeryRetrievalRequisitionForm sr1_rf_1 = new StationeryRetrievalRequisitionForm()
{
RequisitionForm = rq1, SRRFStatus = Enums.SRRFStatus.PendingAssignment, StationeryRetrieval = sr1
};
StationeryRetrievalRequisitionForm sr1_rf_2 = new StationeryRetrievalRequisitionForm()
{
RequisitionForm = rq2, SRRFStatus = Enums.SRRFStatus.PendingAssignment, StationeryRetrieval = sr1
};
//StationeryRetrievalRequisitionForm sr2_rf_3 = new StationeryRetrievalRequisitionForm() { RequisitionForm = rq3, SRRFStatus = Enums.SRRFStatus.PendingAssignment, StationeryRetrieval = sr2 };
db.Add(sr1_rf_1);
db.Add(sr1_rf_2);
//db.Add(sr2_rf_3);
db.SaveChanges();
StationeryRetrievalRequisitionFormProduct sr1_rf1_pr_1 = new StationeryRetrievalRequisitionFormProduct()
{
SR = sr1, RFP = rq1_p1
};
StationeryRetrievalRequisitionFormProduct sr1_rf1_pr_2 = new StationeryRetrievalRequisitionFormProduct()
{
SR = sr1, RFP = rq1_p2
};
StationeryRetrievalRequisitionFormProduct sr1_rf2_pr_1 = new StationeryRetrievalRequisitionFormProduct()
{
SR = sr1, RFP = rq2_p1
};
StationeryRetrievalRequisitionFormProduct sr1_rf2_pr_2 = new StationeryRetrievalRequisitionFormProduct()
{
SR = sr1, RFP = rq2_p2
};
//StationeryRetrievalRequisitionFormProduct sr1_rf3_pr_1 = new StationeryRetrievalRequisitionFormProduct() { SR = sr1, RFP = rq3_p2 };
db.Add(sr1_rf1_pr_1);
db.Add(sr1_rf1_pr_2);
db.Add(sr1_rf2_pr_1);
db.Add(sr1_rf2_pr_2);
db.SaveChanges();
/*End For Testing*/
//Testing for RequisitionFormDisplay
DateTime dd5 = new DateTime(2020, 8, 10, 8, 30, 20);
DateTime dd6 = new DateTime(2020, 8, 11, 8, 30, 20);
DateTime dd7 = new DateTime(2020, 8, 10, 8, 30, 20);
string filePath5 = Path.Combine(uploads, "RequisitionForm.csv");
string jsonString5 = ReadCSVFileUtil.ReadCSVFile(filePath5);
List <CSVRequisitionForm> rfs = (List <CSVRequisitionForm>)JsonConvert.DeserializeObject(jsonString5, (typeof(List <CSVRequisitionForm>)));
rfService.SaveRFFromCSV(rfs);
RequisitionForm rq6 = new RequisitionForm()
{
RFCode = "RF/" + emp1.Department.DeptCode + "/" + dd5.ToString("ddMMyy") + "/1", Employee = emp1, RFStatus = Enums.RFStatus.NotCompleted, RFDate = dd5, RFApprovalDate = dd6, RFApprovalBy = emp9
};
RequisitionFormsProduct rfp1 = new RequisitionFormsProduct()
{
Product = pr1, ProductRequested = 10, RequisitionForm = rq6, ProductCollectedTotal = 9, ProductApproved = 10
};
RequisitionFormsProduct rfp2 = new RequisitionFormsProduct()
{
Product = pr2, ProductRequested = 20, RequisitionForm = rq6, ProductCollectedTotal = 7, ProductApproved = 10
};
db.Add(rq6);
db.Add(rfp1);
db.Add(rfp2);
DisbursementForm df1 = new DisbursementForm()
{
CollectionPoint = cp1, DFCode = "DF/" + emp2.Department.DeptCode + "/" + dd1.ToString("ddMMyy") + "/1", DeptRep = emp2, StoreClerk = emp4, DFDeliveryDate = dd2, DFStatus = Enums.DFStatus.Created, DFDate = dd1
};
DisbursementForm df2 = new DisbursementForm()
{
CollectionPoint = cp2, DFCode = "DF/" + emp2.Department.DeptCode + "/" + dd1.ToString("ddMMyy") + "/2", DeptRep = emp2, StoreClerk = emp4, DFDeliveryDate = dd2, DFStatus = Enums.DFStatus.Completed, DFDate = dd1
};
DisbursementFormRequisitionForm dfrf1 = new DisbursementFormRequisitionForm()
{
DisbursementForm = df1, DFRFStatus = Enums.DFRFStatus.Assigned, RequisitionForm = rq1
};
DisbursementFormRequisitionForm dfrf2 = new DisbursementFormRequisitionForm()
{
DisbursementForm = df1, DFRFStatus = Enums.DFRFStatus.Assigned, RequisitionForm = rq2
};
DisbursementFormRequisitionFormProduct dfrfp1 = new DisbursementFormRequisitionFormProduct()
{
DisbursementForm = df1, RequisitionFormsProduct = rfp1, ProductCollected = 9
};
DisbursementFormRequisitionFormProduct dfrfp2 = new DisbursementFormRequisitionFormProduct()
{
DisbursementForm = df1, RequisitionFormsProduct = rfp2, ProductCollected = 7
};
db.Add(df1);
db.Add(df2);
db.Add(dfrf1);
db.Add(dfrf2);
db.Add(dfrfp1);
db.Add(dfrfp2);
db.SaveChanges();
//DisbursementFormRequisitionForm dfrf3 = new DisbursementFormRequisitionForm() { DFRFStatus = Enums.DFRFStatus.PendingDelivery, DisbursementForm = df1, RequisitionForm = rq1 };
//DisbursementFormRequisitionForm dfrf4 = new DisbursementFormRequisitionForm() { DFRFStatus = Enums.DFRFStatus.PendingDelivery, DisbursementForm = df1, RequisitionForm = rq2 };
//db.Add(dfrf3);
//db.Add(dfrf4);
db.SaveChanges();
DisbursementFormProduct dfp1 = new DisbursementFormProduct()
{
DisbursementForm = df1, Product = pr1, ProductToDeliverTotal = 10
};
DisbursementFormProduct dfp2 = new DisbursementFormProduct()
{
DisbursementForm = df1, Product = pr2, ProductToDeliverTotal = 40
};
db.Add(dfp1);
db.Add(dfp2);
db.SaveChanges();
Supplier sup1 = db.Suppliers.Find(1);
Supplier sup2 = db.Suppliers.Find(2);
Supplier sup3 = db.Suppliers.Find(3);
Supplier sup4 = db.Suppliers.Find(4);
Supplier sup5 = db.Suppliers.Find(5);
Supplier sup6 = db.Suppliers.Find(6);
Supplier sup7 = db.Suppliers.Find(7);
Supplier sup8 = db.Suppliers.Find(8);
Supplier sup9 = db.Suppliers.Find(9);
Supplier sup10 = db.Suppliers.Find(10);
Supplier sup11 = db.Suppliers.Find(11);
Supplier sup12 = db.Suppliers.Find(12);
Supplier sup13 = db.Suppliers.Find(13);
Supplier sup14 = db.Suppliers.Find(14);
Supplier sup15 = db.Suppliers.Find(15);
Supplier sup16 = db.Suppliers.Find(16);
Supplier sup17 = db.Suppliers.Find(17);
Supplier sup18 = db.Suppliers.Find(18);
Supplier sup19 = db.Suppliers.Find(19);
Supplier sup20 = db.Suppliers.Find(20);
//db.Add(sup1);
//db.Add(sup2);
//db.Add(sup3);
//db.Add(sup4);
db.SaveChanges();
DateTime dd8 = new DateTime(2020, 8, 10, 8, 30, 20);
DateTime dd9 = new DateTime(2020, 8, 22, 8, 30, 20);
DateTime dd10 = new DateTime(2020, 7, 10, 8, 40, 20);
DateTime dd11 = new DateTime(2020, 9, 12, 8, 30, 20);
DateTime dd12 = new DateTime(2020, 9, 13, 9, 30, 20);
SupplierProduct sp1 = db.SupplierProducts.Find(1);
SupplierProduct sp2 = db.SupplierProducts.Find(6);
SupplierProduct sp3 = db.SupplierProducts.Find(3);
SupplierProduct sp4 = db.SupplierProducts.Find(4);
//db.Add(sp1);
//db.Add(sp2);
//db.Add(sp3);
//db.Add(sp4);
db.SaveChanges();
PurchaseOrder po1 = new PurchaseOrder()
{
supplier = sup1, DeliverTo = "Logic University - Store", expectedDeliveryDate = dd9, IssuedBy = emp7, POStatus = Enums.POStatus.Issued, POComments = "Order affected by COVID", POCode = "PO/" + dd8.ToString("ddMMyy") + "/1", POIssueDate = dd8
};
PurchaseOrder po2 = new PurchaseOrder()
{
supplier = sup2, DeliverTo = "Logic University - Store", expectedDeliveryDate = dd11, IssuedBy = emp7, POStatus = Enums.POStatus.Completed, POComments = "Some Items may be out of stock", POCode = "PO/" + dd10.ToString("ddMMyy") + "/1", POIssueDate = dd10
};
PurchaseOrder po3 = new PurchaseOrder()
{
supplier = sup2, DeliverTo = "Logic University - Store", expectedDeliveryDate = dd12, IssuedBy = emp7, POStatus = Enums.POStatus.NotCompleted, POComments = "Urgent", POCode = "PO/" + dd10.ToString("ddMMyy") + "/2", POIssueDate = dd10
};
db.Add(po1);
db.Add(po2);
db.Add(po3);
PurchaseOrderSupplierProduct posr1 = new PurchaseOrderSupplierProduct()
{
SupplierProduct = sp1, POQuantityRequested = 10, POUnitPrice = sp1.ProductPrice, PurchaseOrder = po1
};
PurchaseOrderSupplierProduct posr2 = new PurchaseOrderSupplierProduct()
{
SupplierProduct = sp2, POQuantityRequested = 15, POUnitPrice = sp2.ProductPrice, PurchaseOrder = po1
};
PurchaseOrderSupplierProduct posr3 = new PurchaseOrderSupplierProduct()
{
SupplierProduct = sp3, POQuantityRequested = 5, POUnitPrice = sp3.ProductPrice, PurchaseOrder = po1
};
PurchaseOrderSupplierProduct posr4 = new PurchaseOrderSupplierProduct()
{
SupplierProduct = sp1, POQuantityRequested = 3, POUnitPrice = sp1.ProductPrice, PurchaseOrder = po2
};
PurchaseOrderSupplierProduct posr5 = new PurchaseOrderSupplierProduct()
{
SupplierProduct = sp2, POQuantityRequested = 5, POUnitPrice = sp2.ProductPrice, PurchaseOrder = po2
};
PurchaseOrderSupplierProduct posr6 = new PurchaseOrderSupplierProduct()
{
SupplierProduct = sp3, POQuantityRequested = 3, POUnitPrice = sp3.ProductPrice, PurchaseOrder = po3
};
PurchaseOrderSupplierProduct posr7 = new PurchaseOrderSupplierProduct()
{
SupplierProduct = sp4, POQuantityRequested = 5, POUnitPrice = sp4.ProductPrice, PurchaseOrder = po3
};
db.Add(posr1);
db.Add(posr2);
db.Add(posr3);
db.Add(posr4);
db.SaveChanges();
//--------------------------
DeliveryOrder do2 = new DeliveryOrder()
{
DeliveryOrderNo = "D0121567", DOReceivedDate = dd11, PurchaseOrder = po2, Supplier = sup1, DOCode = "DO/" + dd11.ToString("ddMMyy") + "/1", ReceivedBy = emp7
};
DeliveryOrder do3 = new DeliveryOrder()
{
DeliveryOrderNo = "D011267", DOReceivedDate = dd12, PurchaseOrder = po3, Supplier = sup2, DOCode = "DO/" + dd12.ToString("ddMMyy") + "/1", ReceivedBy = emp7
};
db.Add(do2);
db.Add(do3);
db.SaveChanges();
DeliveryOrderSupplierProduct dosr4 = new DeliveryOrderSupplierProduct()
{
PurchaseOrderSupplierProduct = posr4, DOQuantityReceived = 3, DeliveryOrder = do2
};
DeliveryOrderSupplierProduct dosr5 = new DeliveryOrderSupplierProduct()
{
PurchaseOrderSupplierProduct = posr5, DOQuantityReceived = 5, DeliveryOrder = do2
};
DeliveryOrderSupplierProduct dosr6 = new DeliveryOrderSupplierProduct()
{
PurchaseOrderSupplierProduct = posr6, DOQuantityReceived = 3, DeliveryOrder = do3
};
DeliveryOrderSupplierProduct dosr7 = new DeliveryOrderSupplierProduct()
{
PurchaseOrderSupplierProduct = posr7, DOQuantityReceived = 3, DeliveryOrder = do3
};
db.Add(dosr4);
db.Add(dosr5);
db.Add(dosr6);
db.Add(dosr7);
DateTime dd19 = new DateTime(2020, 8, 15, 0, 0, 0);
DateTime dd20 = new DateTime(2020, 9, 15, 0, 0, 0);
DateTime dd21 = new DateTime(2020, 7, 15, 10, 10, 0);
DateTime dd22 = new DateTime(2020, 10, 15, 0, 0, 0);
DateTime dd23 = new DateTime(2020, 11, 15, 0, 0, 0);
DelegationForm delForm1 = new DelegationForm()
{
startDate = dd19,
endDate = dd20,
delegateComment = "Hello There",
Delegatee = emp10,
DelegatedType = empType8,
DepartmentHead = emp9,
DLAssignedDate = dd21,
DLStatus = Enums.DLStatus.Ongoing
};
DelegationForm delForm2 = new DelegationForm()
{
startDate = dd22,
endDate = dd23,
delegateComment = "Hello There",
Delegatee = emp10,
DelegatedType = empType8,
DepartmentHead = emp9,
DLAssignedDate = dd21,
DLStatus = Enums.DLStatus.Assigned
};
//DelegationForm delForm3 = new DelegationForm()
//{
// startDate = dd22,
// endDate = dd23,
// delegateComment = "Hello There",
// Delegatee = emp10,
// DelegatedType = empType6,
// DepartmentHead = emp9,
// DLAssignedDate = dd21,
// DLStatus = Enums.DLStatus.Assigned
//};
db.Add(delForm1);
db.Add(delForm2);
db.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();
}
}
public ActionResult Edit(List <RForm> commitedRetrievalForm, string sessionId)
{
if (sessionId == null)
{
return(RedirectToAction("Login", "Login"));
}
StoreClerk storeclerk = db.StoreClerks.Where(p => p.SessionId == sessionId).FirstOrDefault();
StoreManager storeManager = db.StoreManagers.Where(p => p.SessionId == sessionId).FirstOrDefault();
StoreSupervisor storeSupervisor = db.StoreSupervisors.Where(p => p.SessionId == sessionId).FirstOrDefault();
if (ModelState.IsValid)
{
List <string> departmentList = new List <string>();
int outstandingListCount = db.OutstandingLists.Count();
//update retrieval form status to "Submitted"
StationeryRetrievalForm existingStationeryRetrievalForm = db.StationeryRetrievalForms.Find(commitedRetrievalForm[0].stationeryRetrievalFormDetail.FormNumber);
existingStationeryRetrievalForm.Status = "Submitted";
foreach (RForm commitedFormDetail in commitedRetrievalForm)
{
//Update actual values into retrieval form details
StationeryRetrievalFormDetail existingStationeryRetrievalFormDetail = db.StationeryRetrievalFormDetails.Find(commitedFormDetail.stationeryRetrievalFormDetail.FormDetailsNumber);
existingStationeryRetrievalFormDetail.Actual = commitedFormDetail.stationeryRetrievalFormDetail.Actual;
//update stationery catalog
StationeryCatalog existingCatalog = db.StationeryCatalogs.Find(commitedFormDetail.stationeryRetrievalFormDetail.ItemNumber);
existingCatalog.Balance -= commitedFormDetail.stationeryRetrievalFormDetail.Actual;
//add the department code to our department list created above, to generate disbursement list by department below
if (!departmentList.Contains(commitedFormDetail.stationeryRetrievalFormDetail.DepartmentCode))
{
departmentList.Add(commitedFormDetail.stationeryRetrievalFormDetail.DepartmentCode);
}
//If insufficient inventory, generate a outstanding list object for each retrieval form detail
if (commitedFormDetail.stationeryRetrievalFormDetail.Needed > commitedFormDetail.stationeryRetrievalFormDetail.Actual)
{
outstandingListCount++;
OutstandingList outstandingItem = new OutstandingList
{
OutstandingListNumber = outstandingListCount.ToString(),
RetrievalFormDetailsNumber = commitedFormDetail.stationeryRetrievalFormDetail.FormDetailsNumber,
Status = "Outstanding"
};
db.OutstandingLists.Add(outstandingItem);
}
db.SaveChanges();
}
//create a single disbursement list for each department
foreach (string deptCode in departmentList)
{
DisbursementList dl = new DisbursementList
{
ListNumber = (db.DisbursementLists.Count() + 1).ToString(),
DepartmentCode = deptCode,
Date = DateTime.Today,
Status = "Pending"
};
db.DisbursementLists.Add(dl);
db.SaveChanges();
DepartmentList dept = db.DepartmentLists.Where(x => x.DepartmentCode == deptCode).FirstOrDefault();
string Eid = dept.RepresentativeId;
Employee repo = db.Employees.Find(Eid);
string emailAddress = repo.EmailAddress;
string pointId = dept.CollectionPoint;
CollectionPoint point = db.CollectionPoints.Find(pointId);
string subject = "Your items are ready for collection";
string message = "<p>Dear " + repo.UserName + "." + "</p><br/><p>Your items are ready for collection</p><br/><p>Collection point and time: " + point.CollectionPointName + "---" + point.CollectionTime + "</p><br/><p>Stationery Management Team</p>";
util.SendEmail(emailAddress, subject, message);
int disbursementListDetailsCount = db.DisbursementListDetails.Count();
foreach (RForm commitedFormDetail in commitedRetrievalForm)
{
if (commitedFormDetail.stationeryRetrievalFormDetail.DepartmentCode.Equals(deptCode))
{
disbursementListDetailsCount++;
DisbursementListDetail dld = new DisbursementListDetail
{
ListDetailsNumber = disbursementListDetailsCount.ToString(),
ListNumber = dl.ListNumber,
ItemNumber = commitedFormDetail.stationeryRetrievalFormDetail.ItemNumber,
Quantity = commitedFormDetail.stationeryRetrievalFormDetail.Actual
};
db.DisbursementListDetails.Add(dld);
db.SaveChanges();
}
}
}
return(RedirectToAction("Index", "StationeryRetrievalForms", new { sessionId = sessionId }));
}
if (storeclerk != null)
{
int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count();
int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count();
int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count();
int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count();
int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count();
int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count();
ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString();
ViewData["sessionId"] = storeclerk.SessionId;
ViewData["username"] = storeclerk.UserName;
return(View(commitedRetrievalForm));
}
else if (storeManager != null)
{
int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count();
int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count();
int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count();
int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count();
int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count();
int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count();
ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString();
ViewData["sessionId"] = storeManager.SessionId;
ViewData["username"] = storeManager.UserName;
return(View(commitedRetrievalForm));
}
else if (storeSupervisor != null)
{
int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count();
int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count();
int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count();
int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count();
int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count();
int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count();
ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString();
ViewData["sessionId"] = storeSupervisor.SessionId;
ViewData["username"] = storeSupervisor.UserName;
return(View(commitedRetrievalForm));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
public List <Department> FindDeptsByCollectionPointId(string cpId)
{
CollectionPoint cp = cpServ.GetCollectionPointById(cpId);
return(deptServ.SearchDepartmentByLocationId(cp.LocationId));
}
public void InsertCollectionPoint(CollectionPoint collectionPoint)
{
context.CollectionPoints.Add(collectionPoint);
}
public CollectionPoint GetCollectionPointById(string id)
{
CollectionPoint cp = se.CollectionPoints.Where(x => x.LocationId == id).First();
return(cp);
}
public DBSeeder(ADProjContext dbcontext)
{
//test
//Collectionpoint seeder
CollectionPoint cp1 = new CollectionPoint()
{
Id = Guid.NewGuid().GetHashCode(),
Name = "Science Lobby 1",
Time = new System.DateTime(2020, 1, 1, 1, 13, 30, 00),
EmployeeId = 3
};
dbcontext.Add(cp1);
//Department seeder
Department department1 = new Department()
{
Id = Guid.NewGuid().ToString(),
Name = "Science",
DepartmentHeadId = 1,
DepartmentRepresentativeId = 1,
CollectionPointId = "1"
};
dbcontext.Add(department1);
//Employee seeder
Employee employee1 = new Employee()
{
Id = Guid.NewGuid().GetHashCode(),
DepartmentId = "1",
Role = "Employee",
Name = "John",
Email = "*****@*****.**",
Password = "******"
};
dbcontext.Add(employee1);
Employee employee2 = new Employee()
{
Id = Guid.NewGuid().GetHashCode(),
DepartmentId = "1",
Role = "Manager",
Name = "David",
Email = "*****@*****.**",
Password = "******"
};
dbcontext.Add(employee2);
Employee employee3 = new Employee()
{
Id = Guid.NewGuid().GetHashCode(),
DepartmentId = "1",
Role = "Employee",
Name = "Janice",
Email = "*****@*****.**",
Password = "******"
};
dbcontext.Add(employee3);
dbcontext.SaveChanges();
}
public void Create(CollectionPoint cp)
{
context.CollectionPoints.Add(cp);
context.SaveChanges();
}
public ActionResult IndexCollectionPoint(int? page, int? pagesize, string name, string first)
{
dynamic data = new System.Dynamic.ExpandoObject();
if (name == null) name = "";
var list = _CollectionPointRepos.GetAllCollectionPoint(name);
int _page = page.HasValue ? page.Value : 1;
int _pagesize = pagesize.HasValue ? pagesize.Value : 12;
var vs = list.ToPagedList(_page, _pagesize);
var firstone = new CollectionPoint();
if (first != null && first != "")
{
firstone = list.FirstOrDefault(p => p.CollectionPointCode == first);
var firspage = vs.IndexOf(firstone);
if (firspage == -1)
{
vs.Insert(0, firstone);
}
else if (firspage > 0)
{
vs.Remove(firstone);
vs.Insert(0, firstone);
}
}
data.name = name;
data.list = vs;
data.pageSize = _pagesize;
data.pageIndex = _page;
data.totalCount = vs.TotalCount;
string otherparam = "";
if (name != "") otherparam += "&name=" + name;
data.otherParam = otherparam;
return PartialView(data);
}
protected void ui_save_button_Click(object sender, EventArgs e)
{
CollectionPoint collectionPoint = new CollectionPoint();
int collectionPoint_id;
if (int.TryParse(ui_id_hiddenfield.Value, out collectionPoint_id))
{
collectionPoint.id = Convert.ToInt32(ui_id_hiddenfield.Value);
}
if (String.IsNullOrEmpty(ui_collectionPoint_textbox.Text))
{
Response.Cookies.Add(new HttpCookie("flash_message", "Field(s) marked with * can't be empty.")
{
Path = "/"
});
Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error")
{
Path = "/"
});
return;
}
collectionPoint.name = ui_collectionPoint_textbox.Text;
Message message;
if (collectionPoint.id > 0)
{
message = collectionPointController.actionUpdateCollectionPoint(collectionPoint);
}
else
{
message = collectionPointController.actionCreateCollectionPoint(collectionPoint);
}
//redirecting
if (message.condition)
{
Response.Cookies.Add(new HttpCookie("flash_message", "Successfully Saved.")
{
Path = "/"
});
Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-success")
{
Path = "/"
});
Response.Redirect("~/StoreClerk/CollectionPointDetail.aspx?id=" + collectionPoint.id);
}
else
{
Response.Cookies.Add(new HttpCookie("flash_message", message.message)
{
Path = "/"
});
Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error")
{
Path = "/"
});
Response.Redirect("~/StoreClerk/CollectionPointDetail.aspx?id=" + collectionPoint.id);
}
}
public CollectionPoint GetDeptCollectionPoint(Department dp)
{
CollectionPoint cp = dbcontext.CollectionPoints.Where(m => m.Id == dp.CollectionPointId).FirstOrDefault();
return(cp);
}
public CollectionPoint GetStoreCollectionPoint()
{
CollectionPoint storecp = dbcontext.CollectionPoints.Where(m => m.Id == 6).FirstOrDefault();
return(storecp);
}
public void UpdateCollectionPoint(Department dept, CollectionPoint CP)
{
dept.collectionPointID = CP.collectionPointID;
context.SaveChanges();
}
public void RetrieveDeptId(Dept_Staff user, FormCollection form)
{
int deptId = user.DeptId;
// int deptIdInForm = int.Parse(form["Department"]);
var reqs = db.Departments.Select(i => i.DeptId == deptId);
if (reqs == null)
{
Dictionary <int, int> dictionary = new Dictionary <int, int>();
ConsolidatedRequestsService daoObj = new ConsolidatedRequestsService();
dictionary = daoObj.ConsolidateIndividualRequests(deptId);
List <CollectionOfRequestedItems> CollectionOfReqList =
new List <CollectionOfRequestedItems>();
foreach (var i in dictionary)
{
CollectionOfRequestedItems collectionOfReq = new CollectionOfRequestedItems();
collectionOfReq.ItemId = i.Key;
collectionOfReq.TotalRequestedQty = i.Value;
db.collectionOfRequestedItems.Add(collectionOfReq);
CollectionOfReqList.Add(collectionOfReq);
}
ConsolidatedRequisition cons = new ConsolidatedRequisition();
CollectionPoint coll = new CollectionPoint();
coll.CollectionPointId = int.Parse(form["CollectionPoint"]);
Department dept = new Department();
dept.DeptId = deptId;
cons.CollectionPoint = coll;
cons.Department = dept;
cons.CollectionOfReq = CollectionOfReqList;
cons.ConsolidatedRequisitionStatus = "Approved";
cons.RequestedDate = DateTime.Now;
db.ConsolidatedRequisitions.Add(cons);
var empReqs = db.EmployeeRequestForms.Include(i => i.RequestItems.Select(it => it.Item)).Where(n => n.EmployeeRequestFormstatus == "Approved");
foreach (var e in empReqs)
{
e.EmployeeRequestFormstatus = "Consolidated";
}
db.SaveChanges();
}
else
{
Dictionary <int, int> dictionary = new Dictionary <int, int>();
ConsolidatedRequestsService daoObj = new ConsolidatedRequestsService();
dictionary = daoObj.ConsolidateIndividualRequests(deptId);
List <CollectionOfRequestedItems> CollectionOfReqList =
new List <CollectionOfRequestedItems>();
foreach (var i in dictionary)
{
CollectionOfRequestedItems collectionOfReq = new CollectionOfRequestedItems();
collectionOfReq.ItemId = i.Key;
collectionOfReq.TotalRequestedQty = i.Value;
db.collectionOfRequestedItems.Add(collectionOfReq);
CollectionOfReqList.Add(collectionOfReq);
}
ConsolidatedRequisition cons = new ConsolidatedRequisition();
cons.CollectionPointId = int.Parse(form["CollectionPoint"]);
// int deptId = user.DeptId;
cons.deptId = deptId;
cons.CollectionOfReq = CollectionOfReqList;
cons.ConsolidatedRequisitionStatus = "Approved";
cons.RequestedDate = DateTime.Now;
db.ConsolidatedRequisitions.Add(cons);
var empReqs = db.EmployeeRequestForms.Include(i => i.RequestItems.Select(it => it.Item)).Where(n => n.EmployeeRequestFormstatus == "Approved");
foreach (var e in empReqs)
{
e.EmployeeRequestFormstatus = "Consolidated";
}
db.SaveChanges();
}
}
public static CollectionPoint getcollectionpoint(string g)
{
CollectionPoint cp = CollectionPointEFFacade.getcollectionpointfromname(g);
return(cp);
}
public ActionResult Details(string id, string sessionId, string errorMeg)
{
if (sessionId == null)
{
return(RedirectToAction("Login", "Login"));
}
StoreClerk storeclerk = db.StoreClerks.Where(p => p.SessionId == sessionId).FirstOrDefault();
StoreManager storeManager = db.StoreManagers.Where(p => p.SessionId == sessionId).FirstOrDefault();
StoreSupervisor storeSupervisor = db.StoreSupervisors.Where(p => p.SessionId == sessionId).FirstOrDefault();
List <DisbursementList> disbursementLists = db.DisbursementLists.ToList();
List <DisbursementListDetail> disbursementListDetails = db.DisbursementListDetails.ToList();
List <StationeryCatalog> stationeryCatalogs = db.StationeryCatalogs.ToList();
var disbursementDetailRecord = (from d in disbursementListDetails
join l in disbursementLists on d.ListNumber equals l.ListNumber into table1
from l in table1.ToList()
join s in stationeryCatalogs on d.ItemNumber equals s.ItemNumber into table2
from s in table2.ToList()
select new ViewModelDDetails
{
disbursementList = l,
disbursementListDetail = d,
stationeryCatalog = s,
}).Where(x => x.disbursementList.ListNumber == id).ToList();
if (disbursementDetailRecord.Count() == 0)
{
return(RedirectToAction("Index", "DisbursementLists", new { @sessionId = sessionId }));
}
DisbursementList disbursementList = db.DisbursementLists.Where(d => d.ListNumber == id).Single();
DepartmentList departmentList = db.DepartmentLists.Where(d => d.DepartmentCode == disbursementList.DepartmentCode).Single();
CollectionPoint collectionPoint = db.CollectionPoints.Where(c => c.CollectionPointCode == departmentList.CollectionPoint).Single();
Employee employee = db.Employees.Where(e => e.Id == departmentList.RepresentativeId).Single();
if (storeclerk != null)
{
int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count();
int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count();
int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count();
int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count();
int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count();
int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count();
ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString();
ViewData["collection"] = collectionPoint.CollectionPointName;
ViewData["disbursementList"] = disbursementList.Date;
ViewData["deparment"] = departmentList.DepartmentName;
ViewData["employeeF"] = employee.FirstName;
ViewData["employeeL"] = employee.LastName;
ViewData["sessionId"] = storeclerk.SessionId;
ViewData["username"] = storeclerk.UserName;
ViewData["tag"] = "storeclerk";
ViewData["errorMeg"] = errorMeg;
return(View(disbursementDetailRecord));
}
else if (storeManager != null)
{
int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count();
int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count();
int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count();
int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count();
int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count();
int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count();
ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString();
ViewData["collection"] = collectionPoint.CollectionPointName;
ViewData["disbursementList"] = disbursementList.Date;
ViewData["deparment"] = departmentList.DepartmentName;
ViewData["employeeF"] = employee.FirstName;
ViewData["employeeL"] = employee.LastName;
ViewData["sessionId"] = storeManager.SessionId;
ViewData["username"] = storeManager.UserName;
ViewData["tag"] = "storeManager";
ViewData["errorMeg"] = errorMeg;
return(View(disbursementDetailRecord));
}
else if (storeSupervisor != null)
{
int num = db.RequisitionForms.Where(x => x.Status == "Approved").Count();
int numDisbuserment = db.DisbursementLists.Where(x => x.Status == "Pending").Count();
int numOutS = db.OutstandingLists.Where(x => x.Status == "Awaiting Goods").Count();
int numRetrive = db.StationeryRetrievalForms.Where(x => x.Status == "Pending").Count();
int numPO = db.PurchaseOrders.Where(x => x.Status == "Not Submitted").Count();
int numStock = db.StockAdjustmentVouchers.Where(x => x.Status == "Pending").Count();
ViewData["sumTotal"] = (num + numDisbuserment + numOutS + numRetrive + numPO + numStock).ToString();
ViewData["collection"] = collectionPoint.CollectionPointName;
ViewData["disbursementList"] = disbursementList.Date;
ViewData["deparment"] = departmentList.DepartmentName;
ViewData["employeeF"] = employee.FirstName;
ViewData["employeeL"] = employee.LastName;
ViewData["sessionId"] = storeSupervisor.SessionId;
ViewData["username"] = storeSupervisor.UserName;
ViewData["tag"] = "storeSupervisor";
ViewData["errorMeg"] = errorMeg;
return(View(disbursementDetailRecord));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
public async Task <IActionResult> Index()
{
string name = "Clerk's Name";
using (var httpClient = new HttpClient())
{
int id = (int)HttpContext.Session.GetInt32("UserID");
using (var response = await httpClient.GetAsync(api_url))
{
string apiResponse = await response.Content.ReadAsStringAsync();
name = apiResponse;
}
using (var response = await httpClient.GetAsync(api_url + "get-top-summed/"))
{
string apiResponse = await response.Content.ReadAsStringAsync();
topSixRequested = JsonConvert.DeserializeObject <List <TopSixRequested> >(apiResponse);
}
using (var response = await httpClient.GetAsync(api_url_rqst + "/" + "GetRequestCountByStatus" + "/" + "PendingDelivery"))
{
string apiResponse = await response.Content.ReadAsStringAsync();
pendingDeliveries = JsonConvert.DeserializeObject <int>(apiResponse);
}
using (var response = await httpClient.GetAsync(api_url_rqst + "/" + "GetRequestCountByStatus" + "/" + "Approved"))
{
string apiResponse = await response.Content.ReadAsStringAsync();
newRequests = JsonConvert.DeserializeObject <int>(apiResponse);
}
using (var response = await httpClient.GetAsync(api_url + "get-clerk-pending/" + id))
{
string apiResponse = await response.Content.ReadAsStringAsync();
pendingAdjustments = Int32.Parse(apiResponse);
}
using (var response = await httpClient.GetAsync(api_url + "get-next-collection-time-location/"))
{
string apiResponse = await response.Content.ReadAsStringAsync();
nextCollectionPoint = JsonConvert.DeserializeObject <CollectionPoint>(apiResponse);
}
using (var response = await httpClient.GetAsync(api_url + "get-next-collection-datetime/"))
{
string apiResponse = await response.Content.ReadAsStringAsync();
nextCollectionDate = JsonConvert.DeserializeObject <DateTime>(apiResponse);
}
using (var response = await httpClient.GetAsync(api_url + "get-low-stock-item-count/"))
{
string apiResponse = await response.Content.ReadAsStringAsync();
lowStockItemCount = Int32.Parse(apiResponse);
}
}
ViewData["name"] = name;
ViewData["topSixRequested"] = topSixRequested;
ViewData["newRequests"] = newRequests;
ViewData["pendingDeliveries"] = pendingDeliveries;
ViewData["pendingAdjustments"] = pendingAdjustments;
ViewData["nextCollectionPoint"] = nextCollectionPoint;
ViewData["nextCollectionDate"] = nextCollectionDate;
ViewData["lowStockItemCount"] = lowStockItemCount;
return(View("ClerkDash"));
}
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 void DeleteCollectionPoint(string collectionId)
{
CollectionPoint collectionPoint = context.CollectionPoints.Find(collectionId);
context.CollectionPoints.Remove(collectionPoint);
}
public CollectionPointPayload(CollectionPoint cp)
{
CollectionPointID = cp.CollectionPointID;
CollectionPointDetails = cp.CollectionPointDetails;
}
public void UpdateCollectionPoint(CollectionPoint collectionPoint)
{
context.Entry(collectionPoint).State = EntityState.Modified;
}
public void UpdateCollectionPoint(CollectionPoint collectionPoint)
{
CollectionPointRepo.Instance.Update(collectionPoint);
}
public JsonResult PostRetrieval(Retrieval Details)
{
List <RetrievalItem> cc = JsonConvert.DeserializeObject <List <RetrievalItem> >(Details.RetData[0]);
if (ModelState.IsValid)
{
List <string> departmentList = new List <string>();
int outstandingListCount = db.OutstandingLists.Count();
//update retrieval form status to "Submitted"
StationeryRetrievalForm existingStationeryRetrievalForm = db.StationeryRetrievalForms.Find(cc[0].FormNumber);
existingStationeryRetrievalForm.Status = "Submitted";
foreach (RetrievalItem commitedFormDetail in cc)
{
//Update actual values into retrieval form details
StationeryRetrievalFormDetail existingStationeryRetrievalFormDetail = db.StationeryRetrievalFormDetails.Find(commitedFormDetail.FormDetailsnumber);
existingStationeryRetrievalFormDetail.Actual = Convert.ToInt32(commitedFormDetail.Actual);
//update stationery catalog
StationeryCatalog existingCatalog = db.StationeryCatalogs.Find(commitedFormDetail.ItemNumber);
existingCatalog.Balance -= Convert.ToInt32(commitedFormDetail.Actual);
//add the department code to our department list created above, to generate disbursement list by department below
if (!departmentList.Contains(commitedFormDetail.Dept))
{
departmentList.Add(commitedFormDetail.Dept);
}
//If insufficient inventory, add the item code to our item code list created above, so that we can generate a Outstanding List by item code
if (Convert.ToInt32(commitedFormDetail.Needed) > Convert.ToInt32(commitedFormDetail.Actual))
{
outstandingListCount++;
OutstandingList outstandingItem = new OutstandingList
{
OutstandingListNumber = outstandingListCount.ToString(),
RetrievalFormDetailsNumber = commitedFormDetail.FormDetailsnumber,
Status = "Outstanding"
};
db.OutstandingLists.Add(outstandingItem);
}
db.SaveChanges();
}
//create a single disbursement list for each department
foreach (string deptCode in departmentList)
{
DisbursementList dl = new DisbursementList
{
ListNumber = (db.DisbursementLists.Count() + 1).ToString(),
DepartmentCode = deptCode,
Date = DateTime.Today,
Status = "Pending"
};
db.DisbursementLists.Add(dl);
db.SaveChanges();
DepartmentList dept = db.DepartmentLists.Where(x => x.DepartmentCode == deptCode).FirstOrDefault();
string Eid = dept.RepresentativeId;
Employee repo = db.Employees.Find(Eid);
string emailAddress = repo.EmailAddress;
string pointId = dept.CollectionPoint;
CollectionPoint point = db.CollectionPoints.Find(pointId);
string subject = "Your items are ready for collection";
string message = "<p>Dear " + repo.UserName + "." + "</p><br/><p>Your items are ready for collection</p><br/><p>Collection point and time: " + point.CollectionPointName + "---" + point.CollectionTime + "</p><br/><p>Stationery Management Team</p>";
util.SendEmail(emailAddress, subject, message);
int disbursementListDetailsCount = db.DisbursementListDetails.Count();
foreach (RetrievalItem commitedFormDetail in cc)
{
if (commitedFormDetail.Dept.Equals(deptCode))
{
disbursementListDetailsCount++;
DisbursementListDetail dld = new DisbursementListDetail
{
ListDetailsNumber = disbursementListDetailsCount.ToString(),
ListNumber = dl.ListNumber,
ItemNumber = commitedFormDetail.ItemNumber,
Quantity = Convert.ToInt32(commitedFormDetail.Actual)
};
db.DisbursementListDetails.Add(dld);
db.SaveChanges();
}
}
}
}
return(Json(new { status = "success" }));
}
public async Task <IActionResult> changeCollectionPoint([Bind("DeptId,Name,DeptRep,Cpid")] Department department, CollectionPoint collectionPoint)
{
MyUser user = _context.MyUser.Where(p => p.Email == HttpContext.User.Identity.Name).ToList().FirstOrDefault();
int? id = user.DeptId;
if (id != department.DeptId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(department);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DepartmentExists(department.DeptId))
{
return(NotFound());
}
else
{
throw;
}
}
List <MyUser> allclerks = new List <MyUser>();
allclerks = _context.MyUser.Where(x => x.RoleId == 5).ToList();
CollectionPoint cp = new CollectionPoint();
cp = _context.CollectionPoint.Where(x => x.Cpid == collectionPoint.Cpid).FirstOrDefault();
#region Email
var message = new MimeMessage();
message.From.Add(new MailboxAddress("SSIS", "*****@*****.**"));
//message.To.Add(new MailboxAddress("tqy", "*****@*****.**"));
message.Subject = "New collection point";
foreach (MyUser clerk in allclerks)
{
message.To.Add(new MailboxAddress(clerk.Name, clerk.Email));
message.Body = new TextPart("plain")
{
Text = "Dear " + clerk.Name + ", " +
"This letter is to let you know we have selected the collection point " +
"and delivery timing as " + cp.Name + "." +
"Please check and find details of the location below:" +
Environment.NewLine +
cp.Details +
Environment.NewLine +
"Regards" +
Environment.NewLine +
department.Name +
" department"
};
}
using (var client = new SmtpClient())
{
client.Connect("smtp.gmail.com", 587, false);
client.Authenticate("*****@*****.**", "team2team2");
client.Send(message);
client.Disconnect(true);
}
#endregion
return(RedirectToAction("About", "Home"));
}
return(View());
}
public WCF_CollectionPoint getCollectionListbyDept(string DeptID)
{
CollectionPoint collection_point = CollectionManager_M.getCollectionInfoByDepID(DeptID);
return(new WCF_CollectionPoint(collection_point.Collection_ID, collection_point.Collection_Desc));
}
public void Close()
{
gameObject.SetActive(false);
collectionPoint = null;
}
