public static List<UserData> toUsers(this MySqlDataReader reader)
{
if (reader.HasRows)
{
List<UserData> results = new List<UserData>();
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
UserData u = new UserData();
u.ID = reader.GetInt32(Define.user_id);
u.Full_Name = reader.GetString(Define.user_full_name);
u.Permision = Permision.Read(reader.GetString(Define.user_permision));
u.Status = reader.GetBoolean(Define.user_status);
u.Type = reader.GetInt32(Define.user_type);
u.Time = reader.GetDateTime(Define.user_time);
u.setDirectpass(reader.GetString(Define.user_pass));
try
{
u.Comment = reader.GetString(Define.user_content);
}
catch (Exception)
{
}
try
{
u.Phone = reader.GetString(Define.user_phone);
}
catch (Exception)
{
}
try
{
u.Email = reader.GetString(Define.user_email);
}
catch (Exception)
{
}
u.User_Name = reader.GetString(Define.user_name);
results.Add(u);
}
}
return results;
}
return null;
}
public static UserData toUser(this MySqlDataReader reader)
{
UserData u = null;
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
u = new UserData();
u.ID = reader.GetInt32(Define.user_id);
u.Full_Name = reader.GetString(Define.user_full_name);
u.Permision = Permision.Read(reader.GetString(Define.user_permision));
u.Status = reader.GetBoolean(Define.user_status);
u.Type = reader.GetInt32(Define.user_type);
u.Time = reader.GetDateTime(Define.user_time);
u.User_Name = reader.GetString(Define.user_name);
u.setDirectpass(reader.GetString(Define.user_pass));
try
{
u.Comment = reader.GetString(Define.user_content);
}
catch (Exception)
{
}
try
{
u.Phone = reader.GetString(Define.user_phone);
}
catch (Exception)
{
}
try
{
u.Email = reader.GetString(Define.user_email);
}
catch (Exception)
{
}
try
{
u.Finger_Print = new byte[10*1024*1024];
long bytesRead=reader.GetBytes(reader.GetOrdinal(Define.user_finger_print), 0, u.Finger_Print, 0, u.Finger_Print.Length);
Console.WriteLine(bytesRead + " bytes downloaded from table to file.");
}
catch (Exception)
{
}
}
}
return u;
}