Home page of abdulahad - www.Geocities.ws

USE [Horticulture]GO/****** Object: StoredProcedure [dbo].[usp_VideosSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_VideosSelect]   @videoid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [videoid], [Cropid], [Videourl] FROM [dbo].[Videos] WHERE ([videoid] = @videoid OR @videoid IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_VideosInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_VideosInsert]   @Cropid int, @Videourl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Videos] ([Cropid], [Videourl]) SELECT @Cropid, @Videourl -- Begin Return Select <- do not remove SELECT [videoid], [Cropid], [Videourl] FROM [dbo].[Videos] WHERE [videoid] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_VideosUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_VideosUpdate]   @videoid int, @Cropid int, @Videourl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Videos] SET [Cropid] = @Cropid, [Videourl] = @Videourl WHERE [videoid] = @videoid -- Begin Return Select <- do not remove SELECT [videoid], [Cropid], [Videourl] FROM [dbo].[Videos] WHERE [videoid] = @videoid -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_VideosSelectll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_VideosSelectll]  AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [videoid], [Cropid], [Videourl] FROM [dbo].[Videos]
COMMITGO/****** Object: Table [dbo].[Subjects] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Subjects]( [SubjectId] [int] IDENTITY(1,1) NOT NULL, [Subject] [varchar](250) NULL, [SubjectDescription] [varchar](max) NULL, CONSTRAINT [PK_Subjects] PRIMARY KEY CLUSTERED ( [SubjectId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[Prodtech] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Prodtech]( [ProdTechId] [int] IDENTITY(1,1) NOT NULL, [ProdtechTitle] [varchar](400) NULL, [ProdTechDesc] [varchar](max) NULL, [ProdtechImage] [varchar](300) NULL, CONSTRAINT [PK_Prodtech] PRIMARY KEY CLUSTERED ( [ProdTechId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[Categories] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Categories]( [Categoryid] [int] IDENTITY(1,1) NOT NULL, [Category] [varchar](200) NULL, CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED ( [Categoryid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[Events] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Events]( [id] [int] IDENTITY(1,1) NOT NULL, [Title] [varchar](300) NULL, [EventDescription] [varchar](max) NULL, CONSTRAINT [PK_Events] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[NewsFeed] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[NewsFeed]( [Newsid] [int] IDENTITY(1,1) NOT NULL, [Tilte] [varchar](250) NULL, [Newsdetail] [varchar](max) NULL, [EntryDate] [datetime] NULL, CONSTRAINT [PK_NewsFeed] PRIMARY KEY CLUSTERED ( [Newsid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[Users] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Users]( [id] [int] IDENTITY(1,1) NOT NULL, [LoginName] [varchar](200) NULL, [Password] [varchar](50) NULL, CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ( [id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: StoredProcedure [dbo].[usp_VideosDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_VideosDelete]   @videoid intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Videos] WHERE [videoid] = @videoid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_VideosbyCropId] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_VideosbyCropId]   @Cropid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [videoid], [Cropid],[Videourl], '~\books\' + [Videourl] as VideoFile ,'false' as autoplay FROM [dbo].[Videos] WHERE ([Cropid] = @Cropid )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_UsersUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_UsersUpdate]   @id int, @LoginName varchar(200), @Password varchar(50)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Users] SET [LoginName] = @LoginName, [Password] = @Password WHERE [id] = @id -- Begin Return Select <- do not remove SELECT [id], [LoginName], [Password] FROM [dbo].[Users] WHERE [id] = @id -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_UsersSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_UsersSelect]   @id INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [id], [LoginName], [Password] FROM [dbo].[Users] WHERE ([id] = @id OR @id IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_Userslogin] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_Userslogin]   @loginname varchar(200), @password varchar(50)AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [id], [LoginName], [Password] FROM [dbo].[Users] WHERE ([LoginName] = @loginname and [Password] = @password)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_UsersInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_UsersInsert]   @LoginName varchar(200), @Password varchar(50)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Users] ([LoginName], [Password]) SELECT @LoginName, @Password -- Begin Return Select <- do not remove SELECT [id], [LoginName], [Password] FROM [dbo].[Users] WHERE [id] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_UsersDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_UsersDelete]   @id intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Users] WHERE [id] = @id
COMMITGO/****** Object: StoredProcedure [dbo].[usp_Userschangepasword] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_Userschangepasword]       @LoginName varchar(200), @Password varchar(50)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Users] SET [LoginName] = @LoginName, [Password] = @Password WHERE [LoginName] = @LoginName -- Begin Return Select <- do not remove SELECT [id], [LoginName], [Password] FROM [dbo].[Users] WHERE [LoginName] = @LoginName -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_SubjectsUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_SubjectsUpdate]   @SubjectId int, @Subject varchar(250), @SubjectDescription varchar(MAX)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Subjects] SET [Subject] = @Subject, [SubjectDescription] = @SubjectDescription WHERE [SubjectId] = @SubjectId -- Begin Return Select <- do not remove SELECT [SubjectId], [Subject], [SubjectDescription] FROM [dbo].[Subjects] WHERE [SubjectId] = @SubjectId -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_SubjectsSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_SubjectsSelectAll]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [SubjectId], [Subject], [SubjectDescription] FROM [dbo].[Subjects]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_SubjectsSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_SubjectsSelect]   @SubjectId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [SubjectId], [Subject], [SubjectDescription] FROM [dbo].[Subjects] WHERE ([SubjectId] = @SubjectId OR @SubjectId IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_SubjectsInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_SubjectsInsert]   @Subject varchar(250), @SubjectDescription varchar(MAX)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Subjects] ([Subject], [SubjectDescription]) SELECT @Subject, @SubjectDescription -- Begin Return Select <- do not remove SELECT [SubjectId], [Subject], [SubjectDescription] FROM [dbo].[Subjects] WHERE [SubjectId] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_SubjectsDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_SubjectsDelete]   @SubjectId intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Subjects] WHERE [SubjectId] = @SubjectId
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ProdtechUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ProdtechUpdate]   @ProdTechId int, @ProdtechTitle varchar(400), @ProdTechDesc varchar(MAX)  AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Prodtech] SET [ProdtechTitle] = @ProdtechTitle, [ProdTechDesc] = @ProdTechDesc WHERE [ProdTechId] = @ProdTechId -- Begin Return Select <- do not remove SELECT [ProdTechId], [ProdtechTitle], [ProdTechDesc], [ProdtechImage] FROM [dbo].[Prodtech] WHERE [ProdTechId] = @ProdTechId -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ProdtechSelectAllfordisplay] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_ProdtechSelectAllfordisplay]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [ProdTechId], [ProdtechTitle], [ProdTechDesc], '~\images\' + [ProdtechImage] AS imageurl FROM [dbo].[Prodtech]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ProdtechSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ProdtechSelectAll]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [ProdTechId], [ProdtechTitle], [ProdTechDesc], [ProdtechImage] FROM [dbo].[Prodtech]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ProdtechSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ProdtechSelect]   @ProdTechId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [ProdTechId], [ProdtechTitle], [ProdTechDesc], [ProdtechImage] FROM [dbo].[Prodtech] WHERE ([ProdTechId] = @ProdTechId OR @ProdTechId IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ProdtechInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ProdtechInsert]   @ProdtechTitle varchar(400), @ProdTechDesc varchar(MAX), @ProdtechImage varchar(300)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Prodtech] ([ProdtechTitle], [ProdTechDesc], [ProdtechImage]) SELECT @ProdtechTitle, @ProdTechDesc, @ProdtechImage -- Begin Return Select <- do not remove SELECT [ProdTechId], [ProdtechTitle], [ProdTechDesc], [ProdtechImage] FROM [dbo].[Prodtech] WHERE [ProdTechId] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_ProdtechDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ProdtechDelete]   @ProdTechId intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Prodtech] WHERE [ProdTechId] = @ProdTechId
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventsSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventsSelectAll]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [id], [Title], [EventDescription] FROM [dbo].[Events]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventsSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventsSelect]   @id INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [id], [Title], [EventDescription] FROM [dbo].[Events] WHERE ([id] = @id OR @id IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventsInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventsInsert]   @Title varchar(300), @EventDescription varchar(MAX)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Events] ([Title], [EventDescription]) SELECT @Title, @EventDescription -- Begin Return Select <- do not remove SELECT [id], [Title], [EventDescription] FROM [dbo].[Events] WHERE [id] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventsDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventsDelete]   @id intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Events] WHERE [id] = @id
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CategoriesUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CategoriesUpdate]   @Categoryid int, @Category varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Categories] SET [Category] = @Category WHERE [Categoryid] = @Categoryid -- Begin Return Select <- do not remove SELECT [Categoryid], [Category] FROM [dbo].[Categories] WHERE [Categoryid] = @Categoryid -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CategoriesSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate PROC [dbo].[usp_CategoriesSelectAll]     AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Categoryid], [Category] FROM [dbo].[Categories]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CategoriesSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CategoriesSelect]   @Categoryid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Categoryid], [Category] FROM [dbo].[Categories] WHERE ([Categoryid] = @Categoryid OR @Categoryid IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CategoriesInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CategoriesInsert]   @Category varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Categories] ([Category]) SELECT @Category -- Begin Return Select <- do not remove SELECT [Categoryid], [Category] FROM [dbo].[Categories] WHERE [Categoryid] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_CategoriesDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CategoriesDelete]   @Categoryid intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Categories] WHERE [Categoryid] = @Categoryid
COMMITGO/****** Object: Table [dbo].[EventImages] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[EventImages]( [imageid] [int] IDENTITY(1,1) NOT NULL, [Eventid] [int] NULL, [ImageUrl] [varchar](200) NULL, CONSTRAINT [PK_EventImages] PRIMARY KEY CLUSTERED ( [imageid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[Forum] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Forum]( [ForumId] [int] IDENTITY(1,1) NOT NULL, [SubjectId] [int] NULL, [Title] [varchar](500) NULL, [Detail] [varchar](max) NULL, CONSTRAINT [PK_Forum] PRIMARY KEY CLUSTERED ( [ForumId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[Crops] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Crops]( [Cropid] [int] IDENTITY(1,1) NOT NULL, [Description] [varchar](max) NULL, [fertigation] [varchar](max) NULL, [Weather] [varchar](200) NULL, [Disease] [varchar](700) NULL, [CropTitle] [varchar](200) NULL, [Categoryid] [int] NOT NULL, [HarvestingTime] [varchar](1000) NULL, [Ripetime] [varchar](1000) NULL, [CropImage] [varchar](500) NULL, CONSTRAINT [PK_Crops] PRIMARY KEY CLUSTERED ( [Cropid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: StoredProcedure [dbo].[usp_EventsUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventsUpdate]   @id int, @Title varchar(300), @EventDescription varchar(MAX)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Events] SET [Title] = @Title, [EventDescription] = @EventDescription WHERE [id] = @id -- Begin Return Select <- do not remove SELECT [id], [Title], [EventDescription] FROM [dbo].[Events] WHERE [id] = @id -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_NewsFeedUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_NewsFeedUpdate]   @Newsid int, @Tilte varchar(250), @Newsdetail varchar(MAX), @EntryDate datetimeAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[NewsFeed] SET [Tilte] = @Tilte, [Newsdetail] = @Newsdetail, [EntryDate] = @EntryDate WHERE [Newsid] = @Newsid -- Begin Return Select <- do not remove SELECT [Newsid], [Tilte], [Newsdetail], [EntryDate] FROM [dbo].[NewsFeed] WHERE [Newsid] = @Newsid -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_NewsFeedSelectAllshort] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_NewsFeedSelectAllshort]     AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Newsid], [Tilte], SUBSTRING( [Newsdetail],1,50) as Newsdetail, [EntryDate] FROM [dbo].[NewsFeed]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_NewsFeedSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_NewsFeedSelectAll]     AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Newsid], [Tilte], [Newsdetail], [EntryDate] FROM [dbo].[NewsFeed]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_NewsFeedSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_NewsFeedSelect]   @Newsid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Newsid], [Tilte], [Newsdetail], [EntryDate] FROM [dbo].[NewsFeed] WHERE ([Newsid] = @Newsid OR @Newsid IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_NewsFeedInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_NewsFeedInsert]   @Tilte varchar(250), @Newsdetail varchar(MAX), @EntryDate datetimeAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[NewsFeed] ([Tilte], [Newsdetail], [EntryDate]) SELECT @Tilte, @Newsdetail, @EntryDate -- Begin Return Select <- do not remove SELECT [Newsid], [Tilte], [Newsdetail], [EntryDate] FROM [dbo].[NewsFeed] WHERE [Newsid] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_NewsFeedDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_NewsFeedDelete]   @Newsid intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[NewsFeed] WHERE [Newsid] = @Newsid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_Loginuser] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_Loginuser]   @loginname varchar(200), @password varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [id], [LoginName], [Password] FROM [dbo].[Users] WHERE ([LoginName] = @loginname and [Password] = @password )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ForumUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ForumUpdate]   @ForumId int, @SubjectId int, @Title varchar(500), @Detail varchar(MAX)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Forum] SET [SubjectId] = @SubjectId, [Title] = @Title, [Detail] = @Detail WHERE [ForumId] = @ForumId -- Begin Return Select <- do not remove SELECT [ForumId], [SubjectId], [Title], [Detail] FROM [dbo].[Forum] WHERE [ForumId] = @ForumId -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ForumSelectbysubjitid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_ForumSelectbysubjitid]   @SubjectId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [ForumId], [SubjectId], [Title], [Detail] FROM [dbo].[Forum] WHERE ([SubjectId] = @SubjectId)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ForumSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_ForumSelectAll]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [ForumId], [SubjectId], [Title], [Detail] FROM [dbo].[Forum]

COMMITGO/****** Object: StoredProcedure [dbo].[usp_ForumSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ForumSelect]   @ForumId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [ForumId], [SubjectId], [Title], [Detail] FROM [dbo].[Forum] WHERE ([ForumId] = @ForumId OR @ForumId IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_ForumInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ForumInsert]   @SubjectId int, @Title varchar(500), @Detail varchar(MAX)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Forum] ([SubjectId], [Title], [Detail]) SELECT @SubjectId, @Title, @Detail -- Begin Return Select <- do not remove SELECT [ForumId], [SubjectId], [Title], [Detail] FROM [dbo].[Forum] WHERE [ForumId] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_ForumDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_ForumDelete]   @ForumId intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Forum] WHERE [ForumId] = @ForumId
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventsSelectiamgefordp] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventsSelectiamgefordp]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRANdeclare @id intselect @id = id from [dbo].[Events] SELECT [id], [Title], [EventDescription], '~\images\' +(select top 1 ImageUrl from dbo.EventImages where Eventid = @id) as imageurl FROM [dbo].[Events]
COMMITGO/****** Object: Table [dbo].[Post] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Post]( [PostId] [int] IDENTITY(1,1) NOT NULL, [Forumid] [int] NULL, [PTitle] [varchar](500) NULL, [Pdetail] [varchar](max) NULL, [Username] [varchar](250) NULL, [Emailid] [varchar](100) NULL, CONSTRAINT [PK_Post] PRIMARY KEY CLUSTERED ( [PostId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[DiseasImages] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[DiseasImages]( [Dimageid] [int] IDENTITY(1,1) NOT NULL, [CropId] [int] NOT NULL, [Dimageurl] [varchar](200) NULL, CONSTRAINT [PK_DiseasImages] PRIMARY KEY CLUSTERED ( [Dimageid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[Books] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[Books]( [BookId] [int] IDENTITY(1,1) NOT NULL, [Cropid] [int] NULL, [Bookurl] [varchar](200) NULL, CONSTRAINT [PK_Books] PRIMARY KEY CLUSTERED ( [BookId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: Table [dbo].[tblFiles] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[tblFiles]( [id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, [ContentType] [varchar](50) NULL, [Data] [varbinary](max) NULL, [CropId] [int] NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: StoredProcedure [dbo].[usp_CropsUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CropsUpdate]   @Cropid int, @Description varchar(MAX), @fertigation varchar(MAX), @Weather varchar(200), @Disease varchar(700), @CropTitle varchar(200), @Categoryid int, @HarvestingTime varchar(1000), @Ripetime varchar(1000)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Crops] SET [Description] = @Description, [fertigation] = @fertigation, [Weather] = @Weather, [Disease] = @Disease, [CropTitle] = @CropTitle, [Categoryid] = @Categoryid, [HarvestingTime] = @HarvestingTime, [Ripetime] = @Ripetime WHERE [Cropid] = @Cropid -- Begin Return Select <- do not remove SELECT [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime], [CropImage] FROM [dbo].[Crops] WHERE [Cropid] = @Cropid -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsSelecttopthree] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CropsSelecttopthree]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT top 3 [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime],'~\images\' + [CropImage] as imageurl FROM [dbo].[Crops]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsSelectbycropid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_CropsSelectbycropid]@cropid int  AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime] , '~\images\' + [CropImage] as imageurl FROM [dbo].[Crops] where [Cropid] = @cropid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsSelectbycategoryid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CropsSelectbycategoryid]   @Categoryid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime] , '~\images\' + [CropImage] as imageurl FROM [dbo].[Crops] WHERE Categoryid = @Categoryid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsSelectAllfordisplay] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CropsSelectAllfordisplay]  AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime] , '~\images\' + [CropImage] as imageurl FROM [dbo].[Crops]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreate PROC [dbo].[usp_CropsSelectAll]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime] FROM [dbo].[Crops]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CropsSelect]   @Cropid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime], [CropImage] FROM [dbo].[Crops] WHERE ([Cropid] = @Cropid OR @Cropid IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CropsInsert]   @Description varchar(MAX), @fertigation varchar(MAX), @Weather varchar(200), @Disease varchar(700), @CropTitle varchar(200), @Categoryid int, @HarvestingTime varchar(1000), @Ripetime varchar(1000), @CropImage varchar(500)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Crops] ([Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime], [CropImage]) SELECT @Description, @fertigation, @Weather, @Disease, @CropTitle, @Categoryid, @HarvestingTime, @Ripetime, @CropImage -- Begin Return Select <- do not remove SELECT [Cropid], [Description], [fertigation], [Weather], [Disease], [CropTitle], [Categoryid], [HarvestingTime], [Ripetime], [CropImage] FROM [dbo].[Crops] WHERE [Cropid] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_CropsDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_CropsDelete]   @Cropid intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Crops] WHERE [Cropid] = @Cropid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventImagesUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventImagesUpdate]   @imageid int, @Eventid int, @ImageUrl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[EventImages] SET [Eventid] = @Eventid, [ImageUrl] = @ImageUrl WHERE [imageid] = @imageid -- Begin Return Select <- do not remove SELECT [imageid], [Eventid], [ImageUrl] FROM [dbo].[EventImages] WHERE [imageid] = @imageid -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventImagesSelectbyEventidfordisplay] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_EventImagesSelectbyEventidfordisplay]   @Eventid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [imageid], [Eventid], '~\images\'+ [ImageUrl] as imgeurl FROM [dbo].[EventImages] WHERE ([Eventid] = @Eventid )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventImagesSelectbyEventid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_EventImagesSelectbyEventid]   @Eventid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [imageid], [Eventid], [ImageUrl] FROM [dbo].[EventImages] WHERE ([Eventid] = @Eventid )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventImagesSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_EventImagesSelectAll]     AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [imageid], [Eventid], [ImageUrl] FROM [dbo].[EventImages]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventImagesSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventImagesSelect]   @imageid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [imageid], [Eventid], [ImageUrl] FROM [dbo].[EventImages] WHERE ([imageid] = @imageid OR @imageid IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventImagesInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventImagesInsert]   @Eventid int, @ImageUrl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[EventImages] ([Eventid], [ImageUrl]) SELECT @Eventid, @ImageUrl -- Begin Return Select <- do not remove SELECT [imageid], [Eventid], [ImageUrl] FROM [dbo].[EventImages] WHERE [imageid] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_EventImagesDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_EventImagesDelete]   @imageid intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[EventImages] WHERE [imageid] = @imageid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_PostUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_PostUpdate]   @PostId int, @Forumid int, @PTitle varchar(500), @Pdetail varchar(MAX), @Username varchar(250), @Emailid varchar(100)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Post] SET [Forumid] = @Forumid, [PTitle] = @PTitle, [Pdetail] = @Pdetail, [Username] = @Username, [Emailid] = @Emailid WHERE [PostId] = @PostId -- Begin Return Select <- do not remove SELECT [PostId], [Forumid], [PTitle], [Pdetail], [Username], [Emailid] FROM [dbo].[Post] WHERE [PostId] = @PostId -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_PostSelectbyfid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_PostSelectbyfid]   @Forumid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [PostId], [Forumid], [PTitle], [Pdetail], [Username], [Emailid] FROM [dbo].[Post] WHERE ([Forumid] = @Forumid)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_PostSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_PostSelect]   @PostId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [PostId], [Forumid], [PTitle], [Pdetail], [Username], [Emailid] FROM [dbo].[Post] WHERE ([PostId] = @PostId OR @PostId IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_PostInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_PostInsert]   @Forumid int, @PTitle varchar(500), @Pdetail varchar(MAX), @Username varchar(250), @Emailid varchar(100)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Post] ([Forumid], [PTitle], [Pdetail], [Username], [Emailid]) SELECT @Forumid, @PTitle, @Pdetail, @Username, @Emailid -- Begin Return Select <- do not remove SELECT [PostId], [Forumid], [PTitle], [Pdetail], [Username], [Emailid] FROM [dbo].[Post] WHERE [PostId] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_PostDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_PostDelete]   @PostId intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Post] WHERE [PostId] = @PostId
COMMITGO/****** Object: StoredProcedure [dbo].[usp_DiseasImagesUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_DiseasImagesUpdate]   @Dimageid int, @CropId int, @Dimageurl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[DiseasImages] SET [CropId] = @CropId, [Dimageurl] = @Dimageurl WHERE [Dimageid] = @Dimageid -- Begin Return Select <- do not remove SELECT [Dimageid], [CropId], [Dimageurl] FROM [dbo].[DiseasImages] WHERE [Dimageid] = @Dimageid -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_DiseasImagesSelectbycropid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_DiseasImagesSelectbycropid]   @CropId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Dimageid], [CropId], [Dimageurl] FROM [dbo].[DiseasImages] WHERE ([CropId] = @CropId )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_DiseasImagesSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_DiseasImagesSelectAll]   AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Dimageid], [CropId], [Dimageurl] FROM [dbo].[DiseasImages] COMMITGO/****** Object: StoredProcedure [dbo].[usp_DiseasImagesSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_DiseasImagesSelect]   @Dimageid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Dimageid], [CropId], [Dimageurl] FROM [dbo].[DiseasImages] WHERE ([Dimageid] = @Dimageid OR @Dimageid IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_DiseasImagesInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_DiseasImagesInsert]   @CropId int, @Dimageurl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[DiseasImages] ([CropId], [Dimageurl]) SELECT @CropId, @Dimageurl -- Begin Return Select <- do not remove SELECT [Dimageid], [CropId], [Dimageurl] FROM [dbo].[DiseasImages] WHERE [Dimageid] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_DiseasImagesDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_DiseasImagesDelete]   @Dimageid intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[DiseasImages] WHERE [Dimageid] = @Dimageid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_DiseasImagesbycropid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_DiseasImagesbycropid]   @CropId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Dimageid], [CropId], '~\images\' + [Dimageurl] as imageurl FROM [dbo].[DiseasImages] WHERE ([CropId] = @CropId )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_BooksUpdate] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_BooksUpdate]   @BookId int, @Cropid int, @Bookurl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
UPDATE [dbo].[Books] SET [Cropid] = @Cropid, [Bookurl] = @Bookurl WHERE [BookId] = @BookId -- Begin Return Select <- do not remove SELECT [BookId], [Cropid], [Bookurl] FROM [dbo].[Books] WHERE [BookId] = @BookId -- End Return Select <- do not remove
COMMITGO/****** Object: StoredProcedure [dbo].[usp_BooksSelectbyropid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_BooksSelectbyropid]   @Cropid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [BookId], [Cropid], [Bookurl] FROM [dbo].[Books] WHERE ([Cropid] = @Cropid)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_BooksSelectbycropid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_BooksSelectbycropid]   @Cropid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [BookId], [Cropid], [Bookurl] FROM [dbo].[Books] WHERE ([Cropid] = @Cropid)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_BooksSelectAll] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_BooksSelectAll]
AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [BookId], [Cropid], [Bookurl] FROM [dbo].[Books]
COMMITGO/****** Object: StoredProcedure [dbo].[usp_BooksSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_BooksSelect]   @BookId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [BookId], [Cropid], [Bookurl] FROM [dbo].[Books] WHERE ([BookId] = @BookId OR @BookId IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_BooksInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_BooksInsert]   @Cropid int, @Bookurl varchar(200)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[Books] ([Cropid], [Bookurl]) SELECT @Cropid, @Bookurl -- Begin Return Select <- do not remove SELECT [BookId], [Cropid], [Bookurl] FROM [dbo].[Books] WHERE [BookId] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_BooksDelete] Script Date: 08/28/2014 23:26:23 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_BooksDelete]   @BookId intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[Books] WHERE [BookId] = @BookId
COMMITGO/****** Object: StoredProcedure [dbo].[usp_Booksbycropid] Script Date: 08/28/2014 23:26:23 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_Booksbycropid]   @Cropid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [BookId], [Cropid], '~\books\' + [Bookurl] as bookurlS ,[Bookurl] FROM [dbo].[Books] WHERE ([Cropid] = @Cropid)
COMMITGO/****** Object: Table [dbo].[message] Script Date: 08/28/2014 23:26:26 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[message]( [messageId] [int] IDENTITY(1,1) NOT NULL, [PostId] [int] NOT NULL, [mtitle] [varchar](500) NULL, [mdescription] [varchar](max) NULL, [username] [varchar](250) NULL, [EmailID] [varchar](100) NULL, CONSTRAINT [PK_message] PRIMARY KEY CLUSTERED ( [messageId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object: StoredProcedure [dbo].[usp_VideosSelectbyCropId] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_VideosSelectbyCropId]   @Cropid INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [id], [Cropid], Name FROM dbo.tblFiles WHERE ([Cropid] = @Cropid )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_videoSelectall] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_videoSelectall]  AS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [Id], [Name] FROM [dbo].tblFiles COMMITGO/****** Object: StoredProcedure [dbo].[usp_VideosDeleteall] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_VideosDeleteall]   @videoid intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM dbo.tblFiles WHERE [id] = @videoid
COMMITGO/****** Object: StoredProcedure [dbo].[usp_messageSelectbypid] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate PROC [dbo].[usp_messageSelectbypid]   @PostId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [messageId], [PostId], [mtitle], [mdescription], [username], [EmailID] FROM [dbo].[message] WHERE ([PostId] = @PostId )
COMMITGO/****** Object: StoredProcedure [dbo].[usp_messageSelect] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_messageSelect]   @messageId INTAS SET NOCOUNT ON SET XACT_ABORT ON
BEGIN TRAN
SELECT [messageId], [PostId], [mtitle], [mdescription], [username], [EmailID] FROM [dbo].[message] WHERE ([messageId] = @messageId OR @messageId IS NULL)
COMMITGO/****** Object: StoredProcedure [dbo].[usp_messageInsert] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_messageInsert]   @PostId int, @mtitle varchar(500), @mdescription varchar(MAX), @username varchar(250), @EmailID varchar(100)AS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN INSERT INTO [dbo].[message] ([PostId], [mtitle], [mdescription], [username], [EmailID]) SELECT @PostId, @mtitle, @mdescription, @username, @EmailID -- Begin Return Select <- do not remove SELECT [messageId], [PostId], [mtitle], [mdescription], [username], [EmailID] FROM [dbo].[message] WHERE [messageId] = SCOPE_IDENTITY() -- End Return Select <- do not remove COMMITGO/****** Object: StoredProcedure [dbo].[usp_messageDelete] Script Date: 08/28/2014 23:26:24 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROC [dbo].[usp_messageDelete]   @messageId intAS SET NOCOUNT ON SET XACT_ABORT ON BEGIN TRAN
DELETE FROM [dbo].[message] WHERE [messageId] = @messageId
COMMITGO/****** Object: ForeignKey [FK_Books_Crops] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[Books] WITH CHECK ADD CONSTRAINT [FK_Books_Crops] FOREIGN KEY([Cropid])REFERENCES [dbo].[Crops] ([Cropid])GOALTER TABLE [dbo].[Books] CHECK CONSTRAINT [FK_Books_Crops]GO/****** Object: ForeignKey [FK_Crops_Categories] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[Crops] WITH CHECK ADD CONSTRAINT [FK_Crops_Categories] FOREIGN KEY([Categoryid])REFERENCES [dbo].[Categories] ([Categoryid])GOALTER TABLE [dbo].[Crops] CHECK CONSTRAINT [FK_Crops_Categories]GO/****** Object: ForeignKey [FK_DiseasImages_Crops] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[DiseasImages] WITH CHECK ADD CONSTRAINT [FK_DiseasImages_Crops] FOREIGN KEY([CropId])REFERENCES [dbo].[Crops] ([Cropid])GOALTER TABLE [dbo].[DiseasImages] CHECK CONSTRAINT [FK_DiseasImages_Crops]GO/****** Object: ForeignKey [FK_EventImages_Events] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[EventImages] WITH CHECK ADD CONSTRAINT [FK_EventImages_Events] FOREIGN KEY([Eventid])REFERENCES [dbo].[Events] ([id])GOALTER TABLE [dbo].[EventImages] CHECK CONSTRAINT [FK_EventImages_Events]GO/****** Object: ForeignKey [FK_Forum_Subjects] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[Forum] WITH CHECK ADD CONSTRAINT [FK_Forum_Subjects] FOREIGN KEY([SubjectId])REFERENCES [dbo].[Subjects] ([SubjectId])GOALTER TABLE [dbo].[Forum] CHECK CONSTRAINT [FK_Forum_Subjects]GO/****** Object: ForeignKey [FK_message_Post] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[message] WITH CHECK ADD CONSTRAINT [FK_message_Post] FOREIGN KEY([PostId])REFERENCES [dbo].[Post] ([PostId])GOALTER TABLE [dbo].[message] CHECK CONSTRAINT [FK_message_Post]GO/****** Object: ForeignKey [FK_Post_Forum] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[Post] WITH CHECK ADD CONSTRAINT [FK_Post_Forum] FOREIGN KEY([Forumid])REFERENCES [dbo].[Forum] ([ForumId])GOALTER TABLE [dbo].[Post] CHECK CONSTRAINT [FK_Post_Forum]GO/****** Object: ForeignKey [FK_tblFiles_Crops] Script Date: 08/28/2014 23:26:26 ******/ALTER TABLE [dbo].[tblFiles] WITH CHECK ADD CONSTRAINT [FK_tblFiles_Crops] FOREIGN KEY([CropId])REFERENCES [dbo].[Crops] ([Cropid])GOALTER TABLE [dbo].[tblFiles] CHECK CONSTRAINT [FK_tblFiles_Crops]GO