//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();
}
}
}
