public bool Delete(realisationBLL u)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "delete FROM Realisation where Id=@Id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Id", u.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);
}
public bool Modifier(realisationBLL u)
{
bool isSucces = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
string sql = "UPDATE Realisation set Matricule=@Matricule,NinvMachine=@NinvMachine,ReferancePieces=@ReferancePieces,QuantitéRealiser=@QuantitéRealiser,Rebut=@Rebut,TempsOpration=@TempsOpration,DateRealisation=@DateRealisation,Cfi=@Cfi,Noperaion=@Noperation,TempsRealisation=@TempsRealisation,Id=@Id where Id=@Id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Matricule", u.Matricule);
cmd.Parameters.AddWithValue("@NinvMachine", u.NinvMachine);
cmd.Parameters.AddWithValue("@ReferancePieces", u.ReferancePieces);
cmd.Parameters.AddWithValue("@QuantitéRealiser", u.QuantitéRéaliser);
cmd.Parameters.AddWithValue("@Rebut", u.Rebut);
cmd.Parameters.AddWithValue("@TempsOpration", u.TempsOpration);
cmd.Parameters.AddWithValue("@DateRealisation", u.DateRealisation);
cmd.Parameters.AddWithValue("@Cfi", u.Cfi);
cmd.Parameters.AddWithValue("@Noperation", u.Noperation);
cmd.Parameters.AddWithValue("@TempsRealisation", u.TempsOpration);
cmd.Parameters.AddWithValue("@Id", u.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);
}
