public void updateLinkedinPostofPage(Domain.Socioboard.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 Domain.Socioboard.Domain.LinkedinCompanyPagePosts getCompanyPagPostInformation(string UpdateKey) { //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 get details of account. List <Domain.Socioboard.Domain.LinkedinCompanyPagePosts> objlst = session.CreateQuery("from LinkedinCompanyPagePosts where UpdateKey = :UpdateKey ") .SetParameter("UpdateKey", UpdateKey) .List <Domain.Socioboard.Domain.LinkedinCompanyPagePosts>().ToList <Domain.Socioboard.Domain.LinkedinCompanyPagePosts>(); Domain.Socioboard.Domain.LinkedinCompanyPagePosts result = new Domain.Socioboard.Domain.LinkedinCompanyPagePosts(); if (objlst.Count > 0) { result = objlst[0]; } return(result); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } //End Transaction } //End Session }
public void addLinkedInPagepost(Domain.Socioboard.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); } } }
public Domain.Socioboard.Domain.LinkedinCompanyPagePosts getCompanyPagPostInformation(string UpdateKey) { //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 get details of account. List<Domain.Socioboard.Domain.LinkedinCompanyPagePosts> objlst = session.CreateQuery("from LinkedinCompanyPagePosts where UpdateKey = :UpdateKey ") .SetParameter("UpdateKey", UpdateKey) .List<Domain.Socioboard.Domain.LinkedinCompanyPagePosts>().ToList<Domain.Socioboard.Domain.LinkedinCompanyPagePosts>(); Domain.Socioboard.Domain.LinkedinCompanyPagePosts result = new Domain.Socioboard.Domain.LinkedinCompanyPagePosts(); if (objlst.Count > 0) { result = objlst[0]; } return result; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return null; } }//End Transaction }//End Session }
public IHttpActionResult PsotCommentOnLinkedinCompanyPageUpdate(LinkedInManager LinkedInManager) { try { Domain.Socioboard.Domain.LinkedinCompanyPage objlicompanypage = new Domain.Socioboard.Domain.LinkedinCompanyPage(); objlicompanypage = objLinkedCmpnyPgeRepo.getCompanyPageInformation(LinkedInManager.ProfileId); oAuthLinkedIn Linkedin_oauth = new oAuthLinkedIn(); try { Linkedin_oauth.ConsumerKey = ConfigurationManager.AppSettings["LinkedinApiKey"]; } catch (Exception ex) { Console.WriteLine(ex.Message); } try { Linkedin_oauth.ConsumerSecret = ConfigurationManager.AppSettings["LinkedinSecretKey"]; } catch (Exception ex) { Console.WriteLine(ex.Message); } Linkedin_oauth.Verifier = objlicompanypage.OAuthVerifier; Linkedin_oauth.TokenSecret = objlicompanypage.OAuthSecret; Linkedin_oauth.Token = objlicompanypage.OAuthToken; Linkedin_oauth.Id = objlicompanypage.LinkedinPageId; Linkedin_oauth.FirstName = objlicompanypage.LinkedinPageName; Company company = new Company(); string res = company.SetCommentOnPagePost(Linkedin_oauth, LinkedInManager.ProfileId, LinkedInManager.Updatekey, LinkedInManager.comment); if (res != "Failed") { Domain.Socioboard.Domain.LinkedinCompanyPagePosts lipost = new LinkedinCompanyPagePosts(); lipost = objLinkedinPagePostRepository.getCompanyPagPostInformation(LinkedInManager.Updatekey); lipost.Comments = lipost.Comments + 1; objLinkedinPagePostRepository.updateLinkedinPostCommentofPage(lipost); } string data= new JavaScriptSerializer().Serialize(res); return Ok(data); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return Ok("Something Went Wrong"); } }