/// <summary>
 /// Gets the roles.
 /// </summary>
 /// <param name="userID">The user ID.</param>
 /// <returns></returns>
 private List<string> getRoles(int userID)
 {
     RolesTableAdapter rta = new RolesTableAdapter();
     var roles = rta.GetDataByUserID(userID);
     return (from p in roles select p.Role).ToList();
 }