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