public static List <EventProfileViewModel> LoadEventProfilesByTopicMonthAndParentID(this EventProfileCollection profiles, int parentProfileID, DateTime startDate, DateTime endDate, string topicAreas, int campusID) { List <EventProfileViewModel> events = new List <EventProfileViewModel>(); SqlDataReader reader = new ProfileDataExtension().GetEventProfilesByTopicMonthAndParentID(parentProfileID, startDate, endDate, topicAreas, campusID); while (reader.Read()) { profiles.Add(new EventProfile(reader, false)); events.Add(new EventProfileViewModel((int)reader["profile_id"], (int)reader["occurrence_id"], (DateTime)reader["start"])); } reader.Close(); return(events); }
public static List <EventProfileViewModel> LoadEventsByDateRangeTopicAndCampus(this EventProfileCollection profiles, DateTime startDate, DateTime endDate, string topicAreas, int[] campusIDs) { List <EventProfileViewModel> events = new List <EventProfileViewModel>(); var data = new ProfileDataExtension(); var campuses = string.Join(",", Array.ConvertAll(campusIDs, Convert.ToString)); using (SqlDataReader reader = data.GetEventProfilesByDateRangeTopicsAndCampus(startDate, endDate, topicAreas, campuses)) { while (reader.Read()) { profiles.Add(new EventProfile(reader, false)); events.Add(new EventProfileViewModel((int)reader["profile_id"], (int)reader["occurrence_id"], (DateTime)reader["occurrence_start"])); } } return(events); }