public bool updateOutstandingRequisition() { try { int oldRequestID = 0; int newRequestID = 0; L : var requestDetails = from reqDetails in ctx.RequestDetails join request in ctx.Requests on reqDetails.RequestID equals request.RequestID where request.RequestStatus == "Approved" && reqDetails.ReceivedQty != reqDetails.RequestedQty select reqDetails; if (requestDetails != null) { RequestDetail oldRequestDetail = requestDetails.First(); var req = from request in ctx.Requests where request.RequestID == oldRequestDetail.RequestID select request; Request oldRequest = req.First(); if (oldRequestDetail.RequestID != oldRequestID) { if (newRequestID != 0) { var u = from x in ctx.Requests where x.RequestID == newRequestID select x; Request update = u.First(); update.RequestStatus = "Outstanding"; ctx.SaveChanges(); } ADTeam4EF.Request newRequest = new ADTeam4EF.Request(); newRequest.RequestStatus = "Outstanding Edit"; newRequest.RequestByEmployeeID = oldRequest.RequestByEmployeeID; newRequest.RequestByDepartmentID = oldRequest.RequestByDepartmentID; newRequest.ApprovedByEmployeeID = oldRequest.ApprovedByEmployeeID; newRequest.RequestDate = System.DateTime.Today; oldRequestID = (int)oldRequestDetail.RequestID; ctx.Requests.Add(newRequest); ctx.SaveChanges(); var nR = from n in ctx.Requests where n.RequestStatus == "Outstanding Edit" && n.RequestByEmployeeID == oldRequest.RequestByEmployeeID select n; newRequestID = nR.First().RequestID; } ADTeam4EF.RequestDetail newRequestDetails = new ADTeam4EF.RequestDetail(); newRequestDetails.RequestID = newRequestID; newRequestDetails.RequestedItem = oldRequestDetail.RequestedItem; newRequestDetails.RequestedQty = oldRequestDetail.RequestedQty - oldRequestDetail.ReceivedQty; ctx.RequestDetails.Add(newRequestDetails); ctx.SaveChanges(); goto L; } return(true); } catch { return(false); } }
public String getRequestIDByEmployeeID(string employeeID) { try { int eID = 0; eID = Convert.ToInt16(employeeID); var request = from req in ctx.Requests where req.RequestByEmployeeID == eID select req; ADTeam4EF.Request r = request.First(); return(r.RequestID.ToString()); } catch (Exception ex) { throw ex; } }
public bool approveRequest(int requestID) { try { var request = from req in ctx.Requests where req.RequestID == requestID select req; ADTeam4EF.Request r = request.First(); using (TransactionScope ts = new TransactionScope()) { r.RequestStatus = "Approved"; ctx.SaveChanges(); ts.Complete(); return(true); } } catch { return(false); } }
public Request getRequestIDByEmployeeID(int employeeID) { try { var request = from req in ctx.Requests where req.RequestByEmployeeID == employeeID select req; ADTeam4EF.Request r = request.FirstOrDefault(); if (r != null) { return(r); } else { return(null); } } catch (Exception ex) { throw ex; } }