public AlarmPublisher getAlarmPublisher(int id)
{
var publisher = new AlarmPublisher();
using (var db = new HealthModelsDataContext())
{
var query = db.AlarmPublishers.SingleOrDefault(targetPublisher => targetPublisher.id == id);
publisher = query;
}
return publisher;
}
public void createAlarmPublisher(string pacientName, string condition, string location, string password)
{
using (var db = new HealthModelsDataContext())
{
var publisher = new AlarmPublisher();
publisher.pacient_name = pacientName;
publisher.condition = condition;
publisher.location = location;
publisher.password = password;
db.AlarmPublishers.InsertOnSubmit(publisher);
db.SubmitChanges();
}
}
public void updateAlarmPublisher(int id, string pacientName, string condition, string location, string password)
{
var publisher = new AlarmPublisher();
using (var db = new HealthModelsDataContext())
{
publisher = db.AlarmPublishers.SingleOrDefault(targetPublisher => targetPublisher.id == id);
if (publisher != null)
{
publisher.pacient_name = pacientName;
publisher.condition = condition;
publisher.location = location;
publisher.password = password;
db.SubmitChanges();
}
}
}
partial void DeleteAlarmPublisher(AlarmPublisher instance);
partial void UpdateAlarmPublisher(AlarmPublisher instance);
partial void InsertAlarmPublisher(AlarmPublisher instance);
