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

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

Online Verification System Project Synopsis

Online Verification System

Verification process in other words background verification is very important nowadays for a lot of companies. It actually allows companies to validate the info provided by their employees are true and correct without any discrepancies.   

User Types: Admin, user, verifier

Admin will basically approve verifier login. Admin will also validate all data has been posted to the portal via a user and gives final approval for a submitted proof and details once a verifier validates the data. This portal will have 2 step validation process making it a secure and accurate verification system. Admin will upload content related to rules for different sort of documents which need to be uploaded by a logged in user and also set up rules which will be considered while verifying data provided by a user for a logged in verifier.  

The verifier will log in and validate the details and attachments that have been uploaded by a logged in users as per criteria and rules for documents that are needed. Once verifier validates the details provided and verifies the attachments uploaded by the user, he or she will update verification status for a particular user. This will be then sent to admin for final validation approval or verification approval.

The user will register and once registered they will have a dashboard which will show them rules related to various points under scrutiny. Once registered they will have different modules where they will save the details whichever required.

Modules:

  • Personal Details
  • Educational details
  • Professional details
  • Documents
  • Login / Logout
  • Dashboard
  • Admin

Personal Details: This module will ask the user to save details like First name, Middle name, Last name, DOB, Marital status, Residential Address, Father’s Name, Mother’s Name, Spouse Name if married,  Email, Phone Number, Alternate Number, City, State, Country.

Education Details: User has to save all details related to 10th, 12th Graduation and post.Information related to certifications.

Professional details: User will save all details related to job exp and companies wherein he or she worked previously. Date of joining in the current organization.

Documents: User will upload related documents to verify the professional details saved in the portal.

Admin: Will have a grid to approve and validate data related to a user for final approval. Admin will also have a grid to approve verifier login. Reports will also be provided to see how any users submitted data, how many validated by the verifier, how many users have been validated completely. Different type of reports can be added depending on the requirement.

Future Enhancements:

  • We can come up with SMS / email alerts for registration messages, validation complete messages etc.
  • We can provide reports module with the different type of reports for admin login related to sales, order and customer reports.
  • We can introduce plans like getting contracts from different organizations and managing users on the basis of organizations.
  • We can add payment related module for online renewals related to licenses concept related to organizations.

Technology to Use

Design and Markup

– HTML5, CSS3, JavaScript & jQuery

– Bootstrap / Angular JS

Server side

– PHP OR .Net with framework

Database 

– MySQL

– SQL Server

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

Student Feedback System .Net Project

This project is a .net based website which is getting all the feedback from the student through online.

Modules included in the project are below:

  • Admin
  • Coordinator
  • Faculty
  • Student

Output Snapshots and description for the admin, Student and Faculty Modules:

Admin page:

Admin Login Page:

ADMIN HOME PAGE:

ADMIN -> STUDENT REGISTRATION FORM

ADMIN FACULTY REGISTRATION FORM:

ADMIN NO. OF USER LIST:

ADMIN FEEDBACK REPORT AT EVERY MONTH

The percentage is calculated by taking the reference from the no. of students.

ADMIN CHANGE PASSWORD :

Coordinator

  • Homepage:
  • Coordinator Adding subject :
  • Coordinator adding feedback questions:
  • Coordinator View added the subject :
  • Coordinator assign subject to the lecturer

Faculty

Homepage:

Faculty add the student

• Student list who all registered for there course and a particular subject. That should automatically come to the student name in their form.

• And they should select the student who opted for the subject and gives them rights to them to give the feedback.

• The student who are regularly attending the classes they should only give it.

Added student list will be displayed on another page.

  • Student home page
  • Student change password
  • Student feedback form

This questions should automatically come from the coordinator added question list.

If this student doesn’t have permission to give feedback on this subject that should disable those rows automatically.

This complete Student Feedback System project front-end developed using visual studio 2010 backend SQL server database.

Download this Student Staff Feedback System .Net Project Code, Database Files, Attached the latest updated code with all feedback functionalities.