public async Task <IHttpActionResult> Put(TaskAssignDTO dto) { try { //find the new assignee var user = context.Users.FirstOrDefault(u => u.Email == dto.AssigneeEmail); if (user != null) { //set as new assignee var task = await context.Tasks.FindAsync(dto.TaskId); task.Assignees.Add(user); await context.SaveChangesAsync(); //publish notification here return(Ok(task)); } return(NotFound()); } catch (Exception ex) { return(InternalServerError(ex)); } }
public bool addData(TaskAssignDTO taskAssignDTO) { // Nếu khóa chính trống thì không thể thêm vào. if (taskAssignDTO.Employee == string.Empty || taskAssignDTO.ProjectID == string.Empty || taskAssignDTO.Stage == string.Empty || taskAssignDTO.Task == string.Empty) { return(false); } return(TaskAssignDAO.Instance.addData(taskAssignDTO)); }
//public DataTable getData() //{ // string str_Query = ("SELECT * FROM TASKASSIGN"); // DataTable dt_Result = DataProvider.Instance.ExecuteQuery(str_Query); // return dt_Result; //} //public TaskCreatingDTO getDataObjectFollowAllPrimaryKeys(string projectID, string stage, string task, string employee) //{ // string str_Query = ("SELECT * FROM TASKASSIGN WHERE PROJECTID = '" + projectID + "' AND STAGE = '" + stage + "' AND TASK = '" + task + "' AND EMPLOYEE = '" + employee + "'"); // DataTable dt_Data = DataProvider.Instance.ExecuteQuery(str_Query); // if (dt_Data == null) // return null; // if (dt_Data.Rows.Count == 0) // { // TaskCreatingDTO taskCreatingDTOResultTemp = new TaskCreatingDTO(); // return taskCreatingDTOResultTemp; // } // DataRow dtR_DataRow = dt_Data.Rows[0]; // TaskCreatingDTO taskCreatingDTOResult = new TaskCreatingDTO(dtR_DataRow); // return taskCreatingDTOResult; //} //public List<TaskAssignDTO> getDataList() //{ // string str_Query = ("SELECT * FROM TASKASSIGN"); // DataTable dt_Data = DataProvider.Instance.ExecuteQuery(str_Query); // if (dt_Data == null) // return null; // List<TaskAssignDTO> lst_TaskAssignListResult = new List<TaskAssignDTO>(); // foreach (DataRow item in dt_Data.Rows) // { // TaskAssignDTO taskCreatingDTO = new TaskAssignDTO(item); // lst_TaskAssignListResult.Add(taskCreatingDTO); // } // return lst_TaskAssignListResult; //} public bool addData(TaskAssignDTO taskAssignDTO) { // Nếu khóa chính trống thì không thể thêm vào. if (taskAssignDTO.Employee == string.Empty || taskAssignDTO.ProjectID == string.Empty || taskAssignDTO.Stage == string.Empty || taskAssignDTO.Task == string.Empty) { return(false); } string str_Query = "INSERT INTO TASKASSIGN VALUES ('" + taskAssignDTO.ProjectID + "' , '" + taskAssignDTO.Stage + "', '" + taskAssignDTO.Task + "', '" + taskAssignDTO.Employee + "', '" + taskAssignDTO.TaskDescription + "', '" + DateTime.Parse(taskAssignDTO.StartDate).ToString("MM/dd/yyyy") + "', '" + DateTime.Parse(taskAssignDTO.EndDate).ToString("MM/dd/yyyy") + "', '" + taskAssignDTO.TaskType + "', '" + taskAssignDTO.Approval + "', '" + taskAssignDTO.AttachFile + "', '" + taskAssignDTO.Progress + "', '" + taskAssignDTO.Status + "', NULL, '" + taskAssignDTO.TimeDelay + "', '" + taskAssignDTO.Color + "', '" + taskAssignDTO.Note + "')"; int i_Result = DataProvider.Instance.ExecuteNonQuery(str_Query); return(i_Result > 0); }
private void btnAssignTask_Click(object sender, EventArgs e) { this.str_EmployeeRecieveGlobal = this.cbbEmployee.Text.Trim(); // Lấy ra một task creating. TaskCreatingDTO taskCreatingAssignDTOLocal = TaskCreatingBUS.Instance.getDataObjectFollowProjectIDAndStageAndTask(this.str_ProjectIDGlobal, this.str_StageGlobal, this.str_TaskGlobal); if (taskCreatingAssignDTOLocal == null) { XtraMessageBox.Show("Cannot connect to database!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (taskCreatingAssignDTOLocal.Empty()) { XtraMessageBox.Show("Empty data!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } string str_ProjectIDLocal = this.str_ProjectIDGlobal; string str_StageLocal = this.str_StageGlobal; string str_TaskLocal = this.str_TaskGlobal; // Lấy ra một task assign. // Giờ đưa nhiệm vụ này vào bảng nhiệm vụ đã đẩy. TaskAssignDTO taskAssignDTO = new TaskAssignDTO(taskCreatingAssignDTOLocal); taskAssignDTO.Note += this.str_EmployeeAssignGlobal + " assigned task to " + this.str_EmployeeRecieveGlobal + "; "; if (TaskAssignDAO.Instance.addData(taskAssignDTO)) { // Cập nhật thông tin cho người mới được nhận công việc của người cũ. if (taskCreatingAssignDTOLocal.Approver == string.Empty) { taskCreatingAssignDTOLocal.Approver = null; } if (this.str_EmployeeRecieveGlobal == string.Empty) { taskCreatingAssignDTOLocal.Employee = null; } else { taskCreatingAssignDTOLocal.Employee = this.str_EmployeeRecieveGlobal; } if (this.dtEdtStartDate.Text.Trim() == string.Empty) { taskCreatingAssignDTOLocal.StartDate = null; } else { taskCreatingAssignDTOLocal.StartDate = this.dtEdtStartDate.Text.Trim(); } if (this.dtEdtEndDate.Text.Trim() == string.Empty) { taskCreatingAssignDTOLocal.EndDate = null; } else { taskCreatingAssignDTOLocal.EndDate = this.dtEdtEndDate.Text.Trim(); } taskCreatingAssignDTOLocal.Progress = "0"; taskCreatingAssignDTOLocal.Status = StaticVarClass.status_NotComplete; taskCreatingAssignDTOLocal.FinishDate = null; taskCreatingAssignDTOLocal.TimeDelay = "0"; taskCreatingAssignDTOLocal.Note += this.str_EmployeeRecieveGlobal + " recieved task from " + this.str_EmployeeAssignGlobal + "; "; if (TaskCreatingBUS.Instance.updateDataForTaskAssign(taskCreatingAssignDTOLocal)) { #region Cập nhật lịch sử. string name = StaticVarClass.account_Username; string time = DateTime.Now.ToString(); string action = "Assign project - stage - task: " + str_ProjectIDLocal + " - " + str_StageLocal + " - " + str_TaskLocal + " to employee " + str_EmployeeRecieveGlobal; string status = "Successful"; HistoryDTO hisDTO = new HistoryDTO(name, time, action, status); HistoryDAO.Instance.addData(hisDTO); #endregion XtraMessageBox.Show("Successfully assigned project - stage - task: " + str_ProjectIDLocal + " - " + str_StageLocal + " - " + str_TaskLocal + " to employee " + str_EmployeeRecieveGlobal + "!", "Notification", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { #region Cập nhật lịch sử. string name = StaticVarClass.account_Username; string time = DateTime.Now.ToString(); string action = "Assign project - stage - task: " + str_ProjectIDLocal + " - " + str_StageLocal + " - " + str_TaskLocal + " to employee " + str_EmployeeRecieveGlobal; string status = "Failed"; HistoryDTO hisDTO = new HistoryDTO(name, time, action, status); HistoryDAO.Instance.addData(hisDTO); #endregion XtraMessageBox.Show("Assign project - stage - task: " + str_ProjectIDLocal + " - " + str_StageLocal + " - " + str_TaskLocal + " to employee " + str_EmployeeRecieveGlobal + " failed!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { #region Cập nhật lịch sử. string name = StaticVarClass.account_Username; string time = DateTime.Now.ToString(); string action = "Assign project - stage - task: " + str_ProjectIDLocal + " - " + str_StageLocal + " - " + str_TaskLocal + " to employee " + str_EmployeeRecieveGlobal; string status = "Failed"; HistoryDTO hisDTO = new HistoryDTO(name, time, action, status); HistoryDAO.Instance.addData(hisDTO); #endregion XtraMessageBox.Show("Assign project - stage - task: " + str_ProjectIDLocal + " - " + str_StageLocal + " - " + str_TaskLocal + " to employee " + str_EmployeeRecieveGlobal + " failed!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }