/// <summary> /// Retrieves all the PartnerReminders that need to be processed. /// </summary> /// <param name="ALastReminderDate">Date when PartnerReminders processing last ran.</param> /// <param name="APartnerReminderDT">PartnerReminders DataRows that need to be processed.</param> /// <param name="ADBAccessObj">Already instatiated DB Access object with opened DB connection.</param> /// <param name="AReadTransaction">Already instantiated DB Transaction.</param> /// <returns>DataSet containing the <paramref name="APartnerReminderDT" /> DataTable.</returns> private static DataSet GetRemindersToProcess(DateTime ALastReminderDate, out PPartnerReminderTable APartnerReminderDT, TDataBase ADBAccessObj, TDBTransaction AReadTransaction) { List <OdbcParameter> OdbcParams; string SQLCommand; // Add Typed DataTable to a DataSet so we get the Partner Reminders in a Typed DataTable APartnerReminderDT = new PPartnerReminderTable(); DataSet ReminderResultsDS = new DataSet(); ReminderResultsDS.Tables.Add(APartnerReminderDT); SQLCommand = "SELECT * FROM PUB_p_partner_reminder WHERE "; SQLCommand += " ( p_next_reminder_date_d > ? OR p_last_reminder_sent_d IS NULL) AND "; SQLCommand += " p_next_reminder_date_d <= ? AND "; SQLCommand += " p_reminder_active_l = TRUE AND "; SQLCommand += " p_email_address_c <> ''"; OdbcParams = new List <OdbcParameter>(); // Parameter 1 = LastReminderDate from SystemDefaults OdbcParams.Add(new OdbcParameter("LastDate", OdbcType.Date)); OdbcParams[0].Value = ALastReminderDate.Date; // Parameter 2 = Today's date OdbcParams.Add(new OdbcParameter("Now", OdbcType.Date)); OdbcParams[1].Value = DateTime.Now.Date; DBAccess.GDBAccessObj.Select(ReminderResultsDS, SQLCommand, APartnerReminderDT.TableName, AReadTransaction, OdbcParams.ToArray()); // Mark the data as being 'unchanged' (rather than 'new', which it is by default) ReminderResultsDS.AcceptChanges(); return(ReminderResultsDS); }
/// <summary> /// Retrieves all the PartnerReminders that need to be processed. /// </summary> /// <param name="ALastReminderDate">Date when PartnerReminders processing last ran.</param> /// <param name="APartnerReminderDT">PartnerReminders DataRows that need to be processed.</param> /// <param name="ADBAccessObj">Already instatiated DB Access object with opened DB connection.</param> /// <param name="AReadTransaction">Already instantiated DB Transaction.</param> /// <returns>DataSet containing the <paramref name="APartnerReminderDT" /> DataTable.</returns> private static DataSet GetRemindersToProcess(DateTime ALastReminderDate, out PPartnerReminderTable APartnerReminderDT, TDataBase ADBAccessObj, TDBTransaction AReadTransaction) { List <OdbcParameter>OdbcParams; string SQLCommand; // Add Typed DataTable to a DataSet so we get the Partner Reminders in a Typed DataTable APartnerReminderDT = new PPartnerReminderTable(); DataSet ReminderResultsDS = new DataSet(); ReminderResultsDS.Tables.Add(APartnerReminderDT); SQLCommand = "SELECT * FROM PUB_p_partner_reminder WHERE "; SQLCommand += " ( p_next_reminder_date_d > ? OR p_last_reminder_sent_d IS NULL) AND "; SQLCommand += " p_next_reminder_date_d <= ? AND "; SQLCommand += " p_reminder_active_l = TRUE AND "; SQLCommand += " p_email_address_c <> ''"; OdbcParams = new List <OdbcParameter>(); // Parameter 1 = LastReminderDate from SystemDefaults OdbcParams.Add(new OdbcParameter("LastDate", OdbcType.Date)); OdbcParams[0].Value = ALastReminderDate.Date; // Parameter 2 = Today's date OdbcParams.Add(new OdbcParameter("Now", OdbcType.Date)); OdbcParams[1].Value = DateTime.Now.Date; DBAccess.GDBAccessObj.Select(ReminderResultsDS, SQLCommand, APartnerReminderDT.TableName, AReadTransaction, OdbcParams.ToArray()); // Mark the data as being 'unchanged' (rather than 'new', which it is by default) ReminderResultsDS.AcceptChanges(); return ReminderResultsDS; }