aspdotnet-suresh offers articles and tutorials,csharp dot net, articles and tutorials,VB.NET Articles,Gridview articles,code examples of 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies MVC Example Demo Project Application with Database Download

Sep 2, 2015
Here we will explain simple mvc example project with database / code download or step by step 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 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.

Platform Used

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

Database Details

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 Membership tables and custom tables

1.            Users
2.            webpages_Membership
3.            webpages_OAuthMembership
4.            webpages_Roles
5.            webpages_UsersInRoles

After completing with all Membership Table following custom tables we need to create in database

1.            SchemeMaster
2.            PlanMaster
3.            MemberRegistration
4.            PaymentDetails
5.            RecepitTB
6.            Fiscalyear

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

Login Screen

After login screen now let’s check System User Screen

System User Section

User Dashboard

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

Account Section

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...)

Detailed Report

Payment Receipt

Declaration Form

For more details please check attached folder

Download Project

Please download complete project files from attached file

Author Profile

Name: Saineshwar Bageri


I am Software Developer and MVP from c-sharpcorner working on  .Net Web Technology ( , C# ,  Sqlserver , MVC , Windows ,Console Application, javascript , jquery , json , ORM Dapper) and also freelance developer.

Connect me on Facebook

Connect me on twitter

Connect me on Blogger

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest,, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

subscribe by rss Subscribe by RSS subscribe by email Subscribe by Email


Anonymous said...

thanks... nice efforts..

Emerald said...

Thanks for sharing :)

karthick said...

Good boss... Should b appreciate... Thanks for sharing...pls share a lot regarding MVC

Saineshwar bageri said...

thanks friends

Jayakumar said...


Good one nice.

But when i register users admin or user this table not reflecting table name this


can you update this or give me solution how to insert this table when users registered.

can you share your gmail id thats helpful for me.

Hamid said...

Could you please share, Demo MVC with EF using angularjs databinding data,
with multiple HTML control.

SACHIN said...

hi i have downloaded the project but getting error at the time of building solution
Error 1 The type or namespace name 'CrystalDecisions' could not be found (are you missing a using directive or an assembly reference?)
Please help

Saineshwar bageri said...

Hi Jayakumar when you assign role to User that time the data will be added to this table (webpages_UsersInRoles)

Saineshwar bageri said...

Hi Hamid Ali Khan Will Soon will come up with your need.

Saineshwar bageri said...

You are getting this Error of (CrystalDecisions) because you do not have installed crystal report version 13 on your PC.

Unknown said...

Very nice Demonstration. :)
Can you please help to make my login Authenticate ?
I have already designed & coded login part.
How to update/upgrade this login to Authenticate with WebSecurity.Login()?

Please help.


Anonymous said...

Thank you Mr. Saineshwar Bageri.

From So long i am looking for a complete mvc solution from which i can learn something and you have put all your effort. Thanks alot....

Anonymous said...

Thanks so much

Anonymous said...

The best document for a learner i have ever seen on
Excellent work Mr. Saineshwar Bageri.

anu said...

any one please send me the Crystal report 2013 product key

vivek said...

can any one Please share Username and Password of this project?
I really need it, actually password is encrypted format.

Anubhav said...

Not able to login using either of them
Login Details

1) Admin
UserID : Admin
Password : 123456

2) System User
UserID : User
Password : 123456

WebApp@SoftwareEngineer916 said...

Dear Admin/Friends,

I am getting this error and cannot take the Reports.It is an urgent requirement.Any help is highly appreciable.

The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception.

Saineshwar bageri said...

Its not loading Crystal reports DLL

GO to the bin folder on your local machine and then for every dll click on the dll so in the properties windows you will get the properties of the dll

The there is a property that will show Copy Local by default it is false make it true and then publish the website and replace the website on the server.

Hope that helps

WebApp@SoftwareEngineer916 said...

Thanks Saineshwar...
Finally fixed the issue.After uninstalling Crystal reports v14.0.4 and installed below one works fine.
Please update the site with this URL..

WebApp@SoftwareEngineer916 said...

All Reports is working nice..But 1 warning while build
1> No way to resolve conflict between "log4net, Version=, Culture=neutral, PublicKeyToken=1b44e1d426115821" and "log4net, Version=, Culture=neutral, PublicKeyToken=692fbea5521e1304". Choosing "log4net, Version=, Culture=neutral, PublicKeyToken=1b44e1d426115821" arbitrarily.

Any idea why this message?

Anonymous said...

error in execution
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

hi said...

DeleteRole Not working,

When i try to delete a role it throws ArgumentNullException was unhandled by user Code
value cannot be null
RoleName count is 0
please can you guide in solving this issue.

Anonymous said...


Anonymous said...

Does the source code available in GitHub?

Mahesh Guttedar Kalgi said...

very nice article...but the thing is reports are not generating please help me yar saisankeshwar

Unknown said...

Not able to download the project. Can you please verify?

sumit said...

thanks for sharing information

Unknown said...


Unknown said...

Thank you Mr. Saineshwar Bageri.but crystal report is not working..

Unknown said...

hai sir thanks for sharing Project

when am running project in my pc it shows "one or more projects in solution were not load correctly please see the output window for details " error
can you help me to how to run the project

thanks and regards

Anonymous said...

Your project is running fine except the crystal reports. showing error as "could not locate the assembly crystaldecisions.crystalreports.engine". what should be done with this? can you please help me out?

Anonymous said...

Also I have downloaded the crystal reports 13 but it is asking for product id?
What should be done? please help me its urgent

Anonymous said...

Hi Saineshwar ,

i am not able to download this project could you please guide me what are the right step to download this project i really needed.


Anonymous said...

Hi sir,
Thanks a lot for sharing this project. I have no idea about MVC projects,But it help me very much.

Anonymous said...

what is password to login..?

Anonymous said...

Hello sir
Can you please explain how do you implement role based functionality in application?
Bhushan Deshmukh

Unknown said...

Thank You Very Much Sai For Providing This Project.Recently i just started learning MVC,
It will be very helpful to me.

Unknown said...

Hi Sai
I am getting folloing error
Error 1 Cannot embed interop types from assembly 'c:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet\CrystalDecisions.CrystalReports.Engine.dll' because it is missing either the 'ImportedFromTypeLibAttribute' attribute or the 'PrimaryInteropAssemblyAttribute' attribute c:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet\CrystalDecisions.CrystalReports.Engine.dll GYMONE

Unknown said...

I couldnt download project realted source & DB SCripts , other files.
Pls share links and credentials.

Unknown said...

Thanks Buddy Helps Alot

dheeru yadav said...

connection setting error in visual studio 2013 how resolve

Unknown said...

getting error in WebSecurity.InitializeDatabaseConnection("Mystring", "Users", "Id", "UserName", autoCreateTables: true);

i.e instance failure

Unknown said...
This comment has been removed by the author.
Unknown said...
This comment has been removed by the author.
Unknown said...

report is not open in my system,why?
link is open but no data is show.

vidya086 said...

cant's find project source code download link

Anonymous said...

how should i run database script give me a command

Unknown said...

Hello Mr.Saineshwar Bageri
when i am download recepit here is comming crystal reports errors
CrystalDecisions.CrystalReports.Engine this dll is not handle but i am already add this dll reference but error is comming thanks in advance

Ram said...

bro.... what is the password? where is registration link in login page?

Anonymous said...

Dear Ram ,
a little effort is needed http://localhost:2420/account/login this is login screen .
replace ur local host ip accordingly now when you will try to login using 1) Admin
UserID : Admin
Password : 123456

2) System User
UserID : User
Password : 123456 then it will not be able to validate you . As in the db your table is empty .
so just two steps needed
1. in users table create two entry a. Id = 1, UserName=Admin; Id =2, Username= User
2 check this select * from webpages_Roles u will understand that there is Roleid associated with the RoleName
3. Finaly make an insert as insert into webpages_UsersInRoles values(1,1) and insert into webpages_UsersInRoles values(2,2)
With this step you will have two user which have the authentication and voilla you can login as admin and user .
I also recommend please follow the pdf guideline and then follow this steps.

Anonymous said...

The system cannot find the file specified. Im getting the following error on this line "@Scripts.Render("~/bundles/jquery")"

when i downloaded the file with the link provided, after unzipping i found the bundles folder is missing please help regarding the problem

Unknown said...

But when i register users admin or user this table not reflecting table name this


This is very nice one
can you update this or give me solution how to insert this table when users registered.

Where is using WebMatrix.WebData.WebSecurity class?;

Unknown said...

not able too download. with this link:
would you please help?

All in One said...

thanks am doawnload and i can see all class and thi../

Unknown said...

Thanks for all information. how to connect SMS with in C# program by using MVC

Unknown said...

Hy can you please send code for pay pal

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.