private void btAjouterCategorie_Click(object sender, EventArgs e) // Ajouter { Requete_Sql = "insert into categorie values (null,null)"; sc.AjoutSupModifProduitSql(Requete_Sql); Requete_Sql = "select * from categorie"; List <ServiceWCF.ClsStockProduit> TableCateg = new List <ServiceWCF.ClsStockProduit>(); TableCateg.AddRange(sc.LireCategorieSql(Requete_Sql)); dgvArticle.DataSource = TableCateg; dgvArticle.Columns["Id"].Visible = false; }
private void FormCatalogue_Load(object sender, EventArgs e) { sc = new ServiceWCF.Service1Client(); Requete_Sql = @"select * from categorie"; List <ServiceWCF.ClsStockProduit> TableCateg = new List <ServiceWCF.ClsStockProduit>(); TableCateg.AddRange(sc.LireCategorieSql(Requete_Sql)); dgvCategorie.DataSource = TableCateg; dgvCategorie.Columns["id"].DisplayIndex = 0; dgvCategorie.Columns["nom_produit"].DisplayIndex = 1; dgvCategorie.Columns["description"].DisplayIndex = 2; dgvCategorie.Columns["prix_vente"].DisplayIndex = 3; dgvCategorie.Columns["quantite_stock"].DisplayIndex = 4; dgvCategorie.Columns["somme"].DisplayIndex = 5; dgvCategorie.Columns["id_categorie"].DisplayIndex = 6; dgvCategorie.Columns["id_fournisseur"].DisplayIndex = 7; dgvCategorie.Columns["id"].Visible = false; dgvCategorie.Columns["nom_produit"].Visible = false; dgvCategorie.Columns["description"].Visible = false; dgvCategorie.Columns["prix_vente"].Visible = false; dgvCategorie.Columns["quantite_stock"].Visible = false; dgvCategorie.Columns["somme"].Visible = false; dgvCategorie.Columns["id_categorie"].Visible = false; dgvCategorie.Columns["id_fournisseur"].Visible = false; Requete_Sql = @"select * from produit"; List <ServiceWCF.ClsStockProduit> TableProduit = new List <ServiceWCF.ClsStockProduit>(); TableProduit.AddRange(sc.LireStockProduitSql(Requete_Sql)); dgvArticle.DataSource = TableProduit; dgvArticle.Columns["id"].DisplayIndex = 0; dgvArticle.Columns["nom_produit"].DisplayIndex = 1; dgvArticle.Columns["description"].DisplayIndex = 2; dgvArticle.Columns["prix_vente"].DisplayIndex = 3; dgvArticle.Columns["quantite_stock"].DisplayIndex = 4; dgvArticle.Columns["somme"].DisplayIndex = 5; dgvArticle.Columns["id_categorie"].DisplayIndex = 6; dgvArticle.Columns["id_fournisseur"].DisplayIndex = 7; dgvArticle.Columns["id"].Visible = false; dgvArticle.Columns["somme"].Visible = false; dgvArticle.Columns["nom_categorie"].Visible = false; if (PageAcceuil.ConfirmationConnection == true) { switch (PageAcceuil.Id_Statut) { case 1: // client { btPanier.Visible = true; btAjouterCategorie.Visible = false; dgvArticle.ReadOnly = true; dgvArticle.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dgvCategorie.ReadOnly = true; break; } case 2: // employé { switch (PageAcceuil.Service) { case "Informatique": { btPanier.Visible = true; btAjouterCategorie.Visible = true; dgvArticle.ReadOnly = false; dgvArticle.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect; dgvCategorie.ReadOnly = false; break; } case "Gestion": case "Magasin": { btPanier.Visible = false; btAjouterCategorie.Visible = true; dgvArticle.ReadOnly = false; dgvArticle.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect; dgvCategorie.ReadOnly = false; break; } default: { btPanier.Visible = false; btAjouterCategorie.Visible = false; dgvArticle.ReadOnly = false; dgvArticle.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dgvCategorie.ReadOnly = false; break; } } break; } } } else { btPanier.Visible = false; dgvArticle.ReadOnly = true; dgvCategorie.ReadOnly = true; } }