Posted on

Web Based Training Management System .Net Project

PRELIMINARY INVESTIGATION

1) Interview:

For making software for a company, we need knowledge of their existing system. For this purpose, we take interview of some persons working in that company.
We gather information from taking interview of that person who is related with this software. As- Training Coordinator, Hostel Warden, Trainee, Guest Faculty.

2) Group Discussion:

It was the discussion among the company people who were involved in the project. At first, many ideas were pooled in and existing themes, concepts which the other web applications were using were chosen. And then all these ideas were brought into action by the programmers.

3) Online observation :

It is the process of getting close details of the existing software or web application from the internet. The major objective is to get as close as possible to the system.The information on the TRAINING MANAGEMENT SYSTEM software was obtained from the existing web applications which are running successfully.

4) INFORMATION DESCRIPTION

Training Management System and web application:-.

1) The purpose of the application is to help the director to get details about the training, hostel, feedback, employee, expenses etc.

2) Training Details, Feedback Report, Bill generate automatically.

3) It helps the Training Coordinator to manage the training details, Trainee Information easily.

4) This application also helps to hostel Warden to manage the hostel and mess details in an easy way.

5) This application is also useful for manage detail of Guest Speaker and their lecture information.

6) It helps to manage all visits during training.

7) It also calculates the total gain and expenses of walmi from a training.

Project Objective

To facilitate the process of management of training.
To provide a software for managing trainee registration and maintaining the records.
To generate feedback information from trainees in different aspects.
To generate feedback report for a particular duration.
To maintain an account for a training easily.

Project Introduction

The application provides a login facility to different uses of the organization.
If the login successfully then they use their form.
The application provides facility to manage trainee record and account for a training to the coordinator.
The application provides facility to hostel warden to maintain the record of a trainee who is staying in a hostel.
With the help of this application, the Director sees the feedback report in a different aspect.
This application is useful for calculating expenses for a training and also calculate profit.

Data Flow Diagrams:

Data Flow Diagram of Trainee:

Context Level DFD:

Level 1 DFD:

Level 2 DFD:

Level 3 DFD:

Minimum Hardware Requirement

Microprocessor : Pentium or Core-i series.
Primary Memory (RAM) : 512 MB
Secondary Memory (Hard Disk) : 16 GB
Video Display Unit : VGA Monitor.
Compact Disk Drives : 52x CD-ROM.
Keyboard : 101 Key Enhanced Keyboard.
Mouse : Serial Mouse.

Data flow Diagram for Training Coordinator

Context Level DFD:

Level 1 DFD:

Level 2 DFD:

Level 3 DFD:

Data flow Diagram for Guest Faculty:

Software Requirement

Operating System : Windows XP , Windows Vista , Windows 7

Language : Asp.net (C#.net)

Database : SQL Server 2005

Browser : IE, Mozilla Firefox

ER Diagram:

Use Case Diagram:

LIMITATION

  • After every lecture, we have to maintain the honorarium record.
  • There is no provision for suggestion box in feedback form as it was omitted by concern authority.
  • Only Check-in and check-out record from the hostel is maintained within the software.

FUTURE ENHANCEMENT

  • Online booking facility.
  • We maintain an attendance record of a trainee during training.
  • We Provide male – female reservation in hostel.

Above limitation can be rectified as per authority requirement

Tables Description:

This is table of “CouFac”, In this table we put the information of department of faculty head.

This is table of “Amount”, In this table we put the information of Amount of whole Training..

This is table of “employee”, In this table we put the information of employee.

This is table of “Faculty”, In this table we put the information of UserId and Password.

This is table of “gTraining”, In this table we put the information of lecture of Guest Speaker..

This is table of “Guest”, In this table we put the information of Guest Speaker..

This is table of “hostelCharges”, In this table we put the information of hostel charges..

This is table of “HostelEntry”, In this table we put the information of trainee stay in hostel.

This is table of “Trainee”, In this table we put the information of trainee comes for training.

This is table of “Training”, In this table we put the information of training conduct in organization.

This is table of “Transport”, In this table we put the information of transport used for training.

This is table of “FeedBack”, in this table we put the information of feedback of trainee given for training.

Conclusion:

We made a “Web Based Training Management System” for water and land management institute. This application provide them a automated system, which is very time saving then existing system in walmi.
We test this application by the different testing method and it works properly hence it is useful for the organization.
This application easily manage the training system.

Posted on

Motor Vehicle Loss And Damage Claimform .Net Project

MOTOR VEHICLE LOSS AND DAMAGE CLAIM FORM (E-COMMERCE TEAMWORK)

Project Requirements

In the motor vehicle, damage and loss can be claimed online by client and insurance company store those data.

In this client fills his personal information and then the vehicle information and incident information and claim detail.

Then when the client submits the claims details form it generates the flat file and stores the entry in the database of client side. When the server will check the form of server-side and will enter claim bill number if that flat file does not exist then will show file is corrupted and if the file exists then will show all the information and if the server accepts that the information is stored in the server database.

Data dictionary

  • Client Database
Field name Data type Description
Policyno Numeric Take policy no of client
Poexdate Date/time Enter policy exp date
Cliename Text Enter client name
Address Text Enter address
City Text Enter city
Pincode Numeric Enter pincode
Mobile Numeric Enter mobile number
Comname Text Enter vehicle company
Model Text Enter vehicle model
Serialno Numeric Enter vehicle serial number
Yearofpurchase Numeric Enter vehicle purchase year
Purchasefrom Text Enter the place from where vehicle purchase
Purchasebillno Numeric Enter the billno
Dateofincident Date/time Enter date of incident
Incidentadd Text Enter incident address
Incidentinfo Text Enter incident information
Firdate Date/time Enter fir date
Policystation Text Enter police station name
Claimdate Date/time Enter the date on which client claim
Claimby Text Enter the name who claim
Claimbillno Text Enter Claimbillno(p.k)
Claimamount Numeric Enter the claim amount
  • Server Database
Field name Data type Description
Policyno Numeric Take policy no of client
Poexdate Date/time Enter policy exp date
Cliename Text Enter client name
Address Text Enter address
City Text Enter city
Pincode Numeric Enter pincode
Mobile Numeric Enter mobile number
Comname Text Enter vehicle company
Model Text Enter vehicle model
Serialno Numeric Enter vehicle serial number
Yearofpurchase Numeric Enter vehicle purchase year
Purchasefrom Text Enter the place from where vehicle purchase
Purchasebillno Numeric Enter the billno
Dateofincident Date/time Enter date of incident
Incidentadd Text Enter incident address
Incidentinfo Text Enter incident information
Firdate Date/time Enter fir date
Policystation Text Enter police station name
Claimdate Date/time Enter the date on which client claim
Claimby Text Enter the name who claim
Claimbillno Text Enter Claimbillno(p.k)
Claimamount Numeric Enter the claim amount

Snapshots

CLIENT SIDE FORM

 

Client filled form and by clicking on submit button flat file is generated and will be stored in client database.

ALL THE VALIDATIONS

FLAT FILE GENERATED

Server-side form

Sever side auto-filled from by entering a claim bill number and pressing read button and by pressing the save button will be stored in the database.

Download the below-attached Loss or Damage Claim form for Motor Vehicle project code

Posted on

Bank Management System .Net Web Application project

System Analysis

System Summary: The West Bank Management System project involves the creation of a Web application that will enable the customers of West bank to:

View the details of all accounts that they hold with West Bank.

View the accounts statements for all accounts that they hold with West Bank.

  • Apply for loans online.
  • View the status of loan requests.
  • Requests for checkbooks for any of their accounts.
  • View the status of checkbooks requests.
  • Transfer funds from any of their accounts to another account in West Bank.
  • The Web application will also be used by the employees of West bank to process the requests for loans and checkbooks.

In addition, the application will be used by the administrator to:

Create User-IDs for customers, employees, and administrator and assign them the respective roles.

  • Link User-ID created for customers to the respective Customer-IDs.
  • Upload, edit and delete news items that will appear on the homepage.
  • Upload, edit and modify the information related to various types of loans.
  • Upload, edit and modify the information related to various types of accounts.

Each of the three types of users should also be able to change their password and retrieve their password in case they forget the password.

West-Side bank already has a computerized system in place that maintains the details of all the customers and accounts. The proposed Management System Web application will use the existing database to obtain the details of customers and accounts. Some additional tables may have to be created in the database to accommodate the specific requirements of the Web application.

HARDWARE & SOFTWARE REQUIREMENTS

Hardware: CPU, Mouse, Keyboard, CDs, Printer etc.

Operating System: Window 7 Home Basic-E Series, I3 Processor

Software: Microsoft SQL Server 2008, Microsoft Visual Studio 2008, Microsoft Office etc, Microsoft Office Word, Microsoft Office Visio, Google.

UML Diagrams:

Administrator Accounts Diagram

Customer Accounts Diagram

Employee Accounts Diagram

ER Diagram:

Database Coding:

Database Name Westbank

Car_Loan Tables Details:

  • State_Name
  • Current_City_Date
  • Current_City_Month
  • Current_City_Year
  • Residence_Type
  • Current_Residence_Date
  • Current_Residence_Month
  • Current_Residence_Year
  • Date_Of_Birth_Date
  • Date_Of_Birth_Month
  • Date_Of_Birth_Year
  • Model_Of_Car
  • Employement_Type
  • Salary_Deposit_Yes
  • Salary_Deposit_No

Table Create_Account Details:

  • First_Name
  • Last_Name
  • DOB_Date
  • DOB_Month
  • DOB_Year
  • Address
  • City
  • State
  • Pincode
  • Country
  • Phone_No
  • Email
  • Mobile
  • Status

Table Enrollment_Form Details:

  • First_Name
  • Last_Name
  • Address
  • City
  • State
  • ZipCode
  • Country
  • Tax_Id
  • Home_Phone
  • Mobile
  • Fax_N0
  • Email

Table Locate_Your_Branch Details:

  • Branch
  • Address
  • Telephone
  • Fax
  • ATM
  • Lockers
  • IFSE_Code
  • Working_Time

Table Saving_Application_Form Details:

  • Title
  • First_Name
  • Last_Name
  • Address
  • Pin_Zip_Code
  • City
  • Nearest_Branch
  • Email
  • Residential_PhoneNo_STD
  • Residential_PhoneNo_Phone
  • Office_No_STD
  • Office_No_Phone
  • Office_No_Extn
  • Mpbile_No

Table Customer_Acc_Create Details:

  • Account_Type
  • Customer_ID
  • Minimum_Balance
  • Opening_Balance
  • Overdraft
  • Fixed_Deposit

Table Customer_Acc_Update Details:

  • Account_Type
  • Customer_ID
  • Minimum_Balance
  • Current_Balance
  • Status
  • Overdraft
  • Fixed_Duration_Deposit
  • Maturity_Date

Table Emp_Create_Transaction Details:

  • Transfer
  • Withdraw
  • Deposit
  • From_Acc_No
  • To_Acc_No
  • Amount

Table login Details:

  • User_Id
  • Password
  • Users
Posted on

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.

Posted on

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.