void ProcessRequest()
{
SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)Session["GroupName"];
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
FacebookAccountRepository facerepo = new FacebookAccountRepository();
LinkedInAccountRepository linkrepo = new LinkedInAccountRepository();
clsFeedsAndMessages clsfeedsandmess = new clsFeedsAndMessages();
try
{
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(team.Id);
// FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
// Session["MessageDataTable"] = ds;
// //}
// //else
// //{
// ds = (DataSet)Session["MessageDataTable"];
// // }
// string message = this.BindData(ds.Tables[0]);
// if (string.IsNullOrEmpty(message))
// {
// message = "Sorry no data !";
// }
// Response.Write(message);
//}
string[] profid = null;
if (Request.QueryString["op"] == "bindMessages")
{
try
{
string message = string.Empty;
try
{
profid = Request.QueryString["profileid[]"].Split(',');
if (Request.QueryString["type"] != null)
{
Session["countMesageDataTable_" + profid] = null;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
string facebook = string.Empty;
foreach (var item in profid)
{
if (string.IsNullOrEmpty(item))
{
facebook = "emptyprofile";
}
else
{
facebook = "profile";
}
}
if (facebook == "emptyprofile")
{
try
{
DataSet ds = null;
Session["countMesageDataTable_" + profid] = null;
ds = clsfeedsandmess.bindMessagesIntoDataTable(team.Id);
FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
Session["MessageDataTable"] = ds;
ds = (DataSet)Session["MessageDataTable"];
if (Session["countMessageDataTable"] == null)
{
Session["countMessageDataTable"] = 0;
}
int noOfDataToSkip = (int)Session["countMessageDataTable"];
DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(noOfDataToSkip + 15).CopyToDataTable();
Session["countMessageDataTable"] = noOfDataToSkip + 15;
message = this.BindData(records);//this.BindData(ds.Tables[0]);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else
{
try
{
DataSet ds = null;
Session["countMessageDataTable"] = null;
ds = clsfeedsandmess.bindFeedMessageIntoDataTable(profid);
Session["MessageDataTable"] = ds;
ds = (DataSet)Session["MessageDataTable"];
if (Session["countMesageDataTable_" + profid] == null)
{
Session["countMesageDataTable_" + profid] = 0;
}
int noOfDataToSkip = (int)Session["countMesageDataTable_" + profid];
DataTable records = ds.Tables[0].Rows.Cast<System.Data.DataRow>().Skip(noOfDataToSkip).Take(noOfDataToSkip + 15).CopyToDataTable();
Session["countMesageDataTable_" + profid] = noOfDataToSkip + 15;
message = this.BindData(records);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
if (string.IsNullOrEmpty(message))
{
}
Response.Write(message);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
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 = 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\">";
profiles += "<ul >";
/*Binding facebook profiles in Accordian*/
List<TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "facebook")
{
FacebookAccount alstfacebookprofiles = facerepo.getUserDetails(item.ProfileId);
try
{
// profiles += "<ul><li><a id=\"checkimg_" + i + "\" href=\"#\" onclick=\"checkprofile('checkimg_" + i + "','" + alstfacebookprofiles.FbUserId + "','message','facebook');\"><img src=\"../Contents/img/admin/fbicon.png\" width=\"15\" height=\"15\" alt=\"\" >" + alstfacebookprofiles.FbUserName + "</a></li>";
profiles += "<li class=\"messagetype\"><a href=\"#\"><img src=\"../Contents/img/admin/fbicon.png\" width=\"15\" height=\"15\" alt=\"\"/>" + alstfacebookprofiles.FbUserName + "</a>" +
"<img onclick=\"chkProfilemessage(this.id);\" id=\"fb_" + alstfacebookprofiles.FbUserId + "\" src=\"../Contents/img/uncheck_click.png\" alt=\"\" /></li>";
i++;
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
else if (item.ProfileType == "twitter")
{
TwitterAccount alsttwt = twtaccountrepo.getUserInformation(item.ProfileId);
try
{
//profiles += "<ul><li><a href=\"#\" id=\"checkimg_" + i + "\" onclick=\"checkprofile('checkimg_" + i + "','" + alsttwt.TwitterUserId + "','message','twitter');\"><img src=\"../Contents/img/admin/twittericon.png\" width=\"15\" height=\"15\" alt=\"\" >" + alsttwt.TwitterScreenName + "</a></li>";
profiles += "<li class=\"messagetype\"><a href=\"#\"><img src=\"../Contents/img/admin/twittericon.png\" width=\"15\" height=\"15\" alt=\"\"/>" + alsttwt.TwitterScreenName + "</a>" +
"<img onclick=\"chkProfilemessage(this.id);\" id=\"twt_" + alsttwt.TwitterUserId + "\" src=\"../Contents/img/uncheck_click.png\" alt=\"\" /></li>";
i++;
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
else if (item.ProfileType == "google")
{
GooglePlusAccountRepository gpAccRepo = new GooglePlusAccountRepository();
GooglePlusAccount alstgp = gpAccRepo.getUserDetails(item.ProfileId);
try
{
profiles += "<ul><li><a href=\"#\" id=\"checkimg_" + i + "\" onclick=\"checkprofile('checkimg_" + i + "','" + alstgp.GpUserId + "','message','googleplus');\"><img src=\"../Contents/img/google_plus.png\" width=\"15\" height=\"15\" alt=\"\" >" + alstgp.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"];
//string time = Request.QueryString["now"];
Guid idtoassign = Guid.Empty;
try
{
if (Request.QueryString["memberid"] != string.Empty)
{
idtoassign = Guid.Parse(Request.QueryString["memberid"]);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
// idtoassign = 0;
}
Tasks objTask = new Tasks();
TaskRepository objTaskRepo = new TaskRepository();
objTask.AssignDate = Request.QueryString["now"]; //DateTime.Now.ToString("yyyy-MM-dd H:mm:ss").ToString();
objTask.GroupId = team.GroupId;
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 = Request.QueryString["now"]; //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,team.GroupId);
//IEnumerable<dynamic> result = objTeam.getAllTeamsOfUser(user.Id, team.GroupId);
BusinessSettingRepository objBsnsSettingRepo = new BusinessSettingRepository();
BusinessSetting objbsns = objBsnsSettingRepo.IsNotificationTaskEnable(team.GroupId);
if (objbsns.AssigningTasks == true || team.UserId == user.Id)
{
IEnumerable<dynamic> result = objTeam.getAllTeamsOfUser(user.Id, team.GroupId, user.EmailId);
foreach (Team item in result)
{
try
{
//===========================new code added=========================
UserRepository objUserRepository = new UserRepository();
User objdetails = objUserRepository.getUserInfoByEmail(item.EmailId);
if (objdetails != null)
{
message += "<li><a>";
if (objdetails.ProfileUrl == null)
{
message += "<img src=\"../Contents/img/blank_img.png\" alt=\"\" />";
}
else
{
message += "<img src=\"" + objdetails.ProfileUrl + "\" alt=\"\" />";
}
message += "<span class=\"name\">" +
objdetails.UserName +
"</span>" +
" <span>" +
"<input id=\"customerid_" + objdetails.Id + "\" type=\"radio\" name=\"team_members\" value=\"customerid_" + objdetails.Id + "\">" +
"</span>" +
"</a></li>";
//message += "<li><a>";
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
}
// message += "<li><a>";
if (string.IsNullOrEmpty(user.ProfileUrl))
{
message += "<li><a>";
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"] == "sentmsg")
{
ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
string message = string.Empty;
// message += "<ul id=\"message-list\">";
try
{
List<TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile items in alstprofiles)
{
List<ScheduledMessage> result = objScheduledMessageRepository.getAllSentMessagesOfUser(items.ProfileId);
int sorteddatacount = 0;
if (result != null && result.Count > 0)
{
foreach (ScheduledMessage item in result)
{
try
{
//message += "<ul id=\"message-list\">";
//message += "<li>";
sorteddatacount++;
if (item.ProfileType == "twitter")
{
message += "<ul id=\"message-list\">";
message += "<li>";
TwitterAccountRepository objTwitterAccountRepository = new TwitterAccountRepository();
TwitterAccount objTwitterAccount = objTwitterAccountRepository.getUserInformation(item.ProfileId);
if (string.IsNullOrEmpty(item.PicUrl))
{
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:60px;float:left\"><img href=\"http://twitter.com/" + objTwitterAccount.TwitterScreenName + "\" target=\"_blank\" id=\"formprofileurl_" + sorteddatacount + "\" src=\"" + objTwitterAccount.ProfileImageUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<a href=\"http://twitter.com/" + objTwitterAccount.TwitterScreenName + "\" target=\"_blank\" 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.ShareMessage + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"http://twitter.com/" + objTwitterAccount.TwitterScreenName + "\" target=\"_blank\" id=\"rowname_" + sorteddatacount + "\" >" + objTwitterAccount.TwitterScreenName + "</a> " + item.CreateTime + "</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>";
"</div></div></div></div></li>";
}
else if(!string.IsNullOrEmpty(item.PicUrl))
{
string src = item.PicUrl;
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:60px;float:left\"><img href=\"http://twitter.com/" + objTwitterAccount.TwitterScreenName + "\" target=\"_blank\" id=\"formprofileurl_" + sorteddatacount + "\" src=\"" + objTwitterAccount.ProfileImageUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<a href=\"http://twitter.com/" + objTwitterAccount.TwitterScreenName + "\" target=\"_blank\" 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><img style=\"margin-right:10px;margin-top:10px\" width=\"80px;\" hight=\"80px;\" src=\"" + src + "\">" + item.ShareMessage + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"http://twitter.com/" + objTwitterAccount.TwitterScreenName + "\" target=\"_blank\" id=\"rowname_" + sorteddatacount + "\" >" + objTwitterAccount.TwitterScreenName + "</a> " + item.CreateTime + "</span>" +
"<div class=\"scl\">" +
"</div></div></div></div></li>";
}
message += "</ul>";
}
else if (item.ProfileType == "facebook")
{
message += "<ul id=\"message-list\">";
message += "<li>";
FacebookAccountRepository objFacebookAccountRepository = new FacebookAccountRepository();
FacebookAccount objFacebookAccount = objFacebookAccountRepository.getFacebookAccountDetailsById(item.ProfileId);
if (objFacebookAccount != null)
{
if (string.IsNullOrEmpty(item.PicUrl))
{
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:60px;float:left\"><img href=\"http://www.facebook.com/" + objFacebookAccount.FbUserId + "\" target=\"_blank\" id=\"formprofileurl_" + sorteddatacount + "\" src=\"http://graph.facebook.com/" + objFacebookAccount.FbUserId + "/picture?type=small\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<a href=\"http://www.facebook.com/" + objFacebookAccount.FbUserId + "\" target=\"_blank\" 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.ShareMessage + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"http://www.facebook.com/" + objFacebookAccount.FbUserId + "\" target=\"_blank\" id=\"rowname_" + sorteddatacount + "\" >" + objFacebookAccount.FbUserName + "</a> " + item.CreateTime + "</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>";
"</div></div></div></div></li>";
}
else if (!string.IsNullOrEmpty(item.PicUrl))
{
string src = item.PicUrl;
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:60px;float:left\"><img href=\"http://www.facebook.com/" + objFacebookAccount.FbUserId + "\" target=\"_blank\" id=\"formprofileurl_" + sorteddatacount + "\" src=\"http://graph.facebook.com/" + objFacebookAccount.FbUserId + "/picture?type=small\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<a href=\"http://www.facebook.com/" + objFacebookAccount.FbUserId + "\" target=\"_blank\" 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><img style=\"margin-right:10px;margin-top:10px\" width=\"80px;\" hight=\"80px;\" src=\"" + src + "\">" + item.ShareMessage + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"http://www.facebook.com/" + objFacebookAccount.FbUserId + "\" target=\"_blank\" id=\"rowname_" + sorteddatacount + "\" >" + objFacebookAccount.FbUserName + "</a> " + item.CreateTime + "</span>" +
"<div class=\"scl\">" +
"</div></div></div></div></li>";
}
message += "</ul>";
}
}
else if (item.ProfileType == "linkedin")
{
message += "<ul id=\"message-list\">";
message += "<li>";
LinkedInAccountRepository objLinkedInAccountRepository = new LinkedInAccountRepository();
LinkedInAccount objLinkedInAccount = objLinkedInAccountRepository.getLinkedinAccountDetailsById(item.ProfileId);
if (objLinkedInAccount != null)
{
if (string.IsNullOrEmpty(item.PicUrl))
{
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:60px;float:left\"><img id=\"formprofileurl_" + sorteddatacount + "\" src=\"" + objLinkedInAccount.ProfileImageUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<span class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/link_icon.png\" width=\"16\" height=\"16\" alt=\"\" ></span></div>" +
"</div><div id=\"messagedescription_" + sorteddatacount + "\" class=\"message-list-content\"><div id=\"msgdescription_" + sorteddatacount + "\" style=\"width:500px;height:auto;float:left\"><p>" + item.ShareMessage + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"" + objLinkedInAccount.ProfileUrl + "\" target=\"_blank\" id=\"rowname_" + sorteddatacount + "\" >" + objLinkedInAccount.LinkedinUserName + "</a> " + item.CreateTime + "</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>";
"</div></div></div></div></li>";
}
else if (!string.IsNullOrEmpty(item.PicUrl))
{
string src = item.PicUrl;
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:60px;float:left\"><img id=\"formprofileurl_" + sorteddatacount + "\" src=\"" + objLinkedInAccount.ProfileImageUrl + "\" height=\"48\" width=\"48\" alt=\"\" title=\"\" />" +
"<span class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/link_icon.png\" width=\"16\" height=\"16\" alt=\"\" ></span></div>" +
"</div><div id=\"messagedescription_" + sorteddatacount + "\" class=\"message-list-content\"><div id=\"msgdescription_" + sorteddatacount + "\" style=\"width:500px;height:auto;float:left\"><p><img style=\"margin-right:10px;margin-top:10px\" width=\"80px;\" hight=\"80px;\" src=\"" + src + "\">" + item.ShareMessage + "</p>" +
"<div class=\"message-list-info\"><span><a href=\"" + objLinkedInAccount.ProfileUrl + "\" target=\"_blank\" id=\"rowname_" + sorteddatacount + "\" >" + objLinkedInAccount.LinkedinUserName + "</a> " + item.CreateTime + "</span>" +
"<div class=\"scl\">" +
"</div></div></div></div></li>";
}
message += "</ul>";
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
}
// message += "</ul>";
}
else
{
// message = "Sorry no data !";
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
Response.Write(message);
}
else if (Request.QueryString["op"] == "bindarchive")
{
ArchiveMessageRepository objArchiveRepo = new ArchiveMessageRepository();
string message = string.Empty;
try
{
List<TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile items in alstprofiles)
{
List<ArchiveMessage> result = objArchiveRepo.getAllArchiveMessage(items.ProfileId);
int sorteddatacount = 0;
if (result != null && result.Count > 0)
{
foreach (ArchiveMessage item in result)
{
try
{
message += "<ul id=\"message-list\">";
message += "<li>";
sorteddatacount++;
if (item.SocialGroup == "twitter")
{
message += "<div id=\"messagetaskable_" + sorteddatacount + "\" class=\"userpictiny\"><div style=\"width:60px;height:60px;float:left\"><img id=\"formprofileurl_" + sorteddatacount + "\" onclick=\"detailsdiscoverytwitter(" + item.ProfileId + ");\" 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=\"\" onclick=\"detailsdiscoverytwitter(\"item.ProfileId\");\"></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=\"detailsdiscoverytwitter(" + item.ProfileId + ");\">" + item.UserName + "</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>";
"<a><img onclick=replyfunction(" + sorteddatacount + ",'twitter','" + item.MessageId + "','" + item.ProfileId + "') 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:60px;float:left\"><img id=\"formprofileurl_" + sorteddatacount + "\" onclick=\"getFacebookProfiles(" + item.ProfileId + ");\" 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=\"\" onclick=\"getFacebookProfiles(\"item.ProfileId\");\"></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.UserName + "</a> " + item.CreatedDateTime + "</span>" +
"<div class=\"scl\">" +
"<a><img onclick=replyfunction(" + sorteddatacount + ",'facebook','" + item.MessageId + "','" + item.ProfileId + "') title=\"Comment\" src=\"../Contents/img/admin/goto.png\" width=\"12\" height=\"12\" alt=\"\"/></a></div></div></div></div></li>";
//"<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:60px;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=\"\" onclick=\"detailsprofile(this.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 href=\"#\"><img title=\"Comment\" src=\"../Contents/img/admin/goto.png\" width=\"12\" height=\"12\" alt=\"\"/></a></div></div></div></div></li>";
//"<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>";
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
}
//message += "</ul>";
}
else
{
// message = "Sorry no data !";
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
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 = Convert.ToDateTime(Request.QueryString["CreatedTime"]);
am.MessageId = Request.QueryString["MessageId"];
am.ProfileId = Request.QueryString["ProfileId"];
am.UserName = Request.QueryString["Username"];
am.UserId = use.Id;
// Server.UrlDecode((string)jo["CreatedTime"]);
if (am.UserName != string.Empty)
{
if (!objArchiveRepo.checkArchiveMessageExists(user.Id, am.MessageId))
{
objArchiveRepo.AddArchiveMessage(am);
Response.Write("Message Archive Successfully");
}
else
{
Response.Write("Message Already in Archive");
}
}
}
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);
// }
//}
else if (Request.QueryString["op"] == "updatedstatus")
{
try
{
int i = 0;
int j=0;
List<TeamMemberProfile> alstprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile item in alstprofiles)
{
if (item.ProfileType == "twitter")
{
TwitterMessageRepository twtmsgRepo = new TwitterMessageRepository();
i = twtmsgRepo.updateMessageStatus(item.ProfileId);
}
else if (item.ProfileType == "facebook")
{
FacebookFeedRepository fbfeedRepo = new FacebookFeedRepository();
j = fbfeedRepo.updateMessageStatus(item.ProfileId);
}
}
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(team.Id);
FacebookFeedRepository fbFeedRepo = new FacebookFeedRepository();
Session["MessageDataTable"] = ds;
}
else
{
ds = (DataSet)Session["MessageDataTable"];
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
}
public string ProfilesConnected(string UserId)
{
try
{
Guid userid = Guid.Parse(UserId);
SocialProfilesRepository socialRepo = new SocialProfilesRepository();
List<SocialProfile> lstsocioprofile = socialRepo.getAllSocialProfilesOfUser(userid);
List<profileConnected> lstProfile = new List<profileConnected>();
foreach (SocialProfile sp in lstsocioprofile)
{
profileConnected pc = new profileConnected();
pc.Id = sp.Id;
pc.ProfileDate = sp.ProfileDate;
pc.ProfileId = sp.ProfileId;
pc.ProfileStatus = sp.ProfileStatus;
pc.ProfileType = sp.ProfileType;
pc.UserId = sp.UserId;
if (sp.ProfileType == "facebook")
{
try
{
FacebookAccountRepository objFbAccRepo = new FacebookAccountRepository();
FacebookAccount objFbAcc = objFbAccRepo.getUserDetails(sp.ProfileId);
pc.ProfileName = objFbAcc.FbUserName;
pc.ProfileImgUrl = "http://graph.facebook.com/" + sp.ProfileId + "/picture?type=small";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (sp.ProfileType == "twitter")
{
try
{
TwitterAccountRepository objTwtAccRepo = new TwitterAccountRepository();
TwitterAccount objTwtAcc = objTwtAccRepo.getUserInfo(sp.ProfileId);
pc.ProfileName = objTwtAcc.TwitterScreenName;
pc.ProfileImgUrl = objTwtAcc.ProfileImageUrl;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (sp.ProfileType == "instagram")
{
try
{
InstagramAccountRepository objInsAccRepo = new InstagramAccountRepository();
InstagramAccount objInsAcc = objInsAccRepo.getInstagramAccountById(sp.ProfileId);
pc.ProfileName = objInsAcc.InsUserName;
pc.ProfileImgUrl = objInsAcc.ProfileUrl;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (sp.ProfileType == "linkedin")
{
try
{
LinkedInAccountRepository objLiAccRepo = new LinkedInAccountRepository();
LinkedInAccount objLiAcc = objLiAccRepo.getLinkedinAccountDetailsById(sp.ProfileId);
pc.ProfileName = objLiAcc.LinkedinUserName;
pc.ProfileImgUrl = objLiAcc.ProfileImageUrl;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (sp.ProfileType == "googleplus")
{
try
{
GooglePlusAccountRepository objGpAccRepo = new GooglePlusAccountRepository();
GooglePlusAccount objGpAcc = objGpAccRepo.getUserDetails(sp.ProfileId);
pc.ProfileName = objGpAcc.GpUserName;
pc.ProfileImgUrl = objGpAcc.GpProfileImage;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
lstProfile.Add(pc);
}
return new JavaScriptSerializer().Serialize(lstProfile);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return new JavaScriptSerializer().Serialize("Please Try Again");
}
}