public bool Update(FurnizorBLL f)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "UPDATE FURNIZOR SET nume_furnizor=@nume_furnizor, tara=@tara, oras=@oras WHERE furnizor_id=@furnizor_id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@furnizor_id", f.furnizor_id);
cmd.Parameters.AddWithValue("@nume_furnizor", f.nume_furnizor);
cmd.Parameters.AddWithValue("@tara", f.tara);
cmd.Parameters.AddWithValue("@oras", f.oras);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
public bool Insert(FurnizorBLL f)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "INSERT INTO FURNIZOR (nume_furnizor, tara, oras, furnizor_id) VALUES (@nume_furnizor, @tara, @oras, @furnizor_id)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@furnizor_id", f.furnizor_id);
cmd.Parameters.AddWithValue("@nume_furnizor", f.nume_furnizor);
cmd.Parameters.AddWithValue("@tara", f.tara);
cmd.Parameters.AddWithValue("@oras", f.oras);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
public bool Delete(FurnizorBLL f)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
string sql = "DELETE FROM FURNIZOR WHERE furnizor_id=@furnizor_id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@furnizor_id", f.furnizor_id);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSucces = true;
}
else
{
isSucces = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
}
return(isSucces);
}
