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