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(); } }