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; } }