private void Delete() { if (_IDCONTACORRENTE == -1) { MessageBox.Show(ConfigMessage.Default.MsgSelecRegistro); tabControlMarca.SelectTab(1); } else { DialogResult dr = MessageBox.Show(ConfigMessage.Default.MsgDelete, ConfigSistema1.Default.NameSytem, MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { try { CONTACORRENTEP.Delete(_IDCONTACORRENTE); Util.ExibirMSg(ConfigMessage.Default.MsgDelete2, "Blue"); Entity = null; GetAllConta(); } catch (Exception) { MessageBox.Show(ConfigMessage.Default.MsgDeleteErro); } } } }
private static CONTACORRENTEEntity FillEntityObject(ref FbDataReader DataReader) { CONTACORRENTEEntity entity = new CONTACORRENTEEntity(); FirebirdGetDbData getData = new FirebirdGetDbData(); entity.IDCONTACORRENTE = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDCONTACORRENTE")); entity.IDBANCO = getData.ConvertDBValueToInt32Nullable(DataReader, DataReader.GetOrdinal("IDBANCO")); entity.AGENCIA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("AGENCIA")); entity.CONTACORRENTE = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONTACORRENTE")); entity.OBSERVACAO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO")); entity.NOMECONTA = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOMECONTA")); entity.SALDO = getData.ConvertDBValueToDecimalNullable(DataReader, DataReader.GetOrdinal("SALDO")); return(entity); }
private void DataGriewDados_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (LIS_CONTACORRENTEColl.Count > 0) { int rowindex = e.RowIndex; if (rowindex != -1) { int CodigoSelect = Convert.ToInt32(LIS_CONTACORRENTEColl[rowindex].IDCONTACORRENTE); Entity = CONTACORRENTEP.Read(CodigoSelect); //Salva o saldo CONTACORRENTEP.Save(Entity); tabControlMarca.SelectTab(0); txtNomeContaCorrente.Focus(); } } }
private void DataGriewDados_KeyDown(object sender, KeyEventArgs e) { if (LIS_CONTACORRENTEColl.Count > 0) { //Obter a linha da célula selecionada DataGridViewRow linhaAtual = DataGriewDados.CurrentRow; //Exibir o índice da linha atual int indice = linhaAtual.Index; int CodigoSelect = Convert.ToInt32(LIS_CONTACORRENTEColl[indice].IDCONTACORRENTE); if (e.KeyCode == Keys.Enter) { Entity = CONTACORRENTEP.Read(CodigoSelect); tabControlMarca.SelectTab(0); txtNomeContaCorrente.Focus(); } else if (e.KeyCode == Keys.Delete) { DialogResult dr = MessageBox.Show(ConfigMessage.Default.MsgDelete, ConfigSistema1.Default.NameSytem, MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { try { CONTACORRENTEP.Delete(CodigoSelect); Util.ExibirMSg(ConfigMessage.Default.MsgDelete2, "Blue"); GetAllConta(); } catch (Exception) { MessageBox.Show(ConfigMessage.Default.MsgDeleteErro); } } } } }
private void GetDropContaCorrente() { CONTACORRENTEProvider CONTACORRENTEP = new CONTACORRENTEProvider(); CONTACORRENTECollection CONTACORRENTEColl = new CONTACORRENTECollection(); CONTACORRENTEColl = CONTACORRENTEP.ReadCollectionByParameter(null, "NOMECONTA"); cbContaCorrente.DisplayMember = "NOMECONTA"; cbContaCorrente.ValueMember = "IDCONTACORRENTE"; CONTACORRENTEEntity CONTACORRENTETy = new CONTACORRENTEEntity(); CONTACORRENTETy.NOMECONTA = ConfigMessage.Default.MsgDrop; CONTACORRENTETy.IDCONTACORRENTE = -1; CONTACORRENTEColl.Add(CONTACORRENTETy); Phydeaux.Utilities.DynamicComparer <CONTACORRENTEEntity> comparer = new Phydeaux.Utilities.DynamicComparer <CONTACORRENTEEntity>(cbContaCorrente.DisplayMember); CONTACORRENTEColl.Sort(comparer.Comparer); cbContaCorrente.DataSource = CONTACORRENTEColl; cbContaCorrente.SelectedIndex = 0; }
private void SalvaSaldo() { try { CONTACORRENTEProvider CONTACORRENTEP = new CONTACORRENTEProvider(); CONTACORRENTEEntity CONTACORRENTETy = new CONTACORRENTEEntity(); CONTACORRENTETy = CONTACORRENTEP.Read(Convert.ToInt32(cbContaCorrente.SelectedValue)); //decimal VALOR = Convert.ToInt32(cbCrediDebito.SelectedValue) == 2 ? (Convert.ToDecimal(txtValor.Text) * -1) : Convert.ToDecimal(txtValor.Text); //if (Tipo == 0) //0 Soma // 1 Subtrai // CONTACORRENTETy.SALDO = CONTACORRENTETy.SALDO + Convert.ToDecimal(VALOR); //else if (Tipo == 1) // CONTACORRENTETy.SALDO = CONTACORRENTETy.SALDO - Convert.ToDecimal(VALOR); CONTACORRENTETy.SALDO = SaldoExtrato(); CONTACORRENTEP.Save(CONTACORRENTETy); } catch (Exception ex) { MessageBox.Show("Erro técnico: " + ex.Message); } }
private void TSBNovo_Click(object sender, EventArgs e) { Entity = null; tabControlMarca.SelectTab(0); txtNomeContaCorrente.Focus(); }
private void novoToolStripMenuItem_Click(object sender, EventArgs e) { Entity = null; tabControlMarca.SelectTab(0); txtNomeContaCorrente.Focus(); }
public CONTACORRENTEEntity Read(int IDCONTACORRENTE) { 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_CONTACORRENTE", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Rea_CONTACORRENTE", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; dbCommand.Parameters.AddWithValue("@IDCONTACORRENTE", IDCONTACORRENTE); //PrimaryKey reader = dbCommand.ExecuteReader(); CONTACORRENTEEntity 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(CONTACORRENTEEntity 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_CONTACORRENTE", dbCnn); dbCommand.Transaction = ((FbTransaction)(dbTransaction)); } else { if (dbCnn == null) { dbCnn = ((FbConnection)GetConnectionDB()); } if (dbCnn.State == ConnectionState.Closed) { dbCnn.Open(); } dbCommand = new FbCommand("Sav_CONTACORRENTE", dbCnn); dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted); } dbCommand.CommandType = CommandType.StoredProcedure; if (Entity.IDCONTACORRENTE != -1) { dbCommand.Parameters.AddWithValue("@IDCONTACORRENTE", Entity.IDCONTACORRENTE); //PrimaryKey } else { dbCommand.Parameters.AddWithValue("@IDCONTACORRENTE", DBNull.Value); //PrimaryKey } dbCommand.Parameters.AddWithValue("@IDBANCO", Entity.IDBANCO); //Coluna dbCommand.Parameters.AddWithValue("@AGENCIA", Entity.AGENCIA); //Coluna dbCommand.Parameters.AddWithValue("@CONTACORRENTE", Entity.CONTACORRENTE); //Coluna dbCommand.Parameters.AddWithValue("@OBSERVACAO", Entity.OBSERVACAO); //Coluna dbCommand.Parameters.AddWithValue("@NOMECONTA", Entity.NOMECONTA); //Coluna dbCommand.Parameters.AddWithValue("@SALDO", Entity.SALDO); //Coluna //Retorno da Procedure FbParameter returnValue; returnValue = dbCommand.CreateParameter(); dbCommand.Parameters["@IDCONTACORRENTE"].Direction = ParameterDirection.InputOutput; //Executando consulta dbCommand.ExecuteNonQuery(); result = int.Parse(dbCommand.Parameters["@IDCONTACORRENTE"].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); }