//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();
                }
            }
        }
		private void detach_AlarmAttendances(AlarmAttendance entity)
		{
			this.SendPropertyChanging();
			entity.Alarm = null;
		}
		private void attach_AlarmAttendances(AlarmAttendance entity)
		{
			this.SendPropertyChanging();
			entity.User = this;
		}
 partial void DeleteAlarmAttendance(AlarmAttendance instance);
 partial void UpdateAlarmAttendance(AlarmAttendance instance);
 partial void InsertAlarmAttendance(AlarmAttendance instance);