// GET: Divisions
        public ActionResult Index()
        {
            var DivisionList = db.Divisions.ToList();

            if (Session["User"] != null)
            {
                var user = (Gamification.Models.Users)Session["User"];
                if (user.Role == "Admin")
                {
                    int?SearchDivision = null;
                    if (Request["DivisionID"] != null)
                    {
                        SearchDivision = Convert.ToInt32(Request["DivisionID"]);
                    }

                    if (Request["SearchByDivisionCheckBox"] == "check")
                    {
                        ViewBag.DivisionID = new SelectList(db.Divisions, "DivisionID", "Name").OrderBy(c => c.Text);
                        var searchResult = _divisionRepository.SearchByDivision(DivisionList, SearchDivision).OrderBy(d => d.Name);
                        return(View(searchResult));
                    }
                    else
                    {
                        ViewBag.DivisionID = new SelectList(db.Divisions, "DivisionID", "Name").OrderBy(c => c.Text);
                        return(View(DivisionList.OrderBy(d => d.Name)));
                    }
                }
                else
                {
                    return(RedirectToAction("Index", "Home"));
                }
            }
            else
            {
                return(RedirectToAction("Index", "Home"));
            }
        }