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;
}
void ProcessRequest()
{
User user = (User)Session["LoggedUser"];
if (Request.QueryString["op"] != null)
{
if (Request.QueryString["op"] == "bindMessages")
{
DataSet ds = null;
if (Session["MessageDataTable"] == null)
{
clsFeedsAndMessages clsfeedsandmess = new clsFeedsAndMessages();
ds = clsfeedsandmess.bindMessagesIntoDataTable(user);
FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
Session["MessageDataTable"] = ds;
}
else
{
ds = (DataSet)Session["MessageDataTable"];
}
string message = "There is no message !";
if (ds.Tables[0].Rows.Count > 0)
{
message = this.BindData(ds.Tables[0]);
}
Response.Write(message);
}
else if (Request.QueryString["op"] == "inbox_messages")
{
DataSet ds = null;
if (Session["InboxMessages"] == null)
{
clsFeedsAndMessages clsfeedsandmessages = new clsFeedsAndMessages();
ds = clsfeedsandmessages.bindSentMessagesToDataTable(user, "");
Session["InboxMessages"] = ds;
}
else
{
ds = (DataSet)Session["InboxMessages"];
}
string message = "There is no message !";
if (ds.Tables[0].Rows.Count > 0)
{
message = this.BindData(ds.Tables[0]);
}
Response.Write(message);
}
else if (Request.QueryString["op"] == "bindProfiles")
{
string profiles = string.Empty;
int i = 0;
profiles += "<ul class=\"options_list\">";
/*Binding facebook profiles in Accordian*/
FacebookAccountRepository facerepo = new FacebookAccountRepository();
ArrayList alstfacebookprofiles = facerepo.getOnlyFacebookAccountsOfUser(user.Id);
foreach (FacebookAccount item in alstfacebookprofiles)
{
try
{
profiles += "<ul><li><a id=\"checkimg_" + i + "\" href=\"#\" onclick=\"checkprofile('" + item.FbUserId + "','message','facebook');\"><img src=\"../Contents/img/admin/fbicon.png\" width=\"15\" height=\"15\" alt=\"\" >" + item.FbUserName + "</a></li>";
i++;
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
/*Binding TwitterProfiles in Accordian*/
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
ArrayList alsttwt = twtaccountrepo.getAllTwitterAccountsOfUser(user.Id);
foreach (TwitterAccount item in alsttwt)
{
try
{
profiles += "<ul><li><a href=\"#\" id=\"checkimg_" + i + "\" onclick=\"checkprofile('" + item.TwitterUserId + "','message','twitter');\"><img src=\"../Contents/img/admin/twittericon.png\" width=\"15\" height=\"15\" alt=\"\" >" + item.TwitterScreenName + "</a></li>";
i++;
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
GooglePlusAccountRepository gpAccRepo = new GooglePlusAccountRepository();
ArrayList alstgp = gpAccRepo.getAllGooglePlusAccountsOfUser(user.Id);
foreach (GooglePlusAccount item in alstgp)
{
try
{
profiles += "<ul><li><a href=\"#\" id=\"checkimg_" + i + "\" onclick=\"checkprofile('" + item.GpUserId + "','message','googleplus');\"><img src=\"../Contents/img/google_plus.png\" width=\"15\" height=\"15\" alt=\"\" >" + item.GpUserName + "</a></li>";
i++;
}
catch (Exception esx)
{
logger.Error(esx.Message);
Console.WriteLine(esx.Message);
}
}
profiles += "</ul><input type=\"hidden\" id=\"profilecounter\" value=\"" + i + "\">";
Response.Write(profiles);
}
else if (Request.QueryString["op"] == "changeTaskStatus")
{
Guid taskid = Guid.Parse(Request.QueryString["taskid"]);
bool status = bool.Parse(Request.QueryString["status"]);
if (status == true)
status = false;
else
status = true;
TaskRepository objTaskRepo = new TaskRepository();
objTaskRepo.updateTaskStatus(taskid, user.Id, status);
}
else if (Request.QueryString["op"] == "savetask")
{
string descritption = Request.QueryString["description"];
Guid idtoassign = Guid.Empty;
try
{
if (Request.QueryString["memberid"] != string.Empty)
{
idtoassign = Guid.Parse(Request.QueryString["memberid"].ToString());
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
// idtoassign = 0;
}
Tasks objTask = new Tasks();
TaskRepository objTaskRepo = new TaskRepository();
objTask.AssignDate = DateTime.Now.ToString("yyyy-MM-dd H:mm:ss").ToString();
objTask.AssignTaskTo = idtoassign;
objTask.TaskStatus = false;
objTask.TaskMessage = descritption;
objTask.UserId = user.Id;
Guid taskid = Guid.NewGuid();
objTask.Id = taskid;
objTaskRepo.addTask(objTask);
/////////////////
string comment = Request.QueryString["comment"];
if (!string.IsNullOrEmpty(comment))
{
string curdate = DateTime.Now.ToString("yyyy-MM-dd H:mm:ss").ToString();
TaskComment objcmt = new TaskComment();
TaskCommentRepository objcmtRepo = new TaskCommentRepository();
objcmt.Comment = comment;
objcmt.CommentDate = DateTime.Now;
objcmt.EntryDate = DateTime.Now;
objcmt.Id = Guid.NewGuid();
objcmt.TaskId = objTask.Id;
objcmt.UserId = user.Id;
objcmtRepo.addTaskComment(objcmt);
}
}
else if (Request.QueryString["op"] == "bindteam")
{
TeamRepository objTeam = new TeamRepository();
string message = string.Empty;
message += "<ul>";
IEnumerable<dynamic> result = objTeam.getAllTeamsOfUser(user.Id);
if (result != null)
{
foreach (Team item in result)
{
message += "<li><a>";
message += "<img src=\"../Contents/img/blank_img.png\" alt=\"\" />";
message += "<span class=\"name\">" +
item.FirstName + " " + item.LastName +
"</span>" +
" <span>" +
"<input id=\"customerid_" + item.Id + "\" type=\"radio\" name=\"team_members\" value=\"customerid_" + item.Id + "\">" +
"</span>" +
"</a></li>";
}
message += "<li><a>";
if (string.IsNullOrEmpty(user.ProfileUrl))
{
message += "<img src=\"../Contents/img/blank_img.png\" alt=\"\" />";
}
else
{
message += "<img src=\"" + user.ProfileUrl + "\" alt=\"\" />";
}
message += "<span class=\"name\">" +
user.UserName +
"</span>" +
" <span>" +
"<input id=\"customerid_" + user.Id + "\" type=\"radio\" name=\"team_members\" value=\"customerid_" + user.Id + "\">" +
"</span></a></li>";
}
else
{
message += "<li><a>";
if (string.IsNullOrEmpty(user.ProfileUrl))
{
message += "<img src=\"../Contents/img/blank_img.png\" alt=\"\" />";
}
else
{
message += "<img src=\"" + user.ProfileUrl + "\" alt=\"\" />";
}
message += "<span class=\"name\">" +
user.UserName +
"</span>" +
" <span>" +
"<input id=\"customerid_" + user.Id + "\" type=\"radio\" name=\"team_members\" value=\"customerid_" + user.Id + "\">" +
"</span>" +
"</a></li>";
}
message += "</ul>";
Response.Write(message);
}
else if (Request.QueryString["op"] == "bindarchive")
{
ArchiveMessageRepository objArchiveRepo = new ArchiveMessageRepository();
string message = string.Empty;
message += "<ul id=\"message-list\">";
List<ArchiveMessage> result = objArchiveRepo.getAllArchiveMessage(user.Id);
int sorteddatacount = 0;
if (result != null)
{
foreach (ArchiveMessage item in result)
{
message += "<li>";
sorteddatacount++;
if (item.SocialGroup == "twitter")
{
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:auto;float:left\"><img id=\"formprofileurl_" + sorteddatacount + "\" onclick=\"detailsprofile(this.alt);\" src=\"" + item.ImgUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/twticon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div>" +
"</div><div id=\"messagedescription_" + sorteddatacount + "\" class=\"message-list-content\"><div id=\"msgdescription_" + sorteddatacount + "\" style=\"width:500px;height:auto;float:left\"><p>" + item.Message + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"#\" id=\"rowname_" + sorteddatacount + "\" onclick=\"detailsprofile(" + item.ProfileId + ");\">" + item.ProfileId + "</a> " + item.CreatedDateTime + "</span>" +
"<div class=\"scl\">" +
"<a id=\"createtasktwt_" + sorteddatacount + "\" href=\"#\" onclick=\"createtask(this.id);\"><img src= title=\"Task\" \"../Contents/img/pin.png\" alt=\"\" width=\"14\" height=\"17\" border=\"none\"></a><a href=\"#\"><img title=\"comment\" src=\"../Contents/img/admin/goto.png\" width=\"12\" height=\"12\" alt=\"\"/></a></div></div></div></div></li>";
}
else if (item.SocialGroup == "facebook")
{
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:auto;float:left\"><img id=\"formprofileurl_" + sorteddatacount + "\" onclick=\"detailsprofile(this.alt);\" src=\"" + item.ImgUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/fb_icon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div>" +
"</div><div id=\"messagedescription_" + sorteddatacount + "\" class=\"message-list-content\"><div id=\"msgdescription_" + sorteddatacount + "\" style=\"width:500px;height:auto;float:left\"><p>" + item.Message + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"#\" id=\"rowname_" + sorteddatacount + "\" onclick=\"getFacebookProfiles(" + item.ProfileId + ");\">" + item.ProfileId + "</a> " + item.CreatedDateTime + "</span>" +
"<div class=\"scl\">" +
"<a id=\"createtasktwt_" + sorteddatacount + "\" href=\"#\" onclick=\"createtask(this.id);\"><img title=\"Task\" src=\"../Contents/img/pin.png\" alt=\"\" width=\"14\" height=\"17\" border=\"none\"></a><a href=\"#\"><img title=\"comment\" src=\"../Contents/img/admin/goto.png\" width=\"12\" height=\"12\" alt=\"\"/></a></div></div></div></div></li>";
}
else if (item.SocialGroup == "googleplus")
{
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:auto;float:left\"><img id=\"formprofileurl_" + sorteddatacount + "\" onclick=\"detailsprofile(this.alt);\" src=\"" + item.ImgUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/google_plus.png\" width=\"16\" height=\"16\" alt=\"\"></a></div>" +
"</div><div id=\"messagedescription_" + sorteddatacount + "\" class=\"message-list-content\"><div id=\"msgdescription_" + sorteddatacount + "\" style=\"width:500px;height:auto;float:left\"><p>" + item.Message + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"#\" id=\"rowname_" + sorteddatacount + "\" onclick=\"detailsprofile(" + item.ProfileId + ");\">" + item.ProfileId + "</a> " + item.CreatedDateTime + "</span>" +
"<div class=\"scl\">" +
"<a id=\"createtasktwt_" + sorteddatacount + "\" href=\"#\" onclick=\"createtask(this.id);\"><img title=\"Task\" src=\"../Contents/img/pin.png\" alt=\"\" width=\"14\" height=\"17\" border=\"none\"></a></div></div></div></div></li>";
}
message += "</li>";
}
}
message += "</ul>";
Response.Write(message);
}
else if (Request.QueryString["op"] == "savearchivemsg")
{
User use = (User)Session["LoggedUser"];
ArchiveMessage am = new ArchiveMessage();
ArchiveMessageRepository objArchiveRepo = new ArchiveMessageRepository();
am.UserId = user.Id;
am.ImgUrl = Request.QueryString["imgurl"];
//am.user_name = Request.QueryString["UserName"];
//am.msg = Request.QueryString["Msg"];
////am.sociel_group = Request.QueryString["Network"];
//am.createdtime = Request.QueryString["CreatedTime"];
System.IO.StreamReader sr = new System.IO.StreamReader(Request.InputStream);
string line = "";
line = sr.ReadToEnd();
// JObject jo = JObject.Parse("[" + line + "]");
// am.UserName = Request.QueryString["UserName"];//Server.UrlDecode((string)jo["UserName"]);
//am.Message = Request.QueryString["Msg"];//Server.UrlDecode((string)jo["Msg"]);
JObject jo = JObject.Parse(line);
am.Message = Server.UrlDecode((string)jo["Msg"]); ;//Server.UrlDecode((string)jo["Msg"]);
am.SocialGroup = Request.QueryString["Network"];// Server.UrlDecode((string)jo["Network"]);
am.CreatedDateTime = Request.QueryString["CreatedTime"];
am.MessageId = Request.QueryString["MessageId"];
am.ProfileId = Request.QueryString["ProfileId"];
am.UserId = use.Id;
// Server.UrlDecode((string)jo["CreatedTime"]);
if (am.UserName != string.Empty)
{
if (!objArchiveRepo.checkArchiveMessageExists(user.Id, am.MessageId))
{
objArchiveRepo.AddArchiveMessage(am);
}
}
}
else if (Request.QueryString["op"] == "createfacebookcomments")
{
FacebookAccountRepository facerepo = new FacebookAccountRepository();
string postid = Request.QueryString["replyid"];
string message = Request.QueryString["replytext"];
string userid = Request.QueryString["userid"];
FacebookAccount result = facerepo.getFacebookAccountDetailsById(userid, user.Id);
FacebookClient fc = new FacebookClient(result.AccessToken);
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("message", message);
JsonObject dyn = (JsonObject)fc.Post("/" + postid+ "/comments", parameters);
}
else if (Request.QueryString["op"] == "getFacebookComments")
{
FacebookAccountRepository facerepo = new FacebookAccountRepository();
string postid = Request.QueryString["postid"];
string userid = Request.QueryString["userid"];
FacebookAccount result = facerepo.getFacebookAccountDetailsById(userid, user.Id);
FacebookClient fc = new FacebookClient(result.AccessToken);
JsonObject dyn = (JsonObject)fc.Get("/" + postid + "/comments");
string mess = string.Empty;
dynamic jc = dyn["data"];
int iii = 0;
foreach (dynamic item in jc)
{
mess += "<div class=\"messages\"><section><aside><section class=\"js-avatar_tip\" data-sstip_class=\"twt_avatar_tip\">" +
"<a class=\"avatar_link view_profile\">" +
"<img width=\"54\" height=\"54\" border=\"0\" id=\"" + item["id"] + "\" class=\"avatar\" src=\"http://graph.facebook.com/" + item["from"]["id"] + "/picture?type=small\"><article class=\"message-type-icon\"></article>" +
"</a></section><ul></ul></aside><article><div class=\"\"><a class=\"language\" href=\"\"></a></div>" +
"<div class=\"message_actions\"><a class=\"gear_small\" href=\"#\"><span title=\"Options\" class=\"ficon\">?</span></a></div><div id=\"messagedescription_" + iii + "\" class=\"message-text font-14\">" + item["message"] + "</div><section class=\"bubble-meta\"><article class=\"threefourth text-overflow\"><section class=\"floatleft\"><a class=\"js-avatar_tip view_profile profile_link\" data-sstip_class=\"twt_avatar_tip\"><span id=\"rowname_" + iii + "\">" + item["from"]["name"] + "</span></a> <a data-msg-time=\"1363926699000\" class=\"time\" target=\"_blank\" title=\"View message on Twitter\">" + item["created_time"] + "</a><span class=\"location\"> </span></section></article><ul class=\"message-buttons quarter clearfix\"></ul></section></article></section></div>";
}
Response.Write(mess);
}
else if (Request.QueryString["op"] == "twittercomments")
{
Tweet objTwitterMethod = new Tweet();
TwitterAccountRepository objTwtAccRepo = new TwitterAccountRepository();
try
{
string messid = Request.QueryString["messid"];
string replytext = Request.QueryString["replytext"];
string replyid = Request.QueryString["replyid"];
string userid = Request.QueryString["userid"];
string username = Request.QueryString["username"];
string rowid = Request.QueryString["rowid"];
TwitterAccount objTwtAcc = objTwtAccRepo.getUserInformation(user.Id, userid);
TwitterHelper twthelper = new TwitterHelper();
oAuthTwitter OAuthTwt = new oAuthTwitter();
OAuthTwt.AccessToken = objTwtAcc.OAuthToken;
OAuthTwt.AccessTokenSecret = objTwtAcc.OAuthSecret;
OAuthTwt.TwitterScreenName = objTwtAcc.TwitterScreenName;
twthelper.SetCofigDetailsForTwitter(OAuthTwt);
Tweet twt = new Tweet();
JArray post = twt.Post_Statuses_Update(OAuthTwt, replytext);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (Request.QueryString["op"] == "gpProfile")
{
GooglePlusAccountRepository objgpAccRepo = new GooglePlusAccountRepository();
GooglePlusAccount objGpAcc = objgpAccRepo.getGooglePlusAccountDetailsById(Request.QueryString["gpid"].ToString(), user.Id);
PeopleController obj = new PeopleController();
oAuthToken objgpToken = new oAuthToken();
JArray objProfile = null;
try
{
string strAccess = objgpToken.GetAccessToken(objGpAcc.RefreshToken);
if (!strAccess.StartsWith("["))
strAccess = "[" + strAccess + "]";
JArray objArray = JArray.Parse(strAccess);
foreach (var itemgp in objArray)
{
objGpAcc.AccessToken = itemgp["access_token"].ToString();
}
objProfile = obj.GetPeopleProfile(Request.QueryString["gpid"].ToString(), objGpAcc.AccessToken);
}
catch (Exception Err)
{
logger.Error(Err.Message);
Console.Write(Err.Message.ToString());
}
string jas = string.Empty;
foreach (var item in objProfile)
{
jas += "<div class=\"modal-small draggable\">";
jas += "<div class=\"modal-content\">";
jas += "<button type=\"button\" class=\"modal-btn button b-close\">";
jas += "<span class=\"icon close-medium\"><span class=\"visuallyhidden\">X</span></span></button>";
jas += "<div class=\"modal-header\"><h3 class=\"modal-title\">Profile summary</h3></div>";
jas += "<div class=\"modal-body profile-modal\">";
jas += "<div class=\"module profile-card component profile-header\">";
jas += "<div style=\"background-image: url('https://pbs.twimg.com/profile_banners/215936249/1371721359');\" class=\"profile-header-inner flex-module clearfix\">";
jas += "<div class=\"profile-header-inner-overlay\"></div>";
jas += "<a href=\"#\" class=\"profile-picture media-thumbnail js-nav\">";
string[] imgurl = item["image"]["url"].ToString().Split('?');
jas += "<img src=\"" + imgurl[0] + " alt=\"" + item["name"]["givenName"] + "\" class=\"avatar size73\"></a>";
jas += "<div class=\"profile-card-inner\">";
jas += "<h1 class=\"fullname editable-group\">";
jas += "<a class=\"js-nav\" href=\"#\">" + item["name"]["givenName"] + "</a>";
jas += "<a href=\"#\" class=\"verified-link js-tooltip\">";
jas += "<span class=\"icon verified verified-large-border\">";
jas += "<span class=\"visuallyhidden\"></span></span></a></h1>";
jas += "<h2 class=\"username\">";
jas += "<a class=\"pretty-link js-nav\" href=\"#\">";
jas += "<span class=\"screen-name\"><s></s>" + item["displayName"] + "</span></a></h2>";
jas += "<div class=\"bio-container editable-group\"><p class=\"bio profile-field\"></p></div>";
jas += "<p class=\"location-and-url\">";
jas += "<span class=\"location-container editable-group\">";
jas += "<span class=\"location profile-field\"></span></span>";
jas += "<span class=\"divider hidden\"></span> ";
jas += "<span class=\"url editable-group\"> ";
jas += "<span class=\"profile-field\">";
jas += "<a target=\"_blank\" rel=\"me nofollow\" href=\"" + item["url"] + "\" title=\"#\">" + item["url"] + " </a></span></span></p>";
jas += "<div style=\"cursor: pointer; width: 16px; height: 16px; display: inline-block;\"> </div><p></p></div></div>";
jas += "<div class=\"clearfix\"><div class=\"default-footer\">";
jas += "<div class=\"btn-group\"><div class=\"follow_button\"></div></div></div></div>";
jas += "<div class=\"profile-social-proof\">";
jas += "<div class=\"follow-bar\"></div></div></div>";
jas += "<ol class=\"recent-tweets\"><li class=\"\"><div><i class=\"dogear\"></i></div></li></ol>";
jas += "<div class=\"go_to_profile\">";
jas += "<small><a class=\"view_profile\" target=\"_blank\" href=\""+ item["url"] +"\">Go to full profile →</a></small></div></div>";
jas += "<div class=\"loading\"><span class=\"spinner-bigger\"></span></div></div></div>";
}
Response.Write(jas);
}
else if (Request.QueryString["op"] == "updatedstatus")
{
try
{
TwitterMessageRepository twtmsgRepo = new TwitterMessageRepository();
int i = twtmsgRepo.updateMessageStatus(user.Id);
FacebookFeedRepository fbfeedRepo = new FacebookFeedRepository();
int j = fbfeedRepo.updateMessageStatus(user.Id);
if (i > 0 || j > 0)
{
Session["CountMessages"] = 0;
Session["MessageDataTable"] = null;
DataSet ds = null;
if (Session["MessageDataTable"] == null)
{
clsFeedsAndMessages clsfeedsandmess = new clsFeedsAndMessages();
ds = clsfeedsandmess.bindMessagesIntoDataTable(user);
FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
Session["MessageDataTable"] = ds;
}
else
{
ds = (DataSet)Session["MessageDataTable"];
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
}
}
public void ProcessRequest()
{
//experimental code selected index changed of dropdown
if (!string.IsNullOrEmpty(Request.QueryString["groupsselection"]))
{
SocioBoard.Domain.User user = (SocioBoard.Domain.User)Session["LoggedUser"];
string selectedValue = Request.QueryString["groupsselection"];
TeamRepository objTeamRepository = new TeamRepository();
Team lstDetails = objTeamRepository.getAllGroupsDetails(user.EmailId.ToString(), Guid.Parse(selectedValue),user.Id);
Session["GroupName"] = lstDetails;
Session["groupcheck"] = selectedValue;
SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)Session["GroupName"];
Response.Write(selectedValue);
return;
}
SocialProfilesRepository socio = new SocialProfilesRepository();
List<SocialProfile> alstsocioprofiles = new List<SocialProfile>();
TeamRepository objTeamRepo = new TeamRepository();
if (!string.IsNullOrEmpty(Request.QueryString["op"]))
{
SocioBoard.Domain.User user = (SocioBoard.Domain.User)Session["LoggedUser"];
Team team = (SocioBoard.Domain.Team)Session["GroupName"];
TeamRepository objTeamRepository = new TeamRepository();
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
GroupRepository objGroupRepository = new GroupRepository();
if (Request.QueryString["op"] == "social_connectivity")
{
List<TeamMemberProfile> allprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
string profiles = string.Empty;
profiles += "<ul class=\"rsidebar-profile\">";
foreach (TeamMemberProfile item in allprofiles)
{
try
{
if (item.ProfileType == "facebook")
{
try
{
FacebookAccountRepository facerepo = new FacebookAccountRepository();
FacebookAccount faceaccount = facerepo.getFacebookAccountDetailsById(item.ProfileId);
if (faceaccount != null)
{
profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onclick=\"confirmDel('" + item.ProfileId + "','" + faceaccount.Type + "','fb');\"></div><a href=\"http://www.facebook.com/" + faceaccount.FbUserId + "\" target=\"_blank\"><img src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\" height=\"48\" width=\"48\" alt=\"\" title=\""+ faceaccount.FbUserName + "\" /></a>" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/fb_icon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "youtube")
{
try
{
YoutubeAccountRepository facerepo = new YoutubeAccountRepository();
YoutubeAccount youtube = facerepo.getYoutubeAccountDetailsById(item.ProfileId);
if (youtube != null)
{
profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onclick=\"confirmDel('" + item.ProfileId + "','youtube','youtube');\"></div><a href=\"https://plus.google.com/" + youtube.Ytuserid + "\" target=\"_blank\"><img src=\"" + youtube.Ytprofileimage + " height=\"48\" width=\"48\" alt=\"\" title=\"" + youtube.Ytusername + "\" /></a>" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/youtube.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "tumblr")
{
try
{
TumblrAccountRepository tumbrepo = new TumblrAccountRepository();
TumblrAccount tumblraccount = tumbrepo.getTumblrAccountDetailsById(item.ProfileId);
if (tumblraccount != null)
{
//if (tumblraccount!=null)
//{
// profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','tumblr','tumblr')\"></div><a href=\"http://twitter.com/" + tumblraccount.tblrUserName + "\" target=\"_blank\"><img src=\"http://api.tumblr.com/v2/blog/" + tumblraccount.tblrUserName + ".tumblr.com/avatar\" height=\"48\" width=\"48\" alt=\"\" title=\"" + tumblraccount.tblrUserName + "\" /></a>" +
// "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/tumblr.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
//}
//else
//{
profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','tumblr','tumblr')\"></div><a href=\"http://" + tumblraccount.tblrUserName + ".tumblr.com\" target=\"_blank\"><img src=\"http://api.tumblr.com/v2/blog/" + tumblraccount.tblrUserName + ".tumblr.com/avatar\" height=\"48\" width=\"48\" alt=\"\" title=\"" + tumblraccount.tblrUserName + "\" /></a>" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/tumblr.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
// }
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "twitter")
{
try
{
TwitterAccountRepository twtrepo = new TwitterAccountRepository();
SocioBoard.Domain.TwitterAccount twtaccount = twtrepo.getUserInformation(item.ProfileId);
if (twtaccount != null)
{
profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','twt','twt')\"></div><a href=\"http://twitter.com/" + twtaccount.TwitterScreenName + "\" target=\"_blank\"><img src=\"" + twtaccount.ProfileImageUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + twtaccount.TwitterScreenName + "\" /></a>" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/twticon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "linkedin")
{
try
{
LinkedInAccountRepository liRepo = new LinkedInAccountRepository();
string access = string.Empty, tokenSecrate = string.Empty, LdprofileName = string.Empty, LdPreofilePic = string.Empty;
LinkedInAccount liaccount = liRepo.getUserInformation(item.ProfileId);
if (liaccount != null)
{
if (!string.IsNullOrEmpty(liaccount.ProfileImageUrl))
{
LdPreofilePic = liaccount.ProfileImageUrl;
}
else
{
LdPreofilePic = "../../Contents/img/blank_img.png";
}
profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','linkedin')\"></div><a href=\"" + liaccount.ProfileUrl + "\" target=\"_blank\"><img src=\"" + LdPreofilePic + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + liaccount.LinkedinUserName + "\" /></a>" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/link_icon.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "instagram")
{
try
{
InstagramAccountRepository objInsAccRepo = new InstagramAccountRepository();
InstagramAccount objInsAcc = objInsAccRepo.getInstagramAccountDetailsById(item.ProfileId);
string accessToken = string.Empty;
if (objInsAcc != null)
{
profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','instagram')\"></div><a href=\"http://instagram.com/" + objInsAcc.InsUserName + "\" target=\"_blank\"><img src=\"" + objInsAcc.ProfileUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + objInsAcc.InsUserName + "\" /></a>" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/instagram_24X24.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "googleplus")
{
try
{
//GooglePlusAccountRepository objgpAccRepo = new GooglePlusAccountRepository();
//GooglePlusAccount objgpAcc = objgpAccRepo.getGooglePlusAccountDetailsById(item.ProfileId, user.Id);
//string accessToken = string.Empty;
//profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','googleplus')\"></div><a href=\"http://plus.google.com/" + item.ProfileId + "\" target=\"_blank\"><img src=\"" + objgpAcc.GpProfileImage + "\" height=\"48\" width=\"48\" alt=\"\" title=\"" + objgpAcc.GpUserName + "\" /></a>" +
// "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/google_plus.png\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "googleanalytics")
{
try
{
//GoogleAnalyticsAccountRepository objgaAccRepo = new GoogleAnalyticsAccountRepository();
//GoogleAnalyticsAccount objgaAcc = objgaAccRepo.getGoogelAnalyticsAccountHomeDetailsById(user.Id,item.ProfileId);
//string accessToken = string.Empty;
//profiles += "<li id=\"so_" + item.ProfileId + "\"><div id=\"" + item.ProfileId + "\" class=\"userpictiny\"><div class=\"delet_icon\" onClick=\"confirmDel('" + item.ProfileId + "','googleanalytics')\"></div><a href=\"http://plus.google.com/" + item.ProfileId + "\" target=\"_blank\"><img src=\"../Contents/img/google_analytics.png\" height=\"48\" width=\"48\" alt=\"\" title=\"" + objgaAcc.GaAccountName + "\" /></a>" +
// "<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"\" width=\"16\" height=\"16\" alt=\"\"></a></div></li>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
} profiles += "</ul>";
Response.Write(profiles);
}
else if (Request.QueryString["op"] == "woodrafts")
{
string message = string.Empty;
try
{
DraftsRepository draftsRepository = new DraftsRepository();
List<Drafts> lstDrafts = draftsRepository.getAllDrafts(team.GroupId);
string profurl = string.Empty;
if (string.IsNullOrEmpty(user.ProfileUrl))
{
profurl = "../Contents/img/blank_img.png";
}
else
{
profurl = user.ProfileUrl;
}
if (lstDrafts.Count != 0)
{
foreach (Drafts item in lstDrafts)
{
try
{
message += "<section class=\"section\" style=\"width:648px;\">" +
"<div class=\"js-task-cont read\"><section class=\"task-owner\">" +
"<img width=\"32\" height=\"32\" border=\"0\" class=\"avatar\" src=\"../Contents/img/task_pin.png\">" +
// "<img width=\"32\" height=\"32\" border=\"0\" class=\"avatar\" src=\"" + profurl + "\" />" +
"</section><section class=\"task-activity third\" style=\"width: 19.6%;\"><p>" + user.UserName + "</p><div>" + item.CreatedDate + " </div><p>" +
//"</p></section><section style=\"margin-right: 6px; height: auto; width: 35%;\" class=\"task-message font-13 third\"><a onclick=\"writemessage(this.innerHTML);\" class=\"tip_left\">" + item.Message + "</a></section>" +
"</p></section><section style=\"margin-right: 6px; height: auto; width: 31%;\" class=\"task-message font-13 third\"><span class=\"tip_left\">" + gethtmlfromstring(item.Message) + "</span></section>" +
"<div class=\"userpictiny\" style=\"height:70px; margin-top: 0;\"><img alt=\"\" src=\"" + profurl + "\" />" +
"</div>" +
"<a class=\"small_remove icon publish_delete\" href=\"#\" style=\"top: 7px; float: right; margin-top: 13px; margin-right: 10px;\" title=\"Delete\" onclick=\"deleteDraftMessage('" + item.Id + "')\"></a>" +
"<section style=\"margin-top: 18px; width: 45px; margin-right: 17px;\" class=\"task-status\"><div class=\"ui_light floating task_status_change\"><a class=\"ui-sproutmenu\" href=\"#nogo\">" +
"<span onclick=\"editDraftsMessage('" + item.Id + "','" + item.Message + "');\" class=\"ui-sproutmenu-status\">" +
"<img class=\"edit_button\" src=\"../Contents/img/icon_edit.png\" alt=\"\" />" +
"</span>" +
"</a></div></section></div></section>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
}
else
{
message += "<div style=\"margin-left: 2%; margin-top: 3%;\">No Messages in Drafts</div>";
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
Response.Write(message);
}
else if (Request.QueryString["op"] == "savedrafts")
{
try
{
string message = Request.QueryString["message"];
message = Request.Form["messagee"];
Drafts d = new Drafts();
d.CreatedDate = DateTime.Now;
d.Message = message;
d.ModifiedDate = DateTime.Now;
d.UserId = user.Id;
d.GroupId = team.GroupId;
d.Id = Guid.NewGuid();
DraftsRepository dRepo = new DraftsRepository();
if (!dRepo.IsDraftsMessageExist(user.Id, message))
{
dRepo.AddDrafts(d);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
Response.Write("added successfully");
}
else if (Request.QueryString["op"] == "midsnaps")
{
try
{
Random rNum = new Random();
string loadtype = Request.QueryString["loadtype"];
string midsnaps = string.Empty;
if (loadtype == "load")
profilelimit = 0;
if (profilelimit != -1)
{
// Team lstDetails = objTeamRepository.getAllDetails(team.GroupId, team.EmailId);
List<TeamMemberProfile> alst = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
// ArrayList alst = socio.getLimitProfilesOfUser(user.Id, profilelimit);
if (alst.Count == 0)
profilelimit = -1;
else if (profilelimit == 0)
//profilelimit += 2;
profilelimit += 6;
else
profilelimit += 6;
midsnaps += "<div class=\"row-fluid\" >";
if (loadtype == "load")
{
AdsRepository objAdsRepo = new AdsRepository();
ArrayList lstads = objAdsRepo.getAdsForHome();
int i = 0;
if (lstads.Count <= 1)
{
if (user.PaymentStatus.ToUpper() == "PAID")
{
midsnaps += "";
}
}
else
{
foreach (var item in lstads)
{
Array temp = (Array)item;
i++;
if (temp != null)
{
if (i == 2)
{
if (user.AccountType == "Paid")
{
midsnaps += "<div class=\"span4 rounder recpro\"><button data-dismiss=\"alert\" class=\"close pull-right\" type=\"button\">×</button>" +
"<a href=\"#\"><img src=\"" + temp.GetValue(2).ToString() + "\" alt=\"\" style=\"width:246px;height:331px\"></a></div>";
}
}
}
}
}
}
foreach (TeamMemberProfile item in alst)
{
if (item.ProfileType == "facebook")
{
try
{
FacebookAccountRepository fbrepo = new FacebookAccountRepository();
FacebookFeedRepository facefeedrepo = new FacebookFeedRepository();
List<FacebookFeed> fbmsgs = facefeedrepo.getAllFacebookUserFeeds(item.ProfileId);
FacebookAccount fbaccount = fbrepo.getFacebookAccountDetailsById(item.ProfileId);
midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" +
"<div onclick=\"detailsdiscoveryfacebook('" + fbaccount.FbUserId + "');\" class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + fbaccount.FbUserName + "\" alt=\"\" src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\"\">" +
"<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/fb_icon.png\" width=\"16\" height=\"16\"></a></div>" +
"<div onclick=\"detailsdiscoveryfacebook('" + fbaccount.FbUserId + "');\" class=\"useraccname\">" + getsortpofilename(fbaccount.FbUserName) + "</div><div class=\"usercounter\">" +
"<div class=\"userfoll\">" + fbaccount.Friends;
if (fbaccount.Type == "page")
{
midsnaps += "<span><b style=\"font-size: 13px;\">Fans</b></span>";
}
else
{
midsnaps += "<span><b style=\"font-size: 13px;\">Friends</b></span>";
}
midsnaps += "</div>" +
"<div class=\"userppd\">" + Math.Round(rNum.NextDouble(), 2) + "<span>Avg. Post <br> Per Day</span></div></div><h5>Recent message</h5></div>" +
"<div class=\"concoteng\"> <ul class=\"mess\">";
if (fbmsgs.Count != 0)
{
int msgcount = 0;
foreach (FacebookFeed child in fbmsgs)
{
string mess = string.Empty;
if (msgcount < 2)
{
if (child.FeedDescription.Length > 40)
{
mess = child.FeedDescription.Substring(0, 39);
mess = mess + "...........";
}
else
{
mess = child.FeedDescription;
}
midsnaps += "<li><div class=\"messpic\"><img title=\"\" alt=\"\" src=\"http://graph.facebook.com/" + child.FromId + "/picture?type=small\"></div>" +
"<div class=\"messtext\">" + mess + "</div></li>";
}
else
{
break;
}
msgcount++;
}
}
else
{
midsnaps += "<strong>No messages were found within the past few days.</strong> \"Messages will be displayed once there is activity in this date range.\"";
}
midsnaps += "</ul></div></div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "googleplus")
{
}
else if (item.ProfileType == "twitter")
{
TwitterAccountRepository twtrepo = new TwitterAccountRepository();
SocioBoard.Domain.TwitterAccount twtaccount = twtrepo.getUserInformation(item.ProfileId);
TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
List<TwitterMessage> lsttwtmsgs = twtmsgrepo.getAllTwitterMessagesOfProfile(item.ProfileId);
int tweetcount = 0;
midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" +
"<div onclick=\"detailsdiscoverytwitter('" + item.ProfileId + "');\" class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + twtaccount.TwitterScreenName + "\" alt=\"\" src=\"" + twtaccount.ProfileImageUrl + "\">" +
"<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/twticon.png\" width=\"16\" height=\"16\"></a></div>" +
"<div onclick=\"detailsdiscoverytwitter('" + twtaccount.TwitterUserId + "');\" class=\"useraccname\">" + getsortpofilename(twtaccount.TwitterScreenName) + "</div><div class=\"usercounter\">" +
"<div class=\"userfoll\">" + twtaccount.FollowersCount + "<span><b style=\"font-size: 13px;\">Followers</b></span></div>" +
"<div class=\"userppd\">" + Math.Round(rNum.NextDouble(), 2) + "<span>Avg. tweet <br> Per Day</span></div></div><h5>Recent message</h5></div>" +
"<div class=\"concoteng\"> <ul class=\"mess\">";
try
{
if (lsttwtmsgs.Count == 0)
{
midsnaps += "<strong>No messages were found within the past few days.</strong> \"Messages will be displayed once there is activity in this date range.\"";
}
else
{
foreach (TwitterMessage msg in lsttwtmsgs)
{
if (tweetcount < 2)
{
try
{
string ms = string.Empty;
if (msg.TwitterMsg.Length > 20)
{
ms = msg.TwitterMsg.Substring(0, 20) + "...";
}
else
{
ms = msg.TwitterMsg;
}
midsnaps += "<li><div class=\"messpic\"><img title=\"\" alt=\"\" src=\"" + msg.FromProfileUrl + "\"></div>" +
"<div class=\"messtext\">" + ms + "</div></li>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
else
{
break;
}
tweetcount++;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
midsnaps += "</ul></div></div>";
}
else if (item.ProfileType == "tumblr")
{
try
{
string PostCount = string.Empty;
string LikesCount = string.Empty;
TumblrAccountRepository tumblrrepo = new TumblrAccountRepository();
SocioBoard.Domain.TumblrAccount tumblrccount = tumblrrepo.getTumblrAccountDetailsById(item.ProfileId);
TumblrFeedRepository tumblrfeedrepo = new TumblrFeedRepository();
List<TumblrFeed> lsttumblrmsgs = tumblrfeedrepo.getFeedOfProfile(item.ProfileId);
BlogInfo objBlogInfo = new BlogInfo();
string objData = objBlogInfo.getTumblrUserInfo(tumblrccount.tblrUserName);
//string objFollower = objBlogInfo.getTumblrUserfollower(tumblrccount.tblrUserName);
string[] words = objData.Split('&');
PostCount = words[1].ToString();
LikesCount = words[0].ToString();
midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" +
"<a href=\"http://"+ item.ProfileId + ".tumblr.com\" target=\"_blank\"><div class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + tumblrccount.tblrUserName + "\" alt=\"\" src=\"http://api.tumblr.com/v2/blog/" + tumblrccount.tblrUserName + ".tumblr.com/avatar\"></a>" +
"<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/tumblr.png\" width=\"16\" height=\"16\"></a></div>" +
"<a href=\"http://" + item.ProfileId + ".tumblr.com\" target=\"_blank\"><div class=\"useraccname\">" + getsortpofilename(tumblrccount.tblrUserName) + "</div></a></div>" +
"<div class=\"concoteng\"><div class=\"pillow_fade\">" +
" <div class=\"fb_notifications\">" +
"<ul class=\"user-stats\"> " +
"<li><div class=\"photo_stat\"> post</div> <div class=\"number-stat\">" + PostCount + "</div></li>" +
"<li><div class=\"photo_stat\">likes</div><div class=\"number-stat\">" + LikesCount + "</div></li>" +
"</ul></div></div></div></div>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "youtube")
{
try
{
YoutubeAccountRepository ytrepo = new YoutubeAccountRepository();
YoutubeChannelRepository objYoutubeChannelRepository=new YoutubeChannelRepository();
SocioBoard.Domain.YoutubeAccount ytacount = ytrepo.getYoutubeAccountDetailsById(item.ProfileId);
YoutubeChannel objYoutubeChannel = objYoutubeChannelRepository.getYoutubeChannelDetailsById(item.ProfileId);
if (string.IsNullOrEmpty(ytacount.Ytprofileimage))
{
ytacount.Ytprofileimage = "../../Contents/img/blank_img.png";
}
midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" +
"<a href=\"#\" target=\"_blank\"><div class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + ytacount.Ytuserid + "\" alt=\"\" src=\"" + ytacount.Ytprofileimage + "\"></a>" +
"<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/youtube.png\" width=\"16\" height=\"16\"></a></div>" +
"<a href=\"#\" target=\"_blank\"><div class=\"useraccname\">" + getsortpofilename(ytacount.Ytusername) + "</div></a></div>" +
"<div class=\"concoteng\"><div class=\"pillow_fade\">" +
" <div class=\"fb_notifications\">" +
"<ul class=\"user-stats\"> " +
"<li><div class=\"photo_stat\">Total View</div> <div class=\"number-stat\">" + objYoutubeChannel.ViewCount + "</div></li>" +
"<li><div class=\"photo_stat\">Total Subcriber</div><div class=\"number-stat\">" + objYoutubeChannel.SubscriberCount + "</div></li>" +
"<li><div class=\"photo_stat\">Total Video</div><div class=\"number-stat\">" + objYoutubeChannel.VideoCount + "</div></li>" +
"</ul></div></div></div></div>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "linkedin")
{
try
{
string access = string.Empty, tokenSecrate = string.Empty, LdprofileName = string.Empty, LdPreofilePic = string.Empty;
LinkedInAccountRepository objLiRepo = new LinkedInAccountRepository();
LinkedInFeedRepository objliFeedRepo = new LinkedInFeedRepository();
LinkedInAccount liAccount = objLiRepo.getUserInformation(item.ProfileId);
LinkedInFeedRepository lifeedrepo = new LinkedInFeedRepository();
List<LinkedInFeed> alstliaccount = lifeedrepo.getAllLinkedInFeedsOfProfile(item.ProfileId);
if (liAccount != null)
{
LdprofileName = liAccount.LinkedinUserName;
LdPreofilePic = liAccount.ProfileImageUrl;
}
if (string.IsNullOrEmpty(LdPreofilePic))
{
LdPreofilePic = "../../Contents/img/blank_img.png";
}
int linkedinConcount = 0;
try
{
linkedinConcount = liAccount.Connections;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" +
"<div class=\"userpictiny\"><a target=\"_blank\" href=\"" + liAccount.ProfileUrl + "\"><img width=\"56\" height=\"56\" title=\"" + LdprofileName + "\" alt=\"\" src=\"" + LdPreofilePic + "\"></a>" +
"<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/link_icon.png\" width=\"16\" height=\"16\"></a></div>" +
"<div class=\"useraccname\">" + getsortpofilename(LdprofileName) + "</div><div class=\"usercounter\">" +
"<div class=\"userfoll\">" + linkedinConcount + "<span>Connections</span></div>" +
"<div class=\"userppd\">" + Math.Round(rNum.NextDouble(), 2) + "<span>Avg. Post <br> Per Day</span></div></div><h5>Recent message</h5></div>" +
"<div class=\"concoteng\"> <ul class=\"mess\">";
int link = 0;
if (alstliaccount.Count == 0)
{
midsnaps += "<strong>No messages were found within the past 14 days.</strong> \"Messages will be displayed once there is activity in this date range.\"";
}
else
{
try
{
foreach (LinkedInFeed liFeed in alstliaccount)
{
try
{
if (link < 2)
{
string ms = string.Empty;
if (liFeed.Feeds.Length > 20)
{
ms = liFeed.Feeds.Substring(0, 20) + "...";
}
else
{
ms = liFeed.Feeds;
}
midsnaps += "<li><div class=\"messpic\"><img title=\"\" alt=\"\" src=\"" + liFeed.FromPicUrl + "\"></div>" +
"<div class=\"messtext\">" + ms + "</div></li>";
link++;
}
else
{
break;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
midsnaps += "</ul></div></div>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "instagram")
{
try
{
InstagramAccountRepository objInsAccRepo = new InstagramAccountRepository();
InstagramAccount objInsAcc = objInsAccRepo.getInstagramAccountDetailsById(item.ProfileId);
midsnaps += "<div id=\"mid_" + item.ProfileId + "\" style=\"height:213px;\" class=\"span4 rounder recpro\"><div class=\"concotop\">" +
"<a href=\"http://instagram.com/" + objInsAcc.InsUserName + "\" target=\"_blank\"><div class=\"userpictiny\"><img width=\"56\" height=\"56\" title=\"" + objInsAcc.InsUserName + "\" alt=\"\" src=\"" + objInsAcc.ProfileUrl + "\"></a>" +
"<a title=\"\" class=\"userurlpic\" href=\"#\"><img alt=\"\" src=\"../Contents/img/instagram_24X24.png\" width=\"16\" height=\"16\"></a></div>" +
"<a href=\"http://instagram.com/" + objInsAcc.InsUserName + "\" target=\"_blank\"><div class=\"useraccname\">" + getsortpofilename(objInsAcc.InsUserName) + "</div></a></div>" +
"<div class=\"concoteng\"><div class=\"pillow_fade\">" +
" <div class=\"fb_notifications\">" +
"<ul class=\"user-stats\"> " +
"<li><div class=\"photo_stat\"> photos</div> <div class=\"number-stat\">" + objInsAcc.TotalImages + "</div></li>" +
"<li><div class=\"photo_stat\">following</div><div class=\"number-stat\">" + objInsAcc.Followers + "</div></li>" +
"<li><div class=\"photo_stat\">followers</div><div class=\"number-stat\">" + objInsAcc.FollowedBy + "</div></li>" +
"</ul></div></div></div></div>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "googleanalytics")
{
}
}
midsnaps += "</div>";
Response.Write(midsnaps);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (Request.QueryString["op"] == "accountdelete")
{
Groups lstDetails = objGroupRepository.getGroupName(team.GroupId);
if (lstDetails.GroupName == "Socioboard")
{
Session["facebooktotalprofiles"] = null;
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
string Profiletype = Request.QueryString["profile"];
string profileid = Request.QueryString["profileid"];
if (Profiletype == "fb")
{
try
{
FacebookAccountRepository fbrepo = new FacebookAccountRepository();
int delaccFromTeamMemberProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(profileid);
int delacc = fbrepo.deleteFacebookUser(profileid, user.Id);
if (delacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid);
if (lstsocioprofile.Count >= 0)
{
try
{
FacebookMessageRepository fbmsgrepo = new FacebookMessageRepository();
fbmsgrepo.deleteAllMessagesOfUser(profileid, user.Id);
FacebookFeedRepository fbfeedrepo = new FacebookFeedRepository();
fbfeedrepo.deleteAllFeedsOfUser(profileid, user.Id);
FacebookStatsRepository fbstatsrepo = new FacebookStatsRepository();
fbstatsrepo.deleteFacebookStats(profileid, user.Id);
ScheduledMessageRepository schedulemsgrepo = new ScheduledMessageRepository();
schedulemsgrepo.deleteMessage(user.Id, profileid);
ArchiveMessageRepository archmsgrepo = new ArchiveMessageRepository();
int del = archmsgrepo.DeleteArchiveMessage(user.Id, profileid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception exx)
{
Console.WriteLine(exx.Message);
logger.Error(exx.Message);
}
}
else if (Profiletype == "tumblr")
{
try
{
TumblrAccountRepository tumblraccountrepo = new TumblrAccountRepository();
TumblrFeedRepository objTumblrFeedRepository = new TumblrFeedRepository();
int deltwtacc = tumblraccountrepo.deleteTumblrUser(profileid, user.Id);
int delaccFromTeamMemberProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(profileid);
if (deltwtacc > 0)
{
try
{
socioprofilerepo.deleteProfile(user.Id, profileid);
objTumblrFeedRepository.DeleteTumblrDataByUserid(user.Id, profileid);
ScheduledMessageRepository schedulemsgrepo = new ScheduledMessageRepository();
schedulemsgrepo.deleteMessage(user.Id, profileid);
ArchiveMessageRepository archmsgrepo = new ArchiveMessageRepository();
int del = archmsgrepo.DeleteArchiveMessage(user.Id, profileid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
else if (Profiletype == "youtube")
{
try
{
YoutubeAccountRepository youtubeaccountrepo = new YoutubeAccountRepository();
YoutubeChannelRepository objYoutubeChannelRepository = new YoutubeChannelRepository();
int deltwtacc = youtubeaccountrepo.deleteYoutubeUser(user.Id,profileid);
int delaccFromTeamMemberProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(profileid);
if (deltwtacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
objYoutubeChannelRepository.DeleteProfileDataByUserid(profileid);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
else if (Profiletype == "twt")
{
try
{
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
int deltwtacc = twtaccountrepo.deleteTwitterUser(user.Id, profileid);
int delaccFromTeamMemberProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(profileid);
if (deltwtacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid);
if (lstsocioprofile.Count >= 0)
{
try
{
TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
int d = twtmsgrepo.deleteTwitterMessage(profileid, user.Id);
TwitterFeedRepository twtfeedrepo = new TwitterFeedRepository();
int s = twtfeedrepo.deleteTwitterFeed(profileid, user.Id);
TwitterStatsRepository twtstatsrepo = new TwitterStatsRepository();
int a = twtstatsrepo.deleteTwitterStats(user.Id, profileid);
TwitterDirectMessageRepository twtdirectmsgrepo = new TwitterDirectMessageRepository();
int f = twtdirectmsgrepo.deleteDirectMessage(user.Id, profileid);
ScheduledMessageRepository schedulemsgrepo = new ScheduledMessageRepository();
schedulemsgrepo.deleteMessage(user.Id, profileid);
ArchiveMessageRepository archmsgrepo = new ArchiveMessageRepository();
int del = archmsgrepo.DeleteArchiveMessage(user.Id, profileid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
else if (Profiletype == "linkedin")
{
try
{
LinkedInAccountRepository linkedaccrepo = new LinkedInAccountRepository();
int delaccFromTeamMemberProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(profileid);
int dellinacc = linkedaccrepo.deleteLinkedinUser(profileid, user.Id);
if (dellinacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid);
if (lstsocioprofile.Count >= 0)
{
try
{
LinkedInFeedRepository linkedfeedrepo = new LinkedInFeedRepository();
int s = linkedfeedrepo.deleteAllFeedsOfUser(profileid, user.Id);
ScheduledMessageRepository schedulemsgrepo = new ScheduledMessageRepository();
schedulemsgrepo.deleteMessage(user.Id, profileid);
ArchiveMessageRepository archmsgrepo = new ArchiveMessageRepository();
int del = archmsgrepo.DeleteArchiveMessage(user.Id, profileid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (Profiletype == "instagram")
{
try
{
InstagramAccountRepository insaccrepo = new InstagramAccountRepository();
int delaccFromTeamMemberProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(profileid);
int insacc = insaccrepo.deleteInstagramUser(profileid, user.Id);
if (insacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid);
if (lstsocioprofile.Count >= 0)
{
try
{
ScheduledMessageRepository schedulemsgrepo = new ScheduledMessageRepository();
schedulemsgrepo.deleteMessage(user.Id, profileid);
ArchiveMessageRepository archmsgrepo = new ArchiveMessageRepository();
int del = archmsgrepo.DeleteArchiveMessage(user.Id, profileid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (Profiletype == "googleplus")
{
try
{
GooglePlusAccountRepository googleplusaccrepo = new GooglePlusAccountRepository();
int delaccFromTeamMemberProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByUserid(profileid);
int gplusacc = googleplusaccrepo.deleteGooglePlusUser(profileid, user.Id);
if (gplusacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid);
if (lstsocioprofile.Count >= 0)
{
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
string profiles = string.Empty;
profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">";
/*facebook users binding*/
FacebookAccountRepository fbprepo = new FacebookAccountRepository();
ArrayList lstfbaccounts = fbprepo.getFacebookAccountsOfUser(user.Id);
profiles += "<div class=\"twitte_text\">FACEBOOK</div><div class=\"teitter\"><ul>";
if (lstfbaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (FacebookAccount fbacc in lstfbaccounts)
{
profiles += "<li id=\"liid_" + fbacc.FbUserId + "\" onclick=\"composemessage(this.id,'fb')\"><a><img id=\"img_" + fbacc.FbUserId + "\" src=\"../Contents/img/facebook.png\" alt=\"" + fbacc.AccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"composename_" + fbacc.FbUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + fbacc.FbUserName + "</span><span id=\"imgurl_" + fbacc.FbUserId + "\" style=\"display:none;\">http://graph.facebook.com/" + fbacc.FbUserId + "/picture?type=small</span></a></li>";
}
}
profiles += "</ul> </div>";
/*twitter users binding*/
TwitterAccountRepository twtpaccountrepo = new TwitterAccountRepository();
ArrayList alsttwtaccounts = twtpaccountrepo.getAllTwitterAccountsOfUser(user.Id);
profiles += "<div class=\"twitte_text\">TWITTER</div><div class=\"teitter\"><ul>";
if (alsttwtaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (SocioBoard.Domain.TwitterAccount item in alsttwtaccounts)
{
profiles += "<li id=\"liid_" + item.TwitterUserId + "\" onclick=\"composemessage(this.id,'twt')\"><a><img id=\"img_" + item.TwitterUserId + "\" src=\"../Contents/img/twitter.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.TwitterUserId + "\" style=\"display:none;\">" + item.ProfileImageUrl + "</span><span id=\"composename_" + item.TwitterUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.TwitterScreenName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
/*linkedinuserbinding*/
LinkedInAccountRepository linkaccountrepo = new LinkedInAccountRepository();
ArrayList alstlinkacc = linkaccountrepo.getAllLinkedinAccountsOfUser(user.Id);
profiles += "<div class=\"twitte_text\">LINKEDIN</div><div class=\"teitter\"><ul>";
if (alstlinkacc.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (LinkedInAccount item in alstlinkacc)
{
string profileurl = string.Empty;
if (!string.IsNullOrEmpty(item.ProfileImageUrl))
{
profileurl = item.ProfileImageUrl;
}
else
{
profileurl = "../../Contents/img/blank_img.png";
}
profiles += "<li id=\"liid_" + item.LinkedinUserId + "\" onclick=\"composemessage(this.id,'lin')\"><a><img id=\"img_" + item.LinkedinUserId + "\" src=\"../Contents/img/link.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.LinkedinUserId + "\" style=\"display:none;\">" + profileurl + "</span><span id=\"composename_" + item.LinkedinUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.LinkedinUserName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
Response.Write(RemainingAccount(user));
}
}
else if (Request.QueryString["op"] == "MasterCompose")
{
string profiles = string.Empty;
string FbprofileId = string.Empty;
string TwtprofileId = string.Empty;
string TumblrprofileId = string.Empty;
string LinkedInprofileId = string.Empty;
profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">";
try
{
List<TeamMemberProfile> allprofiles = objTeamMemberProfileRepository.getTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allprofiles)
{
FbprofileId += item.ProfileId + ',';
}
FbprofileId = FbprofileId.Substring(0, FbprofileId.Length - 1);
/*facebook users binding*/
FacebookAccountRepository fbrepo = new FacebookAccountRepository();
List<FacebookAccount> lstfbaccounts = fbrepo.getAllAccountDetail(FbprofileId);
profiles += "<div class=\"twitte_text\">FACEBOOK</div><div class=\"teitter\"><ul>";
if (lstfbaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (FacebookAccount fbacc in lstfbaccounts)
{
profiles += "<li nwtk='fb' class=\"getAllNetworkProfile\" id=\"liid_" + fbacc.FbUserId + "\" onclick=\"composemessage(this.id,'fb')\"><a><img id=\"img_" + fbacc.FbUserId + "\" src=\"../Contents/img/facebook.png\" alt=\"" + fbacc.AccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"composename_" + fbacc.FbUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + fbacc.FbUserName + "</span><span id=\"imgurl_" + fbacc.FbUserId + "\" style=\"display:none;\">http://graph.facebook.com/" + fbacc.FbUserId + "/picture?type=small</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
/*tumbler users binding*/
try
{
List<TeamMemberProfile> allTumblrprofiles = objTeamMemberProfileRepository.getTumblrTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allTumblrprofiles)
{
TumblrprofileId += item.ProfileId + ',';
}
TumblrprofileId = TumblrprofileId.Substring(0, TumblrprofileId.Length - 1);
TumblrAccountRepository tumblrtaccountrepo = new TumblrAccountRepository();
List<TumblrAccount> alsttumblrtaccounts = tumblrtaccountrepo.getAllAccountDetail(TumblrprofileId);
profiles += "<div class=\"twitte_text\">TUMBLR</div><div class=\"teitter\"><ul>";
if (alsttumblrtaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (TumblrAccount item in alsttumblrtaccounts)
{
profiles += "<li nwtk='tumb' class=\"getAllNetworkProfile\" id=\"liid_" + item.tblrUserName + "\" onclick=\"composemessage(this.id,'tumb')\"><a><img id=\"img_" + item.tblrUserName + "\" src=\"../Contents/img/tumblr.png\" alt=\"" + item.tblrAccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.tblrUserName + "\" style=\"display:none;\">http://api.tumblr.com/v2/blog/" + item.tblrProfilePicUrl + ".tumblr.com/avatar</span><span id=\"composename_" + item.tblrUserName + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.tblrUserName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
/*twitter users binding*/
try
{
List<TeamMemberProfile> allTwtprofiles = objTeamMemberProfileRepository.getTwtTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allTwtprofiles)
{
TwtprofileId += item.ProfileId + ',';
}
TwtprofileId = TwtprofileId.Substring(0, TwtprofileId.Length - 1);
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
List<TwitterAccount> alsttwtaccounts = twtaccountrepo.getAllAccountDetail(TwtprofileId);
profiles += "<div class=\"twitte_text\">TWITTER</div><div class=\"teitter\"><ul>";
if (alsttwtaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (TwitterAccount item in alsttwtaccounts)
{
profiles += "<li nwtk='twt' class=\"getAllNetworkProfile\" id=\"liid_" + item.TwitterUserId + "\" onclick=\"composemessage(this.id,'twt')\"><a><img id=\"img_" + item.TwitterUserId + "\" src=\"../Contents/img/twitter.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.TwitterUserId + "\" style=\"display:none;\">" + item.ProfileImageUrl + "</span><span id=\"composename_" + item.TwitterUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.TwitterScreenName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
/*linkedinuserbinding*/
try
{
List<TeamMemberProfile> allLinkedInprofiles = objTeamMemberProfileRepository.getLinkedInTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allLinkedInprofiles)
{
LinkedInprofileId += item.ProfileId + ',';
}
LinkedInprofileId = LinkedInprofileId.Substring(0, LinkedInprofileId.Length - 1);
LinkedInAccountRepository linkaccountrepo = new LinkedInAccountRepository();
List<LinkedInAccount> alstlinkacc = linkaccountrepo.getAllAccountDetail(LinkedInprofileId);
profiles += "<div class=\"twitte_text\">LINKEDIN</div><div class=\"teitter\"><ul>";
if (alstlinkacc.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (LinkedInAccount item in alstlinkacc)
{
string profileurl = string.Empty;
if (!string.IsNullOrEmpty(item.ProfileImageUrl))
{
profileurl = item.ProfileImageUrl;
}
else
{
profileurl = "../../Contents/img/blank_img.png";
}
profiles += "<li nwtk='lin' class=\"getAllNetworkProfile\" id=\"liid_" + item.LinkedinUserId + "\" onclick=\"composemessage(this.id,'lin')\"><a><img id=\"img_" + item.LinkedinUserId + "\" src=\"../Contents/img/link.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.LinkedinUserId + "\" style=\"display:none;\">" + profileurl + "</span><span id=\"composename_" + item.LinkedinUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.LinkedinUserName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
Response.Write(profiles);
}
//=============================================================
else if (Request.QueryString["op"] == "MasterComposesc")
{
string profiles = string.Empty;
string FbprofileId = string.Empty;
string TwtprofileId = string.Empty;
string LinkedInprofileId = string.Empty;
string TumblrprofileId = string.Empty;
//if (Session["profilesforcomposemessage"] == null)
//{
profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">";
try
{
List<TeamMemberProfile> allprofiles = objTeamMemberProfileRepository.getTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allprofiles)
{
FbprofileId += item.ProfileId + ',';
}
FbprofileId = FbprofileId.Substring(0, FbprofileId.Length - 1);
/*facebook users binding*/
FacebookAccountRepository fbrepo = new FacebookAccountRepository();
List<FacebookAccount> lstfbaccounts = fbrepo.getAllAccountDetail(FbprofileId);
profiles += "<div class=\"twitte_text\">FACEBOOK</div><div class=\"teitter\"><ul>";
if (lstfbaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (FacebookAccount fbacc in lstfbaccounts)
{
profiles += "<li nwtk='fb' class=\"getAllNetworkProfile\" id=\"liid_" + fbacc.FbUserId + "\" onclick=\"composemessage(this.id,'fb')\"><a><img id=\"img_" + fbacc.FbUserId + "\" src=\"../Contents/img/facebook.png\" alt=\"" + fbacc.AccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"composename_" + fbacc.FbUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + fbacc.FbUserName + "</span><span id=\"imgurl_" + fbacc.FbUserId + "\" style=\"display:none;\">http://graph.facebook.com/" + fbacc.FbUserId + "/picture?type=small</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
/*tumbler users binding*/
try
{
List<TeamMemberProfile> allTumblrprofiles = objTeamMemberProfileRepository.getTumblrTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allTumblrprofiles)
{
TumblrprofileId += item.ProfileId + ',';
}
TumblrprofileId = TumblrprofileId.Substring(0, TumblrprofileId.Length - 1);
TumblrAccountRepository tumblrtaccountrepo = new TumblrAccountRepository();
List<TumblrAccount> alsttumblrtaccounts = tumblrtaccountrepo.getAllAccountDetail(TumblrprofileId);
profiles += "<div class=\"twitte_text\">TUMBLR</div><div class=\"teitter\"><ul>";
if (alsttumblrtaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (TumblrAccount item in alsttumblrtaccounts)
{
profiles += "<li nwtk='twt' class=\"getAllNetworkProfile\" id=\"liid_" + item.tblrUserName + "\" onclick=\"composemessage(this.id,'twt')\"><a><img id=\"img_" + item.tblrUserName + "\" src=\"../Contents/img/twitter.png\" alt=\"" + item.tblrAccessToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.tblrUserName + "\" style=\"display:none;\">" + item.tblrProfilePicUrl + "</span><span id=\"composename_" + item.tblrUserName + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.tblrUserName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
/*twitter users binding*/
try
{
List<TeamMemberProfile> allTwtprofiles = objTeamMemberProfileRepository.getTwtTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allTwtprofiles)
{
TwtprofileId += item.ProfileId + ',';
}
TwtprofileId = TwtprofileId.Substring(0, TwtprofileId.Length - 1);
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
List<TwitterAccount> alsttwtaccounts = twtaccountrepo.getAllAccountDetail(TwtprofileId);
profiles += "<div class=\"twitte_text\">TWITTER</div><div class=\"teitter\"><ul>";
if (alsttwtaccounts.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (TwitterAccount item in alsttwtaccounts)
{
profiles += "<li nwtk='twt' class=\"getAllNetworkProfile\" id=\"liid_" + item.TwitterUserId + "\" onclick=\"composemessage(this.id,'twt')\"><a><img id=\"img_" + item.TwitterUserId + "\" src=\"../Contents/img/twitter.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.TwitterUserId + "\" style=\"display:none;\">" + item.ProfileImageUrl + "</span><span id=\"composename_" + item.TwitterUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.TwitterScreenName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
/*linkedinuserbinding*/
try
{
List<TeamMemberProfile> allLinkedInprofiles = objTeamMemberProfileRepository.getLinkedInTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allLinkedInprofiles)
{
LinkedInprofileId += item.ProfileId + ',';
}
LinkedInprofileId = LinkedInprofileId.Substring(0, LinkedInprofileId.Length - 1);
LinkedInAccountRepository linkaccountrepo = new LinkedInAccountRepository();
List<LinkedInAccount> alstlinkacc = linkaccountrepo.getAllAccountDetail(LinkedInprofileId);
profiles += "<div class=\"twitte_text\">LINKEDIN</div><div class=\"teitter\"><ul>";
if (alstlinkacc.Count == 0)
{
profiles += "<li>No Records Found</li>";
}
else
{
foreach (LinkedInAccount item in alstlinkacc)
{
string profileurl = string.Empty;
if (!string.IsNullOrEmpty(item.ProfileImageUrl))
{
profileurl = item.ProfileImageUrl;
}
else
{
profileurl = "../../Contents/img/blank_img.png";
}
profiles += "<li nwtk='lin' class=\"getAllNetworkProfile\" id=\"liid_" + item.LinkedinUserId + "\" onclick=\"composemessage(this.id,'lin')\"><a><img id=\"img_" + item.LinkedinUserId + "\" src=\"../Contents/img/link.png\" alt=\"" + item.OAuthToken + "\" border=\"none\" width=\"18\" style=\"float:left;\" /><span id=\"imgurl_" + item.LinkedinUserId + "\" style=\"display:none;\">" + profileurl + "</span><span id=\"composename_" + item.LinkedinUserId + "\" style=\"float:left;margin: 3px 0 0 5px;\">" + item.LinkedinUserName + "</span></a></li>";
}
}
profiles += "</ul> </div>";
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
Response.Write(profiles);
}
else if (Request.QueryString["op"] == "sendmessage")
{
string messagecount = string.Empty;
string message = Request.QueryString["message"];
string time = Request.QueryString["now"];
//message = Request.Form["massagee"];
var userid = Request.QueryString["userid[]"].Split(',');
//var userid = Request.Form["userid[]"].Split(',');
var files = Request.Files.Count;
var fi = Request.Files["file"];
string file = string.Empty;
try
{
if (Request.Files.Count > 0)
{
if (fi != null)
{
var path = Server.MapPath("~/Contents/img/upload");
// var path = System.Configuration.ConfigurationManager.AppSettings["MailSenderDomain"]+"Contents/img/upload";
file = path + "/" + fi.FileName;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
fi.SaveAs(file);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
foreach (var item in userid)
{
string[] networkingwithid = item.Split('_');
if (networkingwithid[0] == "fb")
{
try
{
//for (int i = 0; i < 5000; i++)
// {
FacebookAccountRepository fbaccountrepo = new FacebookAccountRepository();
FacebookAccount fbaccount = fbaccountrepo.getFacebookAccountDetailsById(networkingwithid[1]);
var args = new Dictionary<string, object>();
args["message"] = message;
if (Request.Files.Count > 0)
{
string strPathAndQuery = HttpContext.Current.Request.Url.PathAndQuery;
string strUrl = HttpContext.Current.Request.Url.AbsoluteUri.Replace(strPathAndQuery, "/");
string filepath = strUrl + "/Contents/img/upload/" + fi.FileName;
args["picture"] = filepath;
}
FacebookClient fc = new FacebookClient(fbaccount.AccessToken);
string facebookpost = string.Empty;
if (fbaccount.Type == "page")
{
facebookpost = fc.Post("/" + fbaccount.FbUserId + "/feed", args).ToString();
}
else
{
facebookpost = fc.Post("/me/feed", args).ToString();
}
//}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
else if (networkingwithid[0] == "twt")
{
try
{
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
SocioBoard.Domain.TwitterAccount twtaccount = twtaccountrepo.getUserInformation(networkingwithid[1]);
TwitterHelper twthelper = new TwitterHelper();
oAuthTwitter OAuthTwt = new oAuthTwitter();
OAuthTwt.AccessToken = twtaccount.OAuthToken;
OAuthTwt.AccessTokenSecret = twtaccount.OAuthSecret;
OAuthTwt.TwitterScreenName = twtaccount.TwitterScreenName;
OAuthTwt.TwitterUserId = twtaccount.TwitterUserId;
twthelper.SetCofigDetailsForTwitter(OAuthTwt);
#region For Testing
// For Testing
//OAuthTwt.ConsumerKey = "udiFfPxtCcwXWl05wTgx6w";
//OAuthTwt.ConsumerKeySecret = "jutnq6N32Rb7cgbDSgfsrUVgRQKMbUB34yuvAfCqTI";
//OAuthTwt.AccessToken = "1453351098-Lz4H7cHKp26pXarF6l9zEwdiHDnwH7D0H4zteH3";
//OAuthTwt.AccessTokenSecret = "dGBPxR9wxhQMioIcj5P4Wemxo5EZIZ8wlvDz7i39lSNFg";
//OAuthTwt.TwitterScreenName = "";
//OAuthTwt.TwitterUserId = "";
#endregion
Tweet twt = new Tweet();
if (Request.Files.Count > 0)
{
PhotoUpload ph = new PhotoUpload();
//ph.Tweet(file, message, OAuthTwt);
string res = string.Empty;
ph.NewTweet(file, message, OAuthTwt, ref res);
// for testing
Response.Write(res);
Console.WriteLine(res);
}
else
{
JArray post = twt.Post_Statuses_Update(OAuthTwt, message);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (networkingwithid[0] == "lin")
{
try
{
LinkedInAccountRepository linkedinaccrepo = new LinkedInAccountRepository();
LinkedInAccount linkedaccount = linkedinaccrepo.getUserInformation(networkingwithid[1]);
oAuthLinkedIn Linkedin_oauth = new oAuthLinkedIn();
Linkedin_oauth.Verifier = linkedaccount.OAuthVerifier;
Linkedin_oauth.TokenSecret = linkedaccount.OAuthSecret;
Linkedin_oauth.Token = linkedaccount.OAuthToken;
Linkedin_oauth.Id = linkedaccount.LinkedinUserId;
Linkedin_oauth.FirstName = linkedaccount.LinkedinUserName;
SocialStream sociostream = new SocialStream();
string res = sociostream.SetStatusUpdate(Linkedin_oauth, message);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (networkingwithid[0] == "tumb")
{
string title = string.Empty;
try
{
TumblrAccountRepository objTumblrAccountRepository = new TumblrAccountRepository();
TumblrAccount tumblraccount = objTumblrAccountRepository.getTumblrAccountDetailsById(networkingwithid[1]);
PublishedPosts objPublishedPosts = new PublishedPosts();
objPublishedPosts.PostData(tumblraccount.tblrAccessToken, tumblraccount.tblrAccessTokenSecret, networkingwithid[1], message, title, "text");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
string profiletype="";
if(networkingwithid[0] == "fb")
{
profiletype="facebook";
}
else if(networkingwithid[0] == "twt")
{
profiletype="twitter";
}
else if(networkingwithid[0] == "lin")
{
profiletype="linkedin";
}
else if (networkingwithid[0] == "tumb")
{
profiletype = "tumblr";
}
ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
ScheduledMessage objScheduledMessage = new ScheduledMessage();
try
{
objScheduledMessage.ShareMessage = message;
objScheduledMessage.ClientTime = Convert.ToDateTime(time);
objScheduledMessage.ScheduleTime = Convert.ToDateTime(time);
objScheduledMessage.CreateTime = Convert.ToDateTime(time);
objScheduledMessage.Status = true;
objScheduledMessage.UserId = user.Id;
objScheduledMessage.ProfileType = profiletype;
try
{ var path = System.Configuration.ConfigurationManager.AppSettings["MailSenderDomain"]+"Contents/img/upload";
file = path + "/" + fi.FileName;
objScheduledMessage.PicUrl = file;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objScheduledMessage.ProfileId = networkingwithid[1];
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objScheduledMessageRepository.addNewMessage(objScheduledMessage);
messagecount = objScheduledMessageRepository.getAllSentMessagesOfUser(user.Id).Count().ToString();
}
Response.Write("~"+messagecount);
}
else if (Request.QueryString["op"] == "wooqueue_messages")
{
ScheduledMessageRepository schmsgrepo = new ScheduledMessageRepository();
}
else if (Request.QueryString["op"] == "schedulemessage")
{
var userid = Request.QueryString["users[]"].Split(',');
var datearr = Request.QueryString["datearr[]"].Split(',');
string message = Request.QueryString["message"];
message = Request.Form["messagee"];
ScheduledMessageRepository schmsgrepo = new ScheduledMessageRepository();
string time = Request.QueryString["time"];
string clienttime = Request.QueryString["clittime"];
foreach (var item in userid)
{
if (!string.IsNullOrEmpty(item.ToString()))
{
foreach (var child in datearr)
{
ScheduledMessage schmessage = new ScheduledMessage();
string[] networkingwithid = item.Split('_');
if (networkingwithid[0] == "fbscheduler")
{
schmessage.CreateTime = DateTime.Now;
schmessage.ProfileType = "facebook";
schmessage.ProfileId = networkingwithid[1];
schmessage.Id = Guid.NewGuid();
schmessage.PicUrl = string.Empty;
schmessage.ClientTime = Convert.ToDateTime(clienttime);
string servertime = this.CompareDateWithclient(clienttime, child + " " + time);
schmessage.ScheduleTime = Convert.ToDateTime(servertime);
schmessage.ShareMessage = message;
schmessage.UserId = user.Id;
schmessage.Status = false;
}
else if (networkingwithid[0] == "twtscheduler")
{
schmessage.CreateTime = DateTime.Now;
schmessage.ProfileType = "twitter";
schmessage.ProfileId = networkingwithid[1];
schmessage.Id = Guid.NewGuid();
schmessage.PicUrl = string.Empty;
schmessage.ClientTime = Convert.ToDateTime(clienttime);
string servertime = this.CompareDateWithServer(clienttime, child + " " + time);
schmessage.ScheduleTime = Convert.ToDateTime(servertime);
schmessage.ShareMessage = message;
schmessage.UserId = user.Id;
schmessage.Status = false;
}
else if (networkingwithid[0] == "linscheduler")
{
schmessage.ClientTime = Convert.ToDateTime(clienttime);
schmessage.CreateTime = DateTime.Now;
schmessage.ProfileType = "linkedin";
schmessage.ProfileId = networkingwithid[1];
schmessage.Id = Guid.NewGuid();
schmessage.PicUrl = string.Empty;
string servertime = this.CompareDateWithServer(clienttime, child + " " + time);
schmessage.ScheduleTime = Convert.ToDateTime(servertime);
schmessage.ShareMessage = message;
schmessage.UserId = user.Id;
schmessage.Status = false;
}
if (!string.IsNullOrEmpty(message))
{
if (!schmsgrepo.checkMessageExistsAtTime(user.Id, schmessage.ShareMessage, schmessage.ScheduleTime, schmessage.ProfileId))
{
schmsgrepo.addNewMessage(schmessage);
}
}
}
}
}
}
else if (Request.QueryString["op"] == "insight")
{
string check = "";
FacebookAccount objFacebookAccount = (FacebookAccount)Session["fbpagedetail"];
FacebookHelper objFbHelper = new FacebookHelper();
SocialProfile socioprofile = new SocialProfile();
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
FacebookAccountRepository fbrepo = new FacebookAccountRepository();
FacebookClient fbClient = new FacebookClient(objFacebookAccount.AccessToken);
int fancountPage = 0;
dynamic fancount = fbClient.Get("fql", new { q = " SELECT fan_count FROM page WHERE page_id =" + Request["id"].ToString() });
foreach (var friend in fancount.data)
{
fancountPage = Convert.ToInt32(friend.fan_count);
}
objFacebookAccount.Friends = Convert.ToInt32(fancountPage);
objFacebookAccount.FbUserId = Request["id"].ToString();
objFacebookAccount.FbUserName = Request["name"].ToString();
objFacebookAccount.Type = "page";
objFacebookAccount.UserId = user.Id;
socioprofile.Id = Guid.NewGuid();
socioprofile.ProfileDate = DateTime.Now;
socioprofile.ProfileId = Request["id"].ToString();
socioprofile.ProfileStatus = 1;
socioprofile.ProfileType = "facebook";
socioprofile.UserId = user.Id;
if (!fbrepo.checkFacebookUserExists(objFacebookAccount.FbUserId, user.Id))
{
fbrepo.addFacebookUser(objFacebookAccount);
Groups lstDetails = objGroupRepository.getGroupName(team.GroupId);
if (lstDetails.GroupName == "Socioboard")
{
TeamMemberProfile teammemberprofile = new TeamMemberProfile();
teammemberprofile.Id = Guid.NewGuid();
teammemberprofile.TeamId = team.Id;
teammemberprofile.ProfileId = objFacebookAccount.FbUserId;
teammemberprofile.ProfileType = "facebook";
teammemberprofile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfileRepository.addNewTeamMember(teammemberprofile);
}
if (!socioprofilerepo.checkUserProfileExist(socioprofile))
{
socioprofilerepo.addNewProfileForUser(socioprofile);
}
else
{
socioprofilerepo.updateSocialProfile(socioprofile);
}
}
else
{
check = "exist";
Session["alreadypageexist"] = objFacebookAccount;
fbrepo.updateFacebookUser(objFacebookAccount);
if (!socioprofilerepo.checkUserProfileExist(socioprofile))
{
socioprofilerepo.addNewProfileForUser(socioprofile);
}
else
{
socioprofilerepo.updateSocialProfile(socioprofile);
}
}
//get facebookpagefeeds
fbClient = new FacebookClient(objFacebookAccount.AccessToken);
FacebookHelper fbhelper = new FacebookHelper();
FacebookInsightStatsHelper fbiHelper = new FacebookInsightStatsHelper();
var feeds = fbClient.Get("/" + Request["id"].ToString() + "/feed");
fbiHelper.getPageImpresion(Request["id"].ToString(), user.Id, 15);
fbiHelper.getFanPageLikesByGenderAge(Request["id"].ToString(), user.Id, 15);
fbiHelper.getLocation(Request["id"].ToString(), user.Id, 15);
// fbiHelper.getFanPost("459630637383010", user.Id, 10);
dynamic profile = fbClient.Get(Request["id"].ToString());
fbhelper.getFacebookUserFeeds(feeds, profile);
//end facebookpagefeeds
string id = "id";
string value = Request["id"].ToString();
Dictionary<string, string> Did = new Dictionary<string, string>();
Did.Add(id, value);
dynamic Pageid = Did;
// var friendgenderstats=fbClient.Get("me/friends?fields=gender");
objFbHelper.getfbFriendsGenderStatsForFanPage(Pageid, user.Id, ref objFacebookAccount);
Session["fbSocial"] = null;
Response.Write(RemainingAccount(user));
}
else if (Request.QueryString["op"] == "countmessages")
{
try
{
int val = 0;
/*facebook*/
FacebookAccountRepository fbAccoutsRepo = new FacebookAccountRepository();
ArrayList lstfacebookAccounts = fbAccoutsRepo.getAllFacebookAccountsOfUser(user.Id);
foreach (FacebookAccount item in lstfacebookAccounts)
{
try
{
FacebookClient fb = new FacebookClient(item.AccessToken);
dynamic unreadcount = fb.Get("fql", new { q = "SELECT unread_count FROM mailbox_folder WHERE folder_id = 0 AND viewer_id = " + item.FbUserId + "" });
foreach (var chile in unreadcount.data)
{
var count = chile.unread_count;
int countable = Convert.ToInt32(count.ToString());
val = val + countable;
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
/*Twitter*/
Session["CountMessages"] = val;
Response.Write(val);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
else if (Request.QueryString["op"] == "recentfollowers")
{
string recentfollowers = string.Empty;
#region RecentFollowers
Users twtUsers = new Users();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
ArrayList lstAccRepo = twtAccRepo.getAllTwitterAccountsOfUser(user.Id);
oAuthTwitter oauth = null;
foreach (TwitterAccount itemTwt in lstAccRepo)
{
oauth = new oAuthTwitter();
oauth.AccessToken = itemTwt.OAuthToken;
oauth.AccessTokenSecret = itemTwt.OAuthSecret;
oauth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"];
oauth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"];
oauth.TwitterScreenName = itemTwt.TwitterScreenName;
oauth.TwitterUserId = itemTwt.TwitterUserId;
JArray jarresponse = twtUsers.Get_Followers_ById(oauth, itemTwt.TwitterUserId);
foreach (var item in jarresponse)
{
int resposecount = 0;
if (item["ids"] != null)
{
foreach (var child in item["ids"])
{
if (resposecount < 2)
{
JArray userprofile = twtUsers.Get_Users_LookUp(oauth, child.ToString());
foreach (var items in userprofile)
{
resposecount++;
try
{
recentfollowers += "<li><a href=\"https://twitter.com/" + items["screen_name"] + "\" target=\"_blank\"><img style=\"border:3px solid #FCFCFC;\" title=\"" + items["name"] + "\" width=\"48\" height=\"48\" alt=\"\" src=\"" + items["profile_image_url"] + "\"></a></li>";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
}
}
}
}
Response.Write(recentfollowers);
#endregion
}
else if (Request.QueryString["op"] == "removefollowers")
{
string removeid = Request.QueryString["removeid"];
string userid = Request.QueryString["userid"];
Friendship friendship = new Friendship();
oAuthTwitter oauth = new oAuthTwitter();
TwitterAccountRepository twtaccrepo = new TwitterAccountRepository();
TwitterAccount twtAccount = twtaccrepo.getUserInformation(user.Id, userid);
oauth.TwitterUserId = twtAccount.TwitterUserId;
oauth.TwitterScreenName = twtAccount.TwitterScreenName;
oauth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"];
oauth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"];
oauth.AccessToken = twtAccount.OAuthToken;
oauth.AccessTokenSecret = twtAccount.OAuthSecret;
JArray responseremove = friendship.Post_Friendship_Destroy(oauth, removeid);
}
//for Deleting socialqueue Message
else if (Request.QueryString["op"] == "deletequeuemsg")
{
try
{
string res = string.Empty;
string messageId = Request.QueryString["messageid"].ToString();
Guid userid = user.Id;
ScheduledMessageRepository obj = new ScheduledMessageRepository();
bool check = obj.deleteScheduleMessage(userid, messageId);
if (check == true)
{
res = "success";
}
else
{
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
//for Editing socialqueue Message
else if (Request.QueryString["op"] == "Editqueuemsg")
{
try
{
string messageId = Request.QueryString["messageid"].ToString();
string newstr = Request.QueryString["newstr"];
Guid userid = user.Id;
DateTime dt = DateTime.Now;
ScheduledMessageRepository obj = new ScheduledMessageRepository();
obj.UpdateScheduleMessage(userid, messageId, newstr, dt);
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (Request.QueryString["op"] == "wooqueuemessages")
{
string profileid = string.Empty;
ScheduledMessageRepository schmsgRepo = new ScheduledMessageRepository();
List<TeamMemberProfile> allprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile item in allprofiles)
{
profileid += item.ProfileId + ',';
}
profileid = profileid.Substring(0, profileid.Length - 1);
List<ScheduledMessage> lstschMsg = schmsgRepo.getAllMessagesDetail(profileid);
string schmessages = string.Empty;
//string profurl = string.Empty;
//if (string.IsNullOrEmpty(user.ProfileUrl))
//{
string profurls = "../Contents/img/blank_img.png";
//}
//else
//{
// // profurl = "../Contents/img/blank_img.png";
// profurl = user.ProfileUrl;
//}
if (lstschMsg.Count != 0)
{
foreach (ScheduledMessage item in lstschMsg)
try
{
UserRepository objUserRepository=new UserRepository();
User objuser = objUserRepository.getUsersById(item.UserId);
string profurl = string.Empty;
if (string.IsNullOrEmpty(objuser.ProfileUrl))
{
profurl = "../Contents/img/blank_img.png";
}
else
{
// profurl = "../Contents/img/blank_img.png";
profurl = objuser.ProfileUrl;
}
{
schmessages += "<section class=\"section\"><div class=\"js-task-cont read\">" +
"<section class=\"task-owner\">" +
"<img width=\"32\" height=\"32\" border=\"0\" src=\"" + profurl + "\" class=\"avatar\">" +
"</section>" +
"<section class=\"task-activity third\">" +
"<p>" + objuser.UserName + "</p>" +
"<div>" + CompareDateWithServerNew(item.ClientTime, item.CreateTime, item.ScheduleTime) + "</div>" +
"<input type=\"hidden\" value=\"#\" id=\"hdntaskid_1\">" +
"<p></p>" +
"</section>" +
"<section class=\"task-message font-13 third\" style=\"height: auto; width: 31%; margin-right: 9px;\"><a id=\"edit_" + item.Id + "\" onclick=\"Editqueue('" + item.Id + "','" + item.ShareMessage + "');\" class=\"tip_left\">" + gethtmlfromstring(item.ShareMessage) + "</a></section>";
if (item.ProfileType == "facebook")
{
schmessages += "<div style=\"height:70px; margin-top: 0;\" class=\"userpictiny\">" +
"<img width=\"48\" height=\"48\" src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\" alt=\"\">" +
"<a style=\"right: 2px; top: 40px;\" title=\"\" class=\"userurlpic\" href=\"#\">" +
"<img alt=\"\" src=\"../Contents/img/facebook.png\" style=\"height: 16px;width: 16x;\"></a></div>";
}
else if (item.ProfileType == "twitter")
{
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
TwitterAccount twtAccount = twtAccRepo.getUserInformation(item.ProfileId);
if (twtAccount != null)
{
schmessages += "<div style=\"height:70px; margin-top: 0;\" class=\"userpictiny\">" +
"<img width=\"48\" height=\"48\" src=\"" + twtAccount.ProfileImageUrl + "\" alt=\"\">" +
"<a style=\"right: 2px; top: 40px;\" title=\"\" class=\"userurlpic\" href=\"#\">" +
"<img alt=\"\" src=\"../Contents/img/twitter.png\" style=\"height: 16px;width: 16x;\"></a></div>";
}
}
else if (item.ProfileType == "linkedin")
{
LinkedInAccountRepository linkAccRepo = new LinkedInAccountRepository();
LinkedInAccount linkedAccount = linkAccRepo.getUserInformation(item.ProfileId);
if (linkedAccount != null)
{
schmessages += "<div style=\"height:70px; margin-top: 0;\" class=\"userpictiny\">" +
"<img width=\"48\" height=\"48\" src=\"" + linkedAccount.ProfileImageUrl + "\" alt=\"\">" +
"<a style=\"right: 2px; top: 40px;\" title=\"\" class=\"userurlpic\" href=\"#\">" +
"<img alt=\"\" src=\"../Contents/img/link.png\" style=\"height: 16px;width: 16x;\"></a></div>";
}
}
string status = (item.Status == true) ? "Completed" : "Pending";
schmessages += "<section class=\"task-status\" style=\"width:34px;\"><div class=\"ui_light floating task_status_change\">" +
//"<a href=\"#nogo\" class=\"ui-sproutmenu\"><span class=\"ui-sproutmenu-status\"><img title=\"Edit Status\" onclick=\"PerformClick(this.id)\" src=\"../Contents/img/icon_edit.png\" class=\"edit_button\" id=\"img_" + item.Id + "_" + item.Status + "\"></span></a></div></section>" +
"<a class=\"ui-sproutmenu\"><span class=\"ui-sproutmenu-status\"><img title=\"Edit Status\" onclick=\"PerformClick(this.id)\" src=\"../Contents/img/icon_edit.png\" class=\"edit_button\" id=\"img_" + item.Id + "_" + item.Status + "\"></span></a></div></section>" +
"<section class=\"task-status\" style=\"width: 65px; margin-right: 39px;\">" +
"<div class=\"ui_light floating task_status_change\">" +
"<span class=\"ui-sproutmenu-status\">" + status + "</span>" +
"</div>" +
"</section>" +
"<section class=\"task-status\" style=\"width: 65px; margin-right: 39px;\">" +
"<div class=\"ui_light floating task_status_change\">" +
"<span class=\"ui-sproutmenu-status\"><img title=\"Delete\" onclick=\"deletequeue(this.id)\" style=\"width:33px;margin-left:60px;margin-top:-10px;\" img src=\"../Contents/img/deleteimage.png\" img id=\"" + item.Id + "\"></span>" +
"</div>" +
"</section>" +
"</div></section>";
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
Response.Write(schmessages);
}
}
else
{
schmessages = "<section class=\"section\"><div class=\"js-task-cont read\"><section class=\"task-owner\">" +
"<img width=\"32\" height=\"32\" border=\"0\" class=\"avatar\" src=\"" + profurls + "\">" +
"</section><section class=\"task-activity third\"><p>" + user.UserName + "</p><div></div><p></p></section><section style=\"margin-right: 6px; width: 31%; height: auto;\" class=\"task-message font-13 third\">" +
"<a class=\"tip_left\">No Scheduled Messages</a></section><section style=\"width:113px;\" class=\"task-status\"><span class=\"ficon task_active\"></span>" +
//"<div class=\"ui_light floating task_status_change\"><a class=\"ui-sproutmenu\" href=\"#nogo\">" +
"<div class=\"ui_light floating task_status_change\"><a class=\"ui-sproutmenu\">" +
"<span class=\"ui-sproutmenu-status\"></span></a></div></section></div></section>";
}
Response.Write(schmessages);
}
else if (Request.QueryString["op"] == "drafts_messages")
{
}
else if (Request.QueryString["op"] == "updatequeue")
{
updatequeue(Request.QueryString["id"], Request.QueryString["status"]);
}
else if (Request.QueryString["op"] == "messagechk")
{
SocioBoard.Domain.Messages mstable = new SocioBoard.Domain.Messages();
string[] types = Request.QueryString["type[]"].Split(',');
DataSet ds = (DataSet)Session["MessageDataTable"];
DataSet dss = DataTableGenerator.CreateDataSetForTable(mstable);
DataTable dtt = dss.Tables[0];
DataView dv = new DataView(dtt);
AjaxMessage ajxfed = new AjaxMessage();
string message = string.Empty;
foreach (var item in types)
{
try
{
DataRow[] foundRows = ds.Tables[0].Select("Type = '" + item + "'");
foreach (var child in foundRows)
{
dtt.ImportRow(child);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
message = ajxfed.BindData(dtt);
Response.Write(message);
}
}
}