public void SetArticlesReadForUser(int id_article, string user) { try { using (BD.AtomicRssDatabaseContainer context = new BD.AtomicRssDatabaseContainer()) { BD.Users u = (from el in context.UsersSet where el.Email == user select el).FirstOrDefault(); BD.Articles article = (from el in context.ArticlesSet where el.Id == id_article select el).FirstOrDefault(); if (u != null && article != null) { article.Users.Add(u); } context.SaveChanges(); } } catch (Exception e) { Debug.WriteLine(e.Message); } }
public void LoadArticles() { try { using (BD.AtomicRssDatabaseContainer context = new BD.AtomicRssDatabaseContainer()) { foreach (BD.Channels chan in context.ChannelsSet) { XmlReader read = XmlReader.Create(chan.Link); SyndicationFeed feeds = SyndicationFeed.Load(read); read.Close(); Debug.WriteLine("LoadArticles : " + chan.Link); foreach (SyndicationItem article in feeds.Items) { BD.Articles a = new BD.Articles(); a.Date = article.PublishDate.DateTime; a.Title = article.Title.Text; a.Description = article.Summary.Text; a.GUID = "0000"; a.Link = article.Id; BD.Articles exist = (from el in chan.Articles where el.Link == a.Link select el).FirstOrDefault(); if (exist != null) { Debug.WriteLine("Test : " + a.Link + " exist : " + exist.Link); } if (exist == null) { Debug.WriteLine("Adding new article : " + a.Title); chan.Articles.Add(a); context.ArticlesSet.AddObject(a); } } } context.SaveChanges(); } } catch (Exception e) { Debug.WriteLine(e.Message); } }