public static void GenerateInboxMessage(DatabaseConnection dbConn, int UserID) { EUserReminderOption userReminderOption; if (EUserReminderOption.IsUserGenerateReminder(dbConn, UserID, EInbox.INBOX_TYPE_DATE_OF_BIRTH_18, out userReminderOption)) { Generate18AgeInboxMessage(dbConn, UserID, userReminderOption.UserReminderOptionRemindDaysBefore, userReminderOption.UserReminderOptionRemindDaysAfter); } if (EUserReminderOption.IsUserGenerateReminder(dbConn, UserID, EInbox.INBOX_TYPE_DATE_OF_BIRTH_65, out userReminderOption)) { Generate65AgeInboxMessage(dbConn, UserID, userReminderOption.UserReminderOptionRemindDaysBefore, userReminderOption.UserReminderOptionRemindDaysAfter); } if (EUserReminderOption.IsUserGenerateReminder(dbConn, UserID, EInbox.INBOX_TYPE_DATE_OF_BIRTH, out userReminderOption)) { GenerateBirthdayInboxMessage(dbConn, UserID, userReminderOption.UserReminderOptionRemindDaysBefore, userReminderOption.UserReminderOptionRemindDaysAfter); } if (EUserReminderOption.IsUserGenerateReminder(dbConn, UserID, EInbox.INBOX_TYPE_PROBATION, out userReminderOption)) { GenerateProbationInboxMessage(dbConn, UserID, userReminderOption.UserReminderOptionRemindDaysBefore, userReminderOption.UserReminderOptionRemindDaysAfter); } if (EUserReminderOption.IsUserGenerateReminder(dbConn, UserID, EInbox.INBOX_TYPE_TERMINATION, out userReminderOption)) { GenerateTerminationInboxMessage(dbConn, UserID, userReminderOption.UserReminderOptionRemindDaysBefore, userReminderOption.UserReminderOptionRemindDaysAfter); } if (EUserReminderOption.IsUserGenerateReminder(dbConn, UserID, EInbox.INBOX_TYPE_WORKPERMITEXPIRY, out userReminderOption)) { GenerateWorkPermitExpiryInboxMessage(dbConn, UserID, userReminderOption.UserReminderOptionRemindDaysBefore, userReminderOption.UserReminderOptionRemindDaysAfter); } }
public static bool IsUserGenerateReminder(DatabaseConnection dbConn, int UserID, string ReminderTypeCode, out EUserReminderOption userReminderOption) { DBFilter reminderTypeFilter = new DBFilter(); reminderTypeFilter.add(new Match("ReminderTypeCode", ReminderTypeCode)); DBFilter filter = new DBFilter(); filter.add(new IN("ReminderTypeID", "Select ReminderTypeID from " + EReminderType.db.dbclass.tableName, reminderTypeFilter)); filter.add(new Match("UserID", UserID)); ArrayList list = EUserReminderOption.db.select(dbConn, filter); if (list.Count > 0) { userReminderOption = (EUserReminderOption)list[0]; return(true); } else { userReminderOption = null; return(false); } }