private void button2_Click(object sender, EventArgs e) { if (Validacoes()) { _IDFORMAPAGAMENTO = FORMAPAGAMENTOP.Save(Entity); int Dias = 30; decimal TotalPorc = Convert.ToDecimal("100,00"); for (int i = 0; i < Convert.ToInt32(txtXPrazos.Text); i++) { TxtDias.Text = Convert.ToString(Dias); decimal Porpagto = 100 / Convert.ToDecimal(txtXPrazos.Text); txtPorPagto.Text = Porpagto.ToString("n2"); TotalPorc -= Convert.ToDecimal(txtPorPagto.Text); //Calcula a diferença em Porcentagem de pagamento if (i == Convert.ToInt32(txtXPrazos.Text) - 1) { Porpagto = Porpagto + TotalPorc; txtPorPagto.Text = Porpagto.ToString("n2"); } txtPorcJuros.Text = "0"; _IDITENSFORMAPAGTO = -1; ITENSFORMAPAGTOP.Save(Entity2); Dias += 30; } SalveIMEXAPP(Entity); Entity2 = null; GetItensFormaPagamento(); } }
private void button1_Click(object sender, EventArgs e) { if (ValidacoesFormaPagamento()) { //Grava Forma de pagamento antes de inserir itens if (_IDFORMAPAGAMENTO == -1) { if (Validacoes()) { _IDFORMAPAGAMENTO = FORMAPAGAMENTOP.Save(Entity); } } try { if (_IDFORMAPAGAMENTO != -1) { _IDITENSFORMAPAGTO = ITENSFORMAPAGTOP.Save(Entity2); GetItensFormaPagamento(); Entity2 = null; Util.ExibirMSg(ConfigMessage.Default.MsgSave, "Blue"); } } catch (Exception) { MessageBox.Show(ConfigMessage.Default.MsgSaveErro); } } }
private void TSBNovo_Click(object sender, EventArgs e) { Entity = null; Entity2 = null; GetItensFormaPagamento(); tabControl1.SelectTab(0); txtNome.Focus(); }
private static ITENSFORMAPAGTOEntity FillEntityObject(ref FbDataReader DataReader) { ITENSFORMAPAGTOEntity entity = new ITENSFORMAPAGTOEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDITENSFORMAPAGTO = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDITENSFORMAPAGTO")); entity.IDFORMAPAGAMENTO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDFORMAPAGAMENTO")); entity.DIAS = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("DIAS")); entity.PORCPAGTO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCPAGTO")); entity.PORCJUROS = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("PORCJUROS")); return(entity); }
private void DgItensFormaPagamento_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { int rowindex = e.RowIndex; if (FORMAPAGAMENTOColl.Count > 0 && rowindex > -1) { int ColumnSelecionada = e.ColumnIndex; int CodSelect = -1; if (ColumnSelecionada == 0)//Editar { CodSelect = Convert.ToInt32(ITENSFORMAPAGTOColl[rowindex].IDITENSFORMAPAGTO); Entity2 = ITENSFORMAPAGTOP.Read(CodSelect); } else if (ColumnSelecionada == 1)//Excluir { DialogResult dr = MessageBox.Show(ConfigMessage.Default.MsgDelete, ConfigSistema1.Default.NameSytem, MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { try { CodSelect = Convert.ToInt32(ITENSFORMAPAGTOColl[rowindex].IDITENSFORMAPAGTO); ITENSFORMAPAGTOP.Delete(CodSelect); GetItensFormaPagamento(); Entity2 = null; Util.ExibirMSg(ConfigMessage.Default.MsgDelete2, "Blue"); } catch (Exception) { MessageBox.Show(ConfigMessage.Default.MsgDeleteErro); } } } } }
private void btnCancel_Click(object sender, EventArgs e) { Entity2 = null; }
public ITENSFORMAPAGTOEntity Read(int IDITENSFORMAPAGTO) { 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_ITENSFORMAPAGTO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_ITENSFORMAPAGTO", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@IDITENSFORMAPAGTO", IDITENSFORMAPAGTO); //PrimaryKey reader = dbCommand.ExecuteReader(); ITENSFORMAPAGTOEntity 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(ITENSFORMAPAGTOEntity 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_ITENSFORMAPAGTO", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_ITENSFORMAPAGTO", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; if (Entity.IDITENSFORMAPAGTO != -1) { dbCommand.Parameters.AddWithValue("@IDITENSFORMAPAGTO", Entity.IDITENSFORMAPAGTO); //PrimaryKey } else { dbCommand.Parameters.AddWithValue("@IDITENSFORMAPAGTO", DBNull.Value); //PrimaryKey } dbCommand.Parameters.AddWithValue("@IDFORMAPAGAMENTO", Entity.IDFORMAPAGAMENTO); //Coluna dbCommand.Parameters.AddWithValue("@DIAS", Entity.DIAS); //Coluna dbCommand.Parameters.AddWithValue("@PORCPAGTO", Entity.PORCPAGTO); //Coluna dbCommand.Parameters.AddWithValue("@PORCJUROS", Entity.PORCJUROS); //Coluna //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@IDITENSFORMAPAGTO"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@IDITENSFORMAPAGTO"].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); }