public ActionResult <IEnumerable <ITodoTask> > Post(string email, [FromBody] TaskContentModel model) { _taskManager.Add(new TodoTask(email) { Content = model.Content }); return(Ok(_taskManager.GetAll())); }
internal TaskContentModel TasksContent() { var taskContent = new TaskContentModel(); var taskStatesList = new List <TaskStateModel>(); var employeesList = new List <EmployeeModel>(); var toolsList = new List <ToolModel>(); var toolStatesList = new List <ToolStateModel>(); using (var conn = new MySqlConnection(GetConnectionString())) { try { MySqlCommand myCommand = conn.CreateCommand(); conn.Open(); myCommand.Connection = conn; myCommand.CommandText = "SELECT id, state FROM task_states"; using (var reader = myCommand.ExecuteReader()){ while (reader.Read()) { taskStatesList.Add(ParseTaskStates(reader)); } } myCommand.CommandText = "SELECT id, name, lastName FROM employees"; using (var reader = myCommand.ExecuteReader()){ while (reader.Read()) { employeesList.Add(ParseEmployees(reader)); } } myCommand.CommandText = "SELECT id, toolName FROM tools"; using (var reader = myCommand.ExecuteReader()){ while (reader.Read()) { toolsList.Add(ParseTools(reader)); } } myCommand.CommandText = "SELECT id,state FROM tool_states"; using (var reader = myCommand.ExecuteReader()){ while (reader.Read()) { toolStatesList.Add(ParseToolStates(reader)); } } taskContent.employees = employeesList; taskContent.states = taskStatesList; taskContent.tool_states = toolStatesList; taskContent.tools = toolsList; return(taskContent); } catch (System.Exception ex) { throw ex; } return(null); } }
public ActionResult <IEnumerable <ITodoTask> > Put(Guid id, [FromBody] TaskContentModel model) { _taskManager.Update(id, model.Content); return(Ok(_taskManager.GetAll())); }