public async Task <Task_Output> AddTodo(Task_Input task_Input)
{
var task = new TaskTodo
{
Title = task_Input.Title.Trim(),
isDone = false,
End_At = task_Input.End_At,
UserId = task_Input.UserId
};
unitOfWork.GetRepository <TaskTodo>().Add(task);
var rs = await unitOfWork.SaveChangesAsync();
if (rs <= 0)
{
return(null);
}
return(new Task_Output
{
Id = task.Id,
Title = task_Input.Title,
IsDone = false,
End_At = task_Input.End_At
});
}
public IActionResult addTask(Task_Input task)
{
try {
_db.addTask(task);
return(Ok());
}catch (Exc_NotFound exc) { return(NotFound(exc.Message)); }
catch (Exc_BadRequest exc) { return(BadRequest(exc.Message)); }
}
public async Task <IActionResult> Add(Task_Input task_Input)
{
var task = await taskServices.AddTodo(task_Input);
if (task == null)
{
return(UnprocessableEntity());
}
return(Ok(new { data = task }));
}
public void addTask(Task_Input input)
{
using (var conn = new SqlConnection(connString))
using (var comand = new SqlCommand())
{
comand.Connection = conn;
conn.Open();
var tran = conn.BeginTransaction();
comand.Transaction = tran;
try {
comand.CommandText = "select * from TaskType where Name=@NameType";
comand.Parameters.AddWithValue("NameType", input.TaskType.Name);
var dr = comand.ExecuteReader();
if (!dr.Read())
{
dr.Close();
comand.CommandText = "insert into TaskType values(@NameType)";
comand.ExecuteNonQuery();
}
dr.Close();
comand.CommandText = "select idTaskType from TaskType where Name=@NameType";
dr = comand.ExecuteReader();
if (dr.Read())
{
input.TaskType.IdTaskType = (int)dr.GetValue(0);
}
dr.Close();
comand.CommandText = "select * from project where idProject=@idProject";
comand.Parameters.AddWithValue("idProject", input.IdTeam);
dr = comand.ExecuteReader();
if (!dr.Read())
{
throw new Exc_NotFound("Project with this ID is not found");
}
dr.Close();
comand.CommandText = "select * from TeamMember where IdTeamMember=@idAssignedTo or IdTeamMember=@idCreator";
comand.Parameters.AddWithValue("idAssignedTo", input.IdAssignedTo);
comand.Parameters.AddWithValue("idCreator", input.IdCreator);
dr = comand.ExecuteReader();
if (!dr.Read())
{
throw new Exc_NotFound("TeamMember with this ID is not found");
}
dr.Close();
comand.CommandText = "insert into Task (name, description, deadline, idproject, idtasktype, idassignedto, idcreator) " +
"values(@name,@description,@deadline,@idProject,@idTaskType,@idAssignedTo,@idCreator)";
comand.Parameters.AddWithValue("name", input.Name);
comand.Parameters.AddWithValue("description", input.Description);
comand.Parameters.AddWithValue("deadline", input.Deadline);
comand.Parameters.AddWithValue("idTaskType", input.TaskType.IdTaskType);
comand.ExecuteNonQuery();
dr.Close();
tran.Commit();
tran.Dispose();
}
catch (Exc_BadRequest e)
{
tran.Rollback();
tran.Dispose();
throw new Exc_BadRequest(e.Message);
}catch (Exc_NotFound e)
{
tran.Rollback();
tran.Dispose();
throw new Exc_NotFound(e.Message);
}
catch (Exception e)
{
tran.Rollback();
tran.Dispose();
throw new Exc_BadRequest(e.Message);
}
}
}
