private void delete(Lapins lapin)
{
using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection())
{
cnx.Open();
using (MySqlCommand cmd = new MySqlCommand("delete from Lapin where id=@id", cnx))
{
cmd.Parameters.Add(new MySqlParameter("@id", MySqlDbType.Int32));
cmd.Parameters["@id"].Value = lapin.GetId();
cmd.ExecuteNonQuery();
}
}
}
private void update(Lapins lapin)
{
using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection())
{
cnx.Open();
if (lapin.GetIdGerant() == 0)
{
using (MySqlCommand cmd = new MySqlCommand("update Lapin set surnom=@surnom,age=@age, idGerant=NULL where id=@id", cnx))
{
cmd.Parameters.Add(new MySqlParameter("@id", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@age", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@surnom", MySqlDbType.VarChar));
cmd.Parameters["@id"].Value = lapin.GetId();
cmd.Parameters["@age"].Value = lapin.GetAge();
cmd.Parameters["@surnom"].Value = lapin.GetSurnom();
cmd.ExecuteNonQuery();
}
}
else
{
using (MySqlCommand cmd = new MySqlCommand("update Lapin set surnom=@surnom,age=@age,idGerant=@idGerant where id=@id", cnx))
{
cmd.Parameters.Add(new MySqlParameter("@id", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@age", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@idGerant", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@surnom", MySqlDbType.VarChar));
cmd.Parameters["@id"].Value = lapin.GetId();
cmd.Parameters["@age"].Value = lapin.GetAge();
cmd.Parameters["@surnom"].Value = lapin.GetSurnom();
cmd.Parameters["@idGerant"].Value = lapin.GetIdGerant();
cmd.ExecuteNonQuery();
}
}
}
lapin.SetState(state.unChanged);
}
private void Btn_inscription_Click(object sender, EventArgs e)
{
if (cb_lesCourses.SelectedIndex == -1)
{
return;
}
Course c = (Course)cb_lesCourses.Items[cb_lesCourses.SelectedIndex];
if (c.Depart)
{
c.Add(this.leLap);
lb_lapinsInscrits.Items.Add(this.leLap);
this.lesNouveauxParticipants.Add(new Participer(c.GetId(), leLap.GetId(), 0, state.added));
btn_inscription.Visible = false;
btn_desinscrire.Visible = true;
}
}
