Your Assignment

Database:

Access the MySQL database schema for the assessment test, using the connection string provided below.

server=182.50.133.86;
user=GlmSys;
database=glmsys;
password=C0nnect2me;

This database schema contains the following tables:

ROOM_CATEGORY
Attribute
Data Type
Description
ROOM_CATEGORY_ID
Integer
Primary key

ROOM_CATEGORY_CODE
Varchar(5)
The abbreviation for the room category (E.g.: SGL, DBL etc)

ROOM_CATEGORY_NAME
Varchar(50)
The room category description (E.g.: Single, Double etc)

ACTIVE
TinyInt
To flag the currency is active or not

ROOM_TYPE
Attribute
Data Type
Description
ROOM_TYPE_ID
Integer
Primary key

ROOM_CATEGORY_ID
Integer
The foreign key reference to the table ROOM_TYPE

ROOM_TYPE_CODE
Varchar(5)
The abbreviation for the room type (E.g.: STD, PRE, DLX etc)

ROOM_TYPE_NAME
Varchar(50)
The room type description (E.g.: Standard, Premium, Deluxe)

NO_OF_PAX
Integer
Allowed no of peoples in a room

EXTRA_BED_LIMIT
Integer
Allowed no of additional bed

FACILITY
Varchar(50)
The description about the facilities available for a room type

TARIFF
Decimal(12,2)
The rate of a room type for a day

ACTIVE
TinyInt
To flag the room type is active or not


API Development:

The requirement is to develop a Web API using C# in MVC architecture, for the following functionalities:

The input and output of the Web API must be in JSon format.


API
Name
Description
Stored Procedure
Input Parameters
Output Parameters
insertRoomType
Insert room type details
SP_INSERT_ROOM_TYPE
I_ROOM_CATEGORY_ID (Integer)
I_ROOM_TYPE_CODE (Varchar)
I_ROOM_TYPE_NAME (Varchar)
I_PAX (Integer)
I_EXTRA_BED (Integer)
I_FACILITY (Varchar)
I_TARIFF (Decimal)
I_STATUS (TinyInt)
O_ROOM_TYPE_ID (Integer)
A dataset contains room types already in the database table.

updateRoomType
Update room type details
SP_UPDATE_ROOM_TYPE
I_ROOM_TYPE_ID (Integer)
I_ROOM_CATEGORY_ID (Integer)
I_ROOM_TYPE_CODE (Varchar)
I_ROOM_TYPE_NAME (Varchar)
I_PAX (Integer)
I_EXTRA_BED (Integer)
I_FACILITY (Varchar)
I_TARIFF (Decimal)
I_ACTIVE (TinyInt)
A dataset contains room types already in the database table.

deleteRoomType
Delete room type details
SP_DELETE_ROOM_TYPE
I_ROOM_TYPE_ID (Integer)
A dataset contains room types already in the database table.

getRoomType
Search room types using the parameters – Room Category, Search Keyword and Status
SP_GET_ROOM_TYPE
I_ROOM_TYPE_ID (Integer) - pass 0 to retrieve all room types
I_ROOM_CATEGORY_ID (Integer) - pass 0 to retrieve all room types
I_SEARCH_KEY_WORD (Varchar) - pass null to retrieve all room types
I_STATUS (TinyInt) - pass 0 to retrieve all room types
A dataset contains room types already in the database table, based on applied search criteria

Yes, you are the best to be a CASSIYIAN. Thank you for your interest in employment at CASsys Technologies

#D9, Heavenly Plaza, Vazakkala, Cochin, India - 682021 | +91 (0484) 402 6279 | | +91 9447 059016 | info@cassystechnologies.com