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