public IHttpActionResult GetGroupTwitterProfiles(string GroupId, string UserId)
{
Guid grpId = Guid.Empty;
try
{
grpId = Guid.Parse(GroupId);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
return(BadRequest("Invalid GroupId"));
}
List <Domain.Socioboard.Domain.GroupProfile> lstGroupProfiles = grpProfilesRepo.GetAllGroupProfilesByProfileType(grpId, "twitter");
List <Domain.Socioboard.Domain.TwitterAccount> lstTwitterAccount = new List <Domain.Socioboard.Domain.TwitterAccount>();
TwitterAccountRepository objTwitterAccountRepository = new TwitterAccountRepository();
foreach (var profile in lstGroupProfiles)
{
try
{
lstTwitterAccount.Add(objTwitterAccountRepository.getUserInformation(profile.ProfileId));
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
return(Ok(lstTwitterAccount));
}
public override void PostScheduleMessage(dynamic data)
{
try
{
oAuthTwitter OAuthTwt = new oAuthTwitter();
TwitterAccountRepository fbaccrepo = new TwitterAccountRepository();
TwitterAccount twtaccount = fbaccrepo.getUserInformation(data.UserId, data.ProfileId);
OAuthTwt.CallBackUrl = System.Configuration.ConfigurationSettings.AppSettings["callbackurl"];
OAuthTwt.ConsumerKey = System.Configuration.ConfigurationSettings.AppSettings["consumerKey"];
OAuthTwt.ConsumerKeySecret = System.Configuration.ConfigurationSettings.AppSettings["consumerSecret"];
OAuthTwt.AccessToken = twtaccount.OAuthToken;
OAuthTwt.AccessTokenSecret = twtaccount.OAuthSecret;
OAuthTwt.TwitterScreenName = twtaccount.TwitterScreenName;
OAuthTwt.TwitterUserId = twtaccount.TwitterUserId;
#region For Testing
// For Testing
//OAuthTwt.ConsumerKey = "udiFfPxtCcwXWl05wTgx6w";
//OAuthTwt.ConsumerKeySecret = "jutnq6N32Rb7cgbDSgfsrUVgRQKMbUB34yuvAfCqTI";
//OAuthTwt.AccessToken = "1904022338-Ao9chvPouIU8ejE1HMG4yJsP3hOgEoXJoNRYUF7";
//OAuthTwt.AccessTokenSecret = "Wj93a8csVFfaFS1MnHjbmbPD3V6DJbhEIf4lgSAefORZ5";
//OAuthTwt.TwitterScreenName = "";
//OAuthTwt.TwitterUserId = "";
#endregion
TwitterUser twtuser = new TwitterUser();
if (string.IsNullOrEmpty(data.ShareMessage))
{
data.ShareMessage = "There is no data in Share Message !";
}
JArray post = twtuser.Post_Status_Update(OAuthTwt, data.ShareMessage);
Console.WriteLine("Message post on twitter for Id :" + twtaccount.TwitterUserId + " and Message: " + data.ShareMessage);
ScheduledMessageRepository schrepo = new ScheduledMessageRepository();
schrepo.updateMessage(data.Id);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
Log log = new Log();
log.CreatedDate = DateTime.Now;
log.Exception = ex.Message;
log.Id = Guid.NewGuid();
log.ModuleName = "TwitterScheduler";
log.ProfileId = data.ProfileId;
log.Status = false;
LogRepository logRepo = new LogRepository();
logRepo.AddLog(log);
}
}
protected void TwtProfileDetails(string twtid)
{
TwitterAccountRepository objtwtAccRepo = new TwitterAccountRepository();
TwitterAccount arrTwtAcc = objtwtAccRepo.getUserInfo(twtid);
twtProfileId = arrTwtAcc.TwitterUserId;
divnameId.InnerHtml = arrTwtAcc.TwitterScreenName;
profileImg.ImageUrl = arrTwtAcc.ProfileImageUrl;
spanFollowers.InnerHtml = arrTwtAcc.FollowersCount.ToString();
}
public void AddTest()
{
var mockDao = new Mock <ITwitterAccountDao>();
var repository = new TwitterAccountRepository();
var newAccount = new TwitterAccount(0, new TwitterAccountCredentials("aaa", "bbb"), "world");
repository.Add(newAccount);
mockDao.Verify((dao) => dao.Add(It.IsAny <TwitterAccountDto>()), Times.Once());
}
public string UserInformation(string UserId, string TwitterId)
{
try
{
Guid userid = Guid.Parse(UserId);
TwitterAccountRepository twtAccrepo = new TwitterAccountRepository();
TwitterAccount twtAccount = twtAccrepo.getUserInformation(userid, TwitterId);
return(new JavaScriptSerializer().Serialize(twtAccount));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(new JavaScriptSerializer().Serialize("Please Try Again"));
}
}
public void GetUserReTweetsAPI(string UserId, string TwitterId)
{
try
{
Guid userId = Guid.Parse(UserId);
UserRepository userrepo = new UserRepository();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
TwitterAccount twtAcc = twtAccRepo.getUserInformation(userId, TwitterId);
oAuthTwitter oAuth = new oAuthTwitter();
oAuth.AccessToken = twtAcc.OAuthToken;
oAuth.AccessTokenSecret = twtAcc.OAuthSecret;
oAuth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"];
oAuth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"];
oAuth.TwitterUserId = twtAcc.TwitterUserId;
oAuth.TwitterScreenName = twtAcc.TwitterScreenName;
TwitterHelper twtHelper = new TwitterHelper();
twtHelper.getReTweetsOfUser(oAuth, twtAcc, userId);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
public void FindAllTest()
{
var mockDao = new Mock <ITwitterAccountDao>();
var list = new List <TwitterAccountDto>
{
new TwitterAccountDto(1, "hello", "aaa", "world"),
new TwitterAccountDto(1, "sample", "bbb", "account"),
};
mockDao.Setup((dao) => dao.FindAll()).Returns(list);
var repository = new TwitterAccountRepository();
var actual = repository.FindAll();
Assert.IsType <List <TwitterAccount> >(actual);
var index = 0;
actual.ForEach((item) =>
{
Assert.Equal <TwitterAccount>(list[index], item);
index++;
});
}
public void GetData(object UserId)
{
try
{
Guid userId = (Guid)UserId;
oAuthTwitter OAuth = new oAuthTwitter(ConfigurationManager.AppSettings["consumerKey"], ConfigurationManager.AppSettings["consumerSecret"], ConfigurationManager.AppSettings["callbackurl"]);
TwitterAccountRepository objTwtRepo = new TwitterAccountRepository();
ArrayList arrTwtAcc = objTwtRepo.getAllTwitterAccountsOfUser(userId);
foreach (TwitterAccount itemTwt in arrTwtAcc)
{
OAuth.AccessToken = itemTwt.OAuthToken;
OAuth.AccessTokenSecret = itemTwt.OAuthSecret;
getUserProile(OAuth, itemTwt.TwitterUserId, userId);
getUserTweets(OAuth, itemTwt.TwitterScreenName, itemTwt.TwitterUserId, userId);
getUserFeed(OAuth, itemTwt.TwitterScreenName, itemTwt.TwitterUserId, userId);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
public DataSet bindFeedsIntoDataTable(User user, string network)
{
Messages mstable = new Messages();
DataSet ds = DataTableGenerator.CreateDataSetForTable(mstable);
if (!string.IsNullOrEmpty(network))
{
/*Facebook region*/
if (network == "facebook")
{
FacebookAccountRepository fbaccount = new FacebookAccountRepository();
FacebookMessageRepository fbmsg = new FacebookMessageRepository();
ArrayList alstfbaccount = fbaccount.getAllFacebookAccountsOfUser(user.Id);
foreach (FacebookAccount item in alstfbaccount)
{
List <FacebookMessage> lstfbmsg = fbmsg.getAllFacebookMessagesOfUser(user.Id, item.FbUserId);
foreach (FacebookMessage facebookmsg in lstfbmsg)
{
ds.Tables[0].Rows.Add(facebookmsg.ProfileId, "facebook", facebookmsg.FromId, facebookmsg.FromName, facebookmsg.FromProfileUrl, facebookmsg.MessageDate, facebookmsg.Message, facebookmsg.FbComment, facebookmsg.FbLike, facebookmsg.MessageId, facebookmsg.Type);
}
}
}
else if (network == "twitter")
{
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
TwitterFeedRepository twtfeedrepo = new TwitterFeedRepository();
ArrayList alsttwtaccount = twtaccountrepo.getAllTwitterAccountsOfUser(user.Id);
foreach (TwitterAccount item in alsttwtaccount)
{
List <TwitterFeed> lsttwtmsg = twtfeedrepo.getAllTwitterFeedOfUsers(user.Id, item.TwitterUserId);
foreach (TwitterFeed twtmsg in lsttwtmsg)
{
ds.Tables[0].Rows.Add(twtmsg.ProfileId, "twitter", twtmsg.FromId, twtmsg.FromScreenName, twtmsg.FromProfileUrl, twtmsg.FeedDate, twtmsg.Feed, "", "", twtmsg.MessageId, twtmsg.Type);
}
}
}
else if (network == "linkedin")
{
LinkedInAccountRepository liaccountrepo = new LinkedInAccountRepository();
LinkedInFeedRepository lifeedrepo = new LinkedInFeedRepository();
ArrayList alstliaccount = liaccountrepo.getAllLinkedinAccountsOfUser(user.Id);
foreach (LinkedInAccount item in alstliaccount)
{
List <LinkedInFeed> lsttwtmsg = lifeedrepo.getAllLinkedInFeedsOfUser(user.Id, item.LinkedinUserId);
foreach (LinkedInFeed limsg in lsttwtmsg)
{
ds.Tables[0].Rows.Add(limsg.ProfileId, "linkedin", limsg.FromId, limsg.FromName, limsg.FromPicUrl, limsg.FeedsDate, limsg.Feeds, "", "", "", limsg.Type);
}
}
}
else if (network == "instagram")
{
InstagramAccountRepository insAccRepo = new InstagramAccountRepository();
InstagramFeedRepository insFeedRepo = new InstagramFeedRepository();
ArrayList alstlistaccount = insAccRepo.getAllInstagramAccountsOfUser(user.Id);
foreach (InstagramAccount item in alstlistaccount)
{
List <InstagramFeed> lstFeeed = insFeedRepo.getAllInstagramFeedsOfUser(user.Id, item.InstagramId);
foreach (InstagramFeed insFeed in lstFeeed)
{
ds.Tables[0].Rows.Add(insFeed.InstagramId, "instagram", "", "", "", insFeed.FeedDate, insFeed.FeedImageUrl, "", "", insFeed.FeedId, "");
}
}
}
}
return(ds);
}
public string getresults(string keyword)
{
User user = (User)Session["LoggedUser"];
int i = 0;
string searchRes = string.Empty;
if (!string.IsNullOrEmpty(keyword))
{
DiscoverySearch dissearch = new DiscoverySearch();
DiscoverySearchRepository dissearchrepo = new DiscoverySearchRepository();
//Get data from Database if present, against the specified keyword
List <DiscoverySearch> discoveryList = dissearchrepo.getResultsFromKeyword(keyword);
if (discoveryList.Count == 0) //if no data, get the data for specified keyword from social media apis
{
#region Twitter
try
{
oAuthTwitter oauth = new oAuthTwitter();
oauth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString();
oauth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"].ToString();
oauth.CallBackUrl = ConfigurationManager.AppSettings["callbackurl"].ToString();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
ArrayList alst = twtAccRepo.getAllTwitterAccounts();
foreach (TwitterAccount item in alst)
{
oauth.AccessToken = item.OAuthToken;
oauth.AccessTokenSecret = item.OAuthSecret;
oauth.TwitterUserId = item.TwitterUserId;
oauth.TwitterScreenName = item.TwitterScreenName;
if (TwitterHelper.CheckTwitterToken(oauth, keyword))
{
break;
}
else
{
}
}
Search search = new Search();
JArray twitterSearchResult = search.Get_Search_Tweets(oauth, keyword);
foreach (var item in twitterSearchResult)
{
var results = item["statuses"];
foreach (var chile in results)
{
try
{
dissearch.CreatedTime = SocioBoard.Helper.Extensions.ParseTwitterTime(chile["created_at"].ToString().TrimStart('"').TrimEnd('"'));;
dissearch.EntryDate = DateTime.Now;
dissearch.FromId = chile["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
dissearch.FromName = chile["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
dissearch.ProfileImageUrl = chile["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
dissearch.SearchKeyword = txtSearchText.Text;
dissearch.Network = "twitter";
dissearch.Message = chile["text"].ToString().TrimStart('"').TrimEnd('"');
dissearch.MessageId = chile["id_str"].ToString().TrimStart('"').TrimEnd('"');
dissearch.Id = Guid.NewGuid();
dissearch.UserId = user.Id;
string postID = chile["id"].ToString();
string postURL = "https://twitter.com/" + dissearch.FromName + "/status/" + postID;
if (!dissearchrepo.isKeywordPresent(dissearch.SearchKeyword, dissearch.MessageId))
{
dissearchrepo.addNewSearchResult(dissearch);
}
searchRes += this.BindData(dissearch, i, postURL);
i++;
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
}
#endregion
#region Facebook
try
{
#region FacebookSearch
int j = 0;
string accesstoken = string.Empty;
FacebookAccountRepository fbAccRepo = new FacebookAccountRepository();
ArrayList asltFbAccount = fbAccRepo.getAllFacebookAccounts();
foreach (FacebookAccount item in asltFbAccount)
{
accesstoken = item.AccessToken;
if (FacebookHelper.CheckFacebookToken(accesstoken, txtSearchText.Text))
{
break;
}
}
string facebookSearchUrl = "https://graph.facebook.com/search?q=" + txtSearchText.Text + " &type=post&access_token=" + accesstoken;
var facerequest = (HttpWebRequest)WebRequest.Create(facebookSearchUrl);
facerequest.Method = "GET";
string outputface = string.Empty;
using (var response = facerequest.GetResponse())
{
using (var stream = new StreamReader(response.GetResponseStream(), Encoding.GetEncoding(1252)))
{
outputface = stream.ReadToEnd();
}
}
if (!outputface.StartsWith("["))
{
outputface = "[" + outputface + "]";
}
JArray facebookSearchResult = JArray.Parse(outputface);
foreach (var item in facebookSearchResult)
{
var data = item["data"];
foreach (var chile in data)
{
try
{
dissearch.CreatedTime = DateTime.Parse(chile["created_time"].ToString());
dissearch.EntryDate = DateTime.Now;
dissearch.FromId = chile["from"]["id"].ToString();
dissearch.FromName = chile["from"]["name"].ToString();
dissearch.ProfileImageUrl = "http://graph.facebook.com/" + chile["from"]["id"] + "/picture?type=small";
dissearch.SearchKeyword = txtSearchText.Text;
dissearch.Network = "facebook";
dissearch.Message = chile["message"].ToString();
dissearch.MessageId = chile["id"].ToString();
dissearch.Id = Guid.NewGuid();
dissearch.UserId = user.Id;
string postURL = "https://www.facebook.com/" + dissearch.MessageId;
if (!dissearchrepo.isKeywordPresent(dissearch.SearchKeyword, dissearch.MessageId))
{
dissearchrepo.addNewSearchResult(dissearch);
}
searchRes += this.BindData(dissearch, i, postURL);
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
}
#endregion
#endregion
}
else // if data is there, bind data from databse
{
foreach (DiscoverySearch item in discoveryList)
{
string postURL = string.Empty;
if (item.Network == "facebook")
{
postURL = "https://www.facebook.com/" + item.MessageId;;
}
else if (item.Network == "twitter")
{
postURL = "https://twitter.com/" + item.FromName + "/status/" + item.MessageId;
}
searchRes += this.BindData(item, i, postURL);
i++;
}
}
}
return(searchRes);
}
public IHttpActionResult GetGroupTwitterProfiles(string GroupId, string UserId)
{
Guid grpId = Guid.Empty;
try
{
grpId = Guid.Parse(GroupId);
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
return BadRequest("Invalid GroupId");
}
List<Domain.Socioboard.Domain.GroupProfile> lstGroupProfiles = grpProfilesRepo.GetAllGroupProfilesByProfileType(grpId, "twitter");
List<Domain.Socioboard.Domain.TwitterAccount> lstTwitterAccount = new List<Domain.Socioboard.Domain.TwitterAccount>();
TwitterAccountRepository objTwitterAccountRepository = new TwitterAccountRepository();
foreach (var profile in lstGroupProfiles)
{
try
{
lstTwitterAccount.Add(objTwitterAccountRepository.getUserInformation( profile.ProfileId));
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
}
return Ok(lstTwitterAccount);
}
public string TwitterSearch(string keyword)
{
string SingleTwitterPageResult = string.Empty;
try
{
SingleTwitterPageResult = TwitterAccountPageWithoutLogin("", keyword);
if (!string.IsNullOrEmpty(SingleTwitterPageResult))
{
return SingleTwitterPageResult;
}
}
catch (Exception eee) { }
//int Followers = 0;
bool ischanged = false;
string TwitterResutPage = string.Empty;
string TwitterResutPageid = string.Empty;
string ScreenName = string.Empty;
List<Domain.Socioboard.Domain.DiscoverySearch> lstDiscoverySearch = new List<Domain.Socioboard.Domain.DiscoverySearch>();
string profileid = string.Empty;
try
{
oAuthTwitter oauth = new oAuthTwitter();
Twitter obj = new Twitter();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
//ArrayList alst = twtAccRepo.getAllTwitterAccounts();
oauth.AccessToken = Twitterapponlykey();
//oauth.AccessTokenSecret = "beScSFa1uI7MttvgjoDPjxYMKgC0Mq2EUYzYewbbNvobO";
//oauth.ConsumerKey = "LvHB4sHi0RWcQF7MmrstXhEJE";
//oauth.ConsumerKeySecret = "vd5cdLeje1sThW4cYonIhqWuvKkGk1mZLDu1j1IAbSkLLqp5Kd";
//oauth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"];
//oauth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"];
string twitterSearchResult = Get_Search_Users(oauth, keyword);
JArray twitterpageArray = JArray.Parse(twitterSearchResult);
foreach (var item in twitterpageArray)
{
if (item["verified"].ToString().Equals("True"))
{
TwitterResutPageid = item["id"].ToString();
ScreenName = item["screen_name"].ToString();
ischanged = true;
}
}
if (ischanged)
{
TwitterResutPage = Get_Search_SingleUser(oauth, TwitterResutPageid, ScreenName);
}
return TwitterResutPage;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return "";
}
}
public void ProfilesAvailabeforuser(Guid UserId)
{
string bindprofiles = string.Empty;
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
List <SocialProfile> lstsocialprofile = socioprofilerepo.getAllSocialProfilesOfUser(UserId);
foreach (SocialProfile item in lstsocialprofile)
{
if (item.ProfileType == "facebook")
{
if (!SelectedGroupProfiles.InnerHtml.Contains("facebook_" + item.ProfileId))
{
FacebookAccountRepository fbaccreop = new FacebookAccountRepository();
FacebookAccount facebookaccount = fbaccreop.getFacebookAccountDetailsById(item.ProfileId, UserId);
bindprofiles +=
"<div onclick=\"transfertoGroup('facebook','" + item.ProfileId + "')\" id=\"usergroups_" + item.ProfileId + "\" class=\"ws_conct active\"> <span class=\"img\"><img width=\"48\" height=\"48\" src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\" alt=\"\"><i><img width=\"16\" height=\"16\" src=\"../Contents/img/fb_icon.png\" alt=\"\"></i></span><div class=\"fourfifth\">" +
"<div class=\"location-container\">" + facebookaccount.FbUserName + "</div><span class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "twitter")
{
if (!SelectedGroupProfiles.InnerHtml.Contains("twitter_" + item.ProfileId))
{
string profileimgurl = string.Empty;
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
TwitterAccount twtacco = twtaccountrepo.getUserInformation(UserId, item.ProfileId);
if (twtacco.ProfileImageUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = twtacco.ProfileImageUrl;
}
bindprofiles +=
"<div onclick=\"transfertoGroup('twitter','" + item.ProfileId + "')\" id=\"usergroups_" + item.ProfileId + "\" class=\"ws_conct active\"> <span class=\"img\"><img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"><i><img width=\"16\" height=\"16\" src=\"../Contents/img/twticon.png\" alt=\"\"></i></span><div class=\"fourfifth\">" +
"<div class=\"location-container\">" + twtacco.TwitterScreenName + "</div><span class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "linkedin")
{
if (!SelectedGroupProfiles.InnerHtml.Contains("linkedin_" + item.ProfileId))
{
LinkedInAccountRepository linkedaccrepo = new LinkedInAccountRepository();
LinkedInAccount linkedaccount = linkedaccrepo.getUserInformation(UserId, item.ProfileId);
string profileimgurl = string.Empty;
if (linkedaccount.ProfileUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = linkedaccount.ProfileImageUrl;
}
bindprofiles += "<div onclick=\"transfertoGroup('linkedin','" + item.ProfileId + "')\" id=\"usergroups_" + item.ProfileId + "\" class=\"ws_conct active\"><span class=\"img\"><img width=\"48\" height=\"48\" alt=\"\" src=\"" + profileimgurl + "\" ><i>" +
"<img width=\"16\" height=\"16\" alt=\"\" src=\"../Contents/img/link_icon.png\"></i></span>" +
"<div class=\"fourfifth\"><div class=\"location-container\">" + linkedaccount.LinkedinUserName + "</div>" +
"<span class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "instagram")
{
if (!SelectedGroupProfiles.InnerHtml.Contains("instagram_" + item.ProfileId))
{
string profileimgurl = string.Empty;
InstagramAccountRepository instagramrepo = new InstagramAccountRepository();
InstagramAccount instaaccount = instagramrepo.getInstagramAccountDetailsById(item.ProfileId, UserId);
if (instaaccount.ProfileUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = instaaccount.ProfileUrl;
}
bindprofiles += "<div onclick=\"transfertoGroup('instagram','" + item.ProfileId + "')\" id=\"usergroups_" + item.ProfileId + "\" class=\"ws_conct active\"><span class=\"img\"><img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"><i>" +
"<img width=\"16\" height=\"16\" alt=\"\" src=\"../Contents/img/instagram_24X24.png\"></i></span><div class=\"fourfifth\"><div class=\"location-container\">" + instaaccount.InsUserName + "</div>" +
"<span class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "tumblr")
{
if (!SelectedGroupProfiles.InnerHtml.Contains("tumblr_" + item.ProfileId))
{
string profileimgurl = string.Empty;
TumblrAccountRepository tumblrrepo = new TumblrAccountRepository();
TumblrAccount tumblraccount = tumblrrepo.getTumblrAccountDetailsById(item.ProfileId, UserId);
if (tumblraccount.tblrProfilePicUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = "http://api.tumblr.com/v2/blog/" + tumblraccount.tblrUserName + ".tumblr.com/avatar";
}
bindprofiles += "<div onclick=\"transfertoGroup('tumblr','" + item.ProfileId + "')\" id=\"usergroups_" + item.ProfileId + "\" class=\"ws_conct active\"><span class=\"img\"><img width=\"48\" height=\"48\" src=\"http://api.tumblr.com/v2/blog/" + tumblraccount.tblrUserName + ".tumblr.com/avatar\" alt=\"\"><i>" +
"<img width=\"16\" height=\"16\" alt=\"\" src=\"../Contents/img/tumblr.png\"></i></span><div class=\"fourfifth\"><div class=\"location-container\">" + tumblraccount.tblrUserName + "</div>" +
"<span class=\"add remove\">✖</span></div></div>";
}
}
}
AllGroupProfiles.InnerHtml = bindprofiles;
}
public void GetSearchData(object parameters)
{
#region Twitter
Array arrayParams = (Array)parameters;
DiscoverySearch dissearch = (DiscoverySearch)arrayParams.GetValue(0);
DiscoverySearchRepository dissearchrepo = (DiscoverySearchRepository)arrayParams.GetValue(1);
DiscoverySearch discoverySearch = (DiscoverySearch)arrayParams.GetValue(2);
oAuthTwitter oauth = new oAuthTwitter();
oauth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"].ToString();
oauth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"].ToString();
oauth.CallBackUrl = ConfigurationManager.AppSettings["callbackurl"].ToString();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
//ArrayList alst = twtAccRepo.getAllTwitterAccounts();
ArrayList alst = twtAccRepo.getAllTwitterAccountsOfUser(discoverySearch.UserId);
foreach (TwitterAccount item in alst)
{
oauth.AccessToken = item.OAuthToken;
oauth.AccessTokenSecret = item.OAuthSecret;
oauth.TwitterUserId = item.TwitterUserId;
oauth.TwitterScreenName = item.TwitterScreenName;
if (TwitterHelper.CheckTwitterToken(oauth, discoverySearch.SearchKeyword))
{
break;
}
else
{
}
}
GlobusTwitterLib.Twitter.Core.SearchMethods.Search search = new GlobusTwitterLib.Twitter.Core.SearchMethods.Search();
Newtonsoft.Json.Linq.JArray twitterSearchResult = search.Get_Search_Tweets(oauth, discoverySearch.SearchKeyword);
foreach (var item in twitterSearchResult)
{
var results = item["statuses"];
foreach (var chile in results)
{
try
{
dissearch.CreatedTime = SocioBoard.Helper.Extensions.ParseTwitterTime(chile["created_at"].ToString().TrimStart('"').TrimEnd('"'));;
dissearch.EntryDate = DateTime.Now;
dissearch.FromId = chile["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
dissearch.FromName = chile["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
dissearch.ProfileImageUrl = chile["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
dissearch.SearchKeyword = discoverySearch.SearchKeyword;
dissearch.Network = "twitter";
dissearch.Message = chile["text"].ToString().TrimStart('"').TrimEnd('"');
dissearch.MessageId = chile["id_str"].ToString().TrimStart('"').TrimEnd('"');
dissearch.Id = Guid.NewGuid();
dissearch.UserId = discoverySearch.UserId;//user.Id;
if (!dissearchrepo.isKeywordPresent(dissearch.SearchKeyword, dissearch.MessageId))
{
dissearchrepo.addNewSearchResult(dissearch);
}
}
catch (Exception ex)
{
//logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
}
}
}
#endregion
}
public string DiscoverySearchTwitter(string UserId, string keyword)
{
List<Domain.Socioboard.Domain.DiscoverySearch> lstDiscoverySearch = new List<Domain.Socioboard.Domain.DiscoverySearch>();
string profileid = string.Empty;
try
{
oAuthTwitter oauth = new oAuthTwitter();
Twitter obj = new Twitter();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
ArrayList alst = twtAccRepo.getAllTwitterAccounts();
foreach (Domain.Socioboard.Domain.TwitterAccount item in alst)
{
oauth.AccessToken = item.OAuthToken;
oauth.AccessTokenSecret = item.OAuthSecret;
oauth.TwitterUserId = item.TwitterUserId;
oauth.TwitterScreenName = item.TwitterScreenName;
obj.SetCofigDetailsForTwitter(oauth);
if (this.CheckTwitterToken(oauth, keyword))
{
break;
}
}
Search search = new Search();
JArray twitterSearchResult = search.Get_Search_Tweets(oauth, keyword);
foreach (var item in twitterSearchResult)
{
var results = item["statuses"];
foreach (var chile in results)
{
try
{
objDiscoverySearch = new Domain.Socioboard.Domain.DiscoverySearch();
objDiscoverySearch.SearchKeyword = keyword;
objDiscoverySearch.Network = "twitter";
objDiscoverySearch.Id = Guid.NewGuid();
objDiscoverySearch.UserId = Guid.Parse(UserId);
if (!dissearchrepo.isKeywordPresentforNetwork(objDiscoverySearch.SearchKeyword, objDiscoverySearch.Network))
{
dissearchrepo.addNewSearchResult(objDiscoverySearch);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
objDiscoverySearch = new Domain.Socioboard.Domain.DiscoverySearch();
objDiscoverySearch.CreatedTime = Utility.ParseTwitterTime(chile["created_at"].ToString().TrimStart('"').TrimEnd('"')); ;
objDiscoverySearch.EntryDate = DateTime.Now;
objDiscoverySearch.FromId = chile["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
objDiscoverySearch.FromName = chile["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
objDiscoverySearch.ProfileImageUrl = chile["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
objDiscoverySearch.SearchKeyword = keyword;
objDiscoverySearch.Network = "twitter";
objDiscoverySearch.Message = chile["text"].ToString().TrimStart('"').TrimEnd('"');
objDiscoverySearch.MessageId = chile["id_str"].ToString().TrimStart('"').TrimEnd('"');
objDiscoverySearch.Id = Guid.NewGuid();
objDiscoverySearch.UserId = Guid.Parse(UserId);
lstDiscoverySearch.Add(objDiscoverySearch);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
return new JavaScriptSerializer().Serialize(lstDiscoverySearch);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return new JavaScriptSerializer().Serialize("Please try Again");
}
}
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);
}
private void NewMethod(User user)
{
SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)Session["GroupName"];
TeamRepository objTeamRepository = new TeamRepository();
GroupRepository objGroupRepository = new GroupRepository();
RssFeedsRepository rssFeedsRepo = new RssFeedsRepository();
List <RssFeeds> lstrssfeeds = rssFeedsRepo.getAllActiveRssFeeds(user.Id);
TwitterAccountRepository twtAccountRepo = new TwitterAccountRepository();
ArrayList arrTwtAcc = twtAccountRepo.getAllTwitterAccountsOfUser(user.Id);
//===================================================================================================================================
//====================================================================================================================================
if (lstrssfeeds != null)
{
if (lstrssfeeds.Count != 0)
{
//int rssCount = 0;
string rssData = string.Empty;
rssData += "<h2 class=\"league section-ttl rss_header\">Active RSS Feeds</h2>";
foreach (RssFeeds item in lstrssfeeds)
{
TwitterAccount twtAccount = twtAccountRepo.getUserInformation(item.ProfileScreenName, user.Id);
string picurl = string.Empty;
if (string.IsNullOrEmpty(twtAccount.ProfileUrl))
{
picurl = "../Contents/img/blank_img.png";
}
else
{
picurl = twtAccount.ProfileUrl;
}
rssData += " <section id=\"" + item.Id + "\" class=\"publishing\">" +
"<section class=\"twothird\">" +
"<article class=\"quarter\">" +
"<div href=\"#\" class=\"avatar_link view_profile\" title=\"\">" +
"<img title=\"" + item.ProfileScreenName + "\" src=\"" + picurl + "\" data-src=\"\" class=\"avatar sm\">" +
"<article class=\"rss_ava_icon\"><span title=\"Twitter\" class=\"icon twitter_16\"></span></article>" +
"</div>" +
"</article>" +
"<article class=\"threefourth\">" +
"<ul>" +
"<li>" + item.FeedUrl + "</li>" +
"<li>Prefix: </li>" +
"<li class=\"freq\" title=\"New items from this feed will be posted at most once every hour\">Max Frequency: " + item.Duration + "</li>" +
"</ul>" +
"</article>" +
"</section>" +
"<section class=\"third\">" +
"<ul class=\"rss_action_buttons\">" +
"<li onclick=\"pauseFunction('" + item.Id + "');\" class=\"\"><a id=\"pause_" + item.Id + "\" href=\"#\" title=\"Pause\" class=\"small_pause icon pause\"></a></li>" +
"<li onclick=\"deleteRssFunction('" + item.Id + "');\" class=\"show-on-hover\"><a id=\"delete_" + item.Id + "\" href=\"#\" title=\"Delete\" class=\"small_remove icon delete\"></a></li>" +
"</ul>" +
"</section>" +
"</section>";
}
rss.InnerHtml = rssData;
rss.Style.Add("display", "block");
rdata.Style.Add("display", "none");
}
}
try
{
if (Session["IncomingTasks"] != null)
{
//incom_tasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
//incomTasks.InnerHtml = Convert.ToString((int)Session["IncomingTasks"]);
}
else
{
TaskRepository taskRepo = new TaskRepository();
ArrayList alst = taskRepo.getAllIncompleteTasksOfUser(user.Id, team.GroupId);
Session["IncomingTasks"] = alst.Count;
}
}
catch (Exception es)
{
logger.Error(es.StackTrace);
Console.WriteLine(es.StackTrace);
}
if (Session["CountMessages"] != null)
{
//incom_messages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
//incomMessages.InnerHtml = Convert.ToString((int)Session["CountMessages"]);
}
else
{
//incom_messages.InnerHtml = "0";
//incomMessages.InnerHtml = "0";
}
//usernm.InnerHtml = "Hello, <a href=\"../Settings/PersonalSettings.aspx\"> " + user.UserName + "</a>";
usernm.InnerHtml = "Hello, " + user.UserName + "";
//usernm.InnerHtml = "Hello, <a href=\"../Settings/PersonalSettings.aspx\"> " + user.UserName + "</a>";
usernm.InnerHtml = "Hello, " + user.UserName + "";
//usernm.InnerHtml = "Hello, <a href=\"../Settings/PersonalSettings.aspx\"> " + user.UserName + "</a>";
if (!string.IsNullOrEmpty(user.ProfileUrl))
{
//userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\"/></a>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"" + user.ProfileUrl + "\" alt=\"" + user.UserName + "\"/>";
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userinf.InnerHtml = Datetime;
}
if (user.TimeZone == null)
{
Datetime = DateTime.Now.ToString();
//userinf.InnerHtml = Datetime;
}
}
else
{
//userimg.InnerHtml = "<a href=\"../Settings/PersonalSettings.aspx\"><img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/></a>";
userimg.InnerHtml = "<img id=\"loggeduserimg\" src=\"../Contents/img/blank_img.png\" alt=\"" + user.UserName + "\"/>";
if (user.TimeZone != null)
{
Datetime = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToLongDateString() + " " + TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, user.TimeZone).ToShortTimeString() + " (" + user.TimeZone + ")";
//userinf.InnerHtml = Datetime;
}
if (user.TimeZone == null)
{
Datetime = DateTime.Now.ToString();
//userinf.InnerHtml = Datetime;
}
}
try
{
GroupRepository grouprepo = new GroupRepository();
List <Groups> lstgroups = grouprepo.getAllGroups(user.Id);
string totgroups = string.Empty;
if (lstgroups.Count != 0)
{
foreach (Groups item in lstgroups)
{
totgroups += "<li><a href=\"../Settings/InviteMember.aspx?q=" + item.Id + "\" id=\"group_" + item.Id + "\"><img src=\"../Contents/img/groups_.png\" alt=\"\" style=\" margin-right:5px;\"/>" + item.GroupName + "</a></li>";
}
inviteRedirect.InnerHtml = totgroups;
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
}
}
public void getUserFeeds(string profileid)
{
TwitterUser twtuser = new TwitterUser();
User user = (User)HttpContext.Current.Session["LoggedUser"];
oAuthTwitter OAuth = new oAuthTwitter();
JArray data = twtuser.GetStatuses_User_Timeline(OAuth);
TwitterMessageRepository twtmsgrepo = new TwitterMessageRepository();
TwitterAccountRepository twtrepo = new TwitterAccountRepository();
TwitterAccount twtaccount = twtrepo.getUserInformation(user.Id, profileid);
OAuth.CallBackUrl = ConfigurationManager.AppSettings["callbackurl"];
OAuth.ConsumerKey = ConfigurationManager.AppSettings["consumerKey"];
OAuth.ConsumerKeySecret = ConfigurationManager.AppSettings["consumerSecret"];
OAuth.TwitterScreenName = twtaccount.TwitterScreenName;
OAuth.AccessTokenSecret = twtaccount.OAuthSecret;
OAuth.AccessToken = twtaccount.OAuthToken;
OAuth.ProfileImage = twtaccount.ProfileImageUrl;
TwitterMessage twtmsg = new TwitterMessage();
foreach (var item in data)
{
twtmsg.UserId = user.Id;
twtmsg.Type = "twt_usertweets";
try
{
twtmsg.TwitterMsg = item["text"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.SourceUrl = item["source"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.ScreenName = twtaccount.TwitterScreenName;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.ProfileId = twtaccount.TwitterUserId;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.MessageId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.MessageDate = SocioBoard.Helper.Extensions.ParseTwitterTime(item["created_at"].ToString().TrimStart('"').TrimEnd('"'));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.InReplyToStatusUserId = item["in_reply_to_status_id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.Id = Guid.NewGuid();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.FromProfileUrl = item["user"]["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.FromName = item["user"]["name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twtmsg.FromId = item["user"]["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
twtmsg.EntryDate = DateTime.Now;
try
{
twtmsg.FromScreenName = item["user"]["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!twtmsgrepo.checkTwitterMessageExists(twtmsg.MessageId))
{
twtmsgrepo.addTwitterMessage(twtmsg);
}
}
}
//protected void rbAdmin_CheckedChanged(object sender, EventArgs e)
//{
// rbAdmin.Checked = true;
// rbUser.Checked = false;
// if (rbAdmin.Checked == true && rbUser.Checked == false)
// {
// AccessLevel = "admin";
// }
// else
// {
// AccessLevel = "user";
// }
//}
//protected void rbUser_CheckedChanged(object sender, EventArgs e)
//{
// rbAdmin.Checked = false;
// rbUser.Checked = true;
// if (rbAdmin.Checked == false && rbUser.Checked == true)
// {
// AccessLevel = "user";
// }
// else
// {
// AccessLevel = "admin";
// }
//}
public void BindSocialProfiles()
{
User user = (User)Session["LoggedUser"];
if (Session["GroupId"] != null)
{
Guid groupid = (Guid)Session["GroupId"];
GroupProfileRepository groupprofilesrepo = new GroupProfileRepository();
GroupRepository grouprepo = new GroupRepository();
Groups groups = grouprepo.getGroupDetailsbyId(user.Id, groupid);
List <GroupProfile> lstgroupprofile = groupprofilesrepo.getAllGroupProfiles(user.Id, groupid);
string bindfacebookprofiles = string.Empty;
string bindtwitterprofiles = string.Empty;
string bindlinkedinprofiles = string.Empty;
string bindinstagramprofiles = string.Empty;
string bindtumblrprofiles = string.Empty;
int i = 0;
foreach (GroupProfile item in lstgroupprofile)
{
if (item.ProfileType == "facebook")
{
FacebookAccountRepository fbaccountrepo = new FacebookAccountRepository();
FacebookAccount account = fbaccountrepo.getFacebookAccountDetailsById(item.ProfileId, user.Id);
if (account != null)
{
bindfacebookprofiles += "<div class=\"ws_tm_network_one\"><div class=\"ws_tm_user_name\">" + account.FbUserName + "</div>" +
"<div class=\"ws_tm_chkbx\"><input type=\"checkbox\" value=\"facebook_" + item.ProfileId + "\" onclick=\"isProfileID('" + item.ProfileId + "')\" id=\"facebookcheck_" + i + "\" name=\"chkbox_" + i + "\"></div></div>";
}
}
else if (item.ProfileType == "twitter")
{
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
TwitterAccount twtaccount = twtaccountrepo.getUserInformation(user.Id, item.ProfileId);
if (twtaccount != null)
{
bindtwitterprofiles += "<div class=\"ws_tm_network_one\"><div class=\"ws_tm_user_name\">" + twtaccount.TwitterScreenName + "</div>" +
"<div class=\"ws_tm_chkbx\"><input type=\"checkbox\" value=\"twitter_" + item.ProfileId + "\" onclick=\"isProfileID('" + item.ProfileId + "')\" id=\"twittercheck_" + i + "\" name=\"chkbox_" + i + "\"></div></div>";
}
}
else if (item.ProfileType == "linkedin")
{
LinkedInAccountRepository linkedaccrepo = new LinkedInAccountRepository();
LinkedInAccount linkedaccount = linkedaccrepo.getUserInformation(user.Id, item.ProfileId);
if (linkedaccount != null)
{
bindlinkedinprofiles += "<div class=\"ws_tm_network_one\"><div class=\"ws_tm_user_name\">" + linkedaccount.LinkedinUserName + "</div>" +
"<div class=\"ws_tm_chkbx\"><input type=\"checkbox\" value=\"linkedin_" + item.ProfileId + "\" onclick=\"isProfileID('" + item.ProfileId + "')\" id=\"linkedincheck_" + i + "\" name=\"chkbox_" + i + "\"></div></div>";
}
}
else if (item.ProfileType == "tumblr")
{
TumblrAccountRepository tumblraccrepo = new TumblrAccountRepository();
TumblrAccount tumblraccount = tumblraccrepo.getTumblrAccountDetailsById(item.ProfileId, user.Id);
if (tumblraccount != null)
{
bindtumblrprofiles += "<div class=\"ws_tm_network_one\"><div class=\"ws_tm_user_name\">" + tumblraccount.tblrUserName + "</div>" +
"<div class=\"ws_tm_chkbx\"><input type=\"checkbox\" value=\"tumblr_" + item.ProfileId + "\" onclick=\"isProfileID('" + item.ProfileId + "')\" id=\"tumblrcheck_" + i + "\" name=\"chkbox_" + i + "\"></div></div>";
}
}
else if (item.ProfileType == "instagram")
{
InstagramAccountRepository instagramrepo = new InstagramAccountRepository();
InstagramAccount instaaccount = instagramrepo.getInstagramAccountDetailsById(item.ProfileId, user.Id);
if (instaaccount != null)
{
bindinstagramprofiles += "<div class=\"ws_tm_network_one\"><div class=\"ws_tm_user_name\">" + instaaccount.InsUserName + "</div>" +
"<div class=\"ws_tm_chkbx\"><input type=\"checkbox\" value=\"instagram_" + item.ProfileId + "\" onclick=\"isProfileID('" + item.ProfileId + "')\" id=\"instagramcheck_" + i + "\" name=\"chkbox_" + i + "\"></div></div>";
}
}
i++;
}
if (!string.IsNullOrEmpty(bindfacebookprofiles))
{
FacebookAc.InnerHtml = bindfacebookprofiles;
}
else
{
FacebookAc.InnerHtml = "No Facebook Profiles for " + groups.GroupName + " Group";
}
if (!string.IsNullOrEmpty(bindtwitterprofiles))
{
TwitterAc.InnerHtml = bindtwitterprofiles;
}
else
{
TwitterAc.InnerHtml = "No Twitter Profiles for " + groups.GroupName + " Group";
}
if (!string.IsNullOrEmpty(bindinstagramprofiles))
{
InstagramAc.InnerHtml = bindinstagramprofiles;
}
else
{
InstagramAc.InnerHtml = "No Instagram Profiles for " + groups.GroupName + " Group";
}
if (!string.IsNullOrEmpty(bindlinkedinprofiles))
{
LinkedInAc.InnerHtml = bindlinkedinprofiles;
}
else
{
LinkedInAc.InnerHtml = "No LinkedIn Profiles for " + groups.GroupName + " Group";
}
if (!string.IsNullOrEmpty(bindtumblrprofiles))
{
TumblrAc.InnerHtml = bindtumblrprofiles;
}
else
{
TumblrAc.InnerHtml = "No Tumblr Profiles for " + groups.GroupName + " Group";
}
totalaccountscheck.InnerHtml = i.ToString();
}
}
public IHttpActionResult DeleteUserDetails(string user)
{
GroupsRepository _GroupsRepository=new GroupsRepository();
GroupMembersRepository _GroupMembersRepository = new GroupMembersRepository();
GroupProfileRepository _GroupProfileRepository = new GroupProfileRepository();
TaskRepository _TaskRepository = new TaskRepository();
TaskCommentRepository _TaskCommentRepository = new TaskCommentRepository();
InboxMessagesRepository _InboxMessagesRepository=new InboxMessagesRepository();
FacebookAccountRepository _FacebookAccountRepository=new FacebookAccountRepository();
GoogleAnalyticsAccountRepository _GoogleAnalyticsAccountRepository=new GoogleAnalyticsAccountRepository();
GooglePlusAccountRepository _GooglePlusAccountRepository=new GooglePlusAccountRepository();
InstagramAccountRepository _InstagramAccountRepository=new InstagramAccountRepository();
LinkedInAccountRepository _LinkedInAccountRepository=new LinkedInAccountRepository();
LinkedinCompanyPageRepository _LinkedinCompanyPageRepository=new LinkedinCompanyPageRepository();
ScheduledMessageRepository _ScheduledMessageRepository=new ScheduledMessageRepository();
SocialProfilesRepository _SocialProfilesRepository = new SocialProfilesRepository();
TwitterAccountRepository _TwitterAccountRepository=new TwitterAccountRepository();
TumblrAccountRepository _TumblrAccountRepository = new TumblrAccountRepository();
YoutubeAccountRepository _YoutubeAccountRepository = new YoutubeAccountRepository();
YoutubeChannelRepository _YoutubeChannelRepository = new YoutubeChannelRepository();
try
{
Domain.Socioboard.Domain.User _User = userrepo.getUserInfoByEmail(user);
if (_User != null)
{
List<Domain.Socioboard.Domain.Groups> lstGroups = _GroupsRepository.getAllGroups(_User.Id);
foreach (Domain.Socioboard.Domain.Groups item_group in lstGroups)
{
int i = _GroupMembersRepository.DeleteGroupMember(item_group.Id.ToString());
int j = _GroupProfileRepository.DeleteAllGroupProfile(item_group.Id);
bool rt = _GroupProfileRepository.DeleteGroupReport(item_group.Id);
int k = _TaskRepository.DeleteTaskOfGroup(item_group.Id);
}
int g = _GroupMembersRepository.DeleteGroupMemberByUserId(user);
int h = _GroupsRepository.DeleteGroupsByUserid(_User.Id);
int l = _TaskCommentRepository.DeleteTaskCommentByUserid(_User.Id);
int m = _InboxMessagesRepository.DeleteInboxMessages(_User.Id);
int n = _FacebookAccountRepository.DeleteAllFacebookAccount(_User.Id);
int o = _GoogleAnalyticsAccountRepository.DeleteGoogleAnalyticsAccountByUserid(_User.Id);
int p = _GooglePlusAccountRepository.DeleteGooglePlusAccountByUserid(_User.Id);
int q = _InstagramAccountRepository.DeleteInstagramAccountByUserid(_User.Id);
int r = _LinkedInAccountRepository.DeleteLinkedInAccountByUserid(_User.Id);
int s = _LinkedinCompanyPageRepository.DeleteLinkedinCompanyPage(_User.Id);
int t = _ScheduledMessageRepository.DeleteScheduledMessageByUserid(_User.Id);
int u = _SocialProfilesRepository.DeleteSocialProfileByUserid(_User.Id);
int v = _TwitterAccountRepository.DeleteTwitterAccountByUserid(_User.Id);
int w = _TumblrAccountRepository.DeletetumblraccountByUserid(_User.Id);
int x = _YoutubeAccountRepository.DeleteYoutubeAccount(_User.Id);
int y = _YoutubeChannelRepository.DeleteYoutubeChannelByUserid(_User.Id);
int z = userrepo.DeleteUser(_User.Id);
}
else {
return Ok(false);
}
}
catch (Exception ex)
{
return BadRequest(ex.StackTrace);
}
return Ok(true);
}
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"));
}
}
protected void btnRegister_Click(object sender, ImageClickEventArgs e)
{
User user = new User();
UserRepository userrepo = new UserRepository();
SocioBoard.Helper.SessionFactory.configfilepath = Server.MapPath("~/hibernate.cfg.xml");
try
{
if (txtPassword.Text == txtConfirmPassword.Text)
{
user.PaymentStatus = "unpaid";
user.AccountType = Request.QueryString["type"];
if (user.AccountType == string.Empty)
{
user.AccountType = AccountType.Deluxe.ToString();
}
user.CreateDate = DateTime.Now;
user.ExpiryDate = DateTime.Now.AddMonths(1);
user.Id = Guid.NewGuid();
user.UserName = txtFirstName.Text + " " + txtLastName.Text;
user.Password = this.MD5Hash(txtPassword.Text);
user.EmailId = txtEmail.Text;
user.UserStatus = 1;
if (!userrepo.IsUserExist(user.EmailId))
{
UserRepository.Add(user);
SocioBoard.Helper.MailSender.SendEMail(txtFirstName.Text + " " + txtLastName.Text, txtPassword.Text, txtEmail.Text);
TeamRepository teamRepo = new TeamRepository();
Team team = teamRepo.getTeamByEmailId(txtEmail.Text);
if (team != null)
{
Guid teamid = Guid.Parse(Request.QueryString["tid"]);
teamRepo.updateTeamStatus(teamid);
TeamMemberProfileRepository teamMemRepo = new TeamMemberProfileRepository();
List <TeamMemberProfile> lstteammember = teamMemRepo.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile item in lstteammember)
{
try
{
SocialProfilesRepository socialRepo = new SocialProfilesRepository();
SocialProfile socioprofile = new SocialProfile();
socioprofile.Id = Guid.NewGuid();
socioprofile.ProfileDate = DateTime.Now;
socioprofile.ProfileId = item.ProfileId;
socioprofile.ProfileType = item.ProfileType;
socioprofile.UserId = user.Id;
socialRepo.addNewProfileForUser(socioprofile);
if (item.ProfileType == "facebook")
{
try
{
FacebookAccount fbAccount = new FacebookAccount();
FacebookAccountRepository fbAccountRepo = new FacebookAccountRepository();
FacebookAccount userAccount = fbAccountRepo.getUserDetails(item.ProfileId);
fbAccount.AccessToken = userAccount.AccessToken;
fbAccount.EmailId = userAccount.EmailId;
fbAccount.FbUserId = item.ProfileId;
fbAccount.FbUserName = userAccount.FbUserName;
fbAccount.Friends = userAccount.Friends;
fbAccount.Id = Guid.NewGuid();
fbAccount.IsActive = true;
fbAccount.ProfileUrl = userAccount.ProfileUrl;
fbAccount.Type = userAccount.Type;
fbAccount.UserId = user.Id;
fbAccountRepo.addFacebookUser(fbAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "twitter")
{
try
{
TwitterAccount twtAccount = new TwitterAccount();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
TwitterAccount twtAcc = twtAccRepo.getUserInfo(item.ProfileId);
twtAccount.FollowersCount = twtAcc.FollowersCount;
twtAccount.FollowingCount = twtAcc.FollowingCount;
twtAccount.Id = Guid.NewGuid();
twtAccount.IsActive = true;
twtAccount.OAuthSecret = twtAcc.OAuthSecret;
twtAccount.OAuthToken = twtAcc.OAuthToken;
twtAccount.ProfileImageUrl = twtAcc.ProfileImageUrl;
twtAccount.ProfileUrl = twtAcc.ProfileUrl;
twtAccount.TwitterName = twtAcc.TwitterName;
twtAccount.TwitterScreenName = twtAcc.TwitterScreenName;
twtAccount.TwitterUserId = twtAcc.TwitterUserId;
twtAccount.UserId = user.Id;
twtAccRepo.addTwitterkUser(twtAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "instagram")
{
try
{
InstagramAccount insAccount = new InstagramAccount();
InstagramAccountRepository insAccRepo = new InstagramAccountRepository();
InstagramAccount InsAcc = insAccRepo.getInstagramAccountById(item.ProfileId);
insAccount.AccessToken = InsAcc.AccessToken;
insAccount.FollowedBy = InsAcc.FollowedBy;
insAccount.Followers = InsAcc.Followers;
insAccount.Id = Guid.NewGuid();
insAccount.InstagramId = item.ProfileId;
insAccount.InsUserName = InsAcc.InsUserName;
insAccount.IsActive = true;
insAccount.ProfileUrl = InsAcc.ProfileUrl;
insAccount.TotalImages = InsAcc.TotalImages;
insAccount.UserId = user.Id;
insAccRepo.addInstagramUser(insAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "linkedin")
{
try
{
LinkedInAccount linkAccount = new LinkedInAccount();
LinkedInAccountRepository linkedAccountRepo = new LinkedInAccountRepository();
LinkedInAccount linkAcc = linkedAccountRepo.getLinkedinAccountDetailsById(item.ProfileId);
linkAccount.Id = Guid.NewGuid();
linkAccount.IsActive = true;
linkAccount.LinkedinUserId = item.ProfileId;
linkAccount.LinkedinUserName = linkAcc.LinkedinUserName;
linkAccount.OAuthSecret = linkAcc.OAuthSecret;
linkAccount.OAuthToken = linkAcc.OAuthToken;
linkAccount.OAuthVerifier = linkAcc.OAuthVerifier;
linkAccount.ProfileImageUrl = linkAcc.ProfileImageUrl;
linkAccount.ProfileUrl = linkAcc.ProfileUrl;
linkAccount.UserId = user.Id;
linkedAccountRepo.addLinkedinUser(linkAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.Message);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
}
lblerror.Text = "Registered Successfully !" + "<a href=\"Default.aspx\">Login</a>";
}
else
{
lblerror.Text = "Email Already Exists " + "<a href=\"Default.aspx\">login</a>";
}
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
lblerror.Text = "Please Insert Correct Information";
Console.WriteLine(ex.StackTrace);
}
}
public void ProcessRequest()
{
TeamRepository objTeamRepository = new TeamRepository();
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
FacebookAccountRepository fbaccountrepo = new FacebookAccountRepository();
TwitterAccountRepository twtaccountrepo = new TwitterAccountRepository();
LinkedInAccountRepository linkedaccrepo = new LinkedInAccountRepository();
InstagramAccountRepository instagramrepo = new InstagramAccountRepository();
GroupProfileRepository groupprofilerepo = new GroupProfileRepository();
BusinessSettingRepository objbsnsrepo = new BusinessSettingRepository();
TumblrAccountRepository tumblrrepo = new TumblrAccountRepository();
User user = (User)Session["LoggedUser"];
if (Request.QueryString["op"] != null)
{
if (Request.QueryString["op"] == "SaveGroupName")
{
string groupName = Request.QueryString["groupname"];
GroupRepository grouprepo = new GroupRepository();
Groups group = new Groups();
group.Id = Guid.NewGuid();
group.GroupName = groupName;
group.UserId = user.Id;
group.EntryDate = DateTime.Now;
if (!grouprepo.checkGroupExists(user.Id, groupName))
{
grouprepo.AddGroup(group);
Groups grou = grouprepo.getGroupDetails(user.Id, groupName);
Session["GroupName"] = grou;
}
else
{
Groups grou = grouprepo.getGroupDetails(user.Id, groupName);
Session["GroupName"] = grou;
}
}
else if (Request.QueryString["op"] == "bindGroupProfiles")
{
string bindprofiles = string.Empty;
Guid groupid = Guid.Parse(Request.QueryString["groupId"]);
Session["GroupId"] = groupid;
GroupProfileRepository groupprofilesrepo = new GroupProfileRepository();
List <GroupProfile> lstgroupprofile = groupprofilesrepo.getAllGroupProfiles(user.Id, groupid);
foreach (GroupProfile item in lstgroupprofile)
{
if (item.ProfileType == "facebook")
{
FacebookAccount account = fbaccountrepo.getFacebookAccountDetailsById(item.ProfileId, user.Id);
if (account != null)
{
bindprofiles += "<div id=\"facebook_" + item.ProfileId + "\" class=\"ws_conct\"> <span class=\"img\"><img width=\"48\" height=\"48\" src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\" alt=\"\"><i><img width=\"16\" height=\"16\" src=\"../Contents/img/fb_icon.png\" alt=\"\"></i></span><div class=\"fourfifth\">" +
"<div class=\"location-container\">" + account.FbUserName + "</div><span onclick=\"AddProfileInInviteTeamMember('" + account.FbUserId + "','" + groupid + "','" + item.ProfileType + "')\" class=\"add remove\">+</span><span onclick=\"RemoveProfileFromGroup('" + item.ProfileId + "')\" class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "twitter")
{
TwitterAccount twtaccount = twtaccountrepo.getUserInformation(user.Id, item.ProfileId);
string profileimgurl = string.Empty;
if (twtaccount != null)
{
if (twtaccount.ProfileImageUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = twtaccount.ProfileImageUrl;
}
bindprofiles +=
"<div id=\"twitter_" + item.ProfileId + "\" class=\"ws_conct active\"> <span class=\"img\"><img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"><i><img width=\"16\" height=\"16\" src=\"../Contents/img/twticon.png\" alt=\"\"></i></span><div class=\"fourfifth\">" +
"<div class=\"location-container\">" + twtaccount.TwitterScreenName + "</div><span onclick=\"AddProfileInInviteTeamMember('" + twtaccount.TwitterUserId + "','" + groupid + "','" + item.ProfileType + "')\" class=\"add remove\">+</span><span onclick=\"RemoveProfileFromGroup('" + item.ProfileId + "')\" class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "linkedin")
{
LinkedInAccount linkedaccount = linkedaccrepo.getUserInformation(user.Id, item.ProfileId);
string profileimgurl = string.Empty;
if (linkedaccount != null)
{
if (linkedaccount.ProfileUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = linkedaccount.ProfileImageUrl;
}
bindprofiles += "<div id=\"linkedin_" + item.ProfileId + "\" class=\"ws_conct active\"><span class=\"img\"><img width=\"48\" height=\"48\" alt=\"\" src=\"" + profileimgurl + "\" ><i>" +
"<img width=\"16\" height=\"16\" alt=\"\" src=\"../Contents/img/link_icon.png\"></i></span>" +
"<div class=\"fourfifth\"><div class=\"location-container\">" + linkedaccount.LinkedinUserName + "</div>" +
"<span onclick=\"AddProfileInInviteTeamMember('" + linkedaccount.LinkedinUserId + "','" + groupid + "','" + item.ProfileType + "')\" class=\"add remove\">+</span><span onclick=\"RemoveProfileFromGroup('" + item.ProfileId + "')\" class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "tumblr")
{
TumblrAccount tumblraccount = tumblrrepo.getTumblrAccountDetailsById(item.ProfileId, user.Id);
string profileimgurl = string.Empty;
if (tumblraccount != null)
{
if (tumblraccount.tblrProfilePicUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = "http://api.tumblr.com/v2/blog/" + tumblraccount.tblrUserName + ".tumblr.com/avatar";
}
bindprofiles += "<div id=\"tumblr_" + item.ProfileId + "\" class=\"ws_conct active\"><span class=\"img\"><img width=\"48\" height=\"48\" alt=\"\" src=\"http://api.tumblr.com/v2/blog/" + tumblraccount.tblrUserName + ".tumblr.com/avatar\" ><i>" +
"<img width=\"16\" height=\"16\" alt=\"\" src=\"../Contents/img/tumblr.png\"></i></span>" +
"<div class=\"fourfifth\"><div class=\"location-container\">" + tumblraccount.tblrUserName + "</div>" +
"<span onclick=\"AddProfileInInviteTeamMember('" + tumblraccount.tblrUserName + "','" + groupid + "','" + item.ProfileType + "')\" class=\"add remove\">+</span><span onclick=\"RemoveProfileFromGroup('" + item.ProfileId + "')\" class=\"add remove\">✖</span></div></div>";
}
}
else if (item.ProfileType == "instagram")
{
string profileimgurl = string.Empty;
InstagramAccount instaaccount = instagramrepo.getInstagramAccountDetailsById(item.ProfileId, user.Id);
if (instaaccount != null)
{
if (instaaccount.ProfileUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = instaaccount.ProfileUrl;
}
bindprofiles += "<div id=\"instagram_" + item.ProfileId + "\" class=\"ws_conct active\"><span class=\"img\"><img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"><i>" +
"<img width=\"16\" height=\"16\" alt=\"\" src=\"../Contents/img/instagram_24X24.png\"></i></span><div class=\"fourfifth\"><div class=\"location-container\">" + instaaccount.InsUserName + "</div>" +
"<span onclick=\"AddProfileInInviteTeamMember('" + instaaccount.InstagramId + "','" + groupid + "','" + item.ProfileType + "')\" class=\"add remove\">+</span><span onclick=\"RemoveProfileFromGroup('" + item.ProfileId + "')\" class=\"add remove\">✖</span></div></div>";
}
}
}
Response.Write(bindprofiles);
}
else if (Request.QueryString["op"] == "deleteGroupName")
{
Guid groupid = Guid.Parse(Request.QueryString["groupId"]);
GroupRepository grouprepo = new GroupRepository();
grouprepo.DeleteGroup(groupid);
int count = groupprofilerepo.DeleteAllGroupProfile(groupid);
int cnt = objbsnsrepo.DeleteBusinessSettingByUserid(groupid);
List <Team> objTeamId = objTeamRepository.getAllDetailsUserEmail(groupid);
foreach (Team item in objTeamId)
{
int deteleTeamMember = objTeamMemberProfileRepository.deleteTeamMember(item.Id);
}
int deleteTeam = objTeamRepository.deleteGroupRelatedTeam(groupid);
}
else if (Request.QueryString["op"] == "addProfilestoGroup")
{
string network = Request.QueryString["network"];
string id = Request.QueryString["profileid"];
Guid groupid = (Guid)Session["GroupId"];
GroupProfile groupprofile = new GroupProfile();
groupprofile.EntryDate = DateTime.Now;
groupprofile.GroupId = groupid;
groupprofile.Id = Guid.NewGuid();
groupprofile.ProfileId = id;
groupprofile.ProfileType = network;
groupprofile.GroupOwnerId = user.Id;
GroupProfileRepository grouprepo = new GroupProfileRepository();
if (!grouprepo.checkGroupProfileExists(user.Id, groupid, id))
{
grouprepo.AddGroupProfile(groupprofile);
}
Response.Write(groupid);
}
else if (Request.QueryString["op"] == "deleteGroupProfiles")
{
Guid groupid = (Guid)Session["GroupId"];
try
{
string profileid = Request.QueryString["profileid"];
GroupProfileRepository grouprepo = new GroupProfileRepository();
grouprepo.DeleteGroupProfile(user.Id, profileid, groupid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
Response.Write(groupid);
}
if (Request.QueryString["op"] == "GetInviteMember")
{
string bindprofiles = string.Empty;
string profileimgurl = string.Empty;
try
{
string gp = Request.QueryString["groupId"];
Guid GroupId = Guid.Parse(gp);
// TeamRepository objTeamRepository = new TeamRepository();
List <Team> objTeam = objTeamRepository.getAllDetailsUserEmail(GroupId);
if (objTeam.Count != 0)
{
foreach (Team item in objTeam)
{
UserRepository objUserRepository = new UserRepository();
User ObjUserDetails = objUserRepository.getUserInfoByEmail(item.EmailId);
if (ObjUserDetails != null)
{
if (string.IsNullOrEmpty(ObjUserDetails.ProfileUrl))
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = ObjUserDetails.ProfileUrl;
}
bindprofiles += "<div style=\"float:left; margin-right:18%\"id=\"" + item.Id + "\">" +
"<div style=\"float:left\"><span class=\"img\"><img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"></span>" +
"</div><div style=\"float:left\" class=\"fourfifth\"><div style=\"font-size:small \">" + ObjUserDetails.UserName + "</div> </div><div style=\"float:left;margin-left:3px\" onclick=\"ShowInviteMemberProfileDetails('" + GroupId + "','" + ObjUserDetails.EmailId + "','" + user.Id + "')\"><input class=\"abc\" type=\"radio\" name=\"sex\" value=" + item.Id + "></div>" +
"<span onclick=\"RemoveInviteMemberFromGroup('" + item.Id + "')\" style=\"margin-left:25px;font-size:small;cursor:pointer;position: absolute; margin-top: 28px;margin-left:10px\">x</span></div>";
//bindprofiles += "<div id=\"" + item.Id + "\" class=\"ws_conct active\"> <span class=\"img\"><img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"><i><img width=\"16\" height=\"16\" src=\"../Contents/img/twticon.png\" alt=\"\"></i></span><div class=\"fourfifth\">" +
// "<div class=\"location-container\">" + ObjUserDetails.UserName + "</div><span class=\"add remove\" onclick=\"ShowInviteMemberProfileDetails('" + GroupId + "','" + ObjUserDetails.EmailId + "','" + user.Id + "')\"><input class=\"abc\" type=\"radio\" name=\"sex\" value=" + item.Id + "></span><span onclick=\"RemoveInviteMemberFromGroup('" + item.Id + "')\" class=\"add remove\">✖</span></div></div>";
}
}
}
Response.Write(bindprofiles);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
if (Request.QueryString["op"] == "RemoveInviteMemberFromGroup")
{
if (!string.IsNullOrEmpty(Request.QueryString["Id"]))
{
try
{
string ide = Request.QueryString["Id"];
Guid id = Guid.Parse(ide);
int deleteTeam = objTeamRepository.deleteinviteteamMember(id);
int deleteProfiles = objTeamMemberProfileRepository.DeleteTeamMemberProfileByTeamId(id);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
//modified by hozefa 4-7-2014
if (Request.QueryString["op"] == "ShowInviteMemberProfileDetails")
{
string bindprofiles = string.Empty;
string gpId = Request.QueryString["groupId"];
Guid gpid = Guid.Parse(gpId);
string emailId = Request.QueryString["emailid"];
string userId = Request.QueryString["userid"];
Team teamdata = objTeamRepository.getAllDetails(gpid, emailId);
List <TeamMemberProfile> objTeamMemProfile = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(teamdata.Id);
try
{
foreach (TeamMemberProfile item in objTeamMemProfile)
{
if (item.ProfileType == "facebook")
{
FacebookAccount account = fbaccountrepo.getFacebookAccountDetailsById(item.ProfileId);
if (account != null)
{
bindprofiles += "<div id=\"item\" style=\"float:left;width:170px;margin-top:6px\" id=\"facebook_" + item.ProfileId + "\"><div style=\"float:left\"<span class=\"img\">" +
"<img width=\"48\" height=\"48\" src=\"http://graph.facebook.com/" + item.ProfileId + "/picture?type=small\" alt=\"\"></img><i><img style=\"margin-left:-18px\" width=\"16\" height=\"16\" src=\"../Contents/img/fb_icon.png\" alt=\"\"></img></i>" +
"</span></div><div style=\"float:left\"><div style=\"font-size:small\">" + account.FbUserName + "</div></div>" +
"<span onclick=\"RemoveInviteMemberProfileFromTeamMember('" + teamdata.Id + "','" + item.ProfileId + "','" + gpId + "','" + emailId + "','" + userId + "')\" style=\"margin-left:25px;font-size:small;cursor:pointer;position: absolute; margin-top: 28px;margin-left:10px\">x</span></div>";
}
}
else if (item.ProfileType == "twitter")
{
TwitterAccount twtaccount = twtaccountrepo.getUserInformation(item.ProfileId);
string profileimgurl = string.Empty;
if (twtaccount != null)
{
if (twtaccount.ProfileImageUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = twtaccount.ProfileImageUrl;
}
bindprofiles += "<div id=\"item\" style=\"float:left; width:170px;margin-top:6px\" id=\"twitter_" + item.ProfileId + "\"><div style=\"float:left\"<span class=\"img\">" +
"<img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"></img><i><img style=\"margin-left:-18px\" width=\"16\" height=\"16\" src=\"../Contents/img/twticon.png\" alt=\"\"></img></i>" +
"</span></div><div style=\"float:left\"><div style=\"font-size:small\">" + twtaccount.TwitterScreenName + "</div></div>" +
"<span onclick=\"RemoveInviteMemberProfileFromTeamMember('" + teamdata.Id + "','" + item.ProfileId + "','" + gpId + "','" + emailId + "','" + userId + "')\" style=\"margin-left:25px;font-size:small;cursor:pointer;position: absolute; margin-top: 28px;margin-left:10px\">x</span></div>";
}
}
else if (item.ProfileType == "linkedin")
{
LinkedInAccount linkedaccount = linkedaccrepo.getUserInformation(item.ProfileId);
string profileimgurl = string.Empty;
if (linkedaccount != null)
{
if (linkedaccount.ProfileUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = linkedaccount.ProfileImageUrl;
}
bindprofiles += "<div id=\"item\" style=\"float:left;width:170px;margin-top:6px\" id=\"linkedin_" + item.ProfileId + "\"><div style=\"float:left\"<span class=\"img\">" +
"<img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"></img><i><img style=\"margin-left:-18px\" width=\"16\" height=\"16\" src=\"../Contents/img/link_icon.png\" alt=\"\"></img></i>" +
"</span></div><div style=\"float:left\"><div style=\"font-size:small\">" + linkedaccount.LinkedinUserName + "</div></div>" +
"<span onclick=\"RemoveInviteMemberProfileFromTeamMember('" + teamdata.Id + "','" + item.ProfileId + "','" + gpId + "','" + emailId + "','" + userId + "')\" style=\"margin-left:25px;font-size:small;cursor:pointer;position: absolute; margin-top: 28px;margin-left:10px\">x</span></div>";
}
}
else if (item.ProfileType == "instagram")
{
string profileimgurl = string.Empty;
InstagramAccount instaaccount = instagramrepo.getInstagramAccountDetailsById(item.ProfileId);
if (instaaccount != null)
{
if (instaaccount.ProfileUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = instaaccount.ProfileUrl;
}
bindprofiles += "<div id=\"item\" style=\"float:left;width:170px; margin-top:6px\" id=\"instagram_" + item.ProfileId + "\"><div style=\"float:left\"<span class=\"img\">" +
"<img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"></img><i><img style=\"margin-left:-18px\" width=\"16\" height=\"16\" src=\"../Contents/img/instagram_24X24.png\" alt=\"\"></img></i>" +
"</span></div><div style=\"float:left\"><div style=\"font-size:small\">" + instaaccount.InsUserName + "</div></div>" +
"<span onclick=\"RemoveInviteMemberProfileFromTeamMember('" + teamdata.Id + "','" + item.ProfileId + "','" + gpId + "','" + emailId + "','" + userId + "')\" style=\"margin-left:25px;font-size:small;cursor:pointer;position: absolute; margin-top: 28px;margin-left:10px\">x</span></div>";
}
}
else if (item.ProfileType == "tumblr")
{
string profileimgurl = string.Empty;
TumblrAccount tumblraccount = tumblrrepo.getTumblrAccountDetailsById(item.ProfileId);
if (tumblraccount != null)
{
if (tumblraccount.tblrProfilePicUrl == string.Empty)
{
profileimgurl = "../../Contents/img/blank_img.png";
}
else
{
profileimgurl = "http://api.tumblr.com/v2/blog/" + tumblraccount.tblrUserName + ".tumblr.com/avatar";
}
bindprofiles += "<div id=\"item\" style=\"float:left;width:170px; margin-top:6px\" id=\"tumblr_" + item.ProfileId + "\"><div style=\"float:left\"<span class=\"img\">" +
"<img width=\"48\" height=\"48\" src=\"" + profileimgurl + "\" alt=\"\"></img><i><img style=\"margin-left:-18px\" width=\"16\" height=\"16\" src=\"../Contents/img/tumblr.png\" alt=\"\"></img></i>" +
"</span></div><div style=\"float:left\"><div style=\"font-size:small\">" + tumblraccount.tblrUserName + "</div></div>" +
"<span onclick=\"RemoveInviteMemberProfileFromTeamMember('" + teamdata.Id + "','" + item.ProfileId + "','" + gpId + "','" + emailId + "','" + userId + "')\" style=\"margin-left:25px;font-size:small;cursor:pointer;position: absolute; margin-top: 28px;margin-left:10px\">x</span></div>";
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
Response.Write(bindprofiles);
}
if (Request.QueryString["op"] == "RemoveInviteMemberProfileFromTeamMember")
{
string profileId = Request.QueryString["ProfileId"];
Guid teamid = Guid.Parse(Request.QueryString["TeamId"]);
try
{
int deleteTeamMembeProfile = objTeamMemberProfileRepository.DeleteTeamMemberProfileByTeamIdProfileId(profileId, teamid);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
if (Request.QueryString["op"] == "AddProfileInInviteTeamMember")
{
try
{
string EmailId = string.Empty;
string Result = string.Empty;
TeamMemberProfile objteam = new TeamMemberProfile();
objteam.ProfileId = Request.QueryString["Profileid"];
objteam.ProfileType = Request.QueryString["Profiletype"];
string GrpId = Request.QueryString["Groupid"];
Guid grpid = Guid.Parse(GrpId);
TeamRepository objTeamrepo = new TeamRepository();
Team team = new Team();
Guid id = Guid.NewGuid();
objteam.Id = id;
string teamid = Request.QueryString["Teamid"];
objteam.TeamId = Guid.Parse(teamid);
objteam.StatusUpdateDate = DateTime.Now;
objteam.Status = 0;
team = objTeamrepo.getAllDetailsByTeamID(objteam.TeamId, grpid);
EmailId = team.EmailId;
try
{
if (!objTeamMemberProfileRepository.checkTeamMemberProfile(objteam.TeamId, objteam.ProfileId))
{
objTeamMemberProfileRepository.addNewTeamMember(objteam);
Result = "Success";
}
else
{
//ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('This Profile Already Added.');", true);
Result = "Fail";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
Response.Write(Result + "_" + EmailId);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
public void getUserProile(oAuthTwitter OAuth, string TwitterScreenName, Guid userId)
{
try
{
Users userinfo = new Users();
TwitterAccount twitterAccount = new TwitterAccount();
TwitterAccountRepository twtrepo = new TwitterAccountRepository();
JArray profile = userinfo.Get_Users_LookUp(OAuth, TwitterScreenName);
foreach (var item in profile)
{
try
{
twitterAccount.FollowingCount = Convert.ToInt32(item["friends_count"].ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twitterAccount.FollowersCount = Convert.ToInt32(item["followers_count"].ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
twitterAccount.IsActive = true;
twitterAccount.OAuthSecret = OAuth.AccessTokenSecret;
twitterAccount.OAuthToken = OAuth.AccessToken;
try
{
twitterAccount.ProfileImageUrl = item["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twitterAccount.ProfileUrl = string.Empty;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twitterAccount.TwitterUserId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception er)
{
try
{
twitterAccount.TwitterUserId = item["id"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception err)
{
Console.WriteLine(err.StackTrace);
}
Console.WriteLine(er.StackTrace);
}
try
{
twitterAccount.TwitterScreenName = item["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
twitterAccount.UserId = userId;
if (twtrepo.checkTwitterUserExists(twitterAccount.TwitterUserId, userId))
{
twtrepo.updateTwitterUser(twitterAccount);
}
getTwitterStats(twitterAccount);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
public string TwitterProfileDetails(string userid, string profileid)
{
Domain.Socioboard.Domain.TwitterAccount objTwitterAccount = new Domain.Socioboard.Domain.TwitterAccount();
TwitterAccountRepository _objTwitterAccountRepository = new TwitterAccountRepository();
if (_objTwitterAccountRepository.checkTwitterUserExists(profileid, Guid.Parse(userid)))
{
objTwitterAccount = _objTwitterAccountRepository.getUserInformation(profileid, Guid.Parse(userid));
}
else
{
objTwitterAccount = _objTwitterAccountRepository.getUserInformation(profileid);
}
return new JavaScriptSerializer().Serialize(objTwitterAccount);
}
public string ProfilesConnected(string UserId, string access_token)
{
//if (!User.Identity.IsAuthenticated)
//{
// return "Unauthorized access";
//}
try
{
Guid userid = Guid.Parse(UserId);
SocialProfilesRepository socialRepo = new SocialProfilesRepository();
List<Domain.Socioboard.Domain.SocialProfile> lstsocioprofile = socialRepo.getAllSocialProfilesOfUser(userid);
List<profileConnected> lstProfile = new List<profileConnected>();
foreach (Domain.Socioboard.Domain.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();
Domain.Socioboard.Domain.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();
Domain.Socioboard.Domain.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();
Domain.Socioboard.Domain.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();
Domain.Socioboard.Domain.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();
Domain.Socioboard.Domain.GooglePlusAccount objGpAcc = objGpAccRepo.getUserDetails(sp.ProfileId);
pc.ProfileName = objGpAcc.GpUserName;
pc.ProfileImgUrl = objGpAcc.GpProfileImage;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (sp.ProfileType == "tumblr")
{
try
{
TumblrAccountRepository objTumblrAccountRepository = new TumblrAccountRepository();
Domain.Socioboard.Domain.TumblrAccount objTumblrAccount = objTumblrAccountRepository.getTumblrAccountDetailsById(sp.ProfileId);
pc.ProfileName = objTumblrAccount.tblrUserName;
pc.ProfileImgUrl = objTumblrAccount.tblrProfilePicUrl;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else if (sp.ProfileType == "youtube")
{
try
{
YoutubeAccountRepository objYoutubeAccountRepository = new YoutubeAccountRepository();
Domain.Socioboard.Domain.YoutubeAccount objYoutubeAccount = objYoutubeAccountRepository.getYoutubeAccountDetailsById(sp.ProfileId);
pc.ProfileName = objYoutubeAccount.Ytusername;
pc.ProfileImgUrl = objYoutubeAccount.Ytprofileimage;
}
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");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SocioBoard.Domain.User user = (User)Session["LoggedUser"];
if (user == null)
{
Response.Redirect("/Default.aspx");
}
TwitterAccountRepository objtwtAccRepo = new TwitterAccountRepository();
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)Session["GroupName"];
List <TeamMemberProfile> allprofiles = objTeamMemberProfileRepository.getTwtTeamMemberProfileData(team.Id);
foreach (TeamMemberProfile item in allprofiles)
{
TwtProfileId += item.ProfileId + ',';
}
TwtProfileId = TwtProfileId.Substring(0, TwtProfileId.Length - 1);
List <TwitterAccount> arrTwtAcc = objtwtAccRepo.getAllAccountDetail(TwtProfileId);
string twtUser = string.Empty;
string twtProfileId = string.Empty;
spandiv.InnerHtml = "from " + DateTime.Now.AddDays(-15).ToShortDateString() + "-" + DateTime.Now.ToShortDateString();
foreach (TwitterAccount item in arrTwtAcc)
{
twtUser = twtUser + "<div class=\"teitter\"><ul><li><a id=\"facebook_connect\" onclick='getProfileGraph(\"" + item.TwitterUserId + "\",\"" + item.TwitterScreenName + "\",\"" + item.ProfileImageUrl + "\",\"" + item.FollowersCount + "\")'><span style=\"float:left;margin: 3px 0 0 5px;\" >" + item.TwitterScreenName + "</span></a></li></ul></div>";
twtProfileId = item.TwitterUserId;
divnameId.InnerHtml = item.TwitterScreenName;
profileImg.ImageUrl = item.ProfileImageUrl;
spanFollowers.InnerHtml = item.FollowersCount.ToString();
Session["twtProfileId"] = twtProfileId;
}
divtwtUser.InnerHtml = twtUser;
try
{
strTwtArray = objtwtStatsHelper.getNewFollowers(twtProfileId, 15);
int index = strTwtArray.LastIndexOf(',');
divnewFollower.InnerHtml = strTwtArray.Substring(index + 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strTwtFollowing = objtwtStatsHelper.getNewFollowing(twtProfileId, 15);
int index = strTwtFollowing.LastIndexOf(',');
divFollowed.InnerHtml = strTwtArray.Substring(index + 1);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strTwtAge = objtwtStatsRepo.getAgeDiffCount(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strIncomingMsg = objtwtStatsHelper.getIncomingMsg(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strDmRecieve = objtwtStatsHelper.getDirectMessageRecieve(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strDMSent = objtwtStatsHelper.getDirectMessageSent(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strSentMsg = objtwtStatsHelper.getSentMsg(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strRetweet = objtwtStatsHelper.getRetweets(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strEngInf = objtwtStatsHelper.getEngagements(twtProfileId, 15) + "@" + objtwtStatsHelper.getInfluence(twtProfileId, 15) + "@" + objtwtStatsHelper.getdate(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strAgeDiff = objtwtStatsRepo.getAgeDiffCount(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
try
{
strTwtMention = objtwtStatsHelper.getTwtMention(twtProfileId, 15);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
}
var strgenderTwt = Session["twtGender"].ToString().Split(',');
//divtwtMale.InnerHtml = strgenderTwt[0] + "%";
// divtwtfeMale.InnerHtml = strgenderTwt[1] + "%";
}
}
public string contactSearchTwitter(string keyword)
{
List<Domain.Socioboard.Domain.DiscoverySearch> lstDiscoverySearch = new List<Domain.Socioboard.Domain.DiscoverySearch>();
string profileid = string.Empty;
try
{
oAuthTwitter oauth = new oAuthTwitter();
Twitter obj = new Twitter();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
ArrayList alst = twtAccRepo.getAllTwitterAccounts();
foreach (Domain.Socioboard.Domain.TwitterAccount item in alst)
{
oauth.AccessToken = item.OAuthToken;
oauth.AccessTokenSecret = item.OAuthSecret;
oauth.TwitterUserId = item.TwitterUserId;
oauth.TwitterScreenName = item.TwitterScreenName;
obj.SetCofigDetailsForTwitter(oauth);
if (this.CheckTwitterToken(oauth, keyword))
{
break;
}
}
Users twtUser = new Users();
JArray twitterSearchResult = twtUser.Get_Users_Search(oauth, keyword, "20");
foreach (var item in twitterSearchResult)
{
try
{
objDiscoverySearch = new Domain.Socioboard.Domain.DiscoverySearch();
objDiscoverySearch.FromId = item["screen_name"].ToString();
objDiscoverySearch.FromName = item["screen_name"].ToString();
objDiscoverySearch.SearchKeyword = keyword;
lstDiscoverySearch.Add(objDiscoverySearch);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
return new JavaScriptSerializer().Serialize(lstDiscoverySearch);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return new JavaScriptSerializer().Serialize("Please try Again");
}
}
protected void btnRegister_Click(object sender, ImageClickEventArgs e)
{
try
{
User user = new User();
UserRepository userrepo = new UserRepository();
UserActivation objUserActivation = new UserActivation();
Coupon objCoupon = new Coupon();
CouponRepository objCouponRepository = new CouponRepository();
Groups groups = new Groups();
GroupRepository objGroupRepository = new GroupRepository();
Team teams = new Team();
TeamRepository objTeamRepository = new TeamRepository();
SocioBoard.Helper.SessionFactory.configfilepath = Server.MapPath("~/hibernate.cfg.xml");
try
{
if (DropDownList1.SelectedValue == "Free" || DropDownList1.SelectedValue == "Standard" || DropDownList1.SelectedValue == "Deluxe" || DropDownList1.SelectedValue == "Premium" || DropDownList1.SelectedValue == "SocioBasic" || DropDownList1.SelectedValue == "SocioStandard" || DropDownList1.SelectedValue == "SocioPremium" || DropDownList1.SelectedValue == "SocioDeluxe")
{
if (TextBox1.Text.Trim() != "")
{
string resp = SBUtils.GetCouponStatus(TextBox1.Text).ToString();
if (resp != "valid")
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + resp + "');", true);
return;
}
}
if (txtPassword.Text == txtConfirmPassword.Text)
{
user.PaymentStatus = "unpaid";
user.AccountType = DropDownList1.SelectedValue.ToString();
if (string.IsNullOrEmpty(user.AccountType))
{
user.AccountType = AccountType.Free.ToString();
}
user.CreateDate = DateTime.Now;
user.ExpiryDate = DateTime.Now.AddDays(30);
user.Id = Guid.NewGuid();
user.UserName = txtFirstName.Text + " " + txtLastName.Text;
user.Password = this.MD5Hash(txtPassword.Text);
user.EmailId = txtEmail.Text;
user.UserStatus = 1;
user.ActivationStatus = "0";
if (TextBox1.Text.Trim() != "")
{
user.CouponCode = TextBox1.Text.Trim().ToString();
}
if (!userrepo.IsUserExist(user.EmailId))
{
logger.Error("Before User reg");
UserRepository.Add(user);
try
{
groups.Id = Guid.NewGuid();
groups.GroupName = ConfigurationManager.AppSettings["DefaultGroupName"];
groups.UserId = user.Id;
groups.EntryDate = DateTime.Now;
objGroupRepository.AddGroup(groups);
teams.Id = Guid.NewGuid();
teams.GroupId = groups.Id;
teams.UserId = user.Id;
teams.EmailId = user.EmailId;
objTeamRepository.addNewTeam(teams);
BusinessSettingRepository busnrepo = new BusinessSettingRepository();
SocioBoard.Domain.BusinessSetting objbsnssetting = new SocioBoard.Domain.BusinessSetting();
if (!busnrepo.checkBusinessExists(user.Id, groups.GroupName))
{
objbsnssetting.Id = Guid.NewGuid();
objbsnssetting.BusinessName = groups.GroupName;
objbsnssetting.GroupId = groups.Id;
objbsnssetting.AssigningTasks = false;
objbsnssetting.AssigningTasks = false;
objbsnssetting.TaskNotification = false;
objbsnssetting.TaskNotification = false;
objbsnssetting.FbPhotoUpload = 0;
objbsnssetting.UserId = user.Id;
objbsnssetting.EntryDate = DateTime.Now;
busnrepo.AddBusinessSetting(objbsnssetting);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error("Error : " + ex.Message);
logger.Error("Error : " + ex.StackTrace);
}
try
{
logger.Error("1 Request.QueryString[refid]");
if (Request.QueryString["refid"] != null)
{
logger.Error("3 Request.QueryString[refid]");
User UserValid = null;
if (IsUserValid(Request.QueryString["refid"].ToString(), ref UserValid))
{
logger.Error("Inside IsUserValid");
user.RefereeStatus = "1";
UpdateUserReference(UserValid);
AddUserRefreeRelation(user, UserValid);
logger.Error("IsUserValid");
}
else
{
user.RefereeStatus = "0";
}
}
logger.Error("2 Request.QueryString[refid]");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error("btnRegister_Click" + ex.Message);
logger.Error("btnRegister_Click" + ex.StackTrace);
}
if (TextBox1.Text.Trim() != "")
{
objCoupon.CouponCode = TextBox1.Text.Trim();
List <Coupon> lstCoupon = objCouponRepository.GetCouponByCouponCode(objCoupon);
objCoupon.Id = lstCoupon[0].Id;
objCoupon.EntryCouponDate = lstCoupon[0].EntryCouponDate;
objCoupon.ExpCouponDate = lstCoupon[0].ExpCouponDate;
objCoupon.Status = "1";
objCouponRepository.SetCouponById(objCoupon);
}
Session["LoggedUser"] = user;
objUserActivation.Id = Guid.NewGuid();
objUserActivation.UserId = user.Id;
objUserActivation.ActivationStatus = "0";
UserActivationRepository.Add(objUserActivation);
//add package start
UserPackageRelation objUserPackageRelation = new UserPackageRelation();
UserPackageRelationRepository objUserPackageRelationRepository = new UserPackageRelationRepository();
PackageRepository objPackageRepository = new PackageRepository();
try
{
Package objPackage = objPackageRepository.getPackageDetails(user.AccountType);
objUserPackageRelation.Id = Guid.NewGuid();
objUserPackageRelation.PackageId = objPackage.Id;
objUserPackageRelation.UserId = user.Id;
objUserPackageRelation.ModifiedDate = DateTime.Now;
objUserPackageRelation.PackageStatus = true;
objUserPackageRelationRepository.AddUserPackageRelation(objUserPackageRelation);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
//end package
SocioBoard.Helper.MailSender.SendEMail(txtFirstName.Text, txtPassword.Text, txtEmail.Text, user.AccountType.ToString(), user.Id.ToString());
TeamRepository teamRepo = new TeamRepository();
try
{
Team team = teamRepo.getTeamByEmailId(txtEmail.Text);
if (team != null)
{
Guid teamid = Guid.Parse(Request.QueryString["tid"]);
teamRepo.updateTeamStatus(teamid);
TeamMemberProfileRepository teamMemRepo = new TeamMemberProfileRepository();
List <TeamMemberProfile> lstteammember = teamMemRepo.getAllTeamMemberProfilesOfTeam(team.Id);
foreach (TeamMemberProfile item in lstteammember)
{
try
{
SocialProfilesRepository socialRepo = new SocialProfilesRepository();
SocialProfile socioprofile = new SocialProfile();
socioprofile.Id = Guid.NewGuid();
socioprofile.ProfileDate = DateTime.Now;
socioprofile.ProfileId = item.ProfileId;
socioprofile.ProfileType = item.ProfileType;
socioprofile.UserId = user.Id;
socialRepo.addNewProfileForUser(socioprofile);
if (item.ProfileType == "facebook")
{
try
{
FacebookAccount fbAccount = new FacebookAccount();
FacebookAccountRepository fbAccountRepo = new FacebookAccountRepository();
FacebookAccount userAccount = fbAccountRepo.getUserDetails(item.ProfileId);
fbAccount.AccessToken = userAccount.AccessToken;
fbAccount.EmailId = userAccount.EmailId;
fbAccount.FbUserId = item.ProfileId;
fbAccount.FbUserName = userAccount.FbUserName;
fbAccount.Friends = userAccount.Friends;
fbAccount.Id = Guid.NewGuid();
fbAccount.IsActive = 1;
fbAccount.ProfileUrl = userAccount.ProfileUrl;
fbAccount.Type = userAccount.Type;
fbAccount.UserId = user.Id;
fbAccountRepo.addFacebookUser(fbAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "twitter")
{
try
{
TwitterAccount twtAccount = new TwitterAccount();
TwitterAccountRepository twtAccRepo = new TwitterAccountRepository();
TwitterAccount twtAcc = twtAccRepo.getUserInfo(item.ProfileId);
twtAccount.FollowersCount = twtAcc.FollowersCount;
twtAccount.FollowingCount = twtAcc.FollowingCount;
twtAccount.Id = Guid.NewGuid();
twtAccount.IsActive = true;
twtAccount.OAuthSecret = twtAcc.OAuthSecret;
twtAccount.OAuthToken = twtAcc.OAuthToken;
twtAccount.ProfileImageUrl = twtAcc.ProfileImageUrl;
twtAccount.ProfileUrl = twtAcc.ProfileUrl;
twtAccount.TwitterName = twtAcc.TwitterName;
twtAccount.TwitterScreenName = twtAcc.TwitterScreenName;
twtAccount.TwitterUserId = twtAcc.TwitterUserId;
twtAccount.UserId = user.Id;
twtAccRepo.addTwitterkUser(twtAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "instagram")
{
try
{
InstagramAccount insAccount = new InstagramAccount();
InstagramAccountRepository insAccRepo = new InstagramAccountRepository();
InstagramAccount InsAcc = insAccRepo.getInstagramAccountById(item.ProfileId);
insAccount.AccessToken = InsAcc.AccessToken;
insAccount.FollowedBy = InsAcc.FollowedBy;
insAccount.Followers = InsAcc.Followers;
insAccount.Id = Guid.NewGuid();
insAccount.InstagramId = item.ProfileId;
insAccount.InsUserName = InsAcc.InsUserName;
insAccount.IsActive = true;
insAccount.ProfileUrl = InsAcc.ProfileUrl;
insAccount.TotalImages = InsAcc.TotalImages;
insAccount.UserId = user.Id;
insAccRepo.addInstagramUser(insAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.Message);
}
}
else if (item.ProfileType == "linkedin")
{
try
{
LinkedInAccount linkAccount = new LinkedInAccount();
LinkedInAccountRepository linkedAccountRepo = new LinkedInAccountRepository();
LinkedInAccount linkAcc = linkedAccountRepo.getLinkedinAccountDetailsById(item.ProfileId);
linkAccount.Id = Guid.NewGuid();
linkAccount.IsActive = true;
linkAccount.LinkedinUserId = item.ProfileId;
linkAccount.LinkedinUserName = linkAcc.LinkedinUserName;
linkAccount.OAuthSecret = linkAcc.OAuthSecret;
linkAccount.OAuthToken = linkAcc.OAuthToken;
linkAccount.OAuthVerifier = linkAcc.OAuthVerifier;
linkAccount.ProfileImageUrl = linkAcc.ProfileImageUrl;
linkAccount.ProfileUrl = linkAcc.ProfileUrl;
linkAccount.UserId = user.Id;
linkedAccountRepo.addLinkedinUser(linkAccount);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
logger.Error(ex.Message);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
#region SetInvitationStatusAfterSuccessfulRegistration
try
{
if (Request.QueryString["refid"] != null)
{
string refid = Request.QueryString["refid"];
int res = SetInvitationStatusAfterSuccessfulRegistration(refid, txtEmail.Text);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
#endregion
try
{
lblerror.Text = "Registered Successfully !" + "<a href=\"Default.aspx\">Login</a>";
Response.Redirect("~/Home.aspx");
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
else
{
lblerror.Text = "Email Already Exists " + "<a id=\"loginlink\" href=\"#\">login</a>";
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Account Type!');", true);
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
lblerror.Text = "Success!";
Console.WriteLine(ex.StackTrace);
//Response.Redirect("Home.aspx");
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
Console.WriteLine(ex.StackTrace);
//Response.Redirect("Home.aspx");
}
}
public void getUserProile(oAuthTwitter OAuth, string TwitterScreenName, Guid userId)
{
try
{
Users userinfo = new Users();
//TwitterAccount twitterAccount = new TwitterAccount();
Domain.Socioboard.Domain.TwitterAccount twitterAccount = new Domain.Socioboard.Domain.TwitterAccount();
TwitterAccountRepository twtrepo = new TwitterAccountRepository();
JArray profile = userinfo.Get_Users_LookUp(OAuth, TwitterScreenName);
foreach (var item in profile)
{
try
{
twitterAccount.FollowingCount = Convert.ToInt32(item["friends_count"].ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twitterAccount.FollowersCount = Convert.ToInt32(item["followers_count"].ToString());
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
twitterAccount.IsActive = true;
twitterAccount.OAuthSecret = OAuth.AccessTokenSecret;
twitterAccount.OAuthToken = OAuth.AccessToken;
try
{
twitterAccount.ProfileImageUrl = item["profile_image_url"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twitterAccount.ProfileUrl = string.Empty;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
try
{
twitterAccount.TwitterUserId = item["id_str"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception er)
{
try
{
twitterAccount.TwitterUserId = item["id"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception err)
{
Console.WriteLine(err.StackTrace);
}
Console.WriteLine(er.StackTrace);
}
try
{
twitterAccount.TwitterScreenName = item["screen_name"].ToString().TrimStart('"').TrimEnd('"');
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
twitterAccount.UserId = userId;
if (twtrepo.checkTwitterUserExists(twitterAccount.TwitterUserId, userId))
{
twtrepo.updateTwitterUser(twitterAccount);
}
getTwitterStats(twitterAccount);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
public void twitterrecentdetails(JArray data)
{
Domain.Socioboard.Domain.TwitterRecentDetails insertdata = new Domain.Socioboard.Domain.TwitterRecentDetails();
TwitterAccountRepository objTwtRepo = new TwitterAccountRepository();
string TwitterId = string.Empty;
Guid Id = Guid.NewGuid();
try
{
TwitterId = data[0]["id_str"].ToString();
}
catch (Exception)
{
TwitterId = string.Empty;
}
if (!string.IsNullOrEmpty(TwitterId))
{
string AccountCreationDate = string.Empty;
string LastActivityDate = string.Empty;
string lastfeed = string.Empty;
string FeedId = string.Empty;
string retweetcount = string.Empty;
string favoritecount = string.Empty;
try
{
DateTime AccntCreationDate = Utility.ParseTwitterTime((data[0]["created_at"].ToString()));
AccountCreationDate = AccntCreationDate.ToString();
}
catch (Exception)
{
AccountCreationDate = string.Empty;
}
try
{
DateTime lastactivitydate = Utility.ParseTwitterTime((data[0]["status"]["created_at"].ToString()));
LastActivityDate = lastactivitydate.ToString();
}
catch (Exception)
{
LastActivityDate = string.Empty;
}
try
{
lastfeed = data[0]["status"]["text"].ToString();
FeedId = data[0]["status"]["id_str"].ToString();
retweetcount = data[0]["status"]["retweet_count"].ToString();
favoritecount = data[0]["status"]["favorite_count"].ToString();
}
catch (Exception)
{
lastfeed = string.Empty;
FeedId = string.Empty;
retweetcount = string.Empty;
favoritecount = string.Empty;
}
insertdata.Id = Id;
insertdata.TwitterId = TwitterId;
insertdata.AccountCreationDate = AccountCreationDate;
insertdata.LastActivityDate = LastActivityDate;
insertdata.LastFeed = lastfeed;
insertdata.FeedId = FeedId;
insertdata.FeedRetweetCount = retweetcount;
insertdata.FeedFavoriteCount = favoritecount;
objTwtRepo.InsertTwitterRecentDetails(insertdata);
}
}
public String getTwitterData(string UserId, string twitterid)
{
string ret = string.Empty;
try
{
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls;
Guid userId = Guid.Parse(UserId);
oAuthTwitter OAuth = new oAuthTwitter(ConfigurationManager.AppSettings["consumerKey"], ConfigurationManager.AppSettings["consumerSecret"], ConfigurationManager.AppSettings["callbackurl"]);
TwitterAccountRepository objTwtRepo = new TwitterAccountRepository();
List<Domain.Socioboard.Domain.TwitterAccount> lstTwitterAccount = objTwtRepo.getAllTwitterAccountsOfUser(userId);
foreach (Domain.Socioboard.Domain.TwitterAccount itemTwt in lstTwitterAccount)
{
string profileId = string.Empty;
OAuth.AccessToken = itemTwt.OAuthToken;
OAuth.AccessTokenSecret = itemTwt.OAuthSecret;
getUserProile(OAuth, itemTwt.TwitterUserId, userId);
//getUserTweets(OAuth, itemTwt.TwitterScreenName, itemTwt.TwitterUserId, userId);
getUserTweets(OAuth, itemTwt.TwitterScreenName, itemTwt.TwitterUserId, userId, itemTwt);
gettwitterengagement(OAuth, userId, itemTwt);
getUserFeed(OAuth, itemTwt.TwitterScreenName, itemTwt.TwitterUserId, userId);
getTwitterDirectMessageSent(UserId, OAuth);
getTwittwrDirectMessageRecieved(OAuth, UserId);
getUserMentions(OAuth, itemTwt.TwitterUserId, Guid.Parse(UserId));
getUserFollowersData(OAuth, itemTwt.TwitterScreenName, itemTwt.TwitterUserId, Guid.Parse(UserId));
getUserRetweet(OAuth, itemTwt.TwitterUserId, Guid.Parse(UserId));
#region UpdateTeammemberprofile
Domain.Socioboard.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Socioboard.Domain.TeamMemberProfile();
objTeamMemberProfile.ProfileName = itemTwt.TwitterScreenName;
objTeamMemberProfile.ProfilePicUrl = itemTwt.ProfileImageUrl;
objTeamMemberProfile.ProfileId = itemTwt.TwitterUserId;
objTeamMemberProfileRepository.updateTeamMemberbyprofileid(objTeamMemberProfile);
#endregion
Domain.Socioboard.Domain.TwitterAccount _TwitterAccount = objTwtRepo.GetUserInformation(itemTwt.UserId, itemTwt.TwitterUserId);
if (_TwitterAccount != null)
getTwitterStats(_TwitterAccount);
}
return "twitter Info Updated Successfully";
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return ret;
}
public IHttpActionResult DeleteUserDetails(string user)
{
GroupsRepository _GroupsRepository = new GroupsRepository();
GroupMembersRepository _GroupMembersRepository = new GroupMembersRepository();
GroupProfileRepository _GroupProfileRepository = new GroupProfileRepository();
TaskRepository _TaskRepository = new TaskRepository();
TaskCommentRepository _TaskCommentRepository = new TaskCommentRepository();
InboxMessagesRepository _InboxMessagesRepository = new InboxMessagesRepository();
FacebookAccountRepository _FacebookAccountRepository = new FacebookAccountRepository();
GoogleAnalyticsAccountRepository _GoogleAnalyticsAccountRepository = new GoogleAnalyticsAccountRepository();
GooglePlusAccountRepository _GooglePlusAccountRepository = new GooglePlusAccountRepository();
InstagramAccountRepository _InstagramAccountRepository = new InstagramAccountRepository();
LinkedInAccountRepository _LinkedInAccountRepository = new LinkedInAccountRepository();
LinkedinCompanyPageRepository _LinkedinCompanyPageRepository = new LinkedinCompanyPageRepository();
ScheduledMessageRepository _ScheduledMessageRepository = new ScheduledMessageRepository();
SocialProfilesRepository _SocialProfilesRepository = new SocialProfilesRepository();
TwitterAccountRepository _TwitterAccountRepository = new TwitterAccountRepository();
TumblrAccountRepository _TumblrAccountRepository = new TumblrAccountRepository();
YoutubeAccountRepository _YoutubeAccountRepository = new YoutubeAccountRepository();
YoutubeChannelRepository _YoutubeChannelRepository = new YoutubeChannelRepository();
try
{
Domain.Socioboard.Domain.User _User = userrepo.getUserInfoByEmail(user);
if (_User != null)
{
List <Domain.Socioboard.Domain.Groups> lstGroups = _GroupsRepository.getAllGroups(_User.Id);
foreach (Domain.Socioboard.Domain.Groups item_group in lstGroups)
{
int i = _GroupMembersRepository.DeleteGroupMember(item_group.Id.ToString());
int j = _GroupProfileRepository.DeleteAllGroupProfile(item_group.Id);
bool rt = _GroupProfileRepository.DeleteGroupReport(item_group.Id);
int k = _TaskRepository.DeleteTaskOfGroup(item_group.Id);
}
int g = _GroupMembersRepository.DeleteGroupMemberByUserId(user);
int h = _GroupsRepository.DeleteGroupsByUserid(_User.Id);
int l = _TaskCommentRepository.DeleteTaskCommentByUserid(_User.Id);
int m = _InboxMessagesRepository.DeleteInboxMessages(_User.Id);
int n = _FacebookAccountRepository.DeleteAllFacebookAccount(_User.Id);
int o = _GoogleAnalyticsAccountRepository.DeleteGoogleAnalyticsAccountByUserid(_User.Id);
int p = _GooglePlusAccountRepository.DeleteGooglePlusAccountByUserid(_User.Id);
int q = _InstagramAccountRepository.DeleteInstagramAccountByUserid(_User.Id);
int r = _LinkedInAccountRepository.DeleteLinkedInAccountByUserid(_User.Id);
int s = _LinkedinCompanyPageRepository.DeleteLinkedinCompanyPage(_User.Id);
int t = _ScheduledMessageRepository.DeleteScheduledMessageByUserid(_User.Id);
int u = _SocialProfilesRepository.DeleteSocialProfileByUserid(_User.Id);
int v = _TwitterAccountRepository.DeleteTwitterAccountByUserid(_User.Id);
int w = _TumblrAccountRepository.DeletetumblraccountByUserid(_User.Id);
int x = _YoutubeAccountRepository.DeleteYoutubeAccount(_User.Id);
int y = _YoutubeChannelRepository.DeleteYoutubeChannelByUserid(_User.Id);
int z = userrepo.DeleteUser(_User.Id);
}
else
{
return(Ok(false));
}
}
catch (Exception ex)
{
return(BadRequest(ex.StackTrace));
}
return(Ok(true));
}
