Book Reading Event System MVC App Using ASP.Net SQL & Bootstrap

This Book Reading Event App is a combination of tools and processes that manage book-reading events across India. A book reading event where book lovers come together for a community reading of their favorite book. One or more readers read the book loudly and optionally people even play roles from the book.

INTRODUCTION

A book reading event app is an online web application that is a single-point entry for all book lovers across India. Any registered and verified user who wants to keep a book reading event can create an event, invite people they know by specifying their email ids, or can keep the event open for all. The invited people need not be registered users. Due to some problem, if someone is not able to create an event, s/he can ask some other registered user to keep an event on their behalf of her/him. The registered user can check for the public events happening by just browsing into to portal and for private events, one can check the invited list of events by logging into the portal as well as by checking their invitation mail. Admin can see all the events (whether it is public or private) and all the registered users. As per the requirement, the admin can Edit as well as Delete any future public or private event details.

OBJECTIVE

The objective of this Book Reading Event System Project was to manage all the book reading events properties created by one user and send an invitation to the guests by entering their email ids or by keeping an event public. Managing these resources may itself be sufficient enough to give any user a big jump in terms of efficiency. The objective was to build a web application for people that makes use of it to manage their hectic schedule and make the best use of it in a smooth and efficient manner.

FUNCTIONALITY

The project will manage the intellectual property by creating a database of all the users and events, helping users to create an event, edit the event details, delete an event, add comment(s) on the event, invite the guest(s) for the event and to see any book reading event details happening around. Admin simultaneously verifies details of events as well as users. Admin can also edit and delete the event whenever required. Book Reading Event App has two types of users: Registered users, and Admin users.

Registered users are the normal user of the application who has the following rights:

  • View Past and Upcoming Public events
  • Log in to the system using “Email id” and “Password”
  • Create an Event and send the invites by specifying email ids
  • Edit the events created by him/her
  • View the events invitation list along with the details
  • View the list of events created by him/her
  • Add Comments to the Event

Admin Users have all rights throughout the application as follows:

  • View Past and Upcoming Public events
  • Log in to the system using “Email id” and “Password”
  • Create an Event and send the invites by specifying email ids
  • Edit any upcoming event’s detail
  • View the events invitation list along with the details
  • View the list of events created by him/her
  • Add Comments to the Event
  • View list of all the users
  • View a list of all the events

METHODOLOGY AND APPROACH

The following technologies were used for building this project:

  • Frontend – Hypertext Markup Language (HTML) CSS (Cascading Style Sheets), JavaScript, Bootstrap
  • Backend – ASP.NET (Active Server Page) Model View Controller (MVC)
  • Database – Structured Query Language (SQL) Server
  • Framework – Entity framework is used to connect to the database which helps in object-relational mapping

This project is built in an MVC pattern where M is the model which determines the classes, V is a view that determines views shown to the user and C stands for the controller which is used to handle the request. This project follows three layered architecture. The first layer is the presentation layer which includes views, and the second layer is the business layer which includes the services which work as a mediator between the presentation and data access layer. And the third layer is the data access layer which directly interacts with the SQL server database using entity framework and code first approach.

OBSERVATIONS

Graphical User Interface (GUI) – The website contains many links and tabs for various requirements like Create Event, Edit Event, View Invitations, etc. The users of the application consist of users from India. It will lay stress on each

page’s layout and the features to be depicted on that page.

HOME PAGE:

This is the first landing page. Any user can see the Public Book Reading Events without logging into the system by using the Past Events and Upcoming Events links. The past Events link redirects to the Past Public Events and the Upcoming Events link redirects to the Upcoming Public Events along with their details.

PAST EVENTS:

This page is landing by clicking on Past Events on the home page. Any user can land on this page without logging into the system. But one cannot add comments without logging into the system. Users can see the list of Past Public Events along with the details of each event. The working of Upcoming Events on the home page is the same.

A registered user or admin can log in using their credentials.
Depending on the type of user, s/he will have access to various functionalities of the application. In case the email id and password typed by the user do not match any record in the database, a login failure message will be displayed. If not registered already, a user can sign up by clicking on “Signup”.

USER SIGN UP

A user can register using their credentials. After successful registration user will be redirected to the login page. In case of failing the validation requirements of email id or password, a failure message will be displayed. If registered already, a user can log in by clicking on “Login”.

HOME PAGE AFTER LOGIN:

This is the landing page after the user logs in to the system. PAST EVENTS redirect to the page containing the list of past events which either the user invited, or was a public event. UPCOMING EVENTS redirects to the page containing the list of upcoming events to which either the user is invited, or it is a public event.

Navigation bar: Contains the button for CREATE EVENT, MY EVENTS, INVITATIONS, HELP, USER DETAIL and
LOGOUT functionalities.

Only user with Administrator rights has some additional button for some additional functionalities available in the navigation bar are ALL USERS and ALL EVENTS button.

CREATE EVENT:

Users can create a new event. The user just needs to enter some necessary details like Title, Date, Location, Time, Type of event, and some other optional details like Description, and Other Details. Users can invite guests to the event by entering their email ids separated by a comma. Users must provide the creator id for whom they are creating the event. If the user wants to create an event for himself/herself only, then he/she can check the creator id by clicking on DEAR – XXXXX. If the user is creating an event for someone else, then the admin will verify the details with whose creator id has been entered. If the BACK TO LIST button is clicked, the user will be redirected to the HOME PAGE.

MY EVENTS:

Users can see the complete list of events created using their own creator id. From here user can Edit/Delete his/her any upcoming event by clicking on the Edit/Delete button. Users can also create events by the button provided just under the tile MY EVENTS.

COMMENT. And can also see the comments posted by others in the COMMENTS section. The comments in the COMMENTS section are shown anonymously sorted by date and time.

EDIT EVENT:

Users can edit the details of any upcoming events from the list of events provided on the MY EVENTS page. Users can edit any of the details provided in create event form except the creator id. The layout of the page is exactly the same as CREATE EVENT page. Users can return to the MY EVENTS page using the BACK button.

INVITATIONS:

Users can see the complete list of events to he/she is invited. The list of events being shown is sorted by the date and time of the event. As this page proved to be much helpful to users in order to plan their future activities. By clicking on the DETAILS button, the user will be redirected to the EVENT DETAILS page. On the EVENT DETAILS page, users will find some additional information regarding the events such as the type of event(public/private), the number of invitees invited, and the creator of the event.

EVENT DETAILS:

Users can see all the available information regarding the event he/she invited to by clicking on the Details button available on the INVITATIONS page. Here one can find some additional information such as the type of event(public/private), the number of invitees invited, and the creator of the event. Users can also add comments for this particular event by clicking on ADD

USER DETAILS:

Users can check his/her own details by clicking on the DEAR – XXXXX button. One needs to check their user id for creating their event, so here they can find it out. Here the button name is extracted from the email id by which the user has login into the system. As it is clearly visible from the image, if someone logged into the system with [email protected] then the name before @ is shown after the Dear – button like “Dear – XXXX”. The name visible in the button is the extracted from user’s email id leaving the part from @ symbol.

ALL USERS – ADMIN ONLY:

Only users with administrator rights can access this page. This page can be accessed by clicking on the button ALL USERS available in the navigation bar. On this page, the admin user can see the whole list of users who may or may not be an admin. Admin can see each user’s name, id, and email id.

ALL EVENTS – ADMIN ONLY:

Only users with administrator rights can access this page. This page can be accessed by clicking on the button ALL EVENTS available in the navigation bar. On this page, the admin user can see the complete list of events. The list contains both public as well private events. The list contains both past and upcoming events. The events in the list are sorted by date and time. Admin can use create event functionality here also by clicking on CREATE NEW EVENT button.

Admin can see details like Title, Date, Location, Start Time, Type of Event, Duration, Description, Other Details, No. of Invitees invited, and Creator id of all the events. For some specific requirements, the admin can see the details for a particular event by clicking on the DETAILS button available in that event’s particular row which will be redirected to the EVENT DETAILS PAGE as shown before. Admin can not only edit the events created by him/her but also edit events created by other users/admins. Admin can edit any upcoming event by clicking on the EDIT button for that particular event which will redirect to the EDIT EVENT page. Admin can also edit the creator id for the event.

After being done with the usage of the portal, the user/admin can log out from the system by clicking on the LOGOUT button available in the navigation bar. After clicking on the LOGOUT button, the user will be redirected to the HOME PAGE. Users can again use the system any number of times by logging into the system using the same credentials used for the first time.

CONCLUSION

This Book Reading Event system is a user-friendly software that can be used in any locality for any user to arrange the event and to send an invite to guests just by entering their email ids. Due to some problem, if someone might not be able to create an event and send an invite or somebody might not have email ids available for all the guests, in this case, the book reading event app provides functionality to a user to create an event on behalf of someone else and it will be verified by an admin before sending an invitation to the guests and posting that event on the portal.

Allowing all the users to have access to such web-based application software can help anyone who wants to keep an event busy with the preparation of the event can easily send invitations to the guests and save his/her time. Further, this software can be developed to add more functionalities in the future, like setting a reminder for the events and notifying the user time by time, and setting a flag for the events one is interested in. This project can be further extended to keep any event (i.e., House-Party, Get to Gather) and not just only for book reading. The sheer possibility of scaling this application is immense and will definitely go to be proven the most useful software in the future times.

Online Banking Application in Java using Spring MVC

Purpose of the project: The main purpose of this project is to focus on real-life application scenarios. The agenda would be to build an application and implement the banking features.

Objectives

The project is divided into two parts. The first part contains the main functionality of the banking website such as transferring money, withdrawing money, depositing money, etc. The second part of implementation contains the advanced features such as transferring money using interact, currency conversation, a restriction of transferring $1000 per day, a minimum balance of the account must be Rs 10000, withdrawal error in case of minimum balance goes below Rs 10000 due to withdrawal, admin and non-admin privileges on banking features and so on.

Goals

The goal is to design an online banking application that should have all the necessary basic as well as advanced features. This project is implemented on Java using Spring MVC Framework.

Project Category

This project is covering the skills and core areas of Java Spring MVC Application with equal emphasis on theory and practice. The main focus is to implement an application and analyze issues in the applications followed by a case study in the same area.

Scope of the solution

Through this project, we can develop the banking portal for new banking firms, or we can suggest a better solution to the existing banking portals. Though all existing banking portal has the features that have been implemented in our project, however, an enhancement can be made by analyzing the robustness and accuracy of our application.

Future scope and further enhancement of the project

The project can be made more advanced by implementing sessions, hosting email interaction features on the SMTP level, and many more. Indeed, Java MVC Spring gives a robust platform to develop solutions to real-world problems. It is easier to debug, manage, maintain and develop. It also has a huge list of spring libraries to make developer tasks easy throughout the task.

Problem Statement

The problem with Online Banking Applications
Affects: Customers, Admin
The impact of this is Banking Transactions
A successful solution would be to Design a database for storing the entire information, a front end for user interaction with the system, and analysis of daily, weekly, monthly, or yearly transactions of different types with the implementation of validation.

Literature survey

1. Study of different software development lifecycle models
2. Study of Java Spring MVC Framework
3. Study of Dao and Controller Interactions
4. Study of existing banking applications
5. Study of class lectures, PPT, book, and Stackoverflow
6. Study of Admin and Non-Admin Privileges
7. Study of Application Validation
8. Study of Application Risks and Vulnerability

Download Construction Management System Java Project using Spring MVC framework

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.

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

 

 

Complete Hospital Management System Synopsis

The main aim of developing this Complete Hospital Management System is to provide best software to Hospitals to provide end to end solution for various departments. We have divided the Complete application into 7 major modules, Those are listed below:

1. Administrator
2. Patient Management
3. Materials Management
4. Laboratory Management
5. Employee Management
6. Financial Accounting
7. Operations Management

Each Module is divided into Sub Modules:

Administrator Module

In This module only admin people entered through Password and able to change or update as well as assign the responsibility to anyone. This module is further sub-divided into Doctor Registration, Employee Registration, Appointment Scheduling, and Hospital Administration

Doctor Registration:- In this sub-module all the information regarding the doctor are stored ex. Doctor ID, doctor name, highest qualification, specialization, as well as availability.

Employee Registration: -In this sub-module all the information regarding the employee is stored. Ex. Employee ID, Employee name, Employee address, Employee joining date.

Appointment Scheduling: – In this sub-module all the information regarding the appointment to the patient with the doctor are stored.

Hospital Administration: – In this sub-module all the information regarding Hospital Details

Patient Management:

In this module, all the information regarding patient are stored. This module is divided into various sub-modules. Inpatient Registration, Out-Patient registration, Itemized Patient Billing, Electronic Medical Records/Clinical History, Online Registration.

Materials Management

This module contain information related to complaint, equipment, Assets, Stock & others items maintenance management and keeps track of AMC of the equipments and the services offered by the vendor / manufacturer. This module is sub-divided into General Store Management, Inventory Management, Pharmacy Management, Blood Bank Management.

Laboratory Management

The Laboratory module is a sophisticated computer data management system designed to handle a large amount of data quickly and efficiently for all Pathology Laboratory disciplines, Clinical Pathology, Microbiology, Hematology, Serology, Cytology, Radiology, Biochemistry, and Neurology.

Employee Management

In this module, all the information regarding Employee is soared. This module is divided into various sub-modules; Attendance Management, Payroll Management. The employee management system incorporates attendance for staff, calculation of working hours, and daily, weekly, monthly and yearly analysis. The application accommodates all aspects of scheduling by assigning and maintaining records about different shifts and duty timings, hacking for scheduling conflicts with patient’s schedule, physician schedules, equipment availability and room availability. The employee management system incorporates attendance for staff, calculation of working hours, and daily, weekly, monthly and yearly analysis. The application accommodates all aspects of scheduling by assigning and maintaining records about Different shifts and duty timings, checking for scheduling conflicts with patient’s schedule, physician schedules, equipment availability and room availability.

Financial Accounting:

• Cash Book
• Bank Book
• Ledger Book
• Receipt/Payments
• Journal Voucher
• Insurance
• Invoice
• Purchase Orders
• Records

Operations Management:

In this module, all the information regarding all the available OPD. This module is sub-divided into Housekeeping, Ward Management, Bed Management, Operation Theater, Manager Assistant, Doctors Workbench, and Nursing Workbench.

Online Ticket Booking System Project Source Code

The main objective of the Java Project on the Bus Booking System is to manage the details of Operators, Customers, and Ticket Booking.
It manages all the information about Bus Ticket Booking. The project is totally built at the administrative end and thus only the administrator is guaranteed access.
The purpose of the project is to build a bus ticketing application program to reduce the manual work of managing the Operators, buses, and Customers.

Admin & User Functionalities:

ADMIN 

  • ADD BUS
  • DELETE BUS 
  • EDIT BUS 
  • LOGOUT 

USER

  • DASHBOARD
  • SIGNUP
  • BOOK TICKET
  • LOGOUT

The online bus ticketing system has two users:

1. ADMIN
2.USER(passenger)

1. ADMIN ROLES:

Admin can perform all the actions regarding bus details such as addition, and deletion of the bus. changing operation date and time.

2. USER ROLES

Users (passengers) have limited action in the application. They can log in, and register if they are a new user. After logging in they can view the buses by entering from and to the location and they can book a number of tickets accordingly.

Admin Login:

ACTIONS PERFORMED:

Home page: Admin login page:

On selecting admin in the above-displaying age, the admin can log in and can make changes to the bus details.

User Login Page:

By selecting users, they can view the home page designed and register if they are new users.

Sign-in Page:

If the user is new to this application, they can register themselves by clicking the signup button given below.

UserServices Page:

On successful login of users, they can search for buses and book tickets.

Search Bus Page:

By providing the from, to location, and date of journey, the user can get the list of all available buses planned on that particular route and with the time details.

ContactUs Page:

TECHNOLOGY USED

  • JAVA(SPRING MVC,HIBERNATE)
  • HTML, CSS
  • JAVASCRIPT
  • MYSQL
  • JSP PAGES

Expected Outcomes

  • This Online Bus Ticket Booking System Application Connects Passengers with the Bus Operators And Vice Versa
  • Using This project, Passengers Can Book a Number Of Tickets Whenever They Want And Can Cancel Them.
  • Admins Can Alter The Bus Details Based On Their Route, day Of Operation, and Time.

Introduction to Online Ticket Booking System Project:

The online ticket booking system project explains about concept of developing a web-based bus ticket buying system. This project is implemented in Java Spring MVC Hibernate technologies, as the back end. In the present scenario usage of the internet had grown rapidly and most of the work is done through an online process as we see most products are purchased from websites and bus tickets are booked form online.

Though there are many online bus ticket reservation systems available on the internet we develop an application that will a real-time experience on an online website. This project provides detailed information with the project source code database.

Using these web portals users can book tickets, cancel tickets, know the availability of tickets, and the cost of tickets, and many other features which are available on every online reservation website.

Download the Complete project on Online Bus Ticket Booking System Java Spring MVC Hibernate Project Source Code