public static Boolean delete(Habilite habilite) { Boolean isDelete = false; //Connection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["EntretienSPPPConnectionString"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); String requete = @"DELETE FROM habilite WHERE Identifiant = @Identifiant ; "; SqlCommand commande = new SqlCommand(requete, connection); commande.Parameters.AddWithValue("Identifiant", habilite.Identifiant); try { connection.Open(); commande.ExecuteNonQuery(); isDelete = true; } catch (Exception) { isDelete = false; } finally { connection.Close(); } return isDelete; }
public static Habilite CreateHabilite(Habilite habilite) { ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["EntretienSPPPConnectionString"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); String requete = @"Insert INTO habilite(type) Values (@type); SELECT SCOPE_IDENTITY() ; "; SqlCommand commande = new SqlCommand(requete, connection); commande.Parameters.AddWithValue("libelle", habilite.Type); try { connection.Open(); Decimal IDENTIFIANTDERNIERAJOUT = (Decimal)commande.ExecuteScalar(); return HabiliteDB.Get(Int32.Parse(IDENTIFIANTDERNIERAJOUT.ToString())); } catch (Exception) { throw; } finally { connection.Close(); } }
/// <summary> /// Récupère une Habilite à partir d'un identifiant de client /// </summary> /// <param name="Identifiant">Identifant de Habilite</param> /// <returns>Un Habilite </returns> public static Habilite Get(Int32 identifiant) { //Connection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["EntretienSPPPConnectionString"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); //Commande String requete = @"SELECT Identifiant, Type FROM Habilite WHERE Identifiant = @Identifiant ;"; SqlCommand commande = new SqlCommand(requete, connection); //Paramètres commande.Parameters.AddWithValue("Identifiant", identifiant); //Execution connection.Open(); SqlDataReader dataReader = commande.ExecuteReader(); dataReader.Read(); //1 - Création du Habilite Habilite habilite = new Habilite(); habilite.Identifiant = dataReader.GetInt32(0); habilite.Type = dataReader.GetString(1); dataReader.Close(); connection.Close(); return habilite; }
public static Boolean update(Habilite habilite) { Boolean isUpDAte = false ; //mettre a jour la base de donnée // retourne un boulean si l'update ses bien dérouler //Connection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["EntretienSPPPConnectionString"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); String requete = @"Update habilite set type = @type where identifiant = @identifiant ;"; SqlCommand commande = new SqlCommand(requete, connection); commande.Parameters.AddWithValue("Libelle", habilite.Type); commande.Parameters.AddWithValue("identifiant", habilite.Identifiant); try { connection.Open(); commande.ExecuteNonQuery(); isUpDAte = true; } catch (Exception) { isUpDAte = false; } finally { connection.Close(); } return isUpDAte; }
/// <summary> /// Récupère une liste de Habilite à partir de la base de données /// </summary> /// <returns>Une liste de client</returns> public static List<Habilite> List() { //Récupération de la chaine de connexion //Connection ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["EntretienSPPPConnectionString"]; SqlConnection connection = new SqlConnection(connectionStringSettings.ToString()); //Commande String requete = "SELECT Identifiant, Type FROM Habilite ;"; connection.Open(); SqlCommand commande = new SqlCommand(requete, connection); //execution SqlDataReader dataReader = commande.ExecuteReader(); List<Habilite> list = new List<Habilite>(); while (dataReader.Read()) { //1 - Créer un Habilite à partir des donner de la ligne du dataReader Habilite habilite = new Habilite(); habilite.Identifiant = dataReader.GetInt32(0); habilite.Type = dataReader.GetString(1); //2 - Ajouter ce Habilite à la list de client list.Add(habilite); } dataReader.Close(); connection.Close(); return list; }