private void btnListele_Click(object sender, EventArgs e) { if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_ServisTakip", yeniBaglanti.baglanti); Listele(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "MarkaModel,ReferansNo,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "IlgiliDepartmanKisi,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "Aciklama,"; } else { degisken3 = ""; } if (checkBox4.Checked == true) { degisken4 = "Onarim, Ilgilifirma,"; } else { degisken4 = ""; } if (checkBox5.Checked == true) { degisken5 = "GonderilisTarihi, AlinisTarihi, Sonuc"; } else { degisken5 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + degisken4 + degisken5 + " from Tbl_ServisTakip", yeniBaglanti.baglanti); Listele(); } }
private void btnListele_Click(object sender, EventArgs e) { if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_SatinAlmalar", yeniBaglanti.baglanti); Listele(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "Isim,Soyisim,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "Isletme,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "Departman,"; } else { degisken3 = ""; } if (checkBox4.Checked == true) { degisken4 = "Istek,"; } else { degisken4 = ""; } if (checkBox5.Checked == true) { degisken5 = "IstekTarihi,KullaniciyaTeslimTarihi,Rapor"; } else { degisken5 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + degisken4 + degisken5 + " from Tbl_SatinAlmalar", yeniBaglanti.baglanti); Listele(); } }
private void frmAnaEkran_Load(object sender, EventArgs e) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_AdminHatirlatmalar", yeniBaglanti.baglanti); Listele(); }
private void btnListeleme_Click(object sender, EventArgs e) { if (rbTumListe.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from tbl_kullanicilar", yeniBaglanti.baglanti); Listele(); } if (rbSecili.Checked == true) { if (cbKullaniciAdi.Checked == true) { secim_kullaniciAdi = "KullaniciAdi,"; } else { secim_kullaniciAdi = ""; } if (cbAd.Checked == true) { secim_adi = "Ad,"; } else { secim_adi = ""; } if (cbSoyad.Checked == true) { secim_soyadi = "Soyad,"; } else { secim_soyadi = ""; } if (cbBirimId.Checked == true) { secim_birimId = "BirimID"; } else { secim_birimId = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + secim_kullaniciAdi + secim_adi + secim_soyadi + secim_birimId + " from tbl_kullanicilar", yeniBaglanti.baglanti); Listele(); } }
private void frmDemirbasKablosuzWifiEkipmanlari_Load(object sender, EventArgs e) { ListeyiAktifEt(); VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasKablosuzWifiEkipmanlari", yeniBaglanti.baglanti); Listele(); checkBox1.Enabled = false; checkBox2.Enabled = false; }
private void KullaniciListeleme_Load(object sender, EventArgs e) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from tbl_kullanicilar", yeniBaglanti.baglanti); Listele(); cbKullaniciAdi.Enabled = false; cbAd.Enabled = false; cbSoyad.Enabled = false; cbBirimId.Enabled = false; }
private void frmServisTakipListelemeVeGuncelleme_Load(object sender, EventArgs e) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_ServisTakip", yeniBaglanti.baglanti); Listele(); checkBox1.Enabled = false; checkBox2.Enabled = false; checkBox3.Enabled = false; checkBox4.Enabled = false; checkBox5.Enabled = false; }
private void frmSatinAlmaListelemeVeRaporlama_Load(object sender, EventArgs e) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_SatinAlmalar", yeniBaglanti.baglanti); Listele(); checkBox1.Enabled = false; checkBox2.Enabled = false; checkBox3.Enabled = false; checkBox4.Enabled = false; checkBox5.Enabled = false; }
private void frmMalzemeElektronikAtikSirketineTeslimEdilecekler_Load(object sender, EventArgs e) { ListeyiAktifEt(); VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_MalzemeElektronikAtikSirketineTeslimEdilecekler", yeniBaglanti.baglanti); Listele(); checkBox1.Enabled = false; checkBox2.Enabled = false; checkBox3.Enabled = false; }
public void Listele() { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); SqlCommand sorgu = new SqlCommand("Select * from Tbl_SatinAlmalar", yeniBaglanti.baglanti); DataTable dataTable = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(sorgu); adapter.Fill(dataTable); BindingSource bindingSource = new BindingSource(); bindingSource.DataSource = dataTable; dataGridView1.DataSource = bindingSource; }
private void frmDemirbasScanner_Load(object sender, EventArgs e) { ListeyiAktifEt(); VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasScanner", yeniBaglanti.baglanti); Listele(); checkBox1.Enabled = false; checkBox2.Enabled = false; checkBox3.Enabled = false; checkBox4.Enabled = false; checkBox5.Enabled = false; }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasSwitch", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "BulunduguYer,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "Marka,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "Aciklama, EkBilgi"; } else { degisken3 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + " from Tbl_DemirbasSwitch", yeniBaglanti.baglanti); ListeleIki(); } }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_MalzemeElektronikAtikSirketineTeslimEdilecekler", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "KullaniciAdi, MarkaModel,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "ReferansNo, SistemSeriNo,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "Aciklama, Durumu"; } else { degisken3 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + " from Tbl_MalzemeElektronikAtikSirketineTeslimEdilecekler", yeniBaglanti.baglanti); ListeleIki(); } }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasKablosuzWifiEkipmanlari", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "CihazAdi,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "Aciklama"; } else { degisken2 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + " from Tbl_DemirbasKablosuzWifiEkipmanlari", yeniBaglanti.baglanti); ListeleIki(); } }
public TblServisTakipDAO() { baglanti = new VeriTabaniBaglantisi(); }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasCtos", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "Departman,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "Marka, Model,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "Islemci, Bellek,"; } else { degisken3 = ""; } if (checkBox4.Checked == true) { degisken4 = "Disc,"; } else { degisken4 = ""; } if (checkBox5.Checked == true) { degisken5 = "SistemReferans, EkranReferans"; } else { degisken5 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + degisken4 + degisken5 + " from Tbl_DemirbasCtos", yeniBaglanti.baglanti); ListeleIki(); } }
public TblKullaniciGirisiDAO() { baglanti = new VeriTabaniBaglantisi(); }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasYazici", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "Departman, Ip, Kullanici,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "Model, Tip,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "Siyah, Renkli, Mavi, Sari, Kirmizi,"; } else { degisken3 = ""; } if (checkBox4.Checked == true) { degisken4 = "SeriNo,"; } else { degisken4 = ""; } if (checkBox5.Checked == true) { degisken5 = "Aciklama"; } else { degisken5 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + degisken4 + degisken5 + " from Tbl_DemirbasYazici", yeniBaglanti.baglanti); ListeleIki(); } }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasScanner", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "Model,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "Tip,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "ReferansNo,"; } else { degisken3 = ""; } if (checkBox4.Checked == true) { degisken4 = "YeniScannerVerilisTarihi,"; } else { degisken4 = ""; } if (checkBox5.Checked == true) { degisken5 = "Departman, Kullanici"; } else { degisken5 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + degisken4 + degisken5 + " from Tbl_DemirbasScanner", yeniBaglanti.baglanti); ListeleIki(); } }
public TblDemirbasSwitchDAO() { baglanti = new VeriTabaniBaglantisi(); }
public TblMalzemeYaziciDAO() { baglanti = new VeriTabaniBaglantisi(); }
public TblSatinAlmalarDAO() { baglanti = new VeriTabaniBaglantisi(); }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_DemirbasServer", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "Departman,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "ServerAdi, Ip,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "Marka, Model,"; } else { degisken3 = ""; } if (checkBox4.Checked == true) { degisken4 = "Cpu, Memory, Disc, AygitCdRw,"; } else { degisken4 = ""; } if (checkBox5.Checked == true) { degisken5 = "SistemReferansNo, EkranReferans, SistemYazilimi"; } else { degisken5 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + degisken4 + degisken5 + " from Tbl_DemirbasServer", yeniBaglanti.baglanti); ListeleIki(); } }
public TblDemirbasCtosDAO() { baglanti = new VeriTabaniBaglantisi(); }
public TblDemirbasBilgisayarDAO() { baglanti = new VeriTabaniBaglantisi(); }
public TblMalzemeBilgisayarDAO() { baglanti = new VeriTabaniBaglantisi(); }
public TblMalzemeElektronikAtikSirketineTeslimEdileceklerDAO() { baglanti = new VeriTabaniBaglantisi(); }
public TblDemirbasServerDAO() { baglanti = new VeriTabaniBaglantisi(); }
public TblMalzemeMonitorDAO() { baglanti = new VeriTabaniBaglantisi(); }
private void btnListele_Click(object sender, EventArgs e) { ListeyiPasifYap(); if (radioButton1.Checked == true) { VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select * from Tbl_MalzemeMonitor", yeniBaglanti.baglanti); ListeleIki(); } if (radioButton2.Checked == true) { if (checkBox1.Checked == true) { degisken1 = "KullaniciAdi,"; } else { degisken1 = ""; } if (checkBox2.Checked == true) { degisken2 = "MarkaModel,"; } else { degisken2 = ""; } if (checkBox3.Checked == true) { degisken3 = "ReferansNo,"; } else { degisken3 = ""; } if (checkBox4.Checked == true) { degisken4 = "Aciklama,"; } else { degisken4 = ""; } if (checkBox5.Checked == true) { degisken5 = "MonitorDurumu"; } else { degisken5 = ""; } VeriTabaniBaglantisi yeniBaglanti = new VeriTabaniBaglantisi(); sorgu = new SqlCommand("Select " + degisken1 + degisken2 + degisken3 + degisken4 + degisken5 + " from Tbl_MalzemeMonitor", yeniBaglanti.baglanti); ListeleIki(); } }