ASP.net web application project
YELLOWFISH24
Fakeboard-updated.zipFakeboard-updated/database script/all the storeprocedure/dbo.P5_AddUser.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_AddUser] Script Date: 30/11/2017 15:32:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_AddUser] @username varchar(50), @pword varchar(50), @fname varchar(50), @lname varchar(50), @email varchar(50), @address varchar(50), @uRoleString varchar(50) AS BEGIN declare @userRole int set @userRole = (SELECT P5_Roles.Id FROM P5_Roles inner join P5_User on P5_User.Role = P5_Roles.Id WHERE P5_Roles.RoleName = @uRoleString) INSERT INTO P5_User(LoginName, Password, FirstName,LastName, Email, Address, Role) VALUES (@username, @pword, @fname, @lname, @email, @address, @userRole) END
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_CheckUser.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_CheckUser] Script Date: 30/11/2017 15:36:28 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_CheckUser] @username varchar(50), @password varchar(50) AS BEGIN DECLARE @Exists int IF EXISTS(SELECT LoginName FROM P5_User WHERE LoginName = @username AND Password = @password) BEGIN SET @Exists=1 END ELSE BEGIN SET @Exists=0 END RETURN @Exists END
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_CheckUsername.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_CheckUsername] Script Date: 30/11/2017 15:36:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_CheckUsername] @username varchar(50) AS BEGIN DECLARE @Exists int IF EXISTS(SELECT LoginName FROM P5_User WHERE LoginName = @username) BEGIN SET @Exists=1 END ELSE BEGIN SET @Exists=0 END RETURN @Exists END
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_CreateCourse.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_CreateCourse] Script Date: 30/11/2017 15:36:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_CreateCourse] @code int, @name varchar(50), @duration varchar(50), @instructor varchar(50) AS insert into P5_Courses(Code, CourseName, Duration, Instructor) values(@code, @name, @duration, @instructor)
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_DeleteCourse.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_DeleteCourse] Script Date: 30/11/2017 15:43:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_DeleteCourse] @CourseCode int AS delete from P5_Registration where Code = @CourseCode
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_EnrollStudents.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_EnrollStudents] Script Date: 30/11/2017 15:43:06 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_EnrollStudents] @user varchar(50), @courseCode int as insert into P5_Enroll(UserName, CourseCode) values(@user, @courseCode)
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_GetClassInfo.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_GetClassInfo] Script Date: 30/11/2017 15:43:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_GetClassInfo] AS SELECT * from P5_Registration RETURN 0
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_GetCourse.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_GetCourse] Script Date: 30/11/2017 15:43:24 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_GetCourse] AS SELECT Code, CourseName from P5_Courses
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_GetExistingUsers.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_GetExistingUsers] Script Date: 30/11/2017 15:43:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_GetExistingUsers] AS SELECT LoginName, FirstName, LastName, Email from P5_User
Fakeboard-updated/database script/all the storeprocedure/dbo.P5_GetUserEmail.sql
USE [FA17_3342_tuf40221] GO /****** Object: SqlProcedure [dbo].[P5_GetUserEmail] Script Date: 30/11/2017 15:43:38 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[P5_GetUserEmail] @course int AS select P5_User.Email, LoginName from P5_User inner join P5_Enroll on P5_Enroll.UserName = P5_User.LoginName where P5_Enroll.CourseCode = @course
Fakeboard-updated/database script/table/dbo.P5_Courses.sql
USE [FA17_3342_tuf40221] GO /****** Object: Table [dbo].[P5_Courses] Script Date: 30/11/2017 15:44:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[P5_Courses] ( [Code] INT NOT NULL, [CourseName] VARCHAR (50) NULL, [Duration] VARCHAR (50) NULL, [Instructor] VARCHAR (50) NULL );
Fakeboard-updated/database script/table/dbo.P5_Enroll.sql
USE [FA17_3342_tuf40221] GO /****** Object: Table [dbo].[P5_Enroll] Script Date: 30/11/2017 15:44:57 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[P5_Enroll] ( [Id] INT IDENTITY (1, 1) NOT NULL, [CourseCode] INT NULL, [UserName] VARCHAR (50) NULL );
Fakeboard-updated/database script/table/dbo.P5_Registration.sql
USE [FA17_3342_tuf40221] GO /****** Object: Table [dbo].[P5_Registration] Script Date: 30/11/2017 15:45:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[P5_Registration] ( [Code] INT NOT NULL, [Name] VARCHAR (50) NULL, [Outline] VARCHAR (50) NULL, [Duration] VARCHAR (50) NULL, [Tutor] VARCHAR (50) NULL );
Fakeboard-updated/database script/table/dbo.P5_Roles.sql
USE [FA17_3342_tuf40221] GO /****** Object: Table [dbo].[P5_Roles] Script Date: 30/11/2017 15:45:11 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[P5_Roles] ( [Id] INT NOT NULL, [RoleName] VARCHAR (50) NULL );
Fakeboard-updated/database script/table/dbo.P5_User.sql
USE [FA17_3342_tuf40221] GO /****** Object: Table [dbo].[P5_User] Script Date: 30/11/2017 15:45:17 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[P5_User] ( [LoginName] VARCHAR (50) NOT NULL, [Password] VARCHAR (50) NULL, [FirstName] VARCHAR (50) NULL, [LastName] VARCHAR (50) NULL, [Email] VARCHAR (50) NULL, [Address] VARCHAR (50) NULL, [Role] INT NULL );
Fakeboard-updated/Fakeboard/#cfl.dropboxstatic.com.url
[InternetShortcut] URL=https://cfl.dropboxstatic.com/static/images/icons/icon_spacer-vflN3BYt2.gif
Fakeboard-updated/Fakeboard/.vs/config/applicationhost.config
