private static void Execute(OleDbConnection connection, InputParameters input) { SetNullsNotOk(connection, input); HashSet <string> validLinks = new HashSet <string>(); foreach (DataRow row in GetNonNullDataRows(connection, input)) { string content = Convert.ToString(row[input.LinkField]); string address = AccessInterface.ExtractAddress(content); if (File.Exists(address)) { Console.WriteLine("Yes: " + address); validLinks.Add(content); } else { Console.WriteLine("No: " + address); } } Console.WriteLine("\nExecuting query..."); string condition = getCondition(input, validLinks); string sqlTrue = $"UPDATE [{input.TableName}] SET [{input.OkField}] = True WHERE {condition}"; AccessInterface.ExecuteUpdateCommand(connection, sqlTrue); string sqlFalse = $"UPDATE [{input.TableName}] SET [{input.OkField}] = False WHERE NOT {condition}"; AccessInterface.ExecuteUpdateCommand(connection, sqlFalse); Console.WriteLine("Query executed"); }
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 void SetNullsNotOk(OleDbConnection connection, InputParameters input) { string sql = $"UPDATE [{input.TableName}] SET [{input.OkField}] = False WHERE [{input.LinkField}] is null"; AccessInterface.ExecuteUpdateCommand(connection, sql); }