private void btnAEDel_Click(object sender, RoutedEventArgs e) { ExceptionAttendance ae = (ExceptionAttendance)dataGridExcepHolidays.SelectedItem; MEAPSDbEntities context = new MEAPSDbEntities(); ExceptionAttendance deletable = context.ExceptionAttendances.SingleOrDefault(x => ((x.EmpId == ae.EmpId) && (x.Date == ae.Date))); context.ExceptionAttendances.Remove(deletable); context.SaveChanges(); RefreshDataGrids(); }
private void btnAEAdd_Click(object sender, RoutedEventArgs e) { MEAPSDbEntities context = new MEAPSDbEntities(); ExceptionAttendance ae = new ExceptionAttendance(); ComboBoxItem EmpId = (ComboBoxItem)cbAEEmp.SelectedItem; ae.EmpId = Convert.ToInt32(EmpId.Content); ae.Date = Convert.ToDateTime(dtAEDate.Text); ae.Remarks = txtAERemarks.Text; context.ExceptionAttendances.Add(ae); context.SaveChanges(); RefreshDataGrids(); }