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