public Payments GetPayment(SaftDTO pFilter) { List <Payment> receiptsList = new List <Payment>(); var Payments = new Payments(); try { bdContext.ComandText = "stp_SAFT_RECEIPTS"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { if (Payments.NumberOfEntries == 0) { Payments = new Payments { NumberOfEntries = int.Parse(dr[0].ToString()), TotalDebit = int.Parse(dr[0].ToString()) > 0 ? dr[1].ToString().Replace(",", ".").Replace("-", string.Empty) : "0.00", TotalCredit = int.Parse(dr[0].ToString()) > 0 ? dr[2].ToString().Replace(",", ".").Replace("-", string.Empty) : "0.00" }; } receiptsList.Add(ReceiptDetails(dr, pFilter)); } } catch (Exception ex) { } finally { bdContext.FecharConexao(); if (receiptsList.Count == 0) { Payments = new Payments { TotalCredit = "0.00", TotalDebit = "0.00", }; } else { for (int i = 0; i < receiptsList.Count; i++) { receiptsList[i].PaymentMethod = SetReceiptPaymentMethods(receiptsList[i], pFilter.DateFrom, pFilter.DateUntil); receiptsList[i].Line = SetPaymentLines(receiptsList[i], pFilter);//.ToArray(); } } Payments.Payment = receiptsList;//.ToArray(); } return(Payments); }
private AuditFileBilling GetSaftBillingAuditFile(SaftDTO saft) { AuditFileBilling dto; try { dto = new AuditFileBilling() { Header = daoAuditFile.GetHeaderInfo(saft), MasterFiles = new MasterFiles/// MasterFilesBilling { Customer = daoAuditFile.GetCustomersList(saft), Product = daoAuditFile.GetProductList(saft), TaxTable = new TaxTable { TaxTableEntry = daoAuditFile.GetTaxTableEntriesList(saft) }, }, SourceDocuments = new SourceDocuments //SourceDocumentsBilling { SalesInvoices = daoBillingAuditFile.GetBillingDocuments(saft), WorkingDocuments = daoBillingAuditFile.GetWorkingDocuments(saft), Payments = daoBillingAuditFile.GetPayment(saft) }, }; }catch (Exception ex) { dto = new AuditFileBilling(); string erro = ex.Message; } return(dto); }
public SaftDTO Validar(SaftDTO dto) { try { bdContext.ComandText = "stp_SYS_SAFT_EXPORTACAO_VALIDAR"; bdContext.AddParameter("@SAFT_ID", dto.SaftID); bdContext.AddParameter("@BEGIN_DATE", dto.DateFrom); bdContext.AddParameter("@END_DATE", dto.DateUntil); bdContext.AddParameter("@FILE_TYPE", dto.FileType); bdContext.AddParameter("@SAFT_STATUS", dto.Status); bdContext.AddParameter("@NOTES", dto.Notes); bdContext.AddParameter("@UTILIZADOR", dto.Utilizador); bdContext.AddParameter("@COMPANY_ID", dto.Filial); bdContext.AddParameter("@FISCAL_YEAR", dto.FiscalYear); bdContext.ExecuteNonQuery(); } catch (Exception ex) { dto.MensagemErro = ex.Message.Replace("'", ""); } finally { bdContext.FecharConexao(); } return(dto); }
private static Payment ReceiptDetails(MySqlDataReader dr, SaftDTO pFilter) { var payment = new Payment { PaymentRefNo = dr[3].ToString(), Period = dr[4].ToString(), TransactionID = pFilter.FileType == "F" ? null : dr[5].ToString(), TransactionDate = DateTime.Parse(dr[6].ToString()).ToString("yyyy-MM-dd"), PaymentType = dr[7].ToString().Replace("RE", "RC"), Description = dr[8].ToString(), SystemID = dr[9].ToString(), DocumentStatus = new PaymentsDocumentStatus { PaymentStatus = dr[10].ToString(), PaymentStatusDate = DateTime.Parse(dr[11].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), Reason = dr[12].ToString(), SourceID = dr[13].ToString(), SourcePayment = dr[14].ToString() }, DocumentTotals = new PaymentsDocumentTotals { TaxPayable = dr[15].ToString().Replace(",", ".").Replace("-", string.Empty), NetTotal = dr[16].ToString().Replace(",", ".").Replace("-", string.Empty), GrossTotal = dr[17].ToString().Replace(",", ".").Replace("-", string.Empty), Settlement = new PaymentsDocumentTotalsSettlement { SettlementAmount = dr[18].ToString().Replace(",", ".").Replace("-", string.Empty) }, }, /*WithholdingTax = null new WithholdingTax * { * WithholdingTaxType = "II", * WithholdingTaxDescription = "N/A", * WithholdingTaxAmount = "0.00" * },*/ PaymentID = int.Parse(dr[22].ToString()), SourceID = dr[23].ToString(), SystemEntryDate = DateTime.Parse(dr[24].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), CustomerID = dr[25].ToString() }; if (dr[19].ToString() != "AOA") { payment.DocumentTotals.Currency = new Currency { CurrencyCode = dr[19].ToString(), CurrencyAmount = dr[20].ToString().Replace(",", ".").Replace("-", string.Empty), ExchageRate = dr[21].ToString().Replace(",", ".").Replace("-", string.Empty) }; } return(payment); }
public SalesInvoices GetBillingDocuments(SaftDTO pFilter) { SalesInvoices salesInvoicesResume = new SalesInvoices(); try { bdContext.ComandText = "stp_SAFT_SALES_INVOICES_TOTAL_ENTRIES_DEBITS_CREDITS"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); if (dr.Read()) { salesInvoicesResume = new SalesInvoices { NumberOfEntries = dr[0].ToString(), TotalDebit = dr[1].ToString() != "" ? dr[1].ToString().Replace(",", ".").Replace("-", string.Empty) : "0.00", TotalCredit = dr[2].ToString() != "" ? dr[2].ToString().Replace(",", ".").Replace("-", string.Empty) : "0.00" }; } } catch (Exception ex) { } finally { bdContext.FecharConexao(); } salesInvoicesResume.Invoice = GetSalesInvoiceList(pFilter); if (salesInvoicesResume.Invoice.Count == 0) { salesInvoicesResume = new SalesInvoices { NumberOfEntries = "0", TotalDebit = "0.00", TotalCredit = "0.00" }; } return(salesInvoicesResume); }
public List <SaftDTO> ObterPorFiltro(SaftDTO dto) { List <SaftDTO> lista = new List <SaftDTO>(); try { bdContext.ComandText = "stp_SYS_SAFT_EXPORTACAO_OBTERPORFILTRO"; bdContext.AddParameter("@SAFT_ID", dto.SaftID); bdContext.AddParameter("@BEGIN_DATE", dto.DateFrom); bdContext.AddParameter("@END_DATE", dto.DateUntil); bdContext.AddParameter("@COMPANY_ID", dto.Filial); bdContext.AddParameter("@FILE_TYPE", dto.FileType); bdContext.AddParameter("@SAFT_STATUS", dto.Status); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { dto = new SaftDTO { SaftID = int.Parse(dr[0].ToString()), DateFrom = DateTime.Parse(dr[1].ToString()), DateUntil = DateTime.Parse(dr[2].ToString()), FileType = dr[3].ToString().ToUpper(), Status = int.Parse(dr[4].ToString()), Notes = dr[5].ToString(), CreatedBy = dr[6].ToString(), CreatedDate = DateTime.Parse(dr[7].ToString()), UpdatedBy = dr[8].ToString(), UpdatedDate = DateTime.Parse(dr[9].ToString()), Filial = dr[10].ToString(), FiscalYear = int.Parse(dr[11].ToString()), }; lista.Add(dto); } } catch (Exception ex) { dto.MensagemErro = ex.Message.Replace("'", ""); } finally { bdContext.FecharConexao(); } return(lista); }
private List <PaymentsLines> SetPaymentLines(Payment dto, SaftDTO pSaft) { List <PaymentsLines> lista = new List <PaymentsLines>(); try { bdContext.ComandText = "stp_SAFT_RECEIPTS_LINES"; bdContext.AddParameter("@PAYMENT_ID", dto.PaymentID); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { lista.Add(new PaymentsLines { LineNumber = dr[0].ToString(), SourceDocumentID = new SourceDocumentID { OriginatingON = dr[1].ToString(), InvoiceDate = DateTime.Parse(dr[2].ToString()).ToString("yyyy-MM-dd"), //Description = dr[3].ToString(), }, SettlementAmount = dr[4].ToString().Replace(",", ""), DebitAmount = pSaft.FileType == "F" ? null : dr[5].ToString().Replace(",", ""), CreditAmount = dr[6].ToString().Replace(",", ""), Tax = new Tax { TaxType = dr[7].ToString(), TaxCountryRegion = dr[8].ToString(), TaxCode = dr[9].ToString(), TaxPercentage = dr[10].ToString().Replace(",", "."), TaxAmount = null, // dr[11].ToString().Replace(",", ".") }, TaxExemptionReason = dr[12].ToString(), TaxExemptionCode = dr[13].ToString(), }); } } catch (Exception ex) { string ErroText = ex.Message; } finally { bdContext.FecharConexao(); } return(lista); }
public WorkingDocuments GetWorkingDocuments(SaftDTO pFilter) { WorkingDocuments workingDocuments = new WorkingDocuments(); try { bdContext.ComandText = "stp_SAFT_WORKING_DOCUMENTS_TOTAL_ENTRIES_DEBITS_CREDITS"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); if (dr.Read()) { workingDocuments = new WorkingDocuments { NumberOfEntries = dr[0].ToString(), TotalDebit = dr[1].ToString().Replace(",", ".").Replace("-", string.Empty), TotalCredit = dr[2].ToString().Replace(",", ".").Replace("-", string.Empty) }; } } catch (Exception ex) { } finally { bdContext.FecharConexao(); workingDocuments.WorkDocument = GetWorkDocumentList(pFilter); if (workingDocuments.NumberOfEntries == null && workingDocuments.WorkDocument.Length == 0) { workingDocuments = new WorkingDocuments { NumberOfEntries = "0", TotalDebit = "0.00", //dr[1].ToString().Replace(",", ".").Replace("-", string.Empty), TotalCredit = "0.00" //dr[2].ToString().Replace(",", ".").Replace("-", string.Empty) }; } } return(workingDocuments); }
public AuditFile AuditeFile(SaftDTO dto) { HashRN hashRN = new HashRN(); if (dto.FileType == "F") { var BillingAuditFile = GetSaftBillingAuditFile(dto); hashRN.GenerateInvoicesHash(BillingAuditFile, dto.PrivateKey); hashRN.GenerateWorkingDocumentsHash(BillingAuditFile, dto.PrivateKey); return(BillingAuditFile); } else { return(new AuditFile()); } }
public List <TaxTableEntry> GetTaxTableEntriesList(SaftDTO pFilter) { List <TaxTableEntry> lista = new List <TaxTableEntry>(); try { bdContext.ComandText = "stp_SAFT_TAX_TABLE_ENTRY"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { var tax = new TaxTableEntry { TaxType = dr[0].ToString(), TaxCountryRegion = dr[1].ToString(), TaxCode = dr[2].ToString(), Description = dr[3].ToString(), TaxExpirationDate = null, // dr[4].ToString(), TaxPercentage = dr[5].ToString().Replace(",", "."), TaxAmount = null // dr[6].ToString().Replace(",", ".") }; lista.Add(tax); } } catch (Exception ex) { } finally { bdContext.FecharConexao(); } return(lista); }
public List <Product> GetProductList(SaftDTO pFilter) { List <Product> lista = new List <Product>(); try { bdContext.ComandText = "stp_SAFT_PRODUCTS"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { var product = new Product { ProductType = dr[0].ToString(), ProductCode = dr[1].ToString(), ProductGroup = dr[2].ToString(), ProductDescription = dr[3].ToString(), ProductNumberCode = dr[4].ToString(), CustomsDetails = null,//dr[5].ToString(), //UNNumber = null,//dr[6].ToString() }; lista.Add(product); } } catch (Exception ex) { } finally { bdContext.FecharConexao(); } return(lista); }
public List <SaftDTO> ObterPorFiltro(SaftDTO dto) { return(daoSaft.ObterPorFiltro(dto)); }
private List <CustomerInvoice> GetSalesInvoiceList(SaftDTO pFilter) { List <CustomerInvoice> lista = new List <CustomerInvoice>(); try { bdContext.ComandText = "stp_SAFT_SALES_INVOICES"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { var invoice = new CustomerInvoice { InvoiceNo = dr[0].ToString(), DocumentStatus = new DocumentStatus { InvoiceStatus = dr[1].ToString(), InvoiceStatusDate = DateTime.Parse(dr[2].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), //Reason = dr[3].ToString(), SourceID = dr[4].ToString(), SourceBilling = dr[5].ToString() }, Hash = dr[6].ToString(), HashControl = dr[7].ToString(), Period = dr[8].ToString(), InvoiceDate = DateTime.Parse(dr[9].ToString()).ToString("yyyy-MM-dd"), InvoiceType = dr[10].ToString(), SpecialRegimes = new SpecialRegimes { SelfBillingIndicator = dr[11].ToString(), CashVATSchemeIndicator = dr[12].ToString(), ThirdPartiesBillingIndicator = dr[13].ToString() }, SourceID = dr[14].ToString(), EACCode = dr[15].ToString() == "" ? "000" : dr[15].ToString(), SystemEntryDate = DateTime.Parse(dr[16].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), TransactionID = pFilter.FileType == "F" ? null : dr[17].ToString(), CustomerID = dr[18].ToString(), ShipTo = null /* new ShipTo * { * DeliveryID = dr[19].ToString(), * DeliveryDate = DateTime.Parse(dr[20].ToString() == "" ? dr[16].ToString() : dr[20].ToString()).ToString("yyyy-MM-dd"), * WarehouseID = dr[21].ToString(), * LocationID = dr[22].ToString(), * Address = new Address * { * BuildingNumber = dr[23].ToString(), * StreetName = dr[24].ToString(), * AddressDetail = dr[25].ToString() == "" ? "N/A" : dr[25].ToString(), * City = dr[26].ToString(), * PostalCode = dr[27].ToString(), * Province = dr[28].ToString(), * Country = dr[29].ToString() * } * }*/, ShipFrom = null /*new ShipFrom * { * DeliveryID = dr[30].ToString(), * DeliveryDate = DateTime.Parse(dr[31].ToString() == "" ? dr[16].ToString() : dr[31].ToString()).ToString("yyyy-MM-dd"), * WarehouseID = dr[32].ToString(), * LocationID = dr[33].ToString(), * Address = new Address * { * BuildingNumber = dr[34].ToString(), * StreetName = dr[35].ToString(), * AddressDetail = dr[36].ToString() == "" ? "N/A" : dr[36].ToString(), * City = dr[37].ToString(), * PostalCode = dr[38].ToString(), * Province = dr[39].ToString(), * Country = dr[40].ToString() * } * }*/, MovementEndTime = DateTime.Parse(dr[41].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), MovementStartTime = DateTime.Parse(dr[42].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), InvoiceID = int.Parse(dr[43].ToString()), DocumentTotals = new CustomerInvoiceDocumentTotals { TaxPayable = dr[44].ToString().Replace(",", ".").Replace("-", string.Empty).Replace("-", string.Empty), NetTotal = dr[45].ToString().Replace(",", ".").Replace("-", string.Empty).Replace("-", string.Empty), GrossTotal = dr[46].ToString().Replace(",", ".").Replace("-", string.Empty).Replace("-", string.Empty), Settlement = new Settlement { SettlementDiscount = "0", SettlementAmount = "0", SettlementDate = null,// DateTime.MinValue.ToString("yyyy-MM-dd"), PaymentTerms = "" }, }, WithholdingTax = null /*new WithholdingTax * { * WithholdingTaxType = "IS", * WithholdingTaxDescription = "", * WithholdingTaxAmount = "0", * }*/, }; if (dr[47].ToString() != "AOA") { invoice.DocumentTotals.Currency = new Currency { CurrencyCode = dr[47].ToString(), CurrencyAmount = dr[48].ToString().Replace(",", ".").Replace("-", string.Empty).Replace("-", string.Empty), ExchageRate = dr[49].ToString() == "" || dr[49].ToString() == "0" ? "1" : dr[49].ToString().Replace(",", ".").Replace("-", string.Empty).Replace("-", string.Empty) }; } if (dr[61].ToString() != "0,00") { string WithholdingType = "IS"; if (dr[62].ToString() == "6,50000") { WithholdingType = "II"; } else if (dr[62].ToString() == "10,50000") { WithholdingType = "IRT"; } invoice.WithholdingTax = new WithholdingTax { WithholdingTaxType = WithholdingType, WithholdingTaxDescription = dr[62].ToString(), WithholdingTaxAmount = dr[61].ToString().Replace(",", "."), }; } lista.Add(invoice); } } catch (Exception ex) { string erroEx = ex.Message; } finally { bdContext.FecharConexao(); for (int i = 0; i < lista.Count; i++) { var Line = GetCustomesInvoiceLines(lista[i]); lista[i].Line = Line; /* * var taxBase = Line.Sum(t => decimal.Parse(t.TaxBase.Replace(".", ","))); * * decimal TotalNet = decimal.Parse(lista[i].DocumentTotals.NetTotal.Replace(".", ",")), TotalGross = decimal.Parse(lista[i].DocumentTotals.GrossTotal.Replace(".", ",")), * TotalTax = decimal.Parse(lista[i].DocumentTotals.TaxPayable.Replace(".", ",")); * TotalGross -= TotalTax; * * if ( taxBase == 0) * { * * * lista[i].DocumentTotals = new CustomerInvoiceDocumentTotals * { * TaxPayable = taxBase.ToString(), * NetTotal = TotalNet.ToString().Replace(",", "."), * GrossTotal = TotalGross.ToString().Replace(",", "."), * }; * }*/ lista[i].DocumentTotals.Payment = GetSalesInvoicePaymentMethods(lista[i]).ToArray(); } } return(lista); }
public List <Customer> GetCustomersList(SaftDTO pFilter) { List <Customer> lista = new List <Customer>(); try { bdContext.ComandText = "stp_SAFT_CUSTOMERS"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { var customer = new Customer { CustomerID = dr[0].ToString(), AccountID = dr[1].ToString(), CustomerTaxID = dr[2].ToString(), CompanyName = dr[3].ToString(), Contact = dr[4].ToString() == "" ? null : dr[4].ToString(), BillingAddress = new BillingAddress { BuildingNumber = dr[5].ToString() == "" ? null : dr[5].ToString(), StreetName = dr[6].ToString() == "" ? null : dr[6].ToString(), AddressDetail = dr[7].ToString() == "" ? "Desconhecido" : dr[7].ToString(), City = dr[8].ToString() == "" ? "Desconhecido" : dr[8].ToString(), PostalCode = dr[9].ToString() == "" ? null : dr[9].ToString(), Province = dr[10].ToString() == "" ? null : dr[10].ToString(), Country = dr[11].ToString() }, ShipToAddress = new ShipToAddress { //BuildingNumber = dr[5].ToString() == "" ? "0" : dr[5].ToString(), //StreetName = dr[6].ToString(), AddressDetail = dr[7].ToString() == "" ? dr[6].ToString() : dr[7].ToString(), City = dr[8].ToString() == "" ? "Desconhecido" : dr[8].ToString(), //PostalCode = dr[9].ToString() == "" ? "0" : dr[9].ToString(), //Province = dr[10].ToString(), Country = dr[11].ToString() }, Telephone = dr[12].ToString(), Fax = dr[13].ToString(), Email = dr[14].ToString(), Website = dr[15].ToString(), SelfBillingIndicator = dr[16].ToString() }; lista.Add(customer); } } catch (Exception ex) { } finally { bdContext.FecharConexao(); } return(lista); }
public SaftDTO ObterPorPK(SaftDTO dto) { return(ObterPorFiltro(dto).SingleOrDefault()); }
private WorkDocument[] GetWorkDocumentList(SaftDTO pFilter) { List <WorkDocument> lista = new List <WorkDocument>(); try { bdContext.ComandText = "stp_SAFT_WORKING_DOCUMENTS"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@TRANSACTION_ID", pFilter.SaftID); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); while (dr.Read()) { var workDocument = new WorkDocument { DocumentNumber = dr[0].ToString(), DocumentStatus = new WorkingDocumentStatus { WorkStatus = dr[1].ToString(), WorkStatusDate = DateTime.Parse(dr[2].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), //Reason = dr[3].ToString(), SourceID = dr[4].ToString(), SourceBilling = dr[5].ToString() }, Hash = dr[6].ToString(), HashControl = dr[7].ToString(), Period = dr[8].ToString(), WorkDate = DateTime.Parse(dr[9].ToString()).ToString("yyyy-MM-dd"), WorkType = dr[10].ToString().Replace("FP", "PP").Replace("NP", "PP").Replace("ORT", "OR").Replace("EC", "NE").Replace("ECL", "NE"), SourceID = dr[11].ToString(), EACCode = null,//dr[12].ToString(), SystemEntryDate = DateTime.Parse(dr[13].ToString()).ToString("yyyy-MM-ddTHH:mm:ss"), TransactionID = pFilter.FileType == "F" ? null : dr[14].ToString(), CustomerID = dr[15].ToString(), WorkID = int.Parse(dr[16].ToString()), DocumentTotals = new WorkingDocumentsTotals { TaxPayable = dr[17].ToString().Replace(",", ".").Replace("-", string.Empty), NetTotal = dr[18].ToString().Replace(",", ".").Replace("-", string.Empty), GrossTotal = dr[19].ToString().Replace(",", ".").Replace("-", string.Empty), Currency = new Currency { CurrencyCode = dr[20].ToString(), CurrencyAmount = Math.Round(decimal.Parse(dr[21].ToString()), 2).ToString().Replace(",", ".").Replace("-", string.Empty), ExchageRate = dr[22].ToString().Replace(",", ".").Replace("-", string.Empty) }, }, }; if (dr[20].ToString() == "AOA") { workDocument.DocumentTotals.Currency = null; } lista.Add(workDocument); } } catch (Exception ex) { } finally { bdContext.FecharConexao(); for (int i = 0; i < lista.Count; i++) { lista[i].Line = GetWorkDocumentListLines(lista[i]);//.ToArray(); } } return(lista.ToArray()); }
public void Gravar(SaftDTO dto) { daoSaft.Adicionar(dto); }
public void Validar(SaftDTO dto) { daoSaft.Validar(dto); }
public Header GetHeaderInfo(SaftDTO pFilter) { Header header = new Header(); try { bdContext.ComandText = "stp_SAFT_HEADER"; bdContext.AddParameter("@COMPANY_ID", pFilter.Filial); bdContext.AddParameter("@FILE_TYPE", pFilter.FileType); bdContext.AddParameter("@DATE_INI", pFilter.DateFrom); bdContext.AddParameter("@DATE_TERM", pFilter.DateUntil); bdContext.AddParameter("@FISCAL_YEAR", pFilter.FiscalYear); MySqlDataReader dr = bdContext.ExecuteReader(); if (dr.Read()) { header.AuditFileVersion = dr[1].ToString(); header.CompanyID = dr[2].ToString(); header.TaxRegistrationNumber = dr[3].ToString(); header.TaxAccountingBasis = dr[4].ToString(); header.CompanyName = dr[5].ToString(); header.BusinessName = dr[6].ToString(); header.CompanyAddress = new CompanyAddress { BuildingNumber = dr[7].ToString() == "" ? null : dr[7].ToString(), StreetName = dr[8].ToString() == "" ? null : dr[8].ToString(), AddressDetail = dr[9].ToString(), City = dr[10].ToString(), PostalCode = dr[11].ToString() == "" ? null : dr[11].ToString(), Province = dr[12].ToString() == "" ? null : dr[12].ToString(), Country = dr[13].ToString() }; header.FiscalYear = dr[14].ToString(); header.StartDate = DateTime.Parse(dr[15].ToString()).ToString("yyyy-MM-dd"); header.EndDate = DateTime.Parse(dr[16].ToString()).ToString("yyyy-MM-dd"); header.CurrencyCode = dr[17].ToString(); header.DateCreated = DateTime.Parse(dr[18].ToString()).ToString("yyyy-MM-dd"); header.TaxEntity = dr[19].ToString(); header.ProductCompanyTaxID = dr[20].ToString(); header.SoftwareValidationNumber = "143/AGT/2019"; //dr[21].ToString()== "" ? "143/AGT/2019" : dr[21].ToString(); header.ProductID = "KitandaSoft GE/GC LUCAN - PRESTACAO DE SERVICOS (SU), LDA"; //dr[22].ToString() == "" ? "KITANDASOFT GE" : dr[22].ToString(); header.ProductVersion = dr[23].ToString(); header.HeaderComment = dr[24].ToString(); header.Telephone = dr[25].ToString(); header.Fax = dr[26].ToString(); header.Email = dr[27].ToString(); header.Website = dr[28].ToString(); } } catch (Exception ex) { //header.MensagemErro = ex.Message.Replace("'", ""); } finally { bdContext.FecharConexao(); } return(header); }