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