/// <summary>
/// Populates the selection lists for the events controller
/// </summary>
private void PopulateSelectionLists()
{
//populates the host dropdown with clubs drom db
List <SelectListItem> clubs = SQLUtilities.GetAllHosts();
ViewData["ClubHosts"] = clubs;
//Gets all the categories and creates selection list
List <SelectListItem> cats = SQLUtilities.GetCategories();
ViewData["cats"] = cats;
List <SelectListItem> camp = new List <SelectListItem>();
camp.Add(new SelectListItem()
{
Value = "1", Text = "Stevens Point"
});
camp.Add(new SelectListItem()
{
Value = "2", Text = "Wisconsin Rapids"
});
camp.Add(new SelectListItem()
{
Value = "3", Text = "Marshfield"
});
camp.Add(new SelectListItem()
{
Value = "4", Text = "Adams"
});
camp.Add(new SelectListItem()
{
Value = "5", Text = "Off Campus"
});
ViewData["campuses"] = camp;
}
/// <summary>
/// The AllEvents
/// </summary>
/// <param name="sortOrder">The sortOrder<see cref="string"/></param>
/// <param name="currentFilter">The currentFilter<see cref="string"/></param>
/// <param name="searchString">The searchString<see cref="string"/></param>
/// <param name="page">The page<see cref="int?"/></param>
/// <returns>The <see cref="ActionResult"/></returns>
public ActionResult AllEvents(string sortOrder, string currentFilter, string searchString, int?page)
{
ViewBag.NavTag = "Events";
// Gets the categories for the filters
MintContext db = new MintContext();
ViewData["Categories"] = SQLUtilities.GetCategories();
// Searching
string search = null;
if (Request.QueryString["search"] != null)
{
search = Request.QueryString["search"];
}
// Categories
int?Category = null;
if (Request.QueryString["category"] == "0")
{
Category = null;
}
else if (Request.QueryString["category"] != null)
{
Category = Convert.ToInt32(Request.QueryString["category"]);
}
//Free Stuff/Food
bool?FreeFood = null;
bool?FreeStuff = null;
if (Request.QueryString["freefood"] != null)
{
FreeFood = true;
}
if (Request.QueryString["freestuff"] != null)
{
FreeStuff = true;
}
// Date
string Date = null;
if (Request.QueryString["Date"] != null)
{
Date = Request.QueryString["Date"].ToString();
}
bool?Weekend = null;
if (Request.QueryString["Weekend"] != null)
{
Weekend = true;
}
// Paging info
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
int pageSize = 9;
int pageNumber = (page ?? 1);
// Gets all the events for the page
var events = SQLUtilities.GetAllEvents(search, Category, FreeFood, FreeStuff, Date, Weekend);
//Sets the viewbag info
ViewBag.SearchTerm = search;
ViewBag.Category = Category;
ViewBag.Date = Date;
ViewBag.FreeStuff = FreeStuff == null ? "" : "checked";
ViewBag.FreeFood = FreeFood == null ? "" : "checked";
ViewBag.Weekend = Weekend == null ? "" : "checked";
// Returns the view
return(View(events.ToPagedList(pageNumber, pageSize)));
}
