public bool AjouterFournisseurs(Connexions UnConnexion) { bool opeOK = false; try { var ConnectionStrings = ConfigurationManager.ConnectionStrings; string bddServeur = Convert.ToString(ConnectionStrings["serveur"]); string sBddPort = Convert.ToString(ConnectionStrings["port"]); int bddPort = Convert.ToInt16(sBddPort); string bddBase = Convert.ToString(ConnectionStrings["base"]); string bddIdent = Convert.ToString(ConnectionStrings["identificateur"]); string bddMdp = Convert.ToString(ConnectionStrings["mdp"]); Connex = new Dbconnect(bddServeur, bddPort, bddBase, bddIdent, bddMdp); //Connex = new Dbconnect("secuoli.freeboxos.fr", 3306, "gestioncourses", "amoi", ""); if (Connex.OuvrirConnexion()) { string requete = "INSERT INTO `connexion` (`IdConnexion`, `Ident`, `MDP`, `Nom`, `Prenom`) " + "VALUES ('" + UnConnexion.Ident + "', '" + UnConnexion.Mdp + "', '" + UnConnexion.Nom + "', '" + UnConnexion.Prenom + "')"; Connex.RequeteNoData(requete); opeOK = true; } } catch { opeOK = false; } Connex.FermerConnexion(); return(opeOK); }
public (bool, string) ModifierConnexion(Connexions UnConnexion, int IdConnexion) { bool opeOK = false; int ligneMod = 0; string messErreur = ""; try { var ConnectionStrings = ConfigurationManager.ConnectionStrings; string bddServeur = Convert.ToString(ConnectionStrings["serveur"]); string sBddPort = Convert.ToString(ConnectionStrings["port"]); int bddPort = Convert.ToInt16(sBddPort); string bddBase = Convert.ToString(ConnectionStrings["base"]); string bddIdent = Convert.ToString(ConnectionStrings["identificateur"]); string bddMdp = Convert.ToString(ConnectionStrings["mdp"]); Connex = new Dbconnect(bddServeur, bddPort, bddBase, bddIdent, bddMdp); //Connex = new Dbconnect("secuoli.freeboxos.fr", 3306, "gestioncourses", "amoi", ""); if (Connex.OuvrirConnexion()) { string requete = "UPDATE `connexion` SET `Ident` = '" + UnConnexion.Ident + "', `MDP` = '" + UnConnexion.Mdp + "', `Nom` = '" + UnConnexion.Nom + "', `Prenom` = '" + UnConnexion.Prenom + "WHERE `connexion`.`IdConnexion` = " + IdConnexion; ligneMod = Connex.RequeteNoData(requete); if (ligneMod == 0) { messErreur = Connex.Erreur; opeOK = false; } else { opeOK = true; } } } catch { opeOK = false; messErreur = "Erreur de connexion !"; } Connex.FermerConnexion(); return(opeOK, messErreur); }
public (bool, string) SupprimerArticle(Connexions UnConnexion, int IdConnexion) { bool opeOK = false; int ligneMod = 0; string messErreur = ""; try { var ConnectionStrings = ConfigurationManager.ConnectionStrings; string bddServeur = Convert.ToString(ConnectionStrings["serveur"]); string sBddPort = Convert.ToString(ConnectionStrings["port"]); int bddPort = Convert.ToInt16(sBddPort); string bddBase = Convert.ToString(ConnectionStrings["base"]); string bddIdent = Convert.ToString(ConnectionStrings["identificateur"]); string bddMdp = Convert.ToString(ConnectionStrings["mdp"]); Connex = new Dbconnect(bddServeur, bddPort, bddBase, bddIdent, bddMdp); //Connex = new Dbconnect("secuoli.freeboxos.fr", 3306, "gestioncourses", "amoi", ""); if (Connex.OuvrirConnexion()) { string requete = "DELETE FROM connexion WHERE IdConnexion = " + IdConnexion; ligneMod = Connex.RequeteNoData(requete); if (ligneMod == 0) { messErreur = Connex.Erreur; opeOK = false; } else { opeOK = true; } } } catch { opeOK = false; messErreur = "Erreur de connexion !"; } Connex.FermerConnexion(); return(opeOK, messErreur); }