private void btnRandevuSil_Click(object sender, EventArgs e) { int rndID = 0; if (DataGrid.SelectedRows.Count > 0) { rndID = (int)DataGrid.SelectedRows[0].Cells[0].Value; } using (MeetingDBEntities db = new MeetingDBEntities()) { Randevular rnd = db.Randevulars.Find(rndID); db.Randevulars.Remove(rnd); db.SaveChanges(); } gridDoldur(); }
private void gridDoldur() { using (MeetingDBEntities db = new MeetingDBEntities()) { var sonuc = from randevu in db.Randevulars select new { randevu.ID, randevu.ToplantiKonusu, randevu.Tarih, randevu.BaslangicSaati, randevu.BitisSaati, randevu.Katilimcilar }; DataGrid.DataSource = sonuc.ToList(); DataGrid.SelectedRows[0].Selected = true; } }
private void btnRandevuGuncelle_Click(object sender, EventArgs e) { int rndID = 0; if (DataGrid.SelectedRows.Count > 0) { rndID = (int)DataGrid.SelectedRows[0].Cells[0].Value; } using (MeetingDBEntities db = new MeetingDBEntities()) { Randevular rnd = db.Randevulars.Find(rndID); rnd.ToplantiKonusu = txtToplantiKonusu.Text; rnd.Tarih = dateTimePicker1.Value.ToShortDateString(); rnd.BaslangicSaati = txtBaslangicSaati.Text; rnd.BitisSaati = txtBitisSaati.Text; rnd.Katilimcilar = txtKatilimcilar.Text; db.SaveChanges(); } gridDoldur(); }
private void btnRandevuKayit_Click(object sender, EventArgs e) { if (DateTime.Now < dateTimePicker1.Value) { using (MeetingDBEntities db = new MeetingDBEntities()) { Randevular rnd = new Randevular(); rnd.ToplantiKonusu = txtToplantiKonusu.Text; rnd.Tarih = dateTimePicker1.Value.ToShortDateString(); rnd.BaslangicSaati = txtBaslangicSaati.Text; rnd.BitisSaati = txtBitisSaati.Text; rnd.Katilimcilar = txtKatilimcilar.Text; db.Randevulars.Add(rnd); db.SaveChanges(); } } else { MessageBox.Show("Geçmiş Tarihe Randevu Alınamaz !"); } gridDoldur(); }