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