public ActionResult ApproveRequest(int rid) { try { if (rid != 0) { TMS_Request rObj = db.TMS_Request.Where(x => x.RequestId == rid).FirstOrDefault(); rObj.Status = "A"; db.SaveChanges(); TempData["Success"] = "Request Approved Successfully."; } } catch (Exception) { TempData["Danger"] = "Invalid Request"; } return(View("BatchDetails")); }
public ActionResult RequestForm(int bid) { try { int user_id = ((TMS_UserMaster)Session["UserDetails"]).UserId; int q = (from a in db.TMS_Request join b in db.TMS_BatchMaster on a.BatchId equals b.BatchId join c in db.TMS_UserMaster on a.UserId equals user_id where b.BatchId == bid select a.RequestId).Count(); if (q == 0) { if (Session["UserDetails"] != null) { TMS_UserMaster usrObj = (TMS_UserMaster)Session["UserDetails"]; int empid = usrObj.UserId; var EmpObj = db.TMS_UserMaster.Where(x => x.IsActive == true && x.UserId == empid).FirstOrDefault(); var batch = getBatch(bid); TMS_Request objrqst = new TMS_Request(); objrqst.BatchId = batch.BatchId; objrqst.ManagerId = Convert.ToInt32(EmpObj.ManagerID); objrqst.UserId = EmpObj.UserId; objrqst.Status = "P"; objrqst.IsActive = true; objrqst.CreatedBy = 12; objrqst.CreatedOn = DateTime.Today; objrqst.ModifiedBy = 1; objrqst.ModifiedOn = DateTime.Today; db.TMS_Request.Add(objrqst); db.SaveChanges(); int mgrid = objrqst.ManagerId; TempData["Success"] = "Request has been Forwared to the manager."; } } else { TempData["Warning"] = "Already Registered in Batch"; return(RedirectToAction("CreateRequest")); } } catch (Exception) { TempData["Danger"] = "Invlaid Request/ Invalid Data"; } return(RedirectToAction("CreateRequest")); }
public ActionResult RejectId(int reqId, string comment) { try { if (reqId != 0)// && comment != "") { TMS_Request Robj = db.TMS_Request.Where(x => x.RequestId == reqId).FirstOrDefault(); Robj.Status = "R"; if (comment != null) { Robj.Description = comment; } db.SaveChanges(); TempData["Warning"] = "Request has been Rejected"; } } catch (Exception) { TempData["Danger"] = "Invalid Request"; } return(View("BatchDetails")); }