public void FacebookGroupData(string groupid , string userid) { List<Domain.Socioboard.Domain.Team> teams; List<Domain.Socioboard.Domain.GroupProfile> teammemberprofiles; Domain.Socioboard.Domain.FacebookGroupReport_15 facebook_15 = new Domain.Socioboard.Domain.FacebookGroupReport_15(); Domain.Socioboard.Domain.FacebookGroupReport_30 facebook_30 = new Domain.Socioboard.Domain.FacebookGroupReport_30(); Domain.Socioboard.Domain.FacebookGroupReport_60 facebook_60 = new Domain.Socioboard.Domain.FacebookGroupReport_60(); Domain.Socioboard.Domain.FacebookGroupReport_90 facebook_90 = new Domain.Socioboard.Domain.FacebookGroupReport_90(); Domain.Socioboard.Domain.FacebookReport_15 facebook_15_temp = new Domain.Socioboard.Domain.FacebookReport_15(); Domain.Socioboard.Domain.FacebookReport_30 facebook_30_temp = new Domain.Socioboard.Domain.FacebookReport_30(); Domain.Socioboard.Domain.FacebookReport_60 facebook_60_temp = new Domain.Socioboard.Domain.FacebookReport_60(); Domain.Socioboard.Domain.FacebookReport_90 facebook_90_temp = new Domain.Socioboard.Domain.FacebookReport_90(); int TotalLikes_15 = 0; int TalkingAbout_15 = 0; int Likes_15 = 0; int[] PerDayLikes_15 = new int[15]; int[] PerDayUnlikes_15 = new int[15]; int[] PerDayImpressions_15 = new int[15]; int[] PerDayStoryShare_15 = new int[15]; string str_PerDayLikes_15 = string.Empty; string str_PerDayUnlikes_15 = string.Empty; string str_PerDayImpressions_15 = string.Empty; string str_PerDayStoryShare_15 = string.Empty; int Unlikes_15 = 0; int Impressions_15 = 0; int StoryShare_15 = 0; int ImpressionFans_15 = 0; int ImpressionPagePost_15 = 0; int ImpressionuserPost_15 = 0; int ImpressionCoupn_15 = 0; int ImpressionOther_15 = 0; int ImpressionMention_15 = 0; int ImpressionCheckin_15 = 0; int ImpressionQuestion_15 = 0; int ImpressionEvent_15 = 0; int Organic_15 = 0; int Viral_15 = 0; int Paid_15 = 0; int M_13_17_15 = 0; int M_18_24_15 = 0; int M_25_34_15 = 0; int M_35_44_15 = 0; int M_45_54_15 = 0; int M_55_64_15 = 0; int M_65_15 = 0; int F_13_17_15 = 0; int F_18_24_15 = 0; int F_25_34_15 = 0; int F_35_44_15 = 0; int F_45_54_15 = 0; int F_55_64_15 = 0; int F_65_15 = 0; int Sharing_M_13_17_15 = 0; int Sharing_M_18_24_15 = 0; int Sharing_M_25_34_15 = 0; int Sharing_M_35_44_15 = 0; int Sharing_M_45_54_15 = 0; int Sharing_M_55_64_15 = 0; int Sharing_M_65_15 = 0; int Sharing_F_13_17_15 = 0; int Sharing_F_18_24_15 = 0; int Sharing_F_25_34_15 = 0; int Sharing_F_35_44_15 = 0; int Sharing_F_45_54_15 = 0; int Sharing_F_55_64_15 = 0; int Sharing_F_65_15 = 0; int TotalLikes_30 = 0; int TalkingAbout_30 = 0; int Likes_30 = 0; int[] PerDayLikes_30 = new int[30]; int[] PerDayUnlikes_30 = new int[30]; int[] PerDayImpressions_30 = new int[30]; int[] PerDayStoryShare_30 = new int[30]; string str_PerDayLikes_30 = string.Empty; string str_PerDayUnlikes_30 = string.Empty; string str_PerDayImpressions_30 = string.Empty; string str_PerDayStoryShare_30 = string.Empty; int Unlikes_30 = 0; int Impressions_30 = 0; int StoryShare_30 = 0; int ImpressionFans_30 = 0; int ImpressionPagePost_30 = 0; int ImpressionuserPost_30 = 0; int ImpressionCoupn_30 = 0; int ImpressionOther_30 = 0; int ImpressionMention_30 = 0; int ImpressionCheckin_30 = 0; int ImpressionQuestion_30 = 0; int ImpressionEvent_30 = 0; int Organic_30 = 0; int Viral_30 = 0; int Paid_30 = 0; int M_13_17_30 = 0; int M_18_24_30 = 0; int M_25_34_30 = 0; int M_35_44_30 = 0; int M_45_54_30 = 0; int M_55_64_30 = 0; int M_65_30 = 0; int F_13_17_30 = 0; int F_18_24_30 = 0; int F_25_34_30 = 0; int F_35_44_30 = 0; int F_45_54_30 = 0; int F_55_64_30 = 0; int F_65_30 = 0; int Sharing_M_13_17_30= 0; int Sharing_M_18_24_30= 0; int Sharing_M_25_34_30= 0; int Sharing_M_35_44_30= 0; int Sharing_M_45_54_30= 0; int Sharing_M_55_64_30= 0; int Sharing_M_65_30 = 0; int Sharing_F_13_17_30= 0; int Sharing_F_18_24_30= 0; int Sharing_F_25_34_30= 0; int Sharing_F_35_44_30= 0; int Sharing_F_45_54_30= 0; int Sharing_F_55_64_30= 0; int Sharing_F_65_30 = 0; int TotalLikes_60 = 0; int TalkingAbout_60 = 0; int Likes_60 = 0; int[] PerDayLikes_60 = new int[60]; int[] PerDayUnlikes_60 = new int[60]; int[] PerDayImpressions_60 = new int[60]; int[] PerDayStoryShare_60 = new int[60]; string str_PerDayLikes_60 = string.Empty; string str_PerDayUnlikes_60 = string.Empty; string str_PerDayImpressions_60 = string.Empty; string str_PerDayStoryShare_60 = string.Empty; int Unlikes_60 = 0; int Impressions_60 = 0; int StoryShare_60 = 0; int ImpressionFans_60 = 0; int ImpressionPagePost_60 = 0; int ImpressionuserPost_60 = 0; int ImpressionCoupn_60 = 0; int ImpressionOther_60 = 0; int ImpressionMention_60 = 0; int ImpressionCheckin_60 = 0; int ImpressionQuestion_60 = 0; int ImpressionEvent_60 = 0; int Organic_60 = 0; int Viral_60 = 0; int Paid_60 = 0; int M_13_17_60 = 0; int M_18_24_60 = 0; int M_25_34_60 = 0; int M_35_44_60 = 0; int M_45_54_60 = 0; int M_55_64_60 = 0; int M_65_60 = 0; int F_13_17_60 = 0; int F_18_24_60 = 0; int F_25_34_60 = 0; int F_35_44_60 = 0; int F_45_54_60 = 0; int F_55_64_60 = 0; int F_65_60 = 0; int Sharing_M_13_17_60= 0; int Sharing_M_18_24_60= 0; int Sharing_M_25_34_60= 0; int Sharing_M_35_44_60= 0; int Sharing_M_45_54_60= 0; int Sharing_M_55_64_60= 0; int Sharing_M_65_60 = 0; int Sharing_F_13_17_60 = 0; int Sharing_F_18_24_60 = 0; int Sharing_F_25_34_60 = 0; int Sharing_F_35_44_60 = 0; int Sharing_F_45_54_60 = 0; int Sharing_F_55_64_60 = 0; int Sharing_F_65_60 = 0; int TotalLikes_90 = 0; int TalkingAbout_90 = 0; int Likes_90 = 0; int[] PerDayLikes_90 = new int[90]; int[] PerDayUnlikes_90 = new int[90]; int[] PerDayImpressions_90 = new int[90]; int[] PerDayStoryShare_90 = new int[90]; string str_PerDayLikes_90 = string.Empty; string str_PerDayUnlikes_90 = string.Empty; string str_PerDayImpressions_90 = string.Empty; string str_PerDayStoryShare_90 = string.Empty; int Unlikes_90 = 0; int Impressions_90 = 0; int StoryShare_90 = 0; int ImpressionFans_90 = 0; int ImpressionPagePost_90 = 0; int ImpressionuserPost_90 = 0; int UniqueUser_90 = 0; int UniqueUser_60 = 0; int UniqueUser_30 = 0; int UniqueUser_15 = 0; int ImpressionCoupn_90 = 0; int ImpressionOther_90 = 0; int ImpressionMention_90 = 0; int ImpressionCheckin_90 = 0; int ImpressionQuestion_90 = 0; int ImpressionEvent_90 = 0; int Organic_90 = 0; int Viral_90 = 0; int Paid_90 = 0; int M_13_17_90 = 0; int M_18_24_90 = 0; int M_25_34_90 = 0; int M_35_44_90 = 0; int M_45_54_90 = 0; int M_55_64_90 = 0; int M_65_90 = 0; int F_13_17_90 = 0; int F_18_24_90 = 0; int F_25_34_90 = 0; int F_35_44_90 = 0; int F_45_54_90 = 0; int F_55_64_90 = 0; int F_65_90 = 0; int Sharing_M_13_17_90= 0; int Sharing_M_18_24_90= 0; int Sharing_M_25_34_90= 0; int Sharing_M_35_44_90= 0; int Sharing_M_45_54_90= 0; int Sharing_M_55_64_90= 0; int Sharing_M_65_90 = 0; int Sharing_F_13_17_90 = 0; int Sharing_F_18_24_90 = 0; int Sharing_F_25_34_90 = 0; int Sharing_F_35_44_90 = 0; int Sharing_F_45_54_90 = 0; int Sharing_F_55_64_90 = 0; int Sharing_F_65_90 = 0; // no of fb accounts //string fb_accounts = total_fb_accounts(groupid, userid); int fb_count = 0; 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 session2 = SessionFactory.GetNewSession()) { teammemberprofiles = session2.CreateQuery("from GroupProfile t where t.GroupId = : GroupId and t.ProfileType = : ProfileType").SetParameter("GroupId", Guid.Parse(groupid)).SetParameter("ProfileType", "facebook_page").List<Domain.Socioboard.Domain.GroupProfile>().ToList(); } foreach (Domain.Socioboard.Domain.GroupProfile teammemberprofile in teammemberprofiles) { Domain.Socioboard.Domain.FacebookAccount objFacebookAccount = _FacebookAccountRepository.getFacebookAccountDetailsById(teammemberprofile.ProfileId, Guid.Parse(userid)); if (!string.IsNullOrEmpty(objFacebookAccount.AccessToken)) { fb_count++; using (NHibernate.ISession session2 = SessionFactory.GetNewSession()) { try { NHibernate.IQuery f_15 = session2.CreateQuery("from FacebookReport_15 f where f.FacebookId = : facebookid").SetParameter("facebookid", teammemberprofile.ProfileId); facebook_15_temp = (Domain.Socioboard.Domain.FacebookReport_15)f_15.UniqueResult(); TotalLikes_15 += Int32.Parse(facebook_15_temp.TotalLikes); TalkingAbout_15 += Int32.Parse(facebook_15_temp.TalkingAbout); Likes_15 += facebook_15_temp.Likes; UniqueUser_15 += facebook_15_temp.UniqueUser; try { string[] arr1 = (facebook_15_temp.PerDayLikes).Split(','); for (int i = 0; i < 15; i++) { PerDayLikes_15[i] = PerDayLikes_15[i] + Int32.Parse(arr1[i]); } } catch (Exception) { for (int i = 0; i < 15; i++) { PerDayLikes_15[i] = PerDayLikes_15[i] + 0; } } Unlikes_15 += facebook_15_temp.Unlikes; try { string[] arr2 = (facebook_15_temp.PerDayUnlikes).Split(','); for (int i = 0; i < 15; i++) { PerDayUnlikes_15[i] = PerDayUnlikes_15[i] + Int32.Parse(arr2[i]); } } catch (Exception) { for (int i = 0; i < 15; i++) { PerDayUnlikes_15[i] = PerDayUnlikes_15[i] + 0; } } Impressions_15 += facebook_15_temp.Impression; try { string[] arr3 = (facebook_15_temp.PerDayImpression).Split(','); for (int i = 0; i < 15; i++) { PerDayImpressions_15[i] = PerDayImpressions_15[i] + Int32.Parse(arr3[i]); } } catch (Exception) { for (int i = 0; i < 15; i++) { PerDayImpressions_15[i] = PerDayImpressions_15[i] + 0; } } StoryShare_15 += facebook_15_temp.StoryShare; try { string[] arr4 = (facebook_15_temp.PerDayStoryShare).Split(','); for (int i = 0; i < 15; i++) { PerDayStoryShare_15[i] = PerDayStoryShare_15[i] + Int32.Parse(arr4[i]); } } catch (Exception) { for (int i = 0; i < 15; i++) { PerDayStoryShare_15[i] = PerDayStoryShare_15[i] + 0; } } ImpressionFans_15 += facebook_15_temp.ImpressionFans; ImpressionPagePost_15 += facebook_15_temp.ImpressionPagePost; ImpressionuserPost_15 += facebook_15_temp.ImpressionuserPost; ImpressionCoupn_15 += facebook_15_temp.ImpressionCoupn; ImpressionOther_15 += facebook_15_temp.ImpressionOther; ImpressionMention_15 += facebook_15_temp.ImpressionMention; ImpressionCheckin_15 += facebook_15_temp.ImpressionCheckin; ImpressionQuestion_15 += facebook_15_temp.ImpressionQuestion; ImpressionEvent_15 += facebook_15_temp.ImpressionEvent; Organic_15 += facebook_15_temp.Organic; Viral_15 += facebook_15_temp.Viral; Paid_15 += facebook_15_temp.Paid; M_13_17_15 += facebook_15_temp.M_13_17; M_18_24_15 += facebook_15_temp.M_18_24; M_25_34_15 += facebook_15_temp.M_25_34; M_35_44_15 += facebook_15_temp.M_35_44; M_45_54_15 += facebook_15_temp.M_45_54; M_55_64_15 += facebook_15_temp.M_55_64; M_65_15 += facebook_15_temp.M_65; F_13_17_15 += facebook_15_temp.F_13_17; F_18_24_15 += facebook_15_temp.F_18_24; F_25_34_15 += facebook_15_temp.F_25_34; F_35_44_15 += facebook_15_temp.F_35_44; F_45_54_15 += facebook_15_temp.F_45_54; F_55_64_15 += facebook_15_temp.F_55_64; F_65_15 += facebook_15_temp.F_65; Sharing_M_13_17_15 += facebook_15_temp.Sharing_M_13_17; Sharing_M_25_34_15 += facebook_15_temp.Sharing_M_25_34; Sharing_M_35_44_15 += facebook_15_temp.Sharing_M_35_44; Sharing_M_45_54_15 += facebook_15_temp.Sharing_M_45_54; Sharing_M_55_64_15 += facebook_15_temp.Sharing_M_55_64; Sharing_M_65_15 += facebook_15_temp.Sharing_M_65; Sharing_F_13_17_15 += facebook_15_temp.Sharing_F_13_17; Sharing_F_25_34_15 += facebook_15_temp.Sharing_F_25_34; Sharing_F_35_44_15 += facebook_15_temp.Sharing_F_35_44; Sharing_F_45_54_15 += facebook_15_temp.Sharing_F_45_54; Sharing_F_55_64_15 += facebook_15_temp.Sharing_F_55_64; Sharing_F_65_15 += facebook_15_temp.Sharing_F_65; } catch { } } using (NHibernate.ISession session3 = SessionFactory.GetNewSession()) { try { NHibernate.IQuery f_30 = session3.CreateQuery("from FacebookReport_30 f where f.FacebookId = : facebookid").SetParameter("facebookid", teammemberprofile.ProfileId); facebook_30_temp = (Domain.Socioboard.Domain.FacebookReport_30)f_30.UniqueResult(); TotalLikes_30 += Int32.Parse(facebook_30_temp.TotalLikes); TalkingAbout_30 += Int32.Parse(facebook_30_temp.TalkingAbout); Likes_30 += facebook_30_temp.Likes; UniqueUser_30 += facebook_30_temp.UniqueUser; try { string[] arr1 = (facebook_30_temp.PerDayLikes).Split(','); for (int i = 0; i < 30; i++) { PerDayLikes_30[i] = PerDayLikes_30[i] + Int32.Parse(arr1[i]); } } catch (Exception) { for (int i = 0; i < 30; i++) { PerDayLikes_30[i] = PerDayLikes_30[i] + 0; } } Unlikes_30 += facebook_30_temp.Unlikes; try { string[] arr2 = (facebook_30_temp.PerDayUnlikes).Split(','); for (int i = 0; i < 30; i++) { PerDayUnlikes_30[i] = PerDayUnlikes_30[i] + Int32.Parse(arr2[i]); } } catch (Exception) { for (int i = 0; i < 30; i++) { PerDayUnlikes_30[i] = PerDayUnlikes_30[i] + 0; } } Impressions_30 += facebook_30_temp.Impression; try { string[] arr3 = (facebook_30_temp.PerDayImpression).Split(','); for (int i = 0; i < 30; i++) { PerDayImpressions_30[i] = PerDayImpressions_30[i] + Int32.Parse(arr3[i]); } } catch (Exception) { for (int i = 0; i < 30; i++) { PerDayImpressions_30[i] = PerDayImpressions_30[i] + 0; } } StoryShare_30 += facebook_30_temp.StoryShare; try { string[] arr4 = (facebook_30_temp.PerDayStoryShare).Split(','); for (int i = 0; i < 30; i++) { PerDayStoryShare_30[i] = PerDayStoryShare_30[i] + Int32.Parse(arr4[i]); } } catch (Exception) { for (int i = 0; i < 30; i++) { PerDayStoryShare_30[i] = PerDayStoryShare_30[i] + 0; } } ImpressionFans_30 += facebook_30_temp.ImpressionFans; ImpressionPagePost_30 += facebook_30_temp.ImpressionPagePost; ImpressionuserPost_30 += facebook_30_temp.ImpressionuserPost; ImpressionCoupn_30 += facebook_30_temp.ImpressionCoupn; ImpressionOther_30 += facebook_30_temp.ImpressionOther; ImpressionMention_30 += facebook_30_temp.ImpressionMention; ImpressionCheckin_30 += facebook_30_temp.ImpressionCheckin; ImpressionQuestion_30 += facebook_30_temp.ImpressionQuestion; ImpressionEvent_30 += facebook_30_temp.ImpressionEvent; Organic_30 += facebook_30_temp.Organic; Viral_30 += facebook_30_temp.Viral; Paid_30 += facebook_30_temp.Paid; M_13_17_30 += facebook_30_temp.M_13_17; M_18_24_30 += facebook_30_temp.M_18_24; M_25_34_30 += facebook_30_temp.M_25_34; M_35_44_30 += facebook_30_temp.M_35_44; M_45_54_30 += facebook_30_temp.M_45_54; M_55_64_30 += facebook_30_temp.M_55_64; M_65_30 += facebook_30_temp.M_65; F_13_17_30 += facebook_30_temp.F_13_17; F_18_24_30 += facebook_30_temp.F_18_24; F_25_34_30 += facebook_30_temp.F_25_34; F_35_44_30 += facebook_30_temp.F_35_44; F_45_54_30 += facebook_30_temp.F_45_54; F_55_64_30 += facebook_30_temp.F_55_64; F_65_30 += facebook_30_temp.F_65; Sharing_M_13_17_30 += facebook_30_temp.Sharing_M_13_17; Sharing_M_25_34_30 += facebook_30_temp.Sharing_M_25_34; Sharing_M_35_44_30 += facebook_30_temp.Sharing_M_35_44; Sharing_M_45_54_30 += facebook_30_temp.Sharing_M_45_54; Sharing_M_55_64_30 += facebook_30_temp.Sharing_M_55_64; Sharing_M_65_30 += facebook_30_temp.Sharing_M_65; Sharing_F_13_17_30 += facebook_30_temp.Sharing_F_13_17; Sharing_F_25_34_30 += facebook_30_temp.Sharing_F_25_34; Sharing_F_35_44_30 += facebook_30_temp.Sharing_F_35_44; Sharing_F_45_54_30 += facebook_30_temp.Sharing_F_45_54; Sharing_F_55_64_30 += facebook_30_temp.Sharing_F_55_64; Sharing_F_65_30 += facebook_30_temp.Sharing_F_65; } catch { } } using (NHibernate.ISession session4 = SessionFactory.GetNewSession()) { try { NHibernate.IQuery f_60 = session4.CreateQuery("from FacebookReport_60 f where f.FacebookId = : facebookid").SetParameter("facebookid", teammemberprofile.ProfileId); facebook_60_temp = (Domain.Socioboard.Domain.FacebookReport_60)f_60.UniqueResult(); TotalLikes_60 += Int32.Parse(facebook_60_temp.TotalLikes); TalkingAbout_60 += Int32.Parse(facebook_60_temp.TalkingAbout); Likes_60 += facebook_60_temp.Likes; UniqueUser_60 += facebook_60.UniqueUser; try { string[] arr1 = (facebook_60_temp.PerDayLikes).Split(','); for (int i = 0; i < 60; i++) { PerDayLikes_60[i] = PerDayLikes_60[i] + Int32.Parse(arr1[i]); } } catch (Exception) { for (int i = 0; i < 60; i++) { PerDayLikes_60[i] = PerDayLikes_60[i] + 0; } } Unlikes_60 += facebook_60_temp.Unlikes; try { string[] arr2 = (facebook_60_temp.PerDayUnlikes).Split(','); for (int i = 0; i < 60; i++) { PerDayUnlikes_60[i] = PerDayUnlikes_60[i] + Int32.Parse(arr2[i]); } } catch (Exception) { for (int i = 0; i < 60; i++) { PerDayUnlikes_60[i] = PerDayUnlikes_60[i] + 0; } } Impressions_60 += facebook_60_temp.Impression; try { string[] arr3 = (facebook_60_temp.PerDayImpression).Split(','); for (int i = 0; i < 60; i++) { PerDayImpressions_60[i] = PerDayImpressions_60[i] + Int32.Parse(arr3[i]); } } catch (Exception) { for (int i = 0; i < 60; i++) { PerDayImpressions_60[i] = PerDayImpressions_60[i] + 0; } } StoryShare_60 += facebook_60_temp.StoryShare; try { string[] arr4 = (facebook_60_temp.PerDayStoryShare).Split(','); for (int i = 0; i < 60; i++) { PerDayStoryShare_60[i] = PerDayStoryShare_60[i] + Int32.Parse(arr4[i]); } } catch (Exception) { for (int i = 0; i < 60; i++) { PerDayStoryShare_60[i] = PerDayStoryShare_60[i] + 0; } } ImpressionFans_60 += facebook_60_temp.ImpressionFans; ImpressionPagePost_60 += facebook_60_temp.ImpressionPagePost; ImpressionuserPost_60 += facebook_60_temp.ImpressionuserPost; ImpressionCoupn_60 += facebook_60_temp.ImpressionCoupn; ImpressionOther_60 += facebook_60_temp.ImpressionOther; ImpressionMention_60 += facebook_60_temp.ImpressionMention; ImpressionCheckin_60 += facebook_60_temp.ImpressionCheckin; ImpressionQuestion_60 += facebook_60_temp.ImpressionQuestion; ImpressionEvent_60 += facebook_60_temp.ImpressionEvent; Organic_60 += facebook_60_temp.Organic; Viral_60 += facebook_60_temp.Viral; Paid_60 += facebook_60_temp.Paid; M_13_17_60 += facebook_60_temp.M_13_17; M_18_24_60 += facebook_60_temp.M_18_24; M_25_34_60 += facebook_60_temp.M_25_34; M_35_44_60 += facebook_60_temp.M_35_44; M_45_54_60 += facebook_60_temp.M_45_54; M_55_64_60 += facebook_60_temp.M_55_64; M_65_60 += facebook_60_temp.M_65; F_13_17_60 += facebook_60_temp.F_13_17; F_18_24_60 += facebook_60_temp.F_18_24; F_25_34_60 += facebook_60_temp.F_25_34; F_35_44_60 += facebook_60_temp.F_35_44; F_45_54_60 += facebook_60_temp.F_45_54; F_55_64_60 += facebook_60_temp.F_55_64; F_65_60 += facebook_60_temp.F_65; Sharing_M_13_17_60 += facebook_60_temp.Sharing_M_13_17; Sharing_M_25_34_60 += facebook_60_temp.Sharing_M_25_34; Sharing_M_35_44_60 += facebook_60_temp.Sharing_M_35_44; Sharing_M_45_54_60 += facebook_60_temp.Sharing_M_45_54; Sharing_M_55_64_60 += facebook_60_temp.Sharing_M_55_64; Sharing_M_65_60 += facebook_60_temp.Sharing_M_65; Sharing_F_13_17_60 += facebook_60_temp.Sharing_F_13_17; Sharing_F_25_34_60 += facebook_60_temp.Sharing_F_25_34; Sharing_F_35_44_60 += facebook_60_temp.Sharing_F_35_44; Sharing_F_45_54_60 += facebook_60_temp.Sharing_F_45_54; Sharing_F_55_64_60 += facebook_60_temp.Sharing_F_55_64; Sharing_F_65_60 += facebook_60_temp.Sharing_F_65; } catch { } } using (NHibernate.ISession session5 = SessionFactory.GetNewSession()) { try { NHibernate.IQuery f_90 = session5.CreateQuery("from FacebookReport_90 f where f.FacebookId = : facebookid").SetParameter("facebookid", teammemberprofile.ProfileId); facebook_90_temp = (Domain.Socioboard.Domain.FacebookReport_90)f_90.UniqueResult(); TotalLikes_90 += Int32.Parse(facebook_90_temp.TotalLikes); TalkingAbout_90 += Int32.Parse(facebook_90_temp.TalkingAbout); Likes_90 += facebook_90_temp.Likes; UniqueUser_90 += facebook_90_temp.UniqueUser; try { string[] arr1 = (facebook_90_temp.PerDayLikes).Split(','); for (int i = 0; i < 90; i++) { PerDayLikes_90[i] = PerDayLikes_90[i] + Int32.Parse(arr1[i]); } } catch (Exception) { for (int i = 0; i < 90; i++) { PerDayLikes_90[i] = PerDayLikes_90[i] + 0; } } Unlikes_90 += facebook_90_temp.Unlikes; try { string[] arr2 = (facebook_90_temp.PerDayUnlikes).Split(','); for (int i = 0; i < 90; i++) { PerDayUnlikes_90[i] = PerDayUnlikes_90[i] + Int32.Parse(arr2[i]); } } catch (Exception) { for (int i = 0; i < 90; i++) { PerDayUnlikes_90[i] = PerDayUnlikes_90[i] + 0; } } Impressions_90 += facebook_90_temp.Impression; try { string[] arr3 = (facebook_90_temp.PerDayImpression).Split(','); for (int i = 0; i < 90; i++) { PerDayImpressions_90[i] = PerDayImpressions_90[i] + Int32.Parse(arr3[i]); } } catch (Exception) { for (int i = 0; i < 90; i++) { PerDayImpressions_90[i] = PerDayImpressions_90[i] + 0; } } StoryShare_90 += facebook_90_temp.StoryShare; try { string[] arr4 = (facebook_90_temp.PerDayStoryShare).Split(','); for (int i = 0; i < 90; i++) { PerDayStoryShare_90[i] = PerDayStoryShare_90[i] + Int32.Parse(arr4[i]); } } catch (Exception) { for (int i = 0; i < 90; i++) { PerDayStoryShare_90[i] = PerDayStoryShare_90[i] + 0; } } ImpressionFans_90 += facebook_90_temp.ImpressionFans; ImpressionPagePost_90 += facebook_90_temp.ImpressionPagePost; ImpressionuserPost_90 += facebook_90_temp.ImpressionuserPost; ImpressionCoupn_90 += facebook_90_temp.ImpressionCoupn; ImpressionOther_90 += facebook_90_temp.ImpressionOther; ImpressionMention_90 += facebook_90_temp.ImpressionMention; ImpressionCheckin_90 += facebook_90_temp.ImpressionCheckin; ImpressionQuestion_90 += facebook_90_temp.ImpressionQuestion; ImpressionEvent_90 += facebook_90_temp.ImpressionEvent; Organic_90 += facebook_90_temp.Organic; Viral_90 += facebook_90_temp.Viral; Paid_90 += facebook_90_temp.Paid; M_13_17_90 += facebook_90_temp.M_13_17; M_18_24_90 += facebook_90_temp.M_18_24; M_25_34_90 += facebook_90_temp.M_25_34; M_35_44_90 += facebook_90_temp.M_35_44; M_45_54_90 += facebook_90_temp.M_45_54; M_55_64_90 += facebook_90_temp.M_55_64; M_65_90 += facebook_90_temp.M_65; F_13_17_90 += facebook_90_temp.F_13_17; F_18_24_90 += facebook_90_temp.F_18_24; F_25_34_90 += facebook_90_temp.F_25_34; F_35_44_90 += facebook_90_temp.F_35_44; F_45_54_90 += facebook_90_temp.F_45_54; F_55_64_90 += facebook_90_temp.F_55_64; F_65_90 += facebook_90_temp.F_65; Sharing_M_13_17_90 += facebook_90_temp.Sharing_M_13_17; Sharing_M_25_34_90 += facebook_90_temp.Sharing_M_25_34; Sharing_M_35_44_90 += facebook_90_temp.Sharing_M_35_44; Sharing_M_45_54_90 += facebook_90_temp.Sharing_M_45_54; Sharing_M_55_64_90 += facebook_90_temp.Sharing_M_55_64; Sharing_M_65_90 += facebook_90_temp.Sharing_M_65; Sharing_F_13_17_90 += facebook_90_temp.Sharing_F_13_17; Sharing_F_25_34_90 += facebook_90_temp.Sharing_F_25_34; Sharing_F_35_44_90 += facebook_90_temp.Sharing_F_35_44; Sharing_F_45_54_90 += facebook_90_temp.Sharing_F_45_54; Sharing_F_55_64_90 += facebook_90_temp.Sharing_F_55_64; Sharing_F_65_90 += facebook_90_temp.Sharing_F_65; } catch { } } } } facebook_15.TotalLikes = TotalLikes_15.ToString(); facebook_15.TalkingAbout = TalkingAbout_15.ToString(); facebook_15.Likes = Likes_15; facebook_15.Unlikes = Unlikes_15; facebook_15.Impression = Impressions_15; facebook_15.UniqueUser = UniqueUser_15; facebook_15.StoryShare = StoryShare_15; facebook_15.ImpressionFans = ImpressionFans_15; facebook_15.ImpressionPagePost = ImpressionPagePost_15; facebook_15.ImpressionuserPost = ImpressionuserPost_15; facebook_15.ImpressionCoupn = ImpressionCoupn_15; facebook_15.ImpressionOther = ImpressionOther_15; facebook_15.ImpressionMention = ImpressionMention_15; facebook_15.ImpressionCheckin = ImpressionCheckin_15; facebook_15.ImpressionQuestion = ImpressionQuestion_15; facebook_15.ImpressionEvent = ImpressionEvent_15; facebook_15.Organic = Organic_15; facebook_15.Viral = Viral_15; facebook_15.Paid = Paid_15; facebook_15.M_13_17 = M_13_17_15; facebook_15.M_18_24 = M_18_24_15; facebook_15.M_25_34 = M_25_34_15; facebook_15.M_35_44 = M_35_44_15; facebook_15.M_45_54 = M_45_54_15; facebook_15.M_55_64 = M_55_64_15; facebook_15.M_65 = M_65_15; facebook_15.F_13_17 = F_13_17_15; facebook_15.F_18_24 = F_18_24_15; facebook_15.F_25_34 = F_25_34_15; facebook_15.F_35_44 = F_35_44_15; facebook_15.F_45_54 = F_45_54_15; facebook_15.F_55_64 = F_55_64_15; facebook_15.F_65 = F_65_15; facebook_15.Sharing_M_13_17 = Sharing_M_13_17_15; facebook_15.Sharing_M_18_24 = Sharing_M_18_24_15; facebook_15.Sharing_M_25_34 = Sharing_M_25_34_15; facebook_15.Sharing_M_35_44 = Sharing_M_35_44_15; facebook_15.Sharing_M_45_54 = Sharing_M_45_54_15; facebook_15.Sharing_M_55_64 = Sharing_M_55_64_15; facebook_15.Sharing_M_65 = Sharing_M_65_15; facebook_15.Sharing_F_13_17 = Sharing_F_13_17_15; facebook_15.Sharing_F_18_24 = Sharing_F_18_24_15; facebook_15.Sharing_F_25_34 = Sharing_F_25_34_15; facebook_15.Sharing_F_35_44 = Sharing_F_35_44_15; facebook_15.Sharing_F_45_54 = Sharing_F_45_54_15; facebook_15.Sharing_F_55_64 = Sharing_F_55_64_15; facebook_15.Sharing_F_65 = Sharing_F_65_15; //facebook_15.total_fb_accounts = Int32.Parse(fb_accounts); facebook_15.total_fb_accounts = fb_count; facebook_30.TotalLikes = TotalLikes_30.ToString(); facebook_30.TalkingAbout = TalkingAbout_30.ToString(); facebook_30.Likes = Likes_30; facebook_30.Unlikes = Unlikes_30; facebook_30.Impression = Impressions_30; facebook_30.UniqueUser = UniqueUser_30; facebook_30.StoryShare = StoryShare_30; facebook_30.ImpressionFans = ImpressionFans_30; facebook_30.ImpressionPagePost = ImpressionPagePost_30; facebook_30.ImpressionuserPost = ImpressionuserPost_30; facebook_30.ImpressionCoupn = ImpressionCoupn_30; facebook_30.ImpressionOther = ImpressionOther_30; facebook_30.ImpressionMention = ImpressionMention_30; facebook_30.ImpressionCheckin = ImpressionCheckin_30; facebook_30.ImpressionQuestion = ImpressionQuestion_30; facebook_30.ImpressionEvent = ImpressionEvent_30; facebook_30.Organic = Organic_30; facebook_30.Viral = Viral_30; facebook_30.Paid = Paid_30; facebook_30.M_13_17 = M_13_17_30; facebook_30.M_18_24 = M_18_24_30; facebook_30.M_25_34 = M_25_34_30; facebook_30.M_35_44 = M_35_44_30; facebook_30.M_45_54 = M_45_54_30; facebook_30.M_55_64 = M_55_64_30; facebook_30.M_65 = M_65_30; facebook_30.F_13_17 = F_13_17_30; facebook_30.F_18_24 = F_18_24_30; facebook_30.F_25_34 = F_25_34_30; facebook_30.F_35_44 = F_35_44_30; facebook_30.F_45_54 = F_45_54_30; facebook_30.F_55_64 = F_55_64_30; facebook_30.F_65 = F_65_30; facebook_30.Sharing_M_13_17 = Sharing_M_13_17_30; facebook_30.Sharing_M_18_24 = Sharing_M_18_24_30; facebook_30.Sharing_M_25_34 = Sharing_M_25_34_30; facebook_30.Sharing_M_35_44 = Sharing_M_35_44_30; facebook_30.Sharing_M_45_54 = Sharing_M_45_54_30; facebook_30.Sharing_M_55_64 = Sharing_M_55_64_30; facebook_30.Sharing_M_65 = Sharing_M_65_30; facebook_30.Sharing_F_13_17 = Sharing_F_13_17_30; facebook_30.Sharing_F_18_24 = Sharing_F_18_24_30; facebook_30.Sharing_F_25_34 = Sharing_F_25_34_30; facebook_30.Sharing_F_35_44 = Sharing_F_35_44_30; facebook_30.Sharing_F_45_54 = Sharing_F_45_54_30; facebook_30.Sharing_F_55_64 = Sharing_F_55_64_30; facebook_30.Sharing_F_65 = Sharing_F_65_30; //facebook_30.total_fb_accounts = Int32.Parse(fb_accounts); facebook_30.total_fb_accounts = fb_count; facebook_60.TotalLikes = TotalLikes_60.ToString(); facebook_60.TalkingAbout = TalkingAbout_60.ToString(); facebook_60.Likes = Likes_60; facebook_60.Unlikes = Unlikes_60; facebook_60.Impression = Impressions_60; facebook_60.UniqueUser = UniqueUser_60; facebook_60.StoryShare = StoryShare_60; facebook_60.ImpressionFans = ImpressionFans_60; facebook_60.ImpressionPagePost = ImpressionPagePost_60; facebook_60.ImpressionuserPost = ImpressionuserPost_60; facebook_60.ImpressionCoupn = ImpressionCoupn_60; facebook_60.ImpressionOther = ImpressionOther_60; facebook_60.ImpressionMention = ImpressionMention_60; facebook_60.ImpressionCheckin = ImpressionCheckin_60; facebook_60.ImpressionQuestion = ImpressionQuestion_60; facebook_60.ImpressionEvent = ImpressionEvent_60; facebook_60.Organic = Organic_60; facebook_60.Viral = Viral_60; facebook_60.Paid = Paid_60; facebook_60.M_13_17 = M_13_17_60; facebook_60.M_18_24 = M_18_24_60; facebook_60.M_25_34 = M_25_34_60; facebook_60.M_35_44 = M_35_44_60; facebook_60.M_45_54 = M_45_54_60; facebook_60.M_55_64 = M_55_64_60; facebook_60.M_65 = M_65_60; facebook_60.F_13_17 = F_13_17_60; facebook_60.F_18_24 = F_18_24_60; facebook_60.F_25_34 = F_25_34_60; facebook_60.F_35_44 = F_35_44_60; facebook_60.F_45_54 = F_45_54_60; facebook_60.F_55_64 = F_55_64_60; facebook_60.F_65 = F_65_60; facebook_60.Sharing_M_13_17 = Sharing_M_13_17_60; facebook_60.Sharing_M_18_24 = Sharing_M_18_24_60; facebook_60.Sharing_M_25_34 = Sharing_M_25_34_60; facebook_60.Sharing_M_35_44 = Sharing_M_35_44_60; facebook_60.Sharing_M_45_54 = Sharing_M_45_54_60; facebook_60.Sharing_M_55_64 = Sharing_M_55_64_60; facebook_60.Sharing_M_65 = Sharing_M_65_60; facebook_60.Sharing_F_13_17 = Sharing_F_13_17_60; facebook_60.Sharing_F_18_24 = Sharing_F_18_24_60; facebook_60.Sharing_F_25_34 = Sharing_F_25_34_60; facebook_60.Sharing_F_35_44 = Sharing_F_35_44_60; facebook_60.Sharing_F_45_54 = Sharing_F_45_54_60; facebook_60.Sharing_F_55_64 = Sharing_F_55_64_60; facebook_60.Sharing_F_65 = Sharing_F_65_60; ////facebook_60.total_fb_accounts = Int32.Parse(fb_accounts); facebook_60.total_fb_accounts = fb_count; facebook_90.TotalLikes = TotalLikes_90.ToString(); facebook_90.TalkingAbout = TalkingAbout_90.ToString(); facebook_90.Likes = Likes_90; facebook_90.Unlikes = Unlikes_90; facebook_90.Impression = Impressions_90; facebook_90.UniqueUser = UniqueUser_90; facebook_90.StoryShare = StoryShare_90; facebook_90.ImpressionFans = ImpressionFans_90; facebook_90.ImpressionPagePost = ImpressionPagePost_90; facebook_90.ImpressionuserPost = ImpressionuserPost_90; facebook_90.ImpressionCoupn = ImpressionCoupn_90; facebook_90.ImpressionOther = ImpressionOther_90; facebook_90.ImpressionMention = ImpressionMention_90; facebook_90.ImpressionCheckin = ImpressionCheckin_90; facebook_90.ImpressionQuestion = ImpressionQuestion_90; facebook_90.ImpressionEvent = ImpressionEvent_90; facebook_90.Organic = Organic_90; facebook_90.Viral = Viral_90; facebook_90.Paid = Paid_90; facebook_90.M_13_17 = M_13_17_90; facebook_90.M_18_24 = M_18_24_90; facebook_90.M_25_34 = M_25_34_90; facebook_90.M_35_44 = M_35_44_90; facebook_90.M_45_54 = M_45_54_90; facebook_90.M_55_64 = M_55_64_90; facebook_90.M_65 = M_65_90; facebook_90.F_13_17 = F_13_17_90; facebook_90.F_18_24 = F_18_24_90; facebook_90.F_25_34 = F_25_34_90; facebook_90.F_35_44 = F_35_44_90; facebook_90.F_45_54 = F_45_54_90; facebook_90.F_55_64 = F_55_64_90; facebook_90.F_65 = F_65_90; facebook_90.Sharing_M_13_17 = Sharing_M_13_17_90; facebook_90.Sharing_M_18_24 = Sharing_M_18_24_90; facebook_90.Sharing_M_25_34 = Sharing_M_25_34_90; facebook_90.Sharing_M_35_44 = Sharing_M_35_44_90; facebook_90.Sharing_M_45_54 = Sharing_M_45_54_90; facebook_90.Sharing_M_55_64 = Sharing_M_55_64_90; facebook_90.Sharing_M_65 = Sharing_M_65_90; facebook_90.Sharing_F_13_17 = Sharing_F_13_17_90; facebook_90.Sharing_F_18_24 = Sharing_F_18_24_90; facebook_90.Sharing_F_25_34 = Sharing_F_25_34_90; facebook_90.Sharing_F_35_44 = Sharing_F_35_44_90; facebook_90.Sharing_F_45_54 = Sharing_F_45_54_90; facebook_90.Sharing_F_55_64 = Sharing_F_55_64_90; facebook_90.Sharing_F_65 = Sharing_F_65_90; facebook_15.GroupId = Guid.Parse(groupid); facebook_30.GroupId = Guid.Parse(groupid); facebook_60.GroupId = Guid.Parse(groupid); facebook_90.GroupId = Guid.Parse(groupid); //facebook_90.total_fb_accounts = Int32.Parse(fb_accounts); facebook_90.total_fb_accounts = fb_count; if(PerDayImpressions_15 !=null) { str_PerDayImpressions_15 = String.Join(",", PerDayImpressions_15); } else { for (int i = 0; i < 15; i++) { str_PerDayImpressions_15 = str_PerDayImpressions_15 + "0,"; } } if (PerDayImpressions_30 != null) { str_PerDayImpressions_30 = String.Join(",", PerDayImpressions_30); } else { for (int i = 0; i < 30; i++) { str_PerDayImpressions_30 = str_PerDayImpressions_30 + "0,"; } } if (PerDayImpressions_60 != null) { str_PerDayImpressions_60 = String.Join(",", PerDayImpressions_60); } else { for (int i = 0; i < 60; i++) { str_PerDayImpressions_60 = str_PerDayImpressions_60 + "0,"; } } if (PerDayImpressions_90 != null) { str_PerDayImpressions_90 = String.Join(",", PerDayImpressions_90); } else { for (int i = 0; i < 90; i++) { str_PerDayImpressions_90 = str_PerDayImpressions_90 + "0,"; } } if (PerDayLikes_15 != null) { str_PerDayLikes_15 = String.Join(",", PerDayLikes_15); } else { for (int i = 0; i < 15; i++) { str_PerDayLikes_15 = str_PerDayLikes_15 + "0,"; } } if (PerDayLikes_30 != null) { str_PerDayLikes_30 = String.Join(",", PerDayLikes_30); } else { for (int i = 0; i < 30; i++) { str_PerDayLikes_30 = str_PerDayLikes_30 + "0,"; } } if (PerDayLikes_60 != null) { str_PerDayLikes_60 = String.Join(",", PerDayLikes_60); } else { for (int i = 0; i < 60; i++) { str_PerDayLikes_60 = str_PerDayLikes_60 + "0,"; } } if (PerDayLikes_90 != null) { str_PerDayLikes_90 = String.Join(",", PerDayLikes_90); } else { for (int i = 0; i < 90; i++) { str_PerDayLikes_90 = str_PerDayLikes_90 + "0,"; } } if (PerDayStoryShare_15 != null) { str_PerDayStoryShare_15 = String.Join(",", PerDayStoryShare_15); } else { for (int i = 0; i < 15; i++) { str_PerDayStoryShare_15 = str_PerDayStoryShare_15 + "0,"; } } if (PerDayStoryShare_30 != null) { str_PerDayStoryShare_30 = String.Join(",", PerDayStoryShare_30); } else { for (int i = 0; i < 30; i++) { str_PerDayStoryShare_30 = str_PerDayStoryShare_30 + "0,"; } } if (PerDayStoryShare_60 != null) { str_PerDayStoryShare_60 = String.Join(",", PerDayStoryShare_60); } else { for (int i = 0; i < 60; i++) { str_PerDayStoryShare_60 = str_PerDayStoryShare_60 + "0,"; } } if (PerDayStoryShare_90 != null) { str_PerDayStoryShare_90 = String.Join(",", PerDayStoryShare_90); } else { for (int i = 0; i < 90; i++) { str_PerDayStoryShare_90 = str_PerDayStoryShare_90 + "0,"; } } if (PerDayUnlikes_15 != null) { str_PerDayUnlikes_15 = String.Join(",", PerDayUnlikes_15); } else { for (int i = 0; i < 15; i++) { str_PerDayUnlikes_15 = str_PerDayUnlikes_15 + "0,"; } } if (PerDayUnlikes_30 != null) { str_PerDayUnlikes_30 = String.Join(",", PerDayUnlikes_30); } else { for (int i = 0; i < 30; i++) { str_PerDayUnlikes_30 = str_PerDayUnlikes_30 + "0,"; } } if (PerDayUnlikes_60 != null) { str_PerDayUnlikes_60 = String.Join(",", PerDayUnlikes_60); } else { for (int i = 0; i < 60; i++) { str_PerDayUnlikes_60 = str_PerDayUnlikes_60 + "0,"; } } if (PerDayUnlikes_90 != null) { str_PerDayUnlikes_90 = String.Join(",", PerDayUnlikes_90); } else { for (int i = 0; i < 90; i++) { str_PerDayUnlikes_90 = str_PerDayUnlikes_90 + "0,"; } } facebook_15.PerDayImpression = str_PerDayImpressions_15; facebook_15.PerDayLikes = str_PerDayLikes_15; facebook_15.PerDayStoryShare = str_PerDayStoryShare_15; facebook_15.PerDayUnlikes = str_PerDayUnlikes_15; facebook_30.PerDayImpression = str_PerDayImpressions_30; facebook_30.PerDayLikes = str_PerDayLikes_30; facebook_30.PerDayStoryShare = str_PerDayStoryShare_30; facebook_30.PerDayUnlikes = str_PerDayUnlikes_30; facebook_60.PerDayImpression = str_PerDayImpressions_60; facebook_60.PerDayLikes = str_PerDayLikes_60; facebook_60.PerDayStoryShare = str_PerDayStoryShare_60; facebook_60.PerDayUnlikes = str_PerDayUnlikes_60; facebook_90.PerDayImpression = str_PerDayImpressions_90; facebook_90.PerDayLikes = str_PerDayLikes_90; facebook_90.PerDayStoryShare = str_PerDayStoryShare_90; facebook_90.PerDayUnlikes = str_PerDayUnlikes_90; insert_15(facebook_15); insert_30(facebook_30); insert_60(facebook_60); insert_90(facebook_90); } // } catch(Exception e) { } }
public string retrieve_60(string groupid) { string ret_string = string.Empty; Domain.Socioboard.Domain.FacebookGroupReport_60 ret = new Domain.Socioboard.Domain.FacebookGroupReport_60(); using (NHibernate.ISession session = SessionFactory.GetNewSession()) { try { NHibernate.IQuery retrieve = session.CreateQuery("from FacebookGroupReport_60 where GroupId =: grpid").SetParameter("grpid", Guid.Parse(groupid)); ret = (Domain.Socioboard.Domain.FacebookGroupReport_60)retrieve.UniqueResult(); if (ret == null) { ret = new Domain.Socioboard.Domain.FacebookGroupReport_60(); } ret_string = new JavaScriptSerializer().Serialize(ret); } catch (Exception e) { ret = new Domain.Socioboard.Domain.FacebookGroupReport_60(); ret_string = new JavaScriptSerializer().Serialize(ret); } } return ret_string; }