| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using Microsoft.Extensions.Logging; |
| | | 3 | | using System; |
| | | 4 | | using System.Collections.Generic; |
| | | 5 | | using System.Linq; |
| | | 6 | | using System.Text; |
| | | 7 | | using System.Threading.Tasks; |
| | | 8 | | using WinSolutions.Sveta.Server.Data.DataModel.Contexts; |
| | | 9 | | using WinSolutions.Sveta.Server.Data.DataModel.Entities; |
| | | 10 | | using WinSolutions.Sveta.Server.Data.DataModel.Kinds; |
| | | 11 | | using WinSolutions.Sveta.Server.Services.Interfaces; |
| | | 12 | | using WinSolutions.Sveta.Server.Domain; |
| | | 13 | | using WinSolutions.Sveta.Common; |
| | | 14 | | using WinSolutions.Sveta.Common.Extensions; |
| | | 15 | | |
| | | 16 | | namespace WinSolutions.Sveta.Server.Services.Implements |
| | | 17 | | { |
| | | 18 | | public class CommonContragentService : ICommonContragentService |
| | | 19 | | { |
| | | 20 | | readonly SvetaDbContext _db; |
| | | 21 | | readonly ILogger<CommonContragentService> _logger; |
| | | 22 | | |
| | 186 | 23 | | public CommonContragentService(SvetaDbContext db, ILogger<CommonContragentService> logger) |
| | 186 | 24 | | { |
| | 186 | 25 | | _logger = logger; |
| | 186 | 26 | | _db = db; |
| | 186 | 27 | | } |
| | | 28 | | |
| | | 29 | | /// <summary> |
| | | 30 | | /// предварительная выборка контрагентов |
| | | 31 | | /// </summary> |
| | | 32 | | /// <returns></returns> |
| | 0 | 33 | | private IQueryable<Contragent> PrepareContragents() => _db.Contragents |
| | 0 | 34 | | .Include(x => x.BankAccounts) |
| | 0 | 35 | | .Include(x => x.JuridicAddress) |
| | 0 | 36 | | .Include(x => x.PhysicAddress) |
| | 0 | 37 | | .Include(d => d.ContragentsKind) |
| | 0 | 38 | | .Include(d => d.RecState) |
| | 0 | 39 | | .Include(d => d.Owner) |
| | 0 | 40 | | .Where(e => !e.IsDeleted) |
| | 0 | 41 | | .AsQueryable(); |
| | | 42 | | |
| | | 43 | | /// <summary> |
| | | 44 | | /// Получает контрагента по id |
| | | 45 | | /// </summary> |
| | | 46 | | /// <param name="contragentId">id контрагента</param> |
| | | 47 | | /// <returns>контрагент</returns> |
| | 0 | 48 | | public async Task<Contragent> GetContragent(long contragentId) => await PrepareContragents() |
| | 0 | 49 | | .FirstOrDefaultAsync(e => e.Id == contragentId); |
| | | 50 | | |
| | | 51 | | /// <summary> |
| | | 52 | | /// получает тип контрагента |
| | | 53 | | /// </summary> |
| | | 54 | | /// <param name="guid">гуид типа</param> |
| | | 55 | | /// <returns>тип контрагента</returns> |
| | 0 | 56 | | public async Task<ContragentsKind> GetContragentKind(Guid guid) => await _db.refContragentsKind |
| | 0 | 57 | | .FirstOrDefaultAsync(e => !e.IsDeleted && e.ExternalKey.Equals(guid)); |
| | | 58 | | |
| | | 59 | | /// <summary> |
| | | 60 | | /// получает адрес на основе полного адреса |
| | | 61 | | /// </summary> |
| | | 62 | | /// <param name="fulladdress">полный адрес</param> |
| | | 63 | | /// <returns>адрес</returns> |
| | 0 | 64 | | public async Task<Address> GetAddress(string fulladdress) => await _db.Address |
| | 0 | 65 | | .FirstOrDefaultAsync(e => !e.IsDeleted && e.FullAddress.ToLower().Equals(fulladdress.NormalizeName().ToL |
| | | 66 | | |
| | | 67 | | /// <summary> |
| | | 68 | | /// проверяет существует ли еще контрагент с такими же ИНН и КПП |
| | | 69 | | /// </summary> |
| | | 70 | | /// <param name="data">контрагент</param> |
| | | 71 | | /// <returns>значение true/false</returns> |
| | 0 | 72 | | public async Task<bool> ContragentInnKppExist(Contragent data) => await _db.Contragents.AnyAsync(x => !x.IsDelet |
| | 0 | 73 | | x.Kpp.ToLower() == data.Kpp.NormalizeName().ToLower() |
| | 0 | 74 | | && x.Inn.ToLower() == data.Inn.NormalizeName().ToLower() && x.Id != data.Id); |
| | | 75 | | |
| | | 76 | | /// <summary> |
| | | 77 | | ///получает контрагента по externalKey |
| | | 78 | | /// </summary> |
| | | 79 | | /// <param name="tid">externalKey</param> |
| | | 80 | | /// <returns>контрагент</returns> |
| | 0 | 81 | | public async Task<Contragent> GetContragent(Guid tid) => await PrepareContragents().FirstOrDefaultAsync(x => x.E |
| | | 82 | | |
| | | 83 | | /// <summary> |
| | | 84 | | /// создает контрагента |
| | | 85 | | /// </summary> |
| | | 86 | | /// <param name="data">контрагент</param> |
| | | 87 | | /// <param name="userId">id юзера, от кого выполняется</param> |
| | | 88 | | /// <returns></returns> |
| | | 89 | | public async Task Create(Contragent data, long userId) |
| | 571 | 90 | | { |
| | 571 | 91 | | _db.Entry(data.Owner).State = EntityState.Unchanged; |
| | 571 | 92 | | _db.Entry(data.JuridicAddress).State = EntityState.Unchanged; |
| | 571 | 93 | | _db.Entry(data.PhysicAddress).State = EntityState.Unchanged; |
| | 571 | 94 | | _db.Entry(data.ContragentsKind).State = EntityState.Unchanged; |
| | 571 | 95 | | await _db.Contragents.AddAsync(data); |
| | 571 | 96 | | await _db.SaveChangesAsync(userId); |
| | 571 | 97 | | } |
| | | 98 | | |
| | | 99 | | /// <summary> |
| | | 100 | | /// обновляет контрагента |
| | | 101 | | /// </summary> |
| | | 102 | | /// <param name="data">контрагент</param> |
| | | 103 | | /// <param name="userId">id юзера, от кого выполняется</param> |
| | | 104 | | /// <returns></returns> |
| | | 105 | | public async Task Update(Contragent data, long userId) |
| | 370 | 106 | | { |
| | 370 | 107 | | _db.Contragents.Update(data); |
| | 370 | 108 | | await _db.SaveChangesAsync(userId); |
| | 370 | 109 | | } |
| | | 110 | | |
| | | 111 | | /// <summary> |
| | | 112 | | /// обновляет тип контрагента |
| | | 113 | | /// </summary> |
| | | 114 | | /// <param name="data">тип контрагент</param> |
| | | 115 | | /// <param name="userId">id юзера, от кого выполняется</param> |
| | | 116 | | /// <returns></returns> |
| | | 117 | | public async Task CreateContragentKind(ContragentsKind data, long userId) |
| | 0 | 118 | | { |
| | 0 | 119 | | await _db.refContragentsKind.AddAsync(data); |
| | 0 | 120 | | await _db.SaveChangesAsync(userId); |
| | 0 | 121 | | } |
| | | 122 | | |
| | | 123 | | /// <summary> |
| | | 124 | | /// обновляет тип контрагента |
| | | 125 | | /// </summary> |
| | | 126 | | /// <param name="data">тип контрагент</param> |
| | | 127 | | /// <param name="userId">id юзера, от кого выполняется</param> |
| | | 128 | | /// <returns></returns> |
| | | 129 | | public async Task UpdateContragentKind(ContragentsKind data, long userId) |
| | 0 | 130 | | { |
| | 0 | 131 | | _db.refContragentsKind.Update(data); |
| | 0 | 132 | | await _db.SaveChangesAsync(userId); |
| | 0 | 133 | | } |
| | | 134 | | |
| | | 135 | | /// <summary> |
| | | 136 | | /// создает адрес |
| | | 137 | | /// </summary> |
| | | 138 | | /// <param name="data">адрес</param> |
| | | 139 | | /// <param name="userId">id юзера, от кого выполняется</param> |
| | | 140 | | /// <returns></returns> |
| | | 141 | | public async Task CreateAddress(Address data, long userId) |
| | 0 | 142 | | { |
| | 0 | 143 | | await _db.Address.AddAsync(data); |
| | 0 | 144 | | await _db.SaveChangesAsync(userId); |
| | 0 | 145 | | } |
| | | 146 | | |
| | | 147 | | /// <summary> |
| | | 148 | | /// обновляет адрес |
| | | 149 | | /// </summary> |
| | | 150 | | /// <param name="data">адрес</param> |
| | | 151 | | /// <param name="userId">id юзера, от кого выполняется</param> |
| | | 152 | | /// <returns></returns> |
| | | 153 | | public async Task UpdateAddress(Address data, long userId) |
| | 0 | 154 | | { |
| | 0 | 155 | | _db.Address.Update(data); |
| | 0 | 156 | | await _db.SaveChangesAsync(userId); |
| | 0 | 157 | | } |
| | | 158 | | |
| | | 159 | | /// <summary> |
| | | 160 | | /// Получает служебную запись |
| | | 161 | | /// </summary> |
| | | 162 | | /// <param name="id">id записи</param> |
| | | 163 | | /// <returns></returns> |
| | 0 | 164 | | private async Task<RecordsState> GetRecordState(long id) => await _db.refRecordsState.Where(e => !e.IsDeleted).F |
| | | 165 | | |
| | | 166 | | |
| | | 167 | | } |
| | | 168 | | } |