private void update(Lapin lapin)
{
using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection()) {
cnx.Open();
using (MySqlCommand cmd = new MySqlCommand("update Lapin set surnom=@surnom,age=@age,position=@position,dossard=@dossard idCourse=@idCourse 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("@position", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@dossard", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@surnom", MySqlDbType.VarChar));
cmd.Parameters["@id"].Value = lapin.Id;
cmd.Parameters["@age"].Value = lapin.Age;
cmd.Parameters["@position"].Value = lapin.GetPosition();
cmd.Parameters["@dossard"].Value = lapin.Dossard;
cmd.Parameters["@surnom"].Value = lapin.GetSurnom();
cmd.ExecuteNonQuery();
}
}
lapin.State = State.unChanged;
}
private void insert(Lapin lapin)
{
using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection()) {
cnx.Open();
using (MySqlCommand cmd = new MySqlCommand("insert into Lapin(surnom,age,position,dossard,idCourse) values(@surnom,@age,@position,@dossard,@idCourse)", cnx)) {
cmd.Parameters.Add(new MySqlParameter("@idCourse", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@age", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@position", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@dossard", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@surnom", MySqlDbType.VarChar));
cmd.Parameters["@id"].Value = lapin.Id;
cmd.Parameters["@age"].Value = lapin.Age;
cmd.Parameters["@position"].Value = lapin.GetPosition();
cmd.Parameters["@dossard"].Value = lapin.Dossard;
cmd.Parameters["@surnom"].Value = lapin.Surnom;
cmd.ExecuteNonQuery();
// Todo coder la récupération de LastId
}
}
lapin.State = State.unChanged;
}