public ActionResult MyEvents() { var currentUser = User.Identity.Name; EventTitleViewModel eventTitle = new EventTitleViewModel(); EventOperations eventOperation = new EventOperations(); var result = eventOperation.myEvents(currentUser).Select(eventDetails => new EventTitleViewModel() { Id = eventDetails.EventId, Title = eventDetails.Title, Date = eventDetails.EventDate, }).ToList(); var passedEvents = result.Where(e => e.Date < DateTime.Now); var allupcomingEvents = result.Where(e => e.Date >= DateTime.Now); return(View("MyEvents", new UpcomingPassedEventsModel() { PassedEvents = passedEvents, FutureEvents = allupcomingEvents } )); }
// GET: Events public async Task <IActionResult> Index(string searchString, string eventTitle) { //all title string list IQueryable <string> titleQuery = from e in _context.Event orderby e.Title select e.Title; var events = from e in _context.Event select e; if (!String.IsNullOrEmpty(eventTitle)) { events = events.Where(e => e.Title == eventTitle); } if (!String.IsNullOrEmpty(searchString)) { events = events.Where(e => e.Location.Contains(searchString)); } var EventTitleMV = new EventTitleViewModel(); EventTitleMV.titles = new SelectList(await titleQuery.Distinct().ToListAsync()); EventTitleMV.events = await events.ToListAsync(); return(View(EventTitleMV)); }