private void Btn_valider_Click(object sender, EventArgs e)
{
switch (this.state)
{
case state.modified:
Gerant g = (Gerant)items[this.position];
g.Age = (Convert.ToInt32(this.tb_age.Text));
g.Prenom = (this.tb_prenom.Text);
g.Nom = (this.tb_nom.Text);
g.Password = (this.tb_pwd.Text);
g.Budget = (Convert.ToInt32(this.tb_bud.Text));
if (this.old == 0)
{
g.State1 = (0);
}
else
{
g.State1 = (this.state);
}
items[this.position] = g;
break;
case state.added:
Gerant ge = new Gerant(tb_nom.Text, tb_prenom.Text, Convert.ToInt32(tb_age.Text), tb_pwd.Text, this.state, Convert.ToInt32(tb_bud.Text), lg.LastID);
this.lg.Add(ge);
items.Add(ge);
break;
}
this.Close();
}
public F_Edit_Gerant(state _state, state _stateInitial, ListBox.ObjectCollection _items, int _position)
{
InitializeComponent();
btn_valider.Click += Btn_valider_Click;
this.state = _state;
this.items = _items;
this.position = _position;
this.old = _stateInitial;
switch (state)
{
case state.modified:
tb_id.Visible = true;
l_id.Visible = true;
Gerant g = (Gerant)items[position];
this.tb_id.Text = g.Id.ToString();
this.tb_age.Text = g.Age.ToString();
this.tb_nom.Text = g.Nom.ToString();
this.tb_pwd.Text = g.Password.ToString();
this.tb_prenom.Text = g.Prenom.ToString();
this.tb_bud.Text = g.Budget.ToString();
this.Text = "Modification d'une Course.";
break;
}
}
private void Btn_Connexion_Click(object sender, EventArgs e)
{
if (btn_modif.Text != "Modifier")
{
Btn_modif_Click(sender, e);
}
if (tb_Password.Text == "")
{
MessageBox.Show("OOPS ! Il n\'y a pas de Password", "Erreur");
return;
}
if (lb_lesGerants.SelectedIndex != -1)
{
int position = lb_lesGerants.SelectedIndex;
Gerant g = (Gerant)lb_lesGerants.Items[position];
if (g.State1 == state.added)
{
Btn_save_Click(sender, e);
}
if (g.State1 == state.deleted)
{
MessageBox.Show("Vous ne pouvez pas vous connectez à un compte delete.", "Erreur de Connexion");
}
if (tb_Password.Text == g.Password)
{
FLesLapins fLesLaps = new FLesLapins(g, this.lesLapins);
fLesLaps.Show();
}
else
{
MessageBox.Show("Vous vous êtes trompés de Password ou de Gérant", "Erreur de Connexion");
}
}
}
private void Btn_delete_Click(object sender, EventArgs e)
{
Gerant g = (Gerant)lb_lesGerants.Items[lb_lesGerants.SelectedIndex];
g.State1 = (state.deleted);
lb_lesGerants.Items[lb_lesGerants.SelectedIndex] = g;
}
public ActionResult DeleteConfirmed(int id)
{
Gerant gerant = db.Gerant.Find(id);
db.Gerant.Remove(gerant);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void Btn_up_Click(object sender, EventArgs e)
{
int position = lb_lesGerants.SelectedIndex;
Gerant gerant = (Gerant)lb_lesGerants.Items[position];
F_Edit_Gerant fedit = new F_Edit_Gerant(state.modified, gerant.State1, lb_lesGerants.Items, position);
fedit.Show();
}
public ActionResult Edit([Bind(Include = "id_ger,nom,prenom,tel,email,password")] Gerant gerant)
{
if (ModelState.IsValid)
{
db.Entry(gerant).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(gerant));
}
public ActionResult Create([Bind(Include = "id_ger,nom,prenom,tel,email,password")] Gerant gerant)
{
if (ModelState.IsValid)
{
db.Gerant.Add(gerant);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(gerant));
}
public void SaveChanges(Gerant gerant)
{
switch (gerant.State1)
{
case state.added:
this.insert(gerant);
break;
case state.modified:
this.update(gerant);
break;
}
}
// GET: Gerant/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Gerant gerant = db.Gerant.Find(id);
if (gerant == null)
{
return(HttpNotFound());
}
return(View(gerant));
}
public static int connexionGerant(string adresseMail, string password)
{
Gerant gerant = ControleurGerant.recuperGerantParMail(adresseMail);
if (gerant == null)
{
return(-1);
}
else if (gerant.Password.Equals(password))
{
return(1);
}
else
{
return(0);
}
}
public static Gerant recuperGerantParMail(string adresseMail)
{
Gerant gerant = null;
conn.Open();
MySqlCommand query = new MySqlCommand("SELECT * FROM ladi.DSMSpersonne WHERE adresseMail='" + adresseMail + "'", conn);
using (MySqlDataReader reader = query.ExecuteReader())
{
while (reader.Read())
{
gerant = new Gerant(reader.GetString(1), reader.GetString(2), Outils.convertirStringToDateTime(reader.GetString(3)), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7));
}
}
conn.Close();
return(gerant);
}
private void delete(Gerant gerant)
{
using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection())
{
cnx.Open();
using (MySqlCommand cmd = new MySqlCommand("update lapin set idGerant= null where idGerant=@idGerant", cnx))
{
cmd.Parameters.Add(new MySqlParameter("@idGerant", MySqlDbType.Int32));
cmd.Parameters["@idGerant"].Value = gerant.Id;
cmd.ExecuteNonQuery();
}
using (MySqlCommand cmd = new MySqlCommand("delete from gerant where id=@id", cnx))
{
cmd.Parameters.Add(new MySqlParameter("@id", MySqlDbType.Int32));
cmd.Parameters["@id"].Value = gerant.Id;
cmd.ExecuteNonQuery();
}
}
}
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 <Gerant> gerant)
{
for (int i = 0; i < gerant.Count; i++)
{
Gerant gerants = gerant[i];
switch (gerants.State1)
{
case state.added:
this.insert(gerants);
break;
case state.modified:
this.update(gerants);
break;
case state.deleted:
this.delete(gerants);
gerant.Remove(gerants);
break;
}
}
}
private void update(Gerant gerant)
{
using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection())
{
cnx.Open();
using (MySqlCommand cmd = new MySqlCommand("update Gerant set age=@age, nom=@nom, prenom=@prenom, budget=@budget 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("@nom", MySqlDbType.VarChar));
cmd.Parameters.Add(new MySqlParameter("@prenom", MySqlDbType.VarChar));
cmd.Parameters.Add(new MySqlParameter("@budget", MySqlDbType.Int32));
cmd.Parameters["@budget"].Value = gerant.Budget;
cmd.Parameters["@id"].Value = gerant.Id;
cmd.Parameters["@age"].Value = gerant.Age;
cmd.Parameters["@nom"].Value = gerant.Nom;
cmd.Parameters["@prenom"].Value = gerant.Prenom;
cmd.ExecuteNonQuery();
}
}
gerant.State1 = (state.unChanged);
}
private void insert(Gerant gerant)
{
using (MySqlConnection cnx = DaoConnectionSingleton.GetMySqlConnection())
{
cnx.Open();
using (MySqlCommand cmd = new MySqlCommand("insert into gerant(nom,prenom,age,pwd,budget) values(@nom,@prenom,@age,@pwd,@budget)", cnx))
{
cmd.Parameters.Add(new MySqlParameter("@age", MySqlDbType.Int32));
cmd.Parameters.Add(new MySqlParameter("@nom", MySqlDbType.VarChar));
cmd.Parameters.Add(new MySqlParameter("@prenom", MySqlDbType.VarChar));
cmd.Parameters.Add(new MySqlParameter("@pwd", MySqlDbType.VarChar));
cmd.Parameters.Add(new MySqlParameter("@budget", MySqlDbType.Int32));
cmd.Parameters["@budget"].Value = gerant.Budget;
cmd.Parameters["@age"].Value = gerant.Age;
cmd.Parameters["@nom"].Value = gerant.Nom;
cmd.Parameters["@prenom"].Value = gerant.Prenom;
cmd.Parameters["@pwd"].Value = gerant.Password;
cmd.ExecuteNonQuery();
}
}
gerant.State1 = (state.unChanged);
}
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());
}
public FLesLapins(Gerant entraineur, List <Lapins> lesLapins)
{
this.idGerant = entraineur.Id;
this.lEntraineur = entraineur;
this.lp = new lesLapins();
this.lapinASave = new List <Lapins>();
this.tousLesLapins = new List <Lapins>();
InitializeComponent();
btn_gen.Click += Btn_gen_Click;
btn_bannir.Click += Btn_bannir_Click;
btn_add.Click += Btn_add_Click;
btn_modif.Click += Btn_modif_Click;
lb_mesLapins.SelectedIndexChanged += Lb_mesLapins_SelectedIndexChanged;
btn_Details.Click += Btn_Details_Click;
btn_stat.Click += Btn_stat_Click;
btn_save.Click += Btn_save_Click;
btn_Inscrire.Click += Btn_Inscrire_Click;
this.FormClosed += FLesLapins_FormClosed;
load(lesLapins);
this.l_budget.Text = this.lEntraineur.Budget.ToString() + " $";
this.l_place.Text = (5 - lb_mesLapins.Items.Count).ToString() + " / 5";
}
//cas similaire à un client
public static void enregistrerGerant(string nom, string prenom, DateTime dateNaissance, string adresse, string telephone, string adresseMail, string password)
{
Gerant gerant = new Gerant(nom, prenom, dateNaissance, adresse, telephone, adresseMail, password);
conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO ladi.DSMSpersonne(nom,prenom,dateNaissance,adresse,telephone,adresseMail,password,type) VALUES(@nom,@prenom,@dateNaissance,@adresse,@telephone,@adresseMail,@password,@type)";
cmd.Parameters.AddWithValue("@nom", gerant.Nom);
cmd.Parameters.AddWithValue("@prenom", gerant.Prenom);
cmd.Parameters.AddWithValue("@dateNaissance", gerant.DateNaissance);
cmd.Parameters.AddWithValue("@adresse", gerant.Adresse);
cmd.Parameters.AddWithValue("@telephone", gerant.Telephone);
cmd.Parameters.AddWithValue("@adresseMail", gerant.AdresseMail);
cmd.Parameters.AddWithValue("@password", gerant.Password);
cmd.Parameters.AddWithValue("@type", TypePersonne.GERANT);
cmd.ExecuteNonQuery();
conn.Close();
Console.WriteLine("gerant ajouté");
}
