VB.Net - Real Estate Management System Source Code

Real Estate Management System Project Source Code Using Visual Basic .Net And MySQL Database

Real Estate Management System Project Using VB.Net

in this vb.net project tutorial serie we will see how to make a real estate management system project using windowForm in visual basic .net programming language and mysql database.

goals of this project:
- give students / curious persons an example so they can learn from it.
- helping people create their first project. 
- sharing knowledge with others.

tools:
- vb.net programming language.
- microsoft visual studio express 2013.
- mysql database.
- phpmyadmin.
- xampp server.
- pixabay.com ( website for free images ).

Watch This Full Demo


1 - The Login Form

the login form will allow the Users to login into the Real-Estate application Main Form.
the user need to enter his username and password before clicking the login button.


login from


if the user let the username or password empty, the textbox and label background color will become red.


login from 2


login from 3

if the user enter wrong username or password an error message will show up under the password fields.


login from 4


and if the user enter the correct data and click on the login button the main real estate management system form will show up and the login form will closed.


2 - The Real Estate System Main Project Form

after the user successffully login, he will see this main project window with a menu using panels and buttons.
the user can select where he want to go by clicking the on the item from the menu.

main form

this form contains a menu on the top to make it easy for the user to navigate on the application.

menu

with the menu this form contains also statics part in the middle of the form to show the user how many properties, owners, clients, and sales are in the application.
+ a refresh button to see the new statics when ever he add or remove an item.

statics


3 - The Real Estate System, Manage Clients Form


- this form contains a datagridview with all clients data.

- to add a new client, enter his data and click on "Add" button.

- to edit a client you need to select the one you wan to edit from the datagridview and enter his new data.

- when you want to delete a client just select the client you want to remove and click on the "Remove" button.
- to make it easy for the user when he want to add a new client, he can clear all textboxes by clicking on the "Clear Fields" button.

clients form

4 - The Real Estate System, Manage Owners Form


this form is pretty much like the clients form.

you can add, edit, remove selected owner and all the good stuff.

owners form

if you want to see the selected owner properties, just select the owner from the datagridview and click the "Show This Owner's Properties" button, and a form will show up with all owner's properties in it.


owner's properties

5 - The Real Estate System - Manage Property's Types Form


in this form the user can manage the types of properties in the system project.
all types are displayed in a listbox, if you select an item from the listbox it will be displayed on the textboxes.



types form


7 - The Real Estate System , Manage Property Form


this form contains textBoxes, numericUpDown, checkBoxes and one comboBox populated  with all types.


properties form


in this form the user can add, edit, search and remove a property.
when the user want to add/edit a property he need to select an owner for this property, and he can do that by clicking on the "Select Owner" button and a form will show up with a datagrdview filled with all owners, allowing the user to select an owner.
when the user double click on the datagridview the "select owner" form will be closed and the owner id will be set into the textbox.


owners list

if the user want to search for a property all he need to do is to enter the property's id and click on the "Search" button.

search for a property


Some Notes: each property need to be assigned to a type, which can be selected from the combobx.
if the user let the age at "0" it mean that the real estate is brand new
( except for the lands because ... well it's a land :/ )

if the user want to see the selected property images by clicking on the "Show This Property Images".


property images slider


if the user want to see all properties list by clicking on the "Show All Properties" button .


properties list form

8 - The Real Estate System , Manage Property's Images Form


this form contains 2 datagridviews,1 listbox and 1 picturebox.
- datagridview 1 is filled with all types.
- datagridview 2 is filled with all properties, when the user select a type from datagridview 1 all properties in this type will be displayed in datagridview 2.
- the listbox is populated with all properties images, when the user select a property from datagridview 2 all images of this property will be displayed in listbox.
- when the user select an image from the listbox, the selected image will be displayed in the picturebox.

the user can browse a photo from his computer and add it to the selected property.
the user can remove the selected image by selecting it from the listbox.
there is no edit image, just add and remove.


manage property images form


manage property images form 2


when you click on the "Show This Property Images" a form will show up with a SlideShow to display the images and two buttons to navigate + a label displaying the total images for the selected property.


images slider

9 - The Real Estate System , Manage Sales Form


in this form the user can manage the properties sales.
this form contains 2 datagridviews:
1 - display the sales.
2 - display the properties.
and you can add, edit remove the selected sale.


sales form

to display only the clients the user need to click on the "Show Clients" button. 


show clients

the properties are displayed by default but if the user click to show the clients and want to see the properties again he need to click on the "Show Properties" button. 


show properties


to display only the properties sold, click on the "Properties Sold" button under the  datagridview


Properties Sold

to display only the properties NOT sold, click on the "Properties Not Sold" button under the  datagridview. 


Properties Not Sold



if you want the source code click on the download button below






disclaimer: you will get the source code + the database script
                    and to make it work in your machine is your responsibility
                    and to debug any error/exception is your responsibility
                    this project is for the students who want to see an example and read the code not to get and run.



C# - Login And Register Form Design

How To Design a Login And Register Form In C#

C# Login And Register Form Design


in this c# form design tutorial we will see how to design a login and register form in one  windowForm using csharp programming language .

tools:
- c# programming language.
- microsoft visual studio express 2013.
- iconsdb.com ( to get the close icon).
- canva.com ( to create the app logo ).
- flatuicolorpicker.com ( for color ideas ).

Watch This Full Demo


- The Project Source Code

we will add two buttons and two panels to the form, inside the panels we will add the textboxes and buttons to login and register, and the two buttons will help us to go between the two panels.

c# login form design


c# register form design


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace csharp_LoginRegister_Design
{
    public partial class LoginAndRegisterForm : Form
    {
        public LoginAndRegisterForm()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            button_GoToLogin.PerformClick();
        }

        Color select_color = Color.FromArgb(49, 46, 46);

        private void button_GoToLogin_Click(object sender, EventArgs e)
        {
            panel_login.BringToFront();
            panel_login_bar.BackColor = Color.Yellow;
            panel_register_bar.BackColor = select_color;
            button_GoToLogin.BackColor = select_color;
            button_GoToRegister.BackColor = Color.Black;
        }

        private void button_GoToRegister_Click(object sender, EventArgs e)
        {
            panel_register.BringToFront();
            panel_register_bar.BackColor = Color.Yellow;
            panel_login_bar.BackColor = select_color;
            button_GoToRegister.BackColor = select_color;
            button_GoToLogin.BackColor = Color.Black;
        }

        private void pictureBox_close_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}


VB.Net Import Txt File Text To DataGridview

How To Populate DataGridview From a Text File Data In VB.Net

display txt file text to a datagridview using vb.net



In this VB.NET Tutorial we will see How To Get Records From .txt File And Display The Values Into DataGridView Rows On Button Click Event Using Visual Basic.Net  Programming Language And Visual  Studio Editor.




Project Source Code:


Imports System.IO

Public Class TXT_TO_DGV

    Dim table As New DataTable()
    Private Sub TXT_TO_DGV_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        ' add columns to datatable
        table.Columns.Add("Id", Type.GetType("System.Int32"))
        table.Columns.Add("First Name", Type.GetType("System.String"))
        table.Columns.Add("Last Name", Type.GetType("System.String"))
        table.Columns.Add("Age", Type.GetType("System.Int32"))

        ' set the datatable as datasource
        DataGridView1.DataSource = table

    End Sub

    ' button import
    Private Sub ButtonImport_Click(sender As Object, e As EventArgs) Handles ButtonImport.Click

        Dim lines() As String
        Dim vals() As String
      
        ' get lines from the text file
        lines = File.ReadAllLines("C:\Users\1BestCsharp\Desktop\table.txt")

        For i As Integer = 0 To lines.Length - 1 Step +1  ' lines

            vals = lines(i).ToString().Split("|")
            Dim row(vals.Length - 1) As String

            For j As Integer = 0 To vals.Length - 1 Step +1  ' columns

                row(j) = vals(j).Trim()

            Next j

            table.Rows.Add(row)

        Next i


    End Sub
End Class


OutPut:

Import Text File Text To DataGridview Using VB.Net


C# Real Estate Management System Source Code

Real Estate Management System Project Source Code Using C# And MySQL Database

C# Real Estate Management System Project

in this c# complete project tutorial serie we will see how to create a real estate management system using windowForm in c# programming language and mysql database.

goals of this project:
- give students / curious persons an example so they can learn from it.
- helping people create their first project. 
- sharing knowledge with others.

tools:
- c# programming language.
- microsoft visual studio express 2013.
- mysql database.
- phpmyadmin.
- xampp server.
- pixabay.com ( website for free images ).

Watch This Full Demo


1 - The Login Form

the login form will allow the Users to login into the Real-Estate application Main Form.
the user need to enter his username and password before clicking the login button.


login form


if the user let the username or password empty an astrix will show up in the right side of the textbox.


login form 2

if the user enter wrong username or password an error message will show up telling him what's the problem.


login form 3


and if everything is ok, when the user click on the login button the main real estate management system form will show up and the login form will closed.


2 - The Real Estate System Main Project Form

after the user successfully login, he will see this main app window with a menu using panel and buttons.
the user can select where he want to go by clicking the on the item from the menu.

main form


menu
Menu Item Hover


3 - The Real Estate System , Clients Form


- this form contains a datagridview with all clients data, a label with total clients in the database.

- to add a new client enter his data and click on "Add" button.

- to edit a client you need to select him first from the datagridview and enter his new data.

- when you want to delete a client just select the client you want to remove and click on the "Remove" button.
- when you Add or Remove a client the label with clients count will be updated automatically.

manage clients form

4 - The Real Estate System Manage Owners Form


this form is 90% like the clients form

you can add, edit, remove selected owner and all the good stuff.

manage owners form

if you want to see a selected owner properties, just select the owner from the datagridview and click the "Show This Owner's Properties" button.

and you can see a label with total of properties this owner have.


owner properties

5 - The Real Estate System - Property's Types Form


in this form the user can manage the types of properties in the system.
all types are displayed in a listbox, if you select an item from the listbox it will be displayed on the textboxes.



property types

property types 2

6 - The Real Estate System , Property Form


this form contains textboxes, numericUpDown for the numeric values, checkboxes for the property features, a combobx populated  with all types,


manage property form


in this form the user can add, edit, search and remove a property.
when the user want to add/edit a property he need to select an owner for this property, and he can do that by clicking on the "Select Owner" button and a form will show allowing him to select an owner.


owners list

if the user want to search for a property all he need to do is to enter the property's id and click on the "search" button.
each property need to be assigned to a type, which can be selected form the combobox.

search property


if the user can see the selected property images by clicking on the "Show This Property Images".


property images


if the user want to see all properties list by clicking on the "Show All Properties" button .


owners properties list

7 - The Real Estate System , Property's Images Form


in this form the user can see all properties displayed in a datagridview, and all types on a listbox.


manage property images

if the user select a type from the listbox => all properties in this type will be displayed in the datagridview.




when you select a property from the datagridview => all this property's images id will be displayed in another listbox => and when you select an item from the list the image will show up in a pictureBox.






the user can browse a photo from his computer and add it to the selected property.
the user can remove the selected image by selecting it from the listbox.
there is no edit image, just add and remove.


manage property images 2

when you click on the "Show This Property Images" a form will show up with a SlideShow to display the images and two buttons to navigate.


property images slider

8 - The Real Estate System , Sales Form


in this form the user can manage the properties sales.
this form contains 3 tables:
1 - display the clients.
2 - display the properties.
3 - display the sales.
and you can add, edit remove the selected sale.


property sale form


properties sales form

to display only the properties sold the user need to click on the "Properties Sold". 


properties sold

to display only the properties NOT sold the user need to click on the "Properties Not Sold". 


properties not sold

to display ALL the properties the user need to click on the "All Properties". 

all properties



if you want the source code click on the download button below






disclaimer: you will get the source code + the database script
                    and to make it work in your machine is your responsibility
                    and to debug any error/exception is your responsibility
                    this project is for the students who want to see an example and read                                      the code not to get and run