コード例 #1
0
        private static SALAOFESTAEntity FillEntityObject(ref FbDataReader DataReader)
        {
            SALAOFESTAEntity entity = new SALAOFESTAEntity();

            FirebirdGetDbData getData = new FirebirdGetDbData();

            entity.IDSALAOFESTA = getData.ConvertDBValueToInt32(DataReader, DataReader.GetOrdinal("IDSALAOFESTA"));
            entity.NOME         = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("NOME"));
            entity.RAZAOSOCIAL  = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("RAZAOSOCIAL"));
            entity.DTCADASTRO   = getData.ConvertDBValueToDateTimeNullable(DataReader, DataReader.GetOrdinal("DTCADASTRO"));
            entity.TELEFONE1    = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TELEFONE1"));
            entity.TELEFONE2    = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("TELEFONE2"));
            entity.CNPJ         = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CNPJ"));
            entity.IE           = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("IE"));
            entity.ENDERECO     = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("ENDERECO"));
            entity.BAIRRO       = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("BAIRRO"));
            entity.CIDADE       = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CIDADE"));
            entity.UF           = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("UF"));
            entity.CEP          = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CEP"));
            entity.EMAIL        = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EMAIL"));
            entity.OBSERVACAO   = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("OBSERVACAO"));
            entity.CONTATO      = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("CONTATO"));
            entity.EMAILCONTATO = getData.ConvertDBValueToStringNullable(DataReader, DataReader.GetOrdinal("EMAILCONTATO"));


            return(entity);
        }
コード例 #2
0
        private void Delete()
        {
            if (_IDSALAOFESTA == -1)
            {
                MessageBox.Show(ConfigMessage.Default.MsgSelecRegistro);
                tabControlFornecedor.SelectTab(1);
            }
            else
            {
                DialogResult dr = MessageBox.Show(ConfigMessage.Default.MsgDelete,
                                                  ConfigSistema1.Default.NameSytem, MessageBoxButtons.YesNo);

                if (dr == DialogResult.Yes)
                {
                    try
                    {
                        SALAOFESTAP.Delete(_IDSALAOFESTA);
                        Util.ExibirMSg(ConfigMessage.Default.MsgDelete2, "Blue");
                        Entity = null;
                        btnPesquisa_Click(null, null);
                    }
                    catch (Exception)
                    {
                        MessageBox.Show(ConfigMessage.Default.MsgDeleteErro);
                    }
                }
            }
        }
コード例 #3
0
        private void DataGriewDados_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            if (SALAOFESTAColl.Count > 0)
            {
                int rowindex = e.RowIndex;
                if (rowindex != -1)
                {
                    int CodigoSelect = Convert.ToInt32(SALAOFESTAColl[rowindex].IDSALAOFESTA);

                    Entity = SALAOFESTAP.Read(CodigoSelect);

                    tabControlFornecedor.SelectTab(0);
                    txtNome.Focus();
                }
            }
        }
コード例 #4
0
        private void DataGriewDados_KeyDown(object sender, KeyEventArgs e)
        {
            if (SALAOFESTAColl.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(SALAOFESTAColl[indice].IDSALAOFESTA);

                if (e.KeyCode == Keys.Enter)
                {
                    Entity = SALAOFESTAP.Read(CodigoSelect);

                    tabControlFornecedor.SelectTab(0);
                    txtNome.Focus();
                }
                else if (e.KeyCode == Keys.Delete)
                {
                    DialogResult dr = MessageBox.Show(ConfigMessage.Default.MsgDelete,
                                                      ConfigSistema1.Default.NameSytem, MessageBoxButtons.YesNo);

                    if (dr == DialogResult.Yes)
                    {
                        try
                        {
                            SALAOFESTAP.Delete(CodigoSelect);
                            Util.ExibirMSg(ConfigMessage.Default.MsgDelete2, "Blue");
                            btnPesquisa_Click(null, null);
                        }
                        catch (Exception)
                        {
                            MessageBox.Show(ConfigMessage.Default.MsgDeleteErro);
                        }
                    }
                }
            }
        }
コード例 #5
0
 private void TSBNovo_Click(object sender, EventArgs e)
 {
     Entity = null;
     tabControlFornecedor.SelectTab(0);
     txtNome.Focus();
 }
コード例 #6
0
 private void novoToolStripMenuItem_Click(object sender, EventArgs e)
 {
     Entity = null;
     tabControlFornecedor.SelectTab(0);
     txtNome.Focus();
 }
コード例 #7
0
        public SALAOFESTAEntity Read(int IDSALAOFESTA)
        {
            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_SALAOFESTA", dbCnn);
                    dbCommand.Transaction = ((FbTransaction)(dbTransaction));
                }
                else
                {
                    if (dbCnn == null)
                    {
                        dbCnn = ((FbConnection)GetConnectionDB());
                    }

                    if (dbCnn.State == ConnectionState.Closed)
                    {
                        dbCnn.Open();
                    }

                    dbCommand             = new FbCommand("Rea_SALAOFESTA", dbCnn);
                    dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
                }

                dbCommand.CommandType = CommandType.StoredProcedure;

                dbCommand.Parameters.AddWithValue("@IDSALAOFESTA", IDSALAOFESTA);                //PrimaryKey


                reader = dbCommand.ExecuteReader();

                SALAOFESTAEntity 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;
            }
        }
コード例 #8
0
        public int Save(SALAOFESTAEntity 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_SALAOFESTA", dbCnn);
                    dbCommand.Transaction = ((FbTransaction)(dbTransaction));
                }
                else
                {
                    if (dbCnn == null)
                    {
                        dbCnn = ((FbConnection)GetConnectionDB());
                    }

                    if (dbCnn.State == ConnectionState.Closed)
                    {
                        dbCnn.Open();
                    }

                    dbCommand             = new FbCommand("Sav_SALAOFESTA", dbCnn);
                    dbCommand.Transaction = dbCnn.BeginTransaction(IsolationLevel.ReadCommitted);
                }

                dbCommand.CommandType = CommandType.StoredProcedure;

                //PrimaryKey com valor igual a null, indica um novo registro,
                //o valor da chave será fornecido pelo banco. Qualquer outro valor indicará edição do registro.
                if (Entity.IDSALAOFESTA == -1)
                {
                    dbCommand.Parameters.AddWithValue("@IDSALAOFESTA", DBNull.Value);
                }
                else
                {
                    dbCommand.Parameters.AddWithValue("@IDSALAOFESTA", Entity.IDSALAOFESTA);
                }

                dbCommand.Parameters.AddWithValue("@NOME", Entity.NOME);                                             //Coluna
                dbCommand.Parameters.AddWithValue("@RAZAOSOCIAL", Entity.RAZAOSOCIAL);                               //Coluna
                dbCommand.Parameters.AddWithValue("@DTCADASTRO", Entity.DTCADASTRO);                                 //Coluna
                dbCommand.Parameters.AddWithValue("@TELEFONE1", Entity.TELEFONE1);                                   //Coluna
                dbCommand.Parameters.AddWithValue("@TELEFONE2", Entity.TELEFONE2);                                   //Coluna
                dbCommand.Parameters.AddWithValue("@CNPJ", Entity.CNPJ);                                             //Coluna
                dbCommand.Parameters.AddWithValue("@IE", Entity.IE);                                                 //Coluna
                dbCommand.Parameters.AddWithValue("@ENDERECO", Entity.ENDERECO);                                     //Coluna
                dbCommand.Parameters.AddWithValue("@BAIRRO", Entity.BAIRRO);                                         //Coluna
                dbCommand.Parameters.AddWithValue("@CIDADE", Entity.CIDADE);                                         //Coluna
                dbCommand.Parameters.AddWithValue("@UF", Entity.UF);                                                 //Coluna
                dbCommand.Parameters.AddWithValue("@CEP", Entity.CEP);                                               //Coluna
                dbCommand.Parameters.AddWithValue("@EMAIL", Entity.EMAIL);                                           //Coluna
                dbCommand.Parameters.AddWithValue("@OBSERVACAO", Entity.OBSERVACAO);                                 //Coluna
                dbCommand.Parameters.AddWithValue("@CONTATO", Entity.CONTATO);                                       //Coluna
                dbCommand.Parameters.AddWithValue("@EMAILCONTATO", Entity.EMAILCONTATO);                             //Coluna



                //Retorno da Procedure
                FbParameter returnValue;
                returnValue = dbCommand.CreateParameter();

                dbCommand.Parameters["@IDSALAOFESTA"].Direction = ParameterDirection.InputOutput;


                //Executando consulta
                dbCommand.ExecuteNonQuery();

                result = int.Parse(dbCommand.Parameters["@IDSALAOFESTA"].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);
        }