Gayrimenkul Satış İşlemi Takip Programı C#

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM1 İçerisine Yazılacak Kodlar…

public partial class Form1 : Form
{
public Form2 frm2 ;
public Form3 frm3;
public Form4 frm4 ;
public Form5 frm5 ;
public Form6 frm6 ;
public Form7 frm7;
public Form8 frm8;
public Form9 frm9;

public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm6 = new Form6();
frm7 = new Form7();
frm8 = new Form8();
frm9 = new Form9();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
frm6.frm1 = this;
frm7.frm1 = this;
frm8.frm1 = this;
frm9.frm1 = this;
}
private void Form1_Load(object sender, EventArgs e)
{
label1.Text = " Emlak.Coma Giriş Yapınız... ";
timer1.Interval = 100;
timer1.Enabled = true;
}

private void button1_Click_1(object sender, EventArgs e)
{
frm2.Show();
this.Hide();
}

private void timer1_Tick(object sender, EventArgs e)
{
label1.Text = label1.Text.Substring(1) + label1.Text.Substring(0,1);
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM2 İçerisine Yazılacak Kodlar…

public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.frm3.Show();
this.Hide();
}

private void button2_Click(object sender, EventArgs e)
{
frm1.frm4.Show();
this.Hide();
}

private void button3_Click(object sender, EventArgs e)
{
frm1.frm5.Show();
this.Hide();
}

private void button4_Click(object sender, EventArgs e)
{
frm1.frm6.Show();
this.Hide();
}

private void button6_Click(object sender, EventArgs e)
{
frm1.frm8.ShowDialog();

}

private void button5_Click(object sender, EventArgs e)
{
frm1.frm9.Show();
this.Hide();
}
}

FORM3 İçerisine Yazılacak Kodlar…

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

namespace WindowsFormsApplication1
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}

public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();

public void musara()
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kira", bag);
if (textBox4.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from kira";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "kira");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From kira" +
" where(ilansahibi like '%" + textBox4.Text + "%' )";
dtst.Clear();
adtr.Fill(dtst, "kira");
bag.Close();
}
public void combo()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from metrekare";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox1.Sorted = true;
}

public void combo2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from il";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
comboBox2.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox2.Sorted = true;
}

public void listelesene()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kira ", bag);
adtr.Fill(dtst, "kira");
dataView1.Table = dtst.Tables[0];
dataGrid1.DataSource = dataView1;
adtr.Dispose();
bag.Close();
}
private void Form3_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
combo();
combo2();
listelesene();
}

private void button5_Click(object sender, EventArgs e)
{
frm1.frm2.Show();
this.Hide();
}

private void button1_Click(object sender, EventArgs e)
{

bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO kira(emlaktürü,metrekare,fiyat,il,ilansahibi,taleptarihi) VALUES ('" + textBox1.Text + "','" + comboBox1.Text + "','" + textBox2.Text + "','" + comboBox2.Text + "','" + textBox3.Text + "' , '" + dateTimePicker1.Text + "') ";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listelesene();

MessageBox.Show("İşlem Tamamlandı..");
}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
comboBox1.Text = " ";
comboBox2.Text = " ";
}

private void button3_Click(object sender, EventArgs e)
{
DialogResult cevap;
cevap = MessageBox.Show("silmek istiyormusunuz?", "UYARI", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "DELETE FROM kira WHERE ilansahibi='" + textBox4.Text + "'";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listelesene();

}

}

private void button4_Click(object sender, EventArgs e)
{
musara();
}

private void button6_Click(object sender, EventArgs e)
{
dtst.Clear();
listelesene();
}
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM4 İçerisine Yazılacak Kodlar…

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

namespace WindowsFormsApplication1
{
public partial class Form4 : Form
{
public Form1 frm1;

public Form4()
{
InitializeComponent();
}
public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();

public void musara()
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From satilikbina", bag);
if (textBox4.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from satilikbina";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "satilikbina");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From satilikbina" +
" where(ilansahibi like '%" + textBox4.Text + "%' )";
dtst.Clear();
adtr.Fill(dtst, "satilikbina");
bag.Close();
}
public void combo()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from metrekare";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox1.Sorted = true;
}

public void combo2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from il";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
comboBox2.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox2.Sorted = true;
}

public void listelesene()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From satilikbina ", bag);
adtr.Fill(dtst, "satilikbina");
dataView1.Table = dtst.Tables[0];
dataGrid1.DataSource = dataView1;
adtr.Dispose();
bag.Close();
}

private void button5_Click(object sender, EventArgs e)
{
frm1.frm2.Show();
this.Hide();
}

private void Form4_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
combo();
combo2();
listelesene();
}

private void button1_Click(object sender, EventArgs e)
{

bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO satilikbina(emlaktürü,metrekare,fiyat,il,ilansahibi,taleptarihi) VALUES ('" + textBox1.Text + "','" + comboBox1.Text + "','" + textBox2.Text + "','" + comboBox2.Text + "','" + textBox3.Text + "' , '" + dateTimePicker1.Text + "') ";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listelesene();

MessageBox.Show("İşlem Tamamlandı..");
}

private void button3_Click(object sender, EventArgs e)
{
DialogResult cevap;
cevap = MessageBox.Show("silmek istiyormusunuz?", "UYARI", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "DELETE FROM satilikbina WHERE ilansahibi='" + textBox4.Text + "'";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listelesene();

}
}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
comboBox1.Text = " ";
comboBox2.Text = " ";
}

private void button4_Click(object sender, EventArgs e)
{
musara();
}

private void button6_Click(object sender, EventArgs e)
{
dtst.Clear();
listelesene();
}
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM5 İçerisine Yazılacak Kodlar…

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

namespace WindowsFormsApplication1
{
public partial class Form5 : Form
{
public Form1 frm1;
public Form5()
{
InitializeComponent();
}

public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();

public void combo()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from metrekare";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
comboBox3.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox3.Sorted = true;
}

public void musara()
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From satilikarsa", bag);
if (textBox4.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from satilikarsa";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "satilikarsa");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From satilikarsa" +
" where(ilansahibi like '%" + textBox4.Text + "%' )";
dtst.Clear();
adtr.Fill(dtst, "satilikarsa");
bag.Close();
}

public void combo2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from il";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
comboBox2.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox2.Sorted = true;
}

public void listelesene()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From satilikarsa ", bag);
adtr.Fill(dtst, "satilikarsa");
dataView1.Table = dtst.Tables[0];
dataGrid1.DataSource = dataView1;
adtr.Dispose();
bag.Close();
}
private void Form5_Load(object sender, EventArgs e)
{
textBox1.Enabled = false;
combo();
combo2();
listelesene();
}

private void button5_Click(object sender, EventArgs e)
{
frm1.frm2.Show();
this.Hide();
}

private void button1_Click(object sender, EventArgs e)
{

bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO satilikarsa(emlaktürü,metrekare,fiyat,il,ilansahibi,altyapı) VALUES ('" + textBox1.Text + "','" + comboBox3.Text + "','" + textBox2.Text + "','" + comboBox2.Text + "','" + textBox3.Text + "' , '" + comboBox1.Text + "') ";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listelesene();

MessageBox.Show("İşlem Tamamlandı..");
}

private void button3_Click(object sender, EventArgs e)
{
DialogResult cevap;
cevap = MessageBox.Show("silmek istiyormusunuz?", "UYARI", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "DELETE FROM satilikarsa WHERE ilansahibi='" + textBox4.Text + "'";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listelesene();

}
}

private void button2_Click(object sender, EventArgs e)
{
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
comboBox1.Text = " ";
comboBox2.Text = " ";
comboBox3.Text = " ";
}

private void button4_Click(object sender, EventArgs e)
{
musara();

}

private void button6_Click(object sender, EventArgs e)
{
dtst.Clear();
listelesene();
}

private void dataGrid1_Navigate(object sender, NavigateEventArgs ne)
{

}
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM6 İçerisine Yazılacak Kodlar…

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

namespace WindowsFormsApplication1
{
public partial class Form6 : Form
{
public Form1 frm1;
public Form6()
{
InitializeComponent();
}

public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();

public void combo2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from il";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox1.Sorted = true;
}

public void listelesene()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From bireysel ", bag);
adtr.Fill(dtst, "bireysel");
frm1.frm7.dataView1.Table = dtst.Tables[0];
frm1.frm7.dataGrid1.DataSource = frm1.frm7.dataView1;
adtr.Dispose();
bag.Close();
}
private void Form6_Load(object sender, EventArgs e)
{
combo2();

}
private void button3_Click(object sender, EventArgs e)
{
frm1.frm2.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO bireysel(email,adsoyad,adres,postakodu,il,tel) VALUES ('" + textBox1.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + comboBox1.Text + "' , '" + maskedTextBox2.Text + "') ";
kmt.ExecuteNonQuery();
bag.Close();
kmt.Dispose();
dtst.Clear();
listelesene();

MessageBox.Show("İşlem Tamamlandı..");
}

private void button2_Click(object sender, EventArgs e)
{
frm1.frm7.Show();
this.Hide();
}
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM7 İçerisine Yazılacak Kodlar…

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

namespace WindowsFormsApplication1
{
public partial class Form7 : Form
{
public Form1 frm1;

public Form7()
{
InitializeComponent();
}
private void Form7_Load(object sender, EventArgs e)
{
groupBox1.Visible = false;
}

private void button3_Click(object sender, EventArgs e)
{
frm1.frm2.Show();
this.Hide();
}

private void button1_Click(object sender, EventArgs e)
{
groupBox1.Visible = true;

}
private void button4_Click(object sender, EventArgs e)
{
DialogResult cevap;
cevap = MessageBox.Show("silmek istiyormusunuz?", "UYARI", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.frm6.bag.Open();
frm1.frm6.kmt.Connection = frm1.frm6.bag;
frm1.frm6.kmt.CommandText = "DELETE FROM bireysel WHERE email='" + textBox1.Text + "'";
frm1.frm6.kmt.ExecuteNonQuery();
frm1.frm6.bag.Close();
frm1.frm6.kmt.Dispose();
frm1.frm6.dtst.Clear();
frm1.frm6.listelesene();
}
}

}
}

FORM8 İçerisine Yazılacak Kodlar…

public partial class Form8 : Form
{
public Form1 frm1;
public Form8()
{
InitializeComponent();
}

private void Form8_Load(object sender, EventArgs e)
{
webBrowser1.Navigate("www.gorselprogramlama.com");
}

private void button1_Click(object sender, EventArgs e)
{
frm1.frm2.Show();
this.Close();

}
}

FORM9 İçerisine Yazılacak Kodlar…

public partial class Form9 : Form
{
public Form1 frm1;
public Form9()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
openFileDialog1.ShowDialog();
axWindowsMediaPlayer1.URL = openFileDialog1.FileName;
}
private void button2_Click(object sender, EventArgs e)
{
frm1.frm2.Show();
this.Hide();
}
}

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

Projeyi İNDİR

Rica: Sitemizin Google'da Ön Sıralarda Çıkması İçin Lütfen Alttaki Google+ Butonuna Tıklayınız , Sayfamızı Facebookta Beğeniniz veya yazıları Twitter,Facebookta paylaşınız.