public void DeleteFacebookUser(string UserId, string FacebookId)
{
Guid userid = Guid.Parse(UserId);
FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
int i = fbAccRepo.deleteFacebookUser(FacebookId, userid);
if (i != 0)
{
FacebookFeedRepository fbfeedRepo = new FacebookFeedRepository();
try
{
fbfeedRepo.deleteAllFeedsOfUser(FacebookId, userid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
FacebookMessageRepository fbmsgRepo = new FacebookMessageRepository();
try
{
fbmsgRepo.deleteAllMessagesOfUser(FacebookId, userid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
public List <FacebookFeed> getFacebookFeedsOfUser(Guid userid, string profileid)
{
FacebookFeedRepository facefeedrepo = new FacebookFeedRepository();
List <FacebookFeed> lstfacefeed = facefeedrepo.getAllFacebookFeedsOfUser(userid, profileid);
return(lstfacefeed);
}
public string UserFeeds(string UserId, string FacebookId)
{
try
{
Guid userid = Guid.Parse(UserId);
FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
List <FacebookFeed> lstfbfeed = fbfeedrepo.getAllFacebookUserFeeds(FacebookId);
return(new JavaScriptSerializer().Serialize(lstfbfeed));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(new JavaScriptSerializer().Serialize("Please Try Again"));
}
}
// Saving FacebookFeeds of user into database i.e. FacebookFeed Table
public void getFacebookUserFeeds(dynamic data, dynamic profile)
{
FacebookFeed fbfeed = new FacebookFeed();
User user = (User)HttpContext.Current.Session["LoggedUser"];
FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
if (data != null)
{
foreach (var result in data["data"])
{
fbfeed.Type = "fb_feed";
try
{
fbfeed.UserId = user.Id;
}
catch (Exception ex)
{ Console.WriteLine(ex.StackTrace); }
try
{
fbfeed.ProfileId = profile["id"].ToString();
}
catch (Exception ex)
{ Console.WriteLine(ex.StackTrace); }
try
{
fbfeed.Id = Guid.NewGuid();
}
catch (Exception ex)
{ Console.WriteLine(ex.StackTrace); }
fbfeed.FromProfileUrl = "http://graph.facebook.com/" + result["from"]["id"] + "/picture?type=small";
fbfeed.FromName = result["from"]["name"].ToString();
fbfeed.FromId = result["from"]["id"].ToString();
fbfeed.FeedId = result["id"].ToString();
fbfeed.FeedDate = DateTime.Parse(result["created_time"].ToString());
fbfeed.FbComment = "http://graph.facebook.com/" + result["id"] + "/comments";
fbfeed.FbLike = "http://graph.facebook.com/" + result["id"] + "/likes";
string message = string.Empty;
int lstfbcount = 0;
if (lstfbcount < 25)
{
try
{
if (result["message"] != null)
{
message = result["message"];
lstfbcount++;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
try
{
if (result["description"] != null)
{
message = result["description"];
lstfbcount++;
}
}
catch (Exception exx)
{
try
{
Console.WriteLine(exx.StackTrace);
if (result["story"] != null)
{
message = result["story"];
lstfbcount++;
}
}
catch (Exception exxx)
{
Console.WriteLine(exxx.StackTrace);
message = string.Empty;
}
}
}
}
fbfeed.FeedDescription = message;
fbfeed.EntryDate = DateTime.Now;
if (!fbfeedrepo.checkFacebookFeedExists(fbfeed.FeedId))
{
fbfeedrepo.addFacebookFeed(fbfeed);
}
}
}
}
public DataSet bindFeedMessageIntoDataTable(string[] profid)
{
string fbProfileid = string.Empty;
string twtProfileid = string.Empty;
string profilId = string.Empty;
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
try
{
foreach (var item in profid)
{
if (item.Contains("fb_"))
{
profilId = item.ToString().Split('_')[1];
fbProfileid += profilId + ',';
}
else if (item.Contains("twt_"))
{
profilId = item.ToString().Split('_')[1];
twtProfileid += profilId + ',';
}
else
{
try
{
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
try
{
fbProfileid = fbProfileid.Substring(0, fbProfileid.Length - 1);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtProfileid = twtProfileid.Substring(0, twtProfileid.Length - 1);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
FacebookFeedRepository fbfeedRepository = new FacebookFeedRepository();
List <FacebookFeed> alstfbmsgs = fbfeedRepository.getAllFeedDetail(fbProfileid);
try
{
foreach (FacebookFeed facebookmsg in alstfbmsgs)
{
try
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
TwitterMessageRepository twtmsgRepository = new TwitterMessageRepository();
List <TwitterMessage> lstmsgtwt = twtmsgRepository.getAlltwtMessages(twtProfileid);
try
{
foreach (TwitterMessage lst in lstmsgtwt)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(ds);
}
public DataSet bindMessagesIntoDataTable(Guid id)
{
//SocialProfilesRepository socioprofrepo = new SocialProfilesRepository();
//List<SocialProfile> alstprofiles = socioprofrepo.getAllSocialProfilesOfUser(user.Id);
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
List <TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(id);
// DataTableGenerator datatablegenerepo = new DataTableGenerator();
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
// DataSet ds = datatablegenerepo.CreateDataSetForTable(mstable);
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
FacebookFeedRepository fbfeedRepo = new FacebookFeedRepository();
List <FacebookFeed> alstfeedfb = fbfeedRepo.getUnreadMessages(item.ProfileId);
foreach (FacebookFeed facebookmsg in alstfeedfb)
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
}
else if (item.ProfileType == "twitter")
{
TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
List <TwitterMessage> lstmsgtwtuser = twtmsgrepo.getUnreadMessages(item.ProfileId);
foreach (TwitterMessage lst in lstmsgtwtuser)
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
}
else if (item.ProfileType == "googleplus")
{
}
}
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
try
{
//FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
//List<FacebookFeed> alstfbmsgs = fbfeedrepo.getAllReadFacebookFeeds(user.Id, item.ProfileId);
//foreach (FacebookFeed facebookmsg in alstfbmsgs)
//{
// ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type,facebookmsg.ReadStatus);
//}
facebookid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "twitter")
{
try
{
//TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
//List<TwitterMessage> lstmsgtwtuser = twtmsgrepo.getAllReadMessagesOfUser(user.Id, item.ProfileId);
//foreach (TwitterMessage lst in lstmsgtwtuser)
//{
// ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type,lst.ReadStatus);
//}
twitterid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (item.ProfileType == "googleplus")
{
try
{
//GooglePlusActivitiesRepository objActRepo = new GooglePlusActivitiesRepository();
//List<GooglePlusActivities> lstmsggauser = objActRepo.getAllgoogleplusActivityOfUser(user.Id, item.ProfileId);
//foreach (GooglePlusActivities lst in lstmsggauser)
//{
// ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
//}
googleplusid += item.ProfileId + ",";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
if (facebookid != "")
{
facebookid = facebookid.Substring(0, facebookid.Length - 1);
}
if (twitterid != "")
{
twitterid = twitterid.Substring(0, twitterid.Length - 1);
}
if (googleplusid != "")
{
googleplusid = googleplusid.Substring(0, googleplusid.Length - 1);
}
FacebookFeedRepository fbfeedRepository = new FacebookFeedRepository();
List <FacebookFeed> alstfbmsgs = fbfeedRepository.getAllReadFbFeeds(facebookid);
try
{
foreach (FacebookFeed facebookmsg in alstfbmsgs)
{
try
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.FeedDate, facebookmsg.FeedDescription, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.FeedId, facebookmsg.Type, facebookmsg.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
TwitterMessageRepository twtmsgRepository = new TwitterMessageRepository();
List <TwitterMessage> lstmsgtwt = twtmsgRepository.getAlltwtMessagesOfUser(twitterid);
try
{
foreach (TwitterMessage lst in lstmsgtwt)
{
try
{
ds.Tables[0].Rows.Add(lst.ProfileId, "twitter", lst.FromId, lst.FromScreenName, lst.FromProfileUrl, lst.MessageDate, lst.TwitterMsg, "", "", lst.MessageId, lst.Type, lst.ReadStatus);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
GooglePlusActivitiesRepository objActRepository = new GooglePlusActivitiesRepository();
List <GooglePlusActivities> lstmsggpl = objActRepository.getAllgplusOfUser(googleplusid);
try
{
foreach (GooglePlusActivities lst in lstmsggpl)
{
try
{
ds.Tables[0].Rows.Add(lst.GpUserId, "googleplus", lst.FromId, lst.FromUserName, lst.FromProfileImage, lst.PublishedDate, lst.Content, "", "", lst.ActivityId, "activities");
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
HttpContext.Current.Response.Cache.SetExpires(DateTime.UtcNow.AddDays(-1));
HttpContext.Current.Response.Cache.SetValidUntilExpires(false);
HttpContext.Current.Response.Cache.SetRevalidation(HttpCacheRevalidation.AllCaches);
HttpContext.Current.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Current.Response.Cache.SetNoStore();
TeamRepository objTeamRepository = new TeamRepository();
GroupRepository objGroupRepository = new GroupRepository();
try
{
User user = (User)Session["LoggedUser"];
// SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)Session["GroupName"];
#region check user Activation
UserRepository objUserRepository = new UserRepository();
try
{
if (user != null)
{
if (user.ActivationStatus == "0" || user.ActivationStatus == null)
{
actdiv.InnerHtml = "<marquee behavior=\"scroll\" direction=\"left\"><span >Your account is not yet activated.Check your E-mail to activate your account.</span><a id=\"resendmail\" uid=\"" + user.Id + "\" href=\"#\">Resend Mail</a></marquee>";
if (Request.QueryString["stat"] == "activate")
{
if (Request.QueryString["id"] != null)
{
//objUserActivation = objUserActivationRepository.GetUserActivationStatusbyid(Request.QueryString["id"].ToString());
if (user.Id.ToString() == Request.QueryString["id"].ToString())
{
user.Id = user.Id; //Guid.Parse(Request.QueryString["id"]);
//objUserActivation.UserId = Guid.Parse(Request.QueryString["id"]);// objUserActivation.UserId;
user.ActivationStatus = "1";
//UserActivationRepository.Update(objUserActivation);
int res = objUserRepository.UpdateActivationStatusByUserId(user);
actdiv.Attributes.CssStyle.Add("display", "none");
Console.WriteLine("before");
#region to check/update user Reference Relation
IsUserReferenceActivated(Request.QueryString["id"].ToString());
Console.WriteLine("after");
#endregion
}
else
{
Session["ActivationError"] = "Wrong Activation Link please contact Admin!";
//ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Wrong Activation Link please contact Admin!');", true);
//Response.Redirect("ActivationLink.aspx");
}
}
else
{
Session["ActivationError"] = "Wrong Activation Link please contact Admin!";
//ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Wrong Activation Link please contact Admin!');", true);
//Response.Redirect("ActivationLink.aspx");
}
}
else
{
// Response.Redirect("ActivationLink.aspx");
}
}
if (user.ActivationStatus == "1")
{
actdiv.Attributes.CssStyle.Add("display", "none");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
#endregion
if (!IsPostBack)
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "my", " logout();", true);
if (user == null)
{
Response.Redirect("/Default.aspx");
}
else
{
#region for You can use only 30 days as Unpaid User
if (user.PaymentStatus.ToLower() == "unpaid")
{
if (!SBUtils.IsUserWorkingDaysValid(user.ExpiryDate))
{
// cmposecontainer.Attributes.Add("display", "none");
cmposecontainer.Attributes.CssStyle.Add("display", "none");
//topbtn.Attributes.CssStyle.Add("display", "none");
cmposecontainer.Attributes.CssStyle.Add("display", "none");
searchcontainer.Attributes.CssStyle.Add("display", "none");
}
}
#endregion
try
{
if (Session["IncomingTasks"] != null)
{
//incom_tasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
//incomTasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
}
else
{
//TaskRepository taskRepo = new TaskRepository();
//ArrayList alst = taskRepo.getAllIncompleteTasksOfUser(user.Id,team.GroupId);
//Session["IncomingTasks"] = alst.Count;
//incom_tasks.InnerHtml = Convert.ToString(alst.Count);
//incomTasks.InnerHtml = Convert.ToString(alst.Count);
}
}
catch (Exception es)
{
logger.Error(es.Message);
Console.WriteLine(es.Message);
}
try
{
FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository();
int alstfeedfb = objFacebookFeedRepository.countUnreadMessages(user.Id);
TwitterMessageRepository objTwitterMessageRepository = new TwitterMessageRepository();
int alstMsgtwt = objTwitterMessageRepository.getCountUnreadMessages(user.Id);
incom_messages.InnerHtml = (alstfeedfb + alstMsgtwt).ToString();
if (Session["CountMessages"] != null)
{
//incom_messages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
//incomMessages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
}
else
{
//incom_messages.InnerHtml = "0";
//incomMessages.InnerHtml = "0";
}
}
catch (Exception sx)
{
logger.Error(sx.Message);
Console.WriteLine(sx.Message);
}
//======================================================================================================
try
{
ArrayList totalAccuount = objTeamRepository.getAllAccountUser(user.EmailId, user.Id);
if (totalAccuount.Count != 0)
{
string drodownselectedvalue = string.Empty;
try
{
foreach (Guid item in totalAccuount)
{
Guid GroupIde = (Guid)item;
List <Groups> GetData = objGroupRepository.getAllGroupsDetail(GroupIde);
if (GetData.Count != 0)
{
string val = string.Empty;
foreach (var items in GetData)
{
try
{
if (items.GroupName == "Socioboard")
{
drodownselectedvalue = items.Id.ToString();
}
groupsselection.Items.Add(new ListItem((string)items.GroupName, items.Id.ToString()));
}
catch { }
}
}
}
if (Session["groupcheck"] == null)
{
int i = 0;
groupsselection.SelectedIndex = groupsselection.Items.IndexOf(groupsselection.Items.FindByText("Socioboard"));
//groupsselection.SelectedIndex = groupsselection.Items.IndexOf(groupsselection.Items.FindByValue("Socioboard"));
//ListItem li = groupsselection.Items.FindByText(drodownselectedvalue);
//li.Selected = true;
Session["groupcheck"] = groupsselection.Items.FindByText("Socioboard").Value;
}
else
{
groupsselection.SelectedIndex = groupsselection.Items.IndexOf(groupsselection.Items.FindByValue((string)Session["groupcheck"]));
//groupsselection.se.SelectedIndex = Session["groupcheck"];
}
//if (Session["groupcheck"] == null)
//{
// groupsselection.SelectedValue = (drodownselectedvalue);
// Session["groupcheck"] = groupsselection.SelectedValue;
//}
//else
//{
// groupsselection.SelectedIndex = Session["groupcheck"];
//}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error("Error : " + ex.Message);
logger.Error("Error : " + ex.StackTrace);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error("Error : " + ex.Message);
logger.Error("Error : " + ex.StackTrace);
}
//=====================================================================================================================================
usernm.InnerHtml = "Hello, " + user.UserName + " ";
if (!string.IsNullOrEmpty(user.ProfileUrl))
{
// Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" /></a></a>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" />";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" />";
//userinf.InnerHtml = Datetime;
//{
//userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/></a></a>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\" height=\"100\" width=\"100\"/>";
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userinf.InnerHtml = Datetime;
}
if (user.TimeZone == null)
{
Datetime = DateTime.Now.ToString();
//userinf.InnerHtml = Datetime;
}
}
else
{
//Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/></a>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/>";
//userinf.InnerHtml = Datetime;
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userinf.InnerHtml = Datetime;
}
if (user.TimeZone == null)
{
Datetime = DateTime.Now.ToString();
//userinf.InnerHtml = Datetime;
}
}
try
{
GroupRepository grouprepo = new GroupRepository();
List <Groups> lstgroups = grouprepo.getAllGroupsCompleteDetails(user.Id);
string totgroups = string.Empty;
if (lstgroups.Count != 0)
{
foreach (Groups item in lstgroups)
{
totgroups += "<li><a href=\"../Settings/InviteMember.aspx?q=" + item.Id + "\" id=\"group_" + item.Id + "\"><img src=\"../Contents/img/groups_.png\" alt=\"\" style=\" margin-right:5px;\"/>" + item.GroupName + "</a></li>";
}
inviteRedirect.InnerHtml = totgroups;
}
if (user.AccountType == AccountType.Deluxe.ToString().ToLower())
{
tot_acc = 10;
}
else if (user.AccountType == AccountType.Standard.ToString().ToLower())
{
tot_acc = 20;
}
else if (user.AccountType == AccountType.Premium.ToString().ToLower())
{
tot_acc = 50;
}
profileCount = objSocioRepo.getAllSocialProfilesOfUser(user.Id).Count;
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
}
//Team lstDetails = objTeamRepository.getAllGroupsDetails(user.EmailId.ToString(), Guid.Parse(groupsselection.SelectedItem.Value));
//Session["GroupName"] = lstDetails;
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
UserRefRelationRepository objUserRefRelationRepository = new UserRefRelationRepository();
UserRepository userrepo = new UserRepository();
Registration regObject = new Registration();
TeamRepository objTeamRepo = new TeamRepository();
NewsRepository objNewsRepo = new NewsRepository();
AdsRepository objAdsRepo = new AdsRepository();
UserActivation objUserActivation = new UserActivation();
UserActivationRepository objUserActivationRepository = new UserActivationRepository();
SocialProfilesRepository objSocioRepo = new SocialProfilesRepository();
GroupRepository objGroupRepository = new GroupRepository();
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
Team team = new Team();
SocioBoard.Domain.User user = (User)Session["LoggedUser"];
try
{
if (Session["GroupName"] == null)
{
Groups objGroupDetails = objGroupRepository.getGroupDetail(user.Id);
team = objTeamRepo.getAllDetails(objGroupDetails.Id, user.EmailId);
Session["GroupName"] = team;
}
else
{
team = (SocioBoard.Domain.Team)Session["GroupName"];
}
}
catch (Exception ex)
{
logger.Error("Error: " + ex.Message);
}
Session["facebooktotalprofiles"] = null;
if (user.Password == null)
{
Response.Redirect("/Pricing.aspx");
}
#region Days remaining
if (Session["days_remaining"] == null)
{
if (user.PaymentStatus == "unpaid" && user.AccountType != "Free")
{
int daysremaining = (user.ExpiryDate.Date - DateTime.Now.Date).Days;
if (daysremaining < 0)
{
daysremaining = -1;
}
Session["days_remaining"] = daysremaining;
//ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('You are using '" + user.AccountType + "' account only '" + daysremaining + "' days is remaining !');", true);
if (daysremaining <= -1)
{
}
else if (daysremaining == 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Your trial " + user.AccountType + " account will expire end of the day, please upgrade to paid plan.');", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Your trial " + user.AccountType + " account will expire in " + daysremaining + " days, please upgrade to paid plan.');", true);
}
}
}
#endregion
#region for You can use only 30 days as Unpaid User
if (user.PaymentStatus.ToLower() == "unpaid" && user.AccountType != "Free")
{
if (!SBUtils.IsUserWorkingDaysValid(user.ExpiryDate))
{
// ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('You can use only 30 days as Unpaid User !');", true);
Session["GreaterThan30Days"] = "GreaterThan30Days";
Response.Redirect("/Settings/Billing.aspx");
}
}
Session["GreaterThan30Days"] = null;
#endregion
if (!IsPostBack)
{
try
{
if (user == null)
{
Response.Redirect("Default.aspx");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
try
{
objUserActivation = objUserActivationRepository.GetUserActivationStatus(user.Id.ToString());
}
catch (Exception ex)
{
Session["objUserActivationException"] = "objUserActivationException";
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
#region Count Used Accounts
try
{
if (user.AccountType.ToString().ToLower() == AccountType.Deluxe.ToString().ToLower())
{
tot_acc = 50;
}
else if (user.AccountType.ToString().ToLower() == AccountType.Standard.ToString().ToLower())
{
tot_acc = 10;
}
else if (user.AccountType.ToString().ToLower() == AccountType.Premium.ToString().ToLower())
{
tot_acc = 20;
}
else if (user.AccountType.ToString().ToLower() == AccountType.Free.ToString().ToLower())
{
tot_acc = 5;
}
else if (user.AccountType.ToString().ToLower() == AccountType.SocioBasic.ToString().ToLower())
{
tot_acc = 100;
}
else if (user.AccountType.ToString().ToLower() == AccountType.SocioStandard.ToString().ToLower())
{
tot_acc = 200;
}
else if (user.AccountType.ToString().ToLower() == AccountType.SocioPremium.ToString().ToLower())
{
tot_acc = 500;
}
else if (user.AccountType.ToString().ToLower() == AccountType.SocioDeluxe.ToString().ToLower())
{
tot_acc = 1000;
}
profileCount = objSocioRepo.getAllSocialProfilesOfUser(user.Id).Count;
Session["ProfileCount"] = profileCount;
Session["TotalAccount"] = tot_acc;
try
{
Groups lstDetail = objGroupRepository.getGroupName(team.GroupId);
if (lstDetail.GroupName == "Socioboard")
{
usedAccount.InnerHtml = " using " + profileCount + " of " + tot_acc;
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
#endregion
try
{
Groups lstDetails = objGroupRepository.getGroupName(team.GroupId);
if (lstDetails.GroupName != "Socioboard")
{
expander.Attributes.CssStyle.Add("display", "none");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
//this is used to check whether facebok account Already Exist
if (Session["alreadyexist"] != null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('This Profile is Already Added please add aother Account!');", true);
Session["alreadyexist"] = null;
}
if (Session["alreadypageexist"] != null)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('This Page is Already Added please add aother Page!');", true);
Session["alreadypageexist"] = null;
}
if (!string.IsNullOrEmpty(Request.QueryString["type"]))
{
try
{
userrepo.UpdateAccountType(user.Id, Request.QueryString["type"]);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.StackTrace);
}
}
//acrossProfile.InnerHtml = "Across " + user.UserName + "'s Twitter and Facebook accounts";
teamMem.InnerHtml = "managing " + user.UserName;
try
{
News nws = objNewsRepo.getNewsForHome();
//divNews.InnerHtml = nws.NewsDetail;
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
try
{
ArrayList lstads = objAdsRepo.getAdsForHome();
if (lstads.Count < 1)
{
if (user.PaymentStatus.ToUpper() == "PAID")
{
bindads.InnerHtml = "<img src=\"../Contents/img/admin/ads.png\" alt=\"\" >";
}
else
{
#region ADS Script
bindads.InnerHtml = "<script async src=\"//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js\"></script>" +
"<!-- socioboard -->" +
"<ins class=\"adsbygoogle\"" +
"style=\"display:inline-block;width:250px;height:250px\"" +
"data-ad-client=\"ca-pub-7073257741073458\"" +
"data-ad-slot=\"9533254693\"></ins>" +
"<script>" +
"(adsbygoogle = window.adsbygoogle || []).push({});" +
"</script>";
#endregion
}
}
foreach (var item in lstads)
{
Array temp = (Array)item;
//imgAds.ImageUrl = temp.GetValue(2).ToString();
if (user.PaymentStatus.ToUpper() == "PAID")
{
bindads.InnerHtml = "<img src=\"" + temp.GetValue(2).ToString() + "\" alt=\"\" style=\"width:246px;height:331px\">";
}
else
{
#region ADS Script
bindads.InnerHtml = "<script async src=\"//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js\"></script>" +
"<!-- socioboard -->" +
"<ins class=\"adsbygoogle\"" +
"style=\"display:inline-block;width:250px;height:250px\"" +
"data-ad-client=\"ca-pub-7073257741073458\"" +
"data-ad-slot=\"9533254693\"></ins>" +
"<script>" +
"(adsbygoogle = window.adsbygoogle || []).push({});" +
"</script>";
#endregion
}
break;
// ads.ImageUrl;
}
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
#region Team Member Count
try
{
GroupRepository grouprepo = new GroupRepository();
string groupsofhome = string.Empty;
List <Groups> lstgroups = grouprepo.getAllGroups(user.Id);
if (lstgroups.Count != 0)
{
foreach (Groups item in lstgroups)
{
groupsofhome += "<li><a href=\"../Settings/InviteMember.aspx?q=" + item.Id + "\"><img src=\"../Contents/img/groups_.png\" alt=\"\" style=\" margin-right:5px;\"> " + item.GroupName + "</a></li>";
}
getAllGroupsOnHome.InnerHtml = groupsofhome;
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
#endregion
try
{
string strTeam = string.Empty;
List <Team> teams = objTeamRepo.getAllTeamsOfUser(user.Id, team.GroupId, user.EmailId);
foreach (Team item in teams)
{
strTeam += "<div class=\"userpictiny\"><a target=\"_blank\" href=\"#\">" +
"<img width=\"48\" height=\"48\" title=\"" + item.FirstName + "\" alt=\"\" src=\"../Contents/img/blank_img.png\">" +
"</a></div>";
}
team_member.InnerHtml = strTeam;
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
#region Add Fan Page
try
{
if (Session["fbSocial"] != null)
{
if (Session["fbSocial"] == "p")
{
FacebookAccount objFacebookAccount = (FacebookAccount)Session["fbpagedetail"];
// string strpageUrl = "https://graph.facebook.com/" + objFacebookAccount.FacebookId + "/accounts";
// objFacebookUrlBuilder = (FacebookUrlBuilder)Session["FacebookInsightUser"];
// string strData = objAuthentication.RequestUrl(strpageUrl, objFacebookAccount.Token);
// JObject output = objWebRequest.FacebookRequest(strData, "Get");
FacebookClient fb = new FacebookClient();
fb.AccessToken = objFacebookAccount.AccessToken;
dynamic output = fb.Get("/me/accounts");
// JArray data = (JArray)output["data"];
DataTable dtFbPage = new DataTable();
dtFbPage.Columns.Add("Email");
dtFbPage.Columns.Add("PageId");
dtFbPage.Columns.Add("PageName");
dtFbPage.Columns.Add("status");
dtFbPage.Columns.Add("customer_id");
string strPageDiv = string.Empty;
if (output != null)
{
foreach (var item in output["data"])
{
if (item.category.ToString() != "Application")
{
strPageDiv += "<div><a id=\"A1\" onclick=\"getInsights('" + item["id"].ToString() + "','" + item["name"].ToString() + "')\"><span>" + item["name"].ToString() + "</span> </a></div>";
fbpage.InnerHtml = strPageDiv;
}
}
}
else
{
strPageDiv += "<div>No Pages Found</div>";
}
Page.ClientScript.RegisterStartupScript(Page.GetType(), "my", " ShowDialogHome(false);", true);
Session["fbSocial"] = null;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.StackTrace);
}
#endregion
#region InsightsData
try
{
decimal malecount = 0, femalecount = 0, cnt = 0;
FacebookStatsRepository objfbStatsRepo = new FacebookStatsRepository();
double daysSub = (DateTime.Now - user.CreateDate).TotalDays;
int userdays;
if (daysSub > 0 && daysSub <= 1)
{
userdays = 1;
}
else
{
userdays = (int)daysSub;
}
ArrayList arrFbStats = objfbStatsRepo.getAllFacebookStatsOfUser(user.Id, userdays);
//ArrayList arrFbStats = objfbStatsRepo.getTotalFacebookStatsOfUser(user.Id);
Random rNum = new Random();
foreach (var item in arrFbStats)
{
Array temp = (Array)item;
cnt += int.Parse(temp.GetValue(3).ToString()) + int.Parse(temp.GetValue(4).ToString());
malecount += int.Parse(temp.GetValue(3).ToString());
femalecount += int.Parse(temp.GetValue(4).ToString());
}
try
{
decimal mc = (malecount / cnt) * 100;
male = Convert.ToInt16(mc);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
try
{
decimal fc = (femalecount / cnt) * 100;
female = Convert.ToInt16(fc);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
int twtAccCount = objSocioRepo.getAllSocialProfilesTypeOfUser(user.Id, "twitter").Count;
if (twtAccCount > 1)
{
twtmale = rNum.Next(100);
twtfemale = 100 - twtmale;
}
else if (twtAccCount == 1)
{
twtmale = 100;
twtfemale = 0;
}
Session["twtGender"] = twtmale + "," + twtfemale;
}
catch (Exception Err)
{
Console.Write(Err.Message.ToString());
logger.Error(Err.StackTrace);
}
//getgrphData();
// getNewFriends(7);
// getNewFriends();
// getNewFollowers();
#endregion
#region GetFollower
try
{
String TwtProfileId = string.Empty;
TwitterStatsRepository objtwtStatsRepo = new TwitterStatsRepository();
List <TeamMemberProfile> objTeamMemberProfile = objTeamMemberProfileRepository.getTwtTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in objTeamMemberProfile)
{
TwtProfileId += item.ProfileId + ',';
}
TwtProfileId = TwtProfileId.Substring(0, TwtProfileId.Length - 1);
List <TwitterStats> arrTwtStats = objtwtStatsRepo.getAllAccountDetail(TwtProfileId);
//strTwtArray = "[";
int NewTweet_Count = 0;
string TotalFollower = string.Empty;
foreach (TwitterStats item in arrTwtStats)
{
NewTweet_Count += item.FollowerCount;
}
if (NewTweet_Count >= 100000)
{
TotalFollower = (System.Math.Round(((float)NewTweet_Count / 1000000), 2)) + "M";
}
else if (NewTweet_Count > 1000 && NewTweet_Count < 100000)
{
TotalFollower = (System.Math.Round(((float)NewTweet_Count / 1000), 2)) + "K";
}
else
{
TotalFollower = NewTweet_Count.ToString();
}
spanNewTweets.InnerHtml = TotalFollower;
}
catch (Exception Err)
{
Console.Write(Err.Message.ToString());
logger.Error(Err.StackTrace);
}
#endregion
#region GetFacebookFanPage
try
{
String FbProfileId = string.Empty;
FacebookStatsRepository objFacebookStatsRepository = new FacebookStatsRepository();
List <TeamMemberProfile> objTeamMemberProfile = objTeamMemberProfileRepository.getTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in objTeamMemberProfile)
{
FbProfileId += item.ProfileId + ',';
}
FbProfileId = FbProfileId.Substring(0, FbProfileId.Length - 1);
List <FacebookStats> arrFbStats = objFacebookStatsRepository.getAllAccountDetail(FbProfileId);
//strTwtArray = "[";
int NewFbFan_Count = 0;
string TotalFriends = string.Empty;
foreach (FacebookStats item in arrFbStats)
{
NewFbFan_Count += item.FanCount;
}
if (NewFbFan_Count >= 100000)
{
TotalFriends = (System.Math.Round(((float)NewFbFan_Count / 1000000), 2)) + "M";
}
else if (NewFbFan_Count > 1000 && NewFbFan_Count < 100000)
{
TotalFriends = (System.Math.Round(((float)NewFbFan_Count / 1000), 2)) + "K";
}
else
{
TotalFriends = NewFbFan_Count.ToString();
}
spanFbFans.InnerHtml = TotalFriends;
}
catch (Exception Err)
{
Console.Write(Err.Message.ToString());
logger.Error(Err.StackTrace);
}
#endregion
#region IncomingMessages
try
{
FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
int fbmessagescout = fbFeedRepo.countUnreadMessages(user.Id);
TwitterMessageRepository twtMsgRepo = new TwitterMessageRepository();
int twtcount = twtMsgRepo.getCountUnreadMessages(user.Id);
Session["CountMessages"] = fbmessagescout + twtcount;
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
#endregion
#region NewIncomingMessage
try
{
String FbProfileId = string.Empty;
String TwtProfileId = string.Empty;
List <TeamMemberProfile> objTeamMemberProfile = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile item in objTeamMemberProfile)
{
try
{
if (item.ProfileType == "facebook")
{
FbProfileId += item.ProfileId + ',';
}
else if (item.ProfileType == "twitter")
{
TwtProfileId += item.ProfileId + ',';
}
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
}
try
{
FbProfileId = FbProfileId.Substring(0, FbProfileId.Length - 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
try
{
TwtProfileId = TwtProfileId.Substring(0, TwtProfileId.Length - 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository();
List <FacebookFeed> alstfb = objFacebookFeedRepository.getAllFeedDetail(FbProfileId);
// FacebookMessageRepository objFacebookMessageRepository = new FacebookMessageRepository();
TwitterMessageRepository objtwttatsRepo = new TwitterMessageRepository();
// List<FacebookMessage> alstfb = objFacebookMessageRepository.getAllMessageDetail(FbProfileId);
List <TwitterMessage> alstTwt = objtwttatsRepo.getAlltwtMessages(TwtProfileId);
int TotalFbMsgCount = 0;
int TotalTwtMsgCount = 0;
try
{
TotalFbMsgCount = alstfb.Count;
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
try
{
TotalTwtMsgCount = alstTwt.Count;
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
spanIncoming.InnerHtml = (TotalFbMsgCount + TotalTwtMsgCount).ToString();
string profileid = string.Empty;
ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
foreach (TeamMemberProfile item in objTeamMemberProfile)
{
profileid += item.ProfileId + ',';
}
profileid = profileid.Substring(0, profileid.Length - 1);
spanSent.InnerHtml = objScheduledMessageRepository.getAllSentMessageDetails(profileid).Count().ToString();
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
logger.Error(Err.StackTrace);
}
}
#endregion
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
public string getFacebookpageFeeds(dynamic data, dynamic profile)
{
FacebookFeed fbfeed = new FacebookFeed();
User user = (User)HttpContext.Current.Session["LoggedUser"];
FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
string fanpost = string.Empty;
if (data != null)
{
foreach (var result in data["data"])
{
string message = string.Empty;
int likecount = 0;
int lstfbcount = 0;
int commentcount = 0;
int talking = 0;
string sharecount = string.Empty;
try
{
if (result["message"] != null)
{
message = result["message"];
try
{
if (result["likes"]["data"] != null)
{
foreach (var item in result["likes"]["data"])
{
if (item != null)
{
likecount++;
}
else
{
likecount = 0;
}
}
}
else
{
likecount = 0;
}
}
catch (Exception ex)
{
likecount = 0;
}
try
{
if (result["comments"]["data"] != null)
{
foreach (var item in result["comments"]["data"])
{
if (item != null)
{
commentcount++;
}
else
{
commentcount = 0;
}
}
}
else
{
commentcount = 0;
}
}
catch (Exception ex)
{
commentcount = 0;
}
try
{
if (result["shares"]["count"] != null)
{
sharecount = result["shares"]["count"].ToString();
}
else
{
sharecount = "0";
}
}
catch (Exception ex)
{
sharecount = "0";
}
// lstfbcount++;
}
fanpost = fanpost + "<div class=\"message-sent-table\" ><div class=\"labe-1\">" + message + "</div>" +
"<div class=\"labe-4\">" + talking + "</div><div class=\"labe-5\">" + likecount + "</div><div class=\"labe-6\">" + commentcount + "</div><div class=\"labe-5\">" + sharecount + "</div></div>";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
//fanpost = fanpost + "<div class=\"message-sent-table\" ><div class=\"labe-1\">" + message + "</div>" +
// "<div class=\"labe-4\">" + talking + "</div><div class=\"labe-5\">" + likecount + "</div><div class=\"labe-6\">" + commentcount + "</div><div class=\"labe-5\">" + sharecount + "</div></div>";
}
}
return(fanpost);
}
public string DeleteAllUsersByCreateDate(string date)
{
int i = 0;
int count = 0;
UserRepository objUserRepository = new UserRepository();
List <User> lstuser = objUserRepository.GetAllUsersByCreateDate(date);
ArchiveMessageRepository objArchiveMessageRepository = new ArchiveMessageRepository();
DiscoverySearchRepository objDiscoverySearchRepository = new DiscoverySearchRepository();
DraftsRepository objDraftsRepository = new DraftsRepository();
FacebookAccountRepository objFacebookAccountRepository = new FacebookAccountRepository();
FacebookFeedRepository objFacebookFeedRepository = new FacebookFeedRepository();
FacebookInsightPostStatsRepository objFacebookInsightPostStatsRepository = new FacebookInsightPostStatsRepository();
FacebookInsightStatsRepository objFacebookInsightStatsRepository = new FacebookInsightStatsRepository();
FacebookMessageRepository objFacebookMessageRepository = new FacebookMessageRepository();
FacebookStatsRepository objFacebookStatsRepository = new FacebookStatsRepository();
GoogleAnalyticsAccountRepository objGoogleAnalyticsAccountRepository = new GoogleAnalyticsAccountRepository();
GoogleAnalyticsStatsRepository objGoogleAnalyticsStatsRepository = new GoogleAnalyticsStatsRepository();
GooglePlusAccountRepository objGooglePlusAccountRepository = new GooglePlusAccountRepository();
GooglePlusActivitiesRepository objGooglePlusActivitiesRepository = new GooglePlusActivitiesRepository();
GroupProfileRepository objGroupProfileRepository = new GroupProfileRepository();
GroupRepository objGroupRepository = new GroupRepository();
InstagramAccountRepository objInstagramAccountRepository = new InstagramAccountRepository();
InstagramCommentRepository objInstagramCommentRepository = new InstagramCommentRepository();
InstagramFeedRepository objInstagramFeedRepository = new InstagramFeedRepository();
LinkedInAccountRepository objLinkedInAccountRepository = new LinkedInAccountRepository();
LinkedInFeedRepository objLinkedInFeedRepository = new LinkedInFeedRepository();
LogRepository objLogRepository = new LogRepository();
RssFeedsRepository objRssFeedsRepository = new RssFeedsRepository();
RssReaderRepository objRssReaderRepository = new RssReaderRepository();
ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
SocialProfilesRepository objSocialProfilesRepository = new SocialProfilesRepository();
TaskCommentRepository objTaskCommentRepository = new TaskCommentRepository();
TaskRepository objTaskRepository = new TaskRepository();
TeamRepository objTeamRepository = new TeamRepository();
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
TwitterAccountRepository objTwitterAccountRepository = new TwitterAccountRepository();
TwitterDirectMessageRepository objTwitterDirectMessageRepository = new TwitterDirectMessageRepository();
TwitterFeedRepository objTwitterFeedRepository = new TwitterFeedRepository();
TwitterMessageRepository objTwitterMessageRepository = new TwitterMessageRepository();
TwitterStatsRepository objTwitterStatsRepository = new TwitterStatsRepository();
UserActivationRepository objUserActivationRepository = new UserActivationRepository();
UserPackageRelationRepository objUserPackageRelationRepository = new UserPackageRelationRepository();
count = lstuser.Count();
foreach (var item in lstuser)
{
i++;
try
{
if (item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**" || item.EmailId == "*****@*****.**")
{
}
else
{
objArchiveMessageRepository.DeleteArchiveMessageByUserid(item.Id);
objDiscoverySearchRepository.DeleteDiscoverySearchByUserid(item.Id);
objDraftsRepository.DeleteDraftsByUserid(item.Id);
objFacebookAccountRepository.DeleteFacebookAccountByUserid(item.Id);
objFacebookFeedRepository.DeleteFacebookFeedByUserid(item.Id);
objFacebookInsightPostStatsRepository.DeleteFacebookInsightPostStatsByUserid(item.Id);
objFacebookInsightStatsRepository.DeleteFacebookInsightStatsByUserid(item.Id);
objFacebookMessageRepository.DeleteFacebookMessageByUserid(item.Id);
objFacebookStatsRepository.DeleteFacebookStatsByUserid(item.Id);
objGoogleAnalyticsAccountRepository.DeleteGoogleAnalyticsAccountByUserid(item.Id);
objGoogleAnalyticsStatsRepository.DeleteGoogleAnalyticsStatsByUserid(item.Id);
objGooglePlusAccountRepository.DeleteGooglePlusAccountByUserid(item.Id);
objGooglePlusActivitiesRepository.DeleteGooglePlusActivitiesByUserid(item.Id);
objGroupProfileRepository.DeleteGroupProfileByUserid(item.Id);
objGroupRepository.DeleteGroupsByUserid(item.Id);
objInstagramAccountRepository.DeleteInstagramAccountByUserid(item.Id);
objInstagramCommentRepository.DeleteInstagramCommentByUserid(item.Id);
objInstagramFeedRepository.DeleteInstagramFeedByUserid(item.Id);
objLinkedInAccountRepository.DeleteLinkedInAccountByUserid(item.Id);
objLinkedInFeedRepository.DeleteLinkedInFeedByUserid(item.Id);
objLogRepository.DeleteLogByUserid(item.Id);
objRssFeedsRepository.DeleteRssFeedsByUserid(item.Id);
objRssReaderRepository.DeleteRssReaderByUserid(item.Id);
objScheduledMessageRepository.DeleteScheduledMessageByUserid(item.Id);
objSocialProfilesRepository.DeleteSocialProfileByUserid(item.Id);
objTaskCommentRepository.DeleteTaskCommentByUserid(item.Id);
objTaskRepository.DeleteTasksByUserid(item.Id);
objTeamRepository.DeleteTeamByUserid(item.Id);
objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(item.Id);
objTwitterAccountRepository.DeleteTwitterAccountByUserid(item.Id);
objTwitterDirectMessageRepository.DeleteTwitterDirectMessagesByUserid(item.Id);
objTwitterFeedRepository.DeleteTwitterFeedByUserid(item.Id);
objTwitterMessageRepository.DeleteTwitterMessageByUserid(item.Id);
objTwitterStatsRepository.DeleteTwitterStatsByUserid(item.Id);
objUserActivationRepository.DeleteUserActivationByUserid(item.Id);
objUserPackageRelationRepository.DeleteuserPackageRelationByUserid(item.Id);
objUserRepository.DeleteUserByUserid(item.Id);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
return(i + " " + count);
}
protected void Page_Load(object sender, EventArgs e)
{
User user = (User)Session["LoggedUser"];
try
{
#region for You can use only 30 days as Unpaid User
//SocioBoard.Domain.User user = (User)Session["LoggedUser"];
if (user.PaymentStatus.ToLower() == "unpaid")
{
if (!SBUtils.IsUserWorkingDaysValid(user.ExpiryDate))
{
// ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('You can use only 30 days as Unpaid User !');", true);
Session["GreaterThan30Days"] = "GreaterThan30Days";
Response.Redirect("../Settings/Billing.aspx");
}
}
#endregion
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
if (!IsPostBack)
{
if (user == null)
{
Response.Redirect("/Default.aspx");
}
try
{
getgrphData(7);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
getNewFriends(7);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
getNewFollowers(7);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
GetFollowersAgeWise(7);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
getFollowFollowersMonth();
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
ArrayList arrfbProfile = fbAccRepo.getAllFacebookPagesOfUser(user.Id);
long talking = 0;
foreach (FacebookAccount item in arrfbProfile)
{
FacebookClient fb = new FacebookClient();
fb.AccessToken = item.AccessToken;
pagelikes = pagelikes + fbFeedRepo.countInteractions(item.UserId, item.FbUserId, 7);
dynamic talkingabout = fb.Get(item.FbUserId);
talking = talking + talkingabout.talking_about_count;
// strinteractions = pagelikes.Count(); //(long.Parse(strinteractions) + pagelikes.talking_about_count).ToString();
}
talkingabtcount = (talking / 100) * arrfbProfile.Count;
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
SocialProfilesRepository objsocioRepo = new SocialProfilesRepository();
profileCount = objsocioRepo.getAllSocialProfilesOfUser(user.Id).Count();
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
var strgenderTwt = Session["twtGender"].ToString().Split(',');
divtwtMale.InnerHtml = strgenderTwt[0] + "%";
divtwtfeMale.InnerHtml = strgenderTwt[1] + "%";
}
}
public List<FacebookFeed> getFacebookFeedsOfUser(Guid userid, string profileid)
{
FacebookFeedRepository facefeedrepo = new FacebookFeedRepository();
List<FacebookFeed> lstfacefeed = facefeedrepo.getAllFacebookFeedsOfUser(userid, profileid);
return lstfacefeed;
}
// Saving FacebookFeeds of user into database i.e. FacebookFeed Table
public void getFacebookUserFeeds(dynamic data, dynamic profile)
{
FacebookFeed fbfeed = new FacebookFeed();
User user = (User)HttpContext.Current.Session["LoggedUser"];
FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
if (data != null)
{
foreach (var result in data["data"])
{
fbfeed.Type = "fb_feed";
try
{
fbfeed.UserId = user.Id;
}
catch (Exception ex)
{ Console.WriteLine(ex.StackTrace); }
try
{
fbfeed.ProfileId = profile["id"].ToString();
}
catch (Exception ex)
{ Console.WriteLine(ex.StackTrace); }
try
{
fbfeed.Id = Guid.NewGuid();
}
catch (Exception ex)
{ Console.WriteLine(ex.StackTrace); }
fbfeed.FromProfileUrl = "http://graph.facebook.com/" + result["from"]["id"] + "/picture?type=small";
fbfeed.FromName = result["from"]["name"].ToString();
fbfeed.FromId = result["from"]["id"].ToString();
fbfeed.FeedId = result["id"].ToString();
fbfeed.FeedDate = DateTime.Parse(result["created_time"].ToString());
fbfeed.FbComment = "http://graph.facebook.com/" + result["id"] + "/comments";
fbfeed.FbLike = "http://graph.facebook.com/" + result["id"] + "/likes";
string message = string.Empty;
int lstfbcount = 0;
if (lstfbcount < 25)
{
try
{
if (result["message"] != null)
{
message = result["message"];
lstfbcount++;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
try
{
if (result["description"] != null)
{
message = result["description"];
lstfbcount++;
}
}
catch (Exception exx)
{
try
{
Console.WriteLine(exx.StackTrace);
if (result["story"] != null)
{
message = result["story"];
lstfbcount++;
}
}
catch (Exception exxx)
{
Console.WriteLine(exxx.StackTrace);
message = string.Empty;
}
}
}
}
fbfeed.FeedDescription = message;
fbfeed.EntryDate = DateTime.Now;
if (!fbfeedrepo.checkFacebookFeedExists(fbfeed.FeedId))
{
fbfeedrepo.addFacebookFeed(fbfeed);
}
}
}
}