/// <DeleteRssReader> /// Delete RssReader /// </summary> /// <param name="rss">Set rssid in a RssReader Class Property and Pass the Object of RssReader Class.(Domein.RssReader)</param> /// <returns>Return 1 for true and 0 for false.(int)</returns> public int DeleteRssReader(RssReader rss) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action to delete RssReader by id. NHibernate.IQuery query = session.CreateQuery("delete from RssReader where Id = :adsid") .SetParameter("adsid", rss.Id); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return isUpdated; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return 0; } }//End Transaction }//End Session }
public int getRssFeeds(object url) { try { //Fetch the subscribed RSS Feed XmlDocument RSSXml = new XmlDocument(); RSSXml.Load(url.ToString()); XmlNodeList RSSNodeList = RSSXml.SelectNodes("rss/channel/item"); XmlNode RSSDesc = RSSXml.SelectSingleNode("rss/channel/title"); RssReaderRepository rssReaderRepo = new RssReaderRepository(); StringBuilder sb = new StringBuilder(); foreach (XmlNode RSSNode in RSSNodeList) { RssReader rssReader = new RssReader(); XmlNode RSSSubNode; RSSSubNode = RSSNode.SelectSingleNode("title"); string title = RSSSubNode != null ? RSSSubNode.InnerText : ""; RSSSubNode = RSSNode.SelectSingleNode("link"); string link = RSSSubNode != null ? RSSSubNode.InnerText : ""; RSSSubNode = RSSNode.SelectSingleNode("description"); string desc = RSSSubNode != null ? RSSSubNode.InnerText : ""; RSSSubNode = RSSNode.SelectSingleNode("pubDate"); string publishDate = RSSSubNode != null ? RSSSubNode.InnerText : ""; rssReader.Id = Guid.NewGuid(); rssReader.Description = desc; rssReader.Link = link; rssReader.PublishedDate = publishDate; rssReader.Title = title; rssReader.FeedsUrl = url.ToString(); rssReader.CreatedDate = DateTime.Now; rssReader.Status = false; if (!rssReaderRepo.CheckFeedExists(url.ToString(), desc, publishDate)) { rssReaderRepo.AddRssReader(rssReader); } } return 0; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return 0; } }
public void AddRssReader(RssReader rss) { try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Save(rss); transaction.Commit(); } } } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }
/// <AddRssReader> /// Add new RssReader /// </summary> /// <param name="rss">Set Values in a RssReader Class Property and Pass the Object of RssReader Class.(Domein.RssReader)</param> public void AddRssReader(RssReader rss) { try { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to save new data. session.Save(rss); transaction.Commit(); }//End Transaction }//End Session } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } }
public int DeleteRssReader(RssReader rss) { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { NHibernate.IQuery query = session.CreateQuery("delete from RssReader where Id = :adsid") .SetParameter("adsid", rss.Id); int isUpdated = query.ExecuteUpdate(); transaction.Commit(); return isUpdated; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return 0; } } } }
public void UpdateRssReader(RssReader rss) { throw new NotImplementedException(); }