public Livraison(string code)
{
InitializeComponent();
facture.FindByKey(code);
labelDateP.Text = facture.Date_Payement.ToLongDateString();
labelModeP.Text = facture.Mode_Payement;
}
private void textBox1_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Escape)
{
this.Close();
}
if (e.KeyCode == Keys.Enter)
{
if (facture.FindByKey(textBox1.Text))
{
if ((facture.Etat == "Non Reglee") || (facture.Livree == "Non Livree"))
{
label9.Visible = false;
Payement p = new Payement(textBox1.Text);
p.ShowDialog(this.Owner);
this.Close();
}
else
{
label9.Visible = true;
label9.Text = "Ticket Trouvee\nReglee le " + facture.Date_Payement.ToLongDateString() + "\n" +
"Livree le " + facture.Date_livraison.ToLongDateString();
}
}
else
{
label9.Visible = true;
label9.Text = "Numeros de Ticket non trouvee ...\nVERIFIEZ !";
}
}
}
public IndoFacture(string Code)
{
InitializeComponent();
Save = false;
currentFacture = new TB_Facture();
currentFacture.FindByKey(Code);
TextCodeFacture.Value = currentFacture.Code;
TextAdresseClient.Value = currentFacture.Client.Adresse;
TextTelClient.Value = currentFacture.Client.NTel;
TextNomClient.Value = currentFacture.Client.Nom;
TextPrenomClient.Value = currentFacture.Client.Prenom;
NumericPrixAvance.Value = currentFacture.Prix_Partiel;
NumericPrixTotal.Value = currentFacture.Prix_Total;
DateRecuFacture.Value = currentFacture.Date_Recu;
DateLivraisonFacutre.Value = currentFacture.Date_livraison;
comboModePayement.Text = currentFacture.Mode_Payement;
DB_PostgreSQL dataBase = new DB_PostgreSQL();
DataSet ARFAC = dataBase.returnDataSet("SELECT \"Code_Article\",\"Libelle\",\"Quantite\",\"Operation\",\"Prix\" FROM \"Articles\",\"Ar_Fac\" WHERE \"Ar_Fac\".\"Code_Facture\"='" + Code + "' AND" +
"\"Articles\".\"Code\"=\"Ar_Fac\".\"Code_Article\"");
c1TrueDBGrid1.DataSource = ARFAC.Tables[0];
DataSet Client = dataBase.returnDataSet("SELECT * FROM \"Client\"");
c1Combo1.DataSource = Client.Tables[0];
c1Combo1.Text = currentFacture.Client.Code;
c1Combo1.DisplayMember = "Code";
c1Label1.Value = currentFacture.Etat;
c1Label2.Value = currentFacture.Livree;
if (currentFacture.Livree == "Non Livree")
{
dateSortie.Visible = false;
}
else
{
dateSortie.Value = currentFacture.Date_livraison;
}
Npgsql.NpgsqlDataReader reader = dataBase.returnDataReader("SELECT * FROM \"Cheque\" WHERE \"Code_Facture\"='" + Code + "'");
if (reader.Read())
{
comboBox1.Text = (string)reader["Banque"];
c1TextBox1.Value = (string)reader["Montant"];
c1TextBox2.Value = (string)reader["Num"];
c1DateEdit1.Value = (DateTime)reader["Date"];
}
}
public Payement(string Code)
{
facture.FindByKey(Code);
InitializeComponent();
labelclient.Text = facture.Client.Nom + " " + facture.Client.Prenom;
labelTel.Text = facture.Client.NTel;
labelDateRecu.Text = facture.Date_Recu.ToShortDateString();
labelAdresse.Text = facture.Client.Adresse;
labelTotal.Text = facture.Prix_Total.ToString();
labelPrixPaye.Text = facture.Prix_Partiel.ToString();
labelTotalPaye.Text = (facture.Prix_Total - facture.Prix_Partiel).ToString();
List <ListAF> s = ListAF.GetList(facture.Code);
foreach (ListAF a in s)
{
listBox1.Items.Add(a.article.Libelle + "\t" + a.article.Famille.Libelle + "\t x" + a.Quantite + "\t" + a.Operation + "\t" + a.Prix + " TND");
}
}