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