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