public int FacebookFans(string userid, string profileid, string days)
{
int counts = 0;
int count = 0;
int Totalcount = 0;
Domain.Socioboard.Domain.FacebookFanPage lstFacebookFanPage = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage lstFacebookFancount = new Domain.Socioboard.Domain.FacebookFanPage();
try
{
string[] arr = profileid.Split(',');
foreach (var item in arr)
{
counts += objrepo.getAllFancountDetail(Guid.Parse(userid), item, Convert.ToInt32(days));
count += objrepo.getAllFancountDetailbeforedays(Guid.Parse(userid), item, Convert.ToInt32(days));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
Totalcount = Math.Abs(counts - count);
return(Totalcount);
}
public int FacebookFans(string userid, string profileid, string days)
{
int counts = 0;
int count = 0;
int Totalcount = 0;
Domain.Socioboard.Domain.FacebookFanPage lstFacebookFanPage = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage lstFacebookFancount = new Domain.Socioboard.Domain.FacebookFanPage();
try
{
string[] arr = profileid.Split(',');
foreach (var item in arr)
{
counts += objrepo.getAllFancountDetail(Guid.Parse(userid), item, Convert.ToInt32(days));
count += objrepo.getAllFancountDetailbeforedays(Guid.Parse(userid), item, Convert.ToInt32(days));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
Totalcount = Math.Abs(counts - count);
return Totalcount;
}
public string getfbfans(string groupid, string userid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
int i = 0;
long[] arr_perday = new long[90];
DateTime present_date = DateTime.Now;
string perday_15 = string.Empty;
string perday_30 = string.Empty;
string perday_60 = string.Empty;
string perday_90 = string.Empty;
string AllProfileId = string.Empty;
string AllProfileIds = string.Empty;
string FbProfileId = string.Empty;
string FbProfileIds = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.Team> teams;
List<Domain.Socioboard.Domain.TeamMemberProfile> teammemberprofiles;
List<Domain.Socioboard.Domain.FacebookFanPage> fbfan_15;
List<Domain.Socioboard.Domain.FacebookFanPage> fbfan_30;
List<Domain.Socioboard.Domain.FacebookFanPage> fbfan_60;
List<Domain.Socioboard.Domain.FacebookFanPage> fbfan_90;
Domain.Socioboard.Domain.FacebookFanPage _15_first = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage _30_first = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage _60_first = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage _90_first = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage _15_last = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage _30_last = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage _60_last = new Domain.Socioboard.Domain.FacebookFanPage();
Domain.Socioboard.Domain.FacebookFanPage _90_last = new Domain.Socioboard.Domain.FacebookFanPage();
long perdayalldata = 0;
try
{
using (NHibernate.ISession session1 = SessionFactory.GetNewSession())
{
teams = session1.CreateQuery("from Team t where t.GroupId = : groupid and t.UserId = : userid ").SetParameter("groupid", Guid.Parse(groupid)).SetParameter("userid", Guid.Parse(userid)).List<Domain.Socioboard.Domain.Team>().ToList();
}
foreach (Domain.Socioboard.Domain.Team team in teams)
{
using (NHibernate.ISession session2 = SessionFactory.GetNewSession())
{
teammemberprofiles = session2.CreateQuery("from TeamMemberProfile t where t.TeamId = : teamid and t.ProfileType = : ProfileType").SetParameter("teamid", team.Id).SetParameter("ProfileType", "facebook_page").List<Domain.Socioboard.Domain.TeamMemberProfile>().ToList();
}
foreach (Domain.Socioboard.Domain.TeamMemberProfile teammemberprofile in teammemberprofiles)
{
try
{
FbProfileId += teammemberprofile.ProfileId + ',';
FbProfileIds += "'" + teammemberprofile.ProfileId + "',";
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
try
{
AllProfileId = FbProfileId.Substring(0, FbProfileId.Length - 1);
AllProfileIds = FbProfileIds.Substring(0, FbProfileIds.Length - 1);
ArrProfileId = AllProfileId.Split(',');
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
if (!string.IsNullOrEmpty(AllProfileId))
{
string strfbfan = "from FacebookFanPage t where t.UserId =: UserId and t.ProfilePageId In(" + AllProfileIds + ")";
using (NHibernate.ISession session3 = SessionFactory.GetNewSession())
{
try
{
fbfan_90 = session3.CreateQuery(strfbfan)
.SetParameter("UserId", Guid.Parse(userid))
.List<Domain.Socioboard.Domain.FacebookFanPage>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-90))).OrderByDescending(y => y.EntryDate).ToList();
}
catch (Exception)
{
fbfan_90 = new List<Domain.Socioboard.Domain.FacebookFanPage>();
}
try
{
fbfan_15 = fbfan_90.Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-15))).OrderByDescending(y => y.EntryDate).ToList();
}
catch (Exception)
{
fbfan_15 = new List<Domain.Socioboard.Domain.FacebookFanPage>();
}
try
{
fbfan_30 = fbfan_90.Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-30))).OrderByDescending(y => y.EntryDate).ToList();
}
catch (Exception)
{
fbfan_30 = new List<Domain.Socioboard.Domain.FacebookFanPage>();
}
try
{
fbfan_60 = fbfan_90.Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-60))).OrderByDescending(y => y.EntryDate).ToList();
}
catch (Exception)
{
fbfan_60 = new List<Domain.Socioboard.Domain.FacebookFanPage>();
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
perdayalldata = 0;
foreach (string profileid in ArrProfileId)
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
List<Domain.Socioboard.Domain.FacebookFanPage> lstresult = fbfan_90.Where(t => t.EntryDate >= present_date.Date.AddSeconds(1) && t.EntryDate <= present_date.Date.AddDays(1).AddSeconds(-1)).OrderByDescending(t => t.EntryDate).ToList();
if (lstresult.Count > 0)
{
Domain.Socioboard.Domain.FacebookFanPage _result = lstresult.First();
Domain.Socioboard.Domain.FacebookFanPage _result1 = lstresult.Last();
long add_data = long.Parse(_result.FanpageCount);
long add_data1 = long.Parse(_result1.FanpageCount);
long newfollowerdata = add_data - add_data1;
perdayalldata += newfollowerdata;
}
else
{
perdayalldata += 0;
}
}
}
catch (Exception e)
{
logger.Error("perdayfberror >>" + e);
Console.Write(e.StackTrace);
}
}
arr_perday[i] = perdayalldata;
i++;
logger.Error("perdayfb>>" + perday_90);
present_date = present_date.AddDays(-1);
}
for (i = 0; i < 90; i++)
{
perday_90 = perday_90 + arr_perday[i].ToString() + ",";
}
try
{
string[] arr = perday_90.Split(',');
for (i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
}
catch (Exception)
{
}
if (fbfan_15.Count > 0)
{
_15_first = fbfan_15.First();
_15_last = fbfan_15.Last();
r._15 = long.Parse(_15_first.FanpageCount) - long.Parse(_15_last.FanpageCount);
}
else
{
r._15 = 0;
}
if (fbfan_30.Count > 0)
{
_30_first = fbfan_30.First();
_30_last = fbfan_30.Last();
r._30 = long.Parse(_30_first.FanpageCount) - long.Parse(_30_last.FanpageCount);
}
else
{
r._30 = 0;
}
if (fbfan_60.Count > 0)
{
_60_first = fbfan_60.First();
_60_last = fbfan_60.Last();
r._60 = long.Parse(_60_first.FanpageCount) - long.Parse(_60_last.FanpageCount);
}
else
{
r._60 = 0;
}
if (fbfan_90.Count > 0)
{
_90_first = fbfan_90.First();
_90_last = fbfan_90.Last();
r._90 = long.Parse(_90_first.FanpageCount) - long.Parse(_90_last.FanpageCount);
}
else
{
r._90 = 0;
}
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
}
}
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
