public Int32 UpdateData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "UPDATE \"Facture\" SET \"Date_Recu\"=:dater, \"Date_Livraison\"=:datel, \"Prix_Total\"=:prixt, \"Prix_Partiel\"=:prixp, \"Code_Client\"=:codec, \"Mode_Payement\"=:modep, \"Etat\"=:etat," +
" \"Livree\"=:livree, \"Date_Sortie\"=:datesortie, \"Date_Payement\"=:datepayement" +
" WHERE \"Code\"=:code";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":code", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":dater", DbType.DateTime));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":datel", DbType.DateTime));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prixt", DbType.Double));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prixp", DbType.Double));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":codec", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":modep", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":etat", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":livree", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":datesortie", DbType.DateTime));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":datepayement", DbType.DateTime));
command.Parameters[0].Value = this.Code;
command.Parameters[1].Value = this.Date_Recu;
command.Parameters[2].Value = this.Date_livraison;
command.Parameters[3].Value = this.Prix_Total;
command.Parameters[4].Value = this.Prix_Partiel;
command.Parameters[5].Value = this.Client.Code;
command.Parameters[6].Value = this.Mode_Payement;
command.Parameters[7].Value = this.Etat;
command.Parameters[8].Value = this.Livree;
command.Parameters[9].Value = this.Date_Sortie;
command.Parameters[10].Value = this.Date_Payement;
return(dataBase.ExecuteCommand(command));
}
public Int32 SaveData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "INSERT INTO \"Facture\" (\"Code\", \"Date_Recu\", \"Date_Livraison\", \"Prix_Total\", \"Prix_Partiel\", \"Code_Client\", \"Mode_Payement\", \"Etat\", \"Livree\", \"Date_Sortie\", \"Date_Payement\" )" +
"VALUES(:code,:date_recu,:date_livraison,:prix_total,:prix_partiel,:code_client,:mode_payement,:etat,:livree,:datesortie,:datepayement)";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":code", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":date_recu", DbType.DateTime));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":date_livraison", DbType.DateTime));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prix_total", DbType.Double));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prix_partiel", DbType.Double));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":code_client", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":mode_payement", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":etat", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":livree", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":datesortie", DbType.DateTime));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":datepayement", DbType.DateTime));
command.Parameters[0].Value = this.Code;
command.Parameters[1].Value = this.Date_Recu;
command.Parameters[2].Value = this.Date_livraison;
command.Parameters[3].Value = this.Prix_Total;
command.Parameters[4].Value = this.Prix_Partiel;
command.Parameters[5].Value = this.Client.Code;
command.Parameters[6].Value = this.Mode_Payement;
command.Parameters[7].Value = this.Etat;
command.Parameters[8].Value = this.Livree;
command.Parameters[9].Value = this.Date_Sortie;
command.Parameters[10].Value = this.Date_Payement;
return(dataBase.ExecuteCommand(command));
}
public Int32 UpdateData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "UPDATE \"Articles\" SET \"Libelle\"=:libelle," +
" \"N_Pieces\"=:npieces," +
" \"Description\"=:description," +
" \"Prix_Pressing\"=:prixpressing," +
" \"Prix_Repassage\"=:prixrepassage," +
" \"Prix_Tenture\"=:prixtenture," +
" \"Prix_Autre\"=:prixautre," +
" \"Code_Famille\"=:codef," +
" \"Photo\"=:photo," +
" \"Pressing\"=:pressing," +
" \"Repassage\"=:repassage," +
" \"Tenture\"=:tenture," +
" \"Autre\"=:autre," +
" \"Print\"=:print" +
" WHERE \"Code\"=:cde";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":cde", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":libelle", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":npieces", DbType.Decimal));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":description", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prixpressing", DbType.Decimal));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prixrepassage", DbType.Decimal));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prixtenture", DbType.Decimal));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prixautre", DbType.Decimal));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":codef", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":photo", DbType.Binary));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":pressing", DbType.Boolean));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":repassage", DbType.Boolean));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":tenture", DbType.Boolean));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":autre", DbType.Boolean));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":print", DbType.Boolean));
command.Parameters[0].Value = this.Code;
command.Parameters[1].Value = this.Libelle;
command.Parameters[2].Value = this.N_Pieces;
command.Parameters[3].Value = this.Description;
command.Parameters[4].Value = this.Prix_Pressing;
command.Parameters[5].Value = this.Prix_Repassage;
command.Parameters[6].Value = this.Prix_Tenture;
command.Parameters[7].Value = this.Prix_Autre;
command.Parameters[8].Value = this.Code_Famille;
command.Parameters[9].Value = this.Photo;
command.Parameters[10].Value = this.Pressing;
command.Parameters[11].Value = this.Repassage;
command.Parameters[12].Value = this.Tenture;
command.Parameters[13].Value = this.Autre;
command.Parameters[14].Value = this.Print;
return(dataBase.ExecuteCommand(command));
}
public Int32 UpdateData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "UPDATE \"Famille\" SET \"Libelle\"=:libelle, \"Description\"=:description WHERE \"Code\"=:code";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":libelle", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":description", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":code", DbType.String));
command.Parameters[0].Value = this.Libelle;
command.Parameters[1].Value = this.Description;
command.Parameters[2].Value = this.Code;
return(dataBase.ExecuteCommand(command));
}
public Int32 SaveData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "INSERT INTO \"Famille\" (\"Code\", \"Libelle\", \"Description\")" +
"VALUES(:code,:libelle,:description)";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":libelle", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":description", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":code", DbType.String));
command.Parameters[0].Value = this.Libelle;
command.Parameters[1].Value = this.Description;
command.Parameters[2].Value = this.Code;
return(dataBase.ExecuteCommand(command));
}
private void buttonOk_Click(object sender, EventArgs e)
{
if (VerifierChamo())
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "INSERT INTO \"Cheque\" (\"Banque\", \"Montant\", \"Date\", \"Num\", \"Code_Facture\") " +
"Values('" + comboBox1.Text + "','" + textBox1.Text + "',:date,'" + textBox2.Text + "','" + CodeFacture + "')";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":date", DbType.DateTime));
command.Parameters[0].Value = dateTimePicker1.Value;
dataBase.ExecuteCommand(command);
((Payement)Owner).regle = true;
this.Close();
}
}
public Int32 UpdateData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "UPDATE \"User\" SET \"Password\"=:password, \"Tel\"=:tel, \"Photo\"=:photo, \"Role\"=:role WHERE \"Login\"='" + this.Login + "'";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":nom", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":password", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":tel", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":photo", DbType.Binary));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":role", DbType.Int16));
command.Parameters[0].Value = this.Login;
command.Parameters[1].Value = this.Password;
command.Parameters[2].Value = this.Tel;
command.Parameters[3].Value = this.Photo;
command.Parameters[4].Value = this.Role;
return(dataBase.ExecuteCommand(command));
}
public Int32 UpdateData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "UPDATE \"Client\" SET \"Nom\"=:nom, \"Prenom\"=:prenom, \"Tel\"=:tel, \"Adresse\"=:adresse WHERE \"Code\"=:code";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":nom", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prenom", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":tel", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":adresse", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":code", DbType.String));
command.Parameters[0].Value = this.Nom;
command.Parameters[1].Value = this.Prenom;
command.Parameters[2].Value = this.NTel;
command.Parameters[3].Value = this.Adresse;
command.Parameters[4].Value = this.Code;
return(dataBase.ExecuteCommand(command));
}
public void saveData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "INSERT INTO \"Ar_Fac\" (\"Code_Article\", \"Code_Facture\", \"Operation\", \"Quantite\", \"Prix\")" +
" VALUES(:codeA,:codeF,:oper,:qua,:prix)";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":codeA", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":codeF", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":oper", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":qua", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prix", DbType.String));
command.Parameters[0].Value = this.Code_Article;
command.Parameters[1].Value = this.Code_Facture;
command.Parameters[2].Value = this.Operation;
command.Parameters[3].Value = this.Quantite;
command.Parameters[4].Value = this.Prix;
dataBase.ExecuteCommand(command);
}
public Int32 SaveData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "INSERT INTO \"User\" (\"Login\",\"Password\",\"Tel\",\"Photo\", \"Role\")" +
"VALUES(:nom,:password,:tel,:photo,:role)";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":nom", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":password", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":tel", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":photo", DbType.Binary));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":role", DbType.Int16));
command.Parameters[0].Value = this.Login;
command.Parameters[1].Value = this.Password;
command.Parameters[2].Value = this.Tel;
command.Parameters[3].Value = this.Photo;
command.Parameters[4].Value = this.Role;
return(dataBase.ExecuteCommand(command));
}
public Int32 SaveData()
{
DB_PostgreSQL dataBase = new DB_PostgreSQL();
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
command.CommandText = "INSERT INTO \"Client\" (\"Code\", \"Nom\", \"Prenom\", \"Tel\", \"Adresse\")" +
"VALUES(:code,:nom,:prenom,:tel,:adresse)";
command.Parameters.Add(new Npgsql.NpgsqlParameter(":nom", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":prenom", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":tel", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":adresse", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":code", DbType.String));
command.Parameters[0].Value = this.Nom;
command.Parameters[1].Value = this.Prenom;
command.Parameters[2].Value = this.NTel;
command.Parameters[3].Value = this.Adresse;
command.Parameters[4].Value = this.Code;
return(dataBase.ExecuteCommand(command));
}
public Int32 SaveData()
{
Npgsql.NpgsqlCommand command = new Npgsql.NpgsqlCommand();
if (!this.existe)
{
command.CommandText = "INSERT INTO \"Info_Societe\" (\"Nom\",\"Adresse\",\"Tel\",\"Fax\",\"Logo\")" +
"VALUES(:nom,:adresse,:tel,:fax,:logo)";
}
else
{
command.CommandText = "UPDATE \"Info_Societe\" SET \"Nom\" =:nom,\"Adresse\"=:adresse, \"Logo\"=:logo, \"Tel\"=:tel, \"Fax\"=:fax";
}
command.Parameters.Add(new Npgsql.NpgsqlParameter(":nom", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":adresse", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":tel", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":fax", DbType.String));
command.Parameters.Add(new Npgsql.NpgsqlParameter(":logo", DbType.Binary));
command.Parameters[0].Value = this.nom;
command.Parameters[1].Value = this.adresse;
command.Parameters[2].Value = this.tel;
command.Parameters[3].Value = this.fax;
command.Parameters[4].Value = this.logo;
return(dataBase.ExecuteCommand(command));
}
