public IHttpActionResult Assign(HeadDelegate headDelegate) { Dept_Staff sts = _context.Dept_Staffs.SingleOrDefault(m => m.Username == headDelegate.AssignedDept_Staff.Username); sts.Staff_Status = "Assigned"; HeadDelegate del = new HeadDelegate { UserId = sts.UserId, StartDate = headDelegate.StartDate, EndDate = headDelegate.EndDate }; _context.HeadDelegates.Add(del); _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(); } }