public IList<Site> GetAllSites() { using (var context = new StockEntities()) { return context.Sites.ToList(); } }
public IList<StockFileViewModel> GetAllStockFiles(string SiteId, string StockId) { using (var context = new StockEntities()) { int _siteId = Convert.ToInt32(SiteId); int _stockId = Convert.ToInt32(StockId); var result = (from se in context.StockFiles join s in context.Sites on se.SiteId equals s.ID where _siteId == 0 ? 1 == 1 : se.SiteId == _siteId join ss in context.StockSymbols on se.StockId equals ss.ID where _stockId == 0 ? 1 == 1 : se.StockId == _stockId select new StockFileViewModel { Format = s.Format, Name = s.Name, Url = s.Url, Symbol = ss.Symbol, Id = se.ID, SiteId = se.SiteId, StockId = se.StockId, FileName = se.FileName, DownloadedDate = se.DownloadedDate.Value }).ToList<StockFileViewModel>(); return result; } }
public bool ExtractStockFilesFromSites() { using (var context = new StockEntities()) { bool isExtracted = false; var sitesWithSymbol = (from site in context.Sites from symbol in context.StockSymbols select new { site, symbol }).ToList(); for (int count = 0; count < sitesWithSymbol.Count; count++) { string fileContent = ExtractDataFromSites(sitesWithSymbol[count].site.Url.Replace("{0}", sitesWithSymbol[count].symbol.Symbol)); if(!String.IsNullOrEmpty(fileContent)) { var stockFile = new StockFile(); stockFile.SiteId = sitesWithSymbol[count].site.ID; stockFile.StockId = sitesWithSymbol[count].symbol.ID; stockFile.FileName = sitesWithSymbol[count].site.Name + "_" + sitesWithSymbol[count].symbol.Symbol; stockFile.File = fileContent; stockFile.DownloadedDate = DateTime.Now; context.StockFiles.AddObject(stockFile); } } context.SaveChanges(); isExtracted = true; return isExtracted; } }
public bool RemoveAllStockFiles() { using (var context = new StockEntities()) { bool isDeleted = false; var records = from s in context.StockFiles select s; foreach (var record in records) { context.StockFiles.DeleteObject(record); } context.SaveChanges(); isDeleted = true; return isDeleted; } }
public IList<StockSymbol> GetSymbols() { using (var context = new StockEntities()) { return context.StockSymbols.ToList(); } }
public StockFileViewModel GetStockFile(string StockFileId) { int iStockFileId = Convert.ToInt32(StockFileId); using (var context = new StockEntities()) { var stockFile = (from sf in context.StockFiles join s in context.Sites on sf.SiteId equals s.ID where sf.ID == iStockFileId select new StockFileViewModel { Format = s.Format, File = sf.File, FileName = sf.FileName }).FirstOrDefault(); return stockFile; } }
public IList<string> GetAllSymbols() { using (var context = new StockEntities()) { return context.StockSymbols.Select(x => x.Symbol).ToList(); } }