/// <summary>
/// Gets a Nullable Byte value from a SqlDataReader
/// </summary>
/// <param name="DataReader"></param>
/// <param name="FieldName"></param>
/// <returns></returns>
public static byte GetNullableByte(this SqlDataReader DataReader, string FieldName)
{
//Validate Arguments
ArgumentValidation.ValidateSqlDataReader(DataReader, new System.Globalization.CultureInfo("en-GB"));
int Ordinal = DataReader.GetOrdinal(FieldName);
return(DataReader.IsDBNull(Ordinal) ? Convert.ToByte(0) : DataReader.GetByte(Ordinal));
}
/// <summary>
/// Gets a Nullable Int32 value from a SqlDataReader
/// </summary>
/// <param name="DataReader"></param>
/// <param name="FieldName"></param>
/// <returns></returns>
public static Int32 GetNullableInt32(this SqlDataReader DataReader, string FieldName)
{
//Validate Arguments
ArgumentValidation.ValidateSqlDataReader(DataReader, new System.Globalization.CultureInfo("en-GB"));
int Ordinal = DataReader.GetOrdinal(FieldName);
return(DataReader.IsDBNull(Ordinal) ? 0 : DataReader.GetInt32(Ordinal));
}
/// <summary>
/// Instantiates a user setting from a SqlDataReader object
/// </summary>
/// <param name="DataReader">The SqlDataReader object to parse into the UserSetting object</param>
/// <param name="SQLConnector">A GFSqlConnector to the GroundFrame.SQL database</param>
/// <param name="Culture">The culture in which user would receive any exception messages. Defaults to en-GB</param>
public UserSetting(SqlDataReader DataReader, GFSqlConnector SQLConnector, string Culture)
{
//Set the culture
this._Culture = new CultureInfo(string.IsNullOrEmpty(Culture) ? "en-GB" : Culture);
//Validate Arguments
ArgumentValidation.ValidateSqlDataReader(DataReader, this._Culture);
ArgumentValidation.ValidateSQLConnector(SQLConnector, this._Culture);
this._SQLConnector = new GFSqlConnector(SQLConnector);
//Parse DataReader
this.ParseSqlDataReader(DataReader);
}
