private void textBoxCodigo_KeyUp(object sender, KeyEventArgs 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", textBoxCodigo.Text);
sqlCommand.CommandText = "SELECT ProductID, ProductName," +
"SupplierID, UnitPrice, UnitsInStock FROM Products WHERE ProductID= @PId";
sqlCommand.Connection = sqlConn;
sqlConn.Open();
SqlDataReader dataReader;
dataReader = sqlCommand.ExecuteReader(); //para caso que retorna registros
if (dataReader.Read()) //encontrou registro
{
prod = new Produto(Int32.Parse(dataReader["ProductID"].ToString()),
dataReader[1].ToString(),
Int32.Parse(dataReader[2].ToString()),
Decimal.Parse(dataReader[3].ToString()),
Double.Parse(textBoxQuantidade.Text));
//colocando os dados no formulario
textBoxDescricao.Text = prod.Nome;
}
else
{
textBoxDescricao.Text = "";
prod = null;
}
sqlConn.Close();
}
}
}
private void buttonSalvar_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", textCod.Text);
sqlCommand.CommandText = "SELECT count(ProductID)" +
"FROM Products WHERE ProductID= @PId";
sqlCommand.Connection = sqlConn;
sqlConn.Open();
SqlDataReader dataReader;
dataReader = sqlCommand.ExecuteReader(); //para caso que retorna registros
if (dataReader.Read()) //encontrou registro
{
if(Int32.Parse(dataReader[0].ToString()) == 1)
{
sqlConn.Close();
p = new Produto(Int32.Parse(textCod.Text.ToString()),
textName.Text.ToString(),
Int32.Parse(textIdFor.Text.ToString()),
Decimal.Parse(textValorUni.Text.ToString()),
Double.Parse(textQuantidade.Text));
sqlCommand.CommandText = "UPDATE Products SET ProductName = '" + p.Nome +"'," +
"SupplierID = '" + p.IdFornecedor + "', UnitPrice = '" + p.PrecoUnitarioVenda + "'," +
"UnitsInStock = '" + p.Quantidade + "' where ProductID = '" + p.Id + "'";
sqlConn.Open();
if (sqlCommand.ExecuteNonQuery() > 0)
{
MessageBox.Show("Produto atualizado com sucesso!");
}
else
{
MessageBox.Show("Falha ao atualizar");
}
sqlConn.Close();
}
else
{
sqlConn.Close();
p = new Produto(Int32.Parse(textCod.Text.ToString()),
textName.Text.ToString(),
Int32.Parse(textIdFor.Text.ToString()),
Decimal.Parse(textValorUni.Text.ToString()),
Double.Parse(textQuantidade.Text));
sqlCommand.CommandText = "INSERT into Products (ProductName,SupplierID," +
"UnitPrice,UnitsInStock) values ('" + p.Nome+ "', '" + p.IdFornecedor +
"', '" + p.PrecoUnitarioVenda + "', '" + p.Quantidade +"')";
sqlConn.Open();
if (sqlCommand.ExecuteNonQuery() > 0)
{
MessageBox.Show("Produto adicionado com sucesso!");
}
else
{
MessageBox.Show("Produto nao adicionado");
}
sqlConn.Close();
}
}
else
{
textCod.Text = "";
textName.Text = "";
textIdFor.Text = "";
textValorUni.Text = "";
textQuantidade.Text = "";
}
sqlConn.Close();
bloquearTextBox();
}
}
}