public void ChangeQuantity(int id, int quantity)
{
var conn = dbAccessor.OpenConnection();
dbAccessor.ExecuteQuery(String.Format("UPDATE[BooksForAppoo].[dbo].[Books] SET quantity = {1} WHERE id = {0}", id, quantity), conn);
dbAccessor.CloseConnection(conn);
}
public void BuyBook(int id)
{
var conn = dbAccessor.OpenConnection();
dbAccessor.ExecuteQuery(String.Format("UPDATE[BooksForAppoo].[dbo].[Books] SET quantity = quantity - 1 WHERE id = {0}", id), conn);
dbAccessor.CloseConnection(conn);
}
public void ShowCatalog()
{
var conn = dbAccessor.OpenConnection();
var cmd = dbAccessor.ExecuteQuery("Select * From Books", conn);
catalogPrinter.PrintBooksForManager(cmd);
dbAccessor.CloseConnection(conn);
}
