public void updateLinkedinPostofPage(Domain.Myfashion.Domain.LinkedinCompanyPagePosts lipost)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
session.CreateQuery("Update LinkedinCompanyPagePosts set Likes =:Likes,Comments =:Comments,IsLiked=:IsLiked where PostId = :PostId and UserId = :UserId")
.SetParameter("Likes", lipost.Likes)
.SetParameter("Comments", lipost.Comments)
.SetParameter("IsLiked", lipost.IsLiked)
.SetParameter("PostId", lipost.PostId)
.SetParameter("UserId", lipost.UserId)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
}
}
}
public void addLinkedInPagepost(Domain.Myfashion.Domain.LinkedinCompanyPagePosts lipost)
{
//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())
{
session.Save(lipost);
transaction.Commit();
} //End Transaction
} //End Session
}
public void GetLinkedinCompanyPageFeeds(oAuthLinkedIn _oauth, string UserId, string PageId)
{
LinkedinPageUpdate objlinkedinpageupdate = new LinkedinPageUpdate();
LinkedinPagePostRepository objlipagepostRepo = new LinkedinPagePostRepository();
List<LinkedinPageUpdate.CompanyPagePosts> objcompanypagepost = new List<LinkedinPageUpdate.CompanyPagePosts>();
objcompanypagepost = objlinkedinpageupdate.GetPagePosts(_oauth, PageId);
LinkedinCompanyPagePosts lipagepost = new LinkedinCompanyPagePosts();
foreach (var item in objcompanypagepost)
{
lipagepost.Id = Guid.NewGuid();
lipagepost.Posts = item.Posts;
lipagepost.PostDate = Convert.ToDateTime(item.PostDate);
lipagepost.EntryDate = DateTime.Now;
lipagepost.UserId = Guid.Parse(UserId);
lipagepost.Type = item.Type;
lipagepost.PostId = item.PostId;
lipagepost.UpdateKey = item.UpdateKey;
lipagepost.PageId = PageId;
lipagepost.PostImageUrl = item.PostImageUrl;
lipagepost.Likes = item.Likes;
lipagepost.Comments = item.Comments;
if (!objlipagepostRepo.checkLinkedInPostExists(lipagepost.PostId, lipagepost.UserId))
{
objlipagepostRepo.addLinkedInPagepost(lipagepost);
}
else
{
objlipagepostRepo.updateLinkedinPostofPage(lipagepost);
}
}
}