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.
Hey can you please tell how to join SQL database with website…. Means step by step instructions.
Download project source code and Stored procedure from above link. Open sql server and create database and tables as shows in above video after bind stored procedure to sql database.
Open project source code in visual studio 2012 and run project…
giv project source code and Stored procedure
Project Source code and stored procedure download link is given in above post.
everything is there just see there is option where in u can download the source code of [project
There are no source is available
Source code download project link shows in last portion of post.
while creating tables we need to apply primary key?
yes, first ID column of each table is primary key and set property Is Identity = yes for auto increment.
Msg 2714, Level 16, State 3, Procedure HOUSEMST_CHANGE_IMAGE, Line 10
There is already an object named ‘HOUSEMST_CHANGE_IMAGE’ in the database.
how to this problem issue
It is not a error. The stored procedure name already exist, Write ALTER instead of CREATE in stored procedure and then save.
HI
I am trying to open the application, but in database, dbo.SOCIETY_INNSERT procedure is missing and the table information MessageMst is missing.
can you please give these two detials.
table information given in above post and stored procedure already exist in download file.
dbo.SOCIETY_INNSERT stored procedure is missing.
Stored Procedure already given in download file.
CREATE PROCEDURE [dbo].[SOCIETY_INNSERT]
@SNAME AS NVARCHAR(256),
@ADD AS NVARCHAR(256),
@CITY AS NVARCHAR(256),
@PIN AS NVARCHAR(256),
@NOOFHOUSE AS INT,
@img as nvarchar(700)
AS
BEGIN
INSERT INTO SocietyMst VALUES(@SNAME,@ADD,@CITY,@PIN,@NOOFHOUSE,@img,GETDATE())
END
GO
Hey, How can I run the application I didn’t get solution file on the source code.
step to open : open visual studio -> file -> open -> website ->select whole project folder.
Hey, can you tell me how i connect this website to sql database ???
you have to crate table as show in above post first. then you can run the site.
how can bind stored procedure to sql database ????
Open SLQ database — > New Query –> Past stored procedure code –> Execute query.
Your Project is not Download
How to download Your Uploaded project download
Tell me?
Download link already given in above post.
db is in .txt format .how can i get it on sql
Open sql server –> New Query –> Past .txt code –> Execute query.. done
can we run this project on visual studio 2017?
yes
Mam, I am having the error “System.Data.SqlClient.SqlException: ‘Column name or number of supplied values does not match table definition.” at the time to insert a new society in database.
please, check all table ID column must be Primary key and auto increment.