internal static List <EventDisplayObject> GetAllEventsWithDataByClientID(int?filter)
{
List <EventDisplayObject> retVal = new List <EventDisplayObject>();
int clientID = filter ?? default(int);
using (var db = new RFIDDBEntities())
{
try
{
//var query = db.Clients.ToList();
var query = from b in db.EventRecords
orderby b.ID descending
where b.ClientID == clientID
select b;
foreach (var item in query)
{
EventDisplayObject toAdd = new EventDisplayObject();
toAdd.Event = item;
toAdd.Client = db.Clients.Find(item.ClientID);
var datesQuery = from b in db.EventDates
where b.EventRecordsID == item.ID
select b;
toAdd.EventDates = datesQuery.ToList();
retVal.Add(toAdd);
}
}
catch { }
}
return(retVal);
}
public static EventDisplayObject GetEventWithDataByID(int?eID)
{
EventDisplayObject retVal = new EventDisplayObject();
if (eID != null)
{
using (var db = new RFIDDBEntities())
{
try
{
//var query = db.Clients.ToList();
var query = from b in db.EventRecords
where b.ID == eID
select b;
foreach (var item in query)
{
EventDisplayObject toAdd = new EventDisplayObject();
toAdd.Event = item;
toAdd.Client = db.Clients.Find(item.ClientID);
var datesQuery = from b in db.EventDates
where b.EventRecordsID == item.ID
select b;
toAdd.EventDates = datesQuery.ToList();
retVal = toAdd;
}
}
catch { }
}
}
return(retVal);
}
// GET: Host
public ActionResult Index()
{
int accessEventID = int.Parse(ConfigurationManager.AppSettings["ActiveEvent"]);
EventDisplayObject eventDO = new EventDisplayObject();
eventDO.Event = db.EventRecords.Where(o => o.ID == accessEventID).FirstOrDefault();
eventDO.EventDates = db.EventDates.Where(o => o.EventRecordsID == accessEventID).ToList();
eventDO.Client = db.Clients.Where(o => o.ID == eventDO.Event.ClientID).FirstOrDefault();
List <Attendee> attList = db.Attendees.Where(o => o.EventID == accessEventID).ToList();
// Holds links to various event bits
return(View(eventDO));
}
// GET: EventRecords/Details/5
public ActionResult Details(int?id, int?filter)
{
if (filter == null)
{
return(HttpNotFound());
}
ViewBag.FilterID = filter;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//EventRecord eventRecord = db.EventRecords.Find(id);
EventDisplayObject eventDO = new EventDisplayObject();
eventDO.Event = db.EventRecords.Where(o => o.ID == id).FirstOrDefault();
eventDO.EventDates = db.EventDates.Where(o => o.EventRecordsID == id).ToList();
eventDO.Client = db.Clients.Where(o => o.ID == eventDO.Event.ClientID).FirstOrDefault();
if (eventDO == null || eventDO.Event == null)
{
return(HttpNotFound());
}
return(View(eventDO));
}
