Example #1
0
        public async Task ExportContractorsToErp(TaskTicket taskTicket, Target target)
        {
            var countries = await _dbContext.Countries.ToListAsync().ConfigureAwait(false);

            await FvpWebAppUtils.ChangeTicketStatus(_dbContext, taskTicket.TaskTicketId, TicketStatus.Pending);

            var allSourcesFromTarget = await _dbContext.Sources.Where(s => s.TargetId == target.TargetId).Select(i => i.SourceId).ToListAsync();

            var notMatchedContractors = await _dbContext.Contractors.Where(
                c => c.ContractorErpId == null &&
                c.ContractorErpPosition == null &&
                //c.GusContractorEntriesCount == 1 &&
                (c.ContractorStatus == ContractorStatus.Valid || c.ContractorStatus == ContractorStatus.Accepted) &&
                c.SourceId == taskTicket.SourceId).ToListAsync().ConfigureAwait(false);

            var c21Contractors = notMatchedContractors.GroupBy(c =>
                                                               new
            {
                ContractorId   = c.ContractorId,
                VatId          = string.IsNullOrEmpty(c.VatId) || c.VatId.ToUpper() == "BRAK" ? "" : c.VatId,
                Regon          = string.IsNullOrEmpty(c.Regon) ? "" : c.Regon,
                Name           = string.IsNullOrEmpty(c.Name) ? "" : c.Name,
                Street         = string.IsNullOrEmpty(c.Street) ? "" : c.Street,
                EstateNumber   = string.IsNullOrEmpty(c.EstateNumber) ? "" : c.EstateNumber,
                QuartersNumber = string.IsNullOrEmpty(c.QuartersNumber) ? "" : c.QuartersNumber,
                City           = string.IsNullOrEmpty(c.City) ? "" : c.City,
                CountryCode    = string.IsNullOrEmpty(c.CountryCode) ? "" : c.CountryCode,
                PostalCode     = string.IsNullOrEmpty(c.PostalCode) ? "" : c.PostalCode,
                Province       = string.IsNullOrEmpty(c.Province) ? "" : c.Province,
                Phone          = string.IsNullOrEmpty(c.Phone) ? "" : c.Phone,
                Email          = string.IsNullOrEmpty(c.Email) ? "" : c.Email,
            }).Select(c =>
                      new C21Contractor
            {
                nip         = c.Key.VatId,
                Regon       = c.Key.Regon,
                nazwa       = FvpWebAppUtils.TruncateToLength(c.Key.Name, 100),
                ulica       = FvpWebAppUtils.TruncateToLength(c.Key.Street.Replace("ul. ", "").Replace("UL. ", ""), 35),
                numerDomu   = c.Key.EstateNumber,
                numerMieszk = c.Key.QuartersNumber,
                Miejscowosc = FvpWebAppUtils.TruncateToLength(c.Key.City, 40),
                rejon       = c.Key.Province.ToLower(),
                Kraj        = c.Key.CountryCode,
                kod         = FvpWebAppUtils.TruncateToLength(c.Key.PostalCode, 10),
                Telefon1    = c.Key.Phone,
                email       = c.Key.Email,
                aktywny     = true,
                skrot       = $"FVP-{taskTicket.SourceId}-{c.Key.ContractorId}",
                statusUE    = FvpWebAppUtils.CheckUeCountry(countries, c.Key.CountryCode),
            }).ToList();

            C21ContractorService c21ContractorService = new C21ContractorService(GetDbSettings(target));
            await c21ContractorService.AddContractorsAsync(c21Contractors);

            var output = await c21ContractorService.ProceedContractorsAsync();

            string outputData = "";

            foreach (var item in output)
            {
                outputData += "; " + item;
            }
            Console.WriteLine(outputData);
            SystemDataService systemDataService = new SystemDataService(_logger, _dbContext);
            await systemDataService.MatchContractors(taskTicket, target);
        }
Example #2
0
        public async Task <C21DocumentAggregate> PrepareDocumentAggregate(
            List <AccountingRecord> accountingRecords,
            TargetDocumentSettings targetDocumentSettings,
            List <Contractor> contractors,
            List <DocumentVat> allDocumentVats,
            List <VatRegister> vatRegisters,
            C21DocumentService c21DocumentService,
            Document document, Source source)
        {
            C21DocumentAggregate c21DocumentAggregate = new C21DocumentAggregate();

            var documentVats = allDocumentVats.Where(v => v.DocumentId == document.DocumentId).ToList();

            if (accountingRecords == null)
            {
                c21DocumentAggregate.IsPrepared = false;
                c21DocumentAggregate.Messages.Add(new KeyValuePair <string, string>("Zapisy księgowe", "Brak konfiguracji zapisów księgowych"));
                return(c21DocumentAggregate);
            }
            if (targetDocumentSettings == null)
            {
                c21DocumentAggregate.IsPrepared = false;
                c21DocumentAggregate.Messages.Add(new KeyValuePair <string, string>("Konfiguracja dokumentu", $"Nie skonfigurowano typu dokumentu dla tego źródła danych: {source.Description}"));
                return(c21DocumentAggregate);
            }

            var c21documentId = 1000;//await c21DocumentService.GetNextDocumentId(1000);
            var year          = await c21DocumentService.GetYearId(document.SaleDate);

            if (year == null)
            {
                Console.WriteLine($"Brak roku w FK dla dokumentu z tego okresu.");
            }
            var docTypDef = await c21DocumentService.GetDocumentDefinition(targetDocumentSettings.DocumentShortcut, year.rokId);

            if (docTypDef == null)
            {
                Console.WriteLine($"Brak definicji dokumentu w FK dla dokumentu z tego okresu. ({document.DocumentNumber})");
            }
            var vatRegisterDef = await c21DocumentService.GetVatRegistersDefs(docTypDef.rejestr);

            var contractor = contractors.FirstOrDefault(c => c.ContractorId == document.ContractorId);

            if (year != null && contractor != null && vatRegisterDef != null)
            {
                var street = !string.IsNullOrEmpty(contractor.Street) ? contractor.Street.Replace("UL. ", "").Replace("ul. ", "") : "";
                c21DocumentAggregate.Document = new C21Document
                {
                    id             = c21documentId,
                    rokId          = year.rokId,
                    skrot          = targetDocumentSettings.DocumentShortcut,
                    kontrahent     = contractor.ContractorErpPosition,
                    nazwa          = document.DocumentNumber,
                    tresc          = document.DocumentNumber,
                    datawpr        = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day),
                    datadok        = document.DocumentDate,
                    dataOper       = document.SaleDate,
                    kwota          = Convert.ToDouble(document.Gross),
                    sygnatura      = string.Empty,
                    kontoplatnosci = string.Empty,
                    atrJpkV7       = document.JpkV7,
                    DaneKh         = 0, //contractor.ContractorErpPosition == null ? 1 : 0,
                    kh_nazwa       = string.IsNullOrEmpty(contractor.Name) ? "" : contractor.Name.Length <= 150 ? contractor.Name : contractor.Name.Substring(0, 150),
                    kh_ulica       = string.IsNullOrEmpty(street) ? "" : street.Length <= 50 ? street : street.Substring(0, 50),
                    kh_dom         = contractor.EstateNumber,
                    kh_lokal       = contractor.QuartersNumber,
                    kh_nip         = contractor.VatId,
                    kh_kodPocztowy = FvpWebAppUtils.TruncateToLength(contractor.PostalCode, 10),
                    kh_miejscowosc = string.IsNullOrEmpty(contractor.City) ? "" : contractor.City.Length <= 50 ? contractor.City : contractor.City.Substring(0, 50),
                    kh_kraj        = contractor.CountryCode
                };
                var nextAccountingRecordId = 1000;
                foreach (var accountingRecord in accountingRecords)
                {
                    if (GetRecordAmmount(document, accountingRecord) != 0)
                    {
                        c21DocumentAggregate.AccountingRecords.Add(new C21AccountingRecord
                        {
                            id       = nextAccountingRecordId,
                            dokId    = c21documentId,
                            pozycja  = 0,
                            rozbicie = (short)(accountingRecord.RecordOrder - 1),
                            strona   = !string.IsNullOrEmpty(accountingRecord.Debit) ? (short)0 : (short)1,
                            kwota    = GetRecordAmmount(document, accountingRecord),
                            opis     = document.DocumentNumber,
                            synt     = GetAccountPart(accountingRecord.Account, 0),
                            poz1     = GetAccountPart(accountingRecord.Account, 1),
                            poz2     = GetAccountPart(accountingRecord.Account, 2),
                            poz3     = GetAccountPart(accountingRecord.Account, 3),
                            poz4     = GetAccountPart(accountingRecord.Account, 4),
                            poz5     = GetAccountPart(accountingRecord.Account, 5),
                        });
                    }
                    nextAccountingRecordId++;
                }
                var nextVatRegisterId = 1000;
                foreach (var documentVat in documentVats)
                {
                    var vatRegister = GetVatRegisterIdForVat(GetVatValue(documentVat), vatRegisters);
                    c21DocumentAggregate.VatRegisters.Add(new C21VatRegister
                    {
                        id           = nextVatRegisterId,
                        dokId        = c21documentId,
                        rejId        = vatRegister > 0 ? vatRegister : vatRegisterDef.id,
                        okres        = document.SaleDate,
                        Oczek        = 0,
                        abc          = vatRegisterDef.defAbc,
                        nienaliczany = 0,
                        stawka       = GetVatValue(documentVat),
                        netto        = Convert.ToDouble(documentVat.NetAmount),
                        brutto       = Convert.ToDouble(documentVat.GrossAmount),
                        vat          = Convert.ToDouble(documentVat.VatAmount),
                        atrJpkV7     = documentVat.VatTags
                    });
                    nextVatRegisterId++;
                }
            }
            c21DocumentAggregate.IsPrepared = true;
            return(c21DocumentAggregate);
        }