public async Task <int> EventPromoInTheCitiesCount(List <string> cityNames)
{
using (var context = _dbContextFactory.CreateDbContext())
{
return(await context.EventEntities
.Include(x => x.City)
.Include(x => x.PromoRewardRequests)
.Where(x => x.City != null && cityNames.Contains(x.City.CityName) && x.PromoRewardRequests != null && x.PromoRewardRequests.Any())
.CountAsync());
}
}
public async Task AddBadgeToPerson(PersonEntity person, BadgeNames name)
{
using (var context = _dbContextFactory.CreateDbContext())
{
var badge = await context.Badges.SingleOrDefaultAsync(x => x.BadgeId == (long)name);
if (badge != null)
{
await context.PersonToBadgeEntities.AddAsync(new PersonToBadgeEntity { PersonId = person.PersonId, Badge = badge, IsViewed = false });
await context.SaveChangesAsync();
}
}
}
public async Task <PersonEntity> GetPerson(Guid uid, CancellationToken cancellationToken = default)
{
using (var context = _dbContextFactory.CreateDbContext())
{
return(await context.PersonEntities
.Include(x => x.PersonImageContentEntity)
.Include(x => x.FriendList)
.ThenInclude(x => x.Friend)
.ThenInclude(x => x.PersonImageContentEntity)
.Include(x => x.City)
.SingleOrDefaultAsync(x => x.PersonUid == uid, cancellationToken));
}
}
public async Task <bool> CheckEventExistence(Guid eventUid, CancellationToken cancellationToken = default)
{
using (var context = _dbContextFactory.CreateDbContext())
{
return(await context.EventEntities.AnyAsync(x => x.EventUid == eventUid, cancellationToken));
}
}
public async Task <ChatEntity> GetChat(Guid uid, CancellationToken cancellationToken = default)
{
using (var context = _dbContextFactory.CreateDbContext())
{
return(await context.ChatEntities
.Include(x => x.PersonalSettings)
.ThenInclude(x => x.Person)
.SingleOrDefaultAsync(x => x.ChatUid == uid, cancellationToken));
}
}
