Online Bilet Satış Programı C#

FORM1 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
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 Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;

public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
}

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 int satir;
public Boolean durum = false;

public void otobüslistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From otobüsbil", bag);
adtr.Fill(dtst, "otobüsbil");
dataGridView2.DataSource = dtst.Tables["otobüsbil"];
adtr.Dispose();
bag.Close();
}
public void otobüslistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From otobüsbil", bag);
adtr.Fill(dtst, "otobüsbil");
frm4.dataGridView1.DataSource = dtst.Tables["otobüsbil"];
adtr.Dispose();
bag.Close();
}
public void yolculistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From yolcubil ", bag);
adtr.Fill(dtst, "yolcubil");
dataGridView1.DataSource = dtst.Tables["yolcubil"];
adtr.Dispose();
bag.Close();
}
public void yolculistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From yolcubil ", bag);
adtr.Fill(dtst, "yolcubil");
frm5.dataGridView1.DataSource = dtst.Tables["yolcubil"];
adtr.Dispose();
bag.Close();
}

public void otobüscombo()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Sefer_No,Kalkis_Saati,Varis_Saati from otobüsbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
durum = frm2.comboBox1.FindString(oku[0].ToString());
if (durum == -1) frm2.comboBox1.Items.Add(oku[0].ToString());
durum = frm2.comboBox2.FindString(oku[1].ToString());
if (durum == -1) frm2.comboBox2.Items.Add(oku[1].ToString());
durum = frm2.comboBox3.FindString(oku[2].ToString());
if (durum == -1) frm2.comboBox3.Items.Add(oku[2].ToString());

}
bag.Close();
oku.Dispose();
}
public void yolcucombo()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Koltuk_No,Ad,Soyad from yolcubil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
durum = frm3.comboBox1.FindString(oku[0].ToString());
if (durum == -1) frm3.comboBox1.Items.Add(oku[0].ToString());
durum = frm3.comboBox2.FindString(oku[1].ToString());
if (durum == -1) frm3.comboBox2.Items.Add(oku[1].ToString());
durum = frm3.comboBox3.FindString(oku[2].ToString());
if (durum == -1) frm3.comboBox3.Items.Add(oku[2].ToString());
}
bag.Close();
oku.Dispose();
}

public void seferkontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Sefer_No from otobüsbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{

if (frm2.comboBox1.Text == oku[0].ToString()) durum = true;

}
bag.Close();
oku.Dispose();
}
public void koltukkontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Koltuk_No from yolcubil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{

if (frm3.textBox1.Text == oku[0].ToString()) durum = true;

}
bag.Close();
oku.Dispose();
}

private void Form1_Load(object sender, EventArgs e)
{
label13.Text = string.Format("Saat {0:hh : mm}",DateTime.Now);
label12.Text = string.Format("{0:dd MMMM yyy dddd}", DateTime.Now);
label5.Text = dateTimePicker1.Text;
otobüslistele();
yolculistele();
dataGridView2.Columns[0].HeaderText = "Sefer No";
dataGridView2.Columns[1].HeaderText = "Sefer Güzergah";
dataGridView2.Columns[2].HeaderText = "Kalkış Saati";
dataGridView2.Columns[3].HeaderText = "Varış Saati";
dataGridView2.Columns[4].HeaderText = "Otobüs Tipi";
dataGridView2.Columns[5].HeaderText = "Liste Fiyatı";
dataGridView2.Columns[6].HeaderText = "İnternet Fiyatı";

dataGridView1.Columns[0].HeaderText = "Koltuk No";
dataGridView1.Columns[1].HeaderText = "Cinsiyet";
dataGridView1.Columns[2].HeaderText = "Ad";
dataGridView1.Columns[3].HeaderText = "Soyad";
dataGridView1.Columns[4].HeaderText = "Telefon";
dataGridView1.Columns[5].HeaderText = "E-Mail";
dataGridView1.Columns[6].HeaderText = "Adres";

}
private void button1_Click(object sender, EventArgs e)
{
Application.Exit();
}

private void button2_Click(object sender, EventArgs e)
{
frm2.ShowDialog();
}

private void button3_Click(object sender, EventArgs e)
{
frm3.ShowDialog();
}

private void button4_Click(object sender, EventArgs e)
{
frm4.ShowDialog();
}

private void button5_Click(object sender, EventArgs e)
{
frm5.ShowDialog();
}

private void textBox3_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From otobüsbil", bag);
if (textBox3.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from otobüsbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "otobüsbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From otobüsbil" +
" where(Sefer_No like ‘%" + textBox3.Text + "%’ )";
dtst.Tables["otobüsbil"].Clear();
adtr.Fill(dtst, "otobüsbil");
bag.Close();
}

private void textBox4_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From otobüsbil", bag);
if (textBox4.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from otobüsbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "otobüsbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From otobüsbil" +
" where(Otobüs_Tipi like ‘%" + textBox4.Text + "%’ )";
dtst.Tables["otobüsbil"].Clear();
adtr.Fill(dtst, "otobüsbil");
bag.Close();
}

private void textBox5_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From yolcubil", bag);
if (textBox5.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from yolcubil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "yolcubil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From yolcubil" +
" where(Koltuk_No like ‘%" + textBox5.Text + "%’ )";
dtst.Tables["yolcubil"].Clear();
adtr.Fill(dtst, "yolcubil");
bag.Close();
}

private void textBox6_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From yolcubil", bag);
if (textBox6.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from yolcubil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "yolcubil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From yolcubil" +
" where(Ad like ‘%" + textBox6.Text + "%’ )";
dtst.Tables["yolcubil"].Clear();
adtr.Fill(dtst, "yolcubil");
bag.Close();
}

}
}

[/code]

FORM2 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}

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

private void Form2_Load(object sender, EventArgs e)
{
frm1.otobüscombo();
}

private void button1_Click(object sender, EventArgs e)
{
frm1.seferkontrol();
if (frm1.durum == false)
{
if (comboBox1.Text != "" &amp;&amp; textBox2.Text != "" &amp;&amp; comboBox2.Text != "" &amp;&amp; comboBox3.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO otobüsbil(Sefer_No,Sefer_Güz,Kalkis_Saati,Varis_Saati,Otobüs_Tipi,Liste_Fiyati,İnternet_Fiyati) VALUES (‘" + comboBox1.Text + "’,’" + textBox2.Text + "’,’" + comboBox2.Text + "’,’" + comboBox3.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();

for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["otobüsbil"].Clear();
frm1.otobüslistele();
frm1.otobüscombo();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
else MessageBox.Show("Girmiş olduğunuz Sefer No kullanılmış");
}
}
[/code]

FORM3 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}

private void Form3_Load(object sender, EventArgs e)
{
frm1.yolcucombo();
}

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

private void button1_Click(object sender, EventArgs e)
{
frm1.koltukkontrol();
if (frm1.durum == false)
{
if (comboBox1.Text != "" &amp;&amp; comboBox2.Text != "" &amp;&amp;comboBox3.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO yolcubil(Koltuk_No,Cinsiyet,Ad,Soyad,Telefon,E_Mail,Adres) VALUES (‘" + comboBox1.Text + "’,’" + textBox1.Text + "’,’" + comboBox2.Text + "’,’" + comboBox3.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["yolcubil"].Clear();
frm1.yolcucombo();
frm1.yolculistele();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
else MessageBox.Show("Kayıtlı Koltuk No Girdiniz !");

}
}
[/code]

FORM4 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form4 : Form
{
public Form1 frm1;
public Form4()
{
InitializeComponent();
}

private void Form4_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["otobüsbil"].Clear();
frm1.otobüslistele2();

}

private void button2_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["otobüsbil"].Clear();
frm1.otobüslistele();
this.Close();
}

private void button1_Click(object sender, EventArgs e)
{
string silinecek;
try
{
int row = 0;
for (row = 0; row <= dataGridView1.Rows.Count; row++)
{

if (dataGridView1.Rows[row].Cells[0].Selected == true || dataGridView1.Rows[row].Cells[1].Selected == true || dataGridView1.Rows[row].Cells[2].Selected == true || dataGridView1.Rows[row].Cells[3].Selected == true || dataGridView1.Rows[row].Cells[4].Selected == true || dataGridView1.Rows[row].Cells[5].Selected == true || dataGridView1.Rows[row].Cells[6].Selected == true)
{
break;

}
}
silinecek = dataGridView1.Rows[row].Cells[0].Value.ToString();

DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from otobüsbil WHERE Sefer_No=’" + silinecek + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["otobüsbil"].Clear();
frm1.otobüslistele2();
}
}
catch
{ ;}
}
}
[/code]

FORM5 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form5 : Form
{
public Form1 frm1;
public Form5()
{
InitializeComponent();
}

private void Form5_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["yolcubil"].Clear();
frm1.yolculistele2();
}

private void button2_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["yolcubil"].Clear();
frm1.yolculistele();
this.Close();
}