private static void Clean(OleDbConnection connection, InputParameters input, bool state)
{
string sql = $"UPDATE [{input.TableName}] SET [{input.OkField}] = {state}";
AccessInterface.ExecuteUpdateCommand(connection, sql);
}
private static DataRowCollection GetNonNullDataRows(OleDbConnection connection, InputParameters input)
{
String sql = $"SELECT [{input.LinkField}] FROM [{input.TableName}] WHERE [{input.LinkField}] is not null";
OleDbDataAdapter dataAdapter = AccessInterface.ExecuteSelectCommand(connection, sql);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet, input.TableName);
DataTable table = dataSet.Tables[input.TableName];
return(table.Rows);
}
private static void SetNullsNotOk(OleDbConnection connection, InputParameters input)
{
string sql = $"UPDATE [{input.TableName}] SET [{input.OkField}] = False WHERE [{input.LinkField}] is null";
AccessInterface.ExecuteUpdateCommand(connection, sql);
}
