Drinks Online

To Do

Notes

Auto Errors

Save

Image Sizes:
	Drink:
		-Details		160x250
		-Thumb			60x135

Profile:
		-Profile photo		50x50

//Test sql query call empty you bar search
USE [drinks_online_3.x_sandbox]
GO

DECLARE @IngredientsList nvarchar_list_tbltype
INSERT INTO @IngredientsList VALUES (1)
INSERT INTO @IngredientsList VALUES (2)
INSERT INTO @IngredientsList VALUES (3)

DECLARE	@return_value int

EXEC	@return_value = [dbo].[Drink_GetDrinksWithIngredientsSorted]
		@Ingredients = @IngredientsList,
		@OrderBy = 0,
		@PageIndex = 0,
		@RowsPerPage = 30,
		@Variation = 255,
		@Language = N'en'

SELECT	'Return Value' = @return_value

//vDrink_Ingredients
WITH XMLNAMESPACES (DEFAULT 'http://schemas.datacontract.org/2004/07/Drinks_Online.Drinks') 
SELECT        
	Id, Drink, [Data],
	[Data].value('(/DrinkIngredient/MeasurementAmount)[1]', 'nvarchar(100)') AS MeasurementAmount,
	[Data].value('(/DrinkIngredient/NoAmount)[1]', 'nvarchar(100)') AS NoAmount,
	[Data].value('(/DrinkIngredient/_ingredientId)[1]', 'nvarchar(100)') AS IngredientId,
	[Data].value('(/DrinkIngredient/_languageCode)[1]', 'nvarchar(2)') AS LanguageCode,
	[Data].value('(/DrinkIngredient/_measurementId)[1]', 'nvarchar(100)') AS MeasurementId,
	[Data].value('(/DrinkIngredient/Title)[1]', 'nvarchar(100)') AS Title
FROM            
	dbo.Drink_Ingredients