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();
}
}
