Esempio n. 1
0
        private void buttonConfirm_Click(object sender, EventArgs e)
        {
            using (SqlConnection sqlConn = new SqlConnection("Data Source=(localdb)\\Estoque;Initial Catalog=northwind;Integrated Security=True"))
            {
                using (SqlCommand sqlCommand = new SqlCommand())
                {
                    if ((textBoxLogin.Text != "") && (textBoxPass.Text != ""))
                    {
                        sqlCommand.Parameters.AddWithValue("Log", textBoxLogin.Text);
                        sqlCommand.Parameters.AddWithValue("Pass", textBoxPass.Text);
                        sqlCommand.CommandText = "SELECT ID, login, secret, tipo FROM Employees WHERE Login= @Log AND Secret= @Pass";
                        sqlCommand.Connection = sqlConn;
                        sqlConn.Open();
                        SqlDataReader dataReader;
                        dataReader = sqlCommand.ExecuteReader();

                        if (dataReader.Read())
                        {
                            login = new Operador();
                            login.Login = dataReader["Login"].ToString();
                            login.Id = Int32.Parse(dataReader["ID"].ToString());
                            login.Senha = Int32.Parse(dataReader["Secret"].ToString());
                            login.Tipo = Int32.Parse(dataReader["Tipo"].ToString());
                            FormMenu frm = new FormMenu();
                            frm.Show();
                            this.Visible = false;
                        }
                        else
                        {
                            MessageBox.Show("Login não encontrado");
                        }
                        sqlConn.Close();
                    }
                }
            }
        }
        private void buttonPesquisar_Click(object sender, EventArgs e)
        {
            using (SqlConnection sqlConn =
                    new SqlConnection("Data Source=(localdb)\\Estoque;Initial Catalog=northwind;Integrated Security=True"))
            {
                using (SqlCommand sqlCommand = new SqlCommand())
                {
                    sqlCommand.Parameters.AddWithValue("PId", comboBoxNome.SelectedValue);
                    sqlCommand.CommandText = "SELECT ID, FirstName,LastName," +
                    "Address, HomePhone, login, secret, tipo FROM Employees WHERE id= @PId";
                    sqlCommand.Connection = sqlConn;
                    sqlConn.Open();
                    SqlDataReader dataReader;
                    dataReader = sqlCommand.ExecuteReader(); //para caso que retorna registros
                    if (dataReader.Read()) //encontrou registro
                    {
                        operador = new Operador(Int32.Parse(dataReader[0].ToString()),
                                                dataReader[1].ToString(), dataReader[2].ToString(),
                                                dataReader[3].ToString(), dataReader[4].ToString(),
                                                dataReader[5].ToString(),
                                                Int32.Parse(dataReader[6].ToString()),
                                                Int32.Parse(dataReader[7].ToString()));

                        textBoxCod.Text = operador.Id.ToString();
                        textBoxNome.Text = operador.Nome;
                        textBoxSobreNome.Text = operador.Sobrenome;
                        textBoxEndereco.Text = operador.Endereco;
                        textBoxTelefone.Text = operador.Telefone;
                        textBoxLogin.Text = operador.Login;
                        textBoxSenha.Text = operador.Senha.ToString();
                        comboBoxTipo.Text = operador.Tipo.ToString();
                    }
                    else
                    {
                        limparForm();
                    }
                    sqlConn.Close();
                }
            }
        }
 private void buttonSalvar_Click(object sender, EventArgs e)
 {
     if (operadorNovo)
     {
         using (SqlConnection sqlConn =
             new SqlConnection("Data Source=(localdb)\\Estoque;Initial Catalog=northwind;Integrated Security=True"))
         {
             using (SqlCommand sqlCommand = new SqlCommand())
             {
                 operador = new Operador(Int32.Parse(textBoxCod.Text.ToString()),
                                             textBoxNome.Text.ToString(),
                                             textBoxSobreNome.Text.ToString(),
                                             textBoxEndereco.Text.ToString(),
                                             textBoxTelefone.Text.ToString(), textBoxLogin.Text.ToString(),
                                             Int32.Parse(textBoxSenha.Text.ToString()),
                                             Int32.Parse(comboBoxTipo.SelectedIndex.ToString()));
                 sqlCommand.CommandText = "INSERT into Employees (FirstName,LastName," +
                             "Address,HomePhone,Login,Secret,Tipo) values ('" + operador.Nome +
                             "','" + operador.Sobrenome + "', '" + operador.Endereco + "', '" + operador.Telefone + "','" +
                             operador.Login + "', '" + operador.Senha + "', '" + operador.Tipo + "')";
                 sqlCommand.Connection = sqlConn;
                 sqlConn.Open();
                 if (sqlCommand.ExecuteNonQuery() > 0)
                 {
                     comboBoxNome.Refresh();
                     bloquearTextBox();
                     MessageBox.Show("Operador adicionado com sucesso!");
                 }
                 else
                 {
                     MessageBox.Show("Operador nao adicionado");
                 }
                 sqlConn.Close();
             }
         }
     }
     else
     {
         using (SqlConnection sqlConn =
                 new SqlConnection("Data Source=(localdb)\\Estoque;Initial Catalog=northwind;Integrated Security=True"))
         {
             using (SqlCommand sqlCommand = new SqlCommand())
             {
                 sqlCommand.CommandText = "UPDATE Employees SET FirstName = '" + operador.Nome + "',LastName = '" + operador.Sobrenome + "',"+
                     "Address = '" + operador.Endereco + "'," +
                     "HomePhone = '" + operador.Telefone + "', Login = '******'," +
                      "Secret = '" + operador.Senha + "', Tipo = '" + operador.Tipo + "' where ID = '" + operador.Id + "'";
                 sqlCommand.Connection = sqlConn;
                 sqlConn.Open();
                 if (sqlCommand.ExecuteNonQuery() > 0)
                 {
                     MessageBox.Show("Oeprador atualizado com sucesso!");
                 }
                 else
                 {
                     MessageBox.Show("Falha ao atualizar");
                 }
                 sqlConn.Close();
                 bloquearTextBox();
             }
         }
     }
 }