Computer and Laptop Service Management System Project

Project Introduction:

  • Computer and laptop service centers are in great trouble with the manual operating systems such as they cannot maintain the data of Vendors, Products, Reports of Laptop Service Customers & Employee details.
  • This (LSM) application is used to maintain the Major Data of both product and customer details.
  • They have maintained the secret (PII) data on their server and the documents and files are stored on a computer. Now the manager will allocate the work to their employees of different branches based on the technician available.

Overview of the Project:

The main users of the LSM application are given below:

  • The administrator: The management staff at his office is the administrator of this system. He will take decisions on different tasks whether to issue them or not.
  • The employee: The employee gets the service job on his home page. The employee checks the problem with the laptop & computer and finally solves the problem and updates the status.

MODULES:

  1. Registration module
  2. Login module
  3. Admin module
  4. Customer module
  5. Employee module

REGISTRATION MODULE

  • In the registration module, the admin will register employee details, and branch details and create individual passwords, and usernames.
  • Both registered employees and customers can log in to the system by entering their login id and password. Admin also has login credentials to manage the whole application.

ADMIN MODULE

  • The administrator has full authority over the website. Only the administrator can add employee, and branch details like adding a new branch, laptop service job allotment, job status view, sales of this month, and editing employee details.

CUSTOMER MODULE

  • The laptop and computer problems will be solved by employees and they will update the status in the job receipt form. Customers can open the status view login by entering the job number and mobile number and clicking submit to display the status of the job.

EMPLOYEE MODULE

  • On the home page employees can register for laptop & computer service forms and they can update the service status. And also, how many jobs are allotted to an individual employee. This is an employee module.

ADVANTAGES OF THE PROJECT:

  • Evaluated their employee effort
  • They are maintaining employee data, and customer data.
  • Meanwhile, the application will forecast the Business of their Budget year.
  • Generate the various reports into Grid View as well as the same report will be generated into an excel sheet
  • Invoices can be printed into their letter paid.

You can also visit & download the .Net Application project on Computer Store Management System Project

Software Requirement:

  • Framework: Framework 4.5
  • Language: Microsoft C# .Net Language.
  • Technologies: Asp.Net, Ado.net
  • IDE: Visual Studio 2012
  • Operating System: Microsoft Windows 7
  • Professional Database: Microsoft SQL Server 2008

Hardware Requirement:

COMPONENTS

MINIMUM

RECOMMENDED

Processor

Pentium inside

Intel

Clock Speed

700 MHZ

1 GHz or above

Cabinet

AT

ATX

RAM

256MB SDRAM

512 SDRAM or above

Primary Device

1.44MB Floppy Drive

1.44MB Floppy Drive

Hard Disk

20GB

80GB

CD-ROM

40X CD-ROM drive

52X CD-ROM drive

Display Unit

14” Color Monitor

15” Color Monitor

Keyboard

104 Key Board

107 Key Board

Mouse

2 Button Mouse

3 Button Scroll Mouse

Modem

33.6 Kbps Modem

56.6 Kbps FAX Modem

Sound System

100 W Sound System

380 W Sound System

Pages:

  • Registration
  • Homepage
  • Employee Entry
  • Employee Details:
  • Branch Details
  • Job Check-In Page

Conclusion:

  • In this system, we are hosting the website so working on this system will be online.
  • The designing of registration and authentication modules and connecting them to the database. So that this system will be useful for all laptop service center branches, employers, and customers in all ways.
  • Using this project, time and money can be saved because we are using an online system for all its work. Thus, this project is made for the welfare of society itself.

Also, Read this Online Computer Store .Net Project

FUTURE SCOPE OF THE PROJECT:

This project “LAPTOP SERVICE & MAINTENANCE” will be implemented in the future after making some enhancements as we make our project at a low level. So, the modifications that can be done in the future to our project is to check how interactive the employee is with the customer in the chat box to clarify. And also, feedback on the service can be recorded for social users to trust our service center. Similarly, various modifications can be done to enhance the usability of the given project as suitable for the user’s requirement.

College Sports Management System .Net Project using Asp.net, C#.Net and SQL

PROJECT DESCRIPTION: The College Sports Management System’s objective is to provide a which manages the activity of many sports at a time. It also manages the registration process and announcement of the results.

Modules

Add sports

We can add new sports into the system so that we are able to retrieve them later during the registration process. The sports added would be viewed during the creation of a new intra- college or university tournament.

Add Scoreboard

We add a scoreboard so that the students can view it and the results of each match are announced here so that there will be only one platform for the results. This would reduce the chaos during the score announcement.

Add Tournament

Each tournament from an intra-college or a university can be added here. It later would help in the registration of any sports in that tournament. While adding a new tournament the system would show the set of sports that are entered into the system by the director of the sports so only those sports can be included in the tournament while creation.

Remove Sports

This module will help in the removal of any sports that the sports director thinks are not needed in the system. The removed sports would not be shown anywhere in the system that includes during the addition of a new tournament.

Edit Scoreboard

The added scoreboards would be updated here. This module helps in updating the scores on the scoreboard. Only the scoreboard which is added using the add scoreboard module would be present here and only these scoreboards can be updated. We won’t be able to add a new scoreboard here.

Remove players

This module would remove each player after each round of the tournament. So that only the existing player will be present and the one that is not qualified for the next round would be removed using this module. This would give a clear picture of the qualified players. As well as the player from the college team I can also be removed.

Remove Tournament

After each tournament in the college or a university, we should remove it, so that there won’t be any confusion between different tournaments which are going to be held later on. This module would help in removing all the details of the deleted tournament.

Registration Individual

This module would help in the registration of individual sports events held in the tournament. We selected the tournament in which we want to be part and the sports in which we want to participate in and the player would add his name and the required details asked in the registration form. After all these processes then we can click on the submit button and the student has registered for the tournament that they wish to participate in.

Registration Group

This module would help in the registration of group sports events held in the tournament. We selected the tournament in which we want to be part and the sports in which we want to participate in and the set of player’s names would be added and the other required details asked for in the registration form. After all these processes then we can click on the submit button and the student has registered for the tournament that they wish to participate in.

Payment

This module would help with online payment. So that the students wouldn’t have to stand in a queue or have hard cash in hand in order to do any payment to the sports department. By using this module we are reducing a lot of paperwork and we are giving the students the liberty of doing the payment from wherever they are.

  • This College Sports Resource Booking Project is related to the College Sports Management System Project. You can also visit & download the Android Application project on College Sports Resource Booking

SYSTEM STUDY

EXISTING SYSTEM

The existing system is more of a manual work, where the students have to walk up to the sports department and have to register for the events that they desire to participate, it’s not just the registration process but even other activities such as the announcement of the result, the payment, etc. This results in a lot of paperwork and the chance of the data getting mixed up is high. In the existing System, students are not able to get proper information about the games conducted in various venues. The student needs to spend a lot of time to get the information about the game. The student should attend the venue to get information on the game which takes a lot of time. The information such as the qualified player’s list, the timing of the event, the score of the sports happening, etc.

DISADVANTAGE OF THE EXISTING SYSTEM

  • Involves a lot of paperwork
  • Students have to walk a lot for the registration and other sports-related activities
  • Data getting corrupted is high
  • Human error is common during intra-college and university tournaments.
  • The students need to visit the venue to get all the information about the tournament and would have to wait for a long time.
  • Manually recording all information with regard to all data and manually creating the contest schedules, coordinating facility usage, and hand-registering athletes and teams. The dissemination of information would require that documents be typed, photocopied, and put up on the notice board or common place where students can view them.

You can also visit & download the website project on University Leave and Outing Pass Automated System

PROPOSED SYSTEM

In the proposed College Sports Management System student can get all the information about various games and the venue.

OUTPUT SCREENSHOTS

  • Sports team
  • Adding new tournament
  • Adding new sports
  • Removing sports
  • Removing Players
  • Index page for Registration
  • Registration form for intra-sports
  • Registration form for group events
  • Admin Login
  • Index page
  • Admin Home page
  • Adding scoreboard

You can also visit & download the web application project on Student Activity on Sports System

CONCLUSION

Sport is a part of the curriculum in college. Hence it’s time for the sports department and its activities to be automated and go online as it will be beneficiary for everyone who is associated with sports in college. The “College Sports Management System” project will assist the sports department of the college and would help the students in saving a lot of time in searching for games being conducted in the college. Our project provides students to get register from anywhere and anytime. It helps the administration by streamlining the current intra-college sports event administrative practices. Specifically. It will allow the administrators to configure a set of Tournaments into the system and simply record the results of those contests so that administrators and the public can track the teams during the course of the tournament.

.NET Framework makes the application robust, secure, and reliable. This system provides better scalability and is open to more enhancements. More levels of abstraction can be implemented at the front end and back end, thereby making the system easily adaptable to any changes in the environment.

The software developed was implemented and tested with real data and was found to be error-free. Also, it is found that the system works successfully. The user has to provide their personal detail to buy a package. All the necessary validations are carried out in this project so that the company can make use of this software and the necessary messages make them conscious of the error they have made. Henceforth, valuable reports have been generated for this organization.

You can also visit & download the Java and MySQL-based web Application project on Sports Event Management System

Download the Complete College Sports Management System .Net Project with ASP.Net, C#.Net, and SQL Server.

Professor Online Question Paper Submission to the Examination Cell ASP.Net Project

Introduction

Online Question paper submission is a web portal that is developed or implemented in the ASP.NET domain or platform. This project is helpful for the Professor to submit the question paper to the examination cell or to the Examiner from this site. In the current generation preparing the question paper and handovering in the examination cell is not that much security. This project is developed for a Professor to maintain his details, experience, and preparation of question paper and submit the same to the examiner. The examiner also gives his information, experience and takes approval from the administrator, and then selects the question paper. This project will work on the same line of online examinations; Apart from this, it contains much more additional information such as Course type, Department details, and other details of professors and examiners in this web portal.

For the examination cell, it is very difficult to identify whether the particular question paper is submitted or not. The online Question paper submission portal is implemented in 3 main modules. Professor module, Examiner module, and Admin module. Admin module will add multiple courses and departments under different branches so Professor can easily know the best details of about subjects. The professor module ought to register with the application and choose the course and upload the question paper to the site.

Scope of the Project

The scope of the project is used to manage the details of the professor, Examiner, and Administrator. The Professor and Examiners Sign up by providing the appropriate information and then take approval from the administrator. According to course-wise Professors prepares the question papers and send them to the examiner, then the examiner selects the question paper and submits it to the board. And all these records are stored in Online Question Paper Submission Database. 

Design of the Project:

ER Diagram:

Main Modules of the Project

Administrator

 He administrates by giving approval to Examiner and Professor’s Signup. He also creates Courses, Departments, and Designations in order to fetch the correct and appropriate question paper for that course and department.

Course Details

 It is created by the Admin and it consists of Details of specific courses like BCA, BBA, BCOM, and more. The professor sends the Question paper on the basis of the Course.

Department Details

 It is created by the Admin and it consists of Details about the entire department which is created. The Department section consists of the Department name and Address of that Department.

Designation Details

  It is created by the Admin and it consists of Details about the Designation of a particular professor. This section consists of  Designation names like Ass-professor, HOD, and so on, it also has a description section under the Designation name which helps us to know which particular department the professor’s designation is from. 

Professor’s Signup

 In this section, any professor can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the professor, password and confirms password to confirm, phone number of that particular professor-main ID, and at last the address of that professor.

Examiner’s Signup

 In this section, any Examiner can sign up. But the request is only approved by the Admin. This section consists of the Login name, name of the examiner, password, and confirm password to confirm, and here it consists of designation and department where the examiner can select any of the given designations and department. At last, it asks for the Address and a photograph of that particular Examiner.

Approval for both Professor & Examiner

 This action is performed by the Admin. He approves both professor and Examiner. 

Login for professor & Examiner

 A Professor who has been approved by the Admin can now log in to the Login section and the same for the Examiner too.

Details of Question paper

 Every Question Paper must be sent with appropriate details so as to know more about the paper at a single glance.

View and Edit the Question Paper

 It is viewed and Edited by the Examiner and it is submitted to the University.

Final Reports

It creates and shows all the database records of this project.

Screenshots of Online Question Paper Submission System:

  • Home Page
  • Admin Login Page
  • Admin Main Screen Lists Section
  • Admin Main Screen Create Section
  • Admin Main Screen Approval Section
  • Admin Department list
  • Admin Designation List
  • Course Creation Section
  • Department Creation Section
  • Designation Creation Section
  • Home Screen Signup Section
  • Professor Signup
  • Professor Approve Section
  • Professor Main Screen
  • Examiner Signup Section
  • Examiner Approve Screen
  • Examiner Approve Page
  • User Login Page
  • Examiner Main Screen
  • Examiner Document Viewing Screen
  • Professor New Question Paper Screen
  • Examiner Acknowledgment Screen

Conclusion

It is believed that in the future Online Question Paper Submission centralized document system with the concept of cloud technology will recede in importance as a strategic application to become a competitive necessity that must be adopted by most government departments.

India is striding smoothly towards integrated E-Governance.  In the next five years, situation will be entirely different.  Most companies are adopted cloud technology for the maintenance of documents.

Online Question Paper Submission creates a new trend in maintaining and verifying documents online and it reduces the workload. 

Future Enhancements

  • The news feed is essential for our day-to-day purpose; hence we will add a section about the news. There, we are going to display the news about examination dates, deadlines for submitting papers, etc.
  • We are going to add some more security to our system like an OTP number for verification of the Professor’s and Examiner’s Phone numbers.
  • Authentication of Professor and Examiner is also important, thereby uploading the College Approval Letter by Principal (Signed and Sealed), makes it Admin easy to verify them.
  • We will add a few more Image File Formats such as TIFF, GIF, PNG, JPEG, etc. in order to make Professor and Examiner upload photocopies easily.
  • To make a question paper, Professor has to be experienced; therefore we will add a new section while signing up called Years of Experience. In that section, the professor has to enter how many years of experience he/she has in the teaching profession.
  • Live communication between Professor and Examiner makes it easy to fix the problems; therefore we will add live messaging on the portal.

Download the complete asp.net, vb.net project code, and SQL database on the Question Paper Submission project.

Digital Learning Web Application using Visual C# and ASP.Net MVC

Introduction

“Quality and value: The true purpose of digital learning” From the ancient time we all learning new skills, books and different study materials using printed paper materials. In modern era, People don’t have enough time to sit on a place and go for library to learn something. People wants something that they can carry and read, learn any time anywhere. Digital Learning web application help user to read study materials and different books using laptop, mobile and tablets.

Objectives

In Digital Learning Application we have following objectives:

  • Manage Learners.
  • Track all courses and materials received.
  • Manage courses and fees.
  • Keep track of course status and notify learner.
  • Manage login and role.
  • It must work fast.
  • It must be reliable.
  • It must be economical.

Identification of Need

It pops in my mind when I started Ignou MCA, its very hard to attend all classes while working 9 to 5. I tried to find all study material in compact version, But I tried lots of websites but their no such material. I discussed this problem with many coworker and Ignou alumni but they told same, I thought to start a platform where people connect and ask questions, learn related topics in compact version. So I started analysis of the this project and in many way and found that its good if I start a website with eLearning capabilities. This website has lots of opportunity for ignou learners they can find all courses in future to learn. I planned this to launch on a real live website.

High Level System Requirement:

Admin/Author creates the courses.
Learners enroll and start learning.
Learner pay fees if opted paid course.
Learners attempt quiz and check their progress.
Learners can also share their understanding about particular topic.
Learner can ask questions and can answer.

Detailed Functional Requirements

Admin/Author creates the courses.
Learners enroll and start learning.
Learner pay fees if opted paid course.
Learners attempt quiz and check their progress.
Learners can also share their understanding about particular topic.
Learner can ask questions and can answer.

Module Details

The System modules are:

Learners module
Course Author module
Admin module

Learners module

Before login: Learners can browse courses, See Answers, Share blogs etc.
After Login: Enroll for a Course, Ask questions, Answer question

Author module

Create course
See enrolled students
Answer them, Help them in learning

Admin module

Manage Setting
Manage Authors, Courses, Learners
Manage financial data
See different reports

FUTURE SCOPE

Now a day’s there is a big demand by IGNOU student of this type of learning website, where they can find specific information, Currently its limited for Ignou MCA, later on I’ll update it for all students from Ignou and other universities. I have also plan for offering teachers to come and teach students directly using my website. I am also planning to launch the mobile application very soon.

CONCLUSION

DIGITAL LEARNING SYSTEM allows learners to register, enroll, learn desired topics and courses. I am using Asp.Net 4.0 MVC and C#, keeping in mind the specifications of the system. For designing the system we have used simple data flow diagrams.

Trip Planning and Booking System C#.Net Project

The main purpose of this project is to design a user-friendly, rich look application which serves for booking and planning their holiday trip…

This project consists of 2 modules

  1. Admin Module.
  2. User Module.

We will discuss the technical functions of each module in detail

  • Admin Module:

The role of the admin is to maintain the entire site data. Like adding primary information accepting the user booking. The total functionalities in the admin module are…

  • Add Country
  • Add City
  • Add Hotels
  • Adding Photos to Cities
  • Adding videos to Cities
  • Accepting the booking

In this project, we use web services for interacting with the database because using flex we cannot directly access the database… Here we will discuss each form’s functionalities.

  • Add Country:

In this functionality, the admin is adding different countries to the database. Here we are using the “InsertCountry” Method in the web service. Using this method in the web service we are accessing the stored procedure in database names “SP_InsertCountryDetails”. This is taking two values as parameters those are “Cname” and “Description”. Which are there inserted into the “Tbl_Country” table in the database.

  • Add City:

In this functionality, the admin is adding different city names with respect to a particular country name. Here we are using the “get the country” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country” and we are displaying it in the combo box in the flex design. Their admin will select any country name and he will enter a city in the textbox given in the form. When admin clicks on the entering button it will pass those values to “InsertCity” which is there in web service taking 3 parameters and we are storing it in the database using a stored procedure with the name “SP_CityDetails”.

  • Add Hotels:

In this functionality, the admin is adding particular hotel details in the database corresponding to a particular city and country. For that purpose, he is getting all the country details from the “get the country” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country”  and binds it to the combo box in the flex form. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. After binding all the data admin will enter the hotel details which then call a method in the web service called “InsertHotels” with all the parameters provided by the admin and it will store all the details in the database using the stored procedure “SP_HotelDetails”.

  • Adding photos:

In this functionality, the admin is adding particular Photo details in the database corresponding to a particular city and country. For that purpose, he is getting all the country details from “get country” Method in the web service to access all the country names from the database which is stored in the table “Tbl_Country”  and binds it to the combo box in the flex form. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. After binding all the data admin will select the photos from the local disk and add them to the application. Then it will call the method in the web service called the “InsertImgNames” method where we are writing the insert command to store information in the “Tbl_PhotoDetails” table also we are storing the image in the Photos directory in the web service application folder.

  • Adding videos:

In this functionality, the admin is adding particular video details in the database corresponding to a particular city and country. For that purpose, he is getting all the country details from “getcountry” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country”  and binds it to the combo box in the flex form. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. After binding all the data admin will browse the video from the local disk and add it to the flex application. Then we are calling a web service method “insertVideoNames” for storing the details in the table “Tbl_VideoDetails” which is there in the database. Here we are storing the name in the database and adding that video to the local directory of the web service.

Note: our application only accepts “FLV” format videos that are of size less than 20MB.

  • Accept Booking:

Here admin is accepting the booking from the user on the basis of the availability of the rooms and other information. For this, we are getting all the booking details that are waiting for admin approval from a method called “CheckStatus” where we are getting all the details from the table “Tbl_Payment” which are having the status as false. And also we are getting other information like user personal details from other tables like “Tbl_UserDetails” and we are storing it in a custom dataset. And I am returning it to the flex as an XML string document. Where I am filling those details in “CheckBoxDataGrid”.  Here admin selects any particular details in the check box which is generated individually for each row. After selecting those rows when the admin click Submit button admin will send all those user details to a particular method called “SendMail” in the web service which will make that record status true in the table “Tbl_Payment” and send a mail to that particular user mail ID as a confirmation mail.

 The above-mentioned functionalities are Admin which provides basic information for the site and accepts the booking and sends mails to the user. Here below given are the functionalities for the user module. Where the user can perform several operations on the application those are….

  • User Module:

Here the functionalities for users are…

  • Login
  • Select places
  • View photos
  • View video
  • Make booking

We will discuss all the functionalities in detail…

  • Login:

Here every user has their own credentials using those credentials only they have to access the site to check those credentials we are using one web method called “LoginUser” here we are accessing the stored procedure “SP_LoginUser” for checking the credentials. If those usernames and passwords are correct then it will return a message called “true” otherwise “false”. If it is true user will redirect to the Home page to access other functionalities.

  • Select Places:

In this functionality, if the user wants to make a booking first he needs to select the particular place in which he wants to book the hotel. For that purpose, we are taking one form called “SelectPlaces” in which we are placing two combo boxes. The first one represents the country names and the second will represent city names. For that purpose, he is getting all the country details from “getcountry” Method in the web service to access all the country names from the database which are stored in the table “Tbl_Country”  and binds it to the combo box in the flex form.. If admin selects any particular country it has to call all the cities with respect to countries for which we are using a web method “GetCityNames” it is taking country Id as a parameter and returns all the city details with respect to that country names. Whenever the user selects both country and city then after pressing on the next button it will redirect to the page where the user will get 3 options like

  • Make Booking
  • View photos
  • View videos
  • View photos:

Here user will get all the photos with respect to the user selection of countries and cities. Here we are using the one web method for retrieving all the image details i.e., “GetPhotoNames” it will return all the photo’s names and paths and there we are giving that details to the photo viewer control in flex.

  • View videos:

Here user will get videos if any with respect to that place based on the country and city names selected in the select city page by the user. For that purpose, we are calling one method in the web service called “GetVideoPath” in the web service with respect to the city Id selected in the front end. In that, we are retrieving the details of the video name and path for that particular city and giving it as a source for the video controller in the flex path.

  • Make Booking:

If the user wants to book a hotel in a particular city then the user clicks on the Booking link. Then the page will redirect to a page where the user has to enter “from date” to “to date” and has to enter the number of adults and number of children when the user clicks on next the page will redirect to the booking page with all this information their user will get all the information of hotel details in that particular place. To fill this grid we are calling “GetHotels” and we will all the hotel details with respect to that city Id and it will display it on the grid. The user will enter a particular hotel id in the form. When a user clicks on the book button then we will call a method called “Payment” in the web service. All the details will be stored in the database using a stored procedure called “SP_Payment” and the booking will be waiting for admin confirmation. Once the admin confirms the user booking user will get a mail regarding the details of the booking.

Download the Complete Project on Trip Planning and Booking System C#.Net Project

Online Shopping Store Website Project using C# and SQL

MY ONLINE SHOPPING STORE 

We have a physical shopping store, which is doing well in terms of revenue and margin. We want to increase the business by extending the availability of our products through online mechanisms. Quick time-to-market is the main criterion;

we are adding some features: 

  1. Home Page 
  2. Product Search facility 
  3. Product Detail Page 
  4. Add to Cart 
  5. Place Order

Use Case Diagram-Online Shopping Website:

The use case diagram is usually referred to as a behavior diagram used to describe the actions of all users in a system.

All users described in the use case are actors and the functionality is the action of the system.

The use case for an online  shopping website:

Specification of Use Cases:

Use Case                                      Home page

Home Page

Element

Details

Actor

User

Trigger

With or without authentication

Pre Conditions

Various Categories of the items are displayed

Post Conditions

On clicking each category, various sub-items are to be displayed

Normal course

1.      On hovering various categories are displayed

2.      On each Category, the subcategories are displayed

 

Use Case                      Search Product

Search Product

Element

Details

Actor

User

Trigger

On clicking the search bar for the item to be searched.

Pre Conditions

 Users can check the items they needed

Post Conditions

The various items of the searched product are displayed

Normal course

1.      User enters the Product name or product category

2.      The various items of the product are displayed

Use Case                                      GetAllProducts

GetAllProducts

Element

Details

Actor

User

Trigger

With or without authentication

Pre Conditions

The user needs to enter a product name

Post Conditions

The sub-list of all the items should be displayed.

Normal course

1.      The various products should be displayed varying in different perspectives

Use Case                                      GetProductDetails

Get Product Details

Element

Details

Actor

User

Trigger

On clicking a particular item the info about the product is to be displayed.

Pre Conditions

The user needs to enter the product name or category

Post Conditions

The total info regarding the product is to be displayed

Normal course

1.      User enters the Product name and then submits

2.      The fetching records will be displayed

Use Case                                      AddProduct

Add Product

Element

Details

Actor

Admin

Trigger

When the User Quantity is not available

Pre Conditions

 Checks whether the searched item is available in the inventory or not

Post Conditions

The user can search for the prescribed item

Normal course

1.      Admin checks in the inventory stock

2.      During the period of offers or when the inventory is not available to the users, he adds to the database.

Use Case                                      Delete Product

Delete Product

Element

Details

Actor

Admin

Trigger

When the offer period is completed

Pre Conditions

 Refactoring the product as per the daily market price

Post Conditions

The product is not available after the deletion.

Normal course

1.      Admin login using his credentials

2.      Search for the product to be deleted

3.      Deletes the particular products

Use Case                                      Edit Product

Edit Product

Element

Details

Actor

Admin

Trigger

When the product needs to be updated during the season sale

Pre Conditions

 The product may vary in its cost and delivery

Post Conditions

The product has been updated regarding the information

Normal course

1.      Admin logins using his credentials

2.      Updates the selected products in the inventory.

Use Case                                      Add To Cart

Add To Cart

Element

Details

Actor

User

Trigger

When a user needs to buy the item at a later point in time

Pre Conditions

 If the user likes a particular product he can choose to buy it by clicking the Add To Cart

   

Post Conditions

The selected items are available later until the selected product is available

Normal course

1.      User selects the particular product

2.      He then clicks on Add To Cart.

3.      The liked items are available for later usage

 Use Case                                     BuyNow

BuyNow

Element

Details

Actor

User

Trigger

With  authentication

Pre Conditions

The total amount should be displayed.

Post Conditions

On Clicking the order needs to be placed.

Normal course

1.      Click on Buy Now, select the items and then go to payment

2.      The order should be placed after payment.

Shopping cart System ER Diagram:

ER Diagram:

Flow Chart For Online Shopping system:

Database Table Design:

ProductCategory:

Field Name

Type

Remark

CategoryId

Int

PK

CategoryName

Nvarchar(50)

 

Products:

Field Name

Type

Remark

Id

int

PK

CategoryId

int

FK

Price

Float

 

Quantity

Int

 

Description

Nvarchar(Max)

 

Picture

Nchar(100)

 

CartItem: 

FieldName

Type

Remark

Id

Int

FK

Price

Float

 

Quantity

Int

 

 

Restaurant Database Management System Project using C# & MS Access

Title: Restaurant Database Management System.

Topic Research and Executive Summary:

The Restaurant database Management System is an Enterprise Database project which has a few advantages where restaurants can improve customer relationships; Restaurant owners can know when the customers arrive most of the time which can enhance productivity. By using a Restaurant database Management System owners can have effective use of Human Resources. Due to this database system, we can manage time we can reduce human efficiency and errors, and get accurate information.

Statement of Work

Project Description:

This database system is developed in such a way that restaurant can get accurate details of both offline and online ordering through mobile or web application so customer gets a notification if the order is ready for pickup and customer can track the order if he/she orders online for home delivery.

Due to this database management system, we can reduce the complexity between restaurant management and customers.

Project Challenge:

  1. Collecting the information from the Restaurant owner visa by reading articles or interviewing the store manager of the company.
  2. Learning C# to create an application to connect with Microsoft access. C# is a programming language that is simple, and modern. The language and its implementations provide strong support to software engineering principles. C# is familiar to C and C++
  1. Microsoft Access is a database management system from Microsoft that combines the relational Microsoft jet database engine with a Graphical user interface and software tools.
  1. Must learn to design a logical relational database                                                              
  1. Create ER diagram

Project Description and Milestones:

Stage1: Analysis: The main objective of the database is to manage the details of the staff of the restaurant, the customer who visits the restaurant to order and take away behavior that the customers who order online, and manage the delivery system where the restaurant can assign delivery boys to deliver the food the customer.

Stage2: logical design: The Database consists of 5 data tables which are

Restaurants in different locations.

The store manager who takes care of the restaurant manages the staff and the daily supplies like food items

The staff are of different types such as cashier, waiter, receptionist, cleaner

Customers who order online, who visit the store and have dine-in, and others who take away

Delivery guy who takes the orders and delivers the food to the customer

Stage3: physical design:

The Restaurant is located in different locations so it has a restaurant id and restaurant address.

The manager data table has the manager id, manager name, manager age and management experience, and manager address.

The Staff has staff id, staff age, staff assigned work, staff address, and staff experience.

Data table for a delivery system where it has details of delivery boy, location of the delivery, order details

The customer data table has customer order details and customer names.

The customer ordered online then the data table has the customer’s address, customer name, order details, and delivery boy id.

Stage 4: Implementation: Create the application interface using C# programming language, and create a database using Microsoft access.

Stage5: Modification and Maintenance:

Modification and maintenance of the database are done in the Microsoft database.

Methodology and implementation plan:

This database management system has 4 phases, design, coding, testing, and maintenance. By use of RAD methodology, these stages are implemented.

Step 1: Need to create a design a database with five data tables.

Step 2: By using C# programming we need to create a user application interface, Using Microsoft access we need to create a Database and interlink the application interface and database.

Step 3: Need to test the database system and check for the error the clear the errors.

Step 4: Need to check the database on a regular basis because things to be needed to be upgraded.

Expected results: The Deliverables

By creating a working application for the restaurant so they can access it easily. The Restaurant owners can view the details of the store manager, the number of staff working on a daily basis, and the financial details.

The Store manager can use the database system to view the no of people working in the store and can view the accurate details of the orders

Customers can easily order the food through the online menu

Supporting Facilities:

Database: Designed in Microsoft ACCESS

Application program language: C# programming

Other application: Microsoft Visual Studio (Programming IDE)

Citizens and the Municipal Authorities Connecting System Project

Abstract

Citizens & Municipal Officials Connecting System is a project that is designed to facilitate the citizens and the Municipal Authorities to simplify the process of complaint filing and management. It consists of a mobile application for the citizens as well as an ASP.NET web application for the Authorities. The citizens can file complaints through the app and the authorities will get those complaints and assign them to the appropriate officer.

The officer will then solve the complaint and notify the administrator through the system, the administrator will then change the status of the complaint. The user can track all of this through their mobile app from their dedicated section to view the complaint status.

This system is a significant improvement over the existing system of complaint filing and management, and hence we believe that our project can make a significant contribution to the modernization of the governance procedures.

INTRODUCTION

Citizens & Municipal Officials Connecting System is a tool designed to function as a platform for the citizens to communicate with the Municipal corporation authorities and replace the old method of writing letters and e-mails as they are a time-consuming mode of communicating with the authorities.

  • Background

In this age of rapid urban development and internet connectivity, the gap in communication between the residents of a city and the Municipal Corporation that runs the city should be reduced to a bare minimum.

Unfortunately, there hasn’t been much progress in that area or it has been very slow because this topic hasn’t been seen as a priority by the authorities even with all the technological advancements, due to which the citizens have suffered as they are yet to see a channel of communication that is as fast and as up-to-date as the technology of today.

  • Objectives

The objective of our project is to provide solutions to both – the citizens and the municipal corporation. We aim to provide the citizens with a platform, which they can use to communicate with the authorities.

Another objective of the project is to provide the municipal corporation with a tool – which they previously didn’t have – to manage all the complaints that they receive, freeing them from the responsibility of managing all the heaps of files that are present in their office.

The most important of all the objectives is to save the time of the Municipal authorities so that they can focus on multiple tasks in a single day and utilize their time more efficiently. Other secondary objectives include creating awareness among the masses about the digitization of the traditional paper-based administration – which is regarded as time-consuming – as we are moving toward the idea of a Digital India.

  • Purpose, Scope, and Applicability

The following are the purpose, scope, and applicability of the city reporting system that we are going to develop.

  • Purpose

The project has been undertaken by us to simplify the communication process between the authorities and the citizens by removing the unnecessary and time-consuming formalities that are in place right now and putting in its place a new system that uses an entirely new channel of communication – the Internet and the mobile phone.

Since the citizens can directly communicate with the authorities, it saves a lot of their time as they don’t have to follow a certain protocol anymore, the authorities will forward their query or complaint to the appropriate officer in charge and make the whole process hassle-free for them.

This way the authorities also don’t have to deal with all of the extra paperwork like forms and letters resulting from the old method of registering a complaint, all they have to do is to forward any complaint that they receive to the appropriate officer and that officer will take the necessary steps needed to solve that particular complaint.

  • Scope

The scope of our system ranges from the citizens that will use the system to report their grievances, to the Municipal authorities that will use the system to then manage those complaints and solve them.

This offers us multiple avenues where we can simplify the process of complaint filing and complaint management for both the parties involved respectively.

Citizens can have various problems, like waste disposal, water supply, sewage, drainage problems, waterlogging, etc., through the mobile application they can just simply click a picture and post a complaint, which will then be forwarded to the concerned officer. Thus we are building a single platform that can be used to resolve a wide range of issues about most of the departments in the Municipal Corporation.

Thus we can say that our project is not just one dimensional in terms of its scope we have tried to cover as many areas as we could, and we have also tried to make our project scalable so that we can build upon the existing architecture instead of building a new system entirely from scratch.

  • Applicability

The citizens here can file their complaints in a matter of a few clicks instead of making a personal visit to the local Municipal Corporation office due to which the transportation time and cost of the citizen are saved and the paperwork is also reduced making the whole operation an environment-friendly one.

The Mobile app can also help people with certain physical disabilities to file complaints without having to worry about traveling to the Municipality office and properly handling the paperwork or documentation and going from table to table, to find the right officer to submit their complaint since the app can do both the things for them so that they don’t have to take all the trouble by themselves.

Municipal officers that have been assigned a complaint through the system will need to provide a proof-of-work that they have solved that particular issue and not just click solved on the screen and think that their job is finished, in this way we are promoting accountability of the officers towards the citizen.

ER Diagram:

ER Diagram

SYSTEM ANALYSIS

Existing System

Till now most of the complaints are filed physically or via emails, which in the case of emails require multiple email IDs too, for the relevant authority of a particular department. This might take a lot of time and effort for finding the authority first, for a particular kind of complaint, and then find an email ID of the department.

Due to these multiple channels of communication, the authorities also find it difficult to track every complaint since the users might file their complaints through the medium of their choice, this leads to confusion among the authorities as there is no central system that manages all of the complaints in a single place

Proposed System

This system will not only save the time of the complaint filers but also allow them to track their complaint and their status at regular intervals of time. Once the complaint is solved, the user gets the update on their phone..

Requirement Analysis

  • Problem Definition

Nowadays it is important that if a user is using a mobile app, they have to be provided with accurate information/guidance and proper security of their data should be implemented, to create trustworthiness between the citizens and the government. Authentication and verification of users have also become mandatory now.

  • Issues

Some of the issues that the citizens face with the current system are as follows

  • Time Consumption: Travelling to the office of the Municipal Authorities and filing the complaint physically is a time-consuming process as it involves hopping from table to table.
  • Dealing with Paperwork: Another problem with the physical method is that involves dealing with a lot of paperwork. The citizens have to fill out various forms to file even a single complaint.
  • Lack of accountability: Municipal officers in the past have been accused of not being accountable to the citizens, through our project we are promoting accountability among the Municipality officers.
  • Requirements specification

Here we are going to develop a system that acts as a communication channel between the citizens of a locality and the Municipal Corporation of that locality the main objective is to provide a common interface between the citizens and the authorities so that they can communicate trustfully, at ease and without any inconvenience for both the parties involved.

Overview

  • The user can file a complaint by logging in to the app
  • The user will be requested to create and register an account by filling out all the details that are required
  • A complaint ID will be generated when the user files a complaint it will be unique for every complaint the user files
  • The user can track the status of all their filed complaints through a separate tab called ‘complaint status’.
  • The administrator will be able to delegate various complaints to an officer under him.
  • The officer can change the status of the complaint assigned to him once he has solved the complaint

Medical Store Management Project Windows Application using C#.Net

This Medical Store Management Windows Application provides the facility to store medicine details for a medical Store. It saves time as it allows users to reach medicine quickly by finding it from the database.

Medicine Database is generated by the user by storing medicine details. Admin has the privilege to delete users database, medicine database, looking in users login information like username, password, time of login. Users can register with their Email, Mobile No, and password. The application can be used in many big medical stores to manage medicines and therefore save a lot of time and resources.

The various front-end software used in the Medical Store Management project is C# (As Programming Language), .NET Framework, and Metro Framework. MongoDB is used as the backend tool.

The project is related to Medical Store Management which provides services to medical stores. Any user can log in to the software using this application. Users can find, insert, update, and delete medicine details whenever they want. The system keeps the track of all users and their medical details.

Working of Present Manual System

The staff of the medical store is involved in the following process:

1. Maintaining Medicine Bills
2. Stock Analysis on paper
3. Quantitative Analysis

Drawbacks of present systems

Fast medicine search is not possible manually in a very large Medical Store.
No central database can be maintained to store the results of all medicine details.

Proposed System

1. User registration
2. Insertion, deletion, update, searching of medicine details
3. Stock Analysis

The proposed system provides the following solution

1. It provides better and more efficient service to medical store owners
2. Reduces the workload of store employees
3. Faster searching for medicine
4. All medicine details on a single server

User’s Role

1. Providing the correct information while registering
2. Managing medical store by Insertion, deletion, update, and searching of medicine details
3. Stock Analysis

Admin’s Role

1. Deletion of users or medicine database if required
2. Monitor the user’s login reports and stock analysis

Justification and need for the System

The traditional approach to storing medicine details is on notebooks and bills.
These days there is often more emphasis on software, which may consist of insertion, deletion, update, and searching of medicine details to software.

It is a modern method of medical store management widely accepted and hastily increasing environment of storing medicine details by using Medical Store Application.

It will considerably replace the traditional paper and pen-based medicine data store in the future.

It supports medical store owners to cope with the increasing number of medicines by providing an overview of the database by stock analysis section.

Conclusion

We have implemented the Medical Store Management successfully. We used C# as a programming language on .NET Framework 4.6 and Metro Framework and MongoDB as backend tools as database.

The system is very good at saving the precious time of medical shop owners as well as reducing the workload of medical store staff.

It is a modern method of storing and retrieving the medicine information widely accepted and hastily increasing environment of conducting managing medicines through software in all the sectors of medical stores.

It will considerably replace the traditional paper and pen-based information storage in the future with Medical Store Management Application.

Insurance Policy Maintenance and Claim Management Process .Net Project using C# and SQL Server

An insurance management system is a personal intranet-based web application developed by a group of insurance broker agents to make your insurance policy and claim review process easier and more flexible.

The web application is used to check and monitor the status of customers who have adopted new policies in the context of distributed access in your organization, and to notify them of the terms of the policy’s premium payments and requirements. In fact, the system is designed to accelerate the process in your business process to increase customer satisfaction and keep the overall flow of customers in this domain smooth and stable.

The main problem of manual operation is the registration of holders of existing insurance policies and their regular maintenance of insurance policy payments. Providing regular services also takes a lot of time by searching the registers of the current customer base. If it is possible to automate the data storage process and increase search control, there is always the opportunity to get additional customers in turn, which will increase the profitability of the organization.

The real purpose of choosing this system is to speed up the organizational process. Agents can have the expected information at any time, in any instance. Creating the required reports in accordance with operational requirements will be much easier and information will be available. The system is not only false evidence but also has a high level of customer satisfaction.

The application is also security-oriented and is expected to be fast as a shared access structure because it communicates within the system.

Project Characteristics:

  • The agent can view the required information at any time, whether it is a policy or a customer, with the click of a mouse and the example the second.
  • If planned in an organized manner, customers can be provided with an online terminal where they can receive information with their own hands without major intervention.
  • Customer or policyholder alerts can be generated at lightning speed by asking specific customers.
  • Data can be shared via a single-window link in their respective databases, saving time entering multiple data while they are being collected.
  • The status of the premium payment on the clients’ policies can be systematically discussed by the Agents to check for non-payment.
  • A specific policy can be clearly monitored by the detainee and checked before the claim is resolved.
  • Most importantly, the overall system can provide consistent and reliable authenticated information about your transactions at any time.

Current System:

In general, if a user plans to create an insurance plan manually, they will need to perform a number of activities.

It is a very tedious process for the agent to keep records of what is happening through the system and the required information that may be generally needed at all stages.

In increasing the customer base, the manual search process is very tedious and time-consuming, which repeatedly frustrates the customer with the agent.

Recommended System:

With the new system, the following activities are gaining momentum.

The actual process of the organization can be modulated into three different independent views

  • Agent Appearance
  • Opinion of the policy owner
  • System Administrator View
  • Agent

At any time you can view the required information or policies, or customers with an example of a click of a mouse and a second.
If planned in an organized manner, customers can be provided with an online terminal where they can receive information with their own hands without major intervention.

Modules:

The actual process of an organization can be modulated into three different independent perspectives

  • insurance company information
  • Agency Information
  • customer information
  • Policy Information
  • Policy payments
  • Political demands
  • Security information

Download Insurance Policy Maintenance and Claim Management Process .Net Project Source code, Report, PPT using C# and SQL Server