Airline Catering Services .Net Project

Purpose

India has a major market where there is a strong demand for top quality in flight catering services. A complicated system like airline catering needs to consider various issues. It is the independent international system which provides a collaboration work made easy by chef and administrator.

Project Scope

Airline Catering Services software provides a better user interface in the catering system. Here we maintain all the details of the chef and we maintain the all the goods available in the store. This makes the chef work more reliable. Apart from this Airline Catering Services application we also maintain transport details we have different vehicles to carry different food materials.

Communication interfaces:

System Design:

Study of Existing system

“India is a major market where there is a strong demand for top quality in-flight catering services”. A complicated system like airline catering needs to consider various issues. Till now this type of system is not yet integrated to provide automated catering services.

Technical architecture:

Proposed system

Airline catering services is the independent international airline caterer services which provides a collaboration work made easy by chef and administrator. Transport and Retrieval System have been devised manually, making the entire material handling/stacking process completely mechanized.

Using this Airline Catering Services application administrator can get the details such as number of passengers traveling in the aircraft, the items to be packed for the airlines, what type of food Items (veg or non-veg), beverages that are to be supplied. He can send the required information for administrator.

UML Diagrams:

Use Case Diagram:

Class Diagram:

Sequence Diagram for User:

Sequence Diagram for Admin:

Sequence Diagram for Chef:

Database design:

Requirements

Functional requirements

The following modules are present in this Airline Catering Services application:

  • Administration System: In this module admin can send all the details required to other members. Details like number of passengers travelling in the aircraft, the items to be packed for the airlines, what type of food items (veg or non-veg), beverages that are to be supplied will be configured.
  • Chef: The chef should have the details like number of dishes to be prepared. He will plan what are the items and beverages to be purchased from the vendor. He has to take care of each and every goods that is required for the chef, and he has to maintain each and every flight timings and what the food to be served for that particular airline he has to maintain all that details
  • Care taker: He is responsible to transfer the goods from the transporter to airlines. He plays a major role, he has to maintain all the records of what all the goods he delivered and at what time he received the good. He has check whether the food is good or spoiled during the traveling.

Database tables

TABLE NAME:  Airreg

Column name Data type Length Allow null
Id int 4 0
name varchar 50 0
email varchar 50 1

 

telephone varchar 50 1

 

address varchar 150 1

 

pin varchar 50 1

 

city varchar 50 1
status char 10 0

TABLE NAME:  Chef_Orderproducts

Column name Data type Length Allow null
chefProductsId int 4 0
ProductsOrdered varchar 2000 1
OrderId int 4 1
ChefEmpId int 4 1

TABLE NAME:  roles

Column name Data type Length Allow null
role_Id Int 4 0
role varchar 50 0

TABLE NAME:  Flightdetails

Column name Data type Length Allow null
FlightId int 4 0
FlightName varchar 50 1
FlightTimings varchar 50 1
Deliverytime varchar 50 1
Reporteename varchar 50 1
Reporteephno varchar 50 1


TABLE NAME
:  Food_Type

Column name Data type Length Allow null
foodTypeId int 4 0
foodType varchar 50 1
description varchar 150 1
status bit 1 1

TABLE NAME:  ItemImages

Column name Data type Length Allow null
imageId int 4 0
imageName varchar 50 1
imagePath varchar 50 1
IsActive bit 1 1

TABLE NAME:  Items

Column name Data type Length Allow null
ItemId int 4 0
itemName varchar 50 0
itemDescription varchar 150 1
itemCost float 8 1
ItemTypeId int 4 0
imageId int 4 1
foodTypeId int 4 1
categoryId int 4 1
ItemTempId varchar 50 1
IsActive bit 1 0

TABLE NAME:  Item temperature

Column name Data type Length Allow null
ItemTempId int 4 0
Temperature varchar 50 1

TABLE NAME:  Itemtype

Column name Data type Length Allow null
ItemTypeId int 4 0
ItemType varchar 50 1
description varchar 150 1
status bit 1 1

 Software :

  • Language : Microsoft C#
  • Microsoft ASNet
  • Runtime : Microsoft Framework
  • Environment : Microsoft Visual Studio IDE
  • Web server: Internet Information Services (IIS)
  • Database : Microsoft SQL Server
  • Operating system : Microsoft Windows

6.2 Test cases:

Test case number #01
Module Airline
Description Registration
Input Provide the details in the registration page for the airlines
Expected Output Request for username and password to be entered
Actual output Request for username and password to be entered
Test case number #02
Module Airline
Description registration
Input Provide the login details
Expected Output Displays a message that registration is successful
Actual output Displays a message that registration is successful
Test case number #03
Module Airline
Description login
Input Provide the login details and select the user option in dropdown
Expected Output Displays catering services home page
Actual output Displays catering services home page
Test case number #04
Module Airline
Description Home page
Input Click on about us link
Expected Output Displays the catering management information
Actual output Displays the catering management information
Test case number #05
Module Airline
Description Home page
Input Click on contact us
Expected Output Displays the address of catering services
Actual output Displays the address of catering services
Test case number #06
Module Airline
Description Place an order page
Input Select the food timings and food type
Expected Output Displays the item name, image, description and quantity information
Actual output Displays the item name, image, description and quantity information
Test case number #07
Module Admin
Description Home page
Input Click on orders link
Expected Output Displays the flight details, order details and delivery time
Actual output Displays the flight details, order details and delivery time
Test case number #08
Module Admin
Description Home page
Input Click on orders and view
Expected Output Displays the order details previously entered and  the items ordered
Actual output Displays the order details previously entered and  the items ordered
Test case number #09
Module Admin
Description Home page
Input Click on orders and accept
Expected Output Request to select the chef to whom order has to be assigned
Actual output Request to select the chef to whom order has to be assigned
Test case number #10
Module Admin
Description Home page
Input Select the chef from the drop down list
Expected Output Displays the particular chef information
Actual output Displays the particular chef information
Test case number #11
Module Admin
Description Home page
Input Click on submit
Expected Output Displays a message that the order has assigned successfully
Actual output Displays a message that the order has assigned successfully
Test case number #12
Module Chef
Description View order
Input Click on order link
Expected Output Displays the order item details and order status
Actual output Displays the order item details and order status
Test case number #13
Module Admin
Description view status
Input Click on order status
Expected Output Displays status as product ordered by chef
Actual output Displays status as product ordered by chef
Test case number #14
Module Chef
Description if the order is ready
Input Click on chef inprocess order link
Expected Output Click on completed preparing food link
Actual output Click on completed preparing food link

Output Screens shots

  1. Login
  2. “User” home page
  3. Select Food as per our choice
  4. Place Order
  5. Admin Login
  6. “ADMIN” check for orders with respective of flight details , food types. He sends order information to “CHEF”
  7. CHEF logins and check his orders and prepares food .

Conclusion:

This  proposed  project  “Airline Catering services” is  analyzed ,designed , developed and  tested in the specified  period  of time  using the Advanced Microsoft  .Net technology   to automate the general operations held in a catering system

Time Sheet Management System .Net Project

The main aim of developing this Time Sheet management System .Net Project is to provide automated work Time sheet for allocated projects all employees in the organisation.

The main Users are Employee, Manager and Admin.

Employee functionalities:

where employees can login with their credentials and view their details, modify existing details, enter new time sheets, view time sheet, update time sheet, delete sheets

Manager functionalities:

Where manager has actions like release, update, view, change & allocation time sheet functions.

Admin functionalities:

Where admin can add employees, approve time sheets, create projects, view projects, create employee id’s, project billing actions, etc.

Database Tables below:

Project Table:

 

Column Name Data Type
UniqId int
ProjectId Varchar(50)
Project Name Varchar(50)
Started Date Varchar(50)
Estimated Date Varchar(50)
Client Name Varchar(50)
Client Location Varchar(50)
Address Varchar(50)
Poc Varchar(50)
PO Varchar(50)
Scope Document Varchar(50)
Estimated Cost Varchar(50)
Types Varchar(50)
Pay For Manager Varchar(50)
Pay For Employee Varchar(50)
Technology Required Varchar(50)
Data Bases Varchar(50)
AssgineTo Varchar(50)

Employee table:

Column Naame Data Type
UniqId int
EmpId Varchar(50)
First Name Varchar(50)
Last name Varchar(50)
Password Varchar(50)
Gender Varchar(50)
Phone Number Varchar(50)
Email Varchar(50)
AltEmail Varchar(50)
Experience Varchar(50)
Date Of Join Varchar(50)
Address Varchar(50)
City Varchar(50)
State Varchar(50)
Country Varchar(50)
Pincode Varchar(50)
Position Varchar(50)
Status Varchar(50)

Timesheet Table:

Column Name Data Type
TimeSheet Id int
EmpId Varchar(50)
Date Varcar(50)
Analasys Requirement Varcar(50)
Preparing Functional Design Document Varcar(50)
 Preparing High Level Design Varcar(50)
  Preparing  Loe Level Design Varcar(50)
   Writing Code Varcar(50)
  Preparing Tcehnical Design Document Varcar(50)
Analasys & Fixing Bug Varcar(50)
Unit Testing Varcar(50)
System Testing Varcar(50)
 Integrity Testing Varcar(50)
Preparing Test cases Varcar(50)
Totaltime Varcar(50)
Status Varcar(50)

 

Column Name Data Type
Allocated Id int
Allocated By Varcar(50)
Project Id Varcar(50)
Project Name Varcar(50)
Allocated To Varcar(50)
Status Varcar(50)

 

Column Name Data Type
Uniq Id int
Project Id Varcar(50)
Emp Id Varcar(50)
Total Work Hrs Varcar(50)
Payment Varcar(50)

Download the Time Sheet Management System .Net Project Source code

Query Redressal System .Net Project

The Query Redressal System is designed for the customers of the Global Bank. Through this system, the bank will manage the complaints from the customers and provide the better services for their customers.

The other target of the bank is to provide the services to its customers all over the world. This project enables the customers of the Global Bank to see the general information about the products, services, and schemes offered by the bank.

The Customers of the bank will be given an email id for each product, where they can send an e-mail when they have a query to register.

The email will be converted into complaints and then assigned to the persons handling the product. Persons handling the complaint will have a facility to communicate with the customer via emails through the system.

Advantages:

  • No wastage of time to send a query.
  • We also can know the complaint details.
  • Requires less man power.

Modules:

  • Administrator
  • Products
  • Services
  • complaints

UML Diagrams:

ER Diagram:

Class Diagram:

Use Case Diagram:

Sequence Diagram:

SOFTWARE REQUIREMENTS

Operating System: MS

Languages: Asp.Net with C#

Database System: MS-SQL Server

Web Server: MS IIS

Download Query Redressal System .Net Project.

Development of RunAway Holidays .Net Project

Our Development of RunAway Holidays Project has one Module and it had developed by using .net technologies.

  1. Agent

Administrator:-

Features:-
1.  Register
2.  Forgot Password
3.  Login
4.  Edit Profile
5   Agent Menu
a.  Booking Details

  1. Retrieve booking
  2. Check Fare
  3. Cancellation

Description:-

The administrator has to register first of all.
* Registration is allowed for only one administrator i.e once an admin is registered no other person is allowed to register again.
* After registering, if he/she forgets his/her password, he can get it by giving valid id & emailid and then answering the secret question correctly.
* Once admin provides valid id & password for login, he/she can go to the menu. 

Using this menu admin can

  • edit his/her profile.
  • Add/update/delete/view Booking Details

UML DIAGRAMS

USECASE DIAGRAM:

Use Case Diagram for Agent

Activity Diagram for Agent

Deployment Diagram

Login Flow Diagram

State Diagram:

Database Table:

Output Screens include:

  • Home Page:
  • Agent Login Page:
  • Agent Home Page:
  • Booking Details Page:
  • Retrieve Booking Page:
  • Fares Page:
  • Cancellation Page:
  • Ticket Cancelled Page:

SOFTWARE REQUIREMENTS:

Operating System: Windows

Database: Sql Server

Server side technology: ASP.Net

Server side scripting : ASP

Client-side scripting : HTML, JavaScript

Web-Server : IIS

Database Details below:

Admin Table

  • admin name
  • admin password

Agent Table

  • first name
  • last name
  • mno
  • email id
  • date of birth
  • address
  • city
  • state
  • country
  • pin code
  • agname
  • agpswd
  • agcpswd
  • pswdhint

bbooking Table

  • tname
  • bno
  • type
  • nos
  • bfrom
  • bto
  • atime
  • dtime
  • tcost
  • bdate

Bus Table

  • tname
  • bno
  • type
  • nos

Card table

  • type
  • bname
  • validity
  • number
  • hname

Customer Table

  • fname
  • lname
  • mno
  • eid
  • dob
  • address
  • city
  • state
  • country
  • pin
  • uname
  • upswd
  • ucpswd
  • pswdhint

Feed Table

  • fto
  • ffrom
  • sug
  • per

hbooking Table

  • hname
  • reg
  • type
  • noa
  • nona
  • place
  • address
  • phno
  • ac
  • nonac
  • cac
  • cnonac

hcard Table

  • type
  • bname
  • validity
  • number
  • hname

Hotel Table

  • hname,
  • reg
  • type,
  • noa
  • nona
  • place,
  • address,
  • phno

hticket

  • hticket
  • uname
  • hname
  • reg
  • aday
  • dday
  • type
  • typer
  • place
  • nor
  • cost

Map Table

  • place
  • district
  • state
  • country
  • img_pk
  • img_stream
  • img_type

tcard Table

  • type
  • bname
  • validity
  • number
  • hname

Ticket Table

  • ticketid
  • uname
  • bname
  • bno
  • type
  • nos
  • bfrom
  • bto
  • atime
  • dtime
  • cost
  • bdate

Tour Table

  • packid
  • package
  • nop
  • cost

tticket Table

  • tticketid
  • uname
  • packid
  • package
  • nop
  • cost

Download Development of RunAway Holidays .Net Project Code and Database

Information Pool System .Net Project

The Information Pool provides a number of services to the users in terms of events management, classifieds, discussion board, news, polls, blogs etc depending on the handling of this Information Pool it is broadly divided into two major modules. They are

  • Administration
  • User

Administration: This section of the Information Pool System has all the features of the user as well as added features of administration such as news hosting, site management, configuration, registrations etc.

User: This section is a restricted one and has all the below-mentioned areas.

Welcome Page

The welcome page is the main Information Pool System navigation area. It consists of several blocks that display partial content of the module or other data. The blocks also serve as access points for navigation into module pages.

Welcome page components are laid out into 3 columns:

left column

  • search block that allows to search Information Pool content by keyword
  • events summary that displays several nearest events
  • discussions overview that displays most recent threads
  • links area that display selected links to external sites

the middle column contains short articles extracted from the database

right column

  • classifieds summary presenting most recent classified ads
  • news section displaying news articles or other content extracted from external news sites
    In the default setup, the news section is utilizing JavaScript component

User Registration And Login

First-time Information Pool System user can register to access restricted Information Pool areas and services using the “Join Us” button located in Info Pool header. The registration form can also be used to modify user information if the user is already logged-in.

The user is logged-in if the welcome message contains username displayed below header buttons.

All new users are automatically assigned Security Level 1, which allows them to participate in Info Pool community activities. The Administrator (Level 3), can upgrade the security level of a user to Level 2 (Editor) or Level 3 (Administrator).

Additionally, the Administrator has options to configure email notifications so that users receive Email Confirmation upon successful registration. They can also retrieve lost password via email.

Info Pool Administration

The Administration Module is accessible only to Editors (Security Level 2) and Administrators (Security Level 3) and can be used to manage Info Pool content and configuration.

Most of the administration pages are organized as two-page editing schema. One page contains a list of available items (optionally with searching capabilities) and by clicking items in this list one can navigate into another page containing a form for modifying item data or entering new item data.

Articles/Content

This section is used for review and maintenance of articles appearing in the middle column of Information Pool System’s welcome page. The articles will be ordered by “order” number assigned to each one.

News

This section is used for review and maintenance of news articles appearing in the right column of Information Pool System’s welcome page. By default, the Info Pool is configured to display news headlines.

Events

This section is used for review and approval and of Events submitted by users, as well as for adding new and maintaining existing Events.

Links

The links section is used for review and approval and of Links submitted by users, as well as for adding new and maintaining existing Links.

Link Categories

This form allows the review and maintenance of link categories.

Forums

This section is used for creating and maintaining Discussion Forums. Forum details contain forum information and allow selection of forum moderator from the list of registered users.

Classifieds

This section is used for review and maintenance of Classified Ads submitted by users. Inappropriate ads may be deleted or marked as inactive.

Ad Categories

This form allows the review and maintenance of available classified ad categories. It contains the current category list and forms for editing the category.

Members

This section is used to search, review and edit the list of registered Information Pool System users. The administrator can modify user information, delete users, as well as assign security access level to each user. The Member List page contains “Export To Excel” link, allowing to export Members to Excel.
Members can also be assigned a membership status for organizational purposes, such as candidate, member, or supporter. This status is not used elsewhere in the Information Pool System, except in the Email module.

Member Statuses

This form allows for review and maintenance of user statuses, for organizational purposes.

Send Emails

This page can be used to send email messages to selected Information Pool System users. It allows selection of Member Status to whom the email should be sent. The administrator also needs to enter email parameters, such as From, Subject and email Body.
Email history is also shown on the screen.
Email functionality may require additional email component to be installed on the server, such as CDONTS for Windows. Please contact your hosting company, if you experience issues with sending emails.

Data Dictionary

Info Pool Security

The Information Pool System is configured with 3 default users and 4 security levels, as shown to the right.

Security Level 0:

All visitors who are not logged in have security level 0 with limited permissions, allowing them to view Information Pool System areas. The administrator may configure the Information Pool to allow or disallow anonymous visitors from submitting new content like Events, Links, and Classified Ads.

Security Level 1:

All users who register and log in to the Information Pool are automatically assigned security level 1, allowing them to fully participate in Information Pool community activities. They can submit new content, although some of such content may require approval by an editor or administrator.

Security Level 2:

This security level can be assigned to users only by the administrator and is usually assigned to editors who may submit, review, approve, change and delete content.

Security Level 3:

This is the highest security level, available only to Information Pool owners/administrators and allows them to modify and delete users, configure Information Pool settings, and send email notifications to users.
Information Pool Configuration screen allows the administrator to specify if users need to login to be able to submit new content.

UML Diagrams:

Context Level Diagram

Administrator Use Case Diagram:

ER Diagram:

First Level DFD:

Second Level DFD:

Info Pool Layout

Every Information Pool page contains 3 areas:

Header: contains navigation buttons, Information Pool logo, and Welcome message or User Login information.

Main Content: welcome page or module content is displayed here

Footer: contains Information Pool navigation hyperlinks

Info Pool Configuration

This form contains Information Pool configuration options that affect Information Pool functionality. They include:

  • Information Pool URL
    URL of Information Pool welcome page used to redirect users back to the Information Pool, when they submit event payments via PayPal.
  • Users must be Logged-In to submit new content
    Global setting determining whether only registered Information Pool users are allowed to submit events, links, discussion messages and classified ads
  • Expanded Discussion Search
    this setting turns on/off alternate Discussion Search Results page. When “On” Discussion Search Results show individual replies instead of discussion topics.
  • Email Sender Address
    Default address for “From” field when sending emails
  • Enable Email Registration Confirmation and Password Retrieval
    If you want to utilize emails on your website, you should turn on this feature. It enables users to retrieve their lost passwords via email. It also confirms new user registrations via email
  • Registration Confirmation and Lost Password Body
    In this area, you can supply the email message that you want to send to users when they register or forget their password. You may also use special tags {login} and {password}, which will be replaced with the actual Login and Password of the user that is being emailed.

Info Pool Registration

This URL connects you to Smart Registration Page where you can register the usage of this application. The registration is free and allows you to be notified about the availability of future upgrades.

Support

This URL connects you directly to the Smart Support System where you can submit technical questions, issues, and requests.

Output Screens:

SOFTWARE REQUIREMENTS:

  • WINDOWS
  • Visual Studio .Net Enterprise Edition
  • Visual Studio .Net Framework (Minimal for Deployment)
  • SQL Server

Download This Information Pool System .Net Project.

Freight Forwarding Management System .Net Project Synopsis

This Freight Forwarding Management System software keep track of all activities (booking, container allotment, stuffing, customs clearance, raiment, ship-on-board, delivery, debit note, credit note etc

The containers for Shipping are delivered to Consignee after a relevant process including order booking, stuffing, customs clearance, raiment, delivery etc.

A freight forwarder is an individual or company that exports the goods from one place to another.

The freight forwarder does not actually carry the cargo or conduct business for the ship.

It is an intermediary between carrier and owner of goods being transported.

This software is based on 3Tier Web Architecture powered by the Microsoft’s Dot Net Technology. This software will be implemented in ASP.NET. With this software will handle all the Freight Forwarding Management system software, the user can have access to world-class services any time, any place in the world.

This software keeps track of all activities (booking, container allotment, stuffing, customs clearance, raiment, ship-on-board, delivery, debit note, credit note etc. The Containers for Shipping are delivered to Consignee after a relevant process including order booking, stuffing, customs clearance, raiment, delivery etc. A well Standard reporting will be included in this software which will be very beneficial for the clients and users.

Design Of Solution

Functional Scoping of the Software

  1. Customer Module:- Includes all details of the customer/consigner
  2. Consignee Module:- Includes all details of the consignee.
  3. Agent Module:- Includes all details of the Agent who is dealing with the order.
  4. Shipping Line Module:- Includes all details of the shipping lines.
  5. Booking Module:- In this module booking of a order is done.
  6. Stuffing Module:- In this module container stuffing information is provided.
  7. Customs Clearance:- In this module custom clearance process is provided
  8. Railment Module:- In this module railment process is provided.
  9. Ship-on Board Module:- Finally the container goes to the destination(to the consignee).
  10. Delivery Module:- Goods to be handed over to the consignee.

Reports

  1. Master Daily Activity report
  2. Booking Report.
  3. Pending container allotments vs Bkgs and Containers Allotted Vs Bkgs
  4. Pending Stuffing on containers vs stuffed
  5. Pending Railouts Vs Railed out
  6. Railed Out Vs Shipped on Boards / Planned vessels
  7. Pending Shipped on Boards Vs Planned Vessel
  8. Outstanding Reports ( Clients ) Vs Receipts
  9. Outstanding Reports ( Agents ) Vs Receipts and Payables
  10. Pending Invoices / B/Ls and Invoices and B/Ls released vs Docs or SI Received
  11. Pending SI From Clients vs Cut off Dates/ Rail outs / Planned Vsl
  12. MSI Submitted Vs Cut offs and Pending MSI submissions vs Cut off Dates / Rail outs/ Planned Vsl
  13. Pending Prealerts / Manifests to agents Vs Shipped of Board
  14. Shipping on Board Vs ETA
  15. Arrivals Vs ETA
  16. Transshipments Vs Planned Transhipments
  17. Delivery Vs Arrivals

Facilities Required For Proposed Work

Technologies Used: – ASP.NET with C#.NET

Database Used: – Microsoft SQL Server

Web Services Used: – Advance XML Web Services.

Domain Required: – Any new domain registration is required.

Digital Asset Management System .Net Project Synopsis

Project Title: Digital Asset Management System

Domain: Open Industry 

Sub Domain: Management 

Architecture: N-Tier Architecture

SDLC Methodology: SDLC Model 

Objective:

This System helps in creating and managing a data repository of the inventory pertaining to the hardware and software of IT resources in an organization. It will also be used to manage related documents of all employees which will be saved with security and authenticity. It will have options to register employees, save all related infrastructure items. Comprehensive role management will also be provided as per improved security. 

Description:

This System helps in creating and managing a data repository of the inventory pertaining to the hardware and software of IT resources in an organization.

The IT inventory list basically consists of computers, monitors, software, network devices, printers, plotters, scanners, cartridges, etc. Asset Management, which has two major components, an application to maintain the inventory data pertaining to the installed hardware and software of a computer and its associated peripherals, and second component named which helps in the management of these inventories. The Second module makes use of the data captured by the First and the financial and commercial data pertaining to the inventory. The financial details include data on the invoice, warranty, AMC and the commercial details include data on suppliers, contacts, contracts etc. The financial and commercial data have to be entered manually into the System. The data captured could be imported into System; also manual entry of inventory data is possible in the Software. 

Features:

Inventory of Asset types like Computer, Laptop, Projector, Chairs

Maintaining the Data about the AMC Details.

Raises warnings on Antivirus and AMC Expired date.

Maintains asset information as branch wise in the organization

Maintains the invoice details about Asset

Scope:

This System helps in creating and managing a data repository of the inventory pertaining to the hardware and software of IT resources in an organization.

Admin login into the system through credentials

Admin will add the Branch details

Admin will add information room, floor details

Admin will add the assets information into the system

Admin will add the assets invoice information

Manager login into the system through his credentials

Asset Manager will change assets from one location to another

The system will display expire dates about software like antivirus etc.

Admin will add AMC Details

The manager can view the AMC Details

The system maintains all asset information like computers, chairs laptops etc. 

Out of Scope:

Asset information that might have changed in long timeframes.

AMC contact details information may change.

MODULES

Administration This module is accessible to admin only. Admin can add all assets that are maintained in an organization. He will add company info first. Then will add branches and then related assets and all related information. Will have access to related modules to add the necessary info.

Asset Management this module is for adding different assets and its related info to the application. It will have grid view also to see the added info.  It will have add/ edit and delete option for any asset held in an organization. It will have the option to add AMC info to and upload attachments related to the same for related assets. It will have the option to update the status of an asset like a computer if it is in repair wherever applicable.

Registration Employees has to register themselves and their login will be approved to access the application. Employees can raise a complaint against hardware issues for the assets they are using.

Reports Will be used by admin and management officials to see the status of assets used in the organization as a snapshot.

Roles This module will be used to grant roles to different employees who have registered and access will be granted to them to different modules as per the assigned role. 

Users

Administrator / Asset Manager / Employees

KEYWORDS:

Generic Technology Keywords: Database, User Interface, Programming

Specific Technology Keywords: Asp.Net, C#.Net, MS SqlServer-05

Project Keywords: Presentation, Business Object, Data Access Layer

SDLC Keywords: Analysis, Design, Implementation, Testing 

Software Requirements:

Technical Aspects:
Database: SQL Server 2008  and more
Language: C# and Asp
Framework: .Net
Front-end: HTML, CSS, Javascript

It can also be done in Php, MySql as backend with other frameworks

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Campus Assessment System C# or PHP Project Synopsis

ABSTRACT

The main purpose of this System is to develop a process/ system through which the efficiency of an Institution can be increased by continuous monitoring and assessment of various practices right from academic offerings to infrastructural facilities adopted by the institution.

The main aim of the system is to identify whether the services of the institution under different segments such as Teaching/Learning mechanism, student support services (such as training, placement, career guidance), infrastructural support are in accordance with the expected level of performance. The system further points out the deviations/deficiencies, if any, and suggests possible control measures to bring back the services on the expected level of performance.

This is achieved by gathering opinions/feedback from the stakeholders of the system such as heads of departments, teacher, and student. The opinion/feedback of the stakeholders is taken through carefully designed questionnaires in the form of a survey. The opinion is taken in terms of performance indicators against each of the services offered by the institution. The results of the survey are analyzed and accordingly, summary reports and on-demand reports are generated to help management of the institution to improve and standardize the entire process and practices being adopted by the institution. The surveys can be based on any kind of questionnaires like

  • Surveys based on student performance
  • Surveys based on faculty Performance
  • Surveys based on career guidance & placement
  • Surveys based on campus Infrastructure and allied facilities

This application can be used as Intranet / Internet Application. Using intranet HODs can post the queries and their related options on the site. The authentication for both student and faculty is provided in this system. Any authenticated user can log in and post the views, feedbacks, and suggestions for consideration.

When it comes to the student, depending on the queries one can choose the options. Depending on the knowledge provided the HODs will be able to analyze and take a precise decision.

The system further maintains an address book containing the email ids and contact details of all the students, faculty members, and other staff members so that they can be contacted as and when needed.

MODULES

  • HOD
  • Teacher
  • Student
  • Admin
  • Reports

Software Requirements:

Technical Aspects:

  • Database: SQL Server 2008  and more
  • Language: C# and ASP
  • Framework: .Net
  • Front end: HTML, CSS, Javascript
  • It can also be done in Php, MySql as back end with other frameworks

Hardware Requirements:

  • Intel Core processor
  • RAM 4GB and Above
  • HDD 100 GB Hard Disk Space and Above
  • 64 or 32 bit OS Windows 8 and above 

LIST OF REQUIREMENTS

The given requirements are defined below.

  1. Internal campus assessment Application system should have the Login screen. By this feature the Faculty / Student enters into the system.
  2. A login box should appear to the Faculty / Student, when the system is invoked.
  3. The logins are assigned by the Administrator only, not by the other users of the system.
  4. The System should display proper error messages in case of an error.
  5. The System should enable the user to Logout. This feature ensures the security of the application such that no more transactions can be carried out, once user logs out.
  6. The application must adhere to usability and interoperability norms so that system can be more user friendly by virtue of providing necessary screens and navigations.

SCOPE (IN AND OUT) OF THE PROJECT

Description of what features are in the scope and out of the scope of the Project.

In Scope

  1. Internal campus assessment system should have the login screen, by this feature the HOD /Faculty Student / Administrator enters into the system.
  2. The logins are assigned by the administrator only, for various user types as Faculty, Student and Departmental-heads.
  3. Validation of users and based on user type giving different user interfaces.
  4. Allocation of users to system by Administrator.
  5. Survey Entry provision must be with the Administrator.
  6. Generation of different reports based on the survey.
  7. When the Survey Entries are made by the Admin and when the Faculty/ student logs into the system they must be able to see different surveys that can be attempted by them.
  8. Head of the Department must be able to view the reports in different formats.
  9. Administrator must be able to enter the master data related to sections, sub-sections, Academic years and so on.
  10. Also the process of mapping the Survey to Section must be in Administrator login.

Online Project Approval System .Net / PHP Project Synopsis

Domain: Workflow Management

Architecture: N-Tier Architecture

SDLC Methodology: SDLC Model

Objective:  In this Online Project Approval System project, we will focus mainly on automating the process of project submission. In the sense project topics will be submitted online along with doc and approval will be provided online by the head of the department along with suggestions if any. This will reduce the physical efforts of students meeting the head of the department and also reduce the time frame period of completing this part of project work. Students can also update their project status weekly and provide in for regarding the progress, which will be monitored by all relevant professors and head of departments. It will be useful for all students related to Engineering, MSc, M.Tech, final year students of any grad etc.

Description:

In general, the Project & Title will be selected from various sources and send it to the HOD like the Project Title along with a birds-eye view of the Project in a document called Project Abstract.  The HOD will accept the Project and allows the student to proceed and start working on the Project.

In the middle of the Project designing, the HOD also makes a request to the Student to send the Sample Code of any module as well.  And at the final, the Student has to prepare the necessary Documents like Project Final Document (contains Introduction, Modules, User roles, SDLC methodology, etc.), UML Diagrams, Powerpoint Presentation (PPT) of the Project flow for Demo and also takes the Database (as backup file to restore), Source Code and all the content in a Compact Disk (CD) and submits to the HOD along with printed hard copy.  The HOD will review all these documents and finishes the Project Review and enters the Marks into the College records.

Using this web application the above entire flow can be automated so that the Student need not submit any Soft copy (CD) of the project as well, the College need not maintain all the collected CDs of the students in the Library for records.

Using this web application, the Student can send a request to HOD for Project Title along with Abstract.  On acceptance of HOD, he/she can design the Project along with necessary documents and submit to the College over the Internet using College’s website.  In the HOD Project Review, the HOD can download the Project content from the College’s website (from the Internet) and can do the evaluation.  As well, the Student can also download the content from the College’s website and give Demo of the Project (by restoring the database, configuring the Project site, etc.) to the HOD.

User Types: Admin and Student

Modules:

Admin:

This module will allow HOD or any other admin login to log in and approve project abstracts submitted by students. Admin or HOD will add College Info which can be displayed on the dashboard. Will view project progress which has been submitted by the student and reviews it. Admin can add professors involved in the project. Add batch info for a year, course info for that year, course name, and these all info will be used by the student at registration process. Once the student registration is done, HOD will get a request for approving student registration. Hod or admin can also add project titles that have been approved for different students and they can be viewed by any registered student in the dashboard.

Registration:

The student will register and provide the necessary info. The application will be secure as registration will be approved by HOD and then the student can log in.

Project:

A student once logged in after registration will add abstract along with project name as tentative info in this module and that can be viewed by HOD.
This module will have the option to upload different files for the assigned project. It will have the option to add progress info date wise or weekly. A student can upload initial abstract from this module and then all other files for final submission.

Features and Benefits include:

  • Secured login and authentication with forgot password option.
  • Students Can upload and download documents and another sort of files as zipping.
  • The process of submitting projects abstract and getting approval has been made easy via the online application.

Future enhancements:

  • We can plan mailing module which will allow the student to send email to hod with attachments. View/ send/reply email options will be provided. It can be done in the form of the message center.
  • Registration process can be refined by adding email alerts whenever HOd approves registration.
  • Alerts or notification module can be added separately which will show notification icon and which when clicked will open the related info for which notification was received.

KEYWORDS:

Generic Technology Keywords: Database, User Interface, Programming

Specific Technology Keywords: Asp.Net 3.5, C#.Net, MS SqlServer-05

Project Keywords: Presentation, Business Object, Data Access Layer

SDLC Keywords: Analysis, Design, Implementation, Testing

Software Requirements:

Technical Aspects:
Database: SQL Server 2008  and more
Language: C# and Asp
Framework: .Net
Front-end: HTML, CSS, Javascript

It can also be done in Php, MySql as backend

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Employee Pay Management System C# / PHP Project Synopsis

Project Understanding: This Employee Pay Management System application will basically handle salary management for employees that work on an hourly basis and contract basis. It will allow employees to register and login to access various modules including Timesheet module which actually allows the employee to save their days work on hourly basis. Employee can update his or her details after login. Information will be like educational qualification, technical experience, personal information etc. Employees can also enter their salary rate. The option will be provided to view salary slips on monthly basis. He or she can also apply leaves and also view their leave history.

User Types: Admin, Employee

Basic Modules involved in the project:

Login / Registration / Dashboard → Every employee working on contractual basis will register and once admin approves it will be able to log in. Once they log in they will be provided with different options to save their personal details, emergency details, permanent address, current address etc. They can add experience details related to all previous companies, add skill sets like proficiency in Java or .net etc.

Timesheet → This module will allow the employee to select the client, then select the project he or she is working, task and then provide comments like activity is done and add no of hours worked for any task. Multiple entries can be posted in a day with different no of hours. Depending upon no of hours saved, the monthly payment will be calculated. The option will be provided to mark a day as leave or weekly off. It will have a view wherein there will be a count, hours, work time and Off time. An employee can also enter his / her off hours like half n hour for lunch.

Leaves →  This module will allow employee to save or request leave type for a day or more. It will also have leave history grid to check the history of leaves.

Admin → Admin will actually manage the admin panel in the back end. Admin will create leave types. Will add projects. Will have option to approve employees registration. Will add different skill names, Add company profile with all details including logo, Employer ID, Address Currency, Owner etc,. Add clients and also add tasks. Admin will approve timesheets submitted by employees and then come up with pay calculations. Admin will approve hourly rate submitted by the employee.

Pay module → This module will have a grid wherein it will have the option to pull up employee working hours details and calculate their pay as per hourly rates approved by admin. This module will be accessible to admin only.

 Future Enhancements: 

  • We can come up with employee alerts wherein they will get alerts for approved leaves, approved timesheets.
  • We can provide reports module with a different type of reports.
  • We can also introduce invoice module too.

Software Requirements:

Technical Aspects:
Database: SQL Server 2008  and more
Language: C# and Asp
Framework: .Net
Front-end: HTML, CSS, Javascript

It can also be done in Php, MySql as backend

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above