public static int CheckInventory(int productID) { InventoryModel data = new InventoryModel { ProductID = productID }; string sql = @"select sum(QTY) from dbo.inventory WHERE ProductID = @ProductID"; var inventory = SqlDataAccess.QueryScalar(sql, data); return(inventory); }