public bool AddNewSeries(ComicSeries series)
{
if (GetSeriesByName(series.Name) != null)
{
return(false);
}
var connection = _databaseConnectionManager.GetConnection();
var sql = $"INSERT INTO {ComicSeriesTableStructure.TableName} ({ComicSeriesTableStructure.Id}, {ComicSeriesTableStructure.Name}, {ComicSeriesTableStructure.Publisher}) values ({series.Id}, '{series.Name}', '{series.Publisher}')";
var command = new SQLiteCommand(sql, connection);
connection.Open();
var returnCode = command.ExecuteNonQuery();
connection.Close();
return(returnCode == 1);
}
public bool DeleteSeries(ComicSeries series)
{
if (GetSeriesByName(series.Name) != null)
{
var connection = _databaseConnectionManager.GetConnection();
var sql = $"DELETE FROM {ComicSeriesTableStructure.TableName} WHERE {ComicSeriesTableStructure.Id}={series.Id} AND {ComicSeriesTableStructure.Name}='{series.Name}' AND {ComicSeriesTableStructure.Publisher}='{series.Publisher}'";
var command = new SQLiteCommand(sql, connection);
connection.Open();
var returnCode = command.ExecuteNonQuery();
connection.Close();
return(returnCode == 1);
}
else
{
return(false);
}
}
