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

Crystal Market E Kart Web Portal Project

Abstract

This concept basically related to a portal which will allow dealers or vendors and customer linking on a common platform. This portal will be a web platform wherein vendor will register and add crystal products. They can also differentiate and highlight special crystals as per horoscope ( as they have a huge market). Once crystals are added they will be available for sale which can be searched and added to kart by customers for buying. Portal will provide an easy to use and responsive website.

Project Description in Brief:

The requirement will be to develop an admin module which will be used to sell products, register vendors, register customers, cart functionality and related crystals functionality. We can also manage coupons from admin panel. This will also involve web service / API which will communicate with Website front end and database and save data securely via admin panel.
We will also have employee management wherein executives delivering the sold products to customers will be registered and in turn, will track the delivery part. The application will involve order management and delivery. This will involve executive, the order created and tracking id.
The application will have an informational part too like About US, Terms & conditions, Privacy policy etc which basically will be static pages.

User Types: Admin, Customer, Employee logins (no vendor login as discussed)

  • Admin will have access to all modules in the web and can monitor everything in the application.
  • Customer / Buyer will have access to crystal products view and can browse through and access offers and then finally add products to the kart and order the same.
  • The employee is basically the delivery executive login who will actually manage the deliveries and will have access to the related delivery management screens only
  • Vendor / Seller is basically related to sellers who will register themselves, add their products to the admin panel and the added products will be marketed via the website.

Modules:

Users Modules: Will involve login, registration and log out as the basic functionalities. Users will also have My basket functionality to manage the crystal products added to the kart. My orders will deal with the story of transactions and orders for a logged in and registered customer. My profile will have edit, delivery address manage option, change the password and other details that are necessary.

Admin Panel: Admin being an important module will manage delivery executive employees and their delivery history as it will be linked to order and delivery management. Customers also will be managed by the admin panel. Vendors will register to the application and we can manage vendors via admin panel. Registered vendors will be able to add their products which will be advertised for sale in the crystal market portal. Admin will most importantly manage the categories and subcategories that are involved in adding products and then their sales via the portal. It will also manage the filters that will be provided for searching for various types of crystals.

Kart Module: This Module actually will handle the addition of crystal products which are anticipated to be ordered by a viable customer.  It will be then linked to order management and delivery tracking.

Delivery / Order tracking: It will basically show which order is linked to a particular executive as admin will assign it to a particular executive. Complete delivery status can be tracked in this module. As per order management is concerned once a product is confirmed in kart it will be transferred to order tracking as an order id is assigned to it. And then a delivery executive is assigned an order. This workflow actually provides a flexible tracking system.

Future Enhancements:

  • We can come up with SMS alerts for delivery tracking and registration messages.
  • We can provide reports module with a different type of reports for admin login related to sales, order and delivery reports.
  • We can also introduce a comprehensive invoice module too.
  • Add coupon management system via admin panel

Technology to Use

  • HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behavior
  • Bootstrap / Angular JS will be used for making the site responsive and as a framework.
  • PHP (CodeIgniter, CakePHP, Phalcon or Laravel) OR .Net with framework
  • 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.