public IActionResult AddTasks(TaskTypeRequest task) { try { _addTask.AddTask(task); return(Ok("dodanie powiodlo sie")); }catch (Exception e) { return(BadRequest("Juz istnieje \n")); } }
public async Task <IActionResult> AddTaskType([FromBody] TaskTypeRequest taskTypeRequest) { var taskType = _mapper.Map <TaskType>(taskTypeRequest); var result = await _taskTypeService.Create(taskType); if (result == null) { return(NotFound()); } return(Ok(result)); }
public void AddTask(TaskTypeRequest taskR) { using (SqlConnection con = new SqlConnection(conStr)) using (SqlCommand com = new SqlCommand()) { com.Connection = con; con.Open(); var tran = con.BeginTransaction(); com.Transaction = tran; com.ExecuteNonQuery(); com.CommandText = "select IdTask from Task where IdTask=@IdTask"; com.Parameters.AddWithValue("IdTask", taskR.IdTaskType); var dr = com.ExecuteReader(); if (!dr.Read()) { dr.Close(); throw new Exception(); } else { com.CommandText = "INSERT INTO TASK(IdTaskType,Name) VALUES (@IdTask,@Name)"; com.Parameters.AddWithValue("IdTask", taskR.IdTaskType); com.Parameters.AddWithValue("Name", taskR.Name); dr.Close(); com.ExecuteNonQuery(); } tran.Commit(); con.Close(); } }