//----------------------------------------------------------------------------------------------------------------
public static IEnumerable <AD_GPO_Users> PrintUsersToConsole()
{
List <AD_GPO_Users> item = db.Query <AD_GPO_Users>("SELECT TOP 10 * FROM AD_GPO_Users").ToList();
foreach (AD_GPO_Users breach in item)
{
Console.WriteLine(breach);
}
return(item);
}
//----------------------------------------------------------------------------------------------------------------
public static IEnumerable <Breach> PrintBreachesToConsole()
{
List <Breach> item = db.Query <Breach>("select * from Breach").ToList();
foreach (Breach breach in item)
{
Console.WriteLine(breach);
}
return(item);
}
//----------------------------------------------------------------------------------------------------------------
public static IEnumerable <Breached_Emails> PrintBreachedEmailsToConsole()
{
List <Breached_Emails> item = db.Query <Breached_Emails>("SELECT * FROM Breached_Emails").ToList();
foreach (Breached_Emails breach in item)
{
Console.WriteLine(breach);
}
return(item);
}
public IEnumerable <CurrencyExchangeRateDto> CurrencyExchangeRateList(DateTime date)
{
IEnumerable <CurrencyExchangeRateDto> result;
using (NPoco.IDatabase dbContext = new NPoco.Database(DTO.Global.SQLConnectionString, NPoco.DatabaseType.SqlServer2012))
{
result = dbContext.Query <DTO.Database.CurrencyExchangeRateDto>("SELECT * FROM tbl_CurrencyExchangeRate WHERE CurrencyExchangeRateShortDate = " + Helper.DateHelper.ShortDate(date));
}
return(result);
}