public ActionResult Checkins() { // A page for seeing what EventDay and Agendas to select int accessEventID = int.Parse(ConfigurationManager.AppSettings["ActiveEvent"]); //List<AgendaDisplayObject> retVal = new List<AgendaDisplayObject>(); List <EventDateDisplayObject> retVal = new List <EventDateDisplayObject>(); List <EventDate> dList = db.EventDates.Where(o => o.EventRecordsID == accessEventID).ToList(); foreach (EventDate eDate in dList) { EventDateDisplayObject toAdd = new EventDateDisplayObject(); toAdd.EventDate = eDate; toAdd.Agendas = db.Agendas.Where(o => o.EventDateID == eDate.ID).ToList(); toAdd.Event = db.EventRecords.Where(o => o.ID == eDate.EventRecordsID).FirstOrDefault(); toAdd.Client = db.Clients.Where(o => o.ID == toAdd.Event.ClientID).FirstOrDefault(); toAdd.AgendaFull = new List <AgendaDisplayObject>(); foreach (Agenda agenda in toAdd.Agendas) { AgendaDisplayObject nowAdd = new AgendaDisplayObject(); nowAdd.Agenda = agenda; nowAdd.ActivityList = new List <Activity>(); nowAdd.ActivityList = db.Activities.Where(o => o.AgendaID == agenda.ID).ToList(); toAdd.AgendaFull.Add(nowAdd); } retVal.Add(toAdd); } return(View(retVal)); }
public ActionResult AgendaCheckins(int id) { // when viewing a specific agenda, show the Activities (if any) and the total Attendees for the Agenda AgendaDisplayObject retVal = DBHelper.GetAgendaWithDataByID(id); retVal.ActivityFullList = new List <ActivityDisplayObject>(); foreach (Activity act in retVal.ActivityList) { ActivityDisplayObject toAdd = new ActivityDisplayObject(); toAdd.Activity = act; toAdd.CurrentCheckins = ATAPS_Pile.GetActivityAttendeeCurrentByActivityID(act.ID, id); if (toAdd.CurrentCheckins == null) { toAdd.CurrentCheckins = new List <AttendeeLastCheck>(); toAdd.CheckedInCount = 0; } else { toAdd.CheckedInCount = toAdd.CurrentCheckins.Count(); } retVal.ActivityFullList.Add(toAdd); } return(View(retVal)); }
// GET: Registration/Busses public ActionResult Busses() { Parm checkinParm = db.Parms.Where(o => o.ParmName == "RegistrationAgendaID").FirstOrDefault(); if (checkinParm == null) { bool good = ATAPS_Pile.CreateRegistrationAgenda(); } checkinParm = db.Parms.Where(o => o.ParmName == "RegistrationAgendaID").FirstOrDefault(); AgendaDisplayObject regAgenda = DBHelper.GetAgendaWithDataByID(int.Parse(checkinParm.ParmValue)); return(View(regAgenda)); }
public static AgendaDisplayObject GetAgendaWithDataByID(int?eID) { AgendaDisplayObject retVal = new AgendaDisplayObject(); if (eID != null) { using (var db = new RFIDDBEntities()) { try { retVal.Agenda = db.Agendas.Where(o => o.ID == eID).FirstOrDefault(); retVal.EventDate = db.EventDates.Where(o => o.ID == retVal.Agenda.EventDateID).FirstOrDefault(); retVal.ActivityList = db.Activities.Where(o => o.AgendaID == retVal.Agenda.ID).ToList(); } catch { } } } return(retVal); }