private void txtmt_TextChanged(object sender, EventArgs e)
{
int mt = Int32.Parse(txtmt.Text);
Factures.Modifiermontant(mt, Program.code_f);
Infofacture_Load(null, null);
}
private void Infofacture_Load(object sender, EventArgs e)
{
if (Program.menu != "facture")
{
string st = Factures.creercode_f();
lbltitre.Text = "FACTURE N°" + st + " " + "du";
dataGridView1.DataSource = Program.tabvet;
txttypevetement.DataBindings.Add("Text", Program.tabvet, "TypeVetement");
txtquantite.DataBindings.Add("Text", Program.tabvet, "Quantite");
txtpulavage.DataBindings.Add("Text", Program.tabvet, "PU_lavage");
gbinfoclient.Enabled = false;
montanttotal.Text = Program.montant.ToString();
txtmle.Text = Clients.tableauclient[1];
txtnom.Text = Clients.tableauclient[2];
txtprenom.Text = Clients.tableauclient[3];
txttel.Text = Clients.tableauclient[4];
txtquartier.Text = Clients.tableauclient[5];
}
if (Program.menu == "facture")
{
lbltitre.Text = "FACTURE N°" + Program.code_f + " " + "du";
gbinfoclient.Enabled = false;
dataGridView1.Enabled = false;
string mle = Factures.mleclient(Program.code_f);
string[] infoclient = Clients.infoclient(mle);
txtmle.Text = infoclient[0];
txtnom.Text = infoclient[1];
txtprenom.Text = infoclient[2];
txttel.Text = infoclient[3];
txtquartier.Text = infoclient[4];
txttypevetement.Enabled = false;
txtpulavage.Enabled = false;
dtdatedepot.Enabled = false;
dtdatefacture.Enabled = false;
txtquantite.Enabled = false;
dtdateretraiteff.Enabled = true;
btajouter.Enabled = false;
btretirer.Enabled = false;
btmodifier.Enabled = false;
txtmt.Hide();
//string infovetement = Vetements.infovetement()
string[] infofacture = Factures.infofacture(Program.code_f);
montanttotal.Text = infofacture[1];
lblmontantpayer.Text = infofacture[2];
lblmention.Text = Factures.montantapayer(Program.code_f);
Vetements.tablevetementsfacture.Clear();
Vetements.affichervetementsfacture(Program.code_f);
dataGridView1.DataSource = Vetements.tablevetementsfacture;
}
}
private void btfactures_Click(object sender, EventArgs e)
{
vider();
Factures.afficherdedomages();
dataGridView1.DataSource = Factures.tablesfactures;
btfactures.BackColor = Color.LightSteelBlue;
btclients.BackColor = Color.Transparent;
btvetements.BackColor = Color.Transparent;
btdedomages.BackColor = Color.Transparent;
radioButton1.Text = "Date";
radioButton2.Text = "Client";
radioButton3.Text = "Mention";
btajouterclientele.Text = "Imprimer";
radioButton3.Show();
cbquartier.Show();
bttrier.Location = new Point(582, 34);
}
public static void Ajouterfacture(Factures facture)
{
Program.seConnecter();
MySqlCommand cmd;
cmd = Program.con.CreateCommand();
string req = "INSERT INTO facture VALUES(?code_f, ?montant, ?mention, ?date_creation)";
cmd = new MySqlCommand(req, Program.con);
cmd.Parameters.AddWithValue("?code_f", facture.Code_f);
cmd.Parameters.AddWithValue("?montant", facture.Montant);
cmd.Parameters.AddWithValue("?mention", facture.Mention);
cmd.Parameters.AddWithValue("?date_creation", facture.Date_creation);
cmd.ExecuteNonQuery();
Program.con.Close();
}
private void btfactures_Click(object sender, EventArgs e)
{
Program.menu = "facture";
vider();
gpmodifierclient.Hide();
gpdatagrid1.Size = new Size(700, 307);
dataGridView1.Size = new Size(690, 293);
Factures.afficherfacture();
dataGridView1.DataSource = Factures.tablesfactures;
txtidvet.DataBindings.Clear();
txtidvet.DataBindings.Add("Text", Factures.tablesfactures, "code_f");
btfactures.BackColor = Color.LightSteelBlue;
btclients.BackColor = Color.Transparent;
btvetements.BackColor = Color.Transparent;
btdedomages.BackColor = Color.Transparent;
radioButton1.Text = "Date";
radioButton2.Text = "Client";
radioButton3.Text = "Mention";
btajouterclientele.Text = "Imprimer";
btmodifierclientele.Enabled = true;
radioButton3.Show();
cbquartier.Show();
bttrier.Location = new Point(582, 34);
}
private void button4_Click(object sender, EventArgs e)
{
string code_f = Factures.creercode_f();
Factures facture = new Factures();
facture.Code_f = code_f;
facture.Montant = Program.montant;
facture.Mention = Program.mention;
facture.Date_creation = Program.datemysql(dtdatedepot.Text);
Factures.Ajouterfacture(facture);
switch (Clients.tableauclient[0])
{
case "E":
foreach (DataRow dr in Program.tabvet.Rows)
{
string id = Vetements.creeridentifiant();
string mle = Convert.ToString(dr["MleClient"]);
string idtypvet = Convert.ToString(dr["Idvetement"]);
string libtypvet = Convert.ToString(dr["TypeVetement"]);
int qte = Convert.ToInt32(dr["Quantite"]);
string ddpot = Program.datemysql(dtdatedepot.Text);
string ddispo = Program.datemysql(dtdatedispo.Text);
int veriff = Vetements.verifiercodetypevetement(libtypvet);
if (veriff == 1)
{
Vetements.Enregistrervetement(id, idtypvet, qte, mle, ddpot, ddispo);
Factures.Ajouterlignefacture(code_f, mle, id);
MessageBox.Show("Enregistrement reussie");
}
if (veriff == 0)
{
string cod = Vetements.creercodetypevetement();
string lib = Convert.ToString(dr["TypeVetement"]);
int pu_t = Convert.ToInt32(dr["PU_lavage"]);
int pu_l = Convert.ToInt32(dr["PU_lavage"]);
Vetements.Enregistrertypevetement(cod, lib, pu_t, pu_l);
Vetements.Enregistrervetement(id, cod, qte, mle, ddpot, ddispo);
Factures.Ajouterlignefacture(code_f, mle, id);
MessageBox.Show("Enregistrement reussie");
}
}
break;
case "N":
Clients client = new Clients();
client.Mle = Clients.tableauclient[1];
client.Nom = Clients.tableauclient[2];
client.Prenom = Clients.tableauclient[3];
client.Tel = Convert.ToInt32(Clients.tableauclient[4]);
client.Quartier = Clients.tableauclient[5];
client.Date_ajout = Program.datemysql(dtdatedepot.Text);
Clients.Ajouterclient(client);
foreach (DataRow dr in Program.tabvet.Rows)
{
string id = Vetements.creeridentifiant();
string mle = Convert.ToString(dr["MleClient"]);
string idtypvet = Convert.ToString(dr["Idvetement"]);
string libtypvet = Convert.ToString(dr["TypeVetement"]);
int qte = Convert.ToInt32(dr["Quantite"]);
string ddpot = Program.datemysql(dtdatedepot.Text);
string ddispo = Program.datemysql(dtdatedispo.Text);
int veriff = Vetements.verifiercodetypevetement(libtypvet);
if (veriff == 1)
{
Vetements.Enregistrervetement(id, idtypvet, qte, mle, ddpot, ddispo);
Factures.Ajouterlignefacture(code_f, mle, id);
MessageBox.Show("Enregistrement reussie");
}
if (veriff == 0)
{
string cod = Vetements.creercodetypevetement();
string lib = Convert.ToString(dr["TypeVetement"]);
int pu_t = Convert.ToInt32(dr["PU_lavage"]);
int pu_l = Convert.ToInt32(dr["PU_lavage"]);
Vetements.Enregistrertypevetement(cod, lib, pu_t, pu_l);
Vetements.Enregistrervetement(id, cod, qte, mle, ddpot, ddispo);
Factures.Ajouterlignefacture(code_f, mle, id);
MessageBox.Show("Enregistrement reussie");
}
}
break;
}
}
private void bttrier_Click(object sender, EventArgs e)
{
string d = Factures.creercode_f();
MessageBox.Show(d);
}