private void dgv_liste_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgv_liste.CurrentRow.Cells["id_"].Value != null)
{
Int32 id = Convert.ToInt32(dgv_liste.CurrentRow.Cells["id_"].Value);
if (id > 0)
{
NiveauAcces f = NiveauAccesBLL.One(id);
if (e.ColumnIndex == 3)
{
if (DialogResult.Yes == Messages.Confirmation(Mots.Supprimer.ToLower()))
{
if (NiveauAccesBLL.Delete(f))
{
DeleteRow(f);
Reset();
Messages.Succes();
}
}
}
else
{
Populate(f);
}
}
}
}
catch (Exception ex)
{
Messages.Exception(ex);
}
}
public static Int32 currentNiveauAcces(NiveauAcces f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
String search = "select * from niveau_acces where designation = '" + f.Designation + "' and description = '" + f.Description + "'";
NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
Int32 id = new Int32();
if (lect.HasRows)
{
while (lect.Read())
{
id = (Int32)((lect["id"] != null) ? (!lect["id"].ToString().Trim().Equals("") ? lect["id"] : 0) : 0);
}
}
return(id);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(0);
}
finally
{
Connexion.Deconnection(con);
}
}
public static List <NiveauAcces> listNiveauAcces(string query)
{
NpgsqlConnection con = Connexion.Connection();
try
{
NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
List <NiveauAcces> l = new List <NiveauAcces>();
if (lect.HasRows)
{
while (lect.Read())
{
NiveauAcces y = oneNiveauAcces((Int32)((lect["id"] != null) ? (!lect["id"].ToString().Trim().Equals("") ? lect["id"] : 0) : 0));
l.Add(y);
}
}
return(l);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
public static NiveauAcces oneNiveauAcces(Int32 id)
{
NpgsqlConnection con = Connexion.Connection();
try
{
String search = "select * from niveau_acces where id = " + id;
NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
NiveauAcces y = new NiveauAcces();
if (lect.HasRows)
{
while (lect.Read())
{
y.Id = id;
y.Designation = lect["designation"].ToString();
y.Description = lect["description"].ToString();
y.Update = true;
}
}
return(y);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
private void com_niveau_SelectedIndexChanged(object sender, EventArgs e)
{
NiveauAcces a = com_niveau.SelectedItem as NiveauAcces;
a = niveaux.Find(x => x.Id == a.Id);
current.Niveau = a;
}
private void btn_save_Click(object sender, EventArgs e)
{
Recopie();
if (current.Control())
{
if (!current.Update)
{
NiveauAcces f = NiveauAccesBLL.Save(current);
if (f != null ? f.Id > 0 : false)
{
current.Id = f.Id;
current.Update = true;
AddRow(f);
Messages.Succes();
}
}
else
{
if (NiveauAccesBLL.Update(current))
{
UpdateRow(current);
Messages.Succes();
}
}
Reset();
}
}
public void com_niveau_SelectedIndexChanged(object sender, EventArgs e)
{
NiveauAcces a = com_niveau.SelectedItem as NiveauAcces;
a = niveaux.Find(x => x.Id == a.Id);
current = a;
if (first)
{
LoadFormulaire(a);
}
}
public static bool Delete(NiveauAcces y)
{
try
{
return(NiveauAccesDAO.deleteNiveauAcces(y));
}
catch (Exception ex)
{
throw new Exception("Suppression Impossible", ex);
}
}
public static bool Update(NiveauAcces y)
{
try
{
return(NiveauAccesDAO.updateNiveauAcces(y));
}
catch (Exception ex)
{
throw new Exception("Modification Impossible", ex);
}
}
public static NiveauAcces Save(NiveauAcces y)
{
try
{
return(NiveauAccesDAO.saveNiveauAcces(y));
}
catch (Exception ex)
{
throw new Exception("Insertion Impossible", ex);
}
}
public static Int32 Current(NiveauAcces y)
{
try
{
return(NiveauAccesDAO.currentNiveauAcces(y));
}
catch (Exception ex)
{
throw new Exception("Retour Impossible", ex);
}
}
private void LoadFormulaire(NiveauAcces n)
{
dgv_form.Rows.Clear();
string query = "select * from formulaires order by code";
List <Formulaires> l = FormulairesBLL.List(query);
foreach (Formulaires f in l)
{
f.Update = AutorisationFormulaireBLL.One(AutorisationFormulaireBLL.Current(new AutorisationFormulaire(n, f))).Update;
AddRowFormulaire(f);
}
}
private void LoadRessource(NiveauAcces n, Formulaires f)
{
dgv_ress.Rows.Clear();
string query = "select * from ressources where formulaire = " + f.Id + " order by code";
List <Ressources> l = RessourcesBLL.List(query);
foreach (Ressources r in l)
{
r.Update = AutorisationRessourceBLL.One(AutorisationRessourceBLL.Current(new AutorisationRessource(n, r))).Update;
AddRowRessource(r);
}
}
public static void LoadAcces(NiveauAcces n)
{
string query = "select * from autorisation_formulaire where niveau = " + n.Id;
List <AutorisationFormulaire> lf = AutorisationFormulaireBLL.List(query);
foreach (AutorisationFormulaire af in lf)
{
new AccesFormulaires().Acces(af.Formulaire.Code, af.Update);
}
query = "select * from autorisation_ressource where niveau = " + n.Id;
List <AutorisationRessource> lr = AutorisationRessourceBLL.List(query);
foreach (AutorisationRessource af in lr)
{
new AccesRessources().Acces(af.Ressource.Code, af.Update);
}
}
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 btn_save_Click(object sender, EventArgs e)
{
NiveauAcces f = new NiveauAcces();
f.Designation = txt_designation.Text.Trim();
f.Description = txt_description.Text.Replace("'", "''");
if (f.Control())
{
f = NiveauAccesBLL.Save(f);
if (f != null ? f.Id > 0 : false)
{
current.niveaux.Add(f);
current.com_niveau.Refresh();
current.com_niveau.DataSource = new BindingSource(current.niveaux, null);
current.com_niveau.ResetText();
current.com_niveau.SelectedText = f.Designation;
current.current = f;
this.Close();
}
}
}
public static bool deleteNiveauAcces(NiveauAcces f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string delete = "delete from niveau_acces where id = " + f.Id;
NpgsqlCommand cmd = new NpgsqlCommand(delete, con);
cmd.ExecuteNonQuery();
return(true);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool updateNiveauAcces(NiveauAcces f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string update = "update niveau_acces set designation ='" + f.Designation + "' , description = '" + f.Description + "' where id = " + f.Id;
NpgsqlCommand cmd = new NpgsqlCommand(update, con);
cmd.ExecuteNonQuery();
return(true);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(false);
}
finally
{
Connexion.Deconnection(con);
}
}
public static NiveauAcces saveNiveauAcces(NiveauAcces f)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string insert = "insert into niveau_acces (designation, description, super) values ('" + f.Designation + "','" + f.Description + "','" + f.Super + "')";
NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
cmd.ExecuteNonQuery();
f.Id = currentNiveauAcces(f);
return(f);
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return(null);
}
finally
{
Connexion.Deconnection(con);
}
}
private void dgv_liste_SelectionChanged(object sender, EventArgs e)
{
try
{
if (dgv_liste.Rows.Count > 0)
{
if (dgv_liste.CurrentRow.Cells["id_"].Value != null)
{
Int32 id = (Int32)dgv_liste.CurrentRow.Cells["id_"].Value;
if (id > 0)
{
NiveauAcces f = NiveauAccesBLL.One(id);
Populate(f);
}
}
}
}
catch (Exception ex)
{
Messages.Exception(ex);
}
}
private void AddRow(NiveauAcces y)
{
dgv_liste.Rows.Add(new object[] { y.Id, y.Designation, y.Description, null });
}
private void Reset()
{
txt_description.ResetText();
txt_designation.ResetText();
current = new NiveauAcces();
}
private void Populate(NiveauAcces y)
{
txt_designation.Text = y.Designation;
txt_description.Text = y.Description;
current = y;
}
private void DeleteRow(NiveauAcces f)
{
dgv_liste.Rows.RemoveAt(Utils.GetRowData(dgv_liste, f.Id));
}