//delete
public void deleteAlarmCount(int alarmId)
{
using (var db = new HealthModelsDataContext())
{
AlarmCount alarmCount = db.AlarmCounts.SingleOrDefault(targetAlarmCount => targetAlarmCount.alarmId == alarmId);
if (alarmCount != null)
{
db.AlarmCounts.DeleteOnSubmit(alarmCount);
db.SubmitChanges();
}
}
}
//get
public AlarmCount getAlarmCount(int alarmId)
{
var alarmCount = new AlarmCount();
using (var db = new HealthModelsDataContext())
{
var query = db.AlarmCounts.SingleOrDefault(targetAlarmCount => targetAlarmCount.alarmId == alarmId);
alarmCount = query;
}
return(alarmCount);
}
//increment the count whenever a new user decides to attend a nearby alarm
public void incrementAlarmCount(int alarmId)
{
using (var db = new HealthModelsDataContext())
{
AlarmCount alarmCount = db.AlarmCounts.SingleOrDefault(targetAlarmCount => targetAlarmCount.alarmId == alarmId);
if (alarmCount != null)
{
alarmCount.count += 1;
db.SubmitChanges();
}
}
}
//create
public void createAlarmCount(string alarmName)
{
using (var db = new HealthModelsDataContext())
{
Alarm alarm = db.Alarms.SingleOrDefault(targetAlarm => targetAlarm.name.Equals(alarmName));
if (alarm != null)
{
var alarmCount = new AlarmCount();
alarmCount.alarmId = alarm.id;
alarmCount.count = 1;
db.AlarmCounts.InsertOnSubmit(alarmCount);
db.SubmitChanges();
}
}
}
