public static Boolean makeRejection(TNF tnf, User approver, Notification noti, string reason)
{
//check TNF status
if (!tnf.getStatus().ToLower().Equals("pending"))
{
return(false);
}
Workflow currentWorkflow = tnf.getWorkflow();
Department currentDept = deptDAO.getDeptByName(tnf.getUser().getDepartment());
Course currentCourse = tnfDAO.getCourseFromTNF(tnf.getTNFID());
double courseCost = currentCourse.getPrice();
// if bond exist, reject the bond
double bondCriteria = currentWorkflow.getBondCriteria();
if (currentCourse.getPrice() >= bondCriteria)
{
Bonds currentBond = bondDAO.getBondByTNFIDandUserID(tnf.getTNFID(), tnf.getUser().getUserID());
bondDAO.updateBondStatus(currentBond.getBondID(), "rejected");
}
//Handle Notification, update status, date and reason
//If its HR, reject for all HR
List <User> allHR = userDAO.getAllHR();
List <Notification> allHRNotification = new List <Notification>();
foreach (User hr in allHR)
{
allHRNotification.Add(notificationDAO.getPendingNotificationByTnfIDandUserID(tnf.getTNFID(), hr.getUserID()));
}
allHRNotification = allHRNotification.Where(x => x != null).ToList();
if (allHRNotification.Count < 2)
{
notificationDAO.updateNotificationStatus(noti.getNotificationID(), "rejected");
notificationDAO.updateNotificationApprovedDate(noti.getNotificationID());
if (reason != null)
{
notificationDAO.updateNotificationRemarks(noti.getNotificationID(), reason);
}
}
else
{
foreach (Notification hrNoti in allHRNotification)
{
notificationDAO.updateNotificationStatus(hrNoti.getNotificationID(), "rejected");
notificationDAO.updateNotificationApprovedDate(hrNoti.getNotificationID());
if (reason != null)
{
notificationDAO.updateNotificationRemarks(hrNoti.getNotificationID(), reason);
}
}
}
//Update TNF status
tnfDAO.updateTNFStatus(tnf.getTNFID(), "rejected");
return(true);
}
public static Boolean makeApproval(TNF tnf, User user, Notification noti, string remarks)
{
//check TNF status
if (!tnf.getStatus().ToLower().Equals("pending"))
{
return(false);
}
//check budget
Department currentDept = deptDAO.getDeptByName(tnf.getUser().getDepartment());
Course currentCourse = tnfDAO.getCourseFromTNF(tnf.getTNFID());
double courseCost = currentCourse.getPrice();
Boolean gotBudget = deptDAO.checkDeptBudget(currentDept.getDeptName(), currentCourse.getPrice());
int nextWFLevel = 0;
if (!gotBudget)
{
return(false);
}
//check if approver is last in chain
Boolean isLastApprover = false;
Workflow currentWorkflow = tnf.getWorkflow();
WorkflowSub currentWFS = tnf.getWorkflowSub();
WorkflowApprover nextApprover = new WorkflowApprover();
WorkflowApprover lastApprover = wfaDAO.getLastApproverInChain(currentWorkflow.getWorkflowID(), currentWFS.getWorkflowSubID());
List <WorkflowApprover> approvers = wfaDAO.getSortedWorkflowApprovers(currentWorkflow.getWorkflowID(), currentWFS.getWorkflowSubID());
if (user.getJobCategory().Contains(lastApprover.getJobCategory()))
{
isLastApprover = true;
}
else if (lastApprover.getJobCategory().Equals("superior"))
{
User currentTNFUser = tnf.getUser();
if (currentTNFUser.getSupervisor().Equals(user.getUserID()))
{
isLastApprover = true;
}
}
else
{
int levelOfUser = wfaDAO.getLevelByJobCategory(user.getJobCategory(), currentWorkflow.getWorkflowID(), currentWFS.getWorkflowSubID());
if (levelOfUser == -1)
{
nextApprover = lastApprover;
nextWFLevel = lastApprover.getLevel();
}
else
{
nextApprover = approvers[levelOfUser + 1];
nextWFLevel = levelOfUser + 1;
}
}
//If its HR, approve for all HR
List <User> allHR = userDAO.getAllHR();
List <Notification> allHRNotification = new List <Notification>();
foreach (User hr in allHR)
{
allHRNotification.Add(notificationDAO.getPendingNotificationByTnfIDandUserID(tnf.getTNFID(), hr.getUserID()));
}
allHRNotification = allHRNotification.Where(x => x != null).ToList();
if (allHRNotification.Count < 2)
{
if (isLastApprover)
{
notificationDAO.updateNotificationStatus(noti.getNotificationID(), "approved");
notificationDAO.updateNotificationApprovedDate(noti.getNotificationID());
if (remarks != null)
{
notificationDAO.updateNotificationRemarks(noti.getNotificationID(), remarks);
}
tnfDAO.updateTNFStatus(tnf.getTNFID(), "approved");
deptDAO.updateDeptBudget(currentDept.getDeptName(), (currentDept.getActualBudget() - currentCourse.getPrice()));
double bondCriteria = currentWorkflow.getBondCriteria();
if (currentCourse.getPrice() >= bondCriteria)
{
Bonds currentBond = bondDAO.getBondByTNFIDandUserID(tnf.getTNFID(), tnf.getUser().getUserID());
bondDAO.updateBondStatus(currentBond.getBondID(), "approved");
}
}
else
{
notificationDAO.updateNotificationStatus(noti.getNotificationID(), "approved");
notificationDAO.updateNotificationApprovedDate(noti.getNotificationID());
if (remarks != null)
{
notificationDAO.updateNotificationRemarks(noti.getNotificationID(), remarks);
}
tnfDAO.updateTNFWFStatus(tnf.getTNFID(), nextWFLevel);
tnf = tnfDAO.getIndividualTNFByID(tnf.getUser().getUserID(), tnf.getTNFID());
Workflow_Route.sendApprovalNotification(tnf, nextApprover);
}
}
else
{
if (isLastApprover)
{
foreach (Notification hrNoti in allHRNotification)
{
notificationDAO.updateNotificationStatus(hrNoti.getNotificationID(), "approved");
notificationDAO.updateNotificationApprovedDate(hrNoti.getNotificationID());
if (remarks != null)
{
notificationDAO.updateNotificationRemarks(noti.getNotificationID(), remarks);
}
}
tnfDAO.updateTNFStatus(tnf.getTNFID(), "approved");
deptDAO.updateDeptBudget(currentDept.getDeptName(), (currentDept.getActualBudget() - currentCourse.getPrice()));
double bondCriteria = currentWorkflow.getBondCriteria();
if (currentCourse.getPrice() >= bondCriteria)
{
Bonds currentBond = bondDAO.getBondByTNFIDandUserID(tnf.getTNFID(), tnf.getUser().getUserID());
bondDAO.updateBondStatus(currentBond.getBondID(), "approved");
}
}
else
{
foreach (Notification hrNoti in allHRNotification)
{
notificationDAO.updateNotificationStatus(hrNoti.getNotificationID(), "approved");
notificationDAO.updateNotificationApprovedDate(hrNoti.getNotificationID());
if (remarks != null)
{
notificationDAO.updateNotificationRemarks(noti.getNotificationID(), remarks);
}
}
tnfDAO.updateTNFWFStatus(tnf.getTNFID(), nextWFLevel);
tnf = tnfDAO.getIndividualTNFByID(tnf.getUser().getUserID(), tnf.getTNFID());
Workflow_Route.sendApprovalNotification(tnf, nextApprover);
}
}
return(true);
}