Here we will explain simple asp.net mvc example project with database / code download or step by step asp.net mvc application project with database download. We created simple step by step GYMONE project to let users learn mvc in easy way.
Please check following details for demo Project in Asp.net MVC
Project GYMONE Guide
Project Name: - GYMONE
we provided entire GYMONE project to download with Sql server Script which contains tables and store procedures which are used.
Please read Text files ReadMe_First.txt file first.
In this Application there are 2 Types of Users one will be Admin and other will be System User.
Project System User Process:-
This project aims complete on GYM process. The Process starts with Membership when Member is newly joining GYM he is been registered in GYM Software by System User while registering he will ask to Member for which type of Scheme he will like to take (GYM+CARDIO OR GYM) and for how much period he will be joining GYM (Quarterly, Half Yearly, Yearly) According to this the Fees of GYM will be decided. After registering The Member is given a Receipt and Declaration form. the Receipt is sign be System User and Declaration form is been sign by Member who is joining the GYM along with this Member is told to provide legal Document proof of Address and Photo Identity. Now the Member can use GYM facilities till Period has paid for Services after completion of service he need to renew Membership it from System User for next Period ( Quarterly , Half Yearly , Yearly) and pay Fee to System User for that Period.
The System user also has a Rights to check How much Amount has been Collected this month by seeing Month wise (Month wise Report Download) Report and if he want to check how much Amount has been collected this year than he can view Year wise Report (Year wise Report Download) and Finally he can also check which user renewal is upcoming to notify him about his renewal of Membership by viewing renewal Report.
Admin System User Process:-
The Role of Admin is to Create and Delete System User and also assign roles (Admin , System User ) to them . He also has rights for Adding Scheme ( GYM+CARDIO OR GYM etc ) and Plan ( Quarterly , Half Yearly , Yearly) he can view All Reports Month wise collection Report and Year wise collection Report , Renewal Report according to this he can plan scheme for getting more Member to his GYM.
About Platform Used
we developed this Application using Microsoft Visual Studio Ultimate 2012 with Microsoft SQL server 2008 and Reporting is done using Crystal Report Version (13.0.2000.0).
Project is Created using ASP.NET MVC 4 and Language Used is C# and ORM Dapper with Repository Pattern.
Microsoft Visual Studio Ultimate 2012.
Link to download Trial Microsoft Visual Studio Ultimate 2012
Microsoft SQL server 2008
Link to download Trial Microsoft Visual Microsoft SQL server 2008
SAP Crystal Report Version (13.0.2000.0)
Link to download Trial Crystal report Viewer 2011
Finally after Understanding Process let check out which are the tables we had used in this Application.
Please read Text files ReadMe_First.txt file first in this file entire process of database creation and Login details of file exists.
we have created database with Name GYMONEDBMVC inside this all this tables are present.
we used following Asp.net Membership tables and custom tables
After completing with all Membership Table following custom tables we need to create in database
For detailed info please check attached folder
After Completing Database Details Now let’s have look on Project structure in Visual studio
The Project Name is GYMONE.
You can see basic folder structure provide by MVC
Finally we had completed having look on folder structure now let’s check out our screens.
For detailed info please check attached folder
Screenshots of Project
Starting with Login Screen
After login screen now let’s check System User Screen
System User Section
After login user will see this User Dashboard screen in which he will able to see all page which he can access.
Now let’s open first link of User Dashboard Register Member Master
Register Member Master [Create]
All Member List
In this page we can see All Members List which are Registered
The first thing we are going to look is Admin dashboard
Reports here will be similar to what System User Reports
and lot more sections like
Roles (Creation, Edit, Delete)
Assign Role to users
Mapping User details
Schema Master (Create, Listing, Edit)
Plan Master (Create, Listing, Edit)
Reporting (Year wise, month wise, Renewal, etc...)
For more details please check attached folder
Name: Saineshwar Bageri
Connect me on Facebook
Connect me on twitter
Connect me on Blogger