I have provided entire GYMONE project to download with SQL server Script that contains tables and stored procedures.
Please read text file ReadMe_First.txt 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 completely on GYM process. The process starts with Membership, when Member newly joins the GYM he is registered in the GYM Software by System User. While registering he will ask the Member that which type of Scheme he would like to take (GYM+CARDIO OR GYM) and for how much period he will be joining the 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 signed by the system user and the declaration form is signed by the Member who is joining the GYM. Along with this, the Member is told to provide legal document proof of address and photo identity. Now the Member can use GYM facilities till the Period for which he paid for Services. After completion of service he needs to renew Membership from System User for the next Period (Quarterly, Half Yearly, Yearly) and pay fee to System User for that Period.
The system user also has a right 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 then he can view Year wise Report (Year wise Report Download) and Finally, he can also check which user renewal is coming to notify him about the 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 . Accordingly, he can plan scheme for getting more Member to his GYM.
Platform Used
About Platform Used
I had 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)
Download Trial Crystal report Viewer 2011.
Database Details
Finally after understanding the process let's check out which are the tables we had used in this Application.
Please read text files ReadMe_First.txt first. In this file entire process of database creation and login details of file exists.
I have created database with name GYMONEDBMVC, inside this all the tables are present.
Let’s start with ASP.NET Membership tables. Firsty, we have the following five tables:
- Users
- webpages_Membership
- webpages_OAuthMembership
- webpages_Roles
- webpages_UsersInRoles
User Table
This table contains User Details with UserID.
webpages_Membership
This table contains User Password Details.
webpages_OAuthMembership
webpages_Roles
This table contains roles.
webpages_UsersInRoles
This table contains roles assigned to User.
After completing with all the Membership Tables now let's start with other tables.
- SchemeMaster
- PlanMaster
- MemberRegistration
- PaymentDetails
- RecepitTB
- Fiscalyear
SchemeMaster
Table contains all Scheme Details in it. For example, GYM+CARDIO or GYM
Plan Master
Table contains all Plan Name in it also a Foreign key SchemeID.
E.g. ( Quarterly , Half Yearly , Yearly)
MemberRegistration
Table contains all the details of members and it is a Master table.
PaymentDetails
Table contains all the payment details of Member in it. MemberID is Foreign key in this table.
ReceiptDetails
Table contains details of who and how many Receipts have been downloaded
Fiscal year
Table contains all Fiscal year details.
After completing database details now let’s have a look on Project structure in Visual Studio.
The Project Name is GYMONE.
You can see the basic folder structure provided by MVC.
External packages which are used in this Project
I have also added some packages from NuGet, here is the list:
- Bootstrap
- Dapper dot net
- Grid.MVC
- PagedList.MVC
- JQuery UI
Let’s have a look at folder and the details
Bootstrap folder contains all files of .js and .css.
Controller Folder contains all Controllers created in this application.
Model Folder contains all Models created in this application.
View Folder contains all Views created in this application.
Repository Folder
This folder contains Interface and there implementation.
E.g. IPlanMaster (Interface) and PlanMaster Implementation.
Reports Folder
This folder contains Crystal report which have been developed in this application.
The above shows how the directory and folder structure looks, now let’s check out our screens.
Starting with Login Screen.
Login Screen
After login screen now let’s check System User Screen.
System User Section
User Dashboard
After login, the user will see this User Dashboard screen in which he will be able to see all the pages which he can access.
Now let’s open first link of User Dashboard Register Member Master.
Register Member Master [Create]
Register Member Master [Listing]
Register Member Master [Edit / Update]
Receipt Download
In this page we can download Candidate Receipt.
Candidate Form Download
In this page we can download Candidate Declaration Form.
Payment Listing
In this page we can check out details of Member Payment and Renewal according to Member No or Member Name.
Renewal Details
In this page we can renew All Members Membership.
All Member List
In this page we can see All Member List which are Registered.
Year wise Report Download
In this page we can download Year wise Report of Fee Collection.
Month wise Report Download
In this page we can download Month wise Report of Fee Collection.
Detailed Renewal Report Download
In this page we can download Detailed Renewal Report of all Members.
Detailed Date wise Renewal Report Download [Exact Date]
In this page we can download Detailed Renewal Report of all Members according to Date.
Detailed Date wise Renewal Report Download [Between Dates]
In this page we can download Detailed Renewal Report of all the Members according to Date.
After completing with viewing System User Page now let’s move forward to have a look on Admin
Dashboard and Pages.
It is coded in a simpler way, just have a look on it and learn.
Account Section
The first thing we are going to look is Admin dashboard.
Reports here will be similar to what System User Reports.
After seeing dashboard now we are going to see how a role is created.
Create Role [Create]
Under admin section, create role and it is a one time entry.
In this system I have created only 2 roles [Admin , SystemUser], if any one wants to add another role then he need to add ([Authorize(Roles = "NewRoleName")]) attribute to controller in system.
Role Listing [Listing / Delete Role]
In this page I am displaying all roles which admin has added.
After adding roles now let's move towards creating System User Account.
Create User Account
In this page I am going to Register “SystemUser or Admin" which are going to use system.
And here are the details which are entered for creating an Account.
After Creating Account, first we are going to do is assign role to a user which we have created.
Assign Role to User
In this page I am going to show how to assign role to User which are created.
After assigning a role, now move towards Listing of Roles assigned to the User.
Display All SystemUser Assign Roles
In this page I am displaying all roles with Username to whom it is assigned.
Remove Role from User
In this page I am showing how to delete a User from a role whom we have already assigned a role.
All Registered User Details
In this page I am displaying all the registered user details.
After viewing all the registered User Details now lets Add Scheme to Member from Scheme Master.
Create Scheme Master [Create]
In this page I am going to show how to create a Scheme.
Scheme Master [Listing]
In this page I am going to display all the Scheme details.
Scheme Master [Edit]
In this page I am going to show how to Edit Scheme.
Create Plan Master [Create]
In this page I am going to show how to create a plan.
Plan Master [Listing]
In this page I am going to display all the entered Plans.
Plan Master [Edit]
In this page I am going to show how to Edit Plan.
Finally after completing View, now let’s move towards report to have a look on it.
Month wise Report
The first report which we are going to see is Month wise Report. In this report we are going to display all the fees collected in a particular month.
Year wise Report
The second report which we are going to see is Year wise Report. In this report we are going to display the fee collected in a particular year.
Details Report
The Third report which we are going to see is Details Member Report in this report we are going to display all Members which are registered in the GYM.
Payment Receipt
The Fourth report which we are going to see is Payment Receipt.
Declaration Form
The Fifth report which we are going to see is Declaration Form.
Finally we have completed the project successfully and I believe that people who are new to MVC have learnt a lot from this project.