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