//delete alarm attendance public void deleteAlarmAttendance(string alarmName, string userName) { using (var db = new HealthModelsDataContext()) { Alarm alarm = db.Alarms.SingleOrDefault(targetAlarm => targetAlarm.name.Equals(alarmName)); User user = db.Users.SingleOrDefault(targetUser => targetUser.userName.Equals(userName)); if (alarm != null && user != null) { AlarmAttendance alarmAttendace = db.AlarmAttendances.SingleOrDefault(attendance => attendance.alarmId == alarm.id && attendance.userId == user.id); if (alarmAttendace != null) { db.AlarmAttendances.DeleteOnSubmit(alarmAttendace); db.SubmitChanges(); } } } }
//create alarm attendance public void createAlarmAttendance(string alarmName, string userName) { using (var db = new HealthModelsDataContext()) { Alarm alarm = db.Alarms.SingleOrDefault(targetAlarm => targetAlarm.name.Equals(alarmName)); User user = db.Users.SingleOrDefault(targetUser => targetUser.userName.Equals(userName)); if (alarm != null && user != null) { var alarmAttendace = new AlarmAttendance(); alarmAttendace.userId = user.id; alarmAttendace.alarmId = alarm.id; db.AlarmAttendances.InsertOnSubmit(alarmAttendace); db.SubmitChanges(); } } }