public string gettwitterfollowers(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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] perdayalldatas = { };
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.Team> teams;
List<Domain.Socioboard.Domain.TeamMemberProfile> teammemberprofiles;
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_15 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_30 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_60 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_90 = new List<Domain.Socioboard.Domain.InboxMessages>();
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
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", "twitter").List<Domain.Socioboard.Domain.TeamMemberProfile>().ToList();
}
foreach (Domain.Socioboard.Domain.TeamMemberProfile teammemberprofile in teammemberprofiles)
{
try
{
TwtProfileId += teammemberprofile.ProfileId + ',';
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
try
{
AllProfileId = TwtProfileId.Substring(0, TwtProfileId.Length - 1);
ArrProfileId = AllProfileId.Split(',');
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
if (!string.IsNullOrEmpty(AllProfileId))
{
InboxMessages_90 = session.Query<Domain.Socioboard.Domain.InboxMessages>().Where(U => U.Status == 0 && U.CreatedTime < DateTime.Now.AddDays(1).Date && U.CreatedTime >= (DateTime.Now.AddDays(-90).Date.AddSeconds(1)) && ArrProfileId.Contains(U.ProfileId) && U.MessageType == "twt_followers").GroupBy(x => new { x.ProfileId,x.FromId}).Select(g=>g.First()).ToList<Domain.Socioboard.Domain.InboxMessages>();
InboxMessages_60 = InboxMessages_90.Where(U => U.CreatedTime < DateTime.Now.AddDays(1).Date && U.CreatedTime >= (DateTime.Now.AddDays(-60).Date.AddSeconds(1))).ToList();
InboxMessages_30 = InboxMessages_90.Where(U => U.CreatedTime < DateTime.Now.AddDays(1).Date && U.CreatedTime >= (DateTime.Now.AddDays(-30).Date.AddSeconds(1))).ToList();
InboxMessages_15 = InboxMessages_90.Where(U => U.CreatedTime < DateTime.Now.AddDays(1).Date && U.CreatedTime >= (DateTime.Now.AddDays(-15).Date.AddSeconds(1))).ToList();
present_date = DateTime.Now;
i = 0;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
//List<Domain.Socioboard.Domain.InboxMessages> lstresult = session4.Query<Domain.Socioboard.Domain.TwitterAccountFollowers>().Where(t => t.ProfileId == id && t.EntryDate >= present_date.Date.AddSeconds(1) && t.EntryDate <= present_date.AddDays(1).Date.AddSeconds(-1)).OrderByDescending(t => t.EntryDate).ToList();
List<Domain.Socioboard.Domain.InboxMessages> lstresult = InboxMessages_90.Where(t => t.CreatedTime >= present_date.Date.AddSeconds(1) && t.CreatedTime <= present_date.AddDays(1).Date.AddSeconds(-1)).ToList();
if (lstresult.Count > 0)
{
int newfollowerdata = lstresult.Count();
perday_90 = perday_90 + newfollowerdata.ToString() + ",";
}
else
{
perday_90 += "0,";
}
}
}
catch (Exception e)
{
logger.Error("perdaytwtnerror >>" + e.Message);
}
//logger.Error("perdaytwtn>>" + perday_90);
present_date = present_date.AddDays(-1);
}
if (InboxMessages_15.Count > 0)
{
r._15 = InboxMessages_15.Count;
}
else
{
r._15 = 0;
}
if (InboxMessages_30.Count > 0)
{
r._30 = InboxMessages_30.Count;
}
else
{
r._30 = 0;
}
if (InboxMessages_60.Count > 0)
{
r._60 = InboxMessages_60.Count;
}
else
{
r._60 = 0;
}
if (InboxMessages_90.Count > 0)
{
r._90 = InboxMessages_90.Count;
}
else
{
r._90 = 0;
}
}
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)
{
}
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;
}
public string gettwittersexdivision(string groupid, string userid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 firstname = string.Empty;
string AllProfileId = string.Empty;
string FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.Team> teams;
List<Domain.Socioboard.Domain.TeamMemberProfile> teammemberprofiles;
List<Domain.Socioboard.Domain.TwitterFollowerNames> twtfollowernames;
long total = 0;
long male_count = 0;
long female_count = 0;
string ret_string = string.Empty;
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("ProfileType", "twitter").SetParameter("teamid", team.Id).List<Domain.Socioboard.Domain.TeamMemberProfile>().ToList();
}
foreach (Domain.Socioboard.Domain.TeamMemberProfile teammemberprofile in teammemberprofiles)
{
try
{
AllProfileId += teammemberprofile.ProfileId + ',';
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
try
{
AllProfileId = AllProfileId.Substring(0, AllProfileId.Length - 1);
ArrProfileId = AllProfileId.Split(',');
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
if (!string.IsNullOrEmpty(AllProfileId))
{
string strtwtfollowernames = "from TwitterFollowerNames t where t.TwitterProfileId In(" + AllProfileId + ")";
using (NHibernate.ISession session3 = SessionFactory.GetNewSession())
{
twtfollowernames = session3.CreateQuery(strtwtfollowernames).List<Domain.Socioboard.Domain.TwitterFollowerNames>().ToList();
}
total += twtfollowernames.Count;
if (total > 0)
{
foreach (Domain.Socioboard.Domain.TwitterFollowerNames twtfollowername in twtfollowernames)
{
if (twtfollowername.Name.Contains(" "))
{
firstname = twtfollowername.Name.Split(' ')[0];
}
else
{
firstname = twtfollowername.Name;
}
string namecheck = "from TwitterNameTable t where t.Name =: name ";
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
NHibernate.IQuery querry = session4.CreateQuery(namecheck).SetParameter("name", firstname);
Domain.Socioboard.Domain.TwitterNameTable _TwitterNameTable = (Domain.Socioboard.Domain.TwitterNameTable)querry.UniqueResult();
if (_TwitterNameTable != null)
{
if (_TwitterNameTable.Gender == 1)
{
male_count++;
}
}
else
{
int length = (firstname.Length) / 2;
string sub_name = firstname.Substring(0, length);
using (NHibernate.ISession session5 = SessionFactory.GetNewSession())
{
List<Domain.Socioboard.Domain.TwitterNameTable> root_names = session5.Query<Domain.Socioboard.Domain.TwitterNameTable>().Where(x => x.Name.Contains(sub_name)).ToList<Domain.Socioboard.Domain.TwitterNameTable>();
int ret = cosine_similarity(root_names, firstname);
if (ret == 1)
{
male_count++;
}
}
}
}
}
}
else
{
ret_string = "0,0";
}
}
}
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
if (ret_string.Equals("0,0"))
{
}
else
{
female_count = total - male_count;
ret_string = male_count.ToString() + "," + female_count.ToString();
}
return ret_string;
}
public string getsentmessage(string groupid, string userid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
long _15 = 0;
long _30 = 0;
long _60 = 0;
long _90 = 0;
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 TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.Team> teams;
List<Domain.Socioboard.Domain.TeamMemberProfile> teammemberprofiles;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_15;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_30;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_60;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_90;
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_15;
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_30;
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_60;
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_90;
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 ").SetParameter("teamid", team.Id).List<Domain.Socioboard.Domain.TeamMemberProfile>().ToList();
}
foreach (Domain.Socioboard.Domain.TeamMemberProfile teammemberprofile in teammemberprofiles)
{
try
{
AllProfileId += teammemberprofile.ProfileId + ',';
AllProfileIds += "'" + teammemberprofile.ProfileId + "',";
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
try
{
AllProfileId = AllProfileId.Substring(0, AllProfileId.Length - 1);
AllProfileIds = AllProfileIds.Substring(0, AllProfileIds.Length - 1);
ArrProfileId = AllProfileId.Split(',');
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
if (!string.IsNullOrEmpty(AllProfileId))
{
string strtwitterdirectmessages = "from TwitterDirectMessages t where t.UserId =: UserId and t.SenderId In(" + AllProfileIds + ")";
using (NHibernate.ISession session3 = SessionFactory.GetNewSession())
{
twitterdirectmessages_90 = session3.CreateQuery(strtwitterdirectmessages)
.SetParameter("UserId", Guid.Parse(userid))
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate > (DateTime.Now.AddDays(-90).Date)).ToList();
twitterdirectmessages_60 = twitterdirectmessages_90.Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate > (DateTime.Now.AddDays(-60).Date)).ToList();
twitterdirectmessages_30 = twitterdirectmessages_90.Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate > (DateTime.Now.AddDays(-30).Date)).ToList();
twitterdirectmessages_15 = twitterdirectmessages_90.Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate > (DateTime.Now.AddDays(-15).Date)).ToList();
}
string strschedule = "from ScheduledMessage t where t.UserId =: UserId and t.Status = : msgtype and t.ProfileId In(" + AllProfileIds + ")";
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
schedule_90 = session4.CreateQuery(strschedule)
.SetParameter("UserId", Guid.Parse(userid))
.SetParameter("msgtype", true)
.List<Domain.Socioboard.Domain.ScheduledMessage>().ToList().Where(x => x.ScheduleTime < DateTime.Now.AddDays(1).Date && x.ScheduleTime > (DateTime.Now.AddDays(-90).Date)).ToList();
schedule_60 = schedule_90.Where(x => x.ScheduleTime < DateTime.Now.AddDays(1).Date && x.ScheduleTime > (DateTime.Now.AddDays(-60).Date)).ToList();
schedule_30 = schedule_90.Where(x => x.ScheduleTime < DateTime.Now.AddDays(1).Date && x.ScheduleTime > (DateTime.Now.AddDays(-30).Date)).ToList();
schedule_15 = schedule_90.Where(x => x.ScheduleTime < DateTime.Now.AddDays(1).Date && x.ScheduleTime > (DateTime.Now.AddDays(-15).Date)).ToList();
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
// int item = session.QueryOver<Domain.Socioboard.Domain.ScheduledMessage>().Where(m => m.ScheduleTime >= present_date.Date && m.ScheduleTime <= present_date.AddDays(1).Date && ArrProfileId.Contains(m.ProfileId) && m.Status == 1).Select(Projections.RowCount()).FutureValue<int>().Value;
using (NHibernate.ISession session5 = SessionFactory.GetNewSession())
{
int item = 0;
int item1 = 0;
try
{
//List<Domain.Socioboard.Domain.ScheduledMessage> perday_schedule_90 = session5.CreateQuery(strschedule)
// .SetParameter("UserId", Guid.Parse(userid))
// .SetParameter("msgtype", true)
// .List<Domain.Socioboard.Domain.ScheduledMessage>().ToList().Where(x => x.ScheduleTime <= present_date.AddDays(1).Date.AddSeconds(-1) && x.ScheduleTime >= present_date.Date.AddSeconds(1)).ToList();
List<Domain.Socioboard.Domain.ScheduledMessage> perday_schedule_90 = schedule_90.Where(x => x.ScheduleTime <= present_date.AddDays(1).Date.AddSeconds(-1) && x.ScheduleTime >= present_date.Date.AddSeconds(1)).ToList();
item = perday_schedule_90.Count;
}
catch (Exception e)
{
item = 0;
}
try
{
//List<Domain.Socioboard.Domain.TwitterDirectMessages> perday_twitterdirectmessages_90 = session5.CreateQuery(strtwitterdirectmessages)
// .SetParameter("UserId", Guid.Parse(userid))
// .List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.CreatedDate <= present_date.AddDays(1).Date.AddSeconds(-1) && x.CreatedDate >= present_date.Date.AddSeconds(1)).ToList();
List<Domain.Socioboard.Domain.TwitterDirectMessages> perday_twitterdirectmessages_90 = twitterdirectmessages_90.Where(x => x.CreatedDate <= present_date.AddDays(1).Date.AddSeconds(-1) && x.CreatedDate >= present_date.Date.AddSeconds(1)).ToList();
item1 = perday_twitterdirectmessages_90.Count;
}
catch (Exception e)
{
item1 = 0;
}
int add_data = item + item1;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdaysent >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdaysenterror >>" + e);
Console.Write(e.StackTrace);
}
}
try
{
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
}
catch (Exception)
{
}
r._15 = twitterdirectmessages_15.Count + schedule_15.Count;
r._30 = twitterdirectmessages_30.Count + schedule_30.Count;
r._60 = twitterdirectmessages_60.Count + schedule_60.Count;
r._90 = twitterdirectmessages_90.Count + schedule_90.Count;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
}
}
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string InstagramPostLikesGained(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 ret_string = string.Empty;
List<Domain.Socioboard.Domain.InstagramPostLikes> postlikes_15 = new List<Domain.Socioboard.Domain.InstagramPostLikes>();
List<Domain.Socioboard.Domain.InstagramPostLikes> postlikes_30 = new List<Domain.Socioboard.Domain.InstagramPostLikes>();
List<Domain.Socioboard.Domain.InstagramPostLikes> postlikes_60 = new List<Domain.Socioboard.Domain.InstagramPostLikes>();
List<Domain.Socioboard.Domain.InstagramPostLikes> postlikes_90 = new List<Domain.Socioboard.Domain.InstagramPostLikes>();
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
string follow_str = "from InstagramPostLikes i where i.Profile_Id = : ProfileId";
try
{
postlikes_90 = session.CreateQuery(follow_str).SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.InstagramPostLikes>().ToList().Where(x => x.Created_Date < DateTime.Now.AddDays(1).Date && x.Created_Date > (DateTime.Now.AddDays(-90).Date)).OrderByDescending(y => y.Created_Date).ToList();
postlikes_60 = postlikes_90.Where(x => x.Created_Date <= DateTime.Now && x.Created_Date >= (DateTime.Now.AddDays(-60))).OrderByDescending(y => y.Created_Date).ToList();
postlikes_30 = postlikes_90.Where(x => x.Created_Date <= DateTime.Now && x.Created_Date >= (DateTime.Now.AddDays(-30))).OrderByDescending(y => y.Created_Date).ToList();
postlikes_15 = postlikes_90.Where(x => x.Created_Date <= DateTime.Now && x.Created_Date >= (DateTime.Now.AddDays(-15))).OrderByDescending(y => y.Created_Date).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session2 = SessionFactory.GetNewSession())
{
// List<Domain.Socioboard.Domain.InstagramPostLikes> lstresult = session2.Query<Domain.Socioboard.Domain.InstagramPostLikes>().Where(t => t.Profile_Id == profileid && t.Created_Date >= present_date.Date.AddSeconds(1) && t.Created_Date <= present_date.Date.AddDays(1).AddSeconds(-1)).OrderByDescending(t => t.Created_Date).ToList();
List<Domain.Socioboard.Domain.InstagramPostLikes> lstresult = postlikes_90.Where(t => t.Created_Date >= present_date.Date.AddSeconds(1) && t.Created_Date <= present_date.Date.AddDays(1).AddSeconds(-1)).OrderByDescending(t => t.Created_Date).ToList();
if (lstresult.Count > 0)
{
int item = lstresult.Count;
perday_90 = perday_90 + item.ToString() + ",";
}
else
{
perday_90 = perday_90 + "0,";
}
present_date = present_date.AddDays(-1);
//logger.Error("perdaylikes >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdaylikeserror >>" + e.Message);
}
}
try
{
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
}
catch { }
r._15 = postlikes_15.Count;
r._30 = postlikes_30.Count;
r._60 = postlikes_60.Count;
r._90 = postlikes_90.Count;
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;
}
public string GetVideoPosts(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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;
int item_15 = 0;
int item_30 = 0;
int item_60 = 0;
int item_90 = 0;
string ret_string = string.Empty;
List<Domain.Socioboard.Domain.InstagramSelfFeed> InstagramSelfFeed_15 = new List<Domain.Socioboard.Domain.InstagramSelfFeed>();
List<Domain.Socioboard.Domain.InstagramSelfFeed> InstagramSelfFeed_30 = new List<Domain.Socioboard.Domain.InstagramSelfFeed>();
List<Domain.Socioboard.Domain.InstagramSelfFeed> InstagramSelfFeed_60 = new List<Domain.Socioboard.Domain.InstagramSelfFeed>();
List<Domain.Socioboard.Domain.InstagramSelfFeed> InstagramSelfFeed_90 = new List<Domain.Socioboard.Domain.InstagramSelfFeed>();
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
InstagramSelfFeed_90 = session.Query<Domain.Socioboard.Domain.InstagramSelfFeed>().Where(m => m.Created_Time < present_date.AddDays(1).Date && m.Created_Time > present_date.AddDays(-90).Date && m.Type == "video" && m.ProfileId == profileid).GroupBy(x => x.FeedId).Select(g => g.First()).ToList();
InstagramSelfFeed_60 = InstagramSelfFeed_90.Where(m => m.Created_Time < present_date.AddDays(1).Date && m.Created_Time > present_date.AddDays(-60).Date).ToList();
InstagramSelfFeed_30 = InstagramSelfFeed_90.Where(m => m.Created_Time < present_date.AddDays(1).Date && m.Created_Time > present_date.AddDays(-30).Date).ToList();
InstagramSelfFeed_15 = InstagramSelfFeed_90.Where(m => m.Created_Time < present_date.AddDays(1).Date && m.Created_Time > present_date.AddDays(-15).Date).ToList();
item_90 = InstagramSelfFeed_90.Count;
item_60 = InstagramSelfFeed_60.Count;
item_30 = InstagramSelfFeed_30.Count;
item_15 = InstagramSelfFeed_15.Count;
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
List<Domain.Socioboard.Domain.InstagramSelfFeed> _InstagramSelfFeed = new List<Domain.Socioboard.Domain.InstagramSelfFeed>();
//using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
//{
int item = 0;
try
{
//item = session4.QueryOver<Domain.Socioboard.Domain.InstagramSelfFeed>().Where(m => m.Created_Time >= present_date.Date.AddSeconds(1) && m.Created_Time <= present_date.AddDays(1).Date.AddSeconds(-1) && m.Type == "video" && m.ProfileId == profileid)
// .Select(Projections.CountDistinct<Domain.Socioboard.Domain.InstagramSelfFeed>(x => x.FeedId))
// .FutureValue<int>().Value;
_InstagramSelfFeed = InstagramSelfFeed_90.Where(m => m.Created_Time >= present_date.Date.AddSeconds(1) && m.Created_Time <= present_date.AddDays(1).Date.AddSeconds(-1)).ToList();
item = _InstagramSelfFeed.Count;
}
catch (Exception e)
{
item = 0;
}
int add_data = item;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdayvideoposts >>" + perday_90);
//}
}
catch (Exception e)
{
logger.Error("perdayvideopostserror >>" + e.Message);
}
}
try
{
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
}
catch (Exception)
{
}
r._15 = item_15;
r._30 = item_30;
r._60 = item_60;
r._90 = item_90;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
}
ret_string = new JavaScriptSerializer().Serialize(r);
return ret_string;
}
public string newfollower(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_15 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_30 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_60 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> InboxMessages_90 = new List<Domain.Socioboard.Domain.InboxMessages>();
//string strtwitterfollowers = "from InboxMessages t where t.ProfileId =: ProfileId and t.MessageType =: MessageType";
//string strtwitterfollowers = "from TwitterAccountFollowers t where t.ProfileId =: ProfileId";
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
InboxMessages_90 = session.Query<Domain.Socioboard.Domain.InboxMessages>().Where(U => U.Status == 0 && U.CreatedTime < DateTime.Now.AddDays(1).Date && U.CreatedTime >= (DateTime.Now.AddDays(-90).Date.AddSeconds(1)) && U.ProfileId == profileid && U.MessageType == "twt_followers").GroupBy(x => x.FromId).Select(g => g.First()).ToList<Domain.Socioboard.Domain.InboxMessages>();
InboxMessages_60 = InboxMessages_90.Where(x => x.CreatedTime < DateTime.Now.AddDays(1).Date && x.CreatedTime >= (DateTime.Now.AddDays(-60).Date.AddSeconds(1))).ToList();
InboxMessages_30 = InboxMessages_90.Where(x => x.CreatedTime < DateTime.Now.AddDays(1).Date && x.CreatedTime >= (DateTime.Now.AddDays(-30).Date.AddSeconds(1))).ToList();
InboxMessages_15 = InboxMessages_90.Where(x => x.CreatedTime < DateTime.Now.AddDays(1).Date && x.CreatedTime >= (DateTime.Now.AddDays(-15).Date.AddSeconds(1))).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
List<Domain.Socioboard.Domain.InboxMessages> lstresult = InboxMessages_90.Where(t => t.CreatedTime >= present_date.Date.AddSeconds(1) && t.CreatedTime <= present_date.Date.AddDays(1).AddSeconds(-1)).ToList();
if (lstresult.Count > 0)
{
perday_90 = perday_90 + lstresult.Count.ToString() + ",";
}
else
{
perday_90 = perday_90 + "0,";
}
logger.Error("perdaytwtn>>" + perday_90);
present_date = present_date.AddDays(-1);
}
}
catch (Exception e)
{
logger.Error("perdaytwtnerror >>" + e);
logger.Error(e.Message);
logger.Error(e.StackTrace);
Console.Write(e.StackTrace);
}
}
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
if (InboxMessages_15.Count > 0)
{
r._15 = InboxMessages_15.Count;
}
else
{
r._15 = 0;
}
if (InboxMessages_30.Count > 0)
{
r._30 = InboxMessages_30.Count;
}
else
{
r._30 = 0;
}
if (InboxMessages_60.Count > 0)
{
r._60 = InboxMessages_60.Count;
}
else
{
r._60 = 0;
}
if (InboxMessages_90.Count > 0)
{
r._90 = InboxMessages_90.Count;
}
else
{
r._90 = 0;
}
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string InstagramFollowingGained(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 ret_string = string.Empty;
List<Domain.Socioboard.Domain.InstagramUserDetails> following_15 = new List<Domain.Socioboard.Domain.InstagramUserDetails>();
List<Domain.Socioboard.Domain.InstagramUserDetails> following_30 = new List<Domain.Socioboard.Domain.InstagramUserDetails>();
List<Domain.Socioboard.Domain.InstagramUserDetails> following_60 = new List<Domain.Socioboard.Domain.InstagramUserDetails>();
List<Domain.Socioboard.Domain.InstagramUserDetails> following_90 = new List<Domain.Socioboard.Domain.InstagramUserDetails>();
Domain.Socioboard.Domain.InstagramUserDetails _15_first = new Domain.Socioboard.Domain.InstagramUserDetails();
Domain.Socioboard.Domain.InstagramUserDetails _15_last = new Domain.Socioboard.Domain.InstagramUserDetails();
Domain.Socioboard.Domain.InstagramUserDetails _30_first = new Domain.Socioboard.Domain.InstagramUserDetails();
Domain.Socioboard.Domain.InstagramUserDetails _30_last = new Domain.Socioboard.Domain.InstagramUserDetails();
Domain.Socioboard.Domain.InstagramUserDetails _60_first = new Domain.Socioboard.Domain.InstagramUserDetails();
Domain.Socioboard.Domain.InstagramUserDetails _60_last = new Domain.Socioboard.Domain.InstagramUserDetails();
Domain.Socioboard.Domain.InstagramUserDetails _90_first = new Domain.Socioboard.Domain.InstagramUserDetails();
Domain.Socioboard.Domain.InstagramUserDetails _90_last = new Domain.Socioboard.Domain.InstagramUserDetails();
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
string follow_str = "from InstagramUserDetails i where i.Profile_Id = : ProfileId";
try
{
following_90 = session.CreateQuery(follow_str).SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.InstagramUserDetails>().ToList().Where(x => x.Created_Time <= DateTime.Now && x.Created_Time >= (DateTime.Now.AddDays(-90))).OrderByDescending(y => y.Created_Time).ToList();
following_60 = following_90.Where(x => x.Created_Time < DateTime.Now.AddDays(1).Date && x.Created_Time > DateTime.Now.AddDays(-60).Date).OrderByDescending(y => y.Created_Time).ToList();
following_30 = following_90.Where(x => x.Created_Time < DateTime.Now.AddDays(1).Date && x.Created_Time > DateTime.Now.AddDays(-30).Date).OrderByDescending(y => y.Created_Time).ToList();
following_15 = following_90.Where(x => x.Created_Time < DateTime.Now.AddDays(1).Date && x.Created_Time > DateTime.Now.AddDays(-15).Date).OrderByDescending(y => y.Created_Time).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
//using (NHibernate.ISession session2 = SessionFactory.GetNewSession())
//{
//List<Domain.Socioboard.Domain.InstagramUserDetails> lstresult = session2.Query<Domain.Socioboard.Domain.InstagramUserDetails>().Where(t => t.Profile_Id == profileid && t.Created_Time >= present_date.Date.AddSeconds(1) && t.Created_Time <= present_date.Date.AddDays(1).AddSeconds(-1)).OrderByDescending(t => t.Created_Time).ToList();
List<Domain.Socioboard.Domain.InstagramUserDetails> lstresult = following_90.Where(t => t.Created_Time >= present_date.Date.AddSeconds(1) && t.Created_Time <= present_date.Date.AddDays(1).AddSeconds(-1)).OrderByDescending(t => t.Created_Time).ToList();
if (lstresult.Count > 0)
{
Domain.Socioboard.Domain.InstagramUserDetails _result = lstresult.First();
Domain.Socioboard.Domain.InstagramUserDetails _result1 = lstresult.Last();
long add_data = long.Parse(_result.Following);
long add_data1 = long.Parse(_result1.Following);
long newfollowerdata = add_data - add_data1;
perday_90 = perday_90 + newfollowerdata.ToString() + ",";
}
else
{
perday_90 = perday_90 + "0,";
}
present_date = present_date.AddDays(-1);
// logger.Error("perdayfollowing >>" + perday_90);
//}
}
catch (Exception e)
{
logger.Error(e.Message);
}
}
try
{
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
}
catch (Exception)
{
}
if (following_15.Count > 0)
{
_15_first = following_15.First();
_15_last = following_15.Last();
r._15 = long.Parse(_15_first.Following) - long.Parse(_15_last.Following);
}
else
{
r._15 = 0;
}
if (following_30.Count > 0)
{
_30_first = following_30.First();
_30_last = following_30.Last();
r._30 = long.Parse(_30_first.Following) - long.Parse(_30_last.Following);
}
else
{
r._30 = 0;
}
if (following_60.Count > 0)
{
_60_first = following_60.First();
_60_last = following_60.Last();
r._60 = long.Parse(_60_first.Following) - long.Parse(_60_last.Following);
}
else
{
r._60 = 0;
}
if (following_90.Count > 0)
{
_90_first = following_90.First();
_90_last = following_90.Last();
r._90 = long.Parse(_90_first.Following) - long.Parse(_90_last.Following);
}
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;
}
public string directmessagesent(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
Domain.Socioboard.Domain.TwitterDirectMessages _15_first = new Domain.Socioboard.Domain.TwitterDirectMessages();
Domain.Socioboard.Domain.TwitterDirectMessages _30_first = new Domain.Socioboard.Domain.TwitterDirectMessages();
Domain.Socioboard.Domain.TwitterDirectMessages _60_first = new Domain.Socioboard.Domain.TwitterDirectMessages();
Domain.Socioboard.Domain.TwitterDirectMessages _90_first = new Domain.Socioboard.Domain.TwitterDirectMessages();
Domain.Socioboard.Domain.TwitterDirectMessages _15_last = new Domain.Socioboard.Domain.TwitterDirectMessages();
Domain.Socioboard.Domain.TwitterDirectMessages _30_last = new Domain.Socioboard.Domain.TwitterDirectMessages();
Domain.Socioboard.Domain.TwitterDirectMessages _60_last = new Domain.Socioboard.Domain.TwitterDirectMessages();
Domain.Socioboard.Domain.TwitterDirectMessages _90_last = new Domain.Socioboard.Domain.TwitterDirectMessages();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_15 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_30 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_60 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_90 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
string strtwitterfollowers = "from TwitterDirectMessages t where t.SenderId =: ProfileId";
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
twitterdirectmessages_15 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-15))).ToList();
twitterdirectmessages_30 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-30))).ToList();
twitterdirectmessages_60 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-60))).ToList();
twitterdirectmessages_90 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-90))).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
int item1 = 0;
try
{
item1 = session4.QueryOver<Domain.Socioboard.Domain.TwitterDirectMessages>().Where(m => m.CreatedDate >= present_date.Date && m.CreatedDate <= present_date.AddDays(1).Date).Where(s => s.SenderId == profileid)
.Select(Projections.CountDistinct<Domain.Socioboard.Domain.TwitterDirectMessages>(x => x.MessageId))
.FutureValue<int>().Value;
}
catch (Exception e)
{
item1 = 0;
}
int add_data = item1;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdaydirectmessagesent>>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdaydmsenterror >>" + e);
Console.Write(e.StackTrace);
}
}
try
{
perday_15 = perday_90.Substring(0, 29);
perday_30 = perday_90.Substring(0, 59);
perday_60 = perday_90.Substring(0, 119);
}
catch (Exception e)
{
logger.Error(e.Message);
}
r._15 = twitterdirectmessages_15.Count;
r._30 = twitterdirectmessages_30.Count;
r._60 = twitterdirectmessages_60.Count;
r._90 = twitterdirectmessages_90.Count;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string twitterretweets(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_15 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_30 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_60 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_90 = new List<Domain.Socioboard.Domain.InboxMessages>();
string strtwitterfollowers = "from InboxMessages t where t.ProfileId =: ProfileId and t.MessageType = : msgtype";
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
inboxmessages_15 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.SetParameter("msgtype", "twt_retweet")
.List<Domain.Socioboard.Domain.InboxMessages>().ToList().Where(x => x.EntryTime <= DateTime.Now && x.EntryTime >= (DateTime.Now.AddDays(-15))).ToList();
inboxmessages_30 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.SetParameter("msgtype", "twt_retweet")
.List<Domain.Socioboard.Domain.InboxMessages>().ToList().Where(x => x.EntryTime <= DateTime.Now && x.EntryTime >= (DateTime.Now.AddDays(-30))).ToList();
inboxmessages_60 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.SetParameter("msgtype", "twt_retweet")
.List<Domain.Socioboard.Domain.InboxMessages>().ToList().Where(x => x.EntryTime <= DateTime.Now && x.EntryTime >= (DateTime.Now.AddDays(-60))).ToList();
inboxmessages_90 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.SetParameter("msgtype", "twt_retweet")
.List<Domain.Socioboard.Domain.InboxMessages>().ToList().Where(x => x.EntryTime <= DateTime.Now && x.EntryTime >= (DateTime.Now.AddDays(-90))).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
int item = 0;
try
{
item = session4.QueryOver<Domain.Socioboard.Domain.InboxMessages>().Where(m => m.CreatedTime >= present_date.Date && m.CreatedTime <= present_date.AddDays(1).Date && m.MessageType == "twt_retweet").Where(s => s.RecipientId == profileid)
.Select(Projections.CountDistinct<Domain.Socioboard.Domain.InboxMessages>(x => x.MessageId))
.FutureValue<int>().Value;
}
catch (Exception e)
{
item = 0;
}
int add_data = item;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdaymention >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdaymentionerror >>" + e);
logger.Error(e.StackTrace);
Console.Write(e.StackTrace);
}
}
try
{
perday_15 = perday_90.Substring(0, 29);
perday_30 = perday_90.Substring(0, 59);
perday_60 = perday_90.Substring(0, 119);
}
catch (Exception e)
{
logger.Error(e.Message);
}
r._15 = inboxmessages_15.Count;
r._30 = inboxmessages_30.Count;
r._60 = inboxmessages_60.Count;
r._90 = inboxmessages_90.Count;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string messagesent(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_15 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_30 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_60 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_90 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_15 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_30 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_60 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
List<Domain.Socioboard.Domain.ScheduledMessage> schedule_90 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
string strtwitterfollowers = "from TwitterDirectMessages t where t.SenderId =: ProfileId";
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
twitterdirectmessages_15 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-15))).ToList();
twitterdirectmessages_30 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-30))).ToList();
twitterdirectmessages_60 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-60))).ToList();
twitterdirectmessages_90 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-90))).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
string strschedule = "from ScheduledMessage t where t.ProfileId =: profileid and t.Status = : msgtype";
using (NHibernate.ISession session2 = SessionFactory.GetNewSession())
{
try
{
schedule_15 = session2.CreateQuery(strschedule)
.SetParameter("profileid", profileid)
.SetParameter("msgtype", true)
.List<Domain.Socioboard.Domain.ScheduledMessage>().ToList().Where(x => x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-15))).ToList();
schedule_30 = session2.CreateQuery(strschedule)
.SetParameter("profileid", profileid)
.SetParameter("msgtype", true)
.List<Domain.Socioboard.Domain.ScheduledMessage>().ToList().Where(x => x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-30))).ToList();
schedule_60 = session2.CreateQuery(strschedule)
.SetParameter("profileid", profileid)
.SetParameter("msgtype", true)
.List<Domain.Socioboard.Domain.ScheduledMessage>().ToList().Where(x => x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-60))).ToList();
schedule_90 = session2.CreateQuery(strschedule)
.SetParameter("profileid", profileid)
.SetParameter("msgtype", true)
.List<Domain.Socioboard.Domain.ScheduledMessage>().ToList().Where(x => x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-90))).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session5 = SessionFactory.GetNewSession())
{
int item = 0;
int item1 = 0;
try
{
List<Domain.Socioboard.Domain.ScheduledMessage> perday_schedule_90 = session5.CreateQuery(strschedule)
.SetParameter("profileid", profileid)
.SetParameter("msgtype", true)
.List<Domain.Socioboard.Domain.ScheduledMessage>().ToList().Where(x => x.ScheduleTime <= present_date.AddDays(1).Date && x.ScheduleTime >= present_date.Date).ToList();
item = perday_schedule_90.Count;
}
catch (Exception e)
{
item = 0;
}
try
{
List<Domain.Socioboard.Domain.TwitterDirectMessages> perday_twitterdirectmessages_90 = session5.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.CreatedDate <= present_date.AddDays(1).Date && x.CreatedDate >= present_date.Date).ToList();
item1 = perday_twitterdirectmessages_90.Count;
}
catch (Exception e)
{
item1 = 0;
}
int add_data = item + item1;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdaysent >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdaydmsenterror >>" + e);
Console.Write(e.StackTrace);
}
}
try
{
perday_15 = perday_90.Substring(0, 29);
perday_30 = perday_90.Substring(0, 59);
perday_60 = perday_90.Substring(0, 119);
}
catch (Exception e)
{
logger.Error(e.Message);
}
r._15 = twitterdirectmessages_15.Count;
r._30 = twitterdirectmessages_30.Count;
r._60 = twitterdirectmessages_60.Count;
r._90 = twitterdirectmessages_90.Count;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string youfollowed(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
Domain.Socioboard.Domain.TwitterAccountFollowers _15_first = new Domain.Socioboard.Domain.TwitterAccountFollowers();
Domain.Socioboard.Domain.TwitterAccountFollowers _30_first = new Domain.Socioboard.Domain.TwitterAccountFollowers();
Domain.Socioboard.Domain.TwitterAccountFollowers _60_first = new Domain.Socioboard.Domain.TwitterAccountFollowers();
Domain.Socioboard.Domain.TwitterAccountFollowers _90_first = new Domain.Socioboard.Domain.TwitterAccountFollowers();
Domain.Socioboard.Domain.TwitterAccountFollowers _15_last = new Domain.Socioboard.Domain.TwitterAccountFollowers();
Domain.Socioboard.Domain.TwitterAccountFollowers _30_last = new Domain.Socioboard.Domain.TwitterAccountFollowers();
Domain.Socioboard.Domain.TwitterAccountFollowers _60_last = new Domain.Socioboard.Domain.TwitterAccountFollowers();
Domain.Socioboard.Domain.TwitterAccountFollowers _90_last = new Domain.Socioboard.Domain.TwitterAccountFollowers();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.TwitterAccountFollowers> twitterfollowers_15 = new List<Domain.Socioboard.Domain.TwitterAccountFollowers>();
List<Domain.Socioboard.Domain.TwitterAccountFollowers> twitterfollowers_30 = new List<Domain.Socioboard.Domain.TwitterAccountFollowers>();
List<Domain.Socioboard.Domain.TwitterAccountFollowers> twitterfollowers_60 = new List<Domain.Socioboard.Domain.TwitterAccountFollowers>();
List<Domain.Socioboard.Domain.TwitterAccountFollowers> twitterfollowers_90 = new List<Domain.Socioboard.Domain.TwitterAccountFollowers>();
string strtwitterfollowers = "from TwitterAccountFollowers t where t.ProfileId =: ProfileId";
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
twitterfollowers_15 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterAccountFollowers>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-15))).ToList();
twitterfollowers_30 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterAccountFollowers>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-30))).ToList();
twitterfollowers_60 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterAccountFollowers>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-60))).ToList();
twitterfollowers_90 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterAccountFollowers>().ToList().Where(x => x.EntryDate <= DateTime.Now && x.EntryDate >= (DateTime.Now.AddDays(-90))).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
List<Domain.Socioboard.Domain.TwitterAccountFollowers> lstresult = session4.Query<Domain.Socioboard.Domain.TwitterAccountFollowers>().Where(t => t.ProfileId == profileid && 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.TwitterAccountFollowers _result = lstresult.First();
string add_data = _result.FollowingsCount.ToString();
perday_90 = perday_90 + add_data + ",";
}
else
{
perday_90 = perday_90 + "0,";
}
logger.Error("perdaytwtf>>" + perday_90);
present_date = present_date.AddDays(-1);
}
}
catch (Exception e)
{
logger.Error("perdaytwtferror >>" + e);
Console.Write(e.StackTrace);
}
}
try
{
perday_15 = perday_90.Substring(0, 29);
perday_30 = perday_90.Substring(0, 59);
perday_60 = perday_90.Substring(0, 119);
}
catch (Exception e)
{
logger.Error(e.Message);
}
if (twitterfollowers_15.Count > 0)
{
_15_first = twitterfollowers_15.First();
_15_last = twitterfollowers_15.Last();
r._15 = _15_first.FollowingsCount - _15_last.FollowingsCount;
}
else
{
r._15 = 0;
}
if (twitterfollowers_30.Count > 0)
{
_30_first = twitterfollowers_30.First();
_30_last = twitterfollowers_30.Last();
r._30 = _30_first.FollowingsCount - _30_last.FollowingsCount;
}
else
{
r._30 = 0;
}
if (twitterfollowers_60.Count > 0)
{
_60_first = twitterfollowers_60.First();
_60_last = twitterfollowers_60.Last();
r._60 = _60_first.FollowingsCount - _60_last.FollowingsCount;
}
else
{
r._60 = 0;
}
if (twitterfollowers_90.Count > 0)
{
_90_first = twitterfollowers_90.First();
_90_last = twitterfollowers_90.Last();
r._90 = _90_first.FollowingsCount - _90_last.FollowingsCount;
}
else
{
r._90 = 0;
}
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string clicks(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.ScheduledMessage> clicks_15 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
List<Domain.Socioboard.Domain.ScheduledMessage> clicks_30 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
List<Domain.Socioboard.Domain.ScheduledMessage> clicks_60 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
List<Domain.Socioboard.Domain.ScheduledMessage> clicks_90 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
List<Domain.Socioboard.Domain.ScheduledMessage> perday_clicks_90 = new List<Domain.Socioboard.Domain.ScheduledMessage>();
string link = "http://bit.ly/";
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
clicks_15 = session.Query<Domain.Socioboard.Domain.ScheduledMessage>().Where(x => x.ShareMessage.Contains(link) && x.ProfileId == profileid && x.Status == true && x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-15))).ToList<Domain.Socioboard.Domain.ScheduledMessage>();
clicks_30 = session.Query<Domain.Socioboard.Domain.ScheduledMessage>().Where(x => x.ShareMessage.Contains(link) && x.ProfileId == profileid && x.Status == true && x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-30))).ToList<Domain.Socioboard.Domain.ScheduledMessage>();
clicks_60 = session.Query<Domain.Socioboard.Domain.ScheduledMessage>().Where(x => x.ShareMessage.Contains(link) && x.ProfileId == profileid && x.Status == true && x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-60))).ToList<Domain.Socioboard.Domain.ScheduledMessage>();
clicks_90 = session.Query<Domain.Socioboard.Domain.ScheduledMessage>().Where(x => x.ShareMessage.Contains(link) && x.ProfileId == profileid && x.Status == true && x.ScheduleTime <= DateTime.Now && x.ScheduleTime >= (DateTime.Now.AddDays(-90))).ToList<Domain.Socioboard.Domain.ScheduledMessage>();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
int item = 0;
try
{
perday_clicks_90 = session4.Query<Domain.Socioboard.Domain.ScheduledMessage>().Where(x => x.ShareMessage.Contains(link) && x.ProfileId == profileid && x.Status == true && x.ScheduleTime <= present_date.AddDays(1).Date && x.ScheduleTime >= present_date.Date).ToList<Domain.Socioboard.Domain.ScheduledMessage>();
item = perday_clicks_90.Count;
}
catch (Exception e)
{
item = 0;
}
int add_data = item;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdayclick >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdayclickerror >>" + e);
logger.Error(e.StackTrace);
Console.Write(e.StackTrace);
}
}
try
{
perday_15 = perday_90.Substring(0, 29);
perday_30 = perday_90.Substring(0, 59);
perday_60 = perday_90.Substring(0, 119);
}
catch (Exception e)
{
logger.Error(e.Message);
}
r._15 = clicks_15.Count;
r._30 = clicks_30.Count;
r._60 = clicks_60.Count;
r._90 = clicks_90.Count;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string directmessage(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_15 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_30 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_60 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_90 = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
string strtwitterfollowers = "from TwitterDirectMessages t where t.RecipientId =: ProfileId";
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
twitterdirectmessages_90 = session.CreateQuery(strtwitterfollowers)
.SetParameter("ProfileId", profileid)
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.CreatedDate <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedDate >= (DateTime.Now.AddDays(-90).Date.AddSeconds(1))).GroupBy(x => x.MessageId).Select(g => g.First()).ToList();
twitterdirectmessages_60 = twitterdirectmessages_90.Where(x => x.CreatedDate <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedDate >= (DateTime.Now.AddDays(-60).Date.AddSeconds(1))).ToList();
twitterdirectmessages_30 = twitterdirectmessages_90.Where(x => x.CreatedDate <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedDate >= (DateTime.Now.AddDays(-30).Date.AddSeconds(1))).ToList();
twitterdirectmessages_15 = twitterdirectmessages_90.Where(x => x.CreatedDate <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedDate >= (DateTime.Now.AddDays(-15).Date.AddSeconds(1))).ToList();
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session1 = SessionFactory.GetNewSession())
{
List<Domain.Socioboard.Domain.TwitterDirectMessages> _twitterdirectmessages = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
int item1;
try
{
_twitterdirectmessages = twitterdirectmessages_90.Where(m => m.CreatedDate >= present_date.Date.AddSeconds(1) && m.CreatedDate <= present_date.AddDays(1).Date.AddSeconds(-1)).ToList();
//item1 = session1.QueryOver<Domain.Socioboard.Domain.TwitterDirectMessages>().Where(m => m.CreatedDate >= present_date.Date.AddSeconds(1) && m.CreatedDate <= present_date.AddDays(1).Date.AddSeconds(-1)).Where( S => S.RecipientId == profileid)
// .Select(Projections.CountDistinct<Domain.Socioboard.Domain.TwitterDirectMessages>(x => x.MessageId))
// .FutureValue<int>().Value;
}
catch (Exception e)
{
item1 = 0;
}
int add_data = _twitterdirectmessages.Count;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdayinbox >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdaydmerror >>" + e);
logger.Error(e.Message);
logger.Error(e.StackTrace);
Console.Write(e.StackTrace);
}
}
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
r._15 = twitterdirectmessages_15.Count;
r._30 = twitterdirectmessages_30.Count;
r._60 = twitterdirectmessages_60.Count;
r._90 = twitterdirectmessages_90.Count;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
public string gettwittersexdivision(string profileid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 firstname = string.Empty;
string AllProfileId = string.Empty;
string FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
List<Domain.Socioboard.Domain.Team> teams;
List<Domain.Socioboard.Domain.TeamMemberProfile> teammemberprofiles;
List<Domain.Socioboard.Domain.TwitterFollowerNames> twtfollowernames;
long total = 0;
long male_count = 0;
long female_count = 0;
string ret_string = string.Empty;
try
{
string strtwtfollowernames = "from TwitterFollowerNames t where t.TwitterProfileId = : profileid)";
using (NHibernate.ISession session3 = SessionFactory.GetNewSession())
{
twtfollowernames = session3.CreateQuery(strtwtfollowernames).SetParameter("profileid", profileid).List<Domain.Socioboard.Domain.TwitterFollowerNames>().ToList();
}
total += twtfollowernames.Count;
if (total > 0)
{
foreach (Domain.Socioboard.Domain.TwitterFollowerNames twtfollowername in twtfollowernames)
{
if (twtfollowername.Name.Contains(" "))
{
firstname = twtfollowername.Name.Split(' ')[0];
}
else
{
firstname = twtfollowername.Name;
}
string namecheck = "from TwitterNameTable t where t.Name =: name ";
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
NHibernate.IQuery querry = session4.CreateQuery(namecheck).SetParameter("name", firstname);
Domain.Socioboard.Domain.TwitterNameTable _TwitterNameTable = (Domain.Socioboard.Domain.TwitterNameTable)querry.UniqueResult();
if (_TwitterNameTable != null)
{
if (_TwitterNameTable.Gender == 1)
{
male_count++;
}
}
else
{
int length = (firstname.Length) / 2;
string sub_name = firstname.Substring(0, length);
using (NHibernate.ISession session5 = SessionFactory.GetNewSession())
{
List<Domain.Socioboard.Domain.TwitterNameTable> root_names = session5.Query<Domain.Socioboard.Domain.TwitterNameTable>().Where(x => x.Name.Contains(sub_name)).ToList<Domain.Socioboard.Domain.TwitterNameTable>();
int ret = cosine_similarity(root_names, firstname);
if (ret == 1)
{
male_count++;
}
}
}
}
}
}
else
{
ret_string = "0,0";
}
}
catch (Exception e)
{
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
if (ret_string.Equals("0,0"))
{
}
else
{
female_count = total - male_count;
ret_string = male_count.ToString() + "," + female_count.ToString();
}
return ret_string;
}
public string getinboxcount(string groupid, string userid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
long _15 = 0;
long _30 = 0;
long _60 = 0;
long _90 = 0;
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_15;
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_30;
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_60;
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_90;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_15;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_30;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_60;
List<Domain.Socioboard.Domain.TwitterDirectMessages> twitterdirectmessages_90;
List<Domain.Socioboard.Domain.Team> teams;
List<Domain.Socioboard.Domain.TeamMemberProfile> teammemberprofiles;
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
teams = session4.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 session5 = SessionFactory.GetNewSession())
{
teammemberprofiles = session5.CreateQuery("from TeamMemberProfile t where t.TeamId = : teamid and t.ProfileType =: ProfileType").SetParameter("ProfileType", "twitter").SetParameter("teamid", team.Id).List<Domain.Socioboard.Domain.TeamMemberProfile>().ToList();
}
foreach (Domain.Socioboard.Domain.TeamMemberProfile teammemberprofile in teammemberprofiles)
{
try
{
AllProfileId += teammemberprofile.ProfileId + ',';
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
try
{
AllProfileId = AllProfileId.Substring(0, AllProfileId.Length - 1);
ArrProfileId = AllProfileId.Split(',');
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
if (!string.IsNullOrEmpty(AllProfileId))
{
string strtwitterdirectmessages = "from TwitterDirectMessages t where t.UserId =: UserId and t.RecipientId In(" + AllProfileId + ")";
using (NHibernate.ISession session2 = SessionFactory.GetNewSession())
{
twitterdirectmessages_90 = session2.CreateQuery(strtwitterdirectmessages)
.SetParameter("UserId", Guid.Parse(userid))
.List<Domain.Socioboard.Domain.TwitterDirectMessages>().ToList().Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate >= (DateTime.Now.AddDays(-90).Date)).ToList();
twitterdirectmessages_60 = twitterdirectmessages_90.Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate >= (DateTime.Now.AddDays(-60).Date)).ToList();
twitterdirectmessages_30 = twitterdirectmessages_90.Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate >= (DateTime.Now.AddDays(-30).Date)).ToList();
twitterdirectmessages_15 = twitterdirectmessages_90.Where(x => x.CreatedDate < DateTime.Now.AddDays(1).Date && x.CreatedDate >= (DateTime.Now.AddDays(-15).Date)).ToList();
}
string strinboxmessages = "from InboxMessages t where t.UserId =: UserId and t.MessageType = : msgtype and t.RecipientId In(" + AllProfileId + ")";
using (NHibernate.ISession session3 = SessionFactory.GetNewSession())
{
inboxmessages_90 = session3.CreateQuery(strinboxmessages)
.SetParameter("UserId", Guid.Parse(userid))
.SetParameter("msgtype", "twt_mention")
.List<Domain.Socioboard.Domain.InboxMessages>().ToList().Where(x => x.CreatedTime < DateTime.Now.AddDays(1).Date && x.CreatedTime >= (DateTime.Now.AddDays(-90).Date)).ToList();
inboxmessages_60 = inboxmessages_90.Where(x => x.CreatedTime < DateTime.Now.AddDays(1).Date && x.CreatedTime >= (DateTime.Now.AddDays(-60).Date)).ToList();
inboxmessages_30 = inboxmessages_90.Where(x => x.CreatedTime < DateTime.Now.AddDays(1).Date && x.CreatedTime >= (DateTime.Now.AddDays(-30).Date)).ToList();
inboxmessages_15 = inboxmessages_90.Where(x => x.CreatedTime < DateTime.Now.AddDays(1).Date && x.CreatedTime >= (DateTime.Now.AddDays(-15).Date)).ToList();
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
List<Domain.Socioboard.Domain.InboxMessages> _inboxmessages = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.TwitterDirectMessages> _twitterdirectmessages = new List<Domain.Socioboard.Domain.TwitterDirectMessages>();
try
{
using (NHibernate.ISession session1 = SessionFactory.GetNewSession())
{
int item = 0;
int item1 = 0;
try
{
//item = session1.QueryOver<Domain.Socioboard.Domain.InboxMessages>().Where(m => m.CreatedTime >= present_date.Date.AddSeconds(1) && m.CreatedTime <= present_date.AddDays(1).Date.AddSeconds(-1) && m.MessageType == "twt_mention").WhereRestrictionOn(S => S.RecipientId).IsIn(ArrProfileId)
// .Select(Projections.CountDistinct<Domain.Socioboard.Domain.InboxMessages>(x => x.MessageId))
// .FutureValue<int>().Value;
_inboxmessages = inboxmessages_90.Where(m => m.CreatedTime >= present_date.Date.AddSeconds(1) && m.CreatedTime <= present_date.AddDays(1).Date.AddSeconds(-1)).ToList();
item = _inboxmessages.Count;
}
catch (Exception e)
{
item = 0;
}
try
{
//item1 = session1.QueryOver<Domain.Socioboard.Domain.TwitterDirectMessages>().Where(m => m.CreatedDate >= present_date.Date.AddSeconds(1) && m.CreatedDate <= present_date.AddDays(1).Date.AddSeconds(-1)).WhereRestrictionOn(S => S.RecipientId).IsIn(ArrProfileId)
// .Select(Projections.CountDistinct<Domain.Socioboard.Domain.TwitterDirectMessages>(x => x.MessageId))
// .FutureValue<int>().Value;
_twitterdirectmessages = twitterdirectmessages_90.Where(m => m.CreatedDate >= present_date.Date.AddSeconds(1) && m.CreatedDate <= present_date.AddDays(1).Date.AddSeconds(-1)).ToList();
item1 = _twitterdirectmessages.Count;
}
catch (Exception e)
{
item1 = 0;
}
int add_data = item + item1;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
//logger.Error("perdayinbox >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdayinboxerror >>" + e.Message);
}
}
try
{
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
}
catch (Exception)
{
}
r._15 = twitterdirectmessages_15.Count + inboxmessages_15.Count;
r._30 = twitterdirectmessages_30.Count + inboxmessages_30.Count;
r._60 = twitterdirectmessages_60.Count + inboxmessages_60.Count;
r._90 = twitterdirectmessages_90.Count + inboxmessages_90.Count;
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;
}
public string getfbfans(string groupid, string userid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
long _15 = 0;
long _30 = 0;
long _60 = 0;
long _90 = 0;
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;
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())
{
fbfan_15 = 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(-15))).ToList();
fbfan_30 = 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(-30))).ToList();
fbfan_60 = 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(-60))).ToList();
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))).ToList();
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
List<Domain.Socioboard.Domain.FacebookFanPage> lstresult = session4.Query<Domain.Socioboard.Domain.FacebookFanPage>().Where(t => ArrProfileId.Contains(t.ProfilePageId) && 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();
string add_data = _result.FanpageCount.ToString();
perday_90 = perday_90 + add_data + ",";
}
else {
perday_90 = perday_90 + "0,";
}
logger.Error("perdayfb>>" + perday_90);
present_date = present_date.AddDays(-1);
}
}
catch (Exception e)
{
logger.Error("perdayfberror >>" + e);
Console.Write(e.StackTrace);
}
}
foreach (Domain.Socioboard.Domain.FacebookFanPage t in fbfan_15)
{
_15 += long.Parse(t.FanpageCount);
}
foreach (Domain.Socioboard.Domain.FacebookFanPage t in fbfan_30)
{
_30 += long.Parse(t.FanpageCount);
}
foreach (Domain.Socioboard.Domain.FacebookFanPage t in fbfan_60)
{
_60 += long.Parse(t.FanpageCount);
}
foreach (Domain.Socioboard.Domain.FacebookFanPage t in fbfan_90)
{
_90 += long.Parse(t.FanpageCount);
}
try
{
perday_15 = perday_90.Substring(0, 29);
perday_30 = perday_90.Substring(0, 59);
perday_60 = perday_90.Substring(0, 119);
}
catch (Exception e)
{
logger.Error(e.Message);
}
r._15 += _15;
r._30 += _30;
r._60 += _60;
r._90 += _90;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
}
}
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
logger.Error(e.Message);
logger.Error(e.StackTrace);
}
string ret = new JavaScriptSerializer().Serialize(r);
return ret;
}
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;
}
public string uniquetwitteruser(string groupid, string userid)
{
Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData();
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 FbProfileId = string.Empty;
string TwtProfileId = string.Empty;
string[] ArrProfileId = { };
//List<Domain.Socioboard.Domain.Team> teams;
List<Domain.Socioboard.Domain.GroupProfile> lstGroupProfile;
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_15 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_30 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_60 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> inboxmessages_90 = new List<Domain.Socioboard.Domain.InboxMessages>();
int item_15 = 0;
int item_30 = 0;
int item_60 = 0;
int item_90 = 0;
string ret_string = string.Empty;
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("ProfileType", "twitter").SetParameter("teamid", team.Id).List<Domain.Socioboard.Domain.TeamMemberProfile>().ToList();
// }
lstGroupProfile = grpProfilesRepo.GetAllGroupProfiles(Guid.Parse(groupid));
foreach (Domain.Socioboard.Domain.GroupProfile teammemberprofile in lstGroupProfile)
{
try
{
AllProfileId += teammemberprofile.ProfileId + ',';
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
try
{
AllProfileId = AllProfileId.Substring(0, AllProfileId.Length - 1);
ArrProfileId = AllProfileId.Split(',');
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
if (!string.IsNullOrEmpty(AllProfileId))
{
string strinboxmessages = "from InboxMessages t where t.UserId =: UserId and t.MessageType = : msgtype and Staus= and t.RecipientId In(" + AllProfileId + ")";
using (NHibernate.ISession session3 = SessionFactory.GetNewSession())
{
try
{
inboxmessages_90 = session3.Query<Domain.Socioboard.Domain.InboxMessages>().Where(U => U.Status == 0 && U.CreatedTime < DateTime.Now.AddDays(1).Date && U.CreatedTime >= (DateTime.Now.AddDays(-90).Date.AddSeconds(1)) && ArrProfileId.Contains(U.ProfileId) && U.MessageType == "twt_followers").GroupBy(x => x.FromId).Select(g => g.First()).ToList<Domain.Socioboard.Domain.InboxMessages>();
item_90 = inboxmessages_90.Count;
}
catch (Exception)
{
}
try
{
inboxmessages_60 = inboxmessages_90.Where(m => m.CreatedTime < present_date.Date && m.CreatedTime >= present_date.AddDays(-60).Date).ToList();
item_60 = inboxmessages_60.Count;
}
catch (Exception)
{
}
try
{
inboxmessages_30 = inboxmessages_90.Where(m => m.CreatedTime < present_date.Date && m.CreatedTime >= present_date.AddDays(-30).Date).ToList();
item_30 = inboxmessages_60.Count;
}
catch (Exception)
{
}
try
{
inboxmessages_15 = inboxmessages_90.Where(m => m.CreatedTime < present_date.Date && m.CreatedTime >= present_date.AddDays(-15).Date).ToList();
item_15 = inboxmessages_60.Count;
}
catch (Exception)
{
}
}
present_date = DateTime.Now;
while (present_date.Date != DateTime.Now.Date.AddDays(-90))
{
try
{
List<Domain.Socioboard.Domain.InboxMessages> _inboxmessages = new List<Domain.Socioboard.Domain.InboxMessages>();
using (NHibernate.ISession session4 = SessionFactory.GetNewSession())
{
int item = 0;
try
{
//item = session4.QueryOver<Domain.Socioboard.Domain.InboxMessages>().Where(m => m.CreatedTime >= present_date.Date.AddSeconds(1) && m.CreatedTime <= present_date.AddDays(1).Date.AddSeconds(-1) && m.MessageType == "twt_followers").WhereRestrictionOn(S => S.ProfileId).IsIn(ArrProfileId)
// .Select(Projections.CountDistinct<Domain.Socioboard.Domain.InboxMessages>(x => x.FromId))
// .FutureValue<int>().Value;
_inboxmessages = inboxmessages_90.Where(m => m.CreatedTime >= present_date.Date.AddSeconds(1) && m.CreatedTime <= present_date.AddDays(1).Date.AddSeconds(-1)).ToList();
item = _inboxmessages.Count;
}
catch (Exception e)
{
item = 0;
}
int add_data = item;
perday_90 = perday_90 + add_data.ToString() + ",";
present_date = present_date.AddDays(-1);
logger.Error("perdayuniqueusers >>" + perday_90);
}
}
catch (Exception e)
{
logger.Error("perdayuniqueuserserror >>" + e.Message);
}
}
try
{
string[] arr = perday_90.Split(',');
for (int i = 0; i < 15; i++)
{
perday_15 = perday_15 + arr[i] + ",";
}
for (int i = 0; i < 30; i++)
{
perday_30 = perday_30 + arr[i] + ",";
}
for (int i = 0; i < 60; i++)
{
perday_60 = perday_60 + arr[i] + ",";
}
}
catch (Exception)
{
}
r._15 = item_15;
r._30 = item_30;
r._60 = item_60;
r._90 = item_90;
r.perday_15 = perday_15;
r.perday_30 = perday_30;
r.perday_60 = perday_60;
r.perday_90 = perday_90;
}
//}
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
}
ret_string = new JavaScriptSerializer().Serialize(r);
return ret_string;
}
