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); }
public Task MarkReadAsync(Guid channelId, Guid newsId, Guid personId, IMarkNewsReadRepository.NewsReadType readType = IMarkNewsReadRepository.NewsReadType.Read) => MarkReadAsync(channelId, new Guid[] { newsId }, personId, readType);