Exemple #1
0
 private void RenewRates(Currency currencies, DateTime date)
 {
     using (SolidContext sc = new SolidContext())
     {
         Currency cur  = sc.Currencies.Include("Rates").Where(c => c.CharCode == currencies.CharCode).FirstOrDefault();
         Rate     rate = cur.Rates.Where(d => d.Date == date.Date).FirstOrDefault();
         if (cur.Rates.Count() == 0 | rate == null)
         {
             foreach (var item in currencies.Rates)
             {
                 item.CurrencyID = cur;
                 sc.Rates.Add(item);
             }
             sc.SaveChanges();
         }
         else
         {
             foreach (Rate item in currencies.Rates)
             {
                 rate.Value = item.Value;
                 sc.SaveChanges();
             }
         }
     }
 }
Exemple #2
0
 public void SaveCurrency(Currency currencies)
 {
     using (SolidContext sc = new SolidContext())
     {
         Currency cur = (from c in sc.Currencies
                         where c.CharCode == currencies.CharCode
                         select c).SingleOrDefault();
         if (cur == null)
         {
             sc.Currencies.Add(currencies);
             sc.SaveChanges();
         }
         else
         {
             RenewRates(currencies, currencies.Rates.Single().Date);
         }
     }
 }