/// <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();
}
