public static IEnumerable<Event> LoadByConferenceId(int conferenceId)
{
SearchEvent search = new SearchEvent
{
ConferenceId = conferenceId
};
return Search(search);
}
/// <summary>
/// Loads Event by the id parameter
/// </summary>
/// <param name="eventId">Primary Key of Event table</param>
/// <returns>Event entity</returns>
public static Event Load(int eventId)
{
SearchEvent search
= new SearchEvent
{
EventId = eventId
};
return Search(search).FirstOrDefault();
}
/// <summary>
/// Searches for Event
/// </summary>
/// <param name="item" />
/// <returns>An IEnumerable set of Event</returns>
public static IEnumerable<Event> Search(SearchEvent item)
{
List<SqlParameter> parameters
= new List<SqlParameter>
{
new SqlParameter("@EventId", item.EventId),
new SqlParameter("@ConferenceId", item.ConferenceId),
new SqlParameter("@PaperId", item.PaperId),
new SqlParameter("@FoodPreferenceId", item.FoodPreference),
new SqlParameter("@Comments", item.Comments),
new SqlParameter("@StartDate", item.StartDate),
new SqlParameter("@EndDate", item.EndDate)
};
DataSet set = DataManager.ExecuteProcedure(ConferencePlusConnectionString, "Event_Get", parameters);
IEnumerable<DataRow> dataRows = set.GetRowsFromDataSet();
return ConvertToEntityObject(dataRows);
}
public static IEnumerable<Event> LoadByPaperId(int paperId)
{
SearchEvent search = new SearchEvent
{PaperId = paperId};
return Search(search);
}
/// <summary>
/// Searches for Event
/// </summary>
/// <param name="search" />
/// <returns>An IEnumerable set of Event</returns>
public static IEnumerable<Event> Search(SearchEvent search)
{
return EventDao.Search(search);
}
/// <summary>
///
/// </summary>
/// <param name="conferenceId"></param>
/// <returns></returns>
public static bool IsValidToRemove(int conferenceId)
{
SearchEvent search = new SearchEvent { ConferenceId = conferenceId };
return !EventManager.Search(search).SafeAny();
}
