private void ParseProducts(DbModelContext dbContext) { int counter = 0; do { Thread.Sleep(3 * 1000); if (products.Count > 0) { var currentProduct = products[counter]; parser.GetProduct(ref currentProduct); counter++; try { dbContext.SaveChanges(); } catch (Exception ex) { GenericLogger.Error($"Error when trying to save changes for updating process for {currentProduct.Url}, \n ex : {ex.Message} \n {ex.StackTrace} \n {ex.InnerException.InnerException.Message}"); } } } while (counter < products.Count); }
public void StartCrawling() { using (var dbContext = new DbModelContext()) { Initialize(dbContext); ParseProducts(dbContext); } }
private List <UrmarireProdus> GetFollowedInformation(DbModelContext dbContext) { var information = new List <UrmarireProdus>(); information = (from info in dbContext.UrmarireProdus join user in dbContext.Utilizator on info.Id_Utilizator equals user.Id join prodct in dbContext.Produs on info.Id_Produs equals prodct.Id where info.Invalid == false select info).Include(p => p.Utilizator).Include(p => p.Produs).ToList(); return(information); }
private void GetProductsFromDB(DbModelContext dbContext) { retailerId = dbContext.Vanzator.Where(m => m.Nume.Equals(RetailerConfig.RetailerName)).Select(m => m.Id).FirstOrDefault(); products = new RetailerCrawlProductCollection(RetailerConfig.RetailerName); var prods = (from prod in dbContext.Produs join evol in dbContext.EvolutiaPretului on prod.Id equals evol.Id_Produs join retailer in dbContext.Vanzator on prod.Id_Vanzator equals retailer.Id where retailer.Id.Equals(retailerId) select prod).Include(p => p.EvolutiaPretului).ToList(); products.AddRange(prods); }
public void StartAllertCheck() { try { using (var dbModel = new DbModelContext()) { var followInformation = GetFollowedInformation(dbModel); CheckFollowedInformation(ref followInformation); dbModel.SaveChanges(); } } catch (Exception ex) { } }
public ActionResult LineChart(string productId) { using (DbModelContext dbContext = new DbModelContext()) { ArrayList xValues = new ArrayList(); ArrayList yValues = new ArrayList(); xValues.AddRange((from priceEvolution in dbContext.EvolutiaPretului where priceEvolution.Id_Produs == new Guid(productId) orderby priceEvolution.Data_Actualizare descending select priceEvolution.Data_Actualizare).Take(10).ToList()); yValues.AddRange((from priceEvolution in dbContext.EvolutiaPretului where priceEvolution.Id_Produs == new Guid(productId) orderby priceEvolution.Data_Actualizare descending select priceEvolution.Pret).Take(10).ToList()); new Chart(width: 300, height: 200, theme: ChartTheme.Blue). AddTitle("Evolutia Pretului"). AddSeries(null, chartType: "Line", xValue: xValues, yValues: yValues). Write("bmp"); } return(null); }
protected void Application_Start() { Log.Info("Starting up..."); var container = new ServiceContainer(); container.EnableMvc(); container.RegisterControllers(Assembly.GetExecutingAssembly()); container.RegisterInstance(typeof(DbContext), DbModelContext.Create()); container.Register <IUnitOfWork, UnitOfWork>(); AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); //ControllerBuilder.Current.SetControllerFactory(new LightInjectDefaultControllerFactory()); Log.Info("Routes and bundles registered"); Log.Info("Started"); }
private void Initialize(DbModelContext dbContext) { GetProductsFromDB(dbContext); GetParser(); }
public DbModelContext Init() { return(dbcontext ?? (dbcontext = new DbModelContext())); }
public UnitOfWork() { _context = new DbModelContext(); }
public GenericRepository(DbModelContext dbModelContext) { _context = dbModelContext; }
public ProductsController(DbModelContext context) { _context = context; }