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