//public void UpdateAttendeesIdInSession()
//{
// AttendeesManager attendeesManager = new AttendeesManager();
// SessionsManager sessionsManager = new SessionsManager();
// List<SessionsResult> listSessions = sessionsManager.GetJustBaseTableColumns(new SessionsQuery());
// foreach (var sessionResult in listSessions)
// {
// List<AttendeesResult> listAttendees =
// attendeesManager.GetJustBaseTableColumns(new AttendeesQuery() {Username = sessionResult.Username});
// sessionResult.Attendeesid = listAttendees[0].Id;
// sessionsManager.Update(sessionResult);
// }
//}
public void SetAllAttendeesToYear2008()
{
AttendeesManager attendeesManager = new AttendeesManager();
List<AttendeesResult> listAttendees = attendeesManager.GetJustBaseTableColumns(new AttendeesQuery());
foreach (var attendee in listAttendees)
{
AttendeesCodeCampYearManager.I.Insert(new AttendeesCodeCampYearResult()
{
AttendeesId = attendee.Id,
CodeCampYearId = 3
});
}
}
public void JsonPCallback()
{
string Callback = Request.QueryString["jsonp"];
if (!string.IsNullOrEmpty(Callback))
{
var attendeesQuery = new AttendeesQuery();
if (HttpContext.Current.Request["query"] != null)
{
attendeesQuery = HttpContext.Current.Request["query"].FromJson<AttendeesQuery>();
}
//attendeesQuery.CodeCampYearId = Utils.CurrentCodeCampYear;
// attendeesQuery.Id = 6061;
attendeesQuery.PresentersOnly = true;
attendeesQuery.CodeCampYearIds = new List<int>() {7};
int bioMaxLen = 4096;
if (HttpContext.Current.Request["biomaxlen"] != null)
{
Int32.TryParse(HttpContext.Current.Request["biomaxlen"] ?? "", out bioMaxLen);
}
var attendeesManager = new AttendeesManager();
var listDataSpeakers = attendeesManager.Get(attendeesQuery);
var sessionsManager = new SessionsManager();
var sessionsResults = sessionsManager.Get(new SessionsQuery()
{
CodeCampYearId = Utils.CurrentCodeCampYear
});
//var xxx = listDataSpeakers.Where(a => a.Id == 6061).ToList();
//var yyy = sessionsResults.Where(a => a.Attendeesid == 6061).ToList();
var listDataResults = (from data in listDataSpeakers
orderby data.UserLastName
select new
{
AttendeesId = data.Id,
data.UserFirstName,
data.UserLastName,
data.UserWebsite,
data.PKID,
UserBio = TruncateStringWithEllipse(data.UserBio,4090),
UserBioShort = TruncateStringWithEllipse(data.UserBio, bioMaxLen),
data.SpeakerPictureUrl,
data.TwitterHandle
// AFTER REMOVING ATTENDEESID FROM SESSION THIS BROKE. NEED TO FIX IF WE WANT TO
// MAKE JSONP WORK AGAIN CORRECTLY
//Sessions = (from data1 in sessionsResults
// where data1.Attendeesid == data.Id &&
// data1.CodeCampYearId == Utils.CurrentCodeCampYear
// select new
// {
// data1.Id,
// data1.Title,
// data1.Description,
// data.UserFirstName,
// data.UserLastName
// }).ToList()
}).ToList();
//var xx = listDataResults.Where(a => a.AttendeesId == 6061).ToList();
//foreach (var rec in listDataResults)
//{
// if (bioMaxLen != 0)
// {
// int oriLen = rec.UserBio.Length;
// if (oriLen > bioMaxLen)
// {
// rec.UserBio = rec.UserBio.Substring(0, bioMaxLen) + "...";
// }
// }
//}
var ret = new { success = true, rows = listDataResults, total = attendeesQuery.OutputTotal };
Response.Write(Callback + "( " + ret.ToJson() + " );");
}
Response.End();
}
