1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
|
Private Function ModifierAstuce(ByVal Id As Integer, ByVal XIdType As Integer, Nom As String, Description As String, Code As String, Note As String, Remarque As String, Commentaire As String, Lien As String) As Boolean
Dim SQL As String
ParametroConexion()
MaConexion.Open()
MaCommande = MaConexion.CreateCommand()
MaCommande.Parameters.AddWithValue("@XIdType", XIdType)
MaCommande.Parameters.AddWithValue("@Nom", Nom)
MaCommande.Parameters.AddWithValue("@Description", Description)
MaCommande.Parameters.AddWithValue("@Code", Code)
MaCommande.Parameters.AddWithValue("@Note", Note)
MaCommande.Parameters.AddWithValue("@Remarque", Remarque)
MaCommande.Parameters.AddWithValue("@Commentaire", Commentaire)
MaCommande.Parameters.AddWithValue("@Lien", Lien)
MaCommande.Parameters.AddWithValue("@LeIdAstuce", Id)
SQL = "UPDATE T_ASTUCEPROG SET XIdTypeAstuce = @XIdType, NomAstuce = @Nom, DescripAstuce = @Description, CodeAstuce = @Code, NoteAstuce = @Note, RemAstuce = @Remarque, CommentAstuce = @Commentaire, LienAstuce = @Lien " &
"WHERE IdAstuce = @LeIdAstuce;"
MaCommande.CommandText = SQL
If MaCommande.ExecuteNonQuery() = 1 Then
' Modif effectée
Else
' Erreur
MaConexion.Close()
MaCommande.Dispose()
Return False
End If
MaConexion.Close()
MaCommande.Dispose()
Return True
End Function
Private Sub Bp_modifier_Astuce_Click(sender As Object, e As EventArgs) Handles Bp_modifier_Astuce.Click
Dim IdAstuceEnCours As Integer
IdAstuceEnCours = MesAstuces.Tables(NomTableAstuces).Rows(Me.BindingContext(MesAstuces.Tables(NomTableAstuces)).Position).Item("IdAstuce")
If ModifierAstuce(IdAstuceEnCours, CB_Type.SelectedValue, TB_NomAstuce.Text, TB_DescripAstuce.Text, RTBCode.Text, RTB_NoteAstuce.Text, RTB_RemAstuce.Text, RTB_CommentAstuce.Text, TB_LienAstuce.Text) Then
MesAstuces.Tables(NomTableAstuces).AcceptChanges() ' provoque la màj des composants liés
End If
End Sub
Private Function SupprimerAstuce(ByVal Id As Integer) As Boolean
Dim SQL As String
ParametroConexion()
MaConexion.Open()
MaCommande = MaConexion.CreateCommand()
MaCommande.Parameters.AddWithValue("@LeIdAstuce", Id)
SQL = "DELETE FROM T_FICHIER WHERE XIdAstuceFichier = @LeIdAstuce;"
MaCommande.CommandText = SQL
MaCommande.ExecuteNonQuery()
SQL = "DELETE FROM T_IMAGE WHERE XIdAstuceImage = @LeIdAstuce;"
MaCommande.CommandText = SQL
MaCommande.ExecuteNonQuery()
SQL = "DELETE FROM T_ASTUCEPROG WHERE IdAstuce = @LeIdAstuce;"
MaCommande.CommandText = SQL
If MaCommande.ExecuteNonQuery() = 1 Then
' Suppression effectée
Else
' Erreur
MaConexion.Close()
MaCommande.Dispose()
Return False
End If
MaConexion.Close()
MaCommande.Dispose()
Return True
End Function
Private Sub Bp_Supprimer_Astuce_Click(sender As Object, e As EventArgs) Handles Bp_Supprimer_Astuce.Click
Dim IdAstuceEnCours As Integer
IdAstuceEnCours = MesAstuces.Tables(NomTableAstuces).Rows(Me.BindingContext(MesAstuces.Tables(NomTableAstuces)).Position).Item("IdAstuce")
If SupprimerAstuce(IdAstuceEnCours) Then ' si OK, on supprime dans le DataTable
MesAstuces.Tables(NomTableAstuces).Rows(Me.BindingContext(MesAstuces.Tables(NomTableAstuces)).Position).Delete()
End If
End Sub |
Partager