// remove request by reqId // done public static bool RemoveReq(int reqId) { using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext()) { try { Request request = entities.Requests.Where(r => r.ReqId == reqId).FirstOrDefault(); if (request != null) { if (request.Status.Equals("Unsubmitted") || request.Status.Equals("Bookmarked")) { RequestDetailBL.removeAllReqDet(reqId); } else { request.Status = "Cancelled"; request.CancelledDateTime = DateTime.Now; entities.SaveChanges(); } } return(true); } catch (Exception ex) { throw ex; } } }
// remove request by empId and status // done public static bool RemoveReq(int empId, string status) { using (SA46Team08ADProjectContext entities = new SA46Team08ADProjectContext()) { try { List <Request> reqlist = entities.Requests.Where(r => r.EmpId == empId && r.Status == status).ToList(); if (reqlist.Count > 0) { for (int i = 0; i < reqlist.Count; i++) { if (reqlist[i].Status.Equals("Unsubmitted") || reqlist[i].Status.Equals("Bookmarked")) { RequestDetailBL.removeAllReqDet(reqlist[i].ReqId); } else { reqlist[i].Status = "Cancelled"; reqlist[i].CancelledDateTime = DateTime.Now; entities.SaveChanges(); } } } return(true); } catch (Exception ex) { throw ex; } } }