private void AramaMusteriAdi_TextChanged(object sender, EventArgs e)
{
if (AramaMusteriAdi.Text.Length > 0)
{
string adsoyad2 = fk.IlkHarfleriBuyut(AramaMusteriAdi.Text);
FbConnection baglanti = new FbConnection(fk.Baglanti_Kodu());
FbDataReader MusteriOku; object sonuc;
baglanti.Open();
FbCommand MusteriAraSorgu = new FbCommand("SELECT * FROM Musteriler WHERE Musteri_adi like '%" + AramaMusteriAdi.Text + "%' or Musteri_soyadi like '%" + AramaMusteriAdi.Text + "%' or Musteri_adi like '%" + adsoyad2 + "%' or Musteri_soyadi like '%" + adsoyad2 + "%'", baglanti);
sonuc = MusteriAraSorgu.ExecuteScalar();
Musteri_adi_combo.Items.Clear();
if (sonuc != null)
{
MusteriOku = MusteriAraSorgu.ExecuteReader();
while (MusteriOku.Read())
{
Musteri_adi_combo.Items.Add(MusteriOku["Musteri_adi"].ToString() + " " + MusteriOku["Musteri_soyadi"].ToString());
}
Musteri_adi_combo.SelectedIndex = 0;
Musteri_adi_combo.Enabled = true;
MusteriBilgiGrup.Enabled = true;
}
else
{
MessageBox.Show("Aranan isme / soyisme göre müşteri bulunamadı.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
baglanti.Close();
}
else
{
Musteri_adi_combo.SelectedIndex = -1;
Musteri_adi_combo.Enabled = false;
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
try
{
if (textBox1.Text != "")
{
FbConnection baglanti = new FbConnection(fk.Baglanti_Kodu());
FbDataReader MusteriOku; object sonuc;
string adsD = fk.IlkHarfleriBuyut(textBox1.Text);
baglanti.Open();
FbCommand MusteriAraSorgu = new FbCommand("SELECT * FROM Musteriler WHERE Musteri_adi like '%" + textBox1.Text + "%' or Musteri_soyadi like '%" + textBox1.Text + "%' or Musteri_adi like '%" + adsD + "%' or Musteri_soyadi like '%" + adsD + "%'", baglanti);
sonuc = MusteriAraSorgu.ExecuteScalar();
SatisMusteriCb.Items.Clear();
if (sonuc != null)
{
MusteriOku = MusteriAraSorgu.ExecuteReader();
while (MusteriOku.Read())
{
SatisMusteriCb.Items.Add(MusteriOku["Musteri_adi"].ToString() + " " + MusteriOku["Musteri_soyadi"].ToString());
}
SatisMusteriCb.SelectedIndex = 0;
}
else
{
MessageBox.Show("Aranan isme / soyisme göre müşteri bulunamadı.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Warning);
textBox1.Text = "";
FbConnection baglan = new FbConnection(fk.Baglanti_Kodu());
baglan.Open();
FbCommand MustList = new FbCommand("SELECT * FROM Musteriler", baglan);
object sonuc1 = MustList.ExecuteScalar();
if (sonuc1 != null)
{
FbDataReader oku = MustList.ExecuteReader();
SatisMusteriCb.Enabled = true;
checkBox3.Enabled = true;
while (oku.Read())
{
SatisMusteriCb.Items.Add(oku["Musteri_adi"].ToString() + " " + oku["Musteri_soyadi"].ToString());
}
SatisMusteriCb.SelectedIndex = 0;
}
else
{
SatisMusteriCb.Enabled = false;
checkBox3.Enabled = false;
MessageBox.Show("Kayıtlı müşteri bulunmamaktadır.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
baglan.Close();
}
baglanti.Close();
}
}
catch (Exception e12)
{
MessageBox.Show(e12.Message, "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void musteriarama_TextChanged(object sender, EventArgs e)
{
FbConnection baglan = new FbConnection(fk.Baglanti_Kodu());
if (musteriarama.Text.Length > 0)
{
musteriarama.Text = musteriarama.Text.Replace("'", "’");
FbConnection baglanti = new FbConnection(fk.Baglanti_Kodu());
FbDataReader MusteriOku; object sonuc;
baglanti.Open();
FbCommand MusteriAraSorgu = new FbCommand("SELECT * FROM Musteriler WHERE Musteri_adi like '%" + musteriarama.Text + "%' or Musteri_soyadi like '%" + musteriarama.Text + "%'", baglanti);
sonuc = MusteriAraSorgu.ExecuteScalar();
musteri.Items.Clear();
if (sonuc != null)
{
MusteriOku = MusteriAraSorgu.ExecuteReader();
while (MusteriOku.Read())
{
musteri.Items.Add(MusteriOku["Musteri_adi"].ToString() + " " + MusteriOku["Musteri_soyadi"].ToString());
}
musteri.SelectedIndex = 0;
}
else
{
MessageBox.Show("Aranan isme / soyisme göre müşteri bulunamadı.", "Bilgilendirme", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
baglanti.Close();
}
else
{
MessageBox.Show("İsim veya Soyisim girin ( Hata kodu: M-06 )", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error);
musteri.Items.Clear();
baglan.Open();
FbCommand MusSql = new FbCommand("SELECT Musteri_adi,Musteri_soyadi FROM Musteriler", baglan);
object musSS = MusSql.ExecuteScalar();
if (musSS != null)
{
FbDataReader MusOku = MusSql.ExecuteReader();
while (MusOku.Read())
{
musteri.Items.Add(MusOku["Musteri_adi"].ToString() + " " + MusOku["Musteri_soyadi"].ToString());
}
musteri.SelectedIndex = 0;
}
else
{
DialogResult MusEkle = MessageBox.Show("Sistemde müşteri bulunmamaktadır, yeni müşteri eklemek ister misiniz?", "Bilgilendirme", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (MusEkle == DialogResult.Yes)
{
MusteriEkle me = new MusteriEkle();
me.ShowDialog();
}
}
baglan.Close();
}
}
