// GET rest/sessionpresenter/
public HttpResponseMessage Get(int? codeCampYearId, int? sessionId, int? attendeesId)
{
var sessionPresenterQuery = new SessionPresenterQuery()
{
WithTitle = true
};
if (!codeCampYearId.HasValue || codeCampYearId == -1)
{
sessionPresenterQuery.CodeCampYearId = Utils.CurrentCodeCampYear;
}
else
{
sessionPresenterQuery.CodeCampYearId = codeCampYearId.Value;
}
if (sessionId.HasValue && sessionId.Value != -1)
{
sessionPresenterQuery.SessionId = sessionId.Value;
}
if (attendeesId.HasValue && attendeesId.Value != -1)
{
sessionPresenterQuery.AttendeeId = attendeesId.Value;
}
var sessions =
SessionPresenterManager.I.Get(sessionPresenterQuery);
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, sessions);
return response;
}
public List<SessionsResult> Get(SessionsQuery query)
{
if (query.CodeCampYearId.HasValue)
{
query.CodeCampYearIds = new List<int>() { query.CodeCampYearId.Value};
}
var meta = new CodeCampDataContext();
IQueryable<Sessions> baseQuery = from myData in meta.Sessions
select myData;
// .Where(a => a.Id == 594).ToList();
baseQuery = BaseQueryAutoGen(baseQuery, query);
if (query.SkipRoomIds != null && query.SkipRoomIds.Any())
{
baseQuery = from data in baseQuery
where data.LectureRoomsId.HasValue && !query.SkipRoomIds.Contains(data.LectureRoomsId.Value)
select data;
}
if (query.RoomIds != null && query.RoomIds.Any())
{
baseQuery = from data in baseQuery
where data.LectureRoomsId.HasValue && query.RoomIds.Contains(data.LectureRoomsId.Value)
select data;
}
var sessionIdsPlanToAttend = new List<int>();
var sessionIdsInterested = new List<int>();
if (query.WithInterestOrPlanToAttend != null && HttpContext.Current != null && HttpContext.Current.User.Identity.IsAuthenticated )
{
string username = HttpContext.Current.User.Identity.Name;
Guid? PKID = (from data in meta.Attendees
where data.Username.Equals(username)
select data.PKID).FirstOrDefault();
if (PKID != null)
{
sessionIdsPlanToAttend = (from data in meta.SessionAttendee
where data.Interestlevel == 3 && data.Attendees_username == PKID.Value
select data.Sessions_id).ToList();
sessionIdsInterested = (from data in meta.SessionAttendee
where data.Interestlevel == 2 && data.Attendees_username == PKID.Value
select data.Sessions_id).ToList();
}
}
if (query.CodeCampYearIds != null && query.CodeCampYearIds.Count > 0)
{
baseQuery = baseQuery.Where(data => query.CodeCampYearIds.Contains(data.CodeCampYearId));
}
List<int> sponsorIdsWithActiveJobs;
if (query.JustActiveJobListings != null && query.JustActiveJobListings.Value)
{
sponsorIdsWithActiveJobs = (from data in meta.SponsorListJobListing
where data.StartRunDate.HasValue && data.EndRunDate.HasValue &&
data.StartRunDate.Value.CompareTo(DateTime.Now) < 0 &&
data.EndRunDate.Value.CompareTo(DateTime.Now) > 0 &&
data.HideListing == false
select data.SponsorListId).ToList();
baseQuery =
baseQuery.Where(
data => data.SponsorId != null && sponsorIdsWithActiveJobs.Contains(data.SponsorId.Value));
}
var speakerResults = new List<AttendeesResult>();
var sessionPresenterResults =new List<SessionPresenterResult>();
if (query.WithSpeakers != null && query.WithSpeakers.Value)
{
//var attendeesQuery = new AttendeesQuery
// {
// PresentersOnly = true
// };
var sessionPresenterQuery = new SessionPresenterQuery();
if (query.CodeCampYearIds != null && query.CodeCampYearIds.Count > 0)
{
//attendeesQuery.CodeCampYearIds = query.CodeCampYearIds;
sessionPresenterQuery.CodeCampYearIds = query.CodeCampYearIds;
//attendeesQuery.CodeCampYearIds = query.CodeCampYearIds;
}
sessionPresenterResults = SessionPresenterManager.I.Get(sessionPresenterQuery);
List<int> speakerIdsAll = sessionPresenterResults.Select(a => a.AttendeeId).ToList();
speakerResults = AttendeesManager.I.Get(new AttendeesQuery()
{
Ids = speakerIdsAll
});
}
IQueryable<SessionsResult> results = GetBaseResultIQueryable(baseQuery);
List<SessionsResult> resultList = GetFinalResults(results, query);
var tagsResults = new List<TagsResult>();
var sessionTagsManagers = new List<SessionTagsResult>();
if (query.WithTags != null && query.WithTags.Value)
{
tagsResults = TagsManager.I.GetAll(); // could be smarter, but not that many tags
sessionTagsManagers = SessionTagsManager.I.GetAll();
}
//// next several lines are just for the single speaker that is associated with the session. not the multiple speaker option
//List<int> speakerIds = (resultList.Select(data => data.Attendeesid)).ToList();
//var presentersQuery = from attend in meta.Attendees
// where speakerIds.Contains(attend.Id)
// select new
// {
// attend.Id,
// SpeakerName = attend.UserFirstName + " " + attend.UserLastName,
// attend.UserWebsite,
// attend.PKID
// };
//var speakerDict =
// presentersQuery.ToDictionary(presenter => presenter.Id, presenter => presenter.SpeakerName);
//var speakerUrlDict = new Dictionary<int, string>();
//var speakerImageUrl = new Dictionary<int, string>();
//foreach (var presenter in presentersQuery)
//{
// speakerUrlDict.Add(presenter.Id, presenter.UserWebsite);
// speakerImageUrl.Add(presenter.Id,presenter.PKID.ToString());
//}
var lectureRoomsDict = (from data in meta.LectureRooms select data).ToDictionary(k => k.Id, v => v.Number);
var sessionTimesDict = (from data in meta.SessionTimes select data).ToDictionary(k => k.Id, v => v.StartTimeFriendly);
var planCountsDict = (from data in meta.SessionAttendee
where data.Interestlevel == 3
group data by data.Sessions_id
into g
orderby g.Key ascending
select new { cnt = g.Count(), id = g.Key }).ToDictionary(k => k.id, v => v.cnt);
var interestCountsDict = (from data in meta.SessionAttendee
where data.Interestlevel == 2
group data by data.Sessions_id
into g
orderby g.Key ascending
select new { cnt = g.Count(), id = g.Key }).ToDictionary(k => k.id, v => v.cnt);
var sessionTimesFullDict = new Dictionary<int, SessionTimes>();
if (query.WithSchedule != null)
{
sessionTimesFullDict =
(from data in meta.SessionTimes
select data).ToDictionary(k => k.Id, v => v);
}
var sessionLevelsDict = new Dictionary<int, string>();
if (query.WithLevel.HasValue && query.WithLevel.Value)
{
sessionLevelsDict = (from data in meta.SessionLevels
select data).ToDictionary(k => k.Id, v => v.Description);
}
foreach (var session in resultList)
{
if (query.WithLevel.HasValue && query.WithLevel.Value)
{
if (session.SessionLevel_id.HasValue && sessionLevelsDict.ContainsKey(session.SessionLevel_id.Value))
{
session.SessionLevel = sessionLevelsDict[session.SessionLevel_id.Value];
}
}
session.SessionUrl =
String.Format("/Session/{0}/{1}",
Utils.ConvertCodeCampYearToActualYear(
session.CodeCampYearId.ToString(CultureInfo.InvariantCulture)),
Utils.GenerateSlug(session.Title));
if (query.WithSchedule != null && session.SessionTimesId.HasValue)
{
if (sessionTimesFullDict.ContainsKey(session.SessionTimesId.Value))
{
var st = sessionTimesFullDict[session.SessionTimesId.Value];
session.SessionTimesResult = new SessionTimesResult()
{
// no doing all the parameters, not necessary
CodeCampYearId = st.CodeCampYearId,
StartTime = st.StartTime,
EndTime = st.EndTime,
Id = st.Id,
Description = st.Description
};
}
}
if (query.WithInterestOrPlanToAttend != null)
{
if (sessionIdsInterested.Contains(session.Id))
{
session.LoggedInUserInterested = true;
}
if (sessionIdsPlanToAttend.Contains(session.Id))
{
session.LoggedInUserPlanToAttend = true;
}
}
if (session.Createdate != null)
{
var ts = DateTime.Now.Subtract(session.Createdate.Value);
session.SessionPosted = (ts.Days + 1).ToString(CultureInfo.InvariantCulture);
}
else
{
session.SessionPosted = "Up";
}
// http://localhost:5691/Web/DisplayImage.ashx?sizex=100&PKID=33a199dd-1154-45cb-bc94-40ffc5a99391
// (the next 3 lines maybe overwritten if speaker is set to be removed)
// GOING FORWARD WE DON'T WANT TO USE SINGLE PICTURE FOR SESSIONS SPEAKER SINCE CAN HAVE MULTIPLE SPEAKERS
//session.SpeakerPictureUrl = String.Format("DisplayImage.ashx?sizex=150&PKID={0}", speakerImageUrl[session.Attendeesid]);
//session.PresenterName = speakerDict[session.Attendeesid];
//session.PresenterURL = speakerUrlDict[session.Attendeesid];
session.SpeakerPictureUrl = "DO NOT USE, USE SpeakersList instead";
session.PresenterName = "DO NOT USE, USE SpeakersList instead";
session.PresenterURL = "DO NOT USE, USE SpeakersList instead";
if (query.WithSpeakers != null && query.WithSpeakers.Value)
{
SessionsResult session1 = session;
var speakerIdsForList =
sessionPresenterResults.Where(a => a.SessionId == session1.Id)
.Select(a => a.AttendeeId)
.ToList();
// quick and dirty cleansing of speaker data so just public data will be shown
var tempSpeakerResults =
Enumerable.OrderBy(speakerResults.Where(a => speakerIdsForList.Contains(a.Id)),
a => a.UserLastName == null ? string.Empty : a.UserLastName.ToUpper());
session.SpeakersList = new List<SpeakerResult>();
foreach (var rec in tempSpeakerResults)
{
//// need to figure out if removing primary speaker is necessary
//if (session.DoNotShowPrimarySpeaker)
//{
// string userNameOfSpeakerFromSession = session.Username;
// string userNameOfSpeakerFromSessionSpeaker = rec.Username;
// if (!userNameOfSpeakerFromSession.Equals(userNameOfSpeakerFromSessionSpeaker))
// {
// session.SpeakersList.Add(new AttendeesResult()
// {
// Id = rec.Id,
// Email = rec.Email,
// TwitterHandle = rec.TwitterHandle,
// Username = rec.Username,
// City = rec.City,
// State = rec.State,
// UserBio = rec.UserBio,
// UserFirstName = rec.UserFirstName,
// UserLastName = rec.UserLastName,
// UserZipCode = rec.UserZipCode,
// UserWebsite = rec.UserWebsite,
// SpeakerPictureUrl =
// String.Format(
// String.Format("attendeeimage/{0}.jpg", rec.Id),
// rec.Id)
// });
// // kind of klugy if there are more than 2 speakers, but for now, we should push someone who is not the primary speaker
// // into the primary slot.
// session.Username = "******";
// session.PresenterName = "DO NOT USE THIS. USE SpeakersList instead";
// session.PresenterURL = rec.UserWebsite;
// session.SpeakerPictureUrl = "DO NOT USE THIS. USE SpeakersList instead";
// }
//}
//else
//{
var attendeeResult = new SpeakerResult()
{
AttendeeId = rec.Id,
Email = rec.Email,
TwitterHandle = rec.TwitterHandle,
Username = rec.Username,
City = "",
State = rec.State,
UserBio = rec.UserBio,
UserBioEllipsized = Utils.GetEllipsized(rec.UserBio, 90, "..."),
UserFirstName = rec.UserFirstName,
UserLastName = rec.UserLastName,
UserZipCode = rec.UserZipCode,
UserWebsite = rec.UserWebsite,
SpeakerLocalUrl = String.Format("/Presenter/{0}/{1}-{2}-{3}",
Utils
.ConvertCodeCampYearToActualYear
(session.CodeCampYearId.ToString(
CultureInfo.InvariantCulture)),
Utils.AlphaNumericOnly(
rec.UserFirstName),
Utils.AlphaNumericOnly(
rec.UserLastName),
rec.Id),
ImageUrl =
String.Format(
String.Format("/attendeeimage/{0}.jpg", rec.Id),
rec.PKID)
};
session.SpeakersList.Add(attendeeResult);
//}
}
// need to update speakersshort
var sbSpeakersShort = new StringBuilder();
if (session.SpeakersList.Count > 0 && session.SpeakersList.Count <= 1)
{
session.SpeakersShort = session.SpeakersList[0].UserFirstName + " " +
session.SpeakersList[0].UserLastName;
}
else if (session.SpeakersList.Count > 1)
{
foreach (var speaker in session.SpeakersList)
{
sbSpeakersShort.Append(speaker.UserLastName);
sbSpeakersShort.Append(", ");
}
session.SpeakersShort = sbSpeakersShort.ToString().Trim();
if (session.SpeakersShort.Length > 2)
{
session.SpeakersShort.Remove(session.SpeakersShort.Length - 2);
}
}
else
{
session.SpeakersShort = "Unknown Speaker";
}
//session.SpeakersList = speakerResults.Where(a => speakerIdsForList.Contains(a.Id)).ToList();
}
session.RoomNumber = session.LectureRoomsId != null &&
lectureRoomsDict.ContainsKey(session.LectureRoomsId.Value)
? lectureRoomsDict[session.LectureRoomsId.Value]
: "ROOM NOT FOUND/PROBLEM!";
session.RoomNumberNew = session.RoomNumber;
session.SessionTime = session.SessionTimesId != null &&
sessionTimesDict.ContainsKey(session.SessionTimesId.Value)
? sessionTimesDict[session.SessionTimesId.Value]
: "TIME NOT FOUND/PROBLEM!";
session.TitleWithPlanAttend = planCountsDict.ContainsKey(session.Id)
? string.Format("PA: {0} {1} ", planCountsDict[session.Id],
session.Title)
: "PS: 0 " + session.Title;
if (planCountsDict.ContainsKey(session.Id))
{
session.PlanAheadCount = planCountsDict[session.Id].ToString();
session.PlanAheadCountInt = planCountsDict[session.Id];
}
else
{
session.PlanAheadCount = "SessionId: " + session.Id + " Not Found";
session.PlanAheadCountInt = 0;
}
if (interestCountsDict.ContainsKey(session.Id))
{
session.InterestCount = interestCountsDict[session.Id].ToString();
session.InterestCountInt = interestCountsDict[session.Id];
}
else
{
session.PlanAheadCount = "SessionId: " + session.Id + " Not Found";
session.PlanAheadCountInt = 0;
}
if (query.WithTags != null && query.WithTags.Value)
{
List<int> tagIds =
sessionTagsManagers.Where(a => a.SessionId == session.Id).Select(a => a.TagId).ToList();
session.TagsResults = (tagsResults.Where(data => tagIds.Contains(data.Id))).ToList();
foreach (var r in session.TagsResults)
{
r.SessionId = session.Id;
}
}
session.SessionSlug = Utils.GenerateSlug(session.Title);
session.TitleEllipsized = Utils.GetEllipsized(session.Title, 48, "...");
session.DescriptionEllipsized = Utils.GetEllipsized(session.Description, 90, "...");
}
return resultList;
}
public List<SessionPresenterResult> Get(SessionPresenterQuery query)
{
var meta = new CodeCampDataContext();
// add to codecampyearids
if (query.CodeCampYearId.HasValue)
{
if (query.CodeCampYearIds != null && query.CodeCampYearIds.Count > 0)
{
if (!query.CodeCampYearIds.Contains(query.CodeCampYearId.Value))
{
query.CodeCampYearIds.Add(query.CodeCampYearId.Value);
}
}
else
{
query.CodeCampYearIds = new List<int> { query.CodeCampYearId.Value };
}
}
IQueryable<SessionPresenter> baseQuery = from myData in meta.SessionPresenter select myData;
if (query.CodeCampYearIds != null && query.CodeCampYearIds.Count > 0)
{
// sessionpresenter Ids for this year codecamp
var sessionPresenterIds = (from data in meta.SessionPresenter
join data1 in meta.Sessions on data.SessionId equals data1.Id
where query.CodeCampYearIds.Contains(data1.CodeCampYearId)
select data.Id).ToList();
baseQuery = baseQuery.Where(data => sessionPresenterIds.Contains(data.Id));
}
// next is automated query formation from AutoGen Shared Class
// (do not remove next line or filters will go away)
baseQuery = BaseQueryAutoGen(baseQuery, query);
IQueryable<SessionPresenterResult> results = GetBaseResultIQueryable(baseQuery);
List<SessionPresenterResult> resultList = GetFinalResults(results, query);
if (query.WithTitle.HasValue && query.WithTitle.Value)
{
var sessions = (from data in meta.Sessions
where resultList.Select(a => a.SessionId).Contains(data.Id)
select data);
foreach (var sessionPresenter in resultList)
{
var session = sessions.FirstOrDefault(a => a.Id == sessionPresenter.SessionId);
if (session != null)
{
sessionPresenter.Title = session.Title;
sessionPresenter.Description = session.Description;
}
}
}
if (query.WithSpeaker.HasValue && query.WithSpeaker.Value)
{
var speakerDict = (AttendeesManager.I.Get(new AttendeesQuery()
{
Ids = results.Select(a => a.AttendeeId).ToList()
})).ToDictionary(k => k.Id, v => v);
foreach (var result in results)
{
result.Presenter = speakerDict.ContainsKey(result.AttendeeId)
? speakerDict[result.AttendeeId]
: new AttendeesResult();
}
}
return resultList;
}