//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; }
//update task public void updateTask(string taskName, string status, string description) { var task = new Task(); using (var db = new HealthModelsDataContext()) { task = db.Tasks.SingleOrDefault(targetTask => targetTask.taskName.Equals(taskName)); if (task != null) { task.taskName = taskName; task.status = status; task.description = description; db.SubmitChanges(); } } }
partial void UpdateTask(Task instance);
partial void DeleteTask(Task instance);
partial void InsertTask(Task instance);