How to Run Car Rental System | Car Rental System in Asp.NET Web Forms

If you’ve not yet downloaded the source code, please download it from the link below:

First of all you need to extract the file anywhere in your computer. 

There you’ll see two folders containing different files. You need to open project source code files folder and after that you need to open FYP-CarRentalSystem.sln file as show below:-

After running the file it will take you to Visual Studio (if you have installed). 

All project files will be shown in the Solution Explorer. 

If you try to run the project it will not run and it will show an error about database. To resolve this problem you need to create a new database and run the queries as shown below:

Goto View Menu then select Server Explorer:

Then right click on Data Connection and select Add Connection:

After that you will need to follow the steps below (you can write any name of Database, its better to fill the same as shown in Figure:

Select Yes in Figure Below:

Database created and shown in the Data Connections (CarRentalSystemDB.mdf, this files will be created in your documents directory of your computer): 

Right click on the Database and Select New Query

and it will show the Interface where you will enter the query and run this query:

As i have entered the code of query for database table you need to Run the code given below one by one:

Please run the code step by step.

For creating table of Users:

CREATE TABLE [dbo].[Users] (

    [Id]            INT            IDENTITY (1, 1) NOT NULL,

    [UserName]      NVARCHAR (50)  NOT NULL,

    [FirstName]     NVARCHAR (50)  NOT NULL,

    [LastName]      NVARCHAR (50)  NULL,

    [Password]      NVARCHAR (50)  NOT NULL,

    [EmailId]       NVARCHAR (50)  NOT NULL,

    [ContactNo]     NVARCHAR (50)  NOT NULL,

    [Address]       NVARCHAR (150) NULL,

    [AltEmail]      NVARCHAR (50)  NULL,

    [AltContact]    NVARCHAR (50)  NULL,

    [DriverLicInfo] NVARCHAR (50)  NULL,

    PRIMARY KEY CLUSTERED ([Id] ASC)

);

CREATE TABLE [dbo].[Roles] (

    [Id]    INT            IDENTITY (1, 1) NOT NULL,

    [Roles] NVARCHAR (MAX) NOT NULL,

    PRIMARY KEY CLUSTERED ([Id] ASC)

);

CREATE TABLE [dbo].[UserInRoles] (

    [UserId] INT NOT NULL,

    [RoleId] INT NOT NULL,

    FOREIGN KEY ([UserId]) REFERENCES [dbo].[Users] ([Id]),

    FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Roles] ([Id])

);

For table of Car Models:

CREATE TABLE [dbo].[Models] (

    [ModelId]  INT           IDENTITY (1, 1) NOT NULL,

    [CarModel] NVARCHAR (30) NOT NULL,

    PRIMARY KEY CLUSTERED ([ModelId] ASC)

);

CREATE TABLE [dbo].[Categories] (

    [CategoryId]  INT           IDENTITY (1, 1) NOT NULL,

    [CarCategory] NVARCHAR (30) NOT NULL,

    PRIMARY KEY CLUSTERED ([CategoryId] ASC)

);

CREATE TABLE [dbo].[Brands] (

    [BrandId]  INT           IDENTITY (1, 1) NOT NULL,

    [CarBrand] NVARCHAR (30) NOT NULL,

    PRIMARY KEY CLUSTERED ([BrandId] ASC)

);

CREATE TABLE [dbo].[Cars] (

    [CarId]      INT             IDENTITY (1, 1) NOT NULL,

    [Price]      NVARCHAR (50)   NOT NULL,

    [Detail]     NVARCHAR (MAX)  NULL,

    [Image]      VARBINARY (MAX) NULL,

    [Popular]    NVARCHAR (MAX)  NULL,

    [Damage]     NVARCHAR (MAX)  NULL,

    [Available]  NVARCHAR (MAX)  NULL,

    [ModelId]    INT             NULL,

    [BrandId]    INT             NULL,

    [CategoryId] INT             NULL,

    [UserName]   NVARCHAR (MAX)  NULL,

    [Remarks]    NVARCHAR (MAX)  NULL,

    PRIMARY KEY CLUSTERED ([CarId] ASC),

    FOREIGN KEY ([CategoryId]) REFERENCES [dbo].[Categories] ([CategoryId]) ON DELETE SET NULL,

    FOREIGN KEY ([ModelId]) REFERENCES [dbo].[Models] ([ModelId]) ON DELETE SET NULL,

    FOREIGN KEY ([BrandId]) REFERENCES [dbo].[Brands] ([BrandId]) ON DELETE SET NULL

);

CREATE TABLE [dbo].[Locations] (

    [Id]    INT            IDENTITY (1, 1) NOT NULL,

    [Place] NVARCHAR (MAX) NULL,

    PRIMARY KEY CLUSTERED ([Id] ASC)

);

CREATE TABLE [dbo].[Bookings] (

    [Id]           INT             IDENTITY (1, 1) NOT NULL,

    [StartTime]    DATETIME        NOT NULL,

    [EndTime]      DATETIME        NOT NULL,

    [CNICimg]      VARBINARY (MAX) NOT NULL,

    [Place]        NVARCHAR (MAX)  NULL,

    [Charges]      NVARCHAR (MAX)  NOT NULL,

    [CarId]        INT             NULL,

    [UserName]     NVARCHAR (MAX)  NOT NULL,

    [ReturnedDate] DATETIME        NULL,

    [PaidAmount]   NVARCHAR (MAX)  NULL,

    [SecretCode]   NVARCHAR (50)   NULL,

    [VerifyCode]   NVARCHAR (50)   NULL,

    PRIMARY KEY CLUSTERED ([Id] ASC),

    FOREIGN KEY ([CarId]) REFERENCES [dbo].[Cars] ([CarId]) ON DELETE SET NULL

);

after creating these table, if  you will refresh your Database all tables will look like:

After that you need to run two more queries. I have made two store procedures, one is for Registration of users and second one is for the authentication of users. Please run the given code below in queries again. 

CREATE PROCEDURE spAuthenticateUser

@UserName NVARCHAR (50),

@Password NVARCHAR (50)

AS

begin

Declare @Count int

select @Count = COUNT (UserName) from Users

where [UserName]=@UserName and [Password]=@Password

if(@Count=1)

begin

select 1 as ReturnCode

End

Else

Begin

Select -1 as ReturnCode

End

End

CREATE PROCEDURE spRegisterUsers

    @UserName      NVARCHAR (50),

    @FirstName     NVARCHAR (50),

    @LastName      NVARCHAR (50),

    @Password      NVARCHAR (50),

    @EmailId       NVARCHAR (50),

    @ContactNo     NVARCHAR (50)  ,

    @Address       NVARCHAR (150) ,

    @AltEmail      NVARCHAR (50)  ,

    @AltContact    NVARCHAR (50)  ,

    @DriverLicInfo NVARCHAR (50)  

    

AS

begin 

Declare @Count int 

Declare @ReturnCode int

SELECT @Count=COUNT(UserName)

from Users where UserName=@UserName

if @Count > 0

Begin 

set @ReturnCode=-1

End

Else

Begin

Set @ReturnCode=1

Insert into Users values 

(@UserName, @FirstName, @LastName, @Password, @EmailId,@ContactNo,@Address,@AltEmail,@AltContact,@DriverLicInfo)

end

Select @ReturnCode as ReturnValue 

End

If you open this file you can see the code below where you’ll need to change only the text that I’ve colored red.