public static List <Role> GetRoles()
{
string query = "SELECT RoleID, RoleName from Roles";
MySqlCommand cmd = new MySqlCommand(query);
DBConn conn = new DBConn();
MySqlDataReader dr = conn.ExecuteSelectCommand(cmd);
List <Role> roleList = new List <Role>();
while (dr.Read())
{
Role r = new Role((int)dr["RoleID"], (string)dr["RoleName"]);
roleList.Add(r);
}
conn.CloseConnection();
return(roleList);
}
public static Role GetRole(int roleid)
{
string query = "SELECT RoleID, RoleName from Roles WHERE RoleID = @roleid";
MySqlCommand cmd = new MySqlCommand(query);
cmd.Parameters.AddWithValue("@roleId", roleid);
DBConn conn = new DBConn();
MySqlDataReader dr = conn.ExecuteSelectCommand(cmd);
Role role = null;
while (dr.Read())
{
role = new Role((int)dr["RoleID"], (string)dr["RoleName"]);
}
conn.CloseConnection();
return(role);
}
public static string GetRoleName(int roleid)
{
Role r = GetRole(roleid);
return(r.RoleName);
}
