public void getFanPageLikesByGenderAge(string pageId, Guid UserId, int days)
{
try
{
string strAge = "https://graph.facebook.com/" + pageId + "/insights/page_fans_gender_age";
FacebookClient fb = new FacebookClient();
FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
FacebookAccount acc = fbAccRepo.getUserDetails(pageId);
fb.AccessToken = acc.AccessToken;
///////////////////////////////////////////////////
// string codedataurlgraphic = objAuthentication.RequestUrl(strAge, strToken);
//if (txtDateSince.Text != "")
// strAge = strAge + "&since=" + txtDateSince.Text;
//if (txtDateUntill.Text != "")
// strAge = strAge + "&until=" + txtDateUntill.Text;
JsonObject outputreg = (JsonObject)fb.Get(strAge);
JArray data = (JArray)JsonConvert.DeserializeObject(outputreg["data"].ToString());
FacebookInsightStats objFbi = new FacebookInsightStats();
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
foreach (var item in data)
{
var values = item["values"];
foreach (var age in values)
{
var ageVal = age["value"];
var agevalarray = ageVal.ToString().Substring(1, ageVal.ToString().Length - 2).Split(',');
for (int i = 0; i < agevalarray.Count(); i++)
{
var genderagearray = agevalarray[i].Split(':');
var gender = genderagearray[0].Split('.');
objFbi.AgeDiff = gender[1].Trim();
objFbi.Gender = gender[0].Trim();
objFbi.EntryDate = DateTime.Now;
objFbi.FbUserId = pageId;
objFbi.Id = Guid.NewGuid();
objFbi.PeopleCount = int.Parse(genderagearray[1]);
objFbi.UserId = UserId;
objFbi.CountDate = age["end_time"].ToString();
if (!objfbiRepo.checkFacebookInsightStatsExists(pageId, UserId, age["end_time"].ToString(), gender[1].Trim()))
objfbiRepo.addFacebookInsightStats(objFbi);
else
objfbiRepo.updateFacebookInsightStats(objFbi);
}
// strFbAgeArray=strFbAgeArray+
}
}
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
public void getPageImpresion(string pageId, Guid UserId, int days)
{
try
{
string strAge = "https://graph.facebook.com/" + pageId + "/insights/page_impressions/day";
FacebookClient fb = new FacebookClient();
FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
FacebookAccount acc = fbAccRepo.getUserDetails(pageId);
fb.AccessToken = acc.AccessToken;
JsonObject outputreg = (JsonObject)fb.Get(strAge);
JArray data = (JArray)JsonConvert.DeserializeObject(outputreg["data"].ToString());
FacebookInsightStats objFbi = new FacebookInsightStats();
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
foreach (var item in data)
{
var values = item["values"];
foreach (var age in values)
{
objFbi.EntryDate = DateTime.Now;
objFbi.FbUserId = pageId;
objFbi.Id = Guid.NewGuid();
objFbi.PageImpressionCount = int.Parse( age["value"].ToString());
objFbi.UserId = UserId;
objFbi.CountDate = age["end_time"].ToString();
if (!objfbiRepo.checkFbIPageImprStatsExists(pageId, UserId, age["end_time"].ToString()))
objfbiRepo.addFacebookInsightStats(objFbi);
else
objfbiRepo.updateFacebookInsightStats(objFbi);
}
}
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
public string getStoriesCount(string fbUserId, int days)
{
string strStoriescount = string.Empty;
string strStories = string.Empty;
string strDate = string.Empty;
try
{
FacebookInsightStatsRepository objfbiRepo1 = new FacebookInsightStatsRepository();
ArrayList arrList = objfbiRepo1.getFacebookInsightStatsById(fbUserId, days);
//foreach (var item in arrList)
//{
// Array temp = (Array)item;
// if (temp.GetValue(7) != null)
// {
// strDate = strDate + temp.GetValue(10) + ",";
// strStories = strStories + temp.GetValue(7) + ",";
// }
//}
//if (arrList.Count < 7)
//{
// for (int i = 0; i < 7 - arrList.Count; i++)
// {
// strStories = strStories + "0,";
// strDate = strDate + " ,";
// }
//}
for (int i = 0; i < 10; i++)
{
strDate += RandomDay() + ",";
strStories += getrandomno() + ",";
System.Threading.Thread.Sleep(10);
}
strStoriescount = strDate.Substring(0, strDate.Length - 1) + "@" + strStories.Substring(0, strStories.Length - 1);
//strStoriescount = strDate.Substring(0, strDate.Length - 1) + "@" + strStories.Substring(0, strStories.Length - 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
return strStoriescount;
}
public string getLikesByGenderAge(string fbUserId, int days)
{
string strFbAgeArray = string.Empty;
try
{
string strAgem = "0,";
string strAgef = "0,";
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
ArrayList arrList = objfbiRepo.getFacebookInsightStatsAgeWiseById(fbUserId, days);
strFbAgeArray = "[";
foreach (var item in arrList)
{
Array temp = (Array)item;
if (temp.GetValue(3) != null)
{
string strmVal = "0", strfVal = "0";
if (temp.GetValue(3).ToString().Contains("M"))
{
strmVal = temp.GetValue(6).ToString();
strfVal = "0";
}
if (temp.GetValue(3).ToString().Contains("F"))
{
strfVal = temp.GetValue(6).ToString();
strmVal = "0";
}
strFbAgeArray = strFbAgeArray + "[" + strmVal + "," + strfVal + "],";
}
}
if (arrList.Count < days)
{
for (int i = 0; i < days - arrList.Count; i++)
{
strFbAgeArray = strFbAgeArray + "[0,0],";
}
}
strFbAgeArray = strFbAgeArray.Substring(0, strFbAgeArray.Length - 1) + "]";
// strFbAgeArray = strAgem.Substring(0, strAgem.Length - 1) + "@" + strAgef.Substring(0, strAgef.Length - 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
return strFbAgeArray;
}
public string getLocationInsight(string fbUserId, int days)
{
string strLocationArray = string.Empty;
try
{
string strlocation = string.Empty;
string strcount = string.Empty;
string previousDate = string.Empty;
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
ArrayList arrList = objfbiRepo.getFacebookInsightStatsLocationById(fbUserId, days);
foreach (var item in arrList)
{
Array temp = (Array)item;
if (temp.GetValue(5) != null && temp.GetValue(6) != null)
{
strlocation = strlocation + temp.GetValue(5).ToString().Replace("\r\n \"", " ").Replace('"', ' ').Trim() + ",";
strcount = strcount + temp.GetValue(6) + ",";
}
}
if (arrList.Count == 0)
{
for (int i = 0; i < 7; i++)
{
strlocation += "0,";
strcount += "0,";
}
}
strLocationArray = strlocation.Substring(0, strlocation.Length - 1) + "@" + strcount.Substring(0, strcount.Length - 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
return strLocationArray;
}
public void getLocation(string pageId, Guid UserId, int days)
{
try
{
string strStories = "https://graph.facebook.com/" + pageId + "/insights/page_fans_country";
FacebookClient fb = new FacebookClient();
FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
FacebookAccount acc = fbAccRepo.getUserDetails(pageId);
fb.AccessToken = acc.AccessToken;
JsonObject outputreg = (JsonObject)fb.Get(strStories);
JArray data = (JArray)JsonConvert.DeserializeObject(outputreg["data"].ToString());
FacebookInsightStats objFbi = new FacebookInsightStats();
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
foreach (var item in data)
{
var values = item["values"];
foreach (var loc in values)
{
var locVal = loc["value"];
var locvalarray = locVal.ToString().Substring(1, locVal.ToString().Length - 2).Split(',');
for (int i = 0; i < locvalarray.Count(); i++)
{
var locationarr = locvalarray[i].Split(':');
objFbi.EntryDate = DateTime.Now;
objFbi.FbUserId = pageId;
objFbi.Id = Guid.NewGuid();
objFbi.Location = locationarr[0].ToString();
objFbi.PeopleCount = int.Parse(locationarr[1].ToString());
objFbi.UserId = UserId;
objFbi.CountDate = loc["end_time"].ToString();
if (!objfbiRepo.checkFbILocationStatsExists(pageId, UserId, loc["end_time"].ToString(), locationarr[0].ToString()))
objfbiRepo.addFacebookInsightStats(objFbi);
else
objfbiRepo.updateFacebookInsightStats(objFbi);
}
}
}
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
//public void getPageImpresion(string pageId, Guid UserId, int days)
//{
// try
// {
// string strAge = "https://graph.facebook.com/" + pageId + "/insights/page_impressions/day";
// FacebookClient fb = new FacebookClient();
// FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
// FacebookAccount acc = fbAccRepo.getUserDetails(pageId);
// fb.AccessToken = acc.AccessToken;
// JsonObject outputreg = (JsonObject)fb.Get(strAge);
// JArray data = (JArray)JsonConvert.DeserializeObject(outputreg["data"].ToString());
// FacebookInsightStats objFbi = new FacebookInsightStats();
// FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
// foreach (var item in data)
// {
// var values = item["values"];
// foreach (var age in values)
// {
// objFbi.EntryDate = DateTime.Now;
// objFbi.FbUserId = pageId;
// objFbi.Id = Guid.NewGuid();
// objFbi.PageImpressionCount = int.Parse(age["value"].ToString());
// objFbi.UserId = UserId;
// objFbi.CountDate = age["end_time"].ToString();
// if (!objfbiRepo.checkFbIPageImprStatsExists(pageId, UserId, age["end_time"].ToString()))
// objfbiRepo.addFacebookInsightStats(objFbi);
// else
// objfbiRepo.updateFacebookInsightStats(objFbi);
// }
// }
// }
// catch (Exception Err)
// {
// Console.Write(Err.StackTrace);
// }
//}
public void getPageImpresion(string pageId, Guid UserId, int days)
{
JsonObject outputreg = new JsonObject();
try
{
int count = 0;
string nextpage = string.Empty;
string prevpage = string.Empty;
string strAge = string.Empty;
if (count == 0)
{
strAge = "https://graph.facebook.com/" + pageId + "/insights/page_impressions/day";
}
else
{
strAge = prevpage;
}
FacebookClient fb = new FacebookClient();
FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
for (int i = 0; i < 11; i++)
{
if (count > 0)
{
strAge = prevpage;
}
FacebookAccount acc = fbAccRepo.getUserDetails(pageId);
fb.AccessToken = acc.AccessToken;
outputreg = (JsonObject)fb.Get(strAge);
JArray data = (JArray)JsonConvert.DeserializeObject(outputreg["data"].ToString());
//code written by abhay
JObject data1 = (JObject)JsonConvert.DeserializeObject(outputreg["paging"].ToString());
if (count == 0)
{
prevpage = data1["previous"].ToString();
nextpage = data1["next"].ToString();
//End of block
FacebookInsightStats objFbi = new FacebookInsightStats();
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
foreach (var item in data)
{
var values = item["values"];
foreach (var age in values)
{
//objFbi.EntryDate = DateTime.Now;
objFbi.EntryDate = Convert.ToDateTime(age["end_time"].ToString());
objFbi.FbUserId = pageId;
objFbi.Id = Guid.NewGuid();
objFbi.PageImpressionCount = int.Parse(age["value"].ToString());
objFbi.UserId = UserId;
objFbi.CountDate = age["end_time"].ToString();
if (!objfbiRepo.checkFbIPageImprStatsExists(pageId, UserId, age["end_time"].ToString()))
objfbiRepo.addFacebookInsightStats(objFbi);
else
objfbiRepo.updateFacebookInsightStats(objFbi);
}
}
count++;
}
else
{
count++;
prevpage = data1["previous"].ToString();
// nextpage = data1["next"].ToString();
//End of block
FacebookInsightStats objFbi = new FacebookInsightStats();
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
foreach (var item in data)
{
var values = item["values"];
foreach (var age in values)
{
//objFbi.EntryDate = DateTime.Now;
objFbi.EntryDate = Convert.ToDateTime(age["end_time"].ToString());
objFbi.FbUserId = pageId;
objFbi.Id = Guid.NewGuid();
objFbi.PageImpressionCount = int.Parse(age["value"].ToString());
objFbi.UserId = UserId;
objFbi.CountDate = age["end_time"].ToString();
if (!objfbiRepo.checkFbIPageImprStatsExists(pageId, UserId, age["end_time"].ToString()))
objfbiRepo.addFacebookInsightStats(objFbi);
else
objfbiRepo.updateFacebookInsightStats(objFbi);
}
}
}
}
outputreg = (JsonObject)fb.Get(nextpage);
JArray newdata = (JArray)JsonConvert.DeserializeObject(outputreg["data"].ToString());
JObject newdata1 = (JObject)JsonConvert.DeserializeObject(outputreg["paging"].ToString());
FacebookInsightStats objFbi1 = new FacebookInsightStats();
FacebookInsightStatsRepository objfbiRepo1 = new FacebookInsightStatsRepository();
foreach (var item in newdata)
{
var values = item["values"];
foreach (var age in values)
{
//objFbi1.EntryDate = DateTime.Now;
objFbi1.EntryDate = Convert.ToDateTime(age["end_time"].ToString());
objFbi1.FbUserId = pageId;
objFbi1.Id = Guid.NewGuid();
objFbi1.PageImpressionCount = int.Parse(age["value"].ToString());
objFbi1.UserId = UserId;
objFbi1.CountDate = age["end_time"].ToString();
if (Convert.ToDateTime(age["end_time"].ToString()) > DateTime.Now)
break;
if (!objfbiRepo1.checkFbIPageImprStatsExists(pageId, UserId, age["end_time"].ToString()))
objfbiRepo1.addFacebookInsightStats(objFbi1);
else
objfbiRepo1.updateFacebookInsightStats(objFbi1);
}
}
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
}
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;
}
public void ProcessRequest()
{
SocialProfilesRepository socio = new SocialProfilesRepository();
List<SocialProfile> alstsocioprofiles = new List<SocialProfile>();
if (!string.IsNullOrEmpty(Request.QueryString["op"]))
{
SocioBoard.Domain.User user = (SocioBoard.Domain.User)Session["LoggedUser"];
if (Request.QueryString["op"] == "social_connectivity")
{
alstsocioprofiles = socio.getAllSocialProfilesOfUser(user.Id);
string profiles = string.Empty;
profiles += "<ul class=\"rsidebar-profile\">";
foreach (SocialProfile item in alstsocioprofiles)
{
try
{
if (item.ProfileType == "facebook")
{
try
{
FacebookAccountRepository facerepo = new FacebookAccountRepository();
FacebookAccount faceaccount = facerepo.getFacebookAccountDetailsById(item.ProfileId, user.Id);
if (faceaccount != null)
{
if (item.ProfileStatus == 2)
{
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=\"../Contents/img/remove.png\" height=\"48\" width=\"48\" alt=\"\" title=\"Access token expire Please remove your account and add again\" /></a>" +
"<a href=\"#\" class=\"userurlpic\" title=\"\"><img src=\"../Contents/img/rmeove.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 + "','" + 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 == "twitter")
{
try
{
TwitterAccountRepository twtrepo = new TwitterAccountRepository();
SocioBoard.Domain.TwitterAccount twtaccount = twtrepo.getUserInformation(user.Id, 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(user.Id, 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, user.Id);
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(user.Id);
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\">" +
"</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.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)
{
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 (SocialProfile 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, user.Id);
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;
}
mess = mess.PadLeft(15);
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);
}
}
if (item.ProfileType == "googleplus")
{
}
else if (item.ProfileType == "twitter")
{
TwitterAccountRepository twtrepo = new TwitterAccountRepository();
SocioBoard.Domain.TwitterAccount twtaccount = twtrepo.getUserInformation(user.Id, 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.TwitterScreenName + "');\" 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;
}
ms = ms.PadLeft(15);
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 == "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(user.Id, 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;
}
ms = ms.PadLeft(15);
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, user.Id);
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")
{
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 delacc = fbrepo.deleteFacebookUser(profileid, user.Id);
if (delacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid);
if (lstsocioprofile.Count >= 0)
{
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);
FacebookInsightStatsRepository fbInsightStats = new FacebookInsightStatsRepository();
fbInsightStats.deleteFacebookInsightStats(profileid, user.Id);
}
else
{
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);
FacebookInsightStatsRepository fbInsightStats = new FacebookInsightStatsRepository();
fbInsightStats.deleteFacebookInsightStats(profileid, user.Id);
}
}
}
catch (Exception exx)
{
Console.WriteLine(exx.Message);
logger.Error(exx.Message);
}
}
else if (Profiletype == "twt")
{
try
{
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
int deltwtacc = twtaccountrepo.deleteTwitterUser(user.Id, profileid);
if (deltwtacc > 0)
{
socioprofilerepo.deleteProfile(user.Id, profileid);
List<SocialProfile> lstsocioprofile = socioprofilerepo.checkProfileExistsMoreThanOne(profileid);
if (lstsocioprofile.Count >= 0)
{
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);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.Message);
}
}
else if (Profiletype == "linkedin")
{
try
{
LinkedInAccountRepository linkedaccrepo = new LinkedInAccountRepository();
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)
{
LinkedInFeedRepository linkedfeedrepo = new LinkedInFeedRepository();
int s = linkedfeedrepo.deleteAllFeedsOfUser(profileid, user.Id);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (Profiletype == "instagram")
{
try
{
InstagramAccountRepository insaccrepo = new InstagramAccountRepository();
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)
{ }
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
else if (Profiletype == "googleplus")
{
try
{
GooglePlusAccountRepository googleplusaccrepo = new GooglePlusAccountRepository();
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;
if (Session["profilesforcomposemessage"] == null)
{
profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">";
/*facebook users binding*/
FacebookAccountRepository fbrepo = new FacebookAccountRepository();
ArrayList lstfbaccounts = fbrepo.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)
{
if (fbacc.IsActive != 2)
{
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>";
/*twitter users binding*/
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
ArrayList alsttwtaccounts = twtaccountrepo.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 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>";
/*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 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>";
Session["profilesforcomposemessage"] = profiles;
}
else
{
profiles = (string)Session["profilesforcomposemessage"];
}
Response.Write(profiles);
}
else if (Request.QueryString["op"] == "MasterComposesc")
{
string profiles = string.Empty;
if (Session["profilesforcomposemessage"] == null)
{
profiles += "<div class=\"drop_top\"></div><div class=\"drop_mid\">";
/*facebook users binding*/
FacebookAccountRepository fbrepo = new FacebookAccountRepository();
ArrayList lstfbaccounts = fbrepo.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 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>";
/*twitter users binding*/
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
ArrayList alsttwtaccounts = twtaccountrepo.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 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>";
/*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 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>";
Session["profilesforcomposemessage"] = profiles;
}
else
{
profiles = (string)Session["profilesforcomposemessage"];
}
Response.Write(profiles);
}
else if (Request.QueryString["op"] == "sendmessage")
{
string messagecount = string.Empty;
string message = Request.QueryString["message"];
//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");
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
{
FacebookAccountRepository fbaccountrepo = new FacebookAccountRepository();
FacebookAccount fbaccount = fbaccountrepo.getFacebookAccountDetailsById(networkingwithid[1], user.Id);
var args = new Dictionary<string, object>();
args["message"] = message;
// args["message"] = "Abhay"+i.ToString();
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();
}
if (facebookpost.ToString() != string.Empty)
{
Response.Write("Succesfully posted");
}
else
{
Response.Write("Not posted");
}
}
catch (Exception ex)
{
FacebookAccount objFacebookAccount = new FacebookAccount();
FacebookAccountRepository objFacebookAccountRepository = new FacebookAccountRepository();
objFacebookAccount.FbUserId=networkingwithid[1];
objFacebookAccount.UserId=user.Id;
objFacebookAccount.IsActive=2;
objFacebookAccountRepository.updateFacebookUserStatus(objFacebookAccount);
SocialProfile objSocialProfile = new SocialProfile();
SocialProfilesRepository objSocialProfilesRepository = new SocialProfilesRepository();
logger.Error(ex.Message);
string errormsg =ex.Message;
if(errormsg.Contains("access token"))
{
objSocialProfile.UserId = user.Id;
objSocialProfile.ProfileId = networkingwithid[1];
objSocialProfile.ProfileStatus = 2;
objSocialProfilesRepository.updateSocialProfileStatus(objSocialProfile);
Response.Write(ex.Message);
}
Console.WriteLine(ex.Message);
}
}
else if (networkingwithid[0] == "twt")
{
try
{
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
SocioBoard.Domain.TwitterAccount twtaccount = twtaccountrepo.getUserInformation(user.Id, 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(user.Id, 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);
}
}
string profiletype="";
if(networkingwithid[0] == "fb")
{
profiletype="facebook";
}
else if(networkingwithid[0] == "twt")
{
profiletype="twitter";
}
else if(networkingwithid[0] == "lin")
{
profiletype="linkedin";
}
ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
ScheduledMessage objScheduledMessage = new ScheduledMessage();
objScheduledMessage.ShareMessage = message;
objScheduledMessage.ClientTime = DateTime.Now;
objScheduledMessage.ScheduleTime = DateTime.Now;
objScheduledMessage.CreateTime = DateTime.Now;
objScheduledMessage.Status = true;
objScheduledMessage.UserId = user.Id;
objScheduledMessage.ProfileType = profiletype;
objScheduledMessage.ProfileId = networkingwithid[1];
objScheduledMessageRepository.addNewMessage(objScheduledMessage);
messagecount = objScheduledMessageRepository.getAllSentMessagesOfUser(user.Id).Count().ToString();
}
// = 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);
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);
}
Response.Write("<script>alert(\"This Page is Already Added please add another Page!\");</script>");
}
//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
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")
{
ScheduledMessageRepository schmsgRepo = new ScheduledMessageRepository();
List<ScheduledMessage> lstschMsg = schmsgRepo.getAllMessagesOfUser(user.Id);
string schmessages = string.Empty;
string profurl = string.Empty;
if (string.IsNullOrEmpty(user.ProfileUrl))
{
profurl = "../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
{
{
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>" + user.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: 20%; margin-right: 9px;\"><a id=\"edit_" + item.Id + "\" onclick=\"Editqueue('" + item.Id + "','" + item.ShareMessage + "','" + item.ProfileType + "');\" 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(user.Id, 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(user.Id, 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: 150px; margin-right: 45px;\">" +
"<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;cursor:pointer;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=\"" + profurl + "\">" +
"</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);
}
}
}
public string getInteractionCount(string fbUserId, Guid UserId, int days)
{
string strStories = string.Empty;
try
{
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
ArrayList arrList = objfbiRepo.getFacebookInsightStatsById(fbUserId, UserId, days);
foreach (var item in arrList)
{
Array temp = (Array)item;
if (temp.GetValue(7) != null)
{
//strDate = strDate + temp.GetValue(9) + ",";
strStories = strStories + temp.GetValue(7) + ",";
}
}
strStories = strStories.Substring(0, strStories.Length - 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
return strStories;
}
public string getPageImressions(string fbUserId, Guid UserId, int days)
{
string strPageImpression = string.Empty;
try
{
string strDate = string.Empty;
string strImpression = string.Empty;
FacebookInsightStatsRepository objfbiRepo = new FacebookInsightStatsRepository();
ArrayList arrList = objfbiRepo.getFacebookInsightStatsById(fbUserId, UserId, days);
foreach (var item in arrList)
{
Array temp = (Array)item;
if (temp.GetValue(9) != null && temp.GetValue(8) != null)
{
strDate = strDate + temp.GetValue(8) + ",";
strImpression = strImpression + temp.GetValue(9) + ",";
}
}
if (arrList.Count < 7)
{
for (int i = 0; i < 7 - arrList.Count; i++)
{
strImpression = strImpression + "0,";
strDate = strDate + " ,";
}
}
strPageImpression = strDate.Substring(0, strDate.Length - 1) + "@" + strImpression.Substring(0, strImpression.Length - 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
return strPageImpression;
}