示例#1
0
        public async Task MarkReadAsync(Guid channelId, ICollection <Guid> newsIds, Guid personId, IMarkNewsReadRepository.NewsReadType readType)
        {
            var sql =
                "INSERT INTO ChannelNewsReads (Id, ChannelId, NewsId, PersonId, CreatedOn, ReadType)" +
                " VALUES (@id, @channelId, @newsId, @personId, @createdOn, @readType)";


            var sqlData = newsIds.Select(id => new
            {
                id = Guid.NewGuid(),
                channelId,
                newsId = id,
                personId,
                createdOn = DateTime.UtcNow,
                readType  = readType.ToString()
            }).ToList();

            await using var connection = new SqlConnection(this.connectionString);
            await connection.ExecuteAsync(sql, sqlData);
        }
示例#2
0
 public Task MarkReadAsync(Guid channelId, Guid newsId, Guid personId, IMarkNewsReadRepository.NewsReadType readType = IMarkNewsReadRepository.NewsReadType.Read)
 => MarkReadAsync(channelId, new Guid[] { newsId }, personId, readType);