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); } }