public static void AddNewActivity(EtiAplicacao etiApp, EtiConnNetBD conn, Cliente customer) { EventsClass e = null; try { e = new EventsClass(); e.AddNewActivity(etiApp, customer); } catch (Exception ex) { if (Environment.UserInteractive) { var errorDescription = string.Format("{0}.{1}.{2}", MethodBase.GetCurrentMethod().DeclaringType.FullName, MethodBase.GetCurrentMethod().Name, ex.Message); MessageBox.Show(errorDescription); } else { throw ex; } } finally { e = null; } }
public static void GetIsNew(EtiAplicacao etiApp, EtiConnNetBD conn, Cliente customer) { EventsClass e = null; try { e = new EventsClass(); e.GetIsNew(etiApp, customer); Functions.NewActivity(etiApp, "Subject ... ", "Notes...", customer.Codigo, "1", (int)NaturezaAtividade.Tarefa, null); } catch (Exception ex) { if (Environment.UserInteractive) { var errorDescription = string.Format("{0}.{1}.{2}", MethodBase.GetCurrentMethod().DeclaringType.FullName, MethodBase.GetCurrentMethod().Name, ex.Message); MessageBox.Show(errorDescription); } else { throw ex; } } finally { e = null; } }
public static EtiConnNetBD GetConnection(EtiAplicacao eti, string SQLInstance, string login, string password, string database) { EtiConnNetBD conn = new EtiConnNetBD(eti); try { conn.MakeConnectionToServer(SQLInstance, login, password, database, 0); } catch (Exception ex) { throw new Exception(ex.Message); } return(conn); }
public IHttpActionResult GenerateSettlments([FromBody] JObject data) { EtiConnNetBD etiConn = Eti.Aplicacao.ActiveEmpresa.GetConnectionBD(); try { dynamic _data = data; DateTime From = _data.From; if (From <= DateTime.MinValue) { From = (DateTime)SqlDateTime.MinValue; } JArray _paymts = _data.Payments; IEnumerable <SettlementInput> Payments = _paymts.ToObject <List <SettlementInput> >(); //Alterar estado das encomendas que foram selecionadas; foreach (SettlementInput order in Payments.Where(w => w.Pay == true && w.et_DocType == "ORD")) { MovEncomenda objOrder = Eti.Aplicacao.Movimentos.MovEncomendasCli.Find(order.et_Doc, order.et_FiscalYear, order.et_DocNumber, order.et_Section); //inserir no historico de dados Eticadata.ERP.HistEstadoDocumento statusesHistory = objOrder.HistoricoEstados.CreateNew(); statusesHistory.Tabela = 1;//janela de vendas statusesHistory.Login = Eti.Aplicacao.ActiveUser.Login; statusesHistory.Chave1 = objOrder.Cabecalho.CodSeccao; statusesHistory.Chave2 = objOrder.Cabecalho.AbrevTpDoc; statusesHistory.Chave3 = objOrder.Cabecalho.CodExercicio; statusesHistory.Chave4 = objOrder.Cabecalho.Numero.ToString(); statusesHistory.CodEstado = configs.OrderPaidState; statusesHistory.DataEstado = DateTime.Now; objOrder.HistoricoEstados.Add(statusesHistory); //atualizar na venda de forma a aparecer em 1ª lugar objOrder.Cabecalho.EstadoDocum = configs.OrderPaidState; objOrder.Cabecalho.DataEstado = statusesHistory.DataEstado; objOrder.Cabecalho.LoginEstado = statusesHistory.Login; objOrder.Cabecalho.DataAlteracaoEstado = statusesHistory.DataEstado; Eti.Aplicacao.Movimentos.MovEncomendasCli.Update(ref objOrder); if (!string.IsNullOrEmpty(objOrder.EtiErrorCode)) { throw new Exception(objOrder.EtiErrorDescription); } } //Emitir liquidação das faturas que foram pagas; foreach (SettlementInput invoice in Payments.Where(w => w.Pay == true && w.et_DocType == "INV")) { MovLiquidacao objSettlement = Eti.Aplicacao.Movimentos.MovLiquidacoes.GetNew(configs.SettlementDocType, Eti.Aplicacao.ActiveSeccao.Codigo); MovVenda objInvoice = Eti.Aplicacao.Movimentos.MovVendas.Find(invoice.et_Doc, invoice.et_FiscalYear, invoice.et_DocNumber, invoice.et_Section); objSettlement.Cabecalho.CodEntidade = objInvoice.Cabecalho.CodEntidade; objSettlement.AlteraEntidade(objInvoice.Cabecalho.CodEntidade, true); objSettlement.FindDocs(0, 0, 0, 1); var linePend = objSettlement.get_LinhaOfPendente(invoice.et_Section, invoice.et_Doc, invoice.et_FiscalYear, invoice.et_DocNumber); if (linePend.ValorPendente > 0) { var lineSettlement = objSettlement.get_LinhaOfDocumento(linePend.CodSeccaoPend, linePend.AbrevTpDocPend, linePend.CodExercicioPend, linePend.NumeroPend); short IRS = 0; objSettlement.AlteraConfirmacao(lineSettlement.NumLinha, true, ref IRS); objSettlement.AlteraValorAtribuido(lineSettlement.NumLinha, (double)invoice.ep_value, ref IRS); linePend.Confirmacao = 1; int pagLin = 1; objSettlement.LinesPag[pagLin].AbrevTpMovPagTes = configs.SettlementType; var valid = objSettlement.Validate(); if (valid) { Eti.Aplicacao.Movimentos.MovLiquidacoes.Update(ref objSettlement); } if (!string.IsNullOrEmpty(objSettlement.EtiErrorCode) || !valid) { throw new Exception(objSettlement.EtiErrorDescription); } } } DataTable dtPayments = getPendingPayments(etiConn, From); return(Ok(dtPayments)); } catch (Exception ex) { etiConn.RollBackTrans(); return(BadRequest(ex.Message)); } finally { etiConn.Close(); } }