private void btnValider_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
WCFUtils.ServiceClient client = new WCFUtils.ServiceClient();
WCFUtils.Client cli = new WCFUtils.Client();
if (txtNom.Text != "")
{
cli.Nom = txtNom.Text;
if (txtMail.Text != "")
{
cli.Mail = txtMail.Text;
}
if (txtTel.Text != "")
{
cli.Tel = txtTel.Text;
}
}
using (MySqlConnection cn = new MySqlConnection(Program._cn))
{
cn.Open();
for (int i = 0; i < dataGridViewClients.SelectedCells.Count; i++)
{
MySqlCommand cmd = new MySqlCommand("select NOM_CLIENT, TEL, MAIL from tclient where NOM_CLIENT = '" + dataGridViewClients.SelectedCells[i].Value + "'", cn);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cli = new WCFUtils.Client {
Mail = dr["MAIL"].ToString(), Nom = dr["NOM_CLIENT"].ToString(), Tel = dr["TEL"].ToString()
};
}
dr.Close();
}
}
bool resultat = client.creerModelAvecFacture(vehicule, cli);
if (!resultat)
{
MessageBox.Show("Une erreur s'est produite, veuillez réessayer", "Erreur",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
Cursor = Cursors.Default;
this.Dispose();
}
}
private void btnCreateDevis_Click(object sender, EventArgs e)
{
Cursor = Cursors.WaitCursor;
WCFUtils.ServiceClient client = new WCFUtils.ServiceClient();
WCFUtils.Client cli = new WCFUtils.Client();
if (txtNom.Text != "")
{
cli.Nom = txtNom.Text;
if (txtMail.Text != "")
{
cli.Mail = txtMail.Text;
}
if (txtTel.Text != "")
{
cli.Tel = txtTel.Text;
}
}
using (MySqlConnection cn = new MySqlConnection(Program._cn))
{
cn.Open();
for (int i = 0; i < dataGridViewClients.SelectedCells.Count; i++)
{
MySqlCommand cmd = new MySqlCommand("select NOM_CLIENT, TEL, MAIL from tclient where NOM_CLIENT = '" + dataGridViewClients.SelectedCells[i].Value + "'", cn);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
cli = new WCFUtils.Client {
Mail = dr["MAIL"].ToString(), Nom = dr["NOM_CLIENT"].ToString(), Tel = dr["TEL"].ToString()
};
}
dr.Close();
}
string idDevis = client.CreerModel(vehicule, cli);
MySqlCommand cmd2 = new MySqlCommand("select id_vehicule from tvehicule where id_devis=" + idDevis, cn);
MySqlDataReader dr2 = cmd2.ExecuteReader();
if (dr2.Read())
{
client.SortieUsine(Convert.ToInt32(dr2[0]), "0");
}
}
Cursor = Cursors.Default;
this.Dispose();
}
private void dataGridViewVoiture_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
dataGridViewOptions.DataSource = null;
WCFUtils.ServiceClient cli = new WCFUtils.ServiceClient();
string plaque = dataGridViewVoiture.Rows[e.RowIndex].Cells[0].Value.ToString();
int idFacture = -1;
using (MySqlConnection cn = new MySqlConnection(Program._cn))
{
cn.Open();
MySqlCommand cmd = new MySqlCommand("select tfacture.ID_FACTURE as idFacture from tfacture, tvehicule where tvehicule.PLAQUE = '" + plaque + "' and tfacture.ID_DEVIS = tvehicule.ID_DEVIS ", cn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
idFacture = Convert.ToInt32(dr["idFacture"]);
}
}
WCFUtils.Option[] listeOptions = cli.listeOptions(idFacture.ToString());
dataGridViewOptions.DataSource = listeOptions;
}
private void Submit_Click(object sender, EventArgs e)
{
if (!comboBoxTypes.Text.Equals("") && !comboBoxMarques.Text.Equals("") && !comboBoxModeles.Text.Equals("") && listeOptions != null && listeOptions.Count > 0)
{
WCFUtils.ServiceClient client = new WCFUtils.ServiceClient();
WCFUtils.Option[] options = new WCFUtils.Option[listeOptions.Count];
WCFUtils.Vehicule vehicule = new WCFUtils.Vehicule();
if (listeOptions.Count > 0)
{
using (MySqlConnection cn = new MySqlConnection(Program._cn))
{
cn.Open();
for (int i = 0; i < listeOptions.Count; i++)
{
MySqlCommand cmd = new MySqlCommand("select caracteristique, prix, NOM_OPTION from toption where NOM_OPTION = '" + listeOptions[i].Nom + "'", cn);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
options[i] = new WCFUtils.Option {
Caracteristique = dr["caracteristique"].ToString(), Nom = dr["NOM_OPTION"].ToString(), Prix = Convert.ToInt32(dr["prix"])
};
vehicule.Options = options;
}
dr.Close();
}
}
}
vehicule.Marque = comboBoxMarques.Text;
vehicule.Categorie = comboBoxTypes.Text;
vehicule.Model = comboBoxModeles.Text;
SelectClient select = new SelectClient(vehicule);
select.Show();
this.Dispose();
}
else
{
MessageBox.Show("Veuillez remplir tous les champs", "Erreur",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void onLoad()
{
using (MySqlConnection cn = new MySqlConnection(Program._cn))
{
cn.Open();
MySqlCommand cmd = new MySqlCommand("select NOM_CATEGORIE from tcategorie", cn);
MySqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBoxTypes.Items.Add(dr["NOM_CATEGORIE"].ToString());
}
dr.Close();
cmd.CommandText = "select NOM_MARQUE from tmarque";
dr = cmd.ExecuteReader();
while (dr.Read())
{
comboBoxMarques.Items.Add(dr["NOM_MARQUE"].ToString());
}
dr.Close();
}
if (listeOptions.Count != 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("nomOption");
foreach (WCFUtils.Option nom in listeOptions)
{
dt.Rows.Add(nom.Nom);
}
dataGridViewOptions.DataSource = dt;
WCFUtils.ServiceClient client = new WCFUtils.ServiceClient();
txtPrix.Text = client.calculerpix(listeOptions.ToArray()).ToString() + " €";
}
else
{
dataGridViewOptions.DataSource = null;
}
}
