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