public bool Is_Exist_Local(DataLoad data) { bool result = true; Logs log = new Logs(); try { Query local = new Query(); if (!local.Check_Exits_Product(data.Sku, data.CategoryId)) { Product product = local.Insert_Product(data); long product_id = product.Id; local.Insert_Product_Category(product.Id, data.CategoryId); Pinterest pinterest = local.Insert_Pinterest(product_id, data); local.Insert_Product_Link_Pinterest(product_id, pinterest.Id); data.TypeName = local.Get_Product_Type_By_Id(data.Type).Name; result = false; } } catch (Exception ex) { log.IErrors("Logic - Is_Exist_Local: " + ex.Message); } return(result); }
public Product Insert_Product(DataLoad data) { MoneyDataContext db = new MoneyDataContext(); Product prod = new Product { Sku = data.Sku, Group_Id = data.GroupId, Name = data.Title, Description = data.Description, Url_Source = data.Url, Url_Name = data.UrlName, ProductTypeId = data.Type, Image = data.Image, Price = data.Price, Keywords = data.Keywords, CreatedDate = DateTime.Now, Source_Id = 1 }; try { db.Products.InsertOnSubmit(prod); db.SubmitChanges(); } catch (Exception ex) { } return(prod); }
// Insert Pinterest public Pinterest Insert_Pinterest(long product_id, DataLoad data) { MoneyDataContext db = new MoneyDataContext(); Pinterest prod = new Pinterest { Board = data.Tag, Backlink = data.UrlName, Note = data.Description, Image_Url = data.Image, Type = 1, Is_Pin = 0, Created_Date = DateTime.Now }; try { db.Pinterests.InsertOnSubmit(prod); db.SubmitChanges(); } catch (Exception ex) { } return(prod); }
public int execute(DataLoad data) { int status = 0; Logs log = new Logs(); try { if (!Is_Exist_Local(data)) { status = 1; } else { log.ILogs("Exist: " + data.Sku); status = 2; } } catch (Exception ex) { log.IErrors("Logic - Execute: " + ex.Message); } return(status); }
public DataLoad GetHtml(string url_sun) { DataLoad data = new DataLoad(); try { string html = GetAjaxData(url_sun); HtmlDocument doc = new HtmlDocument(); doc.LoadHtml(html); var titleTag = doc.DocumentNode.SelectSingleNode("//title").InnerText; data.Title = titleTag; data.Url = url_sun; var meta = doc.DocumentNode.SelectNodes("//meta"); foreach (var node in meta) { //Description if (node.GetAttributeValue("name", String.Empty) == "Description") { data.Description = node.GetAttributeValue("content", String.Empty) + " | Best T-Shirts USA are very happy to make you beutiful - Shirts as unique as you are."; } //Keyword if (node.GetAttributeValue("name", String.Empty) == "Keywords") { data.Keywords = node.GetAttributeValue("content", String.Empty); } } //Group ID var groupNote = doc.DocumentNode.SelectSingleNode("//input[@name='MockupGroup']"); data.GroupId = groupNote.Attributes["value"].Value; //SKU var skuNote = doc.DocumentNode.SelectSingleNode("//input[@name='mockupID']"); data.Sku = skuNote.Attributes["value"].Value; //Cate var catNote = doc.DocumentNode.SelectSingleNode("//input[@name='catName']"); data.CategoryName = catNote.Attributes["value"].Value; //Cate var imgNote = doc.DocumentNode.SelectSingleNode("//img[@id='MainImgShow']"); data.Image = imgNote.Attributes["src"].Value; //Url name data.UrlName = ToUrlSlug(titleTag).ToLower(); //Price var priceNote = doc.DocumentNode.SelectNodes("//select[@id='shirtTypes']//option"); string optionNote = ""; foreach (HtmlNode node in priceNote) { optionNote = node.NextSibling.InnerHtml; break; } var text_option = optionNote.Split('$'); data.Price = decimal.Parse(text_option[1]); //string type_array = text_option[0].Split(' ')[0]; } catch (Exception ex) { } return(data); }