private void SalveIMEXAPP(FORMAPAGAMENTOEntity FORMAPAGAMENTOTy) { try { if (CONFISISTEMATy.FLAGIMEXAPP == "S") { CONDICAOPAGAMENTOIMEXAPPEntity CONDICAOPAGAMENTOIMEXAPPTy = new CONDICAOPAGAMENTOIMEXAPPEntity(); CONDICAOPAGAMENTOIMEXAPPTy.XMEUID = FORMAPAGAMENTOTy.IDFORMAPAGAMENTO.ToString(); CONDICAOPAGAMENTOIMEXAPPTy.XCONDICAOPAGAMENTO = FORMAPAGAMENTOTy.NOME; CONDICAOPAGAMENTOIMEXAPPTy.NPARCELAS = ITENSFORMAPAGTOColl.Count; string formula = string.Empty; foreach (var item in ITENSFORMAPAGTOColl) { formula += item.DIAS + "/"; } formula = formula.Substring(0, formula.Length - 1); CONDICAOPAGAMENTOIMEXAPPTy.XFORMULA = formula; CONDICAOPAGAMENTOIMEXAPPP.Save(CONDICAOPAGAMENTOIMEXAPPTy); } } catch (Exception ex) { MessageBox.Show("Erro Técnico: " + ex.Message); } }
private void GetDropFormaPgto() { try { FORMAPAGAMENTOProvider FORMAPAGAMENTOP = new FORMAPAGAMENTOProvider(); FORMAPAGAMENTOColl = FORMAPAGAMENTOP.ReadCollectionByParameter(null, "NOME"); cbFormaPagto.DisplayMember = "NOME"; cbFormaPagto.ValueMember = "IDFORMAPAGAMENTO"; FORMAPAGAMENTOEntity FORMAPAGAMENTOTy = new FORMAPAGAMENTOEntity(); FORMAPAGAMENTOTy.NOME = ConfigMessage.Default.MsgDrop; FORMAPAGAMENTOTy.IDFORMAPAGAMENTO = -1; FORMAPAGAMENTOColl.Add(FORMAPAGAMENTOTy); Phydeaux.Utilities.DynamicComparer <FORMAPAGAMENTOEntity> comparer = new Phydeaux.Utilities.DynamicComparer <FORMAPAGAMENTOEntity>(cbFormaPagto.DisplayMember); FORMAPAGAMENTOColl.Sort(comparer.Comparer); cbFormaPagto.DataSource = FORMAPAGAMENTOColl; cbFormaPagto.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show("Erro técnico: " + ex.Message); } }
private static FORMAPAGAMENTOEntity FillEntityObject(ref FbDataReader DataReader) { FORMAPAGAMENTOEntity entity = new FORMAPAGAMENTOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO")); entity.NOME = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME")); entity.PORCDESCONTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCDESCONTO")); return(entity); }
public FORMAPAGAMENTOEntity Read(int IDFORMAPAGAMENTO) { FbDataReader reader = null; try { //Verificando a existência de um transação aberta if (dbTransaction != null) { if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_FORMAPAGAMENTO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_FORMAPAGAMENTO", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@IDFORMAPAGAMENTO", IDFORMAPAGAMENTO); //PrimaryKey reader = dbCommand.ExecuteReader(); FORMAPAGAMENTOEntity entity = null; if (reader.HasRows) { while (reader.Read()) { entity = FillEntityObject(ref reader); } } // Deleta reader if (reader != null) { reader.Close(); reader.Dispose(); } // Fecha conexão if (dbTransaction == null) { dbCommand.Transaction.Commit(); if (dbCnn.State == ConnectionState.Open) { dbCnn.Close(); } } return(entity); } catch (Exception ex) { // Deleta reader if (reader != null) { reader.Close(); reader.Dispose(); } if (dbTransaction != null) { this.RollbackTransaction(); } else { if (dbCommand.Transaction != null) { dbCommand.Transaction.Rollback(); } if (dbCnn.State == ConnectionState.Open) { dbCnn.Close(); } } throw ex; } }
public int Save(FORMAPAGAMENTOEntity Entity) { int result = 0; try { //Verificando a existência de um transação aberta if (dbTransaction != null) { if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_FORMAPAGAMENTO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_FORMAPAGAMENTO", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; if (Entity.IDFORMAPAGAMENTO != -1) { dbCommand.Parameters.AddWithValue("@IDFORMAPAGAMENTO", Entity.IDFORMAPAGAMENTO); //PrimaryKey } else { dbCommand.Parameters.AddWithValue("@IDFORMAPAGAMENTO", DBNull.Value); //PrimaryKey } dbCommand.Parameters.AddWithValue("@NOME", Entity.NOME); //Coluna dbCommand.Parameters.AddWithValue("@PORCDESCONTO", Entity.PORCDESCONTO); //Coluna //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@IDFORMAPAGAMENTO"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@IDFORMAPAGAMENTO"].Value.ToString()); if (dbTransaction == null) { dbCommand.Transaction.Commit(); dbCnn.Close(); } } catch (Exception ex) { if (dbTransaction != null) { this.RollbackTransaction(); } else { if (dbCommand.Transaction != null) { dbCommand.Transaction.Rollback(); } if (dbCnn.State == ConnectionState.Open) { dbCnn.Close(); } } throw ex; } return(result); }