internal static Role GetRole(List<Role> roles, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_ROLE_ID);
int value = reader.GetInt32(colIndex);
Role role = roles.Where(c => c.ID == value).FirstOrDefault();
if (role == null)
{
role = new Role();
roles.Add(role);
}
return role;
}