private void LoadGrille() { dgv_liste.Rows.Clear(); string query = "select * from niveau_acces where super = false order by id"; List <NiveauAcces> l = NiveauAccesBLL.List(query); foreach (NiveauAcces n in l) { AddRow(n); } Reset(); }
private void LoadAllNiveau() { niveaux.Clear(); string query = "select * from niveau_acces where super = false order by id"; niveaux = NiveauAccesBLL.List(query); com_niveau.DisplayMember = "Designation"; com_niveau.ValueMember = "Id"; com_niveau.DataSource = new BindingSource(niveaux, null); foreach (NiveauAcces f in niveaux) { com_niveau.AutoCompleteCustomSource.Add(f.Designation); } com_niveau.AutoCompleteMode = AutoCompleteMode.SuggestAppend; com_niveau.AutoCompleteSource = AutoCompleteSource.CustomSource; }
private NiveauAcces SuperNiveau() { NiveauAcces n = new NiveauAcces(); string query = "select * from niveau_acces where super = true limit 1"; List <NiveauAcces> l = NiveauAccesBLL.List(query); if (l != null ? l.Count > 0 : false) { n = l[0]; } else { n.Super = true; n.Description = "Super Administrateur"; n.Designation = "Super Administrateur"; n = NiveauAccesBLL.Save(n); } query = "select * from formulaires"; List <Formulaires> lf = FormulairesBLL.List(query); foreach (Formulaires f in lf) { AutorisationFormulaire a = AutorisationFormulaireBLL.One(AutorisationFormulaireBLL.Current(new AutorisationFormulaire(n, f, true))); if (a != null ? a.Id < 1 : true) { AutorisationFormulaireBLL.Save(new AutorisationFormulaire(n, f, true)); } } query = "select * from ressources"; List <Ressources> lr = RessourcesBLL.List(query); foreach (Ressources r in lr) { AutorisationRessource a = AutorisationRessourceBLL.One(AutorisationRessourceBLL.Current(new AutorisationRessource(n, r, true))); if (a != null ? a.Id < 1 : true) { AutorisationRessourceBLL.Save(new AutorisationRessource(n, r, true)); } } return(n); }
private void txt_search_TextChanged(object sender, EventArgs e) { string search = txt_search.Text.Trim(); if (search.Length > 0) { dgv_liste.Rows.Clear(); string query = "select * from niveau_acces where designation like '" + search + "%' or description like '" + search + "%'"; List <NiveauAcces> l = NiveauAccesBLL.List(query); foreach (NiveauAcces f in l) { AddRow(f); } Reset(); } else { LoadGrille(); } }