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(); }