예제 #1
0
 //mostrar valores no formulario
 private void ShowValues(Library.Cargo cargo)
 {
     this.codigoTB.Text    = string.Format("{0}", cargo.Id);
     this.nomeTB.Text      = cargo.Nome;
     this.descricaoTB.Text = cargo.Descricao;
     //cargo.DataCadastro;
 }
예제 #2
0
        private void excluirButton_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            this.InputDisabler(false);
            /************BEGIN************/
            //achando idCargo selecionado na grid
            Library.Cargo cargo = null;
            for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
            {
                cargo = Library.CargoBD.FindById((long)this.dataGridView1.SelectedRows[i].Cells["idDGVTBC"].Value);
            }
            if (MessageBox.Show(this.fcgCargoDeletarMsg, this.fcgCargoDeletarMsgTitle, MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                //se não tiver selecionado mostra mensagem se estiver deleta e atualiza formulario
                if (dataGridView1.SelectedRows.Count != 1)
                {
                    MessageBox.Show(this.fcgCargoDeletarNoSelected);
                }
                else
                {
                    Library.CargoBD.Delete(cargo);
                    this.RefreshForm();
                }
            }

            /*************END*************/
            this.Modo   = "Excluir";
            this.Cursor = Cursors.Default;
        }
예제 #3
0
        static public void Update(Library.Cargo cargo)
        {
            SqlConnection conexao = null;

            try
            {
                conexao = new SqlConnection(global::Connection.Connection.String());
                SqlCommand comando = conexao.CreateCommand();
                comando.CommandText = "UPDATE Cargo SET nome = @nome, descricao = @descricao, dataCadastro = @dataCadastro WHERE (id= " + cargo.Id + ")";
                comando.Parameters.AddWithValue("@nome", cargo.Nome);
                comando.Parameters.AddWithValue("@descricao", cargo.Descricao);
                comando.Parameters.AddWithValue("@dataCadastro", cargo.DataCadastro);

                conexao.Open();

                comando.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Library.Diagnostics.Logger.Error(ex);;
            }
            finally
            {
                conexao.Close();
            }
        }
예제 #4
0
        static public void Save(Library.Cargo cargo)
        {
            SqlConnection conexao = null;

            try
            {
                conexao = new SqlConnection(global::Connection.Connection.String());

                SqlCommand comando = conexao.CreateCommand();

                comando.CommandText = "INSERT INTO Cargo (nome, descricao, dataCadastro) VALUES (@nome, @descricao, @dataCadastro)"
                                      + "SELECT CAST(scope_identity() AS bigint)";

                comando.Parameters.AddWithValue("@nome", cargo.Nome);
                comando.Parameters.AddWithValue("@descricao", cargo.Descricao);
                comando.Parameters.AddWithValue("@dataCadastro", cargo.DataCadastro);

                conexao.Open();

                //comando.ExecuteNonQuery();
                cargo.Id = (long)comando.ExecuteScalar();
            }
            catch (Exception ex)
            {
                Library.Diagnostics.Logger.Error(ex);;
            }
            finally
            {
                conexao.Close();
            }
        }
예제 #5
0
        //atualizar objeto cargo com valores do formulario
        private Library.Cargo UpdateCargoFromForm()
        {
            Library.Cargo cargoTemp = this.cargo;

            //cargoTemp.Id = ;
            cargoTemp.Nome      = this.nomeTB.Text;
            cargoTemp.Descricao = this.descricaoTB.Text;
            //cargoTemp.DataCadastro = DateTime.Now;

            return(cargoTemp);
        }
예제 #6
0
        private void salvarButton_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            /************BEGIN************/
            if (this.ValidateForm())
            {
                this.MenuDisabler(true, false, false, false, false);
                this.InputDisabler(false);


                if (this.modo == "Cadastrar")
                {
                    //criando um cargo com valores do formulário
                    this.cargo = this.ReturnCargoFromForm();
                    //salvando cargo
                    Library.CargoBD.Save(this.cargo);

                    this.dataGridView1.Rows.Add(this.cargo.Id, this.cargo.Nome, this.cargo.DataCadastro);
                }
                else
                {
                    this.cargo = this.UpdateCargoFromForm();
                    //atualizando cargo
                    Library.CargoBD.Update(this.cargo);

                    foreach (DataGridViewRow d in dataGridView1.Rows)
                    {
                        if ((long)d.Cells[0].Value == this.cargo.Id)
                        {
                            d.Cells[0].Value = this.cargo.Id;
                            d.Cells[1].Value = this.cargo.Nome;
                            d.Cells[2].Value = this.cargo.DataCadastro;
                        }
                    }
                }


                //atualizando formulário
                //RefreshForm();
                RefreshChilds();


                this.Modo = "Salvar";
            }
            else
            {
                //mensagem de erro
            }
            /*************END*************/
            this.Cursor = Cursors.Default;
        }
예제 #7
0
 private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
 {
     this.Cursor = Cursors.WaitCursor;
     this.MenuDisabler(true, true, false, false, true);
     this.InputDisabler(false);
     this.Modo = "Selecionar";
     /************BEGIN************/
     if (dataGridView1.SelectedRows.Count == 1)
     {
         //achando idCargo selecionado na grid
         long idCargo = (long)this.dataGridView1.SelectedRows[0].Cells["idDGVTBC"].Value;
         //mostrando cargo selecionado no formulario
         this.cargo = Library.CargoBD.FindById(idCargo);
         this.ShowValues(cargo);
     }
     /*************END*************/
     this.Cursor = Cursors.Default;
 }
예제 #8
0
        private void editarButton_Click(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;
            this.MenuDisabler(true, false, true, true, false);
            this.InputDisabler(true);
            /************BEGIN************/
            //achando idCargo selecionado na grid
            long idCargo = 0;

            for (int i = 0; i < dataGridView1.SelectedRows.Count; i++)
            {
                idCargo = (long)this.dataGridView1.SelectedRows[i].Cells["idDGVTBC"].Value;
            }
            //mostrando cargo selecionado no formulario
            this.cargo = Library.CargoBD.FindById(idCargo);
            this.ShowValues(this.cargo);
            /*************END*************/
            this.Modo   = "Editar";
            this.Cursor = Cursors.Default;
        }
예제 #9
0
        static public Library.Cargo FindById(long idCargo)
        {
            SqlConnection  conexao = null;
            SqlDataAdapter dap     = null;
            DataSet        ds      = null;

            Library.Cargo cargo = null;
            try
            {
                conexao = new SqlConnection(global::Connection.Connection.String());

                dap = new SqlDataAdapter("SELECT * FROM Cargo WHERE id='" + idCargo + "'", conexao);

                ds = new DataSet();

                dap.Fill(ds, "Cargo");

                if (ds.Tables["Cargo"].Rows.Count == 1)
                {
                    cargo              = new Cargo();
                    cargo.Id           = (long)ds.Tables["Cargo"].Rows[0]["id"];
                    cargo.Nome         = ds.Tables["Cargo"].Rows[0]["nome"].ToString();
                    cargo.Descricao    = ds.Tables["Cargo"].Rows[0]["descricao"].ToString();
                    cargo.DataCadastro = (DateTime)ds.Tables["Cargo"].Rows[0]["dataCadastro"];
                }
                return(cargo);
            }
            catch (Exception ex)
            {
                Library.Diagnostics.Logger.Error(ex);;
            }
            finally
            {
                conexao.Close();
                dap.Dispose();
                ds.Dispose();
            }
            return(null);
        }
예제 #10
0
        static public void Delete(Library.Cargo cargo)
        {
            SqlConnection conexao = null;

            try
            {
                conexao = new SqlConnection(global::Connection.Connection.String());
                SqlCommand comando = conexao.CreateCommand();

                comando.CommandText = "DELETE FROM Cargo WHERE id='" + cargo.Id + "'";

                conexao.Open();
                comando.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Library.Diagnostics.Logger.Error(ex);
            }
            finally
            {
                conexao.Close();
            }
        }