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