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