[WebMethod]
public FactureTopNet CreationFacture( int NUM_FACTURE, int NUM_JUR_FACT, int SOCIETE, int TYPE, string LOGIN_CREATION, DateTime DATE_CREATION, string LOGIN_MODIFICATION, DateTime DATE_MODIFICATION, Decimal MNT_FACT, decimal REMISE, decimal NET_PAYE, decimal REST_PAYE, string OBSERV, int ID_CLIENT, string REMARQUE, string MONTANTTEXT, int TIMBRE, int AVOIR, int NUM_LISTE, int ID_REV, int NUM_PF, int NUM_PP, string REFERENCE, string CLE, int ID_COM, decimal MONTANT_COM, DateTime DATE_COM, int RED_COM, int INTER_GROUPE)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=topnet;Initial Catalog=TopnetBase;Data Source=SWEET-4B6F892B4\SQLEXPRESS";
conn.Open();
FactureTopNet facture = new FactureTopNet();
int r;
string req = "INSERT INTO facture (NUM_FACTURE, NUM_JUR_FACT, SOCIETE, TYPE, LOGIN_CREATION, DATE_CREATION,LOGIN_MODIFICATION,DATE_MODIFICATION,MNT_FACT, REMISE, NET_PAYE, REST_PAYE, OBSERV, ID_CLIENT, REMARQUE, MONTANTTEXT, TIMBRE, AVOIR,NUM_LISTE,ID_REV,NUM_PF,NUM_PP, REFERENCE, CLE, ID_COM,MONTANT_COM, DATE_COM, RED_COM, INTER_GROUPE)VALUES('" + NUM_FACTURE + "','" + NUM_JUR_FACT + "','" + SOCIETE + "','" + TYPE + "','" + LOGIN_CREATION + "','" +DATE_CREATION + "','" + LOGIN_MODIFICATION + "','" + DATE_MODIFICATION + "','" + MNT_FACT + "','" + REMISE + "','" + NET_PAYE + "','" + REST_PAYE + "','" + OBSERV + "','" + ID_CLIENT + "','" + REMARQUE + "','" + MONTANTTEXT + "','" + TIMBRE + "','" + AVOIR + "','" + NUM_LISTE + "','" + ID_REV + "','" + NUM_PF + "','" + NUM_PP + "','" + REFERENCE + "','" + CLE + "','" + ID_COM + "','" +MONTANT_COM + "','" + DATE_COM + "','" + RED_COM + "','" + INTER_GROUPE + "')";
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(req, conn);
r = command.ExecuteNonQuery();
facture.NUM_FACTURE = NUM_FACTURE;
facture.NUM_JUR_FACT = NUM_JUR_FACT;
facture.SOCIETE = SOCIETE;
facture.TYPE = TYPE;
facture.LOGIN_CREATION = LOGIN_CREATION;
facture.DATE_CREATION = DATE_CREATION;
facture.LOGIN_MODIFICATION = LOGIN_MODIFICATION;
facture.DATE_MODIFICATION = DATE_MODIFICATION;
facture.MNT_FACT = MNT_FACT;
facture.REMISE = REMISE;
facture.NET_PAYE = NET_PAYE;
facture.REST_PAYE = REST_PAYE;
facture.OBSERV = OBSERV;
facture.ID_CLIENT = ID_CLIENT;
facture.REMARQUE = REMARQUE;
facture.MONTANTTEXT = MONTANTTEXT;
facture.TIMBRE = TIMBRE;
facture.AVOIR = AVOIR;
facture.NUM_LISTE = NUM_LISTE;
facture.ID_REV = ID_CLIENT;
facture.NUM_PF = NUM_PF;
facture.NUM_PP = NUM_PP;
facture.REFERENCE = REFERENCE;
facture.CLE = CLE;
facture.ID_COM = ID_COM;
facture.MONTANT_COM = MONTANT_COM;
facture.DATE_COM = DATE_COM;
facture.RED_COM = RED_COM;
facture.INTER_GROUPE = INTER_GROUPE;
return facture;
}