public static int GetReaderIntField(SqlDataReader reader, string fieldname, DBReaderAction actionOnError, int defaultValue)
{
try
{
return(reader.GetInt32(reader.GetOrdinal(fieldname)));
}
catch (Exception)
{
if (actionOnError == DBReaderAction.DBReaderSetDefaultValue)
{
return(defaultValue);
}
else
{
throw;
}
}
}
public static bool GetReaderBoolField(SqlDataReader reader, string fieldname, DBReaderAction actionOnError)
{
return(GetReaderBoolField(reader, fieldname, actionOnError, false));
}
public static bool GetReaderBoolField(SqlDataReader reader, string fieldname, DBReaderAction actionOnError, bool defaultValue)
{
try
{
return(reader.GetBoolean(reader.GetOrdinal(fieldname)));
}
catch (Exception)
{
if (actionOnError == DBReaderAction.DBReaderSetDefaultValue)
{
return(defaultValue);
}
else
{
throw;
}
}
}
public static string GetReaderStringField(SqlDataReader reader, string fieldname, DBReaderAction actionOnError)
{
return(GetReaderStringField(reader, fieldname, actionOnError, null));
}
public static int GetReaderIntField(SqlDataReader reader, string fieldname, DBReaderAction actionOnError)
{
return(GetReaderIntField(reader, fieldname, actionOnError, 0));
}
public static DateTime GetReaderDateTimeField(SqlDataReader reader, string fieldname, DBReaderAction actionOnError)
{
return(GetReaderDateTimeField(reader, fieldname, actionOnError, DateTime.MinValue));
}
