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)
{
}
}
}
