public EventPlanningModel Get(int id) { var result = new EventPlanningModel(); using (var db = new DataContext()) { var conf = db.CallsForSpeakers.Include(x => x.Organizer) .SingleOrDefault(x => x.Id == id); if (conf == null) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); } result.EventName = conf.EventName; result.EventDescription = conf.Description; result.EventLogoUrl = conf.LogoUrl; result.OrganizerName = conf.Organizer.Name; result.OrganizerEmail = conf.Organizer.Email; result.FirstDay = conf.FirstDayOfEvent; result.LastDay = conf.LastDayOfEvent; result.LastDayToSubmit = conf.LastDayToSubmit; var acceptedSessions = db.Submissions .Where(s => s.CallForSpeakers.Id == id && s.Status == Submission.Accepted).ToArray(); result.AcceptedSubmissions = acceptedSessions.Select(x => new AcceptedSubmissions { Abstract = x.Abstract, Title = x.Title, SpeakerEmail = x.SpeakerEmail, SpeakerName = x.SpeakerName, SpeakerPhotoUrl = x.SpeakerImageUrl, SpeakerTwitter = x.SpeakerTwitter, SpeakerBio = x.SpeakerBio, SpeakerPhone = x.SpeakerPhone }); } return result; }
public EventPlanningModel Get(int id) { var result = new EventPlanningModel(); using (var db = new DataContext()) { var conf = db.CallsForSpeakers.Include(x => x.Organizer) .SingleOrDefault(x => x.Id == id); if (conf == null) { throw new HttpResponseException(new HttpResponseMessage(HttpStatusCode.NotFound)); } result.EventName = conf.EventName; result.EventDescription = conf.Description; result.EventLogoUrl = conf.LogoUrl; result.OrganizerName = conf.Organizer.Name; result.OrganizerEmail = conf.Organizer.Email; result.FirstDay = conf.FirstDayOfEvent; result.LastDay = conf.LastDayOfEvent; result.LastDayToSubmit = conf.LastDayToSubmit; var acceptedSessions = db.Submissions .Where(s => s.CallForSpeakers.Id == id && s.Status == Submission.Accepted).ToArray(); result.AcceptedSubmissions = acceptedSessions.Select(x => new AcceptedSubmissions { Abstract = x.Abstract, Title = x.Title, SpeakerEmail = x.SpeakerEmail, SpeakerName = x.SpeakerName, SpeakerPhotoUrl = x.SpeakerImageUrl, SpeakerTwitter = x.SpeakerTwitter, SpeakerBio = x.SpeakerBio, SpeakerPhone = x.SpeakerPhone }); } return(result); }