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