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));
}
// GET: EventDates/Delete/5
public ActionResult Delete(int?id, int?filter)
{
if (id == null || filter == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventDate eventDateList = db.EventDates.Where(o => o.ID == id).FirstOrDefault();
//EventDate eventDate = db.EventDates.Find(id);
EventDateDisplayObject edDO = new EventDateDisplayObject();
edDO.Agendas = db.Agendas.Where(o => o.EventDateID == id).ToList();
edDO.EventDate = eventDateList;
ViewBag.FilterID = filter;
return(View(edDO));
//if (id == null || filter == null)
//{
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
//}
//int getID = id ?? default(int);
//EventDate eventDate = db.EventDates.Find(getID);
//if (eventDate == null)
//{
// return HttpNotFound();
//}
//ViewBag.FilterID = filter;
//return View(eventDate);
}
internal static List <EventDateDisplayObject> GetAllEventDates()
{
List <EventDateDisplayObject> retVal = new List <EventDateDisplayObject>();
using (var db = new RFIDDBEntities())
{
try
{
//var query = db.Clients.ToList();
var query = from b in db.EventDates
orderby b.ID descending
select b;
foreach (var item in query)
{
EventDateDisplayObject toAdd = new EventDateDisplayObject();
toAdd.EventDate = item;
toAdd.Event = db.EventRecords.Find(item.EventRecordsID);
toAdd.Client = db.Clients.Find(toAdd.Event.ClientID);
var agQuery = from b in db.Agendas
where b.EventDateID == item.ID
select b;
toAdd.Agendas = agQuery.ToList();
retVal.Add(toAdd);
}
}
catch { }
}
return(retVal);
}
// GET: EventDates/Details/5
public ActionResult Details(int?id, int?filter)
{
if (id == null || filter == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EventDate eventDateList = db.EventDates.Where(o => o.ID == id).FirstOrDefault();
//EventDate eventDate = db.EventDates.Find(id);
EventDateDisplayObject edDO = new EventDateDisplayObject();
edDO.Agendas = db.Agendas.Where(o => o.EventDateID == id).ToList();
edDO.EventDate = eventDateList;
ViewBag.FilterID = filter;
return(View(edDO));
}
