//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); }
//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); }
//get user tasks public List <Task> getUserTasks(string username) { List <Task> userTasks = new List <Task>(); using (var db = new HealthModelsDataContext()) { var userQuery = db.Users.SingleOrDefault(targetUser => targetUser.userName.Equals(username)); if (userQuery != null) { User user = userQuery; int userId = user.id; var query = db.AssignedTasks.Where(assigned => assigned.userId == userId).ToList(); List <AssignedTask> assignedUserTasks = query; foreach (AssignedTask assignedTask in assignedUserTasks) { int taskId = assignedTask.taskId; Task userTask = db.Tasks.SingleOrDefault(task => task.id == taskId); userTasks.Add(userTask); } } } return(userTasks); }
public int getMaxId() { int lastId = 0; using (var db = new HealthModelsDataContext()) { lastId = db.Alarms.OrderByDescending(u => u.id).FirstOrDefault().id; } return(lastId); }
//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); }
public List <AlarmPublisher> getAllAlarmPublishers() { List <AlarmPublisher> publishers = new List <AlarmPublisher>(); using (var db = new HealthModelsDataContext()) { var query = db.AlarmPublishers.ToList(); publishers = query; } return(publishers); }
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); }
//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 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); }
//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 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 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 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 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); }
//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); }
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 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); }
//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(); } } }
//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 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 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(); } } }
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(); } }
//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(); } } }
//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(); } } }
//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 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); }
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(); } }
//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(); } }
public string userLogIn(string username, string password) { string result = "Fail"; using (var db = new HealthModelsDataContext()) { User user = db.Users.SingleOrDefault(targetUser => targetUser.userName.Equals(username) && targetUser.password.Equals(password)); if (user != null) { result = user.role; } } return(result); }