public void DeleteBook(string id)
{
var sqlUpdate = $"delete from {_tableName} where {_columnName_ID} = @id";
var parameters = new[] { new SQLiteParameter("@id", id) };
DBSQLiteCommand.ExecuteNonQueryCommand(sqlUpdate, parameters);
}
public List <Book> GetBooks()
{
var sqlSelect = $"select * from {_tableName}";
var result = DBSQLiteCommand.ExecuteReader <Book>(sqlSelect, null, (readerItem =>
{
var item = new Book();
item.FromReader(readerItem);
return(item);
}));
return(result);
}
public DBInfo GetInfo()
{
var sqlFirst = $"select * from {_tableName} limit 1";
var result = DBSQLiteCommand.ExecuteReader <DBInfo>(sqlFirst, null, (readerItem =>
{
var item = new DBInfo();
item.FromReader(readerItem);
return(item);
}));
var info = result.FirstOrDefault();
return(info);
}
public Book GetBook(string id)
{
var sqlFirst = $"select * from {_tableName} where {_columnName_ID} = @id limit 1";
var parameters = new SQLiteParameter[] { new SQLiteParameter("@id", id) };
var result = DBSQLiteCommand.ExecuteReader <Book>(sqlFirst, parameters, (readerItem =>
{
var item = new Book();
item.FromReader(readerItem);
return(item);
}));
var book = result.FirstOrDefault();
return(book);
}
public void UpdateBook(string ID, string Title, string Description, string Abstract, string ISBN, string Author, string Publisher)
{
var sqlUpdate = $"update {_tableName} set {_columnName_Title} = @title, {_columnName_Description} = @desc, {_columnName_Abstract} = @abs, {_columnName_ISBN} = @isbn, {_columnName_Author} = @auth, {_columnName_Publisher} = @pub where {_columnName_ID} = @id";
var parameters = new[] {
new SQLiteParameter("@title", Title),
new SQLiteParameter("@desc", Description),
new SQLiteParameter("@abs", Abstract),
new SQLiteParameter("@isbn", ISBN),
new SQLiteParameter("@auth", Author),
new SQLiteParameter("@pub", Publisher),
new SQLiteParameter("@id", ID)
};
DBSQLiteCommand.ExecuteNonQueryCommand(sqlUpdate, parameters);
}
public void CreateBook(string Title, string Description, string Abstract, string ISBN, string Author, string Publisher)
{
var sqlInsert = $"insert into {_tableName} values(@id, @title, @description, @abstract, @isbn, @author, @publisher, @creationDate)";
var parameters = new[] {
new SQLiteParameter("@id", Guid.NewGuid().ToString()),
new SQLiteParameter("@title", Title),
new SQLiteParameter("@description", Description),
new SQLiteParameter("@abstract", Abstract),
new SQLiteParameter("@isbn", ISBN),
new SQLiteParameter("@author", Author),
new SQLiteParameter("@publisher", Publisher),
new SQLiteParameter("@creationDate", Common.Now)
};
DBSQLiteCommand.ExecuteNonQueryCommand(sqlInsert, parameters);
}
