public async Task <EF.Location> Get(EF.Location args)
{
return(await unitOfWork.LocationRepository.Entities
.Include(x => x.Event).ThenInclude(x => x.Attendance)
.FirstOrDefaultAsync(x => x.Id == args.Id &&
x.CommunityId == args.CommunityId));
}
public async Task <int> Add(EF.Location args)
{
await unitOfWork.LocationRepository.AddAsync(args);
unitOfWork.Commit();
return(args.Id);
}
public IQueryable <EF.Location> Find(EF.Location args)
{
return(unitOfWork.LocationRepository.Entities
.Include(x => x.Event).ThenInclude(x => x.Attendance)
.Where(x => x.Name.Contains(args.Name ?? "") &&
x.CommunityId == args.CommunityId)
.OrderBy(x => x.Name).AsQueryable());
}
public async Task Find_HasNoResult(EF.Location obj)
{
var res = await controller.Find(obj) as JsonResult;
var json = JsonConvert.SerializeObject(res.Value);
var items = JArray.Parse(json);
items.Count.Should().Be(0);
}
public async Task Edit(EF.Location args)
{
var l = await unitOfWork.LocationRepository.Entities.FirstAsync(x => x.Id == args.Id &&
x.CommunityId == args.CommunityId);
l.Name = args.Name;
l.Address = args.Address;
l.DateTimeModified = DateTime.Now;
l.ModifiedBy = args.ModifiedBy;
unitOfWork.Commit();
}
public async Task <IActionResult> Find(EF.Location args)
{
var bll_location = locationBusiness;
var user = HttpContext.Items["EndUser"] as EF.EndUser;
args.CommunityId = user.Member.CommunityId;
var res = from r in (await bll_location.Find(args).ToListAsync())
select new
{
r.Id,
r.Name,
r.Address,
Events = r.Event.Count,
MinAttendees = r.Event.Count <= 0 ? 0 : r.Event.Min(x => x.Attendance.Count),
AverageAttendees = Convert.ToInt16(r.Event.Count <= 0 ? 0 : r.Event.Average(x => x.Attendance.Count)),
MaxAttendees = r.Event.Count <= 0 ? 0 : r.Event.Max(x => x.Attendance.Count)
};
return(Json(res));
}
public Task Delete(EF.Location args)
{
throw new NotImplementedException();
}
