/// <getInsightStatsPostDetails> /// Get Details of Insight Stats Post. /// </summary> /// <param name="PostId">Post id(String)</param> /// <returns>FacebookInsightPostStats class object (Domain.FacebookInsightPostStats) </returns> public FacebookInsightPostStats getInsightStatsPostDetails(string PostId) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //Begin trasaction and opens up. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { NHibernate.IQuery query = session.CreateQuery("from FacebookInsightPostStats where PostId = :postId"); query.SetParameter("postId", PostId); List <FacebookInsightPostStats> lst = new List <FacebookInsightPostStats>(); foreach (FacebookInsightPostStats item in query.Enumerable()) { lst.Add(item); break; } FacebookInsightPostStats fbacc = lst[0]; return(fbacc); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } //End Transaction } //End Session }
public void getFanPost(string pageId, Guid UserId, int days) { string strStories = "https://graph.facebook.com/" + pageId + "/feed"; FacebookClient fb = new FacebookClient(); FacebookAccountRepository fbAccRepo = new FacebookAccountRepository(); FacebookAccount acc = fbAccRepo.getUserDetails(pageId); fb.AccessToken = acc.AccessToken; JsonObject outputreg = (JsonObject)fb.Get(strStories); JArray data = (JArray)JsonConvert.DeserializeObject(outputreg["data"].ToString()); FacebookInsightPostStats objFbiPost = new FacebookInsightPostStats(); FacebookInsightPostStatsRepository objfbiPostRepo = new FacebookInsightPostStatsRepository(); foreach (var item in data) { try { objFbiPost.Id = Guid.NewGuid(); objFbiPost.EntryDate = DateTime.Now; objFbiPost.PageId = pageId; try { objFbiPost.PostMessage = item["story"].ToString(); } catch (Exception Err) { objFbiPost.PostMessage = item["message"].ToString(); } objFbiPost.PostDate = item["created_time"].ToString(); JArray arrComment = (JArray)item["comment"]; if (arrComment != null) { objFbiPost.PostComments = arrComment.Count; } else { objFbiPost.PostComments = 0; } objFbiPost.PostId = item["id"].ToString(); objFbiPost.UserId = UserId; if (!objfbiPostRepo.checkFacebookInsightPostStatsExists(pageId, item["id"].ToString(), UserId, item["created_time"].ToString())) { objfbiPostRepo.addFacebookInsightPostStats(objFbiPost); } else { objfbiPostRepo.updateFacebookInsightPostStats(objFbiPost); } } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
/// <addFacebookInsightPostStats> /// Add a new facebook insight post stats /// </summary> /// <param name="fbinsightstats">Set Values in a FacebookInsightPostStats Class Property and Pass the same Object of FacebookInsightPostStats Class as a parameter (SocioBoard.Domain.FacebookInsightPostStats).</param> public void addFacebookInsightPostStats(FacebookInsightPostStats fbinsightstats) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //Begin session trasaction and opens up. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to save a new data. session.Save(fbinsightstats); transaction.Commit(); } //End Trsaction } //End session }
/// <addFacebookInsightPostStats> /// Add a new facebook insight post stats /// </summary> /// <param name="fbinsightstats">Set Values in a FacebookInsightPostStats Class Property and Pass the same Object of FacebookInsightPostStats Class as a parameter (SocioBoard.Domain.FacebookInsightPostStats).</param> public void addFacebookInsightPostStats(FacebookInsightPostStats fbinsightstats) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //Begin session trasaction and opens up. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to save a new data. session.Save(fbinsightstats); transaction.Commit(); }//End Trsaction }//End session }
public void updateFacebookInsightPostStats(FacebookInsightPostStats fbaccount) { throw new NotImplementedException(); }