private void btnsubmit_Click(object sender, EventArgs e) { string username = txtusername.Text; string email = txtemail.Text; string password = SHA.petitsha(txtpass.Text); User.RoleType role = User.RoleType.EMPLOYE; if (cbrole.Text == "Employe") { role = User.RoleType.EMPLOYE; } else if (cbrole.Text == "Admin") { role = User.RoleType.ADMIN; } string sql = $"insert into admin (username,email ,pass, Role) Values ('{username}', '{email}','{password}', {User.roleTypeToInt(role)})"; if (DataBaseUtil.executeNonQuery(sql) > 0) { this.DialogResult = DialogResult.OK; } else { MessageBox.Show("User " + username + " exists already"); } }
private void btnSubmit_Click(object sender, EventArgs e) { labelVerif.Visible = false; string Libelle = txtLibelle.Text; string MotsCles = txtMots.Text; string Description = txtdesc.Text; decimal Quantite = nudQuantite.Value; float Prix = float.Parse(txtPrix.Text); NumberFormatInfo nfi = new NumberFormatInfo(); nfi.NumberDecimalSeparator = "."; string strprix = Prix.ToString(nfi); int idcategorie = (cbCategorie.SelectedItem as Categorie).Id; int idimage = (cbImage.SelectedItem as Image).Id; string sql = $"insert into produit (nom_produit, p_motscles, description, qteProduit, prix, id_categorie, id_image) Values ('{Libelle}', '{MotsCles}', '{Description}', {Quantite}, {strprix}, {idcategorie}, {idimage}) "; if (DataBaseUtil.executeNonQuery(sql) > 0) { labelVerif.ForeColor = Color.Green; labelVerif.Visible = true; labelVerif.Text = " Les informations ont bien été enregistrées "; this.DialogResult = DialogResult.OK; } else { MessageBox.Show("Echec d'ajout du produit"); } }
private void AjouterJournalConnexion(int id_admin, DateTime t, bool etat) { string dt = t.ToString("yyyy-MM-dd HH:mm:ss"); string sql = $"INSERT INTO journal (dateconnect, etat, PersonID) VALUES ('{dt}', {etat}, {id_admin})"; if (DataBaseUtil.executeNonQuery(sql) == -1) { MessageBox.Show("Erreur lors de l'insertion dans le journal"); } }
private void btndeleteAdmin_Click(object sender, EventArgs e) { List <User> selected = new List <User>(); foreach (DataGridViewRow row in DGVAdmin.SelectedRows) { selected.Add(lesadmins[row.Index]); //DGVParticipant.Rows.RemoveAt(row.Index); } foreach (User s in selected) { string sql = "DELETE FROM admin WHERE id = " + s.Id; DataBaseUtil.executeNonQuery(sql); } load_admin(); }
private void btnDeleteSalon_Click(object sender, EventArgs e) { List <Produit> selected = new List <Produit>(); foreach (DataGridViewRow row in DGVProduit.SelectedRows) { selected.Add(lesproduits[row.Index]); //DGVParticipant.Rows.RemoveAt(row.Index); } foreach (Produit s in selected) { string sql = "DELETE FROM produit WHERE id_produit = " + s.Id; DataBaseUtil.executeNonQuery(sql); } load_produit(); }
private void btnDeleteParticipant_Click(object sender, EventArgs e) { List <Client> selected = new List <Client>(); foreach (DataGridViewRow row in DGVClient.SelectedRows) { selected.Add(lesclients[row.Index]); //DGVParticipant.Rows.RemoveAt(row.Index); } foreach (Client p in selected) { string sql = "DELETE FROM users WHERE id = '" + p.Id + "'"; DataBaseUtil.executeNonQuery(sql); } load_client(); }
private void btnSubmit_Click(object sender, EventArgs e) { labelVerif.Visible = false; string nom = txtusername.Text; string tel = txttel.Text; string departement = txtadresse.Text; string email = txtemail.Text; string sql = $"insert into users (username, tel, adresse, email) Values ('{nom}', '{tel}', '{departement}', '{email}') "; if (DataBaseUtil.executeNonQuery(sql) > 0) { labelVerif.ForeColor = Color.Green; labelVerif.Visible = true; labelVerif.Text = " Les informations ont bien été enregistrées "; } else { MessageBox.Show("Echec de l'ajout d'un client"); } }
private void DGVParticipant_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (0 <= e.RowIndex && e.RowIndex < lesclients.Count) { Client client = lesclients[e.RowIndex]; string modifiedColumn = null; if (e.ColumnIndex == 1) { modifiedColumn = "username"; client.Pseudo = DGVClient.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } else if (e.ColumnIndex == 2) { modifiedColumn = "tel"; client.Tel = DGVClient.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } else if (e.ColumnIndex == 3) { modifiedColumn = "adresse"; client.Adresse = DGVClient.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } else if (e.ColumnIndex == 4) { modifiedColumn = "email"; client.Email = DGVClient.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } if (modifiedColumn != null) { string sql = $"UPDATE users SET {modifiedColumn} = '{DGVClient.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()}' WHERE id = {client.Id} "; if (DataBaseUtil.executeNonQuery(sql) == -1) { MessageBox.Show("Failed to Update User"); } } } }
private void DGVSalon_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (0 <= e.RowIndex && e.RowIndex < lesproduits.Count) { float prix = -1; Produit produit = lesproduits[e.RowIndex]; string strvalue = null; int intvalue = 0; string modifiedColumn = null; if (e.ColumnIndex == 1) { modifiedColumn = "titre_produit"; strvalue = DGVProduit.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } else if (e.ColumnIndex == 2) { modifiedColumn = "description_courte"; strvalue = DGVProduit.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } else if (e.ColumnIndex == 3) { modifiedColumn = "description_longue"; strvalue = DGVProduit.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); } else if (e.ColumnIndex == 4) { modifiedColumn = "qteProduit"; intvalue = int.Parse(DGVProduit.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()); } else if (e.ColumnIndex == 5) { modifiedColumn = "prix"; prix = float.Parse(DGVProduit.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()); } else if (e.ColumnIndex == 6) { modifiedColumn = "id_categorie"; string tmp = DGVProduit.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); intvalue = Categorie.stringToId(tmp); if (intvalue == 0) { MessageBox.Show("Catégorie introuvable"); return; } } if (modifiedColumn != null) { string sql = null; if (strvalue != null) { sql = $"UPDATE produit SET {modifiedColumn} = '{strvalue}' WHERE id_produit = {produit.Id} "; } else if (prix >= 0) { NumberFormatInfo nfi = new NumberFormatInfo(); nfi.NumberDecimalSeparator = "."; string strprix = prix.ToString(nfi); sql = $"UPDATE produit SET {modifiedColumn} = {strprix} WHERE id_produit = {produit.Id} "; } else { sql = $"UPDATE produit SET {modifiedColumn} = {intvalue} WHERE id_produit = {produit.Id} "; } if (DataBaseUtil.executeNonQuery(sql) == -1) { MessageBox.Show("Failed to Update User"); } } } }
public static bool lockUnlockUser(string username, bool locked) { string sql = $"UPDATE admin SET locked = {locked} WHERE admin.username = '******' AND admin.Role <> 1 "; return(DataBaseUtil.executeNonQuery(sql) > 0); }