private void btnEliminar_Click(object sender, EventArgs e) { int rowLine = gridTaxs.GetSelectedRows()[0]; if (cmbTaxType.SelectedIndex == 0) { TaxCode tax = taxas[rowLine]; if (tax.flagPrincipal) { MessageBox.Show("Esta taxa não pode ser eliminada..!"); } else { _taxController.deleteFoId(tax.Id); updateGrid(); } } else { TaxReasonExemption ISE = motivos[rowLine]; if (ISE.flagPrincipal) { MessageBox.Show("Esta taxa não pode ser eliminada..!"); } else { _taxISEController.deleteFoId(ISE.Id); updateGrid(); } } }
private void gridTaxs_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { int rowLine = e.RowHandle; decimal taxa = 0; if (e.Column.Name == "ClTaxaNor") { taxa = decimal.Parse(e.Value.ToString()); } if (e.Value.ToString() == string.Empty) { updateGrid(); } else { if (cmbTaxType.SelectedIndex == 0) { TaxCode tax = taxas[rowLine]; if (tax.flagPrincipal) { MessageBox.Show("Esta taxa não pode ser Alterada..!"); updateGrid(); } else { if (taxa > 0) { //_taxController.update(tax); _tiposTaxa.update(_tiposTaxa.getOne(1)); } else { MessageBox.Show("O valor da taxa não pode ser 0..!"); } } } else { TaxReasonExemption ISE = motivos[rowLine]; if (ISE.flagPrincipal) { if (e.Column.Name == "CLCodigoISE") { MessageBox.Show("Não pode alterar o codigo das Isentas principais.!"); } else { // _taxISEController.update(ISE); _tiposTaxa.update(_tiposTaxa.getOne(2)); } } else { _tiposTaxa.update(_tiposTaxa.getOne(2)); } } } }
public int update(TaxReasonExemption taxReasonExemption) { return(_taxRepository.update(taxReasonExemption)); }
public int delete(TaxReasonExemption taxReasonExemption) { return(_taxRepository.remove(taxReasonExemption)); }
public int insert(TaxReasonExemption taxReasonExemption) { return(_taxRepository.insert(taxReasonExemption)); }
private void simpleButton2_Click(object sender, EventArgs e) { if (txtCode.Text != string.Empty && txtDescricao.Text != string.Empty) { if (cmbTaxType.SelectedIndex == 0) { if (decimal.Parse(txtTax.Text) >= 1) { TaxCodeController _taxController = new TaxCodeController(); TaxCode taxcode = new TaxCode() { Code = txtCode.Text.Trim(), Taxa = decimal.Parse(txtTax.Text), Descricao = txtDescricao.Text.Trim(), flagPrincipal = false, }; bool taxaExiste = false; foreach (var item in _taxController.ListALL()) { taxaExiste = item.Taxa == taxcode.Taxa; if (taxaExiste) { break; } } if (taxaExiste) { MessageBox.Show("Já Exixte a percentagem de taxa de (" + taxcode.Taxa + "%) !\nDigite uma nova taxa para cadastrar..!"); } else { _taxController.insert(taxcode); _tiposTaxa = new TaxTypeController(); updateGrid(); } } else { MessageBox.Show("A taxa não pode ser zero..."); } } else { TaxReasonExemptionController _taxController = new TaxReasonExemptionController(); TaxReasonExemption taxReason = new TaxReasonExemption() { Id = txtCode.Text.Trim(), MencaoFatura = txtDescricao.Text.Trim(), flagPrincipal = false, }; bool codigoExiste = false; foreach (var item in _taxController.ListALL()) { codigoExiste = item.Id.Equals(taxReason.Id); if (codigoExiste) { break; } } if (codigoExiste) { MessageBox.Show("Já Exixte este código de isenta..!"); } else { _taxController.insert(taxReason); _tiposTaxa = new TaxTypeController(); updateGrid(); } } } else { MessageBox.Show("Há campos vazio..!"); } }
public AuditFileSourceDocumentsWorkingDocuments getWorkDocuments() { var groupListProductInvoice = _productSalesController.ListALL(). Where(c => c.DataCadastro.Date >= dataInicio.Date && c.DataCadastro.Date <= dataFinal.Date && c.Fatura.TipoDocumento.WorkDocuments).ToList(). GroupBy(c => c.FaturaId).ToList(); AuditFileSourceDocumentsWorkingDocumentsWorkDocument[] listProformas = new AuditFileSourceDocumentsWorkingDocumentsWorkDocument[groupListProductInvoice.Count()]; decimal totalCredit = 0; int i = 0; int j; foreach (var item in groupListProductInvoice) { Invoice iv = item.ToList()[0].Fatura; if (iv.InvoiceStatusId != 3 /*Doc. Anulado*/ && iv.InvoiceStatusId != 5 /*Doc. faturado*/) { totalCredit += iv.TotalIncidencia; } AuditFileSourceDocumentsWorkingDocumentsWorkDocumentLine[] linesInvoice = new AuditFileSourceDocumentsWorkingDocumentsWorkDocumentLine[iv.ProductsSales.Count()]; j = 0; foreach (var lineProduct in iv.ProductsSales) { string imposto = lineProduct.Product.CodigoTaxa.Code; string impostoType = lineProduct.Product.CodigoTaxaId == 3 ? "NS" : "IVA"; TaxReasonExemption taxReason = null; taxReason = lineProduct.Product.MotivoISEId != null ? new TaxReasonExemptionController().getOne(lineProduct.Product.MotivoISEId) : null; linesInvoice[j] = new AuditFileSourceDocumentsWorkingDocumentsWorkDocumentLine() { CreditAmount = lineProduct.TotalIncidencia.ToString("F3").Replace(",", "."), Description = "bom", LineNumber = (j + 1).ToString(), ProductCode = lineProduct.ProductId.ToString(), Quantity = lineProduct.Quantidade.ToString("F3").Replace(",", "."), UnitPrice = lineProduct.Preco.ToString("F3").Replace(",", "."), ProductDescription = lineProduct.Descricao_Produto, UnitOfMeasure = lineProduct.Unidade, TaxPointDate = Convert.ToDateTime(iv.InvoiceDate), Tax = new AuditFileSourceDocumentsWorkingDocumentsWorkDocumentLineTax() { TaxCountryRegion = "AO", TaxType = impostoType, TaxPercentage = lineProduct.Taxa.ToString("F3").Replace(",", "."), TaxCode = imposto, }, TaxExemptionReason = taxReason != null ? taxReason.MencaoFatura : null, TaxExemptionCode = taxReason != null ? taxReason.Id : null, SettlementAmount = lineProduct.ValorDesconto.ToString("F3").Replace(",", "."), // lineProduct.ValorDesconto.ToString("F").Replace(",", "."), }; j++; } listProformas[i] = new AuditFileSourceDocumentsWorkingDocumentsWorkDocument() { CustomerID = iv.Cliente.Nif.Contains("9999999") || iv.Cliente.Nif == string.Empty ? finalCustomer.Id.ToString() : iv.ClienteId.ToString(), DocumentStatus = new AuditFileSourceDocumentsWorkingDocumentsWorkDocumentDocumentStatus() { WorkStatus = iv.InvoiceStatus.Estado, WorkStatusDate = iv.DataCadastro.ToString("yyyy-MM-ddTHH:mm:ss"), Reason = iv.RazaoNota, SourceID = iv.UserId.ToString(), SourceBilling = "P", }, //TransactionID Hash = iv.Hash, WorkDate = Convert.ToDateTime(iv.InvoiceDate), DocumentNumber = iv.InvoiceNo, WorkType = iv.TipoDocumento.Tipo, SourceID = iv.UserId.ToString(), HashControl = "0", SystemEntryDate = Convert.ToDateTime(iv.DataCadastro.ToString(fDateT)), Period = iv.DataCadastro.Month.ToString(), DocumentTotals = new AuditFileSourceDocumentsWorkingDocumentsWorkDocumentDocumentTotals() { TaxPayable = iv.TotalImposto.ToString("F3").Replace(",", "."), NetTotal = iv.TotalIncidencia.ToString("F3").Replace(",", "."), GrossTotal = iv.TotalGeral.ToString("F3").Replace(",", "."), }, Line = linesInvoice, }; i++; } return(new AuditFileSourceDocumentsWorkingDocuments() { TotalCredit = totalCredit.ToString("F3").Replace(",", "."), TotalDebit = "0.00", NumberOfEntries = listProformas.Count().ToString(), WorkDocument = listProformas.Count() > 0 ? listProformas : null, }); }
public AuditFileSourceDocumentsSalesInvoices getSalesInvoices() { var groupListProductInvoice = _productSalesController.ListALL(). Where(c => c.DataCadastro.Date >= dataInicio.Date && c.DataCadastro.Date <= dataFinal.Date && c.Fatura.TipoDocumento.SalesInvoices).ToList(). GroupBy(c => c.FaturaId).ToList(); //AuditFileSourceDocumentsMovementOfGoods[] auditmovmentsOfGood = new AuditFileSourceDocumentsMovementOfGoods[]; AuditFileSourceDocumentsSalesInvoicesInvoice[] listSalesInvoices = new AuditFileSourceDocumentsSalesInvoicesInvoice[groupListProductInvoice.Count()]; decimal totalDebit = 0; decimal totalCredit = 0; int i = 0; foreach (var item in groupListProductInvoice) { Invoice iv = item.ToList()[0].Fatura; bool notaCreditoOuDebito = iv.TipoDocumento.Id == "10" || iv.TipoDocumento.Id == "9"; if (iv.InvoiceStatusId != 3 /*Doc. Anulado*/ && iv.InvoiceStatusId != 5 /*Doc. faturado*/) { if (notaCreditoOuDebito) { totalDebit += iv.TotalIncidencia; } else { totalCredit += iv.TotalIncidencia; } } AuditFileSourceDocumentsSalesInvoicesInvoiceLine[] linesInvoice = new AuditFileSourceDocumentsSalesInvoicesInvoiceLine[iv.ProductsSales.Count()]; int j = 0; foreach (var lineProduct in iv.ProductsSales) { string imposto = lineProduct.Product.CodigoTaxa.Code; string impostoType = lineProduct.Product.CodigoTaxaId == 3 ? "NS" : "IVA"; TaxReasonExemption taxReason = null; taxReason = lineProduct.Product.MotivoISEId != null ? new TaxReasonExemptionController().getOne(lineProduct.Product.MotivoISEId) : null; bool showCreditField = true; AuditFileSourceDocumentsSalesInvoicesInvoiceLineReferences references = null; if (notaCreditoOuDebito) { showCreditField = false; references = new AuditFileSourceDocumentsSalesInvoicesInvoiceLineReferences() { Reference = iv.Referencia, Reason = iv.RazaoNota == string.Empty ? null : iv.RazaoNota, }; } linesInvoice[j] = new AuditFileSourceDocumentsSalesInvoicesInvoiceLine() { CreditAmountSpecified = showCreditField, DebitAmountSpecified = !showCreditField, CreditAmount = lineProduct.TotalIncidencia.ToString("F3").Replace(",", "."), DebitAmount = lineProduct.TotalIncidencia.ToString("F3").Replace(",", "."), Description = "bom", LineNumber = (j + 1).ToString(), ProductCode = lineProduct.ProductId.ToString(), Quantity = lineProduct.Quantidade.ToString("F3").Replace(",", "."), UnitPrice = lineProduct.Preco.ToString("F3").Replace(",", "."), ProductDescription = lineProduct.Descricao_Produto, UnitOfMeasure = lineProduct.Unidade, Tax = new AuditFileSourceDocumentsSalesInvoicesInvoiceLineTax() { TaxCountryRegion = "AO", TaxType = impostoType, TaxPercentage = lineProduct.Taxa.ToString("F3").Replace(",", "."), TaxCode = imposto, }, References = references, TaxExemptionReason = taxReason != null ? taxReason.MencaoFatura : null, TaxExemptionCode = taxReason != null ? taxReason.Id : null, TaxPointDate = Convert.ToDateTime(iv.InvoiceDate), SettlementAmount = /*lineProduct.ValorDesconto.ToString().Replace(",", ".") */ lineProduct.ValorDesconto.ToString("F3").Replace(",", "."), }; j++; } listSalesInvoices[i] = new AuditFileSourceDocumentsSalesInvoicesInvoice() { CustomerID = iv.Cliente.Nif.Contains("9999999") || iv.Cliente.Nif == string.Empty ? finalCustomer.Id.ToString() : iv.ClienteId.ToString(), DocumentStatus = new AuditFileSourceDocumentsSalesInvoicesInvoiceDocumentStatus() { InvoiceStatus = iv.InvoiceStatus.Estado, InvoiceStatusDate = iv.DataCadastro.ToString("yyyy-MM-ddTHH:mm:ss"), SourceID = iv.UserId.ToString(), SourceBilling = "P", }, Hash = iv.Hash, InvoiceDate = iv.InvoiceDate, InvoiceNo = iv.InvoiceNo, InvoiceType = iv.TipoDocumento.Tipo, SourceID = iv.UserId.ToString(), HashControl = systemInfo.SoftwareValidationNumber == "0" ? "0" : "1", SystemEntryDate = iv.DataCadastro.ToString(fDateT), Period = iv.DataCadastro.Month.ToString(), DocumentTotals = new AuditFileSourceDocumentsSalesInvoicesInvoiceDocumentTotals() { TaxPayable = iv.TotalImposto.ToString("F3").Replace(",", "."), NetTotal = iv.TotalIncidencia.ToString("F3").Replace(",", "."), GrossTotal = iv.TotalGeral.ToString("F3").Replace(",", "."), Payment = new AuditFileSourceDocumentsSalesInvoicesInvoiceDocumentTotalsPayment() { PaymentMechanism = iv.FormaPagamento.Id, PaymentAmount = /*iv.TotalGeral.ToString("F").Replace(",", "."), */ iv.ValorPago.ToString("F3").Replace(",", "."), PaymentDate = Convert.ToDateTime(iv.InvoiceDate), }, }, Line = linesInvoice, SpecialRegimes = new AuditFileSourceDocumentsSalesInvoicesInvoiceSpecialRegimes() { CashVATSchemeIndicator = "0", SelfBillingIndicator = "0", ThirdPartiesBillingIndicator = "0" }, /* WithholdingTax = new AuditFileSourceDocumentsSalesInvoicesInvoiceWithholdingTax() * { * WithholdingTaxType = "IRT", * WithholdingTaxDescription = "Aplicação da Retenção", * WithholdingTaxAmount = "0", * }, */ }; i++; } return(new AuditFileSourceDocumentsSalesInvoices() { Invoice = listSalesInvoices.Count() > 0 ? listSalesInvoices : null, TotalCredit = totalCredit.ToString("F3").Replace(",", "."), TotalDebit = totalDebit.ToString("F3").Replace(",", "."), NumberOfEntries = listSalesInvoices.Count().ToString(), }); }