public static Produto BuscaProduto(int codProduto)
{
using (SqlConnection sqlConn =
new SqlConnection(ConnString))
{
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.Parameters.AddWithValue("Id", codProduto);
sqlCommand.CommandText = "select * from produtos where Id = @Id";
sqlCommand.Connection = sqlConn;
sqlConn.Open();
SqlDataReader dataReader;
dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
Produto prod = new Produto(int.Parse(dataReader[0].ToString()),
dataReader[1].ToString(),
dataReader[2].ToString(),
dataReader[3].ToString(),
int.Parse(dataReader[4].ToString()),
float.Parse(dataReader[5].ToString()),
float.Parse(dataReader[6].ToString()),
dataReader[7].ToString());
return prod;
}
return null;
}
}
}
public static Produto AlterarProduto(int id, string nome, string fornecedor, float p1, float p2, string desc,int qtd)
{
using (SqlConnection sqlConn =
new SqlConnection(ConnString))
{
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.CommandText = "update produtos set NomeProduto = '" +nome+ "',"
+ " Fornecedor = '" +fornecedor+ "',"
+ " PrecoCompra = " +p1+ ","
+ " PrecoVenda = " +p2+ ","
+ " QtdEstoque = " + qtd + ","
+ " Descricao = '" +desc+ "'"
+ " where Id = " +id;
sqlCommand.Connection = sqlConn;
sqlConn.Open();
if (sqlCommand.ExecuteNonQuery() > 0)
{
sqlCommand.Parameters.AddWithValue("Id", id);
sqlCommand.CommandText = "select * from produtos where Id = @Id";
SqlDataReader dataReader;
dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
Produto prod = new Produto(int.Parse(dataReader[0].ToString()),
dataReader[1].ToString(),
dataReader[2].ToString(),
dataReader[3].ToString(),
int.Parse(dataReader[4].ToString()),
float.Parse(dataReader[5].ToString()),
float.Parse(dataReader[6].ToString()),
dataReader[7].ToString());
sqlConn.Close();
return prod;
}
}
sqlConn.Close();
return null;
}
}
}
public ItenVenda(Produto p, int qtd)
{
Produto = p;
Qtd = qtd;
}
public static Produto InserirProduto(string nome, string fornecedor, float p1, float p2, string desc,int qtd, string val)
{
using (SqlConnection sqlConn =
new SqlConnection(ConnString))
{
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.Parameters.AddWithValue("nome", nome);
sqlCommand.Parameters.AddWithValue("fornecedor", fornecedor);
sqlCommand.Parameters.AddWithValue("precoCompra", p1);
sqlCommand.Parameters.AddWithValue("precoVenda", p1);
sqlCommand.Parameters.AddWithValue("desc", desc);
sqlCommand.Parameters.AddWithValue("qtd", qtd);
sqlCommand.Parameters.AddWithValue("val", val);
sqlCommand.CommandText = "insert into produtos values (@desc,@fornecedor,@val,@qtd,@precoCompra,@precoVenda,@nome)";
sqlCommand.Connection = sqlConn;
sqlConn.Open();
if (sqlCommand.ExecuteNonQuery() > 0)
{
sqlCommand.CommandText = "select * from produtos order by Id desc";
SqlDataReader dataReader;
dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
Produto prod = new Produto(int.Parse(dataReader[0].ToString()),
dataReader[1].ToString(),
dataReader[2].ToString(),
dataReader[3].ToString(),
int.Parse(dataReader[4].ToString()),
float.Parse(dataReader[5].ToString()),
float.Parse(dataReader[6].ToString()),
dataReader[7].ToString());
sqlConn.Close();
return prod;
}
}
sqlConn.Close();
return null;
}
}
}
public static Produto RemoverProduto(Produto prod)
{
using (SqlConnection sqlConn =
new SqlConnection(ConnString))
{
using (SqlCommand sqlCommand = new SqlCommand())
{
sqlCommand.Parameters.AddWithValue("id", prod.Cod);
sqlCommand.CommandText = "delete from produtos where Id = @id";
sqlCommand.Connection = sqlConn;
sqlConn.Open();
if (sqlCommand.ExecuteNonQuery() > 0)
{
return prod;
}
sqlConn.Close();
return null;
}
}
}