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