public bool AddShareathon(ShareathonGroup shareathon) { bool IsSuccess = false; //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 data. try { session.Save(shareathon); transaction.Commit(); IsSuccess = true; return IsSuccess; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return IsSuccess; } }//End Transaction }//End Session }
public bool updateShareathon(Domain.Socioboard.Domain.ShareathonGroup shareathon) { bool isUpdate = false; //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 Update Data. // And Set the reuired paremeters to find the specific values. session.CreateQuery("Update ShareathonGroup set Facebookaccountid=:Facebookaccountid,Facebookpageid=:Facebookpageid,Timeintervalminutes=:Timeintervalminutes,FacebookPageUrl=:FacebookPageUrl,Facebookgroupid=:Facebookgroupid,Facebooknameid=:Facebooknameid where Id = :Id") .SetParameter("Facebookaccountid", shareathon.Facebookaccountid) .SetParameter("Facebookpageid", shareathon.Facebookpageid) .SetParameter("Timeintervalminutes", shareathon.Timeintervalminutes).SetParameter("FacebookPageUrl", shareathon.FacebookPageUrl).SetParameter("Facebookgroupid", shareathon.Facebookgroupid).SetParameter("Facebooknameid", shareathon.Facebooknameid) .SetParameter("Id", shareathon.Id) .ExecuteUpdate(); transaction.Commit(); isUpdate = true; return(isUpdate); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(isUpdate); } } //End Transaction } //End session }
public IHttpActionResult AddGroupSharethon(ShareathonGroupViewModel sharethon) { Domain.Socioboard.Domain.ShareathonGroup _ShareathonGroup = new ShareathonGroup(); string groupId = ""; string nameId = ""; Domain.Socioboard.Domain.FacebookAccount facebookAccount = sharegrprepo.getFacebookAccountDetailsByUserProfileId(sharethon.Facebookaccountid, sharethon.Userid); string pageid = FacebookHelper.GetFbPageDetails(sharethon.FacebookPageUrl, facebookAccount.AccessToken); _ShareathonGroup.Id = Guid.NewGuid(); _ShareathonGroup.Facebookpageid = pageid.TrimEnd(','); _ShareathonGroup.FacebookPageUrl = sharethon.FacebookPageUrl; _ShareathonGroup.AccessToken = facebookAccount.AccessToken; _ShareathonGroup.Facebookaccountid = facebookAccount.FbUserId; _ShareathonGroup.Userid = sharethon.Userid; _ShareathonGroup.Timeintervalminutes = sharethon.Timeintervalminutes; _ShareathonGroup.IsHidden = false; _ShareathonGroup.FacebookStatus = 1; for (int i = 0; i < sharethon.FacebookGroupId.Length; i++) { string dataid = sharethon.FacebookGroupId[i]; string[] grpid = Regex.Split(dataid, "###"); groupId = grpid[0] + "," + groupId; } _ShareathonGroup.Facebooknameid = sharethon.Facebooknameid.TrimEnd(','); _ShareathonGroup.Facebookgroupid = groupId.TrimEnd(','); if (!sharegrprepo.IsShareathonExist(sharethon.Userid, groupId, pageid)) { if (sharegrprepo.AddShareathon(_ShareathonGroup)) { return Ok(); } else { return BadRequest(); } } else { return BadRequest("Shareathon exist"); } return Ok(); }
public Domain.Socioboard.Domain.ShareathonGroup getShareathon(Guid Id) { Domain.Socioboard.Domain.ShareathonGroup shareathon = null; //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 { NHibernate.IQuery query = session.CreateQuery("from ShareathonGroup where Id = :ID and FacebookStatus = :FacebookStatus"); query.SetParameter("ID", Id).SetParameter("FacebookStatus", 1); Domain.Socioboard.Domain.ShareathonGroup result = (Domain.Socioboard.Domain.ShareathonGroup)query.UniqueResult(); shareathon = result; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); } } //End Transaction } //End session return(shareathon); }
public void PostData(ShareathonGroup item) { FacebookAccount facebookAccount = sharegrprepo.getFbAccount(item.Facebookaccountid); string feedId = string.Empty; string[] pageid = item.Facebookpageid.Split(','); foreach (string item_str in pageid) { string feeds = FacebookHelper.getFacebookRecentPost(item.AccessToken, item_str); try { if (!string.IsNullOrEmpty(feeds) && !feeds.Equals("[]")) { JObject fbpageNotes = JObject.Parse(feeds); foreach (JObject obj in JArray.Parse(fbpageNotes["data"].ToString())) { try { string feedid = obj["id"].ToString(); feedid = feedid.Split('_')[1]; feedId = feedid + "," + feedId; } catch { } } } } catch (Exception ex) { } } FacebookHelper.postfeedGroup(item.AccessToken, item.Facebookgroupid, feedId, facebookAccount.FbUserId, item.Timeintervalminutes); }
public void PostData(ShareathonGroup item) { Domain.Socioboard.Domain.FacebookAccount facebookAccount = sharegrprepo.getFacebookAccountDetailsByUserProfileId(item.Facebookaccountid, item.Userid); string feedId = string.Empty; string[] pageid = item.Facebookpageid.Split(','); foreach (string item_str in pageid) { string feeds = FacebookHelper.getFacebookRecentPost(facebookAccount.AccessToken, item_str); try { if (!string.IsNullOrEmpty(feeds) && !feeds.Equals("[]")) { JObject fbpageNotes = JObject.Parse(feeds); foreach (JObject obj in JArray.Parse(fbpageNotes["data"].ToString())) { try { string feedid = obj["id"].ToString(); feedid = feedid.Split('_')[1]; feedId = feedid + "," + feedId; } catch { } } FacebookHelper.postfeedGroup(item.AccessToken, item.Facebookgroupid, feedId, facebookAccount.FbUserId, item.Timeintervalminutes, item.Id); } else { facebookAccount.IsActive = 2; facebookrepo.updateFacebookUserStatus(facebookAccount); sharegrprepo.UpadteShareathonByFacebookUserId(facebookAccount.FbUserId, facebookAccount.UserId); } } catch (Exception ex) { } } }