public IHttpActionResult updateCollectionPoint(ChangeCollectionPoint changeCollectionPoints) { string place = changeCollectionPoints.CollectionPlace; var collectionPnts = _context.CollectionPoints.SingleOrDefault(g => g.CollectionPlace == place); int colId = collectionPnts.CollectionPointId; ConsolidatedRequisition consolidated = _context.ConsolidatedRequisitions.Include(i => i.CollectionOfReq).SingleOrDefault(m => m.deptId == changeCollectionPoints.DeptId); consolidated.CollectionPoint = collectionPnts; _context.SaveChanges(); return(Ok()); }
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(); } }