public List <Transaction> GetTransactionsBySku(string sku) { MongoDal mongoDal = new MongoDal(transactionsCollectionName, configuration); List <Transaction> transactions = mongoDal.GetWhere <Transaction>(o => o.Sku == sku).ToList(); return(transactions); }
public List <string> ListSkus() { MongoDal mongoDal = new MongoDal(transactionsCollectionName, configuration); List <string> skus = mongoDal.GetQueryable <Transaction>().Select(o => o.Sku).Distinct().OrderBy(o => o).ToList(); return(skus); }
public void RefreshTransactions(List <Transaction> transactions) { MongoDal mongoDal = new MongoDal(transactionsCollectionName, configuration); mongoDal.DeleteAll <Transaction>(); mongoDal.AddList <Transaction>(transactions); }
public async Task <List <Transaction> > ListTransactions() { List <Transaction> transactions = new List <Transaction>(); try { // string jsonTransactions = @"[ // { 'sku': 'T2006', 'amount': '10.00', 'currency': 'USD' }, // { 'sku': 'M2007', 'amount': '34.57', 'currency': 'CAD' }, // { 'sku': 'R2008', 'amount': '17.95', 'currency': 'USD' }, // { 'sku': 'T2006', 'amount': '7.63', 'currency': 'EUR' }, // { 'sku': 'B2009', 'amount': '21.23', 'currency': 'USD' } // ]"; string jsonTransactions = await client.GetStringAsync(transactionsUrl); transactions = JsonConvert.DeserializeObject <List <Transaction> >(jsonTransactions); } catch (Exception) { MongoDal mongoDal = new MongoDal(transactionsCollectionName, configuration); transactions = mongoDal.GetList <Transaction>(); } return(transactions); }
public void InsertOrUpdateRates(List <CurrencyConvertion> rates) { MongoDal mongoDal = new MongoDal(ratesCollectionName, configuration); foreach (CurrencyConvertion rate in rates) { CurrencyConvertion existentRate = mongoDal.GetWhere <CurrencyConvertion>(o => o.From == rate.From && o.To == rate.To).FirstOrDefault(); if (existentRate == null) { mongoDal.AddObject <CurrencyConvertion>(rate); } else { existentRate.Rate = rate.Rate; mongoDal.UpadeteObject <CurrencyConvertion>(existentRate); } } }
public async Task <List <CurrencyConvertion> > ListRates() { List <CurrencyConvertion> rates = new List <CurrencyConvertion>(); try { // string jsonRates = @"[ // { 'from': 'EUR', 'to': 'USD', 'rate': '1.359' }, // { 'from': 'CAD', 'to': 'EUR', 'rate': '0.732' }, // { 'from': 'USD', 'to': 'EUR', 'rate': '0.736' }, // { 'from': 'EUR', 'to': 'CAD', 'rate': '1.366' } // ]"; string jsonRates = await client.GetStringAsync(ratesUrl); rates = JsonConvert.DeserializeObject <List <CurrencyConvertion> >(jsonRates); } catch (Exception) { MongoDal mongoDal = new MongoDal(ratesCollectionName, configuration); rates = mongoDal.GetList <CurrencyConvertion>(); } return(rates); }
public MongoBll() { _dal = new MongoDal <T>(); }