/// <summary>
/// Report for Task Completion.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void taskCompletedToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
if (dgvProjects.SelectedRows.Count == 1)
{
if (MessageBox.Show("Are you sure Do you want Complete the task ?", GlobalVariables.ProjectName, MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
int shipmentId = Convert.ToInt32(dgvProjects.Rows[dgvProjects.CurrentRow.Index].Cells["colShipMentId"].Value);
TaskStatus objTStatus = new TaskStatus();
objTStatus.Task_ID = Convert.ToInt32(dgvProjects.Rows[dgvProjects.CurrentRow.Index].Cells["colTaskId"].Value);
objTStatus.RoleName = GlobalVariables.RoleName;
objTStatus.TaskAllocation_ID = Convert.ToInt32(dgvProjects.Rows[dgvProjects.CurrentRow.Index].Cells["colTaskAllocationId"].Value);
objTStatus.Status = "SET COMPLETE";
objTStatus.IsReassigned = 'N';
TaskManagementDB.UpdateTaskStatus(objTStatus);
MessageBox.Show("Task completed successfully", GlobalVariables.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Information);
FillAssignTask();
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
// Assign Task.
private void btnAssign_Click(object sender, EventArgs e)
{
try
{
string strErrMsg = "";
if (ValidateUserInputs(out strErrMsg))
{
int ShipMentId = Convert.ToInt32(cmbShipmentName.SelectedValue);
int TaskPrepUrId = Convert.ToInt32(cmbUserName.SelectedValue);
TaskManagementDB.TAtoTaskPrep(ShipMentId, TaskPrepUrId, Common.GlobalVariables.UrId);
MessageBox.Show("Task Assigned Successfully", GlobalVariables.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Information);
FillAssignmentGrid();
ResetUserInPuts();
}
else
{
MessageBox.Show(strErrMsg, GlobalVariables.ProjectName, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void GetUsersTaskCountAndBindToGrid()
{
try
{
if (cmbModule.SelectedItem != null)
{
DataTable dtModuleUsers = null;
DataTable dtTaskCounts = TaskManagementDB.GetUserTaskCountsOnModule(GetSelectedModuleCode(), out dtModuleUsers);
if (dtTaskCounts != null)
{
dgvTaskCounts.AutoGenerateColumns = false;
dgvTaskCounts.DataSource = dtTaskCounts;
colUserName_TC.DataPropertyName = "USER_NAME";
colRoleName_TC.DataPropertyName = "ROLE_NAME";
colAssignedCnt_TC.DataPropertyName = "ASSIGNED_CNT";
colInPrgressCnt_TC.DataPropertyName = "PROGRESS_CNT";
}
AppModuleUsers = dtModuleUsers;
if (dtModuleUsers != null)
{
cmbCurator.DataSource = dtModuleUsers;
cmbCurator.ValueMember = "ANLST_UR_ID";
cmbCurator.DisplayMember = "ANLST_NAME";
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void SetApplicationModuleUsersToComboBox()
{
try
{
if (cmbModule.SelectedValue != null)
{
string strModule = cmbModule.SelectedValue.ToString();
DataTable dtModuleUsers = null;
dtModuleUsers = TaskManagementDB.GetUsersByModule(strModule);
if (dtModuleUsers != null)
{
AppModuleUsers = dtModuleUsers;
cmbCurator.DataSource = dtModuleUsers;
cmbCurator.ValueMember = "ANLST_UR_ID";
cmbCurator.DisplayMember = "ANLST_NAME";
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void GetAssignedShipmentRefsAndBindToGrid()
{
try
{
string strModule = GetSelectedModuleCode();
int shipmentID = Convert.ToInt32(cmbShipment.SelectedValue);
DataTable dtAssignedRefs = TaskManagementDB.GetAssignedRefrencesOnShipment(strModule, shipmentID);
dgvAssignedRefs.DataSource = dtAssignedRefs;
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
/// <summary>
/// Re-assign the selected user task to another user.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
private void btnReAssign_Click(object sender, EventArgs e)
{
_lstTaskAllocIds = new List <int>();
_lstReallocateToUserIds = new List <int>();
try
{
string strErr = string.Empty;
if (ValidateReallocateInputs(ref _lstTaskAllocIds, out strErr))
{
if (_lstTaskAllocIds.Count > 0)
{
DialogResult diaRes = MessageBox.Show("Do you want to re-assign the selected references?", GlobalVariables.MessageCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (diaRes == System.Windows.Forms.DialogResult.Yes)
{
int reallocURID = Convert.ToInt32(dgvReallocateToUser.SelectedRows[0].Cells[colReallocateToURID.Name].Value);
if (TaskManagementDB.ModifyTaskAssignment(_lstTaskAllocIds, reallocURID, GlobalVariables.UR_ID))
{
_headerCheckBox.Checked = false;
usersTaskCounts = TaskManagementDB.GetUsersTaskCountsOnRole("RA", Convert.ToInt32(cmbRole.SelectedValue));
BindUsersTaskCountsToGrid(usersTaskCounts);
//Refresh User tasks
cmbUsers_SelectionChangeCommitted(null, null);
MessageBox.Show("Tasks Re-Assigned successfully", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Error in task Re-Assignment", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
}
else
{
MessageBox.Show(strErr.Trim(), GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void dgvProjects_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
{
if (dgvProjects.Columns[e.ColumnIndex].Name.ToUpper() == colAbstactRefName.Name.ToUpper())
{
using (DataGridViewRow gridRow = dgvProjects.Rows[e.RowIndex])
{
TaskStatus objTStatus = new TaskStatus();
TaskId = Convert.ToInt32(gridRow.Cells[colTaskId.Name].Value.ToString());
objTStatus.Task_ID = TaskId;
objTStatus.Role_ID = GlobalVariables.RoleId;
objTStatus.TaskAllocation_ID = Convert.ToInt32(gridRow.Cells[colTaskAllocationId.Name].Value);
//Update User task status
if (gridRow.Cells[colStatus.Name].Value.ToString().ToUpper().Contains("ASSIGNED"))
{
objTStatus.TaskStatusName = "SET PROGRESS";
objTStatus.IsReassigned = 'N';
//Updates the status to Inprogress.
TaskManagementDB.UpdateTaskStatus(objTStatus);
}
userTaskStatus = objTStatus;
ShipmentRef_ID = Convert.ToInt32(gridRow.Cells[colShipmentRefID.Name].Value);
ShipmentName = gridRow.Cells[colShipmentName.Name].Value.ToString();
ShipmentIssue = Convert.ToInt32(gridRow.Cells[colIssue.Name].Value.ToString());
ShipmentYear = Convert.ToInt32(gridRow.Cells[colYear.Name].Value.ToString());
AbstractRefNo = gridRow.Cells[colAbstactRefName.Name].Value.ToString();
DialogResult = DialogResult.OK;
this.Close();
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void FillAssignmentGrid()
{
try
{
dgvAssignedTaskPreparation.AutoGenerateColumns = false;
ColTpShipmentId.DataPropertyName = "SHIPMENT_ID";
colTPShipMentName.DataPropertyName = "SHIPMENT_NAME";
colTPAssignedTo.DataPropertyName = "USER_NAME";
colTPAssignedDate.DataPropertyName = "START_DATE";
colTpEndDate.DataPropertyName = "END_DATE";
colTPStatus.DataPropertyName = "DOC_STATUS_NAME";
dgvAssignedTaskPreparation.DataSource = TaskManagementDB.GetDMAssignedTaskPreP(Common.GlobalVariables.UrId);
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void GetUnAssignedShipmentReferencesAndBindToControl()
{
try
{
//TANs on Phase,Shipment,userid and roleid
if (cmbShipment.SelectedItem != null)
{
Cursor = Cursors.WaitCursor;
int shipmentID = Convert.ToInt32(cmbShipment.SelectedValue);
string moduleName = GetSelectedModuleCode();
DataTable dtTANs = TaskManagementDB.GetUnAssignedRefrencesOnShipment(moduleName, shipmentID);
if (dtTANs != null)
{
if (dtTANs.Rows.Count > 0)
{
AvailableRefsTbl = dtTANs;
BindDataToUnAssignedRefsGrid(dtTANs);
}
else
{
AvailableRefsTbl = null;
BindDataToUnAssignedRefsGrid(dtTANs);
}
}
else
{
AvailableRefsTbl = null;
BindDataToUnAssignedRefsGrid(dtTANs);
}
Cursor = Cursors.Default;
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void UpdateUserAssignedTaskStatus(DataGridViewRow gridRow)
{
try
{
if (gridRow != null)
{
string allocStatus = "";
if (GlobalVariables.RoleName.ToUpper() == "ANALYST")
{
allocStatus = gridRow.Cells[colAnalystStatus.Name].Value.ToString();
}
else if (GlobalVariables.RoleName.ToUpper() == "REVIEW ANALYST")
{
allocStatus = gridRow.Cells[colReviewStatus.Name].Value.ToString();
}
else if (GlobalVariables.RoleName.ToUpper() == "QUALITY ANALYST")
{
allocStatus = gridRow.Cells[colQCStatus.Name].Value.ToString();
}
if (allocStatus == "ASSIGNED")
{
TaskStatus taskStatus = new TaskStatus();
taskStatus.Task_ID = Task_ID;
taskStatus.TaskAllocation_ID = TaskAllocation_ID;
taskStatus.Role_ID = GlobalVariables.RoleId;
taskStatus.UR_ID = GlobalVariables.UR_ID;
taskStatus.TaskStatusName = "SET PROGRESS";
//Update User Task Status
TaskManagementDB.UpdateUserTaskStatus(taskStatus);
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void btnAssign_Click(object sender, EventArgs e)
{
try
{
List <int> selRefIDs = GetSelectedRef_IDsFromGrid();
if (selRefIDs != null)
{
if (selRefIDs.Count > 0)
{
string strModule = GetSelectedModuleCode();
int shipmentID = Convert.ToInt32(cmbShipment.SelectedValue);
if (TaskManagementDB.UpdateTaskAssignmentDetails(strModule, shipmentID, teamUserID, selRefIDs))
{
MessageBox.Show("Task assigned successfully", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
//Get UnAssigned TANs
GetUnAssignedShipmentReferencesAndBindToControl();
//Get User Task Counts in the Module
GetUsersTaskCountAndBindToGrid();
//Get Assigned TANs
GetAssignedShipmentRefsAndBindToGrid();
}
else
{
MessageBox.Show("Error in task allication", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void cmbRole_SelectionChangeCommitted(object sender, EventArgs e)
{
try
{
if (cmbRole.SelectedIndex != -1)
{
dgvUserTasks.DataSource = null;
usersTaskCounts = TaskManagementDB.GetUsersTaskCountsOnRole("RA", Convert.ToInt32(cmbRole.SelectedValue));
//Get Users On Role
cmbUsers.DisplayMember = "USER_NAME";
cmbUsers.ValueMember = "UR_ID";
cmbUsers.DataSource = usersTaskCounts.Copy();
BindUsersTaskCountsToGrid(usersTaskCounts);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.Message);
}
}
/// <summary>
/// Handles the SelectionChangeCommitted event of the cmbShipment control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
private void cmbShipment_SelectionChangeCommitted(object sender, EventArgs e)
{
try
{
if (cmbShipment.SelectedIndex != -1)
{
if (cmbShipment.SelectedItem != null)
{
int.TryParse(cmbShipment.SelectedValue.ToString(), out shipmentID);
//shipmentID = Convert.ToInt32(cmbShipment.SelectedValue);
if (shipmentID > 0)
{
DataTable dtShipmentRefs = TaskManagementDB.GetTaskPreparationRefsOnShipment(shipmentID);
if (dtShipmentRefs != null)
{
//Bind Data to Task Preparation
DataView dvTaskPrep = dtShipmentRefs.DefaultView;
dvTaskPrep.RowFilter = "VALIDATION_STATUS = 'N'";
DataTable dtTaskPrep = dvTaskPrep.ToTable();
BindShipmentTasksToGrid(dtTaskPrep);
//Bind Data to Task Preparation
DataView dvTaskValid = dtShipmentRefs.DefaultView;
dvTaskValid.RowFilter = "VALIDATION_STATUS = 'Y'";
DataTable dtTaskValid = dvTaskValid.ToTable();
BindValidatedShipmentTasksToGrid(dtTaskValid);
}
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void btnCancelTask_Click(object sender, EventArgs e)
{
try
{
string strErr = string.Empty;
List <int> lstCancelTaskIDs = GetSelectedTaskIDsForCancellation();
if (lstCancelTaskIDs.Count > 0)
{
DialogResult diaRes = MessageBox.Show("Do you want to cancel the selected references?", GlobalVariables.MessageCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (diaRes == System.Windows.Forms.DialogResult.Yes)
{
if (TaskManagementDB.CancelTaskAssignment(lstCancelTaskIDs))
{
_headerCheckBox.Checked = false;
usersTaskCounts = TaskManagementDB.GetUsersTaskCountsOnRole("RA", Convert.ToInt32(cmbRole.SelectedValue));
BindUsersTaskCountsToGrid(usersTaskCounts);
//Refresh User tasks
cmbUsers_SelectionChangeCommitted(null, null);
MessageBox.Show("References cancelled successfully", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
else
{
MessageBox.Show("No References selected for cancellation", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void cmbUsers_SelectionChangeCommitted(object sender, EventArgs e)
{
try
{
if (cmbUsers.SelectedIndex != -1)
{
userAssignedRefs = TaskManagementDB.GetUserAssignedTasks(Convert.ToInt32(cmbUsers.SelectedValue));
{
if (userAssignedRefs.Rows.Count > 0)
{
if (_headerCheckBox != null)
{
_headerCheckBox.Enabled = false;
_headerCheckBox.Checked = false;
}
dgvUserTasks.AutoGenerateColumns = false;
dgvUserTasks.DataSource = userAssignedRefs;
if (_headerCheckBox != null)
{
_headerCheckBox.Enabled = true;
}
_totalCheckBoxes = dgvUserTasks.RowCount;
_totalCheckedCheckBoxes = 0;
}
else
{
dgvUserTasks.DataSource = null;
}
}
//Bind user Task Counts to Grid
BindUsersTaskCountsToGrid(usersTaskCounts);
//if (usersTaskCounts.Rows.Count > 0)
//{
// DataView dvTemp = usersTaskCounts.Copy().DefaultView;
// dvTemp.RowFilter = "UR_ID NOT IN ( " + Convert.ToInt32(cmbUsers.SelectedValue) + " )";
// DataTable dtResult = dvTemp.ToTable();
// if (dtResult != null)
// {
// if (dtResult.Rows.Count > 0)
// {
// dgvReallocateToUser.AutoGenerateColumns = false;
// dgvReallocateToUser.DataSource = dtResult;
// }
// else
// {
// dgvReallocateToUser.DataSource = null;
// }
// }
//}
//else
//{
// dgvReallocateToUser.DataSource = null;
//}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.Message);
}
}
private void loadTaskTSMenuItem_Click(object sender, EventArgs e)
{
try
{
DataTable dtAssignedTans = TaskManagementDB.GetUserTasksOnModule(GlobalVariables.UR_ID, GlobalVariables.Module);
if (GlobalVariables.Module == "RA")
{
using (frmTaskSheet usrTaskSheet = new frmTaskSheet())
{
usrTaskSheet.AssignedTANs = dtAssignedTans;
if (usrTaskSheet.ShowDialog() == DialogResult.OK)
{
if (usrTaskSheet.DocType == "ABSTRACT")
{
frmReactionCuration absCuration = new frmReactionCuration();
absCuration.TaskID = usrTaskSheet.Task_ID;
absCuration.TaskAllocationID = usrTaskSheet.TaskAllocation_ID;
absCuration.ShipmentRefID = usrTaskSheet.ShipmentRef_ID;
absCuration.AbstractRefNo = usrTaskSheet.SelectedRef;
sslblRefName.Text = usrTaskSheet.SelectedRef;
sslblShipment.Text = usrTaskSheet.ShipmentName;
absCuration.MdiParent = this;
absCuration.Show();
}
else if (usrTaskSheet.DocType == "JOURNAL")
{
frmReactionCuration_Journal journlCuration = new frmReactionCuration_Journal();
journlCuration.TaskID = usrTaskSheet.Task_ID;
journlCuration.TaskAllocationID = usrTaskSheet.TaskAllocation_ID;
journlCuration.ShipmentRefID = usrTaskSheet.ShipmentRef_ID;
journlCuration.AbstractRefNo = usrTaskSheet.SelectedRef;
sslblRefName.Text = usrTaskSheet.SelectedRef;
sslblShipment.Text = usrTaskSheet.ShipmentName;
journlCuration.MdiParent = this;
journlCuration.Show();
}
}
}
}
// Task Preparation users task sheet.
else if (GlobalVariables.Module == "TP")
{
using (TaskSheets.FrmTaskSheetTP taskSheet = new TaskSheets.FrmTaskSheetTP())
{
taskSheet.UserTasks = dtAssignedTans;
if (taskSheet.ShowDialog() == DialogResult.OK)
{
if (taskSheet.userTaskStatus.Task_ID > 0)
{
GlobalVariables.TaskId = taskSheet.userTaskStatus.Task_ID;
FrmPdfGererationOnAbstract objTaskPrepare = new FrmPdfGererationOnAbstract();
objTaskPrepare.TaskID = taskSheet.userTaskStatus.Task_ID;
objTaskPrepare.TaskAllocationID = taskSheet.userTaskStatus.TaskAllocation_ID;
objTaskPrepare.Shipment_Name = taskSheet.ShipmentName;
objTaskPrepare.ShipmentYear = taskSheet.ShipmentYear;
objTaskPrepare.ShipmentIssue = taskSheet.ShipmentIssue;
objTaskPrepare.Abstract_RefNo = taskSheet.AbstractRefNo;
objTaskPrepare.ShipmentRefID = taskSheet.ShipmentRef_ID;
objTaskPrepare.MdiParent = this;
objTaskPrepare.Show();
}
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}