Advertisement
Guest User

Untitled

a guest
Feb 17th, 2017
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. listAccounts.Add(new Account { Username = "acc1", Password = "123", Roles = new String[] {"superadmin", "admin", "employee"} });
  2. listAccounts.Add(new Account { Username = "acc2", Password = "123", Roles = new String[] {"admin", "employee"} });
  3. listAccounts.Add(new Account { Username = "acc3", Password = "123", Roles = new String[] {"employee"} });
  4.  
  5. public AccountModel() {
  6. DataTable dt_usuarios = new DataTable();
  7. DataTable dt_roles = new DataTable();
  8. String sql = "SELECT username,password FROM usuarios";
  9. conexion.conectar();
  10. MySqlDataAdapter datos = new MySqlDataAdapter(sql, conexion.con);
  11. datos.Fill(dt_usuarios);
  12. List<String> roles_list = new List<String>();
  13. foreach (DataRow user_name in dt_usuarios.Rows)
  14. {
  15. String sql_roles = "SELECT r.rol FROM roles r,userroles ur,usuarios u WHERE u.username='" + user_name[0].ToString() + "' AND u.id_usuarios=ur.id_usuarios AND ur.id_roles=r.id_roles";
  16. MySqlDataAdapter datos_roles = new MySqlDataAdapter(sql_roles, conexion.con);
  17. datos_roles.Fill(dt_roles);
  18. foreach (DataRow roles_user in dt_roles.Rows)
  19. {
  20. roles_list.Add(roles_user[0].ToString());
  21. }
  22.  
  23. listAccounts.Add(new Account { Username = user_name[0].ToString(), Password = user_name[1].ToString(), Roles = new String[] { roles_list } });
  24. }
  25. conexion.cerrar();
  26. //listAccounts.Add(new Account { Username = "acc1", Password = "123", Roles = new String[] {"superadmin", "admin", "employee"} });
  27. //listAccounts.Add(new Account { Username = "acc2", Password = "123", Roles = new String[] {"admin", "employee"} });
  28.  
  29. //listAccounts.Add(new Account { Username = "acc3", Password = "123", Roles = new String[] {"employee"} });
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement