public bool Insert_Pin(DataLoad data) { bool result = false; try { MoneyDataContext db = new MoneyDataContext(); Pinterest pin = new Pinterest { Old_Id = data.OldId, Board = data.Board, Backlink = data.Backlink, Note = data.Note, Image_Url = data.Image_Url, Type = data.Type, Is_Pin = 0, Created_Date = DateTime.Now }; db.Pinterests.InsertOnSubmit(pin); db.SubmitChanges(); result = true; } catch (Exception ex) { } 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); }
public void Update_Board(int id) { try { MoneyDataContext db = new MoneyDataContext(); ReachBoardPinterest prod = (from p in db.ReachBoardPinterests where p.Id == id select p).SingleOrDefault(); prod.IsLoad = 1; db.SubmitChanges(); } catch (Exception ex) { } }
public void Update_Pin(int id, string pin_id) { try { MoneyDataContext db = new MoneyDataContext(); Pinterest prod = (from p in db.Pinterests where p.Id == id select p).SingleOrDefault(); prod.PinId = pin_id; prod.Is_Pin = 1; prod.Update_Date = DateTime.Now; db.SubmitChanges(); } catch (Exception ex) { } }
public bool Insert_Product_Link_Pinterest(long product_id, int pinterest_id) { bool result = false; try { MoneyDataContext db = new MoneyDataContext(); ProductPinterest prod = new ProductPinterest { ProductId = product_id, PinId = pinterest_id }; db.ProductPinterests.InsertOnSubmit(prod); db.SubmitChanges(); result = true; } catch (Exception ex) { } return(result); }
public bool Insert_Product_Category(long product_id, int category_id) { bool result = false; try { MoneyDataContext db = new MoneyDataContext(); ProductCategoryDetail prod = new ProductCategoryDetail { Product_Id = product_id, Category_Id = category_id }; db.ProductCategoryDetails.InsertOnSubmit(prod); db.SubmitChanges(); result = true; } catch (Exception ex) { } return(result); }
// 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); }