// 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;
}
}
}
