//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;
}
//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();
}
}
}
partial void DeleteAlarmCount(AlarmCount instance);
partial void UpdateAlarmCount(AlarmCount instance);
partial void InsertAlarmCount(AlarmCount instance);
