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