/// <summary>
/// Converts given column of given row to boolean value. "YES" string
/// interpreted as True and "NO" as False. Over values interpreted as
/// Null. Works with default data row version.
/// </summary>
/// <param name="row">DataRow with values to check.</param>
/// <param name="column">Column name.</param>
/// <returns>
/// Returns True, if value of given column of given row equivalent to "YES",
/// False, if value of given column of given row equivalent to "NO", and
/// Null otherwise.
/// </returns>
public static SqlBoolean GetSqlBool(DataRow row, string column)
{
if (row == null)
{
throw new ArgumentNullException("row");
}
if (String.IsNullOrEmpty(column))
{
throw new ArgumentException(Resources.Error_EmptyString, "column");
}
return(DataInterpreter.GetSqlBool(row, column, DataRowVersion.Default));
}
/// <summary>
/// Writes given expression to given string builder if value in given column
/// of given data row is equivalent to False.
/// </summary>
/// <param name="row">Data row to extract value.</param>
/// <param name="column">Column name to look for value.</param>
/// <param name="expression">Expression to write to string builder.</param>
/// <param name="target">String builder to write.</param>
public static void WriteIfFalse(DataRow row, string column, string expression, StringBuilder target)
{
if (row == null)
{
throw new ArgumentNullException("row");
}
if (String.IsNullOrEmpty(column))
{
throw new ArgumentException(Resources.Error_EmptyString, "column");
}
if (target == null)
{
throw new ArgumentNullException("target");
}
if (!DataInterpreter.GetSqlBool(row, column))
{
target.Append(expression);
}
}