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; }