private static void CreateLeaveApplication(DatabaseConnection dbConn, EAttendanceRecord attendanceRecord)
{
if (attendanceRecord.LeaveAppID > 0)
{
ELeaveApplication leaveApp = new ELeaveApplication();
leaveApp.LeaveAppID = attendanceRecord.LeaveAppID;
if (!ELeaveApplication.db.select(dbConn, leaveApp))
{
attendanceRecord.LeaveAppID = 0;
}
}
// Check LeaveAppID <= 0 To prevent override LeaveAppID created by external function
if (attendanceRecord.RosterCodeID > 0 && attendanceRecord.LeaveAppID <= 0)
{
ERosterCode rosterCode = new ERosterCode();
rosterCode.RosterCodeID = attendanceRecord.RosterCodeID;
if (ERosterCode.db.select(dbConn, rosterCode))
{
if (rosterCode.RosterCodeType.Equals(ERosterCode.ROSTERTYPE_CODE_LEAVE) && rosterCode.LeaveCodeID > 0)
{
ELeaveCode leaveCode = new ELeaveCode();
leaveCode.LeaveCodeID = rosterCode.LeaveCodeID;
if (ELeaveCode.db.select(dbConn, leaveCode))
{
ELeaveApplication leaveApp = ELeaveApplication.GetOrCreateSingleDayLeaveApplicationObject(dbConn, attendanceRecord.EmpID, rosterCode.LeaveCodeID, attendanceRecord.AttendanceRecordDate);
if (leaveApp != null)
{
if (leaveApp.LeaveAppID <= 0)
{
ELeaveApplication.db.insert(dbConn, leaveApp);
attendanceRecord.LeaveAppID = leaveApp.LeaveAppID;
}
}
}
}
else if (rosterCode.RosterCodeType.Equals(ERosterCode.ROSTERTYPE_CODE_RESTDAY))
{
ELeaveBalance.DeleteLeaveBalanceAfter(dbConn, attendanceRecord.EmpID, ELeaveType.RESTDAY_LEAVE_TYPE(dbConn).LeaveTypeID, attendanceRecord.AttendanceRecordDate);
}
else if (rosterCode.RosterCodeType.Equals(ERosterCode.ROSTERTYPE_CODE_STATUTORYHOLIDAY))
{
ELeaveBalance.DeleteLeaveBalanceAfter(dbConn, attendanceRecord.EmpID, ELeaveType.STATUTORYHOLIDAY_LEAVE_TYPE(dbConn).LeaveTypeID, attendanceRecord.AttendanceRecordDate);
}
else if (rosterCode.RosterCodeType.Equals(ERosterCode.ROSTERTYPE_CODE_PUBLICHOLIDAY))
{
ELeaveBalance.DeleteLeaveBalanceAfter(dbConn, attendanceRecord.EmpID, ELeaveType.PUBLICHOLIDAY_LEAVE_TYPE(dbConn).LeaveTypeID, attendanceRecord.AttendanceRecordDate);
}
}
}
}
private static void DeleteLeaveApplication(DatabaseConnection dbConn, EAttendanceRecord attendanceRecord)
{
if (attendanceRecord.LeaveAppID > 0)
{
ERosterCode rosterCode = new ERosterCode();
rosterCode.RosterCodeID = attendanceRecord.RosterCodeID;
if (ERosterCode.db.select(dbConn, rosterCode))
{
ELeaveApplication leaveApp = new ELeaveApplication();
leaveApp.LeaveAppID = attendanceRecord.LeaveAppID;
if (ELeaveApplication.db.select(dbConn, leaveApp))
{
if (leaveApp.EmpPayrollID <= 0 &&
rosterCode.LeaveCodeID.Equals(leaveApp.LeaveCodeID) &&
attendanceRecord.AttendanceRecordDate.Equals(leaveApp.LeaveAppDateFrom) &&
attendanceRecord.AttendanceRecordDate.Equals(leaveApp.LeaveAppDateTo)
)
{
//ELeaveCode leaveCode = new ELeaveCode();
//leaveCode.LeaveCodeID = leaveApp.LeaveCodeID;
//if (ELeaveCode.db.select(dbConn, leaveCode))
ELeaveApplication.db.delete(dbConn, leaveApp);
}
}
}
}
if (attendanceRecord.RosterCodeID > 0 && attendanceRecord.LeaveAppID <= 0)
{
ERosterCode rosterCode = new ERosterCode();
rosterCode.RosterCodeID = attendanceRecord.RosterCodeID;
if (ERosterCode.db.select(dbConn, rosterCode))
{
if (rosterCode.RosterCodeType.Equals(ERosterCode.ROSTERTYPE_CODE_RESTDAY))
{
ELeaveBalance.DeleteLeaveBalanceAfter(dbConn, attendanceRecord.EmpID, ELeaveType.RESTDAY_LEAVE_TYPE(dbConn).LeaveTypeID, attendanceRecord.AttendanceRecordDate);
}
else if (rosterCode.RosterCodeType.Equals(ERosterCode.ROSTERTYPE_CODE_STATUTORYHOLIDAY))
{
ELeaveBalance.DeleteLeaveBalanceAfter(dbConn, attendanceRecord.EmpID, ELeaveType.STATUTORYHOLIDAY_LEAVE_TYPE(dbConn).LeaveTypeID, attendanceRecord.AttendanceRecordDate);
}
else if (rosterCode.RosterCodeType.Equals(ERosterCode.ROSTERTYPE_CODE_PUBLICHOLIDAY))
{
ELeaveBalance.DeleteLeaveBalanceAfter(dbConn, attendanceRecord.EmpID, ELeaveType.PUBLICHOLIDAY_LEAVE_TYPE(dbConn).LeaveTypeID, attendanceRecord.AttendanceRecordDate);
}
}
}
}
protected override void beforeUpdate(DatabaseConnection dbConn, DBManager db)
{
base.beforeUpdate(dbConn, db);
// trigger on beforeUpdate for updating AttendanceRecord.LeaveAppID before saving to database
if (oldValueObject != null)
{
EAttendanceRecord oldAttendanceRecord = (EAttendanceRecord)oldValueObject;
if (oldAttendanceRecord.RosterCodeID != this.RosterCodeID)
{
DeleteLeaveApplication(dbConn, oldAttendanceRecord);
CreateLeaveApplication(dbConn, this);
}
}
else
{
CreateLeaveApplication(dbConn, this);
}
}
