| | | 1 | | using System; |
| | | 2 | | using System.Collections.Generic; |
| | | 3 | | using System.Linq; |
| | | 4 | | using System.Threading.Tasks; |
| | | 5 | | using Microsoft.EntityFrameworkCore; |
| | | 6 | | using Microsoft.Extensions.Logging; |
| | | 7 | | using WinSolutions.Sveta.Server.Data.DataModel.Contexts; |
| | | 8 | | using WinSolutions.Sveta.Server.Data.DataModel.Entities; |
| | | 9 | | using WinSolutions.Sveta.Server.Services.Interfaces; |
| | | 10 | | using WinSolutions.Sveta.Common; |
| | | 11 | | using WinSolutions.Sveta.Common.Extensions; |
| | | 12 | | |
| | | 13 | | namespace WinSolutions.Sveta.Server.Services.Implements |
| | | 14 | | { |
| | | 15 | | public class AddressService : SvetaServiceBase, IAddressService |
| | | 16 | | { |
| | | 17 | | private readonly SvetaDbContext _db; |
| | | 18 | | private readonly ILogger<AddressService> _logger; |
| | | 19 | | |
| | | 20 | | public AddressService(SvetaDbContext db, ILogger<AddressService> logger, IAuthenticationService authenticationSe |
| | 185 | 21 | | : base(authenticationService) |
| | 185 | 22 | | { |
| | 185 | 23 | | _db = db; |
| | 185 | 24 | | _logger = logger; |
| | 185 | 25 | | } |
| | | 26 | | |
| | | 27 | | /// <summary> |
| | | 28 | | /// Получает запись адреса по id записи |
| | | 29 | | /// </summary> |
| | | 30 | | /// <param name="id">id адреса</param> |
| | | 31 | | /// <returns>адрес</returns> |
| | | 32 | | public async Task<Address> GetAddress(long id) |
| | 0 | 33 | | { |
| | 0 | 34 | | return await _db.Address.Where(e => !e.IsDeleted).FirstOrDefaultAsync(e=>e.Id == id); |
| | 0 | 35 | | } |
| | | 36 | | |
| | | 37 | | /// <summary> |
| | | 38 | | /// Получает запись адреса по полному адресу |
| | | 39 | | /// </summary> |
| | | 40 | | /// <param name="fullAddress">полный адрес</param> |
| | | 41 | | /// <returns>адрес</returns> |
| | | 42 | | public async Task<Address> GetFullAddress(string fullAddress) |
| | 0 | 43 | | { |
| | 0 | 44 | | return await _db.Address.Where(e => !e.IsDeleted).FirstOrDefaultAsync(e => e.FullAddress.Contains(fullAddres |
| | 0 | 45 | | } |
| | | 46 | | |
| | | 47 | | /// <summary> |
| | | 48 | | /// Возвращает физический адрес по контрагенту |
| | | 49 | | /// </summary> |
| | | 50 | | /// <param name="contragentId">Идентификатор контрагента</param> |
| | | 51 | | /// <returns></returns> |
| | 0 | 52 | | public async Task<Address> GetPhysicAddressByContragent(long contragentId) => await _db.Contragents |
| | 0 | 53 | | .Include(d => d.PhysicAddress) |
| | 0 | 54 | | .Where(d => !d.IsDeleted) |
| | 0 | 55 | | .Where(d => d.Id == contragentId) |
| | 0 | 56 | | .Select(d => d.PhysicAddress) |
| | 0 | 57 | | .FirstOrDefaultAsync(); |
| | | 58 | | |
| | | 59 | | /// <summary> |
| | | 60 | | /// Возвращает актуальный адрес по департаменту |
| | | 61 | | /// </summary> |
| | | 62 | | /// <param name="departmentId">Идентификатор контрагента</param> |
| | | 63 | | /// <returns></returns> |
| | 29 | 64 | | public async Task<Address> GetActualAddressDepartment(long departmentId) => await _db.Departments |
| | 29 | 65 | | .Include(d => d.ActualAddress) |
| | 29 | 66 | | .Where(d => !d.IsDeleted) |
| | 29 | 67 | | .Where(d => d.Id == departmentId) |
| | 29 | 68 | | .Select(d => d.ActualAddress) |
| | 29 | 69 | | .FirstOrDefaultAsync(); |
| | | 70 | | } |
| | | 71 | | } |