// GET: PTORequest/Approve
public ActionResult Approve(int?id)
{
if (Request.IsAuthenticated)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PTO_REQUEST pTO_REQUEST = db.PTO_REQUEST.Find(id);
if (pTO_REQUEST == null)
{
return(HttpNotFound());
}
else
{
pTO_REQUEST.approved = true;
pTO_REQUEST.approved_by = (int)Session["UserID"];
pTO_REQUEST.approved_on = DateTime.Now;
Edit(pTO_REQUEST);
return(RedirectToAction("Pending"));
}
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public long CreateRequest(long userId, long approverEmployeeId, string comment, long ptoCycleID)
{
long returnValue;
try
{
using (var context = new PTOMEntities())
{
returnValue = GetSequenceNextValue(context, "PTOMS.PTO_REQUEST_ID_SQ");
var r = new PTO_REQUEST
{
APPROVER_EMPLOYEE_ID = approverEmployeeId,
EMPLOYEE_ID = userId,
PTO_COMMENT = comment,
PTO_REQUEST_ID = returnValue,
REQUEST_DATE = DateTime.Now,
PTO_CYCLE_ID = ptoCycleID,
STATUS = RequestStatus.Pending.ToString()
};
context.PTO_REQUEST.AddObject(r);
context.SaveChanges();
}
}
catch (Exception ex)
{
LoggingHelper.LogServiceMessage(LoggingHelper.MessageType.Error, string.Empty, ex);
throw;
}
return(returnValue);
}
public ActionResult DeleteConfirmed(int id)
{
if (Request.IsAuthenticated)
{
PTO_REQUEST pTO_REQUEST = db.PTO_REQUEST.Find(id);
db.PTO_REQUEST.Remove(pTO_REQUEST);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult Edit([Bind(Include = "requestID,requested_by,total_time_requested,requested_on,approved,approved_on,approved_by,comments,pto_start,pto_end")] PTO_REQUEST pTO_REQUEST)
{
if (Request.IsAuthenticated)
{
if (ModelState.IsValid)
{
db.Entry(pTO_REQUEST).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.approved_by = new SelectList(db.USERs, "userID", "fname", pTO_REQUEST.approved_by);
ViewBag.requested_by = new SelectList(db.USERs, "userID", "fname", pTO_REQUEST.requested_by);
return(View(pTO_REQUEST));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
// GET: PTORequest/Details/5
public ActionResult Details(int?id)
{
if (Request.IsAuthenticated)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PTO_REQUEST pTO_REQUEST = db.PTO_REQUEST.Find(id);
if (pTO_REQUEST == null)
{
return(HttpNotFound());
}
return(View(pTO_REQUEST));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
// GET: PTORequest/Edit/5
public ActionResult Edit(int?id)
{
if (Request.IsAuthenticated)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
PTO_REQUEST pTO_REQUEST = db.PTO_REQUEST.Find(id);
if (pTO_REQUEST == null)
{
return(HttpNotFound());
}
ViewBag.approved_by = new SelectList(db.USERs, "userID", "fname", pTO_REQUEST.approved_by);
ViewBag.requested_by = new SelectList(db.USERs, "userID", "fname", pTO_REQUEST.requested_by);
return(View(pTO_REQUEST));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
private PTORequest ConvertToPTORequest(PTO_REQUEST request)
{
return(request == null ? null : new PTORequest
{
PTOCycleID = request.PTO_CYCLE_ID,
ApproverEmployeeID = request.APPROVER_EMPLOYEE_ID,
EmployeeID = request.EMPLOYEE_ID,
PTOComment = request.PTO_COMMENT,
PTORequestId = request.PTO_REQUEST_ID,
RequestDate = request.REQUEST_DATE,
Status = (RequestStatus)Enum.Parse(typeof(RequestStatus), request.STATUS),
StatusChangeComment = request.STATUS_CHANGE_COMMENT,
StatusChangeDate = request.STATUS_CHANGE_DATE,
RequestDays = (from d in request.PTO_DAY
select new PTODay
{
RequestTypeID = d.REQUEST_TYPE_ID,
PTODayDate = d.PTO_DAY_DATE,
PTODayID = d.PTO_DAY_ID,
PTORequestID = d.PTO_REQUEST_ID
}).ToList()
});
}
