void personelListe()
{
personelService = new PersonelServis();
var sonuc = personelService.personelListesi("select*from Personel");
dgvPersonelListe.DataSource = sonuc;
cmbPersonel.DataSource = sonuc;
cmbPersonel.ValueMember = "Id";
cmbPersonel.DisplayMember = "Ad";
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
if (dgvPersonelListe.SelectedRows.Count != 0)
{
var tarih = Convert.ToDateTime(dtpTarih.Text);
var item = (PersonelDTO)dgvPersonelListe.SelectedRows[0].DataBoundItem;
personelService = new PersonelServis();
personelService.Update("update Personel set Adi='" + txtAd.Text + "',Soyadi='" + txtSoyad.Text + "',KayitTarihi='" + tarih.ToString("yyyy-MM-dd") + "' where id='" + item.Id + "'");
personelListe();
}
}
private void btnSil_Click(object sender, EventArgs e)
{
try
{
var item = (PersonelDTO)dgvPersonelListe.SelectedRows[0].DataBoundItem;
personelService = new PersonelServis();
personelService.Delete("delete from Personel where Id=" + item.Id + "");
MessageBox.Show("Silindi!");
}
catch
{
}
personelListe();
}
private void btnKaydet_Click(object sender, EventArgs e)
{
try
{
personelService = new PersonelServis();
string ad = txtAd.Text;
string soyad = txtSoyad.Text;
DateTime tarih = DateTime.Parse(dtpTarih.Text);
personelService.insert("insert into Personel (Adi,Soyadi,KayitTarihi) values ('" + ad + "','" + soyad + "','" + tarih.ToString("yyyy-MM-dd") + "')");
personelListe();
MessageBox.Show("Eklendi");
}
catch
{
}
}
