public bool AjouterFournisseurs(Fournisseurs UnFournisseur) { 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 `Fournisseur` (`Nom`, `Adresse`, `CodePostal`, `Ville`) " + "VALUES ('" + UnFournisseur.Nom + "', '" + UnFournisseur.Adresse + "', '" + UnFournisseur.Cp + "', '" + UnFournisseur.Ville + "')"; Connex.RequeteNoData(requete); opeOK = true; } } catch { opeOK = false; } Connex.FermerConnexion(); return(opeOK); }
public MySqlDataReader LecturetoutClub() { 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 = "SELECT * FROM fournisseur"; reader = Connex.RequeteSql(requete); return(reader); } } catch { return(reader); } Connex.FermerConnexion(); return(reader); }
public bool AjouterClub(Articles Unarticle) { 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 `article` (`IdArticle`, `RefSociete`, `RefFournisseur`, `Nom`, `Description`, `Emplacement`, `StockMin`, `StockMax`, `Quantite`, `IdFournisseur`)" + "VALUES ('" + Unarticle.RefSte + "', '" + Unarticle.RefFrs + "', '" + Unarticle.Nom + "', '" + Unarticle.Description + "', '" + Unarticle.Emplacement + "', '" + Unarticle.StockMini + "', '" + Unarticle.StockMaxi + "', '" + Unarticle.Quantite + "', '" + Unarticle.IdFrs + "')"; Connex.RequeteNoData(requete); opeOK = true; } } catch { opeOK = false; } Connex.FermerConnexion(); return(opeOK); }
public (bool, string) ModifierArticle(Articles Unarticle, int IdArticle) { 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 `article` SET `RefSociete` ='" + Unarticle.RefSte + "', `RefFournisseur` = '" + Unarticle.RefFrs + "', `Nom` = '" + Unarticle.Nom + "', `Description` = '" + Unarticle.Description + "', `Emplacement` = '" + Unarticle.Emplacement + "', `StockMin` = '" + Unarticle.StockMini + "', `StockMax` = '" + Unarticle.StockMaxi + "', `Quantite` = '" + Unarticle.Quantite + "', `IdFournisseur` = '" + Unarticle.IdFrs + "' WHERE `article`.`IdArticle` = " + IdArticle; 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) 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(Fournisseurs UnArticle, int IdFournisseur) { 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 fournisseur WHERE IdFournisseur = " + IdFournisseur; 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); }