public async Task <ServiceResult <SearchEventViewModel> > GetEventByCriteria(
string userId,
string responder,
DateTime?fromDate,
DateTime?toDate,
int offset,
int limit)
{
var agency = await _dbContext
.AgencyUsers
.Where(x => x.UserId == userId)
.Select(x => x.Agency)
.FirstOrDefaultAsync();
if (agency == null)
{
return(new ServiceResult <SearchEventViewModel>("Agency not found"));
}
var query = _dbContext.Events
.Include(x => x.Type)
.Include(x => x.Responder)
.ThenInclude(x => x.Agency)
.Where(x => x.Responder.AgencyId == agency.Id);
if (!string.IsNullOrEmpty(responder))
{
query = query.Where(x => x.Responder.Code.ToLower().Contains(responder.ToLower()));
}
if (fromDate.HasValue)
{
query = query.Where(x => x.EventTime >= fromDate || x.DispatchTime >= fromDate);
}
if (toDate.HasValue)
{
query = query.Where(x => x.EventTime <= toDate || x.DispatchTime <= toDate);
}
query = query.OrderByDescending(x => x.EventTime);
var total = await query.CountAsync();
if (limit > 0)
{
query = query.Skip(offset).Take(limit);
}
var data = await query.ToListAsync();
var result = new SearchEventViewModel()
{
Events = _mapper.Map <List <EventViewModel> >(data),
Total = total
};
return(new ServiceResult <SearchEventViewModel>(result));
}
public IHttpActionResult GetSearchEvents(SearchEventViewModel model)
{
if (ModelState.IsValid)
{
var events = eveRP.Search(model);
return(Ok(events.ToList()));
}
return(BadRequest(ModelState));
}
public List <Event> GetMyEvents()
{
string userId = RequestContext.Principal.Identity.GetUserId();
SearchEventViewModel model = new SearchEventViewModel
{
SwimmerId = userId
};
var events = eveRP.Search(model);
return(events.ToList());
}
public virtual ActionResult Search(SearchEventViewModel model)
{
IEnumerable<Epilogger.Data.Event> evs = ES.GetEventsBySearchTerm(model.SearchTerm);
model.Events = Mapper.Map<IEnumerable<Epilogger.Data.Event>, List<DashboardEventViewModel>>(evs);
return View(model);
}
public ActionResult SearchRedirect(SearchEventViewModel model)
{
return RedirectToAction("Home/Search", model);
}
public SearchEventView()
{
InitializeComponent();
DataContext = new SearchEventViewModel();
}
