private void frmIndex_Load(object sender, EventArgs e)
{
connection = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\OtelDB.mdf;Integrated Security=True;Connect Timeout=30";
SqlConnection bag = new SqlConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SqlCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Otel o = new Otel();
o.Ad = dr["otelismi"].ToString();
o.Il = dr["sehir"].ToString();
o.Ilce = dr["ilce"].ToString();
o.Adres = dr["adres"].ToString();
o.Telefon = dr["telefon"].ToString();
o.EPosta = dr["eposta"].ToString();
o.OdaSayisi = dr["odasayisi"].ToString();
agac.IsmeGoreOtelEkle(o);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
try
{
string komut = @"SELECT * FROM personel";
cmd = new SqlCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Personel pe = new Personel();
pe.TC = dr["tc"].ToString();
pe.Ad = dr["ad"].ToString();
pe.Soyad = dr["soyad"].ToString();
pe.Telefon = dr["telefon"].ToString();
pe.Adres = dr["adres"].ToString();
pe.EPosta = dr["eposta"].ToString();
//pe.Departman = Int32.Parse(dr["departman"].ToString());
//pe.Pozisyon = cmbPozisyon.Text;
//personel puan eklenecek
list.PersonelEkle(pe);
//otel id'si ve personel id'si aynı olmalı bu id'ye göre personel listesi otele eklenmeli.
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
private void frmIndex_Load(object sender, EventArgs e)
{
connection = @"Data Source =C:\Users\merve_l7t2av4\Desktop\veriYapilari\Yeni klasör\otel.db;version=3";
SQLiteConnection bag = new SQLiteConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SQLiteCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Otel o = new Otel();
o.Ad = dr["otelismi"].ToString();
o.Il = dr["sehir"].ToString();
o.Ilce = dr["ilce"].ToString();
o.Adres = dr["adres"].ToString();
o.Telefon = dr["telefon"].ToString();
o.EPosta = dr["eposta"].ToString();
o.OdaSayisi = dr["odasayisi"].ToString();
agac.IsmeGoreOtelEkle(o);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
try
{
string komut = @"SELECT * FROM personel";
cmd = new SQLiteCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
Personel pe = new Personel();
pe.TC = dr["tc"].ToString();
pe.Ad = dr["ad"].ToString();
pe.Soyad = dr["soyad"].ToString();
pe.Telefon = dr["telefon"].ToString();
pe.Adres = dr["adres"].ToString();
pe.EPosta = dr["eposta"].ToString();
//pe.Departman = Int32.Parse(dr["departman"].ToString());
//pe.Pozisyon = cmbPozisyon.Text;
//personel puan eklenecek
list.PersonelEkle(pe);
//otel id'si ve personel id'si aynı olmalı bu id'ye göre personel listesi otele eklenmeli.
}
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
private void btnGoster_Click(object sender, EventArgs e)
{
connection = @"Data Source =C:\Users\merve_l7t2av4\Desktop\Yeni klasör\otel.db;version=3";
SQLiteConnection bag = new SQLiteConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SQLiteCommand(komut, bag);
dr = cmd.ExecuteReader();
aramaAgaci = new IkiliAramaAgaci();
while (dr.Read())
{
Otel ot = new Otel();
ot.Ad = dr["otelismi"].ToString();
aramaAgaci.IsmeGoreOtelEkle(ot);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
switch (cmbAgacDuzeyi.SelectedIndex)
{
case 0:
aramaAgaci.PreOrder();
break;
case 1:
aramaAgaci.InOrder();
break;
case 2:
aramaAgaci.PostOrder();
break;
default:
break;
}
MessageBox.Show(aramaAgaci.DugumleriYazdir().ToString());
}
private void frmOtelGoruntule_Load(object sender, EventArgs e)
{
connection = @"Data Source =C:\Users\merve_l7t2av4\Desktop\veriYapilari\Yeni klasör\otel.db;version=3";
SQLiteConnection bag = new SQLiteConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SQLiteCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
aramaAgaci = new IkiliAramaAgaci();
Otel ot = new Otel();
ot.Ad = dr["otelismi"].ToString();
aramaAgaci.IsmeGoreOtelEkle(ot);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
}
private void frmOtelGoruntule_Load(object sender, EventArgs e)
{
connection = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\OtelDB.mdf;Integrated Security=True;Connect Timeout=30";
SqlConnection bag = new SqlConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SqlCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
aramaAgaci = new IkiliAramaAgaci();
Otel ot = new Otel();
ot.Ad = dr["otelismi"].ToString();
aramaAgaci.IsmeGoreOtelEkle(ot);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
}
