public int AddTask(TaskAddRequest model)
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "dbo.Task_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", model.Name);
cmd.Parameters.AddWithValue("@StartTime", model.StartTime);
cmd.Parameters.AddWithValue("@Deadline", model.Deadline);
SqlParameter idParam = cmd.Parameters.Add("@Id", SqlDbType.Int);
idParam.Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
conn.Close();
return((int)idParam.Value);
}
}
public async Task <IActionResult> AddTask(
[FromBody] TaskAddRequest taskAddRequest,
CancellationToken cancellationToken = default)
{
var taskDal = taskAddRequest.ToDal();
try
{
await _dbContext
.Tasks
.AddAsync(taskDal, cancellationToken);
await _dbContext.SaveChangesAsync(cancellationToken);
return(Ok(taskDal.Id));
}
catch (DbUpdateException ex)
when(ex.IsPgSqlKeyViolationException())
{
return(Conflict(ex.InnerException.Message));
}
catch (Exception ex)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, ex));
}
}
IEnumerator StartRequestModifyTask(TaskAddRequest reqObj)
{
string url = "http://li1440-68.members.linode.com:3102/TaskModify";
var jsonStr = JsonUtility.ToJson(reqObj);
Debug.Log("jsonStr" + jsonStr);
var jsonRaw = System.Text.Encoding.UTF8.GetBytes(jsonStr);
var uploader = new UnityEngine.Networking.UploadHandlerRaw(jsonRaw);
uploader.contentType = "application/json; charset=utf-8";
var req = UnityEngine.Networking.UnityWebRequest.Post(url, string.Empty);
req.uploadHandler = uploader;
req.SetRequestHeader("Accept", "application/json");
yield return(req.Send());
if (req.isError)
{
Debug.LogError("StartRequestModifyTask req.error" + req.error);
yield break;
}
else
{
StandardResponse res = null;
Debug.Log("StartRequestModifyTask completed response=" + req.downloadHandler.text);
try
{
res = JsonUtility.FromJson <StandardResponse>(req.downloadHandler.text);
}
catch
{
yield break;
}
if (null == res || res.Success == false)
{
if (null != res)
{
Debug.LogWarning("StartRequestModifyTask() res.Success=" + res.Success);
}
else
{
Debug.LogWarning("StartRequestModifyTask() null == res");
}
yield break;
}
else
{
Debug.Log("StartRequestModifyTask completed");
m_ModifyTaskInterfaceHelper.Clear();
FetchTask();
}
}
yield return(null);
}
public void AddTask()
{
Debug.LogWarning("AddTask");
if (null == m_AddTaskInterfaceHelper)
{
return;
}
{
TaskBundle bundle = TaskBundleHelper.CopyFromAddTaskInterfaceHelper(m_AddTaskInterfaceHelper);
// prepare bundle to upload string
TaskAddRequest req = new TaskAddRequest();
req.RequestSerial = m_RequestSerial++;
req.UpdateSerial = TaskMauerStaticData.GetUpdateSerial();
req.ProjectKey = m_ProjectKey;
req.Task = bundle;
m_RequestList.Add(m_RequestSerial, req);
StartCoroutine(StartRequestTaskAdd(req));
}
m_AddTaskInterfaceHelper.gameObject.SetActive(false);
}
void MouseRelease()
{
if (m_SelectedObjDraged)
{
if (IsSelected())
{
// update position to data
TaskBundle bundle = TryFindTaskData(m_SelectedObjTaskID);
TaskVisualObj visual = TryFindTaskVisual(m_SelectedObjTaskID);
if (null != visual && null != bundle)
{
if (bundle.Visual.IsPin)
{
// revert position
SetTaskVisual3DFromBundle(visual.m_3DObj, bundle);
}
else
{
Vector3 pos = visual.m_3DObj.transform.localPosition;
bundle.Visual.PositionStr = string.Format("{0},{1},{2}", pos.x, pos.y, pos.z);
// uploading apply change to task
TaskAddRequest fetchReq = new TaskAddRequest();
fetchReq.UpdateSerial = TaskMauerStaticData.GetUpdateSerial();
fetchReq.ProjectKey = m_ProjectKey;
fetchReq.Task = bundle;
StartCoroutine(StartRequestModifyTask(fetchReq));
}
}
}
m_SelectedObjDraged = false;
}
}
public void ConfirmModifyTask()
{
Debug.LogWarning("ConfirmModifyTask");
if (null == m_ModifyTaskInterfaceHelper)
{
return;
}
TaskBundle bundle = TryFindTaskData(m_SelectedObjTaskID);
if (null != bundle)
{
// uploading apply change to task
TaskBundle modifyBundle = TaskBundleHelper.CopyFromModifyTaskInterfaceHelper(m_ModifyTaskInterfaceHelper, bundle);
TaskAddRequest fetchReq = new TaskAddRequest();
fetchReq.UpdateSerial = TaskMauerStaticData.GetUpdateSerial();
fetchReq.ProjectKey = m_ProjectKey;
fetchReq.Task = modifyBundle;
StartCoroutine(StartRequestModifyTask(fetchReq));
}
HideModifyTaskInterface();
}
/// <summary> Add task </summary>
public async Task <ActionResult> AddTaskAsync(TaskAddRequest addTaskRequest)
{
var project = await _projectRepository.GetByIdAsync(addTaskRequest.ProjectId);
if (project == null)
{
return(new NotFoundObjectResult($"Project is not found with id:{addTaskRequest.ProjectId}"));
}
var task = _mapper.Map <Models.Task>(addTaskRequest);
task.StatusId = 1;
await _taskRepository.InsertAsync(task);
return(new OkResult());
}
public async Task <ActionResult> Post([FromBody] TaskAddRequest addTaskRequest)
{
return(await _taskService.AddTaskAsync(addTaskRequest));
}
