internal static List <ActivityDisplayObject> GetAllActivitiesWithDataByAgendaID(int?eID)
{
List <ActivityDisplayObject> retval = new List <ActivityDisplayObject>();
if (eID != null)
{
using (var db = new RFIDDBEntities())
{
try
{
List <Activity> aList = db.Activities.Where(o => o.AgendaID == eID).ToList();
foreach (var item in aList)
{
ActivityDisplayObject toAdd = new ActivityDisplayObject();
toAdd.Activity = item;
toAdd.Agenda = db.Agendas.Where(o => o.ID == item.AgendaID).FirstOrDefault();
toAdd.ActivityDetail = db.ActivityDetails.Where(o => o.ActivityID == item.ID).FirstOrDefault();
retval.Add(toAdd);
}
}
catch { }
}
}
return(retval);
}
internal static bool CreateRegistrationAgenda()
{
// no Registration Agenda has yet been created for this Event
RFIDDBEntities db = new RFIDDBEntities();
int accessEventID = int.Parse(ConfigurationManager.AppSettings["ActiveEvent"]);
Parm checkinParm = new Parm();
List <EventDate> eDates = db.EventDates.Where(o => o.EventRecordsID == accessEventID).OrderBy(o => o.EventDate1).ToList();
checkinParm.ParmName = "RegistrationAgendaID";
Agenda regAg = new Agenda();
regAg.AgendaName = "Registration";
regAg.AgendaOrder = 0;
regAg.AgendaType = 1;
regAg.EventDateID = eDates[0].ID;
db.Agendas.Add(regAg);
db.SaveChanges();
checkinParm.ParmValue = regAg.ID.ToString();
db.Parms.Add(checkinParm);
db.SaveChanges();
return(true);
}
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);
}
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);
}
public static List <Attendee> GetTotalAgendaAttendanceByID(int agnID)
{
RFIDDBEntities db = new RFIDDBEntities();
List <AttendeeLastCheck> checks = db.AttendeeLastChecks.Where(o => o.AgendaID == agnID).ToList();
List <Attendee> retVal = db.Attendees.Where(p => checks.Any(p2 => p2.AttendeeID == p.ID)).ToList();
return(retVal);
}
// GET: EventRecords/Create
public ActionResult Create(int?filter)
{
if (filter == null)
{
return(HttpNotFound());
}
ViewBag.FilterID = filter;
RFIDDBEntities db = new RFIDDBEntities();
ViewBag.PossibleClients = db.Clients.Where(o => o.ID == filter).ToList();
EventRecord eventRec = new EventRecord();
eventRec.EventCode = "Invalid Client ID";
if (ViewBag.PossibleClients.Count > 0)
{
eventRec.EventCode = ATAPS_Pile.GenerateEventShortcode(ViewBag.PossibleClients[0].ClientName);
}
return(View(eventRec));
}
public static List <GiftCard> GetIssued(RFIDDBEntities db, Attendee attendee)
{
// start an empty list
List <GiftCard> results = new List <GiftCard>();
// get all the parms
string name = "GiftCard-" + attendee.ID;
List <Parm> parms = db.Parms.Where(x => x.ParmName == name).ToList();
// convert the parms to GiftCard objects
foreach (Parm parm in parms)
{
string number = parm.ParmValue;
string sig_url = "/Content/gift_card_signatures/" + attendee.LastName + attendee.FirstName + "-GiftCardSig-" + number + ".png";
results.Add(new GiftCard(sig_url, number));
}
// return the list
return(results);
}
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);
}
public static List <AttendeeLastCheck> GetActivityAttendeeCurrentByActivityID(int actID, int agnID)
{
RFIDDBEntities db = new RFIDDBEntities();
int retVal = 0;
// NOTE: I know there's a cleaner way to pull this list without having to loop through it, but I'm coming up with blank. We should take another look at this when
// we have time to ponder the problem. I know this is close, but should be possible to do without the loop.
// UPDATE: I added a LINQ query that seems to be right, but still have to loop through the var to get the count.
List <AttendeeLastCheck> checks = db.AttendeeLastChecks.Where(o => o.LastActivity == actID).OrderBy(o => o.AttendeeID).ThenByDescending(o => o.LastUpdate).ToList();
//var res = from element in checks
// group element by element.AttendeeID
// into groups
// select groups.OrderBy(p => p.LastUpdate).First();
//int temp = 0;
//foreach(var item in res)
//{
// if(item.CheckDir == "In") { temp++; }
//}
List <AttendeeLastCheck> latest = new List <AttendeeLastCheck>();
int lastID = -1;
foreach (AttendeeLastCheck aCh in checks)
{
if (aCh.AttendeeID != lastID)
{
lastID = aCh.AttendeeID;
if (aCh.CheckDir == "In")
{
latest.Add(aCh);
}
}
}
return(latest);
}
public static List <Attendee> GetSortedAttendeesWithFilter(int?filter, string sortOrder, string searchString, int?pageNum)
{
RFIDDBEntities db = new RFIDDBEntities();
List <Attendee> retVal = new List <Attendee>();
int pageSize = 25;
// here we pull the query based on the sort order and direction
List <Attendee> attendees = new List <Attendee>();
attendees = db.Attendees.Where(o => o.EventID == filter).ToList();
if (!String.IsNullOrEmpty(searchString))
{
attendees = attendees.Where(s => s.LastName.ToLower().Contains(searchString.ToLower()) ||
s.FirstName.ToLower().Contains(searchString.ToLower()) ||
s.RfID.ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "name_desc":
attendees = attendees.OrderByDescending(s => s.LastName).ToList();
break;
case "WinnerQueueOrder":
attendees = attendees.OrderByDescending(s => s.WinnerQueueOrder.HasValue).ThenBy(s => s.WinnerQueueOrder).ToList();
break;
case "wqo_desc":
attendees = attendees.OrderByDescending(s => s.WinnerQueueOrder.HasValue).ThenByDescending(s => s.WinnerQueueOrder).ToList();
break;
case "ParticipantType":
attendees = attendees.OrderBy(s => s.ParticipantType).ToList();
break;
case "ptype_desc":
attendees = attendees.OrderByDescending(s => s.ParticipantType).ToList();
break;
case "RSVPStatus":
attendees = attendees.OrderBy(s => s.RSVPStatus).ToList();
break;
case "rsvp_desc":
attendees = attendees.OrderByDescending(s => s.RSVPStatus).ToList();
break;
case "RFID":
attendees = attendees.OrderBy(s => s.RfID).ToList();
break;
case "rfid_desc":
attendees = attendees.OrderByDescending(s => s.RfID).ToList();
break;
default:
attendees = attendees.OrderBy(s => s.LastName).ToList();
break;
}
retVal = attendees;
return(retVal);
}
