public ActionResult Edit(int id, Task updatedTask) { var existingTask = s_tasks.Single(t => t.TaskId == id); existingTask.Title = updatedTask.Title; existingTask.Description = updatedTask.Description; existingTask.Completed = updatedTask.Completed; return RedirectToAction("GetAll"); }
public void AddTask(Task task) { using (var connection = CreateConnection()) { var command = connection.CreateCommand(); command.CommandText = "insert into task(title, description) values (@title, @description)"; command.Parameters.AddWithValue("@title", task.Title); command.Parameters.AddWithValue("@description", task.Description); connection.Open(); command.ExecuteNonQuery(); } }
public void AddTask(Task task) { using (var connection = DatabaseConnection.CreateConnection()) { var command = connection.CreateCommand(); command.CommandText = "insert into task(title, description, createdby) values (@title, @description, @userid)"; command.Parameters.AddWithValue("@title", task.Title); command.Parameters.AddWithValue("@description", task.Description); command.Parameters.AddWithValue("@userid", m_currentUser.UserId); connection.Open(); command.ExecuteNonQuery(); } }
public void UpdateTask(int id, Task task) { using (var connection = CreateConnection()) { var command = connection.CreateCommand(); command.CommandText = "update task set title = @title, description = @descr, completed = @cmpl where taskid = @taskid"; command.Parameters.AddWithValue("@taskid", id); command.Parameters.AddWithValue("@title", task.Title); command.Parameters.AddWithValue("@descr", task.Description); command.Parameters.AddWithValue("@cmpl", task.Completed); connection.Open(); command.ExecuteNonQuery(); } }
public int AddTask(Task task) { using (var connection = DatabaseConnection.CreateConnection()) { var command = connection.CreateCommand(); command.CommandText = "add_task"; command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@title", task.Title); command.Parameters.AddWithValue("@description", task.Description); command.Parameters.AddWithValue("@created_by", m_currentUser.UserId); command.Parameters.AddWithValue("@task_id", -1).Direction = ParameterDirection.Output; connection.Open(); command.ExecuteNonQuery(); return (int) command.Parameters["@task_id"].Value; } }
public IEnumerable<Task> FindUncompletedTasks() { using (var connection = CreateConnection()) { var command = connection.CreateCommand(); command.CommandText = "select * from task where completed = 0"; connection.Open(); var tasks = new List<Task>(); using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { while (reader.Read()) { var task = new Task(); task.TaskId = reader.GetInt32(0); task.Title = reader.GetString(1); task.Description = reader.GetString(2); task.Completed = reader.GetBoolean(3); tasks.Add(task); } } return tasks; } }
public Task FindTask(int id) { using (var connection = CreateConnection()) { var command = connection.CreateCommand(); command.CommandText = "select * from task where taskid = @taskid"; command.Parameters.AddWithValue("@taskid", id); connection.Open(); using (var reader = command.ExecuteReader(CommandBehavior.CloseConnection)) { if (reader.Read()) { // TODO: Extract method for reading task and use in all task readering methods. var task = new Task(); task.TaskId = reader.GetInt32(0); task.Title = reader.GetString(1); task.Description = reader.GetString(2); task.Completed = reader.GetBoolean(3); return task; } return null; } } }
public ActionResult Edit(int id, Task updatedTask) { m_tasks.UpdateTask(id, updatedTask); return RedirectToAction("GetAll"); }
public ActionResult Create(Task task) { m_tasks.AddTask(task); return RedirectToAction("GetAll"); }
// POST api/task public int Post(Task task) { var id = m_task.AddTask(task); return id; }
private static Task ReadTaskFromRecord(IDataRecord record) { var task = new Task(); task.TaskId = record.GetInt32(0); task.Title = record.GetString(1); task.Description = record.GetString(2); task.Completed = record.GetBoolean(3); return task; }
public void UpdateTask(int id, Task task) { throw new NotImplementedException(); }
public ActionResult Create(Task task) { task.TaskId = ++s_counter; s_tasks.Add(task); return RedirectToAction("GetAll"); }