/// <summary>
/// Function used to search events based on user's search term
/// </summary>
/// <param name="query">
/// Holds the users search term
/// </param>
/// <returns>
/// eventDataDB object holding the search results.
/// </returns>
public eventDataDB searchEvents(string query)
{
eventDataDBTableAdapters.DataTableTableAdapter adapt = new eventDataDBTableAdapters.DataTableTableAdapter();
query = query + "%";
adapt.FillSearchEvents(data.DataTable, query);
return(data);
}
/// <summary>
/// Function used to rate event
/// </summary>
/// <param name="username">
/// User that is rating the event
/// </param>
/// <param name="rating">
/// Rating of the event
/// </param>
/// <param name="eventID">
/// ID of the event being rated
/// </param>
/// <returns>
/// Boolean value of sucess or failure.
/// </returns>
public Boolean rateEvent(string username, int rating, int eventID)
{
try
{
userdataDBTableAdapters.DataTable2TableAdapter adapt = new userdataDBTableAdapters.DataTable2TableAdapter();
eventDataDBTableAdapters.DataTableTableAdapter adapt2 = new eventDataDBTableAdapters.DataTableTableAdapter();
eventDataDB checkValidEventID = new eventDataDB();
adapt2.FillCheckEventID(checkValidEventID.DataTable, eventID);
if (checkValidEventID.DataTable.Count() != 1)
{
return(false);
}
if (rating < 0 || rating > 5)
{
return(false);
}
adapt.rateEvent(username, rating, eventID);
return(true);
}
catch
{
return(false);
}
}
public eventDataDB getRecommendedEvents(string username)
{
eventDataDBTableAdapters.DataTableTableAdapter adapt = new eventDataDBTableAdapters.DataTableTableAdapter();
adapt.FillRecommendedEvents(data.DataTable, username);
return(data);
}
/// <summary>
/// used to search the database for events > systemdate.
/// </summary>
/// <param name="none">
/// </param>
/// <returns>
/// eventDataDB object holding the all events > systemdate.
/// </returns>
public eventDataDB getUpcomingEvents()
{
eventDataDBTableAdapters.DataTableTableAdapter adapt = new eventDataDBTableAdapters.DataTableTableAdapter();
adapt.FillUpcomingEvents(data.DataTable);
return(data);
}