public ElementCorrelation[] SelectCorrelationResults(ElementTypeDefs typeA, ElementTypeDefs typeB, CorrelationPeriodType periodType) { using (FinanceDBEntities context = new FinanceDBEntities()) { return(context.SelectCorrelationResults((Int16)typeA, (Int16)typeB, (Byte)periodType).ToArray <ElementCorrelation>()); } }
public ElementWrapper( String ticker, ElementTypeDefs elementType, String name) { this.Ticker = ticker; this.ElementType = elementType; this.Name = name; }
public ElementWrapper[] SelectElements(ElementTypeDefs itemsTypes) { String cacheItemKey = String.Format("[SelectElements][{0}]", itemsTypes.ToString()); selectElementsLock.AcquireReaderLock(dataProviderLockTimeout); ElementWrapper[] result = null; try { result = (ElementWrapper[])DataCache.Instance.Get(cacheItemKey); if (null == result) { ////////////////////////////////////////////////////////////////// /// no data in cache - need to load it, but first check it again /// LockCookie lockCookie = selectElementsLock.UpgradeToWriterLock(dataProviderLockTimeout); try { result = (ElementWrapper[])DataCache.Instance.Get(cacheItemKey); if (null == result) { Element[] elements = (new ItemsDataProvider()).GetElementsByType(itemsTypes); if (LoggerFactory.AppLogger.IsTraceEnabled) { LoggerFactory.AppLogger.Trace("[DataProviderProxy.SelectElements] Loaded elements " + elements.Length); } result = WrapperUtilities.Convert(elements); DataCache.Instance.Add(cacheItemKey, result); } } finally { selectElementsLock.DowngradeFromWriterLock(ref lockCookie); } } } finally { selectElementsLock.ReleaseReaderLock(); } return(result); }
public Element[] GetElementsByType(ElementTypeDefs itemType) { using (FinanceDBEntities context = new FinanceDBEntities()) { if (itemType == ElementTypeDefs.Wszystko) { return((from e in context.Elements select e).ToArray <Element>()); } else { return((from e in context.Elements where e.Type == (Int16)itemType select e).ToArray <Element>()); } } }
public ElementWrapper[] SelectItems(ElementTypeDefs itemsTypes) { return((new DataProviderProxy()).SelectElements(itemsTypes)); }