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