public Task ChangeState(Int32 taskId, String status)
{
Task task = new Task();
using (RecklessCheckListEntities context = new RecklessCheckListEntities())
{
Int32 valueId = (from v in context.TASK_VALUE
where v.NAME == status
select v.TASK_VALUE_ID).First();
var taskSelect = from t in context.TASKs.Include("TASK_VALUE")
where t.TASK_ID == taskId
select t;
if (taskSelect.Count() == 1)
{
TASK contextTask = taskSelect.First();
contextTask.TASK_VALUE_ID = valueId;
context.SaveChanges();
task = new Task() { Id = contextTask.TASK_ID, Value = status, Name = contextTask.NAME };
}
}
return task;
}
public TaskList GetTasks()
{
TaskList list = new TaskList();
list.Tasks = new List<Task>();
using (RecklessCheckListEntities context = new RecklessCheckListEntities())
{
list.Tasks = (from t in context.TASKs.Include("TASK_VALUE")
select new Task() { Id = t.TASK_ID, Name = t.NAME, Value = t.TASK_VALUE.NAME }).ToList();
}
return list;
}
public Task GetTask(Int32 taskId)
{
Task task = new Task();
using (RecklessCheckListEntities context = new RecklessCheckListEntities())
{
var taskSelect = from t in context.TASKs.Include("TASK_VALUE")
where t.TASK_ID == taskId
select t;
if (taskSelect.Count() == 1)
{
TASK selectedTask = taskSelect.First();
task = new Task() { Id = selectedTask.TASK_ID, Value = selectedTask.TASK_VALUE.NAME, Name = selectedTask.NAME };
}
}
return task;
}
public TaskResponse ToggleTask(Int32 taskId)
{
TaskResponse response = new TaskResponse();
using (RecklessCheckListEntities context = new RecklessCheckListEntities())
{
var taskSelect = from t in context.TASKs.Include("TASK_VALUE")
where t.TASK_ID == taskId
select t;
if (taskSelect.Count() == 1)
{
TASK contextTask = taskSelect.First();
response.OldStatus = contextTask.TASK_VALUE.NAME;
Int32 valueId = ((contextTask.TASK_VALUE_ID + 1) % 4);
if (valueId == 0)
valueId = 4;
contextTask.TASK_VALUE_ID = valueId;
context.SaveChanges();
var status = (from s in context.TASK_VALUE
where s.TASK_VALUE_ID == contextTask.TASK_VALUE_ID
select s.NAME).First();
response.NewStatus = status;
response.Completed = true;
}
else
{
response.Completed = false;
}
}
return response;
}