public ArrayList GetRoles() { ArrayList resultado = new ArrayList(); this.cmd.CommandText = "SELECT ID_ROLE, NAME, DESCRIPTION FROM ROLES"; using (SqlDataReader reader = this.cmd.ExecuteReader()) { while (reader.Read()) { Int16 id_role = -1; string Name = ""; string Description = ""; if (!reader.IsDBNull(0)) { id_role = reader.GetInt16(0); } if (!reader.IsDBNull(1)) { Name = reader.GetString(1); } if (!reader.IsDBNull(2)) { Description = reader.GetString(2); } RoleVO roleVO = new RoleVO(); roleVO.ID = id_role; roleVO.Name = Name; roleVO.Description = Description; resultado.Add(roleVO); } } return resultado; }
public ArrayList GetRoles(string userName) { ArrayList resultado = new ArrayList(); int id_user = -1; this.cmd.CommandText = "SELECT ID_USER FROM USERS WHERE USER_NAME = " + userName; using (SqlDataReader reader = this.cmd.ExecuteReader()) { if (reader.Read()) { if (!reader.IsDBNull(0)) { id_user = reader.GetInt32(0); } } } if (id_user != -1) { this.cmd.CommandText = "SELECT ROLES.ID_ROLE, NAME, DESCRIPTION FROM ROLES INNER JOIN USERS_ROLES ON USERS_ROLES.ID_USER = "******" AND USERS_ROLES.ID_ROLE = ROLES.ID_ROLE"; using (SqlDataReader reader = this.cmd.ExecuteReader()) { if (reader.Read()) { Int16 id_role = -1; string Name = ""; string Description = ""; if (!reader.IsDBNull(0)) { id_role = reader.GetInt16(0); } if (!reader.IsDBNull(1)) { Name = reader.GetString(1); } if (!reader.IsDBNull(2)) { Description = reader.GetString(2); } RoleVO roleVO = new RoleVO(); roleVO.ID = id_role; roleVO.Name = Name; roleVO.Description = Description; resultado.Add(roleVO); } } } return resultado; }