public void InsertTwitterRecentDetails(Domain.Socioboard.Domain.TwitterRecentDetails data)
{
bool exists = false;
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
exists = session.Query <Domain.Socioboard.Domain.TwitterRecentDetails>()
.Any(x => x.TwitterId == data.TwitterId);
}
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
if (exists)
{
session.CreateQuery("Update twitterrecentdetails set AccountCreationDate = : AccountCreationDate , LastActivityDate = : LastActivityDate , LastFeed = : LastFeed , FeedId = : FeedId , FeedRetweetCount = : FeedRetweetCount , FeedFavoriteCount = : FeedFavoriteCount where TwitterId = : TwitterId")
.SetParameter("AccountCreationDate", data.AccountCreationDate)
.SetParameter("LastActivityDate", data.LastActivityDate)
.SetParameter("LastFeed", data.LastFeed)
.SetParameter("FeedId", data.FeedId)
.SetParameter("FeedRetweetCount", data.FeedRetweetCount)
.SetParameter("FeedFavoriteCount", data.FeedFavoriteCount)
.ExecuteUpdate();
transaction.Commit();
}
else
{
session.Save(data);
transaction.Commit();
}
}
}
}
public void twitterrecentdetails(JArray data)
{
Domain.Socioboard.Domain.TwitterRecentDetails insertdata = new Domain.Socioboard.Domain.TwitterRecentDetails();
TwitterAccountRepository objTwtRepo = new TwitterAccountRepository();
string TwitterId = string.Empty;
Guid Id = Guid.NewGuid();
try
{
TwitterId = data[0]["id_str"].ToString();
}
catch (Exception)
{
TwitterId = string.Empty;
}
if (!string.IsNullOrEmpty(TwitterId))
{
string AccountCreationDate = string.Empty;
string LastActivityDate = string.Empty;
string lastfeed = string.Empty;
string FeedId = string.Empty;
string retweetcount = string.Empty;
string favoritecount = string.Empty;
try
{
DateTime AccntCreationDate = Utility.ParseTwitterTime((data[0]["created_at"].ToString()));
AccountCreationDate = AccntCreationDate.ToString();
}
catch (Exception)
{
AccountCreationDate = string.Empty;
}
try
{
DateTime lastactivitydate = Utility.ParseTwitterTime((data[0]["status"]["created_at"].ToString()));
LastActivityDate = lastactivitydate.ToString();
}
catch (Exception)
{
LastActivityDate = string.Empty;
}
try
{
lastfeed = data[0]["status"]["text"].ToString();
FeedId = data[0]["status"]["id_str"].ToString();
retweetcount = data[0]["status"]["retweet_count"].ToString();
favoritecount = data[0]["status"]["favorite_count"].ToString();
}
catch (Exception)
{
lastfeed = string.Empty;
FeedId = string.Empty;
retweetcount = string.Empty;
favoritecount = string.Empty;
}
insertdata.Id = Id;
insertdata.TwitterId = TwitterId;
insertdata.AccountCreationDate = AccountCreationDate;
insertdata.LastActivityDate = LastActivityDate;
insertdata.LastFeed = lastfeed;
insertdata.FeedId = FeedId;
insertdata.FeedRetweetCount = retweetcount;
insertdata.FeedFavoriteCount = favoritecount;
objTwtRepo.InsertTwitterRecentDetails(insertdata);
}
}