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