public async Task <List <KomBankRatesLine> > GetSomeLastDaysForBank(string bankTitle, int days) { await using BanksListenerContext db = new BanksListenerContext(_dbPath); return(db.KomBankRates .Where(r => r.Bank == bankTitle.ToUpper() && r.LastCheck > DateTime.Now.AddDays(-days)) .OrderByDescending(l => l.LastCheck) .ToList()); }
public async Task <KomBankRatesLine> GetLastForEvery(string bankTitle) { await using BanksListenerContext db = new BanksListenerContext(_dbPath); return(db.KomBankRates .OrderByDescending(l => l.LastCheck) .FirstOrDefault(r => r.Bank == bankTitle.ToUpper())); }
public async Task <List <BelStockArchiveOneCurrencyDay> > GetBelstockArchive(int portion) { int portionSize = _iniFile.Read(IniSection.General, IniKey.BelstockPortionSize, 100); await using BanksListenerContext db = new BanksListenerContext(_dbPath); return(db.BelStockArchive.OrderBy(l => l.Date) .Skip(portion * portionSize) .Take(portionSize) .ToList()); }
public async Task <List <KomBankRatesLine> > Get() { _logFile.AppendLine("Used to check in browser. Type http://localhost:11082/bali "); await using BanksListenerContext db = new BanksListenerContext(_dbPath); var result = new List <KomBankRatesLine>(); foreach (var komBank in (KomBankE[])Enum.GetValues(typeof(KomBankE))) { result.Add(await db.KomBankRates .Where(r => r.Bank == komBank.ToString().ToUpper()) .OrderByDescending(l => l.LastCheck) .FirstOrDefaultAsync()); } return(result); }