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