public async Task <ActionResult> Edit(EditSuggestionModel model)
        {
            if (ModelState.IsValid)
            {
                var suggestion = await db.Suggestions.FindAsync(model.SuggestionId);

                if (suggestion == null)
                {
                    return(HttpNotFound());
                }
                suggestion.Title        = model.Title;
                suggestion.Description  = model.Description;
                suggestion.DepartmentId = model.DepartmentId;
                suggestion.TopicId      = model.TopicId;
                suggestion.HasReviewed  = false;
                suggestion.LastUpdated  = DateTime.Now;

                db.Entry(suggestion).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", model.DepartmentId);
            ViewBag.TopicId      = new SelectList(db.Topics, "TopicId", "Name", model.TopicId);
            //ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName", suggestion.UserId);
            return(View(model));
        }
        // GET: Suggestions/Edit/5
        public async Task <ActionResult> Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            Suggestion suggestion = await db.Suggestions.FindAsync(id);

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

            var model = new EditSuggestionModel
            {
                Description  = suggestion.Description,
                Title        = suggestion.Title,
                DepartmentId = suggestion.DepartmentId,
                TopicId      = suggestion.TopicId,
                SuggestionId = suggestion.SuggestionId
            };

            ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", suggestion.DepartmentId);
            ViewBag.TopicId      = new SelectList(db.Topics, "TopicId", "Name", suggestion.TopicId);
            //ViewBag.UserId = new SelectList(db.Users, "Id", "FirstName", suggestion.UserId);
            return(View(suggestion));
        }