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