public static void save(Droits droits)
{
if (droits.Id == 0)
{
OdbcCommand cmd = new OdbcCommand("insert into droits (admin,Tables,Consulter, Ajouter, Modifier, Supprimer) values(?,?,?,?,?,?)", AccesBd.getConnection());
cmd.Parameters.Add("@Admin", OdbcType.VarChar).Value = droits.admin.Numero;
cmd.Parameters.Add("@table", OdbcType.VarChar).Value = droits.Table;
cmd.Parameters.Add("@Consult", OdbcType.VarChar).Value = droits.Consulter;
cmd.Parameters.Add("@ajou", OdbcType.VarChar).Value = droits.Ajouter;
cmd.Parameters.Add("@modif", OdbcType.VarChar).Value = droits.Modifier;
cmd.Parameters.Add("@Suppri", OdbcType.VarChar).Value = droits.Supprimer;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
else
{
OdbcCommand cmd = new OdbcCommand("update droits set admin=?,tables=?,consulter=?, ajouter=?, modifier=?, supprimer=? where Id=?", AccesBd.getConnection());
cmd.Parameters.Add("@Admin", OdbcType.VarChar).Value = droits.admin.Numero;
cmd.Parameters.Add("@table", OdbcType.VarChar).Value = droits.Table;
cmd.Parameters.Add("@Consult", OdbcType.VarChar).Value = droits.Consulter;
cmd.Parameters.Add("@ajou", OdbcType.VarChar).Value = droits.Ajouter;
cmd.Parameters.Add("@modif", OdbcType.VarChar).Value = droits.Modifier;
cmd.Parameters.Add("@Suppri", OdbcType.VarChar).Value = droits.Supprimer;
cmd.Parameters.Add("@id", OdbcType.Int).Value = droits.Id;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
public static List <Droits> findAll()
{
List <Droits> droitss = new List <Droits>();
OdbcCommand cmd = new OdbcCommand("select Id from droits", AccesBd.getConnection());
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Droits droits = find(dr.GetInt32(0));
droitss.Add(droits);
}
cmd.Dispose();
return(droitss);
}
public static Droits findAdmin(string Admin)
{
Droits droits = null;
OdbcCommand cmd = new OdbcCommand("select * from droits where admin=?", AccesBd.getConnection());
cmd.Parameters.Add("@numero", OdbcType.VarChar).Value = Admin;
OdbcDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
droits = new Droits {
Id = dr.GetInt32(0), admin = AdminDao.findByNumero(dr.GetString(1)), Table = dr.GetString(2), Consulter = dr.GetString(3), Ajouter = dr.GetString(4), Modifier = dr.GetString(5), Supprimer = dr.GetString(6)
};
}
cmd.Dispose();
return(droits);
}
public void DataAdminload()
{
List <Admin> Buss = AdminDao.findAll();
int i = 0;
dgAdmin.Rows.Clear();
foreach (Admin bus in Buss)
{
Droits drt = DroitDao.findAdmin(bus.Numero);
dgAdmin.Rows.Add();
dgAdmin.Rows[i].Cells[0].Value = bus.Numero;
dgAdmin.Rows[i].Cells[1].Value = bus.Nom;
dgAdmin.Rows[i].Cells[2].Value = bus.Prenom;
dgAdmin.Rows[i].Cells[3].Value = bus.UserName;
dgAdmin.Rows[i].Cells[4].Value = bus.Password;
dgAdmin.Rows[i].Cells[5].Value = drt.Consulter;
dgAdmin.Rows[i].Cells[6].Value = drt.Ajouter;
dgAdmin.Rows[i].Cells[7].Value = drt.Modifier;
dgAdmin.Rows[i].Cells[8].Value = drt.Supprimer;
i++;
}
}
