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