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