public void Load() { var sql = string.Format("SELECT * FROM Configuration WITH (NOLOCK) " + "WHERE [Key] = '{0}' OR [Key]= '{1}'", "Offline:Status", "Offline:ManualOverrideEnabled"); _configs = _customerPaymentsConnection.Exec <OfflineConfig>(sql); }
public void Load() { var sql = string.Format("SELECT * FROM logging.CustomerPayments_log WITH (NOLOCK) " + "WHERE Date BETWEEN '{0}' AND '{1}' " + "ORDER BY Date DESC", DateTime.Now.FormattedMins(-Constants.TimeoutDuration), DateTime.Now.Formatted()); _logs = _connectionCreator.Exec <Log>(sql); }
public void Load() { var sql = string.Format("SELECT * FROM Payment WITH (NOLOCK) " + "WHERE CreationDateTime BETWEEN '{0}' AND '{1}' " + "ORDER BY CreationDateTime", DateTime.Now.FormattedMins(-Constants.TimeoutDuration), DateTime.Now.Formatted()); _payments = _connectionCreator.Exec <Payment>(sql); }
public IEnumerable <Notification> GetNotificationsForLast(int duration) { var sql = string.Format("SELECT * FROM NotificationMessageStore WITH (NOLOCK) " + "WHERE CreateDateTime BETWEEN '{0}' AND '{1}' " + "ORDER BY CreateDateTime", DateTime.Now.FormattedMins(-duration), DateTime.Now.Formatted()); return(_connectionCreator.Exec <Notification>(sql)); }
public void Load() { var sqlQuery = CreateSqlQuery(); _summary = _connectionCreator.Exec <SystemEventSummary>(sqlQuery); }
public void Load() { _summary = _connectionCreator.Exec <ErrorSummary>(_sql); }