private void InsertProduit_Load(object sender, EventArgs e) { lescategories = Categorie.getAllCategories(); cbCategorie.DataSource = lescategories; cbCategorie.DisplayMember = "Nom"; cbCategorie.ValueMember = "Id"; string sql = "SELECT * from image"; try { MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); lesimages = new List <Image>(); while (rdr.Read()) { int id = int.Parse(rdr[0].ToString()); string nom = rdr[1].ToString(); Image img = new Image(id, nom); lesimages.Add(img); } rdr.Close(); cbImage.DataSource = lesimages; cbImage.DisplayMember = "Nom"; cbImage.ValueMember = "Id"; } catch { MessageBox.Show("Erreur de chargement de la liste des Images"); } }
public static List <Categorie> getAllCategories() { List <Categorie> lescategories = new List <Categorie>(); string sql = "SELECT * from categorie"; try { MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); lescategories = new List <Categorie>(); while (rdr.Read()) { int id = int.Parse(rdr[0].ToString()); string nom = rdr[1].ToString(); Categorie cat = new Categorie(id, nom); lescategories.Add(cat); } rdr.Close(); return(lescategories); } catch { return(null); } }
private void load_produit() { lesproduits.Clear(); string sql = "SELECT produit.*, categorie.nom_categorie from produit, categorie WHERE produit.id_categorie = categorie.id_categorie"; MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { Produit ProduitView = new Produit(int.Parse(rdr[0].ToString()), rdr[1].ToString(), rdr[2].ToString(), rdr[3].ToString(), int.Parse(rdr[4].ToString()), float.Parse(rdr[5].ToString()), rdr[8].ToString()); lesproduits.Add(ProduitView); } rdr.Close(); DGVProduit.DataSource = null; DGVProduit.DataSource = lesproduits; }
private void load_client() { lesclients.Clear(); string sql = "Select * from users "; MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { Client ClientView = new Client(int.Parse(rdr[0].ToString()), rdr[1].ToString(), rdr[2].ToString(), rdr[3].ToString(), rdr[4].ToString()); lesclients.Add(ClientView); } rdr.Close(); DGVClient.DataSource = null; DGVClient.DataSource = lesclients; }
private void load_admin() { lesadmins.Clear(); string sql = "Select * from admin"; MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { int roleid = int.Parse(rdr[4].ToString()); User.RoleType role = User.intToRoleType(roleid); User AdminViews = new User(int.Parse(rdr[0].ToString()), rdr[1].ToString(), rdr[2].ToString(), rdr[3].ToString(), role, bool.Parse(rdr[5].ToString())); lesadmins.Add(AdminViews); } rdr.Close(); //DGVAdmin.DataSource = null; DGVAdmin.DataSource = lesadmins; }
private void load_journal() { lesjournaux.Clear(); DateTime dt = DateTime.Now.Subtract(new TimeSpan(3, 0, 0, 0, 0)); string strdate = Journal.dateTimeToSQLString(dt); string sql = $"SELECT username, dateconnect, role, etat from journal, admin WHERE journal.PersonID = admin.id AND dateconnect > '{strdate}' ORDER BY dateconnect DESC"; MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { dt = DateTime.Parse(rdr[1].ToString()); int r = int.Parse(rdr[2].ToString()); bool etat = Boolean.Parse(rdr[3].ToString()); Journal JournalView = new Journal(dt, rdr[0].ToString(), User.intToRoleType(r), etat); lesjournaux.Add(JournalView); } rdr.Close(); DGVJournal.DataSource = null; DGVJournal.DataSource = lesjournaux; }
private void load_commande() { lescommandes.Clear(); string sql = "SELECT * from commande "; MySqlCommand cmd = new MySqlCommand(sql); MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { Commande CommandeView = new Commande(int.Parse(rdr[0].ToString()), rdr[1].ToString(), rdr[2].ToString(), rdr[3].ToString()); int ref_com = int.Parse(rdr[0].ToString()); string date_commande = (rdr[1].ToString()); string id_u = (rdr[2].ToString()); string total = (rdr[3].ToString()); lescommandes.Add(CommandeView); } rdr.Close(); DGVCommande.DataSource = null; DGVCommande.DataSource = lescommandes; }
private void cbProduit_SelectedIndexChanged(object sender, EventArgs e) { Produit produit = cbProduit.SelectedItem as Produit; try { byuser.Clear(); string sql = $"SELECT users.username, panier.qte, commande.date_commande FROM panier, commande, users WHERE panier.ref_com = commande.ref_com AND panier.id_produit = {produit.Id} AND commande.id_u = users.id"; MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { Buy b = new Buy(rdr[0].ToString(), int.Parse(rdr[1].ToString()), DateTime.Parse(rdr[2].ToString())); byuser.Add(b); } rdr.Close(); DGVBuy.DataSource = null; DGVBuy.DataSource = byuser; } catch { MessageBox.Show("La Liste n'a pas pu etre récuperer"); } }
private void load_Produits() { lesproduits.Clear(); try { string sql = "SELECT * FROM produit"; MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { Produit ProduitView = new Produit(int.Parse(rdr[0].ToString()), rdr[1].ToString(), rdr[2].ToString(), rdr[3].ToString(), int.Parse(rdr[4].ToString()), float.Parse(rdr[5].ToString()), null); lesproduits.Add(ProduitView); } rdr.Close(); cbProduit.DataSource = null; cbProduit.DataSource = lesproduits; cbProduit.DisplayMember = "Nom"; cbProduit.ValueMember = "Id"; } catch { MessageBox.Show("Impossible de charger les produits"); } }
public static bool checkUserLocked(string username) { string sql = $"Select locked FROM admin WHERE admin.username = '******' "; try { MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); while (rdr.Read()) { bool locked = bool.Parse(rdr[0].ToString()); if (locked) { rdr.Close(); return(true); } } rdr.Close(); return(false); } catch { } return(false); }
private void btnLogin_Click(object sender, EventArgs e) { if (txtusername.Text == "" || txtpassword.Text == "") { MessageBox.Show("Remplissez tous les champs"); return; } try { string username = txtusername.Text; string pass = txtpassword.Text; pass = SHA.petitsha(pass); if (User.checkUserLocked(username)) { MessageBox.Show("Votre compte a été verouillé suite à 5 tentatives échouées"); this.DialogResult = DialogResult.Cancel; return; } string sql = $"Select id, username, pass, Role from admin where username='******'"; MySqlDataReader rdr = DataBaseUtil.executeSelect(sql); if (rdr.Read()) { labelError.Visible = false; int id = int.Parse(rdr[0].ToString()); string password = rdr[2].ToString(); bool etat = password.Equals(pass.ToLower()); role = int.Parse(rdr[3].ToString()); nomoperateur = rdr[1].ToString(); if (etat) { this.DialogResult = DialogResult.OK; } else { int nbr = -1; if (!dictUserConnexion.TryGetValue(username, out nbr)) { dictUserConnexion.Add(username, 0); } dictUserConnexion[username]++; nbr = dictUserConnexion[username]; if (dictUserConnexion[username] == 5) { User.lockUnlockUser(username, true); } labelError.Visible = true; } rdr.Close(); AjouterJournalConnexion(id, DateTime.Now, etat); } else { labelError.Visible = true; } } catch { } ///this.StrLevel = "Administrateur"; }