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); }