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;
}
