private void submit_Click(object sender, EventArgs e)
{
using (MySqlConnection cn = new MySqlConnection(Program._cn))
{
cn.Open();
if (dataGridViewOptions.SelectedCells.Count > 0)
{
for (int i = 0; i < dataGridViewOptions.SelectedCells.Count; i++)
{
WCFUtils.Option option = new WCFUtils.Option();
MySqlCommand cmd = new MySqlCommand("select caracteristique, prix from toption where NOM_OPTION = '" + dataGridViewOptions.SelectedCells[i].Value.ToString() + "'", cn);
MySqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
option.Nom = dataGridViewOptions.SelectedCells[i].Value.ToString();
option.Prix = Convert.ToInt32(dr["prix"].ToString());
option.Caracteristique = dr["caracteristique"].ToString();
}
dr.Close();
CreateVoiture.listeOptions.Add(option);
}
}
}
this.Close();
}
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);
}
}