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