internal static User GetUser(List<User> users, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_USER_ID);
int value = reader.GetInt32(colIndex);
User user = users.Where(c => c.ID == value).FirstOrDefault();
if (user == null)
{
user = new User();
users.Add(user);
}
return user;
}