private void btnPersonelSil_Click(object sender, EventArgs e) { int id = int.Parse(dataGridPersonel.SelectedRows[0].Cells[0].Value.ToString()); silinecekPersonel = db.Personels.Where(x => x.Personelid == id).FirstOrDefault(); if (db.Siparislers.Any(x => x.Personel_id == silinecekPersonel.Personelid)) { MessageBox.Show("İşlem yapılan Personel silinemez", "DİKKAT"); return; } else if (MessageBox.Show($"{silinecekPersonel.Adi.Trim()} adlı personel silinsin mi?", "Dikkat", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { db.Personels.Remove(silinecekPersonel); db.SaveChanges(); MessageBox.Show($"{silinecekPersonel.Adi.Trim()} adlı personel silindi"); var q = from prsnl in db.Personels join dprtmn in db.Departmen on prsnl.Departman_id equals dprtmn.Departmanid join durum in db.AktifPasifDurums on prsnl.Durum_id equals durum.Durumid select new { prsnl.Personelid, prsnl.Adi, prsnl.Soyadi, dprtmn.DepartmanAdi, prsnl.DogumTarihi, prsnl.DogumYeri, prsnl.TcNo, prsnl.TelefonNo, prsnl.KullaniciAdi, prsnl.Password, prsnl.Adres, durum.DurumAdi }; dataGridPersonel.DataSource = q.ToList(); } }
private void cmbPersonelSec_SelectedIndexChanged_1(object sender, EventArgs e) { secilenPersonel = cmbPersonelSec.SelectedItem as Personel; }
private void cmbPersonelSiparis_SelectedIndexChanged(object sender, EventArgs e) { seciliPersonel = cmbPersonelSiparis.SelectedItem as Personel; }