public void GetGlobalMarketView()
        {
            HttpRequestClient client = new HttpRequestClient();
            var obj = client.GetGlobalMarketView();

            tblGlobalMarketView gmv = new tblGlobalMarketView();

            Guid guid = Guid.NewGuid();

            gmv = new tblGlobalMarketView()
            {
                ID                            = guid,
                ActiveAssets                  = Utlity.ParseInt(obj.ActiveAssets),
                ActiveCurrencies              = Utlity.ParseInt(obj.ActiveCurrencies),
                ActiveMarkets                 = Utlity.ParseInt(obj.ActiveMarkets),
                BTCPercentageofMarketCap      = Utlity.ParseDouble(obj.BTCPercentageOfMarketCap),
                LastUpdated                   = obj.LastUpdated,
                TimeStamp                     = DateTime.Now,
                Total24HVolumeConvertCurrency = Utlity.ParseDecimal(obj.Total24hVolumeConvertCurrency),
                Total24HVolumeUSD             = Utlity.ParseDecimal(obj.Total24hVolumeUSD),
                TotalMarketCapConvertCurrency = Utlity.ParseDecimal(obj.TotalMarketCapConvertCurrency),
                TotalMarketCapUSD             = Utlity.ParseDecimal(obj.TotalMarketCapUSD),
                TransactionID                 = guid.ToString().GetHashCode()
            };

            CurrencyDataContext.InsertGlobalMarketView(gmv);
        }
        public void GetAllCurrenciesAndUpdate()
        {
            //For each JSON call there will be transaction ID associated with it
            var restTransactionID = Guid.NewGuid().GetHashCode();

            try
            {
                HttpRequestClient client = new HttpRequestClient();
                var freshCurrencies      = client.GetCurrencies();

                tblCurrencyMarketView         cur          = null;
                List <tblCurrencyMarketView>  curFreshList = new List <tblCurrencyMarketView>();
                List <tblCurrencyRankChanged> ranksChanged = new List <tblCurrencyRankChanged>();
                List <tblCurrencyView>        newlyAdded   = new List <tblCurrencyView>();

                foreach (var item in freshCurrencies)
                {
                    cur = new tblCurrencyMarketView()
                    {
                        ID                  = Guid.NewGuid(),
                        CoinMarkCapID       = item.Id,
                        AvailableSupply     = Utlity.ParseDecimal(item.AvailableSupply),
                        LastUpdatedUTC      = item.LastUpdated,
                        MarketCapConvert    = Utlity.ParseDecimal(item.MarketCapConvert),
                        MarketCapUSD        = Utlity.ParseDecimal(item.MarketCapUsd),
                        Name                = item.Name,
                        PercentageChange1H  = Utlity.ParseDouble(item.PercentChange1h),
                        PercentageChange24H = Utlity.ParseDouble(item.PercentChange24h),
                        PercentageChange7D  = Utlity.ParseDouble(item.PercentChange7d),
                        PriceBTC            = Utlity.ParseDecimal(item.PriceBtc),
                        PriceConvert        = Utlity.ParseDecimal(item.PriceConvert),
                        PriceUSD            = Utlity.ParseDecimal(item.PriceUsd),
                        Rank                = Utlity.ParseInt(item.Rank),
                        Symbol              = item.Symbol,
                        TotalSupply         = Utlity.ParseDecimal(item.TotalSupply),
                        Volume24hUSD        = Utlity.ParseDecimal(item.Volume24hUsd),
                        Volumne24HConvert   = Utlity.ParseDecimal(item.Volume24Convert),
                        TimeStamp           = DateTime.Now,
                        TransactionID       = restTransactionID
                    };
                    curFreshList.Add(cur);
                }


                //Add Fresh Currencies, which are going to be just 1 or 2 at a time
                var addRemovePairs = FindNewCurrencies(curFreshList, restTransactionID);
                if (addRemovePairs.Added != null && addRemovePairs.Added.Count > 0)
                {
                    newlyAdded = BuildNewCurrencyList(curFreshList, addRemovePairs.Added, restTransactionID);
                    CurrencyDataContext.InsertCurrencyViews(newlyAdded);
                }

                if (addRemovePairs.Removed != null && addRemovePairs.Removed.Count > 0)
                {
                    CurrencyDataContext.UpdateCurrencyViewForDelete(addRemovePairs.Removed, restTransactionID);
                }

                //Get those currency views which need to be updated in DB (New ones)
                var updateCurView = GetCurrencyViewToUpdate(curFreshList, newlyAdded);

                //The update the old currency views and report rank change
                if (updateCurView != null && updateCurView.Count > 0)
                {
                    ranksChanged = CurrencyDataContext.UpdateCurrencyViewAndCurrencyRankChanged(updateCurView, restTransactionID);
                }

                CurrencyDataContext.InsertCurrencyMarketView(curFreshList);

                CurrencyDataContext.InsertTransactionLog(restTransactionID);
            }
            catch (Exception ex)
            {
                CurrencyDataContext.InsertTransactionLog(restTransactionID, false);
                ErrorLogging.LogError(ex);
            }
        }