private void Btn_gen_Click(object sender, EventArgs e) { for (int i = 0; i < 5; i++) { Lapins a = new Lapins(lp.LastID, "a", state.added, 0); this.lp.Add(a); lb_LapinsLibres.Items.Add(a); } }
private void Lb_mesLapins_SelectedIndexChanged(object sender, EventArgs e) { if (lb_mesLapins.SelectedIndex == -1) { tb_sur.Text = " "; return; } Lapins unLapinAMoi = (Lapins)lb_mesLapins.Items[lb_mesLapins.SelectedIndex]; tb_sur.Text = unLapinAMoi.GetSurnom(); }
private void Btn_modif_Click(object sender, EventArgs e) { Lapins leLapin = (Lapins)lb_mesLapins.Items[lb_mesLapins.SelectedIndex]; leLapin.SetSurnom(tb_sur.Text); if (leLapin.GetState() == state.unChanged || leLapin.GetState() == state.modified) { leLapin.SetState(state.modified); } lb_mesLapins.Items.RemoveAt(lb_mesLapins.SelectedIndex); lb_mesLapins.Items.Add(leLapin); }
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 Btn_bannir_Click(object sender, EventArgs e) { if (lb_mesLapins.SelectedIndex == -1) { return; } Lapins a = (Lapins)lb_mesLapins.Items[lb_mesLapins.SelectedIndex]; a.SetState(state.modified); a.SetIdGerant(0); string val = Regex.Replace(this.l_budget.Text, "[^0-9.]", ""); this.l_budget.Text = (Convert.ToInt32(val) + (a.Valeur / 2)).ToString() + " $"; lb_mesLapins.Items.RemoveAt(lb_mesLapins.SelectedIndex); lb_LapinsLibres.Items.Add(a); this.l_place.Text = (5 - lb_mesLapins.Items.Count).ToString() + " / 5"; }
private void insert(Lapins lapin) { using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection()) { cnx.Open(); if (lapin.GetIdGerant() == 0) { using (MySqlCommand cmd = new MySqlCommand("insert into Lapin(surnom,age,vitesse,endurance,chance) values(@surnom,@age,@vitesse,@endurance,@chance)", cnx)) { cmd.Parameters.Add(new MySqlParameter("@surnom", MySqlDbType.VarChar)); cmd.Parameters.Add(new MySqlParameter("@age", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@vitesse", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@endurance", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@chance", MySqlDbType.Int32)); cmd.Parameters["@surnom"].Value = lapin.GetSurnom(); cmd.Parameters["@age"].Value = lapin.GetAge(); cmd.Parameters["@vitesse"].Value = lapin.Vitesse; cmd.Parameters["@endurance"].Value = lapin.Endurance; cmd.Parameters["@chance"].Value = lapin.Chance; cmd.ExecuteNonQuery(); } } else { using (MySqlCommand cmd = new MySqlCommand("insert into Lapin(surnom,age,vitesse,endurance,chance,idGerant) values(@surnom,@age,@vitesse,@endurance,@chance,@idGerant)", cnx)) { cmd.Parameters.Add(new MySqlParameter("@surnom", MySqlDbType.VarChar)); cmd.Parameters.Add(new MySqlParameter("@age", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@vitesse", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@endurance", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@chance", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@idGerant", MySqlDbType.Int32)); cmd.Parameters["@surnom"].Value = lapin.GetSurnom(); cmd.Parameters["@age"].Value = lapin.GetAge(); cmd.Parameters["@vitesse"].Value = lapin.Vitesse; cmd.Parameters["@endurance"].Value = lapin.Endurance; cmd.Parameters["@chance"].Value = lapin.Chance; cmd.Parameters["@idGerant"].Value = lapin.GetIdGerant(); cmd.ExecuteNonQuery(); } } } lapin.SetState(state.unChanged); }
private void Btn_add_Click(object sender, EventArgs e) { Lapins leLapin = (Lapins)this.lb_LapinsLibres.Items[lb_LapinsLibres.SelectedIndex]; if (lb_mesLapins.Items.Count == 5) { return; } if (leLapin.OffreMinimal == 0) { MessageBox.Show("Ce Lapin a déjà été démarché."); lb_LapinsLibres.Items.RemoveAt(lb_LapinsLibres.SelectedIndex); return; } F_Encheres f_Encheres = new F_Encheres(this.lEntraineur, lb_mesLapins.Items, lb_LapinsLibres.Items, lb_LapinsLibres.SelectedIndex, l_place, l_budget); f_Encheres.Show(); }
public F_Encheres(Gerant _unGerant, ListBox.ObjectCollection _itemsLapinsEquipe, ListBox.ObjectCollection _itemLapinsLibres, int _pos, Label count, Label budget) { InitializeComponent(); btn_refresh.Click += F_Encheres_Click; btn_valider.Click += Btn_valider_Click; tb_offre.TextChanged += Tb_offre_TextChanged; this.position = _pos; this.unGerant = _unGerant; this.itemLapinsLibres = _itemLapinsLibres; this.itemsLapinsEquipe = _itemsLapinsEquipe; this.leLapin = (Lapins)this.itemLapinsLibres[this.position]; this.items_Count = count; this.gerantBudget = budget; this.l_vitesse.Text = this.leLapin.Vitesse.ToString(); this.l_endurance.Text = this.leLapin.Endurance.ToString(); this.l_chance.Text = this.leLapin.Chance.ToString(); this.l_leLapin.Text = this.leLapin.ToString(); this.l_offreA.Text = this.leLapin.OffreMinimal.ToString() + " $"; this.l_valeurL.Text = this.leLapin.Valeur.ToString() + " $"; this.l_prixMax.Text = (this.leLapin.Valeur * 1.10).ToString() + " $"; }
public void SaveChanges(List <Lapins> lapins) { for (int i = 0; i < lapins.Count; i++) { Lapins lapin = lapins[i]; switch (lapin.GetState()) { case state.added: this.insert(lapin); break; case state.modified: this.update(lapin); break; case state.deleted: this.delete(lapin); lapins.Remove(lapin); break; } } }
public F_lesCourses() { InitializeComponent(); this.lc = new LesCourses(); this.lesCourses = new List <Course>(); this.lesNouveauxParticipants = new List <Participer>(); this.lesP = new List <Participer>(); btn_lancer.Click += Btn_lancer_Click; btn_quit.Click += Btn_quit_Click; btn_desinscrire.Visible = false; btn_inscription.Visible = false; cb_lesCourses.SelectedIndexChanged += Cb_lesCourses_SelectedIndexChanged; btn_create.Click += Btn_create_Click; btn_save.Click += Btn_save_Click; btn_inscription.Visible = false; this.l_lap.Visible = false; this.tb_leLapin.Visible = false; this.l_bud.Visible = false; this.l_budR.Visible = false; this.leLap = null; this.load(new DaoCourse().GetAll(), new DaoParticiper().GetAll()); }
public F_lesCourses(Lapins unLapin, Gerant g) { InitializeComponent(); lc = new LesCourses(); this.leG = g; this.leLap = unLapin; tb_leLapin.Text = this.leLap.ToString(); this.lesP = new List <Participer>(); this.lc = new LesCourses(); this.lesNouveauxParticipants = new List <Participer>(); btn_inscription.Click += Btn_inscription_Click; btn_desinscrire.Click += Btn_desinscrire_Click; btn_quit.Click += Btn_quit_Click; cb_lesCourses.SelectedIndexChanged += Cb_lesCourses_SelectedIndexChanged; btn_lancer.Visible = false; btn_create.Visible = false; btn_desinscrire.Visible = false; btn_inscription.Visible = false; btn_save.Click += Btn_save_Click; this.l_bud.Text = this.leG.Budget.ToString() + " $"; this.load(new DaoCourse().GetAll(), new DaoParticiper().GetAll()); }
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); }