private void btn_Sil_Click(object sender, EventArgs e)
{
PersonelManager pm = new PersonelManager();
Personel.id = Convert.ToInt16(tb_Id.Text);
pm.Sil();
tbl_personelTableAdapter.Fill(this.personelVeriTabaniDataSet1.tbl_personel);
}
private void Istatistik_Load(object sender, EventArgs e)
{
PersonelManager pm = new PersonelManager();
lbl_Top.Text = pm.KisiSay().ToString();
lbl_Evli.Text = pm.EvliPersonel().ToString();
lbl_Bekar.Text = pm.BekarPersonel().ToString();
lbl_Sehir.Text = pm.FarkıSehirSayisi().ToString();
lbl_TopMaas.Text = pm.TopMaas().ToString();
lbl_OrtMaas.Text = pm.OrtMaas().ToString();
}
private void Form1_Load(object sender, EventArgs e)
{
PersonelManager pm = new PersonelManager();
tbl_personelTableAdapter.Fill(this.personelVeriTabaniDataSet1.tbl_personel);
List <string> iller = new List <string>();
iller = pm.İllerBas();
foreach (string i in iller)
{
cb_Sehir.Items.Add(i);
}
}
private void btn_Kaydet_Click(object sender, EventArgs e)
{
PersonelManager pm = new PersonelManager();
Personel.id = Convert.ToInt16(tb_Id.Text);
Personel.ad = tb_Ad.Text;
Personel.soyad = tb_Soyad.Text;
Personel.sehir = cb_Sehir.Text;
Personel.maas = Convert.ToDecimal(tb_Maas.Text);
if (rb_Evli.Checked)
{
Personel.durum = true;
}
else
{
Personel.durum = false;
}
Personel.meslek = tb_Meslek.Text;
pm.Kaydet();
}
private void btn_Güncelle_Click(object sender, EventArgs e)
{
PersonelManager pm = new PersonelManager();
Personel.id = Convert.ToInt16(tb_Id.Text);
Personel.ad = tb_Ad.Text;
Personel.soyad = tb_Soyad.Text;
Personel.sehir = cb_Sehir.Text;
Personel.meslek = tb_Meslek.Text;
Personel.maas = Convert.ToInt32(tb_Maas.Text);
if (rb_Evli.Checked == true)
{
Personel.durum = true;
}
else
{
Personel.durum = false;
}
pm.Guncelle();
}