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