public bool Insert(FurnizoriBLL f, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "INSERT INTO Furnizori( Nume, Adresa, Cod_fiscal) VALUES (@Nume, @Adresa, @Cod_fiscal)";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
cmd.Parameters.AddWithValue("@Nume", f.Nume);
cmd.Parameters.AddWithValue("@Adresa", f.Adresa);
cmd.Parameters.AddWithValue("@Cod_fiscal", f.Cod_fiscal);
//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 Update(FurnizoriBLL c, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "UPDATE Furnizori SET Nume=@Nume, Adresa=@Adresa, Cod_fiscal=@Cod_fiscal WHERE ID_furnizor=@ID_furnizor ";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
cmd.Parameters.AddWithValue("@ID_furnizor", c.ID_furnizor);
cmd.Parameters.AddWithValue("@Nume", c.Nume);
cmd.Parameters.AddWithValue("@Adresa", c.Adresa);
cmd.Parameters.AddWithValue("@Cod_fiscal", c.Cod_fiscal);
//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(FurnizoriBLL c, SqlConnection conn)
{
//set bool var
bool isSuccess = false;
try
{
//sql Query
string sql = "DELETE FROM Furnizori WHERE ID_furnizor=@ID_furnizor ";
//sql comand
SqlCommand cmd = new SqlCommand(sql, conn);
//param to get value
cmd.Parameters.AddWithValue("@ID_furnizor", c.ID_furnizor);
//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);
}
