private int Insert(String ManufacturerCode, InManufacturerSeries manufacturer) { String Query = "INSERT INTO [SecLockManufacturerSeries]([ManufacturerCode],[Name]) VALUES('" + ManufacturerCode + "','" + manufacturer.Name + "');"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
private int Update(String ManufacturerCode, InManufacturerSeries manufacturer) { String Query = "UPDATE [SecLockManufacturerSeries] SET [Name] = '" + manufacturer.Name + "',[ManufacturerCode] = '" + ManufacturerCode + "' WHERE [Name] = '" + manufacturer.Name + "'"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return oDm.RunActionQuery(); }
public int Save(String ManufacturerCode, InManufacturerSeries manufacturer) { var x = GetData(manufacturer); if (x.Count > 0) return Update(ManufacturerCode, manufacturer); else return Insert(ManufacturerCode, manufacturer); }
public List<InManufacturerSeries> GetData(InManufacturerSeries manufacturer) { String Query = "SELECT * FROM SecLockManufacturerSeries WHERE ID = " + manufacturer.ID +" ORDER BY Name"; OleDbDataManager oDm = new OleDbDataManager(this.ConnectionString, Query, true); return DataParser.ToList<InManufacturerSeries>(oDm.GetTable()); }
public void GetProductsByManufacturerFromSite(InManufacturer manufacturer) { String Url = "http://www.seclock.com/products/items.asp?m=" + manufacturer.Code; if (!LoggedIn) Login(); HtmlAgilityPack.HtmlDocument document = browser.GetWebRequest(Url); HtmlNodeCollection seriesNodes = document.DocumentNode.SelectNodes("//ul[@class='products']/li"); manufacturer.SeriesList = new List<InManufacturerSeries>(); if (!ReferenceEquals(seriesNodes, null)) { foreach (HtmlNode seriesNode in seriesNodes) { InManufacturerSeries series = new InManufacturerSeries(); var seriesDetail = seriesNode.SelectSingleNode("a"); if (!ReferenceEquals(seriesDetail, null)) { series.Name = seriesNode.SelectSingleNode("a").InnerText; series.Products = new List<InProduct>(); HtmlNodeCollection anchorNodes = seriesNode.SelectNodes("ul/li/a"); foreach (HtmlNode anchorNode in anchorNodes) { InProduct product = new InProduct(); product.Code = anchorNode.InnerHtml; var dbProducts = new InProductManager(Constants.ConnectionString).GetData(product); if (dbProducts.Count() > 0) { product = dbProducts[0]; } product.Name = anchorNode.InnerText; product.Url = anchorNode.Attributes["href"].Value; product.ManufacturerSeries = series.Name; product.ManufacturerName = manufacturer.Name; product.ManufacturerCode = manufacturer.Code; new InProductManager(Constants.ConnectionString).Save(product); series.Products.Add(product); } new InManufacturerSeriesManager(Constants.ConnectionString).Save(manufacturer.Code, series); manufacturer.SeriesList.Add(series); } } exportManager.Insert(Constants.SiteName.SECLOCK, Constants.ExportType.SECLOCK_MANUFACTURER_SERIES, manufacturer.Code); } }