예제 #1
0
            //----------------------------------------------------------------------------------------------------------------
            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);
            }
예제 #2
0
            //----------------------------------------------------------------------------------------------------------------
            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);
            }
예제 #3
0
            //----------------------------------------------------------------------------------------------------------------
            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);
            }
예제 #4
0
        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);
        }