public ActionResult BrandManagerReview(int id, CPTRequestViewModel model)
        {
            if (ModelState.IsValid)
            {
                var request = db.CPTRequests.Find(id);
                if (request == null)
                {
                    return(HttpNotFound());
                }

                // Review the request.
                request.BReview = model.BReview;

                if (request.BReview == Review.Approved)
                {
                    request.RequestStatus = RequestStatus.MDRequestApproval;
                }
                else if (request.BReview == Review.Rejected)
                {
                    request.RequestStatus = RequestStatus.Rejected;
                }

                db.Entry(request).State = EntityState.Modified;
                db.SaveChanges();

                return(RedirectToAction("BrandManagerReviewIndex"));
            }

            ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "City");
            return(View());
        }
        // GET: CPTRequest/BrandManagerReview/5
        public ActionResult BrandManagerReview(int?id)
        {
            if (id == null)
            {
                return(View("Error"));
            }
            CPTRequest request = db.CPTRequests.Find(id);

            if (request == null)
            {
                return(View("Error"));
            }

            var model = new CPTRequestViewModel
            {
                Id              = request.RequestID,
                RequestTitle    = request.RequestTitle,
                ProductDivision = request.ProductDivision,
                Justification   = request.Justification,
                LocationId      = request.LocationId,
                RequestDate     = request.RequestDate,
                RequestStatus   = request.RequestStatus,
                SubmittedByName = db.Employees.Find(request.SubmittedById).FullName,
                SubmittedById   = request.SubmittedById,
                City            = request.Location.City,
            };

            ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "City");
            return(View(model));
        }
        // GET: CPTRequest/SubmittedRequestsDetails/5
        public ActionResult SubmittedRequestsDetails(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CPTRequest request = db.CPTRequests.Find(id);

            if (request == null)
            {
                return(HttpNotFound());
            }

            var model = new CPTRequestViewModel
            {
                Id               = request.RequestID,
                RequestTitle     = request.RequestTitle,
                ProductDivision  = request.ProductDivision,
                Justification    = request.Justification,
                LocationId       = request.LocationId,
                City             = request.Location.City,
                RequestDate      = request.RequestDate ?? DateTime.Now.Date,
                RequestStatus    = request.RequestStatus,
                BReviewRequest   = request.BReviewRequest,
                BReview          = request.BReview,
                BrandManagerName = db.BrandManagers.Find(request.BReviewRequest).FullName,
            };

            ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "City");
            return(View(model));
        }
        // GET: CPTRequest/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CPTRequest request = db.CPTRequests.Find(id);

            if (request == null)
            {
                return(HttpNotFound());
            }

            var model = new CPTRequestViewModel
            {
                Id              = request.RequestID,
                RequestTitle    = request.RequestTitle,
                ProductDivision = request.ProductDivision,
                Justification   = request.Justification,
                LocationId      = request.LocationId,
                City            = request.Location.City,
                RequestDate     = request.RequestDate ?? DateTime.Now.Date,
                //REmployeeId = request.REmployeeId,
                SubmittedById   = request.SubmittedById,
                RequestStatus   = request.RequestStatus,
                SubmittedByName = request.Employee.FullName
            };

            ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "City");
            return(View(model));
        }
        public ActionResult RequesterCreate(CPTRequestViewModel model)
        {
            if (ModelState.IsValid)
            {
                // Create the request from the model.
                var request = new CPTRequest
                {
                    RequestTitle    = model.RequestTitle,
                    RequestDate     = DateTime.Now.Date,
                    RequestStatus   = RequestStatus.BMRequestApproval,
                    ProductDivision = model.ProductDivision,
                    Justification   = model.Justification,
                    MDecisionId     = model.MDecisionId,
                    MReviewRequest  = model.MReviewRequest,
                    BEmployeeId     = model.BEmployeeId,
                    BDecisionId     = model.BDecisionId,
                    REmployeeId     = model.REmployeeId,
                    BDecisionMade   = model.BDecisionMade,
                    BDecisionDate   = model.BDecisionDate,
                    BReview         = model.BReview,
                    MDecision       = model.MDecision,
                    MDecisionDate   = model.MDecisionDate,
                    MReview         = model.MReview,
                    LocationId      = model.LocationId,
                    SubmittedById   = User.Identity.IsAuthenticated ? User.Identity.GetUserId <int>() : db.Users.First().Id,
                    //BReviewRequest =
                };
                var result = from b in db.BrandManagers
                             where b.ProductDivision == model.ProductDivision
                             select b.Id;

                request.BReviewRequest = result.First();

                //var BMID = db.BrandManagers.Where(b => b.ProductDivision == model.ProductDivision).First();

                // Save the created request to the database.
                db.CPTRequests.Add(request);
                db.SaveChanges();

                return(RedirectToAction("SubmittedRequestsIndex"));
            }

            ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "City");

            return(View());
        }