public bool Update(ProduseBLL p, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "UPDATE Produse SET Nume=@Nume, Natura=@Natura, Cod=@Cod, Lot=@Lot, DataExpirare=@DataExpirare WHERE ID_produs=@ID_produs ";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
cmd.Parameters.AddWithValue("@ID_produs", p.ID_produs);
cmd.Parameters.AddWithValue("@Cod", p.Cod);
cmd.Parameters.AddWithValue("@Natura", p.Natura);
cmd.Parameters.AddWithValue("@Lot", p.Lot);
cmd.Parameters.AddWithValue("@DataExpirare", p.DataExpirare);
cmd.Parameters.AddWithValue("@Nume", p.Nume);
//open conection
conn.Open();
//var to hold value after quer executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
//eror
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Insert(ProduseBLL p, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "INSERT INTO Produse(Nume, Natura, Cod, Lot, DataExpirare) VALUES (@Nume, @Natura, @Cod, @Lot, @DataExpirare)";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
cmd.Parameters.AddWithValue("@Cod", p.Cod);
cmd.Parameters.AddWithValue("@Natura", p.Natura);
cmd.Parameters.AddWithValue("@Lot", p.Lot);
cmd.Parameters.AddWithValue("@DataExpirare", p.DataExpirare);
cmd.Parameters.AddWithValue("@Nume", p.Nume);
//open conection
conn.Open();
//var to hold value after quer executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
//eror
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Delete(ProduseBLL p, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "DELETE FROM Produse WHERE ID_produs=@ID_produs ";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
cmd.Parameters.AddWithValue("@ID_produs", p.ID_produs);
//open conection
conn.Open();
//var to hold value after quer executed
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
//eror
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSuccess);
}
