private void DoDeleteCommand(SQLiteConnection sqlcon, SQLDeleteTable table)
{
CommandPerformed = $"{table.GetSqlWithParameters()}{Environment.NewLine}{table.GetParamList().ToString()}{Environment.NewLine}";
SQLPerformed = table.GetSql();
try
{
SqliteConnection db = sqlcon.GetConnection();
using (SqliteCommand command = db.CreateCommand())
{
command.CommandText = table.GetSqlWithParameters();
List <SqliteParameter> Params = GetCommandParameters(table.GetParamList());
if (Params.Count > 0)
{
foreach (var p in Params)
{
command.Parameters.Add(p);
}
}
command.ExecuteNonQuery();
Success = true;
}
}
catch
{
Success = false;
}
}
/// <summary>
/// Constructor that takes the table name, there where values that are to be used delete the matching records. It can also take a bool value to delete everything
/// </summary>
/// <param name="sqlcon"></param>
/// <param name="TableName"></param>
/// <param name="WhereFields"></param>
/// <param name="deleteallrecords"></param>
public SQLiteDelete(SQLiteConnection sqlcon, string TableName, SQLWhereVars WhereFields, bool deleteallrecords = false)
{
SQLDeleteTable table = new SQLDeleteTable(TableName, WhereFields, deleteallrecords);
DoDeleteCommand(sqlcon, table);
}
/// <summary>
/// Constructor that takes the database connection and the delete table that contains the information for the command
/// </summary>
/// <param name="sqlcon"></param>
/// <param name="table"></param>
public SQLiteDelete(SQLiteConnection sqlcon, SQLDeleteTable table)
{
DoDeleteCommand(sqlcon, table);
}
