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