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