| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using OzonDomains.Models; |
| | | 3 | | using OzonRepositories.Context; |
| | | 4 | | |
| | | 5 | | namespace OzonRepositories.Data; |
| | | 6 | | |
| | | 7 | | public class FileUploadRecordRepository : MainRepository, IRepository<FileUploadRecord> |
| | | 8 | | { |
| | 4 | 9 | | public FileUploadRecordRepository(ApplicationDbContext dbContext) : base(dbContext) |
| | | 10 | | { |
| | 4 | 11 | | } |
| | | 12 | | |
| | | 13 | | public async Task<int> Add(FileUploadRecord value) |
| | | 14 | | { |
| | 0 | 15 | | await _context.FileUploadRecords.AddAsync(value); |
| | 0 | 16 | | return await _context.SaveChangesAsync(); |
| | 0 | 17 | | } |
| | | 18 | | |
| | | 19 | | public async Task<int> Delete(FileUploadRecord value) |
| | | 20 | | { |
| | 1 | 21 | | _context.FileUploadRecords.Remove(value); |
| | 1 | 22 | | return await _context.SaveChangesAsync(); |
| | 1 | 23 | | } |
| | | 24 | | |
| | | 25 | | public async Task<List<FileUploadRecord>> Get() |
| | | 26 | | { |
| | 0 | 27 | | return await _context.FileUploadRecords.ToListAsync(); |
| | 0 | 28 | | } |
| | | 29 | | |
| | | 30 | | public async Task<List<FileUploadRecord>> GetPaginatedAsync(int pageNumber, int pageSize) |
| | | 31 | | { |
| | 1 | 32 | | return await _context.FileUploadRecords |
| | 1 | 33 | | .OrderByDescending(r => r.Date) |
| | 1 | 34 | | .ThenByDescending(r => r.Id) |
| | 1 | 35 | | .Skip((pageNumber - 1) * pageSize) |
| | 1 | 36 | | .Take(pageSize) |
| | 1 | 37 | | .ToListAsync(); |
| | 1 | 38 | | } |
| | | 39 | | |
| | | 40 | | public async Task<FileUploadRecord?> GetAsync(int id) |
| | | 41 | | { |
| | 2 | 42 | | return await _context.FileUploadRecords.FindAsync(id); |
| | 2 | 43 | | } |
| | | 44 | | |
| | | 45 | | public async Task<FileUploadRecord?> GetAsync(FileUploadRecord value) |
| | | 46 | | { |
| | 0 | 47 | | return await _context.FileUploadRecords |
| | 0 | 48 | | .FirstOrDefaultAsync(f => f.FileName == value.FileName); |
| | 0 | 49 | | } |
| | | 50 | | |
| | | 51 | | public async Task<int> Update(FileUploadRecord value) |
| | | 52 | | { |
| | 0 | 53 | | _context.FileUploadRecords.Update(value); |
| | 0 | 54 | | return await _context.SaveChangesAsync(); |
| | 0 | 55 | | } |
| | | 56 | | |
| | | 57 | | /// <summary> |
| | | 58 | | /// Одним запросом (WHERE FileName IN (...)) возвращает те из переданных имён файлов, |
| | | 59 | | /// которые уже есть в FileUploadRecords — вместо отдельного запроса на каждый файл. |
| | | 60 | | /// </summary> |
| | | 61 | | public async Task<HashSet<string>> GetExistingFileNamesAsync(IEnumerable<string> fileNames) |
| | | 62 | | { |
| | 0 | 63 | | var names = fileNames.Distinct().ToList(); |
| | 0 | 64 | | if (names.Count == 0) |
| | 0 | 65 | | return new HashSet<string>(); |
| | | 66 | | |
| | 0 | 67 | | var existing = await _context.FileUploadRecords |
| | 0 | 68 | | .AsNoTracking() |
| | 0 | 69 | | .Where(f => names.Contains(f.FileName)) |
| | 0 | 70 | | .Select(f => f.FileName) |
| | 0 | 71 | | .ToListAsync(); |
| | | 72 | | |
| | 0 | 73 | | return existing.ToHashSet(); |
| | 0 | 74 | | } |
| | | 75 | | } |