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) SupprimerArticle(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 = "DELETE FROM article WHERE 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);
}