private void comboBoxEtat_Validating(object sender, CancelEventArgs e)
{
if (cBEtat.Text != "")
{
int i = 0; bool b = false;
while ((i < cBEtat.Items.Count) && (b == false))
{
if (((structEtat)cBEtat.Items[i]).Etat.Equals(cBEtat.Text))
b = true;
else
i++;
}
if (b == false)
{
DialogResult a = MessageBox.Show("Voulez vous rajouter l'etat", "choix", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (a == DialogResult.Yes)
{
if (MaConnexion.ExecuteUpdate(connectionString, "insert into Etat (DesigEtat,rowguid) values ('" + cBEtat.Text + "',NEWID())") == 1)
{
DataSet dataset = MaConnexion.ExecuteSelect(connectionString,"select max(idEtat) from Etat");
structEtat strEt = new structEtat(dataset.Tables[0].Rows[0][0].ToString(),cBEtat.Text);
cBEtat.Items.Add(strEt);
cBEtat.SelectedItem = cBEtat.Items[cBEtat.Items.Count-1];
}
}
else
cBEtat.Text = "";
}
}
}
private void chargerEtat()
{
//chargement des etats des biens
String requete = "select * from etat";
DataSet dataSet = MaConnexion.ExecuteSelect(connectionString, requete);
if (dataSet != null)
{
foreach (DataRow row in dataSet.Tables[0].Rows)
{
structEtat str = new structEtat(row[0].ToString(), row[1].ToString());
cBEtat.Items.Add(str);
}
}
}
