public ActionResult RunGraber() { if (graberState == 1) { return(PartialView("GraberWorkingMessage")); } graberState = 1; db = new Models.ProductContext(); graber = new Graber("https://cnc.prom.ua"); productModel = new List <Models.Product>(); graber.Strategy = new PopulateModelStrategy(); graber.RunGrabber(); ProductsCollection result = (ProductsCollection)graber.Result; InsertNewResult(result); ViewBag.Count = productModel.Count; graberState = 0; return(PartialView("RunGraberResult")); }
public ActionResult ClearDb() { db = new Models.ProductContext(); db.Database.ExecuteSqlCommand("delete from ProductPriceHistories;delete from Products;"); return(PartialView("ClearBasePV")); }
// GET: Manage public ActionResult Index() { // UIRules.GraberMode mode = new UIRules.GraberMode(); db = new Models.ProductContext(); var productCount = db.Products.Count(); if (productCount == 0) { /* * mode.Action = "RunGraber"; * mode.Description = "Get products"; */ ViewBag.SelectPV = "ModePopultaePV"; } else { ViewBag.SelectPV = "ModeUpdatePV"; /* * mode.Action = "UpdatePrice"; * mode.Description = "Update prices"; */ } return(View()); }
public object UpdatePrice() { db = new Models.ProductContext(); graber = new Graber("https://cnc.prom.ua"); graber.Strategy = new PopulateModelStrategy(); graber.RunGrabber(); ProductsCollection result = (ProductsCollection)graber.Result; UpdatePriceHistory(result); return(new { s = "Updated" }); }
protected void UpdateProductButton_Click(object sender, EventArgs e) { using (var db = new Models.ProductContext()) { int productId = Convert.ToInt16(DropDownEditProduct.SelectedValue); var product = (from c in db.Products where c.ProductID == productId select c); /* if (product = ) * { * product.m * }*/ } }