Category: SQL Server Projects

Engineering computer science students who are looking for SQL Database Server 2005, 2008 projects for beginners and can download sample SQL projects with source code and report for free. Download All Latest SQL Database Projects, SQL Projects Ideas, SQL Presentations & PPT’s Here.

Posted on

Health and Social Organizations Information Portal

Description of the project:

This is an information portal which holds all the information regarding the events conducted by some social organizations (like NGO) and their registered volunteers. It is a website which acts as a platform between the charity/social organizations and the volunteers who participate in those events.

As per the event requirement an organization sends a request to the website (like “an organization wants to launch a blood donation camp and needs a work force of total 30 members where 10 members are doctors and others are volunteers who take care of other things”).

Depending upon the requirement of the event one organization is going to launch the posts requests to some volunteers who are presently in inactive state (i.e., presently not involved in any other event). At this stage the request posted by the organizations will be in pending mode. This request will be pending till the volunteers required for the event are met. In case for the first time if the requirement is greater than the resources the admin sends this event information to some other volunteers.

After the requirement is met a mail is sent to the concerned charity/social organization that their event has been approved and these are the people who will be participating in this event. In the same way a message is sent to all the people who have been selected for that event as volunteers.

We also have a registration field for the new people who are willing to participate in the event as volunteers. Here we have two specifications for a new volunteer that is (a) knowledge transfer and (b) general volunteer. In detail:

(a)               Knowledge transfer registration à this is a scenario for a volunteer who is a busy doctor but is really interested in helping or participating in an event so with his help we get some valuable information in the form of document, video and audio files. Which will be available for the users after the doctor approves the material prepared.

(b)               General volunteer registration à this is a general volunteer registration scenario where a normal user and the doctor who is interested to participate in that event. Now it could be any of the above two ways new volunteers have registered they can login and view the events going to be launched and send their accepted views of participation. Only thing is that no volunteer can be assigned a new event if he is already under an event.

Modules: 

  • Admin module: In this module admin deals with the uploading of all the related information of a topic , selecting the volunteers, sending request to volunteers and organisations and accepting/rejecting response sent by them.
  •  User module: In this module registers into the site and can access all the information related to the posted by the admin, replies to the request sent by the admin to attend as a volunteer for an event.(doctor can also be treated as a user when he is willing to attend as a volunteer to the Event).
  • Charity organisation module: In this module charity can post an event requesting n No. of people required to conduct an event. Gathers all the necessary information required to conduct an event. Messaging is done with the volunteers who are assigned to conduct an event. 

Technical Environment:

  • Microsoft framework 2.0
  • Microsoft C# language
  • Visual Studio 2005 IDE
  • Microsoft SQLserver2005
  • Internet Information Services (IIS)
  • Microsoft Windows 2000 Sp4 or higher
  • Microsoft ASP.Net 2.0
Posted on

Holiday Trip Planner .Net Project

Description of the project:

Holiday Trip Planner travel planning functionality makes it easy for users to plan holidays in a matter of minutes. By pre-planning your dream holiday, you can then proceed to book with ease. Holiday Trip Planner is an online travel management system. It aimed to offer a range of best-value services to ensure that the tour runs smoothly and efficiently. It offers a complete range of services for business and individual travelers.

Holiday Trip Planner Home

The user is provided with an option to select the location where he wants to spend his holidays. As soon as the location is selected the user can see the gallery of the selected location. Users can also be provided with an option to take a virtual tour of the selected location. After selecting of location, the user has to give the accommodation details and no.of days of stay. The user will be redirected to the payment option where the user has to give the credit card details for payment.  Admin is the person who maintains the website.

Existing System:

There are many websites that offer tour packages. But they are not user-friendly. The user is not provided with many options like a gallery and a virtual tour of the selected location.

Proposed System:

Holiday Trip Planner is designed in Adobe Flex with which screens become user-friendly. Users can view the gallery and virtual tour of the selected location before booking.

Modules:

It provides the following functionalities:

Online Booking: The user can book the holiday trip by giving the details and selecting accommodation details.

Payment: Users will have to pay through their credit card details. 

Administration: Admin has the ability to add location details and maintain the details. And also admin can view the bookings posted by users.

Gallery n Virtual Tour: The user can view the photos of the location and can take a virtual tour of the location.

Product Features

  • Web-enabled allows tourists from any state or country to explore places.
  • Do not have to visit the travel agency or travel desk to plan the trip.
  • Allows the tourism dept to invite more customers and hence more revenue.
  • Just a click away to ensure booking, schedule, or cancellations.

Improves performance on time.

Project Scope

  1. Provide detailed tourism information about the state.
  2. Provide information about the packages, and schedules that can be used as a planner for the visiting tourists.
  3. Provide a facility to book, view schedules, and cancel their bookings.
  4. Provide a facility to pay online using credit cards.
  5. Know their pick up, and drop as well as their itinerary during the stay.
  6. Facility to prepone and postpone tour schedule. 

System Analysis: 

User friendly

Different aspects such as the name of the city, different tourist locations in each city along with the gallery, virtual tour, to provide accommodation hotel bookings and online payment will be given different tabs/modules so that it is easier for the user to access the website of his wish.

Separate modules will be provided for transactions with a credit card. 

Transaction management:

The user can pay for the entire trip directly from the site. This site provides security to the user details.

Software requirements:

o   Flex Builder 3

o   Microsoft .Net framework 3.5

o   Microsoft Visual Studio 2008

o   ASP.NET

o   Microsoft C#.Net language

o   Microsoft SQL Server 2005

o   ADO.NET

Hardware Requirements:

Processor:            Intel Pentium 4 or more

Ram:            1 GB or more

Hard disk:            40 GB hard disk is recommended for the primary partition.

Download the Complete Holiday Trip Planner .Net Project code, report, PPT

Posted on

Interview Management System

 Interview Management System- IMS

Contents: 

  1. Existing System
  2. Proposed system
  3. Scope
  4. Features of IMS
  5. How does the IMS work?
  6. Reports and Analysis
  7. Functional Requirements 

Existing System:

In existing system whenever the company is conducting interviews, process involves that taking the jobseeker details, conducting written test, correcting or evaluating the written test papers etc. This entire process is done manually. So, the disadvantages of this process are:

  1. It takes more manpower
  2. It takes much time
  3. Some time the results may be wrong in this approach

Proposed System:

In proposed system, we have to computerize our process where each and everything is done systematically and computerized.

The Interview Management module assists in capturing all-relevant information about the jobseekers which is automatically captured in a database, and a professional quality temporary disposable/photo Jobseeker badge is printed. No need to encode regular Jobseekers again.

Features of IMS:

  1. Secured
  2. Easy to use
  3. Reliable & accurate
  4. No need of examiner

How does the Interview Management System work?

Step 1: Jobseeker Data Entry; in this step, all required information will be captured along with his personal and professional details

Step 2: Take a digital photo of the Jobseeker

Step 3: Take digital fingerprint of the Jobseeker

Step 4: Take digital signature of the Jobseeker

Step 5: Print a Temporary Disposable Badge with Jobseeker’s photo and relevant visit information

Step 6: Jobseeker has to login to the site and enter the username and password to write the online test

Step 7: Online examination questions can be categorized according to the technology.He/she has to select his/her technology and then click on start exam to start exam A serial number is provided with questions from different topics

Step 8: After completion of test time automatically test will get closed. And marks will be displayed to him/her.

Step 9: Logout

Reports and Analysis:

               The IMS simplifies full reporting and auditing of Job Seeker activities and stores your reports.

Functional Requirements:The H/W Requirements:

  • Desktop PC & Monitor
  • Digital Camera
  • Fingerprint Scanner
  • Digital Signature Pad
  • Printer

S/w Requirement:·

  • .NET Framework
  • VisualStudio tool
  • SQL Server 2005
Posted on

Electronic Store System .Net Project

Synopsis of Project 

  1. Project Title: Electronic Store System.
  1. Introduction of the Project:

The Electronic Store Project is creating for store the detail of a Electronic store documents as customer details, product details also purchase details, and maintain the billing system of the Electronic store. It is easy to use for human being to store and maintain an Electronic store details.

Electronic Store System

  1. Objective of the project:

The Electronic store project is helping us to maintain or control all transaction of a Electronic store use by any system or computer. The actual purpose of the project is reduce the time to control an Electronic store billing system and store records in computer.

  1. Project Category:

It is RDBMS base software and also use OOPS concept.

  1. DFD:
  1. E-R Diagrams :
  1. Data base Design:

Table of the Data base:

  1. tbllogin,
  2. tblcustomer,
  3. tblproduct,
  4. tblproducttype,
  5. tblorder,
  6.  tblpurchase,
  7. tbldelivery

Table relation:

Project Module:

  • Login module :

The login module is use for maintain security part of the project using userid and password.

  • Customer Module:

Customer module is use for store the details of all customer who is want to purchase or deliver the product.

  • Product Module:

Product module is use to store the product details of all product details.

  • Order Module:

Order Module is use for take any order of any product of the shop.

  • Payment Module:

Payment Module is use for control payment details of a product of purchase or order time.

  • Delivery Module:

The delivery module is use for control delivery details of all products if delivery is required.

  • Report Module:

The report module is use of create bill of a payment of any product which is purchase.

Tools/Platform:

To develop the Electronic  shop system project I use the .Net platform.

  1. Testing Process To be use:
  2. Unit Testing
  3. Module Testing
  4. Subsystem Testing
  5. System Testing 

Hardware and Software Requirement:

  1. Hardware requirement:

   PIV 1.2 GHZ or above

512 MB RAM or Higher

100 MB Free Hard disk space or Higher

  1. Software requirement:

WINDOWS NT 4 | 2000 | XP | ME

Visual Studio .Net 2008 Enterprise Edition

Internet Information Server 5.0

Visual Studio .Net Framework 3.5

SQL Server 2005

  1.  No the project is not for any industry or client. 
  1.  Future scope of the Project:

The Future scope of the project is it is work to maintain only one shop. If a large Electronic sealer organization is want use this application is not work properly. Because, it is not nor works in LAN connected machine it is work only local machine. So it is the future scope of the project is work in LAN.

  1. Further Enhancement :

The further enhancement of the project is to develop it for control all process of a Electronic store now it is control only seals and order for Electronic. We cannot use it for seals or order for Electronic accessories.

Posted on

E Fashions Java & SQL Project

Project Title: – e-fashions

Purpose of this project: Generally most of the organizations depend on models to launch their products in to the market. Search for the models manually obviously take much time and may not yield the purpose sometimes. This e-fashions project provides an environment for clients to search for models for their advertisements.

Administrator:

The person who coordinates the models and clients is the administrator. Admin can train the models, edit the prices for the models and group them into categories. By displaying the models, he invites the clients to choose the models and edits the contract between the models and clients. He maintains the cost of the contracts between the models and clients.

Models:

A Model can Register, Login and upload their profiles and photos.

Clients:

Clients can Register, search for models by opening their profiles, they can use them for their advertisements by paying the amount by online.

E Fashions Java Project

HARDWARE & SOFTWARE SPECIFICATIONS              

We are used the softwares to execute the code i.e Tomcat server ,SQL 2005 and java .

First we should restore the data base i.e Efashion backup file by clicking on database and select restore the database option in SQL 2005.

Then place the code in the C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps folder  run the code by starting the tomcat.

The code will execute step by step first we should click on admin then we should enter in to admin login by giving the id and password we should enter in to admin home then we can perform some operations.The client and model also login according to their ids and passwords and perform their operations.

Preamble of the project: The internet revolution has made tremendous changes in the life style of people by providing what they want in the useful form at anywhere. With revolution the thinking of the people has completely changed their looking for systems which provides lot of option and guidance in all things (for example education, marriage ,job ,property , etc…).

Objective of the Project: The aim of this Project is to perform the following operations

  • Managing all the details of the models and clients. The details include user name, passwords, contact numbers, email ids, user address, etc.
  • Administrator manages the problems occurred during selecting, updating, contract etc.
  • The details of all the models and clients have to be clearly defined.
  • The clients should provide updates of the addresses, contact numbers etc to the Admin.
  • It is useful to the clients who are going to select the models.
  • Providing updates of models names, photos etc.
  • Administrator can always watch the progress of the models as well as clients.
  • It is user friendly interface to the client: Requires no technical knowledge for searching.
  • It requires less time: When a client is searching for a model in a manual process it takes much time , but when compared to our proposed system it takes less time.
  • The main scope of the project is to select the models for advertisements 

PROBLEM DEFINITION

Previous methods:

The main purpose for preparing this document is to give a general insight into the analysis and requirements of the existing system or situation and for determining the operating characteristics of the system.It saves a lot of time and money of the people. 

In the real time environment there is a much importance for the advertisement, to sale / explore the products / goods of an organization to the people globally. To explore they need advertisement.

Some advertisements require manpower in the form of models, where we want to explain about a product. Generally every organization recruits / utilizes many models for their advertisements.  The organization may or may not get the required models; even sometimes they may not get the details of the model

Project approach and motivation approach:

In this paper, we model the sequence of operations in efashions and show how it can be used for the select the models. Our proposed project would be working using a server for database and information storage and clients for information retrieval.

Organization looks for in a fashion runway model and commercial fashion model include the following:

  • a good sense of style
  • ability to look good at all times
  • must know how to dress up properly
  • knowledge about make up applications
  • has good walking posture
  • excellent stamina
  • familiarity in different poses
  • great facial projection

In the present existing system, the models are selecting manually by clients. It is time consuming and a risky factor.

For example, when we consider a particular organization who wants to launch a new product in to the market.So,we need a model.Then,he manually  concerns every model and select them.But in this process we are not sure that whether the particualr model is suitable for the particular product or not.

It includes the following modules: –

  1. Models
  2. Clients
  3. Reports
  4. Administrator
Posted on

CET Admission System Project in C#.Net with ASP & SQL

Project Profile

University allots Examination centers (As per Candidate’s preferences of examination centre provided in the Application Form) and Seat numbers to the Candidates and generates admit cards informing the seat number, centre and date and time. University publishes the Information of the Hall Tickets & Examination centers allotted on the admission website. The Candidate can print his/her Admit Card by visiting admission website.

CET Admission System Project

University publishes the CET result on admission web site on the stipulated date.

University generates merit list with Combined Score (Academic score + CET score) for admission quota and publishes it on the admission website as well as provides facility to the Candidate to print his/her Scorecard.

As per the data of number of seats available in the college the combined merit (Academic score + CET score) of the candidate, and the preferences given by the candidates in the Option form University allocates seats to the candidates and publishes the college wise candidates list on the admission website.

The Candidate can print his/her provisional Admission Letter by visiting admission website. System administrator adds different colleges with their Admission seat capacity,

also Exam centers list with its capacity along with its unique Id should be maintained. 

Features of the system :

  • Candidate can make enquiry about the CET.
  • Candidate can apply online for CET.
  • Candidate can give online CET Exam.
  • Results will be put on the website.
  • After getting results, Candidate can apply online for Admission.

The total Project can be divided into different sub-systems as follows : 

  1. Application Stage
  2. Pre-CET Stage (Admit Cards)
  3. Online Exam(OES)
  4. Post-CET Stage (Score Cards)
  5. Post-CET Stage (Option Form Filling)
  6. Admission Process
  7. General set-up system

Ajax Functionality Used In Project:

  1. In the Online CET Project, We used Calendar Control with Ajax Functionality in it.
  2. When you forgot your password then there is one Forgot password Page in that page Selected Question
  3. Brings City name into the City DropDownList, whenever user selects the particular State name from the State DropDownList.

TOOLS:- 

C#.NET:-

C- Sharp is used as Front-End Tool. C- Sharp is a general user Interface Programming Language. Programming in C- Sharp is much simple and understandable compared to other programming languages. Even if some error in software remains uncovered, other S/W Professionals can easily handle errors.

MS-SQL :-

MS-SQL is used as Back-End Tool.

Microsoft Word :-

Word is used for basic purpose of writing Help Files because it offers great new ways to polish the formatting in document. 

PLATFORM:- 

Windows XP :-

Windows XP is more convenient and easier to use. All the tools mentioned above works better under Windows compared to other platform.

VALIDATIONS 

USER FORMS : 

Following forms have been validated, through ASP.NET validation controls in each & every fields. 

  • Confirmation Form
  • Forgot Password Form
  • Change Password Form
  • Admission Form
  • Hall Ticket Form
  • Show Detail Form
  • Show Detail1 Form
  • Login Form
  • Signup Form
  • Status Form 

ADMIN FORMS :

DATA DICTIONARY

TBL_CANDIDATE_INFO

This table is used to store candidate personal information, qualification and DD Details.

Primary Key: Candidate_ID

Field_Name Data_Type Size Description
Candidate_ID nvarchar 10 This will be the Id of the candidate & the primary key of the table.
First_Name nvarchar 40 First name of the candidate.
Middle_Name nvarchar 40 Middle name of the candidate.
Last_Name nvarchar 40 Last name of the candidate.
Address_1 nvarchar MAX Address1 of the candidate.
Address_2 nvarchar MAX Address2 of the candidate.
Address_3 nvarchar MAX Address3 of the candidate.
Gender Nvarchar 6 Sex of the candidate.
City nvarchar 30 City of the candidate.
State nvarchar 10 State of the candidate.
Pincode numeric 6 Pincode of the city.
Country nvarchar 20 Country of the candidate.
Nationality nvarchar 20 Nationality of the candidate.
Birthdate smalldatetime Birthdate of the candidate.
Age int Age of the candidate.
STD_Code Int STD code of the Candidate’s Phone no.
Phone_No Numeric 10 Phone number of the Candidate
Mobile_No Numeric 10 Mobile number of the Candidate
Email_ID nvarchar 50 Email id of the candidate.
SSC_percentage numeric 4,2 SSC percentage of the candidate.
SSC_year numeric 4 SSC passing year of the candidate.
SSC_board nvarchar 50 Education board from where the candidate passed SSC.
HSC_percentage numeric 4,2 HSC percentage of the candidate.
HSC_year numeric 4 HSC passing year of the candidate.
HSC_board nvarchar 50 Education board from where the candidate passed HSC.
Graduation_Degree nvarchar 10 Graduation Degree of Candidate.
Graduation_percentage numeric 4,2 Graduation percentage of the candidate.
Graduation_year numeric 4 Graduation passing year of the candidate.
University nvarchar 50 University from where the candidate completed Graduation.
Choice_of_center1 nvarchar 30 Examination Centre1 of choice for the candidate.
Choice_of_center2 nvarchar 30 Examination Centre2 of choice for the candidate.
Choice_of_center3 nvarchar 30 Examination Centre3 of choice for the candidate.
DD_no numeric 10 Demand Draft number issued to the candidate.
MICR_Code Numeric 10 MICR_Code of the DD issued to the Candidate.
DD_Date Smalldatetime Date of the issued DD.
DD_Received bit It shows the status, whether DD is received or not.
Amount Int Amount of the DD paid by the candidate.
Bank_Code nvarchar 10 Bank name which draw the DD.
Branch_Code numeric 10 Branch code of the drawee bank.
Batch_year numeric 4 Batch year for which the candidate is applying.
HallTicket Nvarchar 10 Hall Ticket no. of candidate will be stored.
Seatno Nvarchar 3 Seat no. of the candidate will be stored.
ExamCenter_Id Nvarchar 10 Exam center Id will be stored.

 

TBL_CENTER_COLLEGE

This table is used to store details of the entire examination center.

Primary Key: College_ID

Foreign Key: Center_ID

Field Name Data Type Length Description
Center_Id nvarchar 10 This Column is used to store CenterID which works as a Foreign Key.
College_Id nvarchar 10 This Column is used to store CollegeID which is Unique.
College_Name nvarchar 30 This Column is used to store Center Name.
Address_1 nvarchar MAX This Column is used to store Address.
Address_2 nvarchar MAX This Column is used to store Address.
State_Id nvarchar 10 This Column is used to store State.
Pincode nvarchar 6 This Column is used to store State’s Pincode No.
Course_Id nvarchar 10

 

TBL_GRADUATION

This table is used to store all the graduation’s degree name.

Primary Key: Graduation_ID

Field Name Data Type Length Description
Graduation_Id Nvarchar 10 This Column is used to store GraduationID which is Unique.
Graduation_Name Nvarchar 50 This Column is used to store Graduation Name.

 

TBL_BANK

 

This table is used to store Bank name for DD Details.

Primary Key: – Bank_ID

 

Field Name Data Type Length Description
Bank_Id Nvarchar 10 This Column is used to store BankID which is Unique.
Bank_Name Nvarchar 50 This Column is used to store Bank Name.

 

TBL_COURSE 

This table is used to store courses offered by the colleges.

Primary Key: – Course_ID

Field Name Data Type Length Description
Course_Id Nvarchar 10 This Column is used to store CourseID which is Unique.
Course_Name Nvarchar 50 This Column is used to store Course Name.

 

TBL_STATE 

This table is used to store states.

Primary Key: – State_ID

Field_Name Data_Type Size Description
State_Id Nvarchar 10 It is used to store State Id.
State_Name Nvarchar 30 It is used to store State Name.

 

TBL_EXAMCITYCENTER 

This table is used to all the examination center of any city.

Primary Key: – ExamCenter_ID

Foreign Key: – ExamCity_Id

Field_Name Data_Type Size Description
ExamCity_Id Nvarchar 10 It is used to store city Id.
ExamCenter_Id Nvarchar 10 It is used to store Exam Center Id.
ExamCenter_Name Nvarchar 30 It is used to store Exam Center Name.
Address Nvarchar MAX It is used to store Exam Address.
Phone_no Nvarchar 20 It is used to Phone No.
TotalSeat Int
AllotedSeat Int

TBL_USERS 

This table is used to store Login related information. Candidate ID will be used as user name.

Foreign Key: – Candidate_ID 

Field_Name Data_Type Size Description
Candidate_ID Nvarchar 10 This Column is used to store UserID of the user which is Unique.
Password Nvarchar 30 Password will be stored in the Encrypted Form.
SecQue Nvarchar MAX Security question will be stored.
SecAns Nvarchar MAX Security Answer will be stored.
Type Nvarchar 20 Type of the user will be stored whether He is administrator or User.

 

TBL_EXAMMASTER 

This table is used to store all the exams which are available in this system.

Primary Key: – Exam_ID 

Field_Name Data_Type Size Description
Exam_ID Nvarchar 10 This Column is used to store ExamID of the Exam which is Unique.
Exam_Name Nvarchar 30 This Column is used to store Exam Name.
Totalque Int This Column is used to store total no. of question related with the exam.
Timing Numeric 5,2 This column will be having value of allotted time for the exam.
Total_Marks Int It shows the total marks of the examination.
QueSet Int Question that will appear in the exam. Question will be selected randomly from the question paper Entity.

  

TBL_USERRESULT

This table is used to store information about the various exams given by the user, status of the exam (whether user has completed it or not) and his marks.

Foreign Key: – Candidate_ID and Exam_ID 

Field_Name Data_Type Size Description
Candidate_ID Nvarchar 10 This Column is used to store UserID of the user which works as a Foreign Key.
Exam_ID Nvarchar 10 This Column works as a Foreign Key and used to store the exams given by the user.
Status Bit This column shows that whether user has completed the exam or not. If It is set to 1 that means exam is completed by user.
MarksScored Int Marks Scored by the user.

 

TBL_CITY

This table is used to all the city of examination center.

Primary Key: – City_ID

Foreign Key: – State_Id

Field_Name Data_Type Size Description
City_Id Nvarchar 10 It is used to store city Id.
City_Name Nvarchar 30 It is used to store city Name.
State_Id Nvarchar 10 It is used to store State Id.

 Following forms have been validated, through ASP.NET validation controls in each & every fields. 

  • Login Form
  • Admit Center Form
  • Candidate DD Form
  • Candidate Result Form
  • Bank Form
  • City Form
  • State Form
  • College Form
  • Course Form
  • Exam Center Form
  • Graduation Form
  • Hall Ticket Form
  • Candidate Information 

NOTE : More information about validation you can find in TEST CASES sheet.

Posted on

Tour and Travels Web Application in ASP.Net with C# & SQL

ABSTRACT

This site is used to provide the information to all the people who love to travel and wants to explore the beauties of the nature and wants to see the manmade monuments. Being armed with the right information about the places to visit, the facilities over the places and the way to reach to that place.

The main aim of this system is to bridging the gap between the people from all over the world who wants to visit one of the India’s most popular hill station uttranchal and the agents providing the facilities and the hotels available over the tourist’s places.

Tours and Travels management System in asp and csharp

As internet now a days become the media, which is most commonly used by the person, so in this direction we have plane to facilitate the travelers, the agents, hotels and the guides to interact at the common place.

It is a forum where viewer, travel agents and manager of hotel can exchange information, quickly, effectively and inexpensively. At our site you can register hotels, search for a tourist place. It is a one stop where you get information about tourist place, travel agents, hotels and other things.

It can provide detail knowledge for tourism in a specialized manner and also provide a information in following manner like area wise, agent wise, hotel wise etc.

By using our website user can introduce the wastage of fairs in finding each and every station it provide centralized information of tourism places as well as provide strategically planning for travel.

OBJECTIVE:

To provide the information to travelers in searching for the information about the destination. We can access any type of information any time any way. At our site you can advertise for hotels, register the travel agents, visit sub places of tourist places and can get the information about relatively guides.

  1. To provide the details of all tourist places.
  2. Provide the tips for travelers.
  3. Providing the helps to hoteliers, agents and guides for registering on the site for the visitors to view them.
  4. To provide links for various travels and tourism sites.
  5. Act as a resource useful for all the persons involved in the process of tour and travels.

This project focus on exploring the functioning of “TOUR AND TRAVELS” site means exploring the information regarding the tourist places on internet and provide facilities to reach these places .This project contain the information about the distance, fares, places for visits and facilitate provided over there .

The user group of this project is –

1. Administration department

2. Visitors section

3. Registration section.

4. Guide lines for travelers.

Different users may access different sections and information as per there requirement and under the area of their authentication.

This project is based on “WEB APPLICATION” by means of internet and is based on .NET platform as Front end tool (C#, ASP.NET) and a back End (MS-SQL SERVER). 

THEME OF THE PROJECT:

This project peeps deep in to the activities and functioning of the TOUR AND TRAVELS site .This project tries to make the process of information gathering on various tourist places quiet easily and interactively. Every visitor, hotel’s owner, travel agents, guides will feel quiet easy in accessing information and getting answers of their queries.

DATA STRUCTURE: 

TABLES USED DURING PROJECT: 

TABLE NAME:  Registration Table

DESCRIPTION:It will contain the detail of login admin.

Attribute Types        
Registration No Text
Booking Date Text
Special Package Text
Destination Text
Number of Days Text
Number of People Text
Vehicle Text
Phone Number Text
Total Expenditure Text

Conclusion:

The project has been able to achieve most of its objectives and features within the estimated schedules and quality features. We have to say that for sure that the project was really tough to put our skills to the worst possible test and it gives us immense satisfaction that we have come through successful. It helps us to develop a system, which is helpful in saving the time of a user.

Posted on

.Net Application Projects using ASP.Net, C# and SQL Server

We have implemented Real Time Application projects in asp.net using C# and SQL server 2005 and 2008. Mainly these applications works like Web applications and Windows applications (Desktop applications). Academic Students can easily download and execute these projects on their system using guidelines and how to execute video file provided by us.

Students or users can send us their innovative ideas/requirements to implement in the real time manner.

Services we provide:

  • .Net Application project training (Offline and online).
  • Development of real time projects

.Net Application Projects 

  1. A new color filter array system for image acquisition
  2. A secured image watermarking system for image ownership
  3. A secured key based secret data sharing system in steganography
  4. A user-oriented image retrieval system
  5. Advanced patient management system
  6. Alert based monitoring of stock trading systems
  7. An efficient color image compression using wavelet based technique
  8. An efficient human facial expression recognition system
  9. Application layer blocker for preventing on cyber security
  10. Autonomous network reconfiguration system in WMM
  11. Biometric authentication using eye tracking and finger print authentication
  12. Bug tracking system
  13. Human expertise search engine
  14. Human motion tracking using live web camera
  15. Information leak detection and prevention
  16. Online art gallery
  17. Online budget analysis system
  18. Air port authority of India
  19. Scar global life insurance
  20. Pharmacy management system
  21. Travel desk management
  22. Social ethical aspect of data mining
  23. Multipurpose national RFID
  24. Organization work tracking analysis system
  25. Infrastructure management system
  26. Fuzzy data mining
  27. Expo management system
  28. Digital right management
  29. Citizen management system
  30. Agriculture system
  31. Interpretative key management
  32. Fivatech feature extraction
  33. Yard management system
  34. Sulekha classifieds website management system
  35. Spam filtering using mobile application
  36. Numerous remote system manager
  37. Web enabled estate mgmt system
  38. Human expertise search engine
  39. Online employees communication system
  40. Predicting missing items in shopping carts
  41. Human facial expression recognition
  42. Remote networking service group
  43. Online road transport authority
  44. Online warehouse management system
  45. Online vehicle services
  46. Courier service management system
  47. Web based library management system
  48. Integrated project management and controlling system
  49. Web based hospital management system
  50. Web based cargo manager
  51. Alert based monitoring of stock trading systems
  52. Online visa processing
  53. Spare parts management system
  54. Online e-learning
  55. Gas-agency management system
  56. E-community management system
  57. Bug Tracking system
  58. Premium customer information management
  59. Defect tracking system
  60. Corporate recruitment system(CRS)
  61. Distributed products automation
  62. Online survey manager
  63. TCPIP based process monitoring
  64. Access control system
  65. Enterprise resource information systems
  66. Mining information system
  67. Online trading system
  68. Textile management system
  69. Repository and search engine of a college
  70. Toll gate management system
  71. Voting Software
  72. Warehouse management system
  73. Work flow management system
  74. Steganography In Audio Files
  75. Image Compression and De-compression
  76. Marine Operations And Management System
  77. Multi-Lingual Website
  78. Citizen Card System
  79. Voyage Management
  80. Medical Image Compression
  81. Online Crime file Management
  82. Contract Labor Management System
  83. Data Leakage Detection
  84. Load Shedding In Mobile Systems With Mobiqual
  85. Publishing Search Logs
  86. Issue Tracker
  87. Light-Weight Multi-Document Summarization Based On Two-Pass Re Ranking
  88. Mindtech Bug And Component Systems
  89. Web Enabled Automated Manufacturing System
  90. Enterprise Fleet Management Syste
  91. Effective Audio Video Transfer Using Real Time Protocol
  92. Extended XML Tree Pattern Matching
  93. Multihoming Route Control
  94. VAS for Hand Held Device
  95. Personal Authentication Based On Iris Recognition
  96. Intranet Mailing System
  97. Mobile i Broker
  98. Mobiminder: Location Based Reminder on Mobiles
  99. Mobile Electronic Program Guide
  100. RITAS: Services For Randomized Intrusion Tolerance
  101. Resilient Online Coverage For Surveillance Applications
  102. Improving Utilization Of Infrastructure Clouds
  103. Stealthy Attacks In Wireless Ad Hoc Networks
  104. MultiAuctioneer Progressive Auction For Dynamic Spectrum Access
  105. Continuous Monitoring Of Distance-Based Range Queries
  106. Natural Image Segmentation Based On Tree Equipartition
  107. Card Management System
  108. Company Information Tracking System
  109. Credit Card Management System
  110. E -Crime File Management System
  111. Company Security Reporting System
  112. Data Delivery Properties of Human Contact Networks
  113. Design and Performance Analysis of Mobility Management
  114. Dynamic Conflict-Free Transmission Scheduling for Sensor Network Queries
  115. Efficient Location Training Protocols for Heterogeneous Sensor and Actor Networks
  116. Enabling Public Verifiability and Data Dynamics For Storage Security in Cloud Computing
  117. Ensuring Data Storage Security in Cloud Computing
  118. Fast Detection Of Mobile Replica Node Attacks
  119. Implementation and Validating Environmental and Health
  120. Inter Bank Fund Transfer in Distributed Network
  121. A Fault-Tolerant Token Based Atomic Broadcast Algorithm
  122. Real-Time Detection Of Clone Attacks
  123. Mobility Management Approaches for Mobile IP Networks
  124. Modeling and Detection of Camouflaging Worm
  125. Multiple Routing Configurations for Fast IP Network Recovery
  126. Noise Reduction By Fuzzy Image Filtering
  127. Nymble: Blocking Misbehaving Users in Anonymizing Networks
  128. Optimal Jamming Attacks and Network Defense Policies in Wireless Sensor Network
  129. Ranking Spatial Data by Quality Preferences
  130. Remote PC Administration Using J2ME
  131. Script Identification Through Temporal Sequence Of The Strokes
  132. SPAF: Stateless FSA-based Packet Filters
  133. Staying Connected in a Mobile Healthcare System
  134. Twitter Client For Android Based Smart Phone
  135. Virtual Router Using Destination-Sequenced Distance Vector
  136. IT Project and Process Management
  137. Minimum Bandwidth Reservations For Periodic Streams In Wireless Real Time Systems
  138. Mobile Sampling of Sensor Field Data
  139. Effectiveness of Monitoring for Intrusion Detection in Mobile Ad Hoc Networks
  140. Online Real Estate Property Management
  141. Online Recruitment System
  142. Online Rental House Web Portal
  143. Optimal Channel Access Management with QoS Support for Cognitive Vehicular Networks
  144. Automation Of Analysis And Development Management
  145. Secret Key Establishment Using Temporally and Spatially Correlated Wireless Channel Coefficient
  146. SMS Based Mobile Banking with Security
  147. Adaptive Location-Oriented Content Delivery In Delay-Sensitive Pervasive Applications
  148. Control Theoretic Approach to Distributed Optimal Configuration of 802.11 WLANs
  149. Autonomous Deployment Of Heterogeneous Mobile Sensors
  150. Cooperative Clustering Protocol For Energy Saving Of Mobile Devices
  151. Mobility Management Schemes Based On Pointer Forwarding For Wireless Mesh Networks
  152. Effective Scheduling In Infrastructure-Based Cognitive Radio Networks
  153. Cross-Layer Optimization For Multimedia Transport Over Multicode CDMA Networks
  154. Efficient Location Training Protocols For Heterogeneous Sensor And Actor Networks
  155. Dynamic Time Slot Partitioning For Multimedia Transmission In Two-Hop Cellular Networks
Posted on

.Net Mini Projects for BCA, MCA and BTech

.Net Projects (Non-IEEE, Web Based, Window Based)

.Net Application Projects List

  1. Online Rental System
  2. Course Finder And Allocation Management Tool
  3. Load Balancing Strategies
  4. Web Enabled Estate Management System
  5. A Wavelet-Laplace Variation Technique
  6. Traveler Info System
  7. Web based Cargo Manager
  8. Defect Tracking System
  9. Distance Learning System
  10. Education Loans
  11. Human Resource Management System project
  12. Insurance Management System
  13. Online Art Gallery
  14. Online E Learning
  15. Online Examination
  16. Online Visa Processing
  17. Repository and Search Engine of a College
  18. Survey Manager
  19. Voting Software
  20. Content Based Image Retrieval System
  21. Addiction Recovery
  22. Airline Reservation System
  23. Asset Management System
  24. Automatic E-Card Forwarding
  25. Background Verification System
  26. Back To My Village
  27. Chemical Management System
  28. College Info
  29. Crime Detection Using Face Recognition
  30. Data Secure Encryption System
  31. E_Former
  32. E-Certificate
  33. E-Learning
  34. Electrical Database Maintenance
  35. E-Payroll
  36. E-Post office System
  37. E-Scholarship
  38. Fin Corp-Cash Controller
  39. Franchisee Management System
  40. Gram Panchayat Management System
  41. HRMS Resource Planning
  42. Information Portal
  43. instant interact New
  44. Intranet Communication
  45. Live Meeting Mailing System
  46. Digital Library
  47. Distributed Computing For E-Learning
  48. Digital School Management System
  49. Financial Forecast System
  50. TV Broadcasting System (Window Application)
  51. Employee Monitoring System
  52. Web Based Mail Service
  53. Airline Reservation System
  54. TV Shows project
  55. Access a World of Information
  56. Remote Networking Service
  57. Matrimonial Application
  58. Steganography
  59. Health Care Management
  60. Online Recruitment Process New
  61. Multi User Contact Manager
  62. Net Banking
  63. Office Management System
  64. Online Auction
  65. Online Auction For Customs Products In Sea Ports
  66. Online Bidding
  67. Online Evaluation tool
  68. Online Service Pivot
  69. Online Shopping
  70. Online Test Center
  71. Online Vehicle Tracking
  72. Online Virtual Classes
  73. Online Air Ticketing System
  74. Online Blood Bank (Blood Camber Services)
  75. Online Selection
  76. Order Processing Order
  77. Patron Complaints Resolving System
  78. Project Scheduler System
  79. Property 4 Hyderabad
  80. Pub Maintenance System
  81. Radical Application Portal
  82. Reality Event Organization
  83. RTA Information System (RTA)
  84. Societal Informatics
  85. Soft Solutions
  86. Software Project Organization
  87. Student Halt Mart
  88. Super Market
  89. Task Tracker Arranger System
  90. Tax Assessment Services
  91. Tele Communication Services
  92. Time Login & Leave Management
  93. Vehicle & Health Insurance Policy Premium Calculator
  94. Venture Information System
  95. Warehouse Management System
  96. Web Enabled Estate
  97. Web Tourist Programming System
  98. Zeppelin Reservation System
  99. Universal Feed Reader
  100. Information Screen In Share Marketing
  101. Online Art Gallery
  102. Secure Multimedia Audio & Video Streaming
  103. Automated Mobile Examination Results
  104. BSNL Office Management System
  105. Civil Registry
  106. Corporate Recruitment Management System
  107. Trading Partners Collaboration (Consulting Website)
  108. E Postal Services Network
  109. E2M Conference
  110. E-Cops (Online Crime Reporting)
  111. E Mobile Shop
  112. E-School Management System
  113. Friends Adda Social Networking Site
  114. Geo Spatial InfoTech Solutions
  115. H1B Visa Processing System
  116. Insurance Agent Management System
  117. Integral Construction Portal
  118. Knowledge Management System
  119. Knowledge Process Outsourcing
  120. Lead to Reed Transformation system
  121. Loss Control System (LCS) for Insurance Producers
  122. Prison Management System
  123. Mobile Payment System
  124. Online Auction
  125. Online Property Search
  126. Slow Orthogonal Frequency Division Multiplexing
  127. Speed Cash System
  128. Student Fee Management System
  129. Advanced Online Parking
  130. Web Mart Online Shopping Paradise
  131. My Club – Club Management System
  132. College Information System
  133. Cooking Recipe Portal
  134. Shopping Cart System
  135. Digital Portico
  136. DTC Packers & Movers
  137. E Commerce Mobile Shop
  138. Online Electronic Shop
  139. Expo Management System
  140. E Learning Solutions
  141. Kiosk Management System
  142. Online Learning – Learn Direct through E-Commerce System
  143. Online Art Gallery
  144. Online Bus Reservation
  145. Online Real Estate
  146. Online Social Networking
  147. Security for OSN User Walls by Blacklisting the Misbehaving Users
  148. Perfume Gallery
  149. Online Learning Center
  150. Inventory Management System
  151. Tours & Travels Website
  152. Extreme Sport – Online Store
  153. Store Management System
  154. E Banking
  155. Online Survey Creator
  156. Enterprise Project and Defect Tracking Tool
  157. AICTE Campaign System
  158. Web Based Digital Watermarking Screenshots
  159. Web Hosting System
  160. Online Learning System

Technologies used to implement These Projects are:

ASP.Net, C#.Net, ADO.Net, SQL Server.

Posted on

Asp.Net Tourism Project with SQL Database operations

Tourism Project

Project Description: A sample Tourism project which explains about developing an Asp.Net Application in layered architecture. This Tourism application has all coding standards in place. This online Tourism project is developed only for freshers and junior developers. It has Object Oriented Programming which helps Freshers and Junior developers to easily understand how project will be developed any software company. 

Note: it is not an advanced project which means it doesn’t have Business Rules, Security, Roles etc, this application will helps to understand how to develop an application using classes and reusable data access objects etc. 

Project Requirement:

Need to develop a tourism application with below operations available.

  •  Need to capture the Guides and Customer information
  •  Need to capture various location 
  •  Any person can see locations available in application
  •  Application should have ability to update the existing data.
  •  Application should have static pages to display predefined content. 

Below technologies are used in this application development

  •  ASP.NET
  •  C#.NET
  •  SQL Server
  •  HTML
  •  JavaScript
  •  Css 

Concepts Covered in this tourism project: 

  1. Using Master Page.
  2. Using Validation controls to validate page.
  3. Binding grid-view with data-source controls and edit delete operations using grid-view.
  4. Centralized session management
  5. Uploading files to server
  6. Using Query Strings
  7. Using Object Oriented Programming (Using classes and objects) to do database operations
  8. Inserting Data into database using stored procedures
  9. Updating/deleting Data into database using stored procedures
  10. Centralized procedure names management
  11. Using same screen for two different type of user’s database operations
  12. Centralized database operations
  13. Implementing coding when tables having Parent and Child relation (Added database diagram for reference ).
  14. OOPs in relational database operations (Parent and Child/ Primary and Foreign key operations)
  15. Maintaining database transactions in dot net while doing multiple database operations at once.
  16. Commit and roll back operations using dot net.
  17. Exception Handling (Not included logging)
  18. Writing Stored Procedures
  19. HTML & CSS 

Project Architecture: 

This application has two layer architecture as below 

l  Presentation Layer: Which will have all presentation related code and design.

l  Data Access Layer: Which will have all database operations. 

Presentation layer will communicate Data Access layer for all database operations such as Insert, Update, Delete and Get operations. 

Below Image will helps you understand the application architecture.

SQL Database Details:

This application has 3 tables and stored procedures are also included in database. Below diagram will helps you to understand the database relations.

we need to configure the database before you open the application in browser.

We can configure database three ways

  1. Restore Backup file (Works for SQL Server 2008 R2 only )
  2. Execute the provided database scripts to create new database in your server
  3. Attach the database directly to your database server
  4. Keep database .mdf and .ldf files in your App_Data directory and use below connection string to connect the database

Connection String: <addname=”ConnectionString1″connectionString=”Data Source=.;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True”providerName=”System.Data.SqlClient”/>

In the above case please check for data-source (. or ./sqlexpress or any other database instnace) 

We are providing below database files and you can use any of the file as per your convinence

  1. “.bak” file (works only for Sql Server 2008 R2).
  2. “.mdf” and “.ldf” files
  3. Sql Script file. 

 Download the Asp.Net Tourism Project with SQL Database source code with documentations and screenshots.