ÿþIF (CHARINDEX('4.2', @@version) > 0 OR

    CHARINDEX('6.00', @@version) > 0 OR

    CHARINDEX('6.50', @@version) > 0 )



/* Switch to master database  */



USE master

GO



/* Switch to new database  */



USE Ch10TaraStoreSQL

GO



set quoted_identifier on



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AddCatSQL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[AddCatSQL]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CategoryList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[CategoryList]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FilterDataGrid]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[FilterDataGrid]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ProductsBySubCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[ProductsBySubCategory]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SingleProductByProductID]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[SingleProductByProductID]

GO



if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SubCategoryByCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[SubCategoryByCategory]

GO

 

SET QUOTED_IDENTIFIER ON 

GO

SET ANSI_NULLS ON 

GO



CREATE PROCEDURE dbo.AddCatSQL

(

@CatName nvarchar(50),

@CatImage nvarchar(50),

@CatThumb nvarchar(50),

@CatDesc ntext,

@CatID int OUTPUT

)

AS

INSERT INTO Categories

(CategoryName, CatImage, Thumbnail, Description)

VALUES (@CatName, @CatImage, @CatThumb, @CatDesc)

SELECT

@CatID = @@Identity

RETURN

GO

SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO



SET QUOTED_IDENTIFIER ON 

GO

SET ANSI_NULLS ON 

GO



CREATE PROCEDURE dbo.CategoryList

	AS

SELECT *

	FROM Categories

	ORDER BY CategoryID ASC

RETURN  

GO

SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO



SET QUOTED_IDENTIFIER ON 

GO

SET ANSI_NULLS ON 

GO



CREATE PROCEDURE dbo.FilterDataGrid 

    @MySearchTerm nvarchar(20)

AS

SELECT *

FROM Products

WHERE (ModelName LIKE @MySearchTerm )

ORDER BY ModelName

RETURN



GO

SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO



SET QUOTED_IDENTIFIER ON 

GO

SET ANSI_NULLS ON 

GO



CREATE PROCEDURE dbo.ProductsBySubCategory

	@SubCategoryID int

AS

SELECT *

	FROM Products

	WHERE SubCategoryID = @SubCategoryID

	ORDER BY ModelName

RETURN

GO

SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO



SET QUOTED_IDENTIFIER ON 

GO

SET ANSI_NULLS ON 

GO



CREATE PROCEDURE dbo.SingleProductByProductID

	@ProductID int 

AS

SELECT *

	FROM Products

	WHERE ProductID = @ProductID

	ORDER BY ModelName

RETURN

GO

SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO



SET QUOTED_IDENTIFIER ON 

GO

SET ANSI_NULLS ON 

GO



CREATE PROCEDURE dbo.SubCategoryByCategory

 	@CategoryID int

AS

SELECT *

	FROM SubCategories

	WHERE CategoryID = @CategoryID

	ORDER BY SubCategoryID

RETURN

GO





SET QUOTED_IDENTIFIER OFF 

GO

SET ANSI_NULLS ON 

GO