Bug Tracking System .Net Project with SQL Server & ASP.Net

To create a new Bug Tracking System, which enables the user to detect the bugs and notify colleagues and administrators to get the rectification from them immediately.

This project “Bug Tracking System” handles the Organization details in the database in an efficient manner. This system is more innovative to use, any user can make up easier and faster transactions between employees. This site can be used under any private concern, for flexibly handling the databases, to get dispatches the data to process them for individual usages. Thus it makes the system more flexible, and more reliable for use.

For all the above this site is the perfect place for users, especially employees who preferred to save time and entered into the current trend.  Thus the entire project of the Bug Tracking System is clearly tested; all the modules are working correctly, as well as the output is verified.

Modules

  • Employee Details
  • Priority Master
  • Project Details
  • Status Fixation
  • Fast Search
  • Add Bugs

Module description

Employee Details:

The employee details module allows the administrator to make the entries for the employee with their proper identities such as name, email-id, mobile number and etc.
 
Priority Master:

The priority master module allows the administrative people to fix up the priority for the occurrences of the fore coming errors, which are assigned or created as high, low, medium, and so on.
 
Project Details:

The Project detail module allows the administrator to create the details about the ongoing projects, their issues, the status of the project, and its responsible person details.
 
Status Fixation:

The status of the project and the position of the bug is fixed by the user with its completion status, affection-causing range, prioritization, and so on.

Fast Search:

The fast search module allows the user to search the current project records in a simpler manner with details such as project name, respective person details, and so on.
 
Add Bugs:

The add bugs module allows the user to create the bugs which they are facing from their projects, and publish that problem to the general users for clarification, which leads other users to carry on the bugs and rectify them with their own ideas.

Download the Complete Bug Tracking System project source code, Report, and PPT.

E-Students Consultancy .Net Project using C# and SQL Server

The E-Students Consultancy project is a comprehensive web application that is most useful for simplifying the testing process. Its role is more visible in the business environment, as well as in other types of sectors. The system simplifies the testing process by assessing the student’s abilities and fitness. Because the world is a competitive world, it is difficult to examine every individual, and it can also lead to misunderstandings or inaccurate results.

This system is useful for managing the student inspection process; A new user of this system can register his identity to access its features. After successful authentication, this system generates a set of individual questions for users; The user can make their choice to select the correct option from the target test. After filling in the answers to each selection question, the questionnaire ends with an automated process of the system.

This system manipulates the results of the questionnaire, showing the set of skills of each user, creating a survey on the results, and helping the organization or any commercial sector to choose the right person for the ideal job.

existing system

In this modern world the existing online job searching system provides minimum secure authentication for the students that’s why the resulting process takes so much time. Students have to wait for a period to know the result of the attended online tests, even if it may take a month or a while. Each and every student are forced to register their identities on the consultancy site for the job and they have to wait until the respective persons respond to their registration.

So there is a chance to miss the other opportunities from others. Students are required to pay for getting the premium details (like Contact details) of the registered companies. To avoid this type of problem a new method of consultancy portal is required.

Disadvantages

  • Provides minimum security means for individuals
  • The major disadvantages of this system are low efficiency and time consumption. 
  • The maintenance cost of the existing system is high and it should be barred by the students only.
  • Students feel hesitation and there is an opportunity to miss other opportunities.

Proposed System

In this proposed approach individual secured authentication means are provided for each and every student and company, the student can enter into the system with proper identities, so it is easy to find the fraudulent people if any mismatching occurs. The E-Student Consultancy provides a bridge between students and corporate, which leads to attaining job offers and online test scenarios. Free access is provided so the students and companies can attain the details securely without any delay. The online test generation process allows the student to feel free and attend the test to know their individual talent. The result will be delivered immediately once the test is over. This system is used to test the students and their eligibility level.

Advantages

  • Secured login mechanisms are handled.
  • Reducing the workload of the companies and students.
  • Time consumption is comparatively good.
  • Easy access and Online Test Procedures make the students feel free to work.
  • Results will be delivered to students instantly.
  • Implementation and maintenance cost is low.

Modules:

AUTHENTICATION Module

REGISTRATION Module:

The E-Student consultancy provides two types of registration processes on the company side and the student side, in the company side the registration process depends upon the company name, contact details, and vacancy then creates the complete registration process. On the student side, the registration process is based on the personal detail like name, Mail Id, address, etc

COMPANY DETAILS MANIPULATION Module:

The company details manipulation process allows the user to create the company details with proper identities. The following details are required to register the company into the server: company name, contact, and the number of vacancies available in the company. These details are registered into the server, which is useful to the students to find out the company details and the number of vacancies available in the company, and address of the company. This is used to view the job vacancies in the company and reduce the job search time.

ONLINE TEST REGISTRATION Module:

The online test manipulation process is one of the major implementations in this e-student consultancy. That is used to test the student’s ability and fitness for the job. In the online test generation module questions are created by the company individuals and then it will be uploaded into the portal for student access. The students can register and attend the test which is created by the company individuals. The student’s mark will be calculated by the server at the time of completing the test. The student mark denotes whether a particular student is eligible for the job or not.

RESULT ANALYSIS Module:

The result analyzing process is used to generate the result for the test which is attended by the student online and the test generation process creates the result immediately once the student answers their last question. Once the mark is generated then it will immediately be transferred to the respective student mail.

Download E Students Consultancy Project.

Study Point C#.Net Project Report

OBJECTIVE

Study Point is a web project for all programming languages and software, which includes all online web-related activities for learning, as well as answers to questions from students, teachers, and developers.
We use a combination of surveys, focus groups, and personal interviews to reach students, teachers, developers, software developers, human resource managers, development companies, and more. Gather information. After meeting the requirements, we set these goals and objectives for the Port of Study Point website:

  • Get help from NET and JAVA experts and other users
  • To give you the best education, support, and advice.
  • Training schedule for registered users.
  • If you have an internet connection, you can easily find it anywhere in the world.
  • Admin can create an online discussion forum between all registered users and administrators.
  • Provide training materials and course content.

EXISTING SYSTEM

The Current system includes importing data into Microsoft Excel files and printing to storing data. When an administrator needs information about an e-learning student, he or she searches for specific files in the file system. Download the file to learn. Add hints of new technologies and new languages ​​to solve your research questions or applications or problems.

PROPOSED SYSTEM

The recommended system is a browser that is fully integrated into the web system that provides the main database. You can submit survey materials, questions, updates, and more online, and you can request answers from your address or email address. You will find information about training materials and new updates on the web.

The online database is stored, which can be downloaded by the administrator. All student, student, and developer information can be saved by entering the information on the web. Only one administrator can access it, which improves security and no one else can access the data.

SYSTEM MODELS


FUNCTIONAL DESCRIPTION

• Designed in general for user updates, access to training materials, and learning new technologies
• Administrator login
• Detailed information on new technologies and programming languages.
• User questions can also be solved.

MAINTENANCE

The site is easy to maintain and requires minimal operating costs. This site is designed for future reference so that it does not require continuous maintenance. Depending on the terms, the administrator can maintain the site freely as an administrator login.

MODULES:

HOME:

This module contains the name and logo of the baby planet. There is also a simple menu bar. Dynamic windows in the list of new skills, new teaching materials usually have strong updates. There should also be a “new” icon for newly added data.

ABOUT US:

This module provides information about the web pages of the Training Center and the GCRG Institutional Group that run the Learning Center.

OUR SERVICES:

In this module, we have the function to provide users with different technologies, different programming languages ​​, and troubleshooting.

OUR GALLERY:

This module contains pictures of our students, academics, and infrastructure.

OUR DEPARTMENT:

This module contains information about the course, Dean, HOD, and Point Research Trainer who oversees the GCRG Institute Group.

REGISTRATION:

This module is intended for students/developers/visitors who want to join the group and get help through the web port. Student/developer/project developers should register online to improve progress in general.
The main case has the following functions:

Name, type, type, current address, mobile number, email ID, job, profile picture, password, confirmation password, captcha number. A unique user ID is sent to the user’s mobile number.

CONTACT US:

This module is just a username. There are two main things to keep in mind on a contact page: one is static communication information and the other is dynamic form checks.

LOGIN:

This page works for logged in users. When you log in, you are using a web function. Join groups, receive support, help other group members, and so on.

DASHBOARD:

There are options in this module that have user services.

WHAT’S NEW:

This module provides information about new information languages, modern and existing technologies in the community, and the needs of the community where the project can be developed.

USER PROFILE:

This module contains detailed information about the users who visit the web.

DOWNLOAD:

For users who want to download the content of the training material. This is a download link for the content of this copy page that will be downloaded.

SHARE FILE:

On this page, users can add files, content, tutorials, and much more. This page contains services.

DISCUSSION BOARD:

This module can help students or programmers to solve problems in their field.

FEEDBACK:

This module gives users an understanding of the web, its services, and recommendations.

CHANGE PASSWORD:

This module allows the user to change keywords if he forgets or suspects that it has been stolen.

FEEDBACK MANAGEMENT:

Answer the user, student, student, or developer in this module.

ENQUIRY MANAGEMENT:

Answer questions from users, students, academics, or developers in this module.

DOWNLOAD MANAGEMENT:

This module discusses the content or learning material in the database for students and users, as well as those concerned with the content level.

USER MANAGEMENT:

This module handles registered Study point users.

SHARE FILE MANAGEMENT:

In this module, the administrator manages the shared file data in the database, and if necessary or not to ensure that the data is shared by the user, it will be deleted in the database.

WHAT’S NEW MANAGEMENT:

This module includes updates on new languages, technologies in the community, and current community needs.

CONCLUSION

The end result of the project is the creation of a web application that allows students and developers to access the web pages, where they can promote projects and applications in multiple ways and build a developer team. Groups are social units of different sizes that share values, opinions, numbers, and questions. 
This is not just a web portal, it is a direct product of the Vocational Education Council. We will add many more services later.

Download Study Point C# Net Project Report

 

Course Finder and Allocation Management Tool .Net Project

The Course Finder system is supported by students who enter high school. The purpose of the Course Finder software is first and foremost Internet users. This section discusses different courses and materials. The main purpose of this system is to search for secrets. An e-mail was opened at the university to participate in the new course.

They have many advantages such as school teaching, college photography, state-of-the-art exhibitions at the bar according to your classroom rain, course.

Generally, students will rely on candidates already studying at university to understand university details, but by using this software, they can easily understand the current status of university researchers. It is a tool for student purposes on the web. The student can search for university information, fees, academic records.

Purpose of the Project: –

The purpose of the “Course Finder and Allocation Management Tool” project is to facilitate the search for online universities by means of a package called the Course Study System.

The system has a registration module for students to forget their passwords, and at the same time, a new user enters the place where new students want to register and also an alternative to a forgotten password. A successful student can participate in a college search.

As modern organizations grow increasingly complex and computing works according to leaders, it becomes important for the coordination of individuals, groups, and computers in the modern organization.

Through this college search, students can find universities that can be adapted to their subject type and at the same time reduce search time.

Big cities where life is within a few minutes have to announce things. In this way, this online archived information helps students complete their search in a limited time.

Furthermore, students can go directly to the university directly from this site. At the same time, they can make the university of their choice.

Existing system

The current system is an intervention where students have to search for papers on campus and go to college to obtain university information.

The following is the usability of the current system.

  • It is difficult to find out about a college degree on a relevant course that is being sought by a student who is new to college.
  • More manual hours are required and reports are required.
  • It is easy to know important information about the environment and the found objects.
  • The signs of a college renovation are hard to maintain. 

The default system

Course attendees and course management systems are an application that delivers more than the accreditation hours to enable universities to successfully understand the relevant course. These applications collect data in a centralized way that is accessible to all users at the same time. It is very easy to manage historical data in a database. There is no specific training for users to use the application. They can easily use a device that reduces interference to normal elements and thus improves performance.

The purpose of the system

Course attendance systems are assisted by middle school students and higher education students who are new to the school. The purpose of the search engine software is first and foremost Internet users. The purpose of the course and attendance management is to give users of the information system the best information when it comes to looking for universities for the best results.

Download the attached Course Finder and Allocation Management Tool .Net Project full source code, project report, PPT

Course Finder And Allocation Management Tool .Net Project

Online Fee Challan Generation Project Synopsis

INTRODUCTION:

The project is a web-based application where the user can generate Challan to pay the fee. The system automates the conventional process of generating Challan by visiting the college website. The system would be having two logins: Admin and User Login. Admin can view student details and can even add or update things in their account.

Modules:

  • Admin login
  • Student/user login
  • Student details
  • The Fee details
  • Dues

Software Requirements:

  • Windows XP,Windows 10
  • Sql 2012
  • Visual studio 2017

Advantages:

  • This software is user friendly you will automatically feel the difference in managing the fee challan things on the implementation of software
  • It perfectly manages the fees by creating the student profile with demographic information, contact details and parent information
  • Using this software is completely safe
  • It also offers quick payment 

Disadvantages:

  • User must have a reliable internet connection

Online Laundry Management System Project Synopsis

Online Laundry System is an Integrated System of Laundries functional work, organize and maintain the Data necessary for operations.

This Online Laundry System provides user-friendly dashboards with login access for Admin, Web Admin, Accountant of Laundry.

Online Laundry System has modules to manage Customer Invoices for Pisces, weight, Package, Delivery of Pisces, weight, Package wise, and Barcode Generations many more. It has a fully-fledged Human Resource module to manage the payroll and pay slips.

  • Front End: ASP.NET, C#, Entity Framework
  • Back End: SQL Server 2017

The modules included in the Online Landry System are as follows:

  • Customer Registration: This Module Created and Registered new Customer in an application with their necessary and Basic information. Admin has Rights to create, Edit View and Delete all customer information. Search Customer also included in this.
  • Invoice Generation: After Registered customer, Admin can create Invoice for Customers.

Customer Have three option-1) He/She can choose Pisces wise Invoice-He/She can give a Clothes by Pisces wise.

2) He can choose Weight wise Invoice.-He/She can a bunch of cloth weight wise.

#) He can choose Package wise Invoice.-He/She can select a package for a month, in that no of Pisces are fixed.

In one screen admin can able to create an invoice and also he can see a last all invoices for a particular customer.

Bar Code Generation: Admin can generate a Bar Code for all selected items for a particular invoice for a customer. After generation, he can able to print barcode on label printer and tag on clothes.

Delivery: Admin can Deliver cloths depend on their status-(Ready, Pending, Delivered), Different Color show Different status, He can also take Remaining payment from and generate an invoice for taking payment.

Reports: Different Report are a presence in a system like

  1. Customer List,
  2. Due Payment,
  3. Daily Collection,
  4. Garment-wise Collection,
  5. Cash Book,
  6. Customer Total Business etc.
  • Dash Board– User-Friendly Dashboard available. Graphical Representation is also available. which shows
  1. Total Business
  2. Financial Collection.
  • SMS Integration –This system also includes SMS sending on all action and transaction performed for a customer like a Customer Registration, Invoice generation, Payment given etc.

Online Medicine Donation System Portal ASP.Net Project

Objective:

The aim and objective of this medicine donator project are to prepare a portal for the collection of unused medicine for further utilization by a needy person. The website must be like user can donate the unused medicine to NGO.
That NGO can help needy people. The user can donate the medicine.
It’s can be claimed by NGO.  They can collect from a particular place. There must be a login for the user, ngo, admin. Admin can see all details of user donated medicine. There must be a form like registration of the new user.
Medicine donate form. It’s must be tracked in the SQL Server database.

Project Description:

The Project is about the collection of medicine which is unused by the patient who recovers completely and medicine becomes waste that medicine can be collected and used further.

Modules:-

  • Membership and Registration:- To register and get membership donation of medicine.
  • NGO Details:- Different NGO’s can connect with portal and donate Medicine.
  • Donator’s details:- To Keep Donators details.
  • Help Desk:- To solves query of people.
  • Complaint and Suggestion:- Forgiving views and suggestion and also complaints if any.
  • Invoice:-Generate an invoice to give a record of their donated medicine.
  • Record Management:- To maintain the entire record properly about donators and their donation.
  • Collection of medicine:-Collection of medicine through courier.

Features:-

  • Easy to Access
  • User-friendly
  • Reliable and coordinative
  • Easy to handle

Tools and Language:-

  • Frontend: ASP.NET
  • Back End: SQL Management System
Requirements Requirements description
Registration for a new user The user firstly needs to register with the website.
Sign in for an existing user The existing user can sign in directly to the website.
Donation of medicine The user can donate any kind of medicine.
 Selection of  NGO The user can select the NGO.
Advance notification to the user The user will get a prior notification once the collection team will reach at the user end.
Notification through email The user will get a notification once the medicine is delivered.
Feedback form The user can fill up the feedback form.

Online Medicine Search Web Application .Net Project

SYNOPSIS

This “GOOGLE A MEDICINE” is an online medicine search web application. This application allows a visitor to search for a medicine and addresses of medical stores (wholesale and retail sales) where the medicine is available. This application is a solution. So, this web application is planned to develop based on the requirements of the client.

The client is a small scale pharmaceutical company that is distributing generic medicines to emergency medicines and having a good network of medical (retail) stores. Main need of the client is to prepare an online application to help the needy people in finding the availability of the medicine and a list of medical stores where the medicine is available. The visitor can quickly find the nearest medical store by selecting the area in the search tools.

This application also provides a login account to a registered medical store. Using this account a person from the medical store can update the list of medicines and their stock on daily-wise. This avoids providing outdated data to the visitor.

Emergency medical services for chronic health problems are depending on the availability of medicines. Most of the times, unavailability of medicines affect the lives of deceased persons. Addresses of medical shops that are providing 24 hours service should be made available to all. Some medical shops provide door delivery service for the needy people in an emergency even though the medical shop or distributor is not providing 24 hours service.

PROJECT DESCRIPTION

The application software is titled “ GOOGLE A MEDICINE ”.The tailor-made software which suites the requirements of a medicine searching software is developed using ASP.NET as front end and SQL SERVER as the backend

This project is an online medicine search web application. This application allows a visitor to search for a medicine and addresses of medical stores (wholesale and retail sales) where the medicine is available.

This application is a solution. So, this web application is planned to develop based on the requirements of the client.

This project contains the following module:

PUBLIC PAGES MODULE:

These modules are useful in providing information to a visitor (login is not required) about the website and contact address and numbers. The homepage displays the main features of the website.

MEDICAL STORE MODULE:

These modules can do add a new medicine to list, manage existing Medicines List, and edit or Update medicines stock and maintain the application settings

MEDICINE SEARCH MODULES:

This module can do for Search and advanced search for search results and search results filtration

ADMIN MODULE (Operator):

These modules allow an administrator of the website to manage cities and manage master data. And also provide Manage Medical Store User Accounts.

DATA FLOW DIAGRAM:

USER, ADMIN, USERLOGIN, MEDICINE SEARCH, BLOOD SEARCH, SEND QUERIES Dataflow Diagrams:

 

UML DIAGRAMS

Use Case Diagram: Visitor and Facilities

Use Case Diagram: Medical-Member and Facilities

Use Case Diagram: Blood Bank-Member and Facilities


Use Case Diagram: Administrator and Facilities

USE CASE RELATIONSHIP DIAGRAMS


ACTIVITY DIAGRAM FOR ADMINISTRATOR’S ACTIVITIES


ACTIVITY DIAGRAM FOR MEMBER’S ACTIVITIES

HARDWARE SPECIFICATION:

Processor: Pentium IV

Ram: 2 GB RAM

Hard DDisk: 80 G.B Hard Disk 

SOFTWARE REQUIREMENTS

Operating System: Windows Server

RDBMS: SqlServer

Web Browser: Internet Explorer

Web Server: IIS

Technology: ASP.NET

Languages used: C#.NET

DATABASE DESIGN

TABLENAME: USER LOGIN

ColumnName DataType Description
Sno Int Sno
UserID Varchar(10) UserID
LoginTime Datetime LoginTime

TABLENAME: USER QUERIES 

ColumnName  DataType Description
UserID Varchar(10) UserID
UserQuery Varchar(max) UserQuery
Reply Varchar(max) Reply
Status Int Status

 TABLENAME : BLOOD BANKS    

ColumnName  DataType Description
Sno Int Sno
UserID Varchar(10) UserID
BankName Varchar(50) BankName
Bgroup Varchar(10) BGroup
Stock Int Stock

 TABLENAME: MEDICINES

ColumnName  DataType Description
Sno int Sno
UserID Varchar(10) UserID
MedicineName Varchar(100) MedicineName
Dosage Varchar(50) Dosage
Stock int Stock
Pdate DateTime Pdate

 TABLENAME: PASSWORD

ColumnName  DataType Description
UserID Varchar(10) UserID
SQuestion Varchar(100) SQuestion
Answer Varchar(100) Answer

TABLENAME: USER DETAILS

ColumnName  DataType Description
UserID Varchar(10) UserID
OrgName Varchar(100) OrgName
Area Varchar(100) Area
Address Varchar(200) Address
City Varchar(50) City
Contactphones Varchar(50) Contactphones

TABLENAME: USER

ColumnName  DataType Description
UserID Varchar(10) UserID
OrgName Varchar(100) OrgName
Area Varchar(100) Area
Address Varchar(200) Address
City Varchar(50) City
Contactphones Varchar(50) Contactphones

TABLENAME: USER

ColumnName  DataType Description
Sno int Sno
UserID Varchar(10) UserID
Password Varchar(10) Password

Download the below attached Online Medicine Search Web Application .Net Project Source Code & database

Loss Control System for Insurance Producers .Net Project

Introduction

Insurance companies issue various types of policies to protect home and business owners from various types of unforeseen calamities such as fire, floods, theft etc.  However, prior to issuing or renewing a policy, the insurance company conducts a field survey of the property to ensure that the property is adequately secured and is not vulnerable to damage.  Thus the insurance company ensures that the chances of damage or loss are controlled.  For example, if a petrol pump has to be insured, the petrol pump owner should provide for adequate fire safety equipment, signboards prohibiting smoking near the fueling area etc.

In order to conduct these surveys, the insurance company enlists the services of independent surveyors residing near the property.  These surveyors are trained personnel and are pre-approved for certain types of activities.  The aim of the project is to develop a system used by insurance companies and surveyors to record the surveys to be done, assigning a surveyor to conduct the survey, capture, and approval of survey results, recording and approving of the surveyor’s Time and Expenses (T&E) Report. 

Workflow of the proposed system

Detailed Functionality

 1.    Record the Surveys to be done

Prior to issuing or renewing an insurance policy, the underwriting department raises an RFS (Request for Service) in LCS.  The details to be entered include –

Location to be surveyed

Type of insurance coverage (fire, theft, flood etc.)

Date by which the survey should be completed

Surveyor ID  (to be searched based on the location’s pin code)

Type of service requested (eg. Survey.  In future, the same system can be extended to verify insurance claims)

The estimated budget for the survey (This is the amount of money that the insurance company is willing to spend towards surveyor’s T & E)

The underwriter may also attach a copy of insurance policy application to RFS.

  1. Working with an RFS

Once an RFS is assigned to a surveyor, he/she starts working on the RFS.  The surveyor should be able to query the status of various RFS’s assigned to him/her.  Typical activities that are carried out by Surveyor on RFS include –

Scheduling a visit to the location – Enter the scheduled date and time in the system and update the status.

Survey the location and Write a Survey report – Attach the survey report to RFS on completing the site visit.

Writing recommendations and following-up on recommendations – Writes recommendations on the corrective actions to be taken at the location and updating the action taken on the recommendation.

Entering time and expense details – Record the time and expenses incurred to carry out the survey and the follow-up actions.  These details have to be entered by date and activity.

Close RFS – After all the details are entered, the surveyor closes the RFS.

  1. Approving Time and Expenses

The underwriter reviews the T&E reports and either approves or disapproves the expenses based on the budget.

In case it is disapproved, he/she cites the reasons for disapproval.  The surveyor is informed to update the expenses accordingly.

If it is approved, it is sent to the finance section for payment.

  1. Reporting

This module generates various reports for surveyors and underwriters.

For surveyors –  List of RFS by status,  List of RFS received or completed during a given period, Report on T & E for a given period

For underwriters – List of RFS by status (across surveyors or for a specific surveyor), List of RFS raised or completed during a given period,   T&E claimed and paid during a given period.

UML Diagrams:

Use Case Diagram:

Sequence Diagram:

Activity Diagram:

Class Diagram:

REQUIREMENTS

Software Requirements:

Visual Studio .NET

Front-End: C# in ASP.NET

Back-End: SQL Server

Hardware Requirements: 

RAM: 2 GB

Hard disc: 80 GB

Test Cases:

s.no Test case name Test procedure Pre-condition Expected result output Specification
1 Login Enter userid and password Displays pay bills form success Login
2 Login Enter admin and password  

Displays the status

success Login
3 Login Enter user and password Error message success Login
4 Pay bills Enter details Select billername, date, accountno Displays bill paid successfully success Pay bills
5 Add biller Select the biller Select billername Add biller successfully success Add biller
6 Add biller Select the biller Select name Displays as already exists success Add biller
7 View details As admin Displays list of pending transactions success View status
8 View details As admin Update status Displays status success View status
9 View details As user Edit date, amount Displays all transaction of that user success View report

Download the below-attached Loss Control System for Insurance Producers .Net Project Source Code

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