Society Management System ASP.Net Project
In previous asp.net project post we have discussed about Student Management System , Milk Management System , Library Management System , Medical Store system project in asp.net with c#.
In this asp.net project post we will learn about Housing Society management system.
Society Management System
| Project Title : | E- Housing Society Management System |
|---|---|
| Abstract : | The Housing Helping Society is web application that manages society by houses with members details. |
| Project Type : | Website |
| Technology : | Visual Studio ASP.Net 2010 with C# Language |
| Database : | SQL-Server 2008 Database |
E – Housing Helping System Project in ASP.Net C#
The basic concept of this society system, we create global web based application in asp.net with c# language to manage Society with House and Owner of house detail. We provide platform to register society to our system, and there are many houses according to each society. Each house allocated to owner of house, all the owner are members of our project. After becoming a member they can login to give his house on rent or sell for all users. The people can easily find search the rent house or sell house in which society and get contact detail of owner of house by visiting our website. All members can make online complain related home to society management.
Project Video Tutorial
E- Housing Helping Society
Definition :
The Housing Helping Society is web application that manages society by houses with members details.
Abstract of Project :
In this society management system all the society categorize by the number of houses. The people who lives in house they may be a owner of house or tenant of house. In this era, people are very busy with their routine work, so they do not have time for complain small problem related to houses. We have developed the system for society member they can make complain form any where any time and we resolve the Complain as soon as possible. In this system people can easily find address of the house by providing member name.
The Member of our system can give advertise his house for rent and sell easily through our system by login his login detail. The main purpose of this site is to find out the house for rent and house for buy easily by visiting website.
Who can use the system
In this society helping system there are are three types of user one is Admin, Owner of house or member of website and the third rest of all other people.
Functionality of Admin :
Admin can manage all the system by login with his username and password.
Admin can register or add detail of society and create or add detail of number of houses of particular society.
After crating a house, allocate the house to member and generate username and password for all the member of this system. The member is a owner of house.
Admin can responsible for solve complain made by any member of the system. Admin can manage reports of rent house, sell house and complain.
Functionality of Member / Owner of House :
In our society system admin can allocate house to member and member is a owner of house. Member can easily put his house on rent and sell whenever he wants. Member can make any complain related to house by login his account and he can change his account detail, contact detail.
Member can receive message from users regarding to rent or buy his house in his message box.
Functionality of User :
User are the people who just search our website. User can easily find out detail of house or get easily address of the house by providing member name or society name from our search page.
User can easily know about how many houses are on rent and how many on sell in which society with member detail through our society helping system website.
PROJECT SQL – SERVER DATABASE DETAIL
Here, we provide society system sql data dictionary.
| TableName : SocietyMst |
|---|
| Detail : Table stores society detail |
| Columns : SID int – Society ID SName nvarchar(50) – SocietyName Address nvarchar(50) City nvarchar(50) Pincode nvarchar(50) NoHouse int – Total no of house in society Image nvarchar(200) – Picture of society EntryDate datetime – Society create date |
| TableName : HouseMst |
|---|
| Detail : Table stores House detail according to created society |
| Columns : HID int – House ID BlockNo int – Number of House unique for each house Type nvarchar(50) – Type of House (1bhk, 2bhk, etc..) Detail nvarchar(200) SName nvarchar(50) – SocietyName Image nvarchar(200) – Picture of House EntryDate datetime – House create date |
| TableName : UserMst |
|---|
| Detail : Table stores user detail with house detail |
| Columns : UID int – User ID FName nvarchar(50) – User First Name LName nvarchar(50) – User Last Name Email nvarchar(50) – User Email address Mobile nvarchar(50) – User Mobile No Bdate datetime – User birth date HouseID int – user is owner of this house no SocietyName nvarchar(50) – Society name Member int -Total member of house UserName nvarchar(50) – Username for log in to system Password nvarchar(50) – Password for log in to system Image nvarchar(200) – Picture of User EntryDate datetime – User create date |
| TableName : RentMst |
|---|
| Detail : Table stores the detail of rent house |
| Columns : RID int – Rent ID HID int – House Id SName nvarchar(50) – SocietyName UID int – Owner ID of house Rent float – House Rent Price EntryDate datetime – Rent create date |
| TableName : SellMst |
|---|
| Detail : Table stores Sell House detail |
| Columns : SID int – Sell ID HID int – House Id SName nvarchar(50) – SocietyName UID int – Owner ID of house Sell float – House Sell Price EntryDate datetime – Sell create date |
| TableName : ComplainMst |
|---|
| Detail : Table stores the member complains and problems. |
| Columns : CID int – Complain ID UID int – User ID, who makes complain Subject nvarchar(200) – Subject of complain Complain nvarchar(500) – Complain message Reply nvarchar(200) – Answer or solution of complain Status nvarchar(50) – Status of compalin solved or pending EntryDate datetime – House create date |
| TableName : MessageMst |
|---|
| Detail : Table stores detail of send and receive message. |
| Columns : MID int – Message ID FromName nvarchar(200) – Sender ToName nvarchar(200) – Receiver Subject nvarchar(200) Message nvarchar(500) EntryDate datetime – message date |
Related Project :
Hospital Management System C#.Net Project
Social Networking Site ASP.Net Project
Matrimonial Website ASP.Net Project
Download Society Helping System Website Project
| Download C#.net project with source code | |
|---|---|
| Download Society Management System C#.Net | Download Project |
| Download SQL-Server Database Stored Procedure. | Download SP |
| Use Case Diagram Society Management System. | Download Use Case |
| Activity Diagram For Society Management System | Activity Diagram |
| E-R Diagram For Society Management System | Download ERDiagram |
| DFD Diagram For Society Management System | Download DFD |
| Flow chart Diagram For Society Management System | Download FlowChart |
Project Tips :
Buy Project :
Contact us on meeraacademy@hotmail.com for buy full project with source code and database.
Download and Run Project Demo :
Learn how to download and run c# .net project with source code. Project Demo
Subscribe us
If you liked this c# post, then please subscribe to our YouTube Channel for more Project video tutorials.
We hope that this asp.net project tutorial helped you to understand Society Management System Project.
I am getting error in procedure that column name or number of supplied values does not match table definition
please, check all tables ID column must be set to primary key and auto increment.
Which version of sql server management studio is compatible for visual studio 2013?
All version are compatible. I prefer sql 2012 with VS2013.
Please give me the database of Society Management System Project in asp.net
All tables and stored procedure already given in above post.
how to import stored procedure?
create database ‘HHelp’ –> new query windows –> past download stored procedure txt code –> execute query –> Done.
Thank you so much ..
great work ..this is helping me so much to learning.
Thank you. we appreciate your comments.
Hey what is the password of admin page
username = password = admin
i am getting this type of error (Column name or number of supplied values does not match table definition)how to solve it
Make sure all table first column ID must be Primary Key.
Msg 213, Level 16, State 1, Procedure HOUSE_INSERT, Line 11 [Batch Start Line 7]
Column name or number of supplied values does not match table definition.
Make sure all tables first column ID must be set as Primary Key and auto increment.
how can i auto increment it? pls suggest!
At the time of table creation, select column for autoincrement set Identity Specification –> Is Identity = Yes
When i am running the script in ssms latest edition the commands are succesfully running but the tables are’nt updating even after i refresh it
you have to create tables manually from above post.
Foreign key required or not ?? If required which table column
No, make sure first ID column of all table is set as primary key and auto increment.