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