public bool DeleteItem(string IID, int RTID) { using (var ctx = new ADProjectSA40Team4Entities()) { var x = (from y in ctx.RequestDetails where y.RequestedItem == IID && y.RequestID == RTID select y).FirstOrDefault(); ctx.RequestDetails.Remove(x); ctx.SaveChanges(); var xe = (from y in ctx.RequestDetails where y.RequestID == RTID select y).ToList(); if (xe.Count < 1) { var x1 = (from y1 in ctx.Requests where y1.RequestID == RTID select y1).FirstOrDefault(); ctx.Requests.Remove(x1); ctx.SaveChanges(); return(true); } else { return(false); } } }
public void ReqNo(int eid1) { var genReqNo = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == eid1 select grn1).ToList(); if (genReqNo.Count > 0) { int reqno = genReqNo[0].RequestID; using (var ctxt = new ADProjectSA40Team4Entities()) { lk: var x = (from y in ctxt.RequestDetails where y.RequestID == reqno select y).FirstOrDefault(); if (x != null) { ctxt.RequestDetails.Remove(x); ctxt.SaveChanges(); goto lk; } var x1 = (from y1 in ctxt.Requests where y1.RequestID == reqno select y1).FirstOrDefault(); ctxt.Requests.Remove(x1); ctxt.SaveChanges(); } } }
public void DeleteReqNo(int tran) { using (var ctxt = new ADProjectSA40Team4Entities()) { lk: var x = (from y in ctxt.RequestDetails where y.RequestID == tran select y).FirstOrDefault(); if (x != null) { ctxt.RequestDetails.Remove(x); ctxt.SaveChanges(); goto lk; } var x1 = (from y1 in ctxt.Requests where y1.RequestID == tran select y1).FirstOrDefault(); ctxt.Requests.Remove(x1); ctxt.SaveChanges(); } }