private void LoadByUserModelDataRow(DataRow dataRow) { this.ID = MySQLDBCommon.GetValueIntFromSql(GetDatabaseTableFieldName(dataRow, nameof(this.ID))); this.UID = MySQLDBCommon.GetValueStringFromSql(GetDatabaseTableFieldName(dataRow, nameof(this.UID))); this.FirstName = MySQLDBCommon.GetValueStringFromSql(GetDatabaseTableFieldName(dataRow, nameof(this.FirstName))); this.LastName = MySQLDBCommon.GetValueStringFromSql(GetDatabaseTableFieldName(dataRow, nameof(this.LastName))); this.EmailAddress = MySQLDBCommon.GetValueStringFromSql(GetDatabaseTableFieldName(dataRow, nameof(this.EmailAddress))); }
public UserModel(int id) : base(MySqlConnectionString.ConnectionString) { DataTable DataTable = _MySQLDBStateless.ExecDataTable($"SELECT * FROM {this.TableName()} WHERE {MySQLDBStateless.GetDatabaseTableFieldName(this, nameof(this.ID))} = {MySQLDBCommon.SetValueForSql(id)}"); if (DataTable.Rows.Count == 1) { LoadByUserModelDataRow(DataTable.Rows[0]); } }