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