//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);
}
