public void insertCit(Citoyen citoyen)
{
Citoyen c1 = new Citoyen();
dataBase = new DataBase();
dataBase.insertCitoyen(c1);
}
private void ok_Btn_Click(object sender, EventArgs e)
{
Citoyen c1 = new Citoyen();
c1.setcin(textcin2.Text);
c1.setNom(textnom.Text);
c1.setPrenom(textprenom.Text);
c1.setAdresse(textadress.Text);
c1.setAge(Convert.ToInt32(textage.Text));
c1.setMaladie_grave(textmalad.Text);
c1.setEtat(Convert.ToInt32(textetat.Text));
metier = new Metier();
metier.insertCit(c1);
}
public void insertCitoyen(Citoyen citoyen)
{
if (OpenConnection())
{
String sql = "INSERT INTO Citoyen(cin,nom,prenom,age,adresse,etat,maladie_grave) VALUES('" + citoyen.getcin() + "','" + citoyen.getNom() + "','" +
citoyen.getPrenom() + "'," + citoyen.getAge() + ",'" + citoyen.getAdresse() + "'," + citoyen.getEtat() + ",'" + citoyen.getMaladie_grave() + "')";
try
{
SqlCommand command = new SqlCommand(sql, con);
command.ExecuteNonQuery();
CloseConnection();
MessageBox.Show("DONE");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
