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)); } }