public string retrievefan_60(string id)
{
string ret_string = string.Empty;
Domain.Socioboard.Domain.TopFiveFans_60 ret = new Domain.Socioboard.Domain.TopFiveFans_60();
List<Domain.Socioboard.Domain.TopFiveFans_60> ret_list = new List<Domain.Socioboard.Domain.TopFiveFans_60>();
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
try
{
ret_list = session.CreateQuery("from TopFiveFans_60 where ProfileId =: id").SetParameter("id", id).List<Domain.Socioboard.Domain.TopFiveFans_60>().ToList().OrderByDescending(x => x.Rank).ToList();
if (ret_list == null)
{
ret_list = new List<Domain.Socioboard.Domain.TopFiveFans_60>();
}
ret_string = new JavaScriptSerializer().Serialize(ret_list);
}
catch (Exception e)
{
logger.Error("noretrievedata>>");
Console.WriteLine(e.StackTrace);
logger.Error(e.Message);
logger.Error(e.StackTrace);
ret_list = new List<Domain.Socioboard.Domain.TopFiveFans_60>();
ret_string = new JavaScriptSerializer().Serialize(ret_list);
}
}
return ret_string;
}
public void top_five_fans(string profileid)
{
List<Domain.Socioboard.Domain.TopFiveFans_15> topfans_15 = new List<Domain.Socioboard.Domain.TopFiveFans_15>();
List<Domain.Socioboard.Domain.TopFiveFans_30> topfans_30 = new List<Domain.Socioboard.Domain.TopFiveFans_30>();
List<Domain.Socioboard.Domain.TopFiveFans_60> topfans_60 = new List<Domain.Socioboard.Domain.TopFiveFans_60>();
List<Domain.Socioboard.Domain.TopFiveFans_90> topfans_90 = new List<Domain.Socioboard.Domain.TopFiveFans_90>();
List<Domain.Socioboard.Domain.InboxMessages> mention_retweets_15 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> mention_retweets_30 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> mention_retweets_60 = new List<Domain.Socioboard.Domain.InboxMessages>();
List<Domain.Socioboard.Domain.InboxMessages> mention_retweets_90 = new List<Domain.Socioboard.Domain.InboxMessages>();
Domain.Socioboard.Domain.TopFiveFans_15 first_15 = new Domain.Socioboard.Domain.TopFiveFans_15();
Domain.Socioboard.Domain.TopFiveFans_15 second_15 = new Domain.Socioboard.Domain.TopFiveFans_15();
Domain.Socioboard.Domain.TopFiveFans_15 third_15 = new Domain.Socioboard.Domain.TopFiveFans_15();
Domain.Socioboard.Domain.TopFiveFans_15 fourth_15 = new Domain.Socioboard.Domain.TopFiveFans_15();
Domain.Socioboard.Domain.TopFiveFans_15 fifth_15 = new Domain.Socioboard.Domain.TopFiveFans_15();
Domain.Socioboard.Domain.TopFiveFans_30 first_30 = new Domain.Socioboard.Domain.TopFiveFans_30();
Domain.Socioboard.Domain.TopFiveFans_30 second_30 = new Domain.Socioboard.Domain.TopFiveFans_30();
Domain.Socioboard.Domain.TopFiveFans_30 third_30 = new Domain.Socioboard.Domain.TopFiveFans_30();
Domain.Socioboard.Domain.TopFiveFans_30 fourth_30 = new Domain.Socioboard.Domain.TopFiveFans_30();
Domain.Socioboard.Domain.TopFiveFans_30 fifth_30 = new Domain.Socioboard.Domain.TopFiveFans_30();
Domain.Socioboard.Domain.TopFiveFans_60 first_60 = new Domain.Socioboard.Domain.TopFiveFans_60();
Domain.Socioboard.Domain.TopFiveFans_60 second_60 = new Domain.Socioboard.Domain.TopFiveFans_60();
Domain.Socioboard.Domain.TopFiveFans_60 third_60 = new Domain.Socioboard.Domain.TopFiveFans_60();
Domain.Socioboard.Domain.TopFiveFans_60 fourth_60 = new Domain.Socioboard.Domain.TopFiveFans_60();
Domain.Socioboard.Domain.TopFiveFans_60 fifth_60 = new Domain.Socioboard.Domain.TopFiveFans_60();
Domain.Socioboard.Domain.TopFiveFans_90 first_90 = new Domain.Socioboard.Domain.TopFiveFans_90();
Domain.Socioboard.Domain.TopFiveFans_90 second_90 = new Domain.Socioboard.Domain.TopFiveFans_90();
Domain.Socioboard.Domain.TopFiveFans_90 third_90 = new Domain.Socioboard.Domain.TopFiveFans_90();
Domain.Socioboard.Domain.TopFiveFans_90 fourth_90 = new Domain.Socioboard.Domain.TopFiveFans_90();
Domain.Socioboard.Domain.TopFiveFans_90 fifth_90 = new Domain.Socioboard.Domain.TopFiveFans_90();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
deletefans_90(profileid);
mention_retweets_90 = session.Query<Domain.Socioboard.Domain.InboxMessages>().Where(x => x.CreatedTime <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedTime > (DateTime.Now.AddDays(-90).Date) && x.ProfileId == profileid && (x.MessageType == "twt_mention" || x.MessageType == "twt_retweets")).ToList();
dynamic list_90 = mention_retweets_90.GroupBy(n => n.FromId).Select(group => new Domain.Socioboard.Domain.TopFiveFans_90(group.Count(), group.First().FromId, profileid,group.First().FromName)).ToList();
topfans_90 = (List<Domain.Socioboard.Domain.TopFiveFans_90>)list_90;
first_90 = topfans_90.OrderByDescending(r => r.Count).FirstOrDefault();
if (first_90 != null)
{
int mentions = mention_retweets_90.Where(x => x.FromId == first_90.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_90.Where(x => x.FromId == first_90.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_90.Where(a => a.FromId == first_90.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_90(first_90, 1, mentions, retweets, image_url);
}
second_90 = topfans_90.OrderByDescending(r => r.Count).Skip(1).FirstOrDefault();
if (second_90 != null)
{
int mentions = mention_retweets_90.Where(x => x.FromId == second_90.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_90.Where(x => x.FromId == second_90.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_90.Where(a => a.FromId == second_90.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_90(second_90, 2, mentions, retweets, image_url);
}
third_90 = topfans_90.OrderByDescending(r => r.Count).Skip(2).FirstOrDefault();
if(third_90 != null)
{
int mentions = mention_retweets_90.Where(x => x.FromId == third_90.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_90.Where(x => x.FromId == third_90.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_90.Where(a => a.FromId == third_90.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_90(third_90, 3, mentions, retweets, image_url);
}
fourth_90 = topfans_90.OrderByDescending(r => r.Count).Skip(3).FirstOrDefault();
if(fourth_90 != null)
{
int mentions = mention_retweets_90.Where(x => x.FromId == fourth_90.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_90.Where(x => x.FromId == fourth_90.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_90.Where(a => a.FromId == fourth_90.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_90(fourth_90, 4, mentions, retweets, image_url);
}
fifth_90= topfans_90.OrderByDescending(r => r.Count).Skip(4).FirstOrDefault();
if(fifth_90 !=null)
{
int mentions = mention_retweets_90.Where(x => x.FromId == fifth_90.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_90.Where(x => x.FromId == fifth_90.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_90.Where(a => a.FromId == fifth_90.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_90(fifth_90, 5, mentions, retweets, image_url);
}
deletefans_60(profileid);
mention_retweets_60 = session.Query<Domain.Socioboard.Domain.InboxMessages>().Where(x => x.CreatedTime <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedTime > (DateTime.Now.AddDays(-90).Date) && x.ProfileId == profileid && (x.MessageType == "twt_mention" || x.MessageType == "twt_retweets")).ToList();
dynamic list_60 = mention_retweets_60.GroupBy(n => n.FromId).Select(group => new Domain.Socioboard.Domain.TopFiveFans_60(group.Count(), group.First().FromId, profileid, group.First().FromName)).ToList();
topfans_60 = (List<Domain.Socioboard.Domain.TopFiveFans_60>)list_60;
first_60 = topfans_60.OrderByDescending(r => r.Count).FirstOrDefault();
if (first_60 != null)
{
int mentions = mention_retweets_60.Where(x => x.FromId == first_60.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_60.Where(x => x.FromId == first_60.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_60.Where(a => a.FromId == first_60.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_60(first_60, 1, mentions, retweets, image_url);
}
second_60 = topfans_60.OrderByDescending(r => r.Count).Skip(1).FirstOrDefault();
if (second_60 != null)
{
int mentions = mention_retweets_60.Where(x => x.FromId == second_60.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_60.Where(x => x.FromId == second_60.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_60.Where(a => a.FromId == second_60.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_60(second_60, 2, mentions, retweets, image_url);
}
third_60 = topfans_60.OrderByDescending(r => r.Count).Skip(2).FirstOrDefault();
if (third_60 != null)
{
int mentions = mention_retweets_60.Where(x => x.FromId == third_60.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_60.Where(x => x.FromId == third_60.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_60.Where(a => a.FromId == third_60.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_60(third_60, 3, mentions, retweets, image_url);
}
fourth_60 = topfans_60.OrderByDescending(r => r.Count).Skip(3).FirstOrDefault();
if (fourth_60 != null)
{
int mentions = mention_retweets_60.Where(x => x.FromId == fourth_60.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_60.Where(x => x.FromId == fourth_60.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_60.Where(a => a.FromId == fourth_60.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_60(fourth_60, 4, mentions, retweets, image_url);
}
fifth_60 = topfans_60.OrderByDescending(r => r.Count).Skip(4).FirstOrDefault();
if (fifth_60 != null)
{
int mentions = mention_retweets_60.Where(x => x.FromId == fifth_60.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_60.Where(x => x.FromId == fifth_60.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_60.Where(a => a.FromId == fifth_60.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_60(fifth_60, 5, mentions, retweets, image_url);
}
deletefans_30(profileid);
mention_retweets_30 = session.Query<Domain.Socioboard.Domain.InboxMessages>().Where(x => x.CreatedTime <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedTime > (DateTime.Now.AddDays(-90).Date) && x.ProfileId == profileid && (x.MessageType == "twt_mention" || x.MessageType == "twt_retweets")).ToList();
dynamic list_30 = mention_retweets_30.GroupBy(n => n.FromId).Select(group => new Domain.Socioboard.Domain.TopFiveFans_30(group.Count(), group.First().FromId, profileid, group.First().FromName)).ToList();
topfans_30 = (List<Domain.Socioboard.Domain.TopFiveFans_30>)list_30;
first_30 = topfans_30.OrderByDescending(r => r.Count).FirstOrDefault();
if (first_30 != null)
{
int mentions = mention_retweets_30.Where(x => x.FromId == first_30.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_30.Where(x => x.FromId == first_30.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_30.Where(a => a.FromId == first_30.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_30(first_30, 1, mentions, retweets, image_url);
}
second_30 = topfans_30.OrderByDescending(r => r.Count).Skip(1).FirstOrDefault();
if (second_30 != null)
{
int mentions = mention_retweets_30.Where(x => x.FromId == second_30.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_30.Where(x => x.FromId == second_30.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_30.Where(a => a.FromId == second_30.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_30(second_30, 2, mentions, retweets, image_url);
}
third_30 = topfans_30.OrderByDescending(r => r.Count).Skip(2).FirstOrDefault();
if (third_30 != null)
{
int mentions = mention_retweets_30.Where(x => x.FromId == third_30.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_30.Where(x => x.FromId == third_30.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_30.Where(a => a.FromId == third_30.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_30(third_30, 3, mentions, retweets, image_url);
}
fourth_30 = topfans_30.OrderByDescending(r => r.Count).Skip(3).FirstOrDefault();
if (fourth_30 != null)
{
int mentions = mention_retweets_30.Where(x => x.FromId == fourth_30.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_30.Where(x => x.FromId == fourth_30.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_30.Where(a => a.FromId == fourth_30.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_30(fourth_30, 4, mentions, retweets, image_url);
}
fifth_30 = topfans_30.OrderByDescending(r => r.Count).Skip(4).FirstOrDefault();
if (fifth_30 != null)
{
int mentions = mention_retweets_30.Where(x => x.FromId == fifth_30.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_30.Where(x => x.FromId == fifth_30.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_30.Where(a => a.FromId == fifth_30.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_30(fifth_30, 5, mentions, retweets, image_url);
}
deletefans_15(profileid);
mention_retweets_15 = session.Query<Domain.Socioboard.Domain.InboxMessages>().Where(x => x.CreatedTime <= DateTime.Now.AddDays(1).Date.AddSeconds(-1) && x.CreatedTime > (DateTime.Now.AddDays(-90).Date) && x.ProfileId == profileid && (x.MessageType == "twt_mention" || x.MessageType == "twt_retweets")).ToList();
dynamic list_15 = mention_retweets_15.GroupBy(n => n.FromId).Select(group => new Domain.Socioboard.Domain.TopFiveFans_15(group.Count(), group.First().FromId, profileid, group.First().FromName)).ToList();
topfans_15 = (List<Domain.Socioboard.Domain.TopFiveFans_15>)list_15;
first_15 = topfans_15.OrderByDescending(r => r.Count).FirstOrDefault();
if (first_15 != null)
{
int mentions = mention_retweets_15.Where(x => x.FromId == first_15.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_15.Where(x => x.FromId == first_15.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_15.Where(a => a.FromId == first_15.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_15(first_15, 1, mentions, retweets, image_url);
}
second_15 = topfans_15.OrderByDescending(r => r.Count).Skip(1).FirstOrDefault();
if (second_15 != null)
{
int mentions = mention_retweets_15.Where(x => x.FromId == second_15.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_15.Where(x => x.FromId == second_15.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_15.Where(a => a.FromId == second_15.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_15(second_15, 2, mentions, retweets, image_url);
}
third_15 = topfans_15.OrderByDescending(r => r.Count).Skip(2).FirstOrDefault();
if (third_15 != null)
{
int mentions = mention_retweets_15.Where(x => x.FromId == third_15.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_15.Where(x => x.FromId == third_15.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_15.Where(a => a.FromId == third_15.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_15(third_15, 3, mentions, retweets, image_url);
}
fourth_15 = topfans_15.OrderByDescending(r => r.Count).Skip(3).FirstOrDefault();
if (fourth_15 != null)
{
int mentions = mention_retweets_15.Where(x => x.FromId == fourth_15.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_15.Where(x => x.FromId == fourth_15.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_15.Where(a => a.FromId == fourth_15.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_15(fourth_15, 4, mentions, retweets, image_url);
}
fifth_15 = topfans_15.OrderByDescending(r => r.Count).Skip(4).FirstOrDefault();
if (fifth_15 != null)
{
int mentions = mention_retweets_15.Where(x => x.FromId == fifth_15.FromId && x.MessageType == "twt_mention").ToList().Count;
int retweets = mention_retweets_15.Where(x => x.FromId == fifth_15.FromId && x.MessageType == "twt_retweet").ToList().Count;
string image_url = mention_retweets_15.Where(a => a.FromId == fifth_15.FromId).Select(x => x.FromImageUrl).ToList().First().ToString();
insertfans_15(fifth_15, 5, mentions, retweets, image_url);
}
}
}
catch {
}
}