//get the users who attend a particular alarm public List<User> getAllarmAttendants(string alarmName) { List<User> attendants = new List<User>(); using (var db = new HealthModelsDataContext()) { Alarm alarm = db.Alarms.SingleOrDefault(targetAlarm => targetAlarm.name.Equals(alarmName)); if (alarm != null) { List<AlarmAttendance> alarmAttendances = new List<AlarmAttendance>(); var attendancesQuery = db.AlarmAttendances.Where(attendace => attendace.alarmId == alarm.id).ToList(); alarmAttendances = attendancesQuery; foreach (AlarmAttendance alarmAttendance in alarmAttendances) { User attendant = db.Users.SingleOrDefault(attendantUser => attendantUser.id == alarmAttendance.userId); attendants.Add(attendant); } } } return attendants; }
//to get the users assigned to a particular task public List<User> getTaskUsers(string taskName) { List<User> taskUsers = new List<User>(); using (var db = new HealthModelsDataContext()) { var taskQuery = db.Tasks.SingleOrDefault(targetTask => targetTask.taskName.Equals(taskName)); if(taskQuery != null) { Task task = taskQuery; int taskId = task.id; var query = db.AssignedTasks.Where(assigned => assigned.taskId == taskId).ToList(); List<AssignedTask> assignedTaskUsers = query; foreach(AssignedTask assignedTask in assignedTaskUsers) { int userId = assignedTask.userId; User taskUser = db.Users.SingleOrDefault(user => user.id == userId); taskUsers.Add(taskUser); } } } return taskUsers; }
//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 SubTasks public List<SubTask> getSubtasks() { List<SubTask> subtask = new List<SubTask>(); using (var db = new HealthModelsDataContext()) { var query = db.SubTasks.ToList(); subtask = query; } return subtask; }
//get SubTask public SubTask getSubtask(int id) { var subtask = new SubTask(); using (var db = new HealthModelsDataContext()) { var query = db.SubTasks.SingleOrDefault(targetSubtask => targetSubtask.id.Equals(id)); subtask = query; } return subtask; }
//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; }
//get tasks public List<Task> getTasks() { List<Task> tasks = new List<Task>(); using (var db = new HealthModelsDataContext()) { var query = db.Tasks.ToList(); tasks = query; } return tasks; }
//get users public List<User> getUsers() { List<User> users = new List<User>(); using (var db = new HealthModelsDataContext()) { var query = db.Users.ToList(); users = query; } return users; }
//get Alarms public List<Alarm> getAlarms() { List<Alarm> alarms = new List<Alarm>(); using (var db = new HealthModelsDataContext()) { var query = db.Alarms.ToList(); alarms = query; } return alarms; }
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 List<AlarmPublisher> getAllAlarmPublishers() { List<AlarmPublisher> publishers = new List<AlarmPublisher>(); using (var db = new HealthModelsDataContext()) { var query = db.AlarmPublishers.ToList(); publishers = query; } return publishers; }
//status filter public List<Task> taskStatusFilter(string status) { List<Task> filteredTasks = new List<Task>(); using (var db = new HealthModelsDataContext()) { var query = db.Tasks.Where(targetTask => targetTask.status.Equals(status)).ToList(); filteredTasks = query; } return filteredTasks; }
//get task public Task getTask(string taskName) { var task = new Task(); using (var db = new HealthModelsDataContext()) { var query = db.Tasks.SingleOrDefault(targetTask => targetTask.taskName.Equals(taskName)); task = query; } return task; }
//get user public User getUser(string username) { var user = new User(); using (var db = new HealthModelsDataContext()) { var query = db.Users.SingleOrDefault(targetUser => targetUser.userName.Equals(username)); user = query; } return user; }
public Alarm getAlarmById(int id) { var alarm = new Alarm(); using (var db = new HealthModelsDataContext()) { var query = db.Alarms.SingleOrDefault(targetAlarm => targetAlarm.id == id); alarm = query; } return alarm; }
//get Alarm public Alarm getAlarm(string name) { var alarm = new Alarm(); using (var db = new HealthModelsDataContext()) { var query = db.Alarms.SingleOrDefault(targetAlarm => targetAlarm.name.Equals(name)); alarm = query; } return alarm; }
//delete alarm public void deleteAlarm(string name) { using (var db = new HealthModelsDataContext()) { Alarm alarm = db.Alarms.SingleOrDefault(targetAlarm => targetAlarm.name.Equals(name)); if(alarm!=null) { db.Alarms.DeleteOnSubmit(alarm); db.SubmitChanges(); } } }
//delete SubTask public void deleteSubTask(int id) { using (var db = new HealthModelsDataContext()) { SubTask subTask = db.SubTasks.SingleOrDefault(targetSubTask => targetSubTask.id == id); if (subTask != null) { db.SubTasks.DeleteOnSubmit(subTask); db.SubmitChanges(); } } }
//delete task public void deleteTask(string taskName) { using (var db = new HealthModelsDataContext()) { Task task = db.Tasks.SingleOrDefault(targetTask => targetTask.taskName.Equals(taskName)); if(task != null) { db.Tasks.DeleteOnSubmit(task); db.SubmitChanges(); } } }
public void createPublishedAlarm(int alarmId, int publisherId) { using (var db = new HealthModelsDataContext()) { var publishedAlarm = new PublishedAlarm(); publishedAlarm.alarmId = alarmId; publishedAlarm.publisherId = publisherId; db.PublishedAlarms.InsertOnSubmit(publishedAlarm); db.SubmitChanges(); } }
//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(); } } }
//delete user public void deleteUser(string username) { using (var db = new HealthModelsDataContext()) { User user = db.Users.SingleOrDefault(targetUser => targetUser.userName.Equals(username)); if(user!=null) { db.Users.DeleteOnSubmit(user); db.SubmitChanges(); } } }
public int getPublisherId(int alarmId) { int publisherId = 0; using (var db = new HealthModelsDataContext()) { var query = db.PublishedAlarms.SingleOrDefault(targetPublished => targetPublished.alarmId == alarmId); var publishedAlarm = new PublishedAlarm(); publishedAlarm = query; publisherId = publishedAlarm.publisherId; } return publisherId; }
//create task public void createTask(string taskName, string status, string description) { using (var db = new HealthModelsDataContext()) { var task = new Object_Models.Task(); task.taskName = taskName; task.status = status; task.description = description; db.Tasks.InsertOnSubmit(task); db.SubmitChanges(); } }
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(); } }
//create user public void createUser(string firstName, string lastName, string username, string password, string role) { using (var db = new HealthModelsDataContext()) { var user = new User(); user.firstName = firstName; user.lastName = lastName; user.userName = username; user.password = password; user.role = role; db.Users.InsertOnSubmit(user); db.SubmitChanges(); } }
//get specific task subtasks public List<SubTask> getTaskSubTasks(string taskName) { List<SubTask> taskSubTasks = new List<SubTask>(); using (var db = new HealthModelsDataContext()) { Task task = db.Tasks.SingleOrDefault(targetTask => targetTask.taskName.Equals(taskName)); if (task != null) { var query = db.SubTasks.Where(subTask => subTask.taskId == task.id).ToList(); taskSubTasks = query; } } return taskSubTasks; }
//create Alarm public void createAlarm(string name, string type, string location, string status) { using (var db = new HealthModelsDataContext()) { var alarm = new Alarm(); alarm.name = name; alarm.type = type; alarm.time = DateTime.Now; alarm.location = location; alarm.status = status; db.Alarms.InsertOnSubmit(alarm); 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(); } } }
//create SubTask public void createSubtask(string taskName, string description, string status) { using (var db = new HealthModelsDataContext()) { Task task = db.Tasks.SingleOrDefault(targetTask => targetTask.taskName.Equals(taskName)); if (task != null) { var subtask = new SubTask(); subtask.taskId = task.id; subtask.description = description; subtask.status = status; db.SubTasks.InsertOnSubmit(subtask); db.SubmitChanges(); } } }