Employee Pay Management System C# / PHP Project Synopsis

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

User Types: Admin, Employee

Basic Modules involved in the project:

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

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

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

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

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

 Future Enhancements: 

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

Software Requirements:

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

It can also be done in Php, MySql as backend

Hardware Requirements:

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

Online Test Management Application Project Synopsis

Online Test Management:

Online test application will provide an Online platform wherein students will attend online objective questions. Grades will be provided as per the number of questions that were answered correctly. This concept will use an admin panel as the backend for loading the questions and also identify whether the student has selected a correct answer or not. Questions will be segregated on the basis of different subjects.

The option will be there to add subjects also. Admin panel will be saving the data and communicating with DB via web service or API.  It will have a flow wherein a subject will be selected and that will load respective questions. Once all questions are answered result will be published there and then.

A student can see grades as per the number of questions that were answered correctly or will calculate the marks for all correct answers and show percentage of marks.

The whole process of conducting the test and checking them and then grading them was a tedious manual process and time consuming too. This whole process can be avoided by adapting to a new online text conducting application that will allow  a easy to approach UI wherein students can save their answers and also being graded much faster and their by publish results soon.

This software will also be secured as it will provide code match system which admin will provide to the student which each of them has to enter to start the exam. Student will also register themselves to appear to this exam. After successful registration admin will approve the registration and then the student will login to the online application system. We can also implement time constraint check for the completion of the exam after which student cannot attempt any question.

User Types: Admin and Student

Modules:

Admin:

  • Subject: Will have the option to add subjects for which questions will be uploaded.
  • Questions: This module will select a subject and then add questions to it along with correct answers for the same. This actually helps in checking whether student gave the correct answer or not. This part is basically admin panel which manages the question and answer that are save in DB and then provide instant results too.
  • Student: Admin will approve student registration for attending test online. Will also post results for different subjects for which student has appeared.
  • Grades: Admin will define grades as per percentage of correct answers given by the student. All those calculation are taken care in this module.

Student:

  • Exam: Once logged in a student will have set of questions which will be objective and he or she has to select the correct answer. It  will be a UI with questionset being loaded on the basis of the subject selected.
  • View Result: This module will be a UI where in result will be shown in a grid grouping them subject wise. Grade and percentage of marks will also be shown for the student who has appeared for the exam.

Contact Us: Will show info related to contact numbers and also search filters.

Future Enhancements:

  • We can provide email notifications and SMS integration. This will require web service or API integration with SMS providers and SMTP configuration to handle emails. It will notify students once results are posted by admin.
  • Add Blogs that can be posted by students.
  • We can plan a social platform in the same application where in students can chat with other registered students. Can also like comment and share posts from other students. Admin can also post info and students can access it. Post pics and share them too in groups created by students.

Software Requirements:

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

It can also be done in Php, MySql as the back end with other frameworks

Hardware Requirements:

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

Sales Management Portal .Net Project

The Sales Management System should have, but not limited to, the features and functionalities as below

1)  Search: allows users to staff find clients by names, either on the complete or partial match.

2)  A filter for browsing: can shorten the list and separate prospects from current clients.

3)  A sign-in form

4)  Manager Console: Managers can create user accounts, view, and update entries, leave comments on entries, and send messages to staff, etc.

5)  Pipeline Reports: Managers should also be able to run various reports such as lists of prospects, reports of opportunities or proposals by dates, sales projections by month or by the salesperson, project tracking, etc.

Features described in this document may require, but not limited to, the following advanced technical knowledge and skills for:

  • HTML programming and CSS styling
  • Responsive design
  • The user authenticates and authorization
  • SQL database and programming
  • Site navigation
  • Application of state and cookies
  • Validation controls
  • API and Web service programming
  • Test and debug

Students should study and try to incorporate as many features and functionalities as possible in their projects

Portal Homepage

Main page after user logged-in

  • Announcements section displays manager’s messages in the order of dates.
  • Left-hand side panel displays a list of all clients in alphabetical order.
  • Users can search clients by names, also can filter the list by types, client or prospect.
  • The new prospect can be added by clicking Add Client.

Illustration of a pipeline for a client

After staff selects a client from the main client list, the page shows a sales pipeline for the selected client: General Info, Contacts, Notes, Opportunities, Proposals, and Projects.

The illustration shows the Contacts page

Database Design

Below are some essential information used in a real-world sales pipeline. It is recommended to incorporate them in your database design.

Pipeline: Opportunities

  • Opportunities Name
  • Added by
  • Date Added
  • Chance to close (percentage)
  • Estimated Budget
  • Opportunity Duration
  • Opportunity Type (a list of major products and services )
  • Contact Name
  • Contact Telephone
  • Opportunity Description
  • Opportunity Notes

Pipeline: Proposals

  • Proposal Name
  • Account Manager
  • Date Added
  • Chance to Close (percentage)
  • Estimated Budget
  • Proposal Duration
  • Proposal Amount
  • Total Revenue
  • Proposal Status (a project is automatically created when proposal status is set to accept )
  • Rejection Reason
  • Contact Name
  • Contact Telephone
  • Description
  • Proposal Notes

Pipeline: Projects

  • Project Name
  • Project Manager
  • Date Added
  • Project Amount
  • Total Revenue
  • Project Duration
  • Project Status
  • Launch Date
  • Contact Name
  • Contact Telephone
  • Project Description
  • Project Notes

Download The Sales Management System .Net Project Code, SQL Database & Output Screens.

Online Resume Management .Net Project Synopsis

Online resume management will basically provide an online platform that will provide an option to upload a resume and then search for jobs relevant to the skill set. It will have admin panel which will allow admin to manage different features. It will maintain information related to users who will register and apply for jobs as per skills. This application will provide an option to apply for different Functions or Verticals and allow users to apply for different skills as per choice.

User Types: Admin, Users

Modules:

Admin Module:

It will be accessible to Admin and he or she can add or manage Filters, Employers of Choice, and Job Openings.
→ Job Openings will have the option to add info related to Job title, Company name, Skills, Location, Experience, Posted On, Company Logo, HR Name, Contact no
→ Filters will have options to add different values to filters, like Bangalore / Hyderabad etc in Location. The grid will be provided with different Filter Names and will have the option to add/ Edit option to add Filter values. The option will also be there to add Filter heads.
→ Employers of choice will have the option to add a company logo. Description / About US, Jobs of that company. Admin can add as many Employers of choice and they will be added to the dashboard.

Home Dashboard:

This is basically the dashboard for all users (registered or unregistered). It will show different options like Search filters, Employers of Choice, Login / Register, Upload resume, Job Openings etc. Employers of choice will be added by admin. Job openings info will be added by admin.
Search: This module will provide filters that will allow searches for different conditions. Filters related to Skills, Function, Industry, Location, startups etc will be provided. This module will be accessible to both admin and user. Admin will manage filter updates, like adding and removing different filter values. Users will able to see these filters managed by admin in the home dashboard.

Registration Module:

It will have a complete and comprehensive form which will lot of options to be selected and save relevant information. It will have options to save First name, Last name, Middle name, Password, Re-Confirm password, Current Location, Total Exp, Industry, Function, Key Skills etc for submitting initial registration information.

Notifications:

This module will show notifications whenever admin adds new Job Openings or add Employers of choice.

Contact Us:

Will show info related to contact numbers and also search filters.

Future Enhancements:

We can provide email notifications and SMS integration. This will require web service or API integration with SMS providers and SMTP configuration to handle emails.

Provide package plans for users with related services.
Add Blogs that can be posted by users.

Software Requirements:

Technical Aspects:

Database: SQL Server 2008 and more

Language: C# and Asp

Framework: .Net

Front-end: HTML, CSS, JavaScript

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

Hardware Requirements:

Intel Core processor

RAM 4GB and Above

HDD 100 GB Hard Disk Space and Above

64 or 32 bit OS Windows 8 and above

Lab Test Management .Net / PHP Project Synopsis

Lab Test Management Synopsis:

Project Understanding: This Lab Test Management project basically will be used by the Diagnostic center and it has to provide the main functionality of adding lab test to the applications on ad hoc basis whenever needed. The main functionality should involve the addition of lab tests which will be used later at any point in time to generate bill receipts for patients who come over to center for various lab tests. It will also have reminders functionality which will send SMS notifications to customers in regard to various lab tests that need to be performed in specific time frames. The application will also provide registration for customers and also maintain their history, reports etc. It will also involve doctor registration who prescribes lab tests.

User Types:

Admin, Front Office, Manager, Lab Technician, Customer

Admin will have access to all modules. Can add lab tests from back-end via admin panel.

Front Office can access

Basic Modules involved in the project: 

Reporting

For this module, we will initially provide Option to gets reports like tests done on a daily, monthly and yearly filtering reports and costing related reports. Will discuss more with a client for specific reports which they will look out for.

User

This module will allow customers to register. It will have Personal details, Address, package selection option which diagnostics center provides, submit home collection request, view history related to reports and tests that were done previously, schedule a lab test.

Lab Test

It will be accessible to Admin and Manager only. These modules will allow the addition of categories to the system. Each category will then be linked to Subcategories and each subcategory will have different lab tests linked to it. A Lab test that needs to be added will have Lab Test name, Lab test Code, Methodology, and Disease info. Filter criteria will be provided to segregate and search lab tests. Each lab test will have the option to add price to it. (Need info related to CGST and SGST info which need to be shown at the time of report generation).

Doctor

Admin / Manager can add doctor details to the application. Doctors added to the application can be easily searched while generating receipts for lab tests. Basically, doctors added to the application are reference doctors who prescribe for lab tests.

Notifications

(SMS package integration → client needs to purchase SMS package / SMTP email configuration).

Reminders

This functionality will be implemented such that it sends out alerts to patients reminding them to schedule a lab test which has to be done after a specific interval of time frame. For example, a diabetes patient has to get his blood profile done to monitor sugar levels, we will send reminders to the patient that will go put after every 30 days suppose as SMS and email.

Lab Order management

This module will be used by the Front office to book lab tests for walk-in patients, generate receipts, register customers.

Admin panel details:

This will basically be the back end of the project. A separate link will be provided for this panel and is accessible only to admin. It will provide a secure back-end management of data and structural approach to the methodology followed while saving data.

Sl No Task / Module
1 Admin, Front Office, Manager, Lab Technician, Customer
Registration, profile management, change password, email verification of the user
2. Lab Test management
3. User / Customer management
4. Notifications and Reminder management
5. Doctor profile and registration
6. Reporting module
7. Lab Order management
8. Testing
9. Bug fixing and feedback changes

Details:
Lab test:
Main Category: All (slug for filtering)
Allergy / Diabetes etc

Add lab test details:

Lab Test Name: 5-HYDROXY INDOLE ACETIC ACID

Test Code: 9952

Diseases: biochemical diagnosis and monitoring of intestinal carcinoid syndrome

Methodology: ENZYME IMMUNOASSAY

Notifications:

→ Option to notify customers once results of lab test are ready

→ Option to notify customers via SMS or email for reminders related to periodic lab tests

→ Option to notify scheduled home sample collection info

→ Option to notify billing info for a lab test.

→ Will notify customers once they are registered successfully.

Reminders will work in the same concept as provided by the client.

Technology to Use:

Design and Markup

– HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behaviour
– AngularJS will be used for making the site responsive and secured as per scripting is concerned.

The server-side language (anyone can be used depending upon your preference)

– PHP (Core PHP or any framework like CakePHP, Phalcon or Laravel)
OR
– C# and Asp (with a bootstrap framework or DNN skin)

Database Software (anyone can be used depending on your preference and server setup)
– MySQL
– SQL Server

→ We will suggest a server also.

→ This app will need maintenance for sure on a monthly basis. We will look forward to monthly maintenance charges.