public int AnnulerConversion(string CodeConversion)
{
try
{
// string dernier_EB = DernierEtatBesoin() + "EB" + InitialNomUtilisateur;
string s = " DELETE FROM tConversionPoint " +
" WHERE CodeConversion=@a ";
//Em.CodeEtatdeBesoin, change par dernier_EB
string[] r = { CodeConversion };
DateTime[] d = { DateTime.Now };
// Verification de solde
//double solde.
//Clients.ClientDataAccessLayer Dal = new Clients.ClientDataAccessLayer();
ClassRequette req = new ClassRequette();
req.ExecuterSqlAvecDate(ClassVariableGlobal.seteconnexion(), s, r, d);;
//EtatBesoinModel etat = new EtatBesoinModel();
//etat.CodeEtatdeBesoin = dernier_EB;
//etat.DesignationEtatDeBesion = Em.DesignationEtatDeBesion;
return(1);
}
catch
{
return(0);
throw;
}
}
public ConversionPointModel NouvelleConversion(ConversionPointModel Obj)
{
try
{
// string dernier_EB = DernierEtatBesoin() + "EB" + InitialNomUtilisateur;
string s = "INSERT INTO tConversionPoint " +
" (CodeConversion,CodeClient, PointConvertie, RefOperation,DateOperation) " +
" VALUES(@a,@b, @c,@d,@da) ";
//Em.CodeEtatdeBesoin, change par dernier_EB
string[] r = { DernierCon(), Obj.CodeClient, Obj.PointConvertie, Obj.RefOperation, };
DateTime[] d = { DateTime.Now };
// Verification de solde
//double solde.
//Clients.ClientDataAccessLayer Dal = new Clients.ClientDataAccessLayer();
ClassRequette req = new ClassRequette();
req.ExecuterSqlAvecDate(ClassVariableGlobal.seteconnexion(), s, r, d);;
//EtatBesoinModel etat = new EtatBesoinModel();
//etat.CodeEtatdeBesoin = dernier_EB;
//etat.DesignationEtatDeBesion = Em.DesignationEtatDeBesion;
return(Obj);
}
catch
{
return(null);
throw;
}
}
public void AjouterOperation(OperationModel Op)
{
string s = " INSERT INTO tOperation" +
" (NumOperation, Libelle, CodeEtatdeBesoin,NomUt, DateOp, DateSysteme) " +
" VALUES(@a, @b, @c, @d, @da, @db)";
string[] r = { Op.NumOperation, Op.Libelle, Op.CodeEtatdeBesoin, Op.NomUt, };
DateTime[] d = { Op.DateOp, DateTime.Now };
ClassRequette req = new ClassRequette();
req.ExecuterSqlAvecDate(ClassVariableGlobal.SetConnexion(), s, r, d);
}
public void AjouterMvtCompte(MvtCompteModel MvtC)
{
string s = " INSERT INTO tMvtCompte " +
"(NumCompte, NumOperation, Details, Qte, Entree, Sortie, CodeProject) " +
"VALUES(@a, @b, @c, @d, @e, @f, @g)";
string[] r = { MvtC.NumCompte, MvtC.NumOperation, MvtC.Details.ToString(),
MvtC.Qte.ToString(), MvtC.Entree.ToString(), MvtC.Sortie.ToString(), MvtC.CodeProject };
DateTime[] d = { };
ClassRequette req = new ClassRequette();
req.ExecuterSqlAvecDate(ClassVariableGlobal.SetConnexion(), s, r, d);
}
public void SupprimmeerOperation(string Op)
{
string s = " delete FROM tOperation " +
" WHERE NumOperation=@a ";
string[] r = { Op };
DateTime[] d = { DateTime.Now };
ClassRequette req = new ClassRequette();
req.ExecuterSqlAvecDate(ClassVariableGlobal.SetConnexion(), s, r, d);
}
public void AjouterArticle(ArticleModel Art)
{
string s = "INSERT INTO tArticle" +
"(CodeArticle, CodeDepartement, DesegnationArticle, CategorieArticle, PrixAchat," +
" Critique, PrixVente, Compte, UniteEngro, UiniteEnDetaille, QteEnDet, Enstock," +
" Solde, CompteFournisseur) " +
"VALUES(@a, @b, @c, @d, @e, @f, @g, @h, @j, @k, @l, @m, @n, @o)";
string[] r = { Art.CodeArticle, Art.CodeDepartement, Art.DesegnationArticle,
Art.CategorieArticle.ToString(), Art.PrixAchat.ToString(), Art.Critique.ToString(),Art.PrixVente.ToString()
, Art.Compte.ToString(), Art.UniteEngro, Art.UiniteEnDetaille.ToString(),Art.QteEnDet.ToString(),
Art.Enstock.ToString(), Art.Solde.ToString(), Art.CompteFournisseur.ToString() };
DateTime[] d = { };
ClassRequette req = new ClassRequette();
req.ExecuterSqlAvecDate(ClassVariableGlobal.SetConnexion(), s, r, d);;
}
public void InsertTest(tTest test)
{
using (SqlConnection connection = new SqlConnection(ClassVariableGlobal.SetConnexion()))
{
connection.Open();
string query = "INSERT INTO tTest(SavedTest) VALUES(@a)";
//SqlCommand commande = new SqlCommand(query, connection);
//commande.Parameters.AddWithValue("@SavedTest", test.ToSave);
string[] r = { test.ToSave };
DateTime[] rd = { DateTime.UtcNow };
ClassRequette req = new ClassRequette();
req.ExecuterSqlAvecDate(ClassVariableGlobal.SetConnexion(), query, r, rd);
}
}
