public IEnumerable <Data> Get_Image() { mmoDataContext context = new mmoDataContext(); var query = (from pin in context.Pinterests where !(from post in context.Postings where post.SourceId == 6 select post.ImgId).Contains(pin.Id) && pin.Type == 2 && pin.Image_Url != null select pin) .Take(950); List <Data> datas = new List <Data>(); foreach (var i in query) { Data da = new Data(); var img = da.CovertImgUrl(i.Image_Url); if (img == null) { Remove_Pin(i.Id); } else { var photos = new BinaryFile[] { new BinaryFile(img, i.Note, null) }; da.id = i.Id; da.photos = photos; da.title = String.Join("", i.Note.Split('\'')); da.tags = da.ConvertTags(i.Note); datas.Add(da); } } return(datas); }
public void Remove_Pin(int id) { try { mmoDataContext db = new mmoDataContext(); Pinterest prod = (from p in db.Pinterests where p.Id == id select p).SingleOrDefault(); db.Pinterests.DeleteOnSubmit(prod); db.SubmitChanges(); } catch (Exception ex) { } }
public bool Insert_Posted(int id) { bool result = false; try { mmoDataContext db = new mmoDataContext(); Posting post = new Posting { ImgId = id, SourceId = 6 }; db.Postings.InsertOnSubmit(post); db.SubmitChanges(); result = true; } catch (Exception ex) { } return(result); }