public string getYoutubeData(string UserId, string youtubeId)
{
string ret = string.Empty;
try
{
Guid userId = Guid.Parse(UserId);
oAuthToken OAuthToken = new oAuthToken();
OAuthToken.ConsumerKey = ConfigurationManager.AppSettings["YtconsumerKey"];
OAuthToken.ConsumerSecret = ConfigurationManager.AppSettings["YtconsumerSecret"];
YoutubeAccountRepository ObjYoutubeAccountRepository = new YoutubeAccountRepository();
Domain.Socioboard.Domain.YoutubeAccount ObjYoutubeAccount = ObjYoutubeAccountRepository.getYoutubeAccountDetailsById(youtubeId, userId);
AddYouTubeChannels(userId.ToString(), ObjYoutubeAccount.Accesstoken, youtubeId);
return "Youtube Channel is added";
}
catch (Exception ex)
{
throw;
}
}
public string AddYoutubeAccount(string client_id, string client_secret, string redirect_uri, string UserId, string GroupId, string code)
{
#region Local variables Inisitalisation
string ret = string.Empty;
string objRefresh = string.Empty;
string refreshToken = string.Empty;
string access_token = string.Empty;
oAuthTokenYoutube ObjoAuthTokenYoutube = new oAuthTokenYoutube();
oAuthToken objToken = new oAuthToken();
Domain.Socioboard.Domain.YoutubeAccount objYoutubeAccount = new Domain.Socioboard.Domain.YoutubeAccount();
Domain.Socioboard.Domain.YoutubeChannel objYoutubeChannel;
YoutubeChannelRepository objYoutubeChannelRepository = new YoutubeChannelRepository();
YoutubeAccountRepository objYoutubeAccountRepository = new YoutubeAccountRepository();
#endregion
#region Get AccessToken and RefreshToken
objToken.ConsumerKey = client_id;
objToken.ConsumerSecret = client_secret;
try
{
objRefresh = ObjoAuthTokenYoutube.GetRefreshToken(code, client_id, client_secret, redirect_uri);
logger.Error("Abhay: ObjoAuthTokenYoutube()");
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
JObject objaccesstoken = JObject.Parse(objRefresh);
try
{
refreshToken = objaccesstoken["refresh_token"].ToString();
}
catch (Exception ex)
{
access_token = objaccesstoken["access_token"].ToString();
ObjoAuthTokenYoutube.RevokeToken(access_token);
Console.WriteLine(ex.StackTrace);
return("Refresh Token Not Found");
}
try
{
access_token = objaccesstoken["access_token"].ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
#endregion
#region Get user Profile and Add Youtube Account
JArray userinfo = new JArray();
try
{
userinfo = objToken.GetUserInfo("me", access_token.ToString());
}
catch (Exception ex)
{
}
foreach (var itemEmail in userinfo)
{
try
{
objYoutubeAccount.Id = Guid.NewGuid();
objYoutubeAccount.Ytuserid = itemEmail["id"].ToString();
objYoutubeAccount.Emailid = itemEmail["email"].ToString();
try
{
objYoutubeAccount.Ytusername = itemEmail["given_name"].ToString();
}
catch (Exception ex)
{
objYoutubeAccount.Ytusername = itemEmail["name"].ToString();
}
objYoutubeAccount.Ytprofileimage = itemEmail["picture"].ToString();
objYoutubeAccount.Accesstoken = access_token;
objYoutubeAccount.Refreshtoken = refreshToken;
objYoutubeAccount.Isactive = 1;
objYoutubeAccount.Entrydate = DateTime.Now;
objYoutubeAccount.UserId = Guid.Parse(UserId);
if (!objYoutubeAccountRepository.checkYoutubeUserExists(objYoutubeAccount))
{
YoutubeAccountRepository.Add(objYoutubeAccount);
ret = "Account Added Successfully";
}
else
{
ret = "Account already Exist !";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
#endregion
#region Add Youtube Channels
GlobusGooglePlusLib.Youtube.Core.Channels ObjChannel = new GlobusGooglePlusLib.Youtube.Core.Channels();
JArray objarray = new JArray();
try
{
string part = (oAuthTokenYoutube.Parts.contentDetails.ToString() + "," + oAuthTokenYoutube.Parts.statistics.ToString());
string Value = ObjChannel.Get_Channel_List(access_token, part, 50, true);
JObject UserChannels = JObject.Parse(@Value);
objarray = (JArray)UserChannels["items"];
}
catch (Exception ex)
{
}
foreach (var item in objarray)
{
objYoutubeChannel = new Domain.Socioboard.Domain.YoutubeChannel();
try
{
objYoutubeChannel.Id = Guid.NewGuid();
objYoutubeChannel.Channelid = item["id"].ToString();
objYoutubeChannel.Likesid = item["contentDetails"]["relatedPlaylists"]["likes"].ToString();
objYoutubeChannel.Favoritesid = item["contentDetails"]["relatedPlaylists"]["favorites"].ToString();
objYoutubeChannel.Uploadsid = item["contentDetails"]["relatedPlaylists"]["uploads"].ToString();
objYoutubeChannel.Watchhistoryid = item["contentDetails"]["relatedPlaylists"]["watchHistory"].ToString();
objYoutubeChannel.Watchlaterid = item["contentDetails"]["relatedPlaylists"]["watchLater"].ToString();
objYoutubeChannel.Googleplususerid = objYoutubeAccount.Ytuserid;
objYoutubeChannel.UserId = Guid.Parse(UserId);
try
{
string viewcnt = item["statistics"]["viewCount"].ToString();
objYoutubeChannel.ViewCount = Convert.ToInt32(viewcnt);
string videocnt = item["statistics"]["videoCount"].ToString();
objYoutubeChannel.VideoCount = Convert.ToInt32(videocnt);
string commentcnt = item["statistics"]["commentCount"].ToString();
objYoutubeChannel.CommentCount = Convert.ToInt32(commentcnt);
string Subscribercnt = item["statistics"]["subscriberCount"].ToString();
objYoutubeChannel.SubscriberCount = Convert.ToInt32(Subscribercnt);
try
{
string str = item["statistics"]["hiddenSubscriberCount"].ToString();
if (str == "false")
{
objYoutubeChannel.HiddenSubscriberCount = 0;
}
else
{
objYoutubeChannel.HiddenSubscriberCount = 1;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!objYoutubeChannelRepository.checkYoutubeChannelExists(objYoutubeChannel.Channelid, Guid.Parse(UserId)))
{
YoutubeChannelRepository.Add(objYoutubeChannel);
}
}
#endregion
#region Add TeamMemberProfile
//Domain.Socioboard.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
//Domain.Socioboard.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Socioboard.Domain.TeamMemberProfile();
//objTeamMemberProfile.Id = Guid.NewGuid();
//objTeamMemberProfile.TeamId = objTeam.Id;
//objTeamMemberProfile.Status = 1;
//objTeamMemberProfile.ProfileType = "youtube";
//objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
//objTeamMemberProfile.ProfileId = objYoutubeAccount.Ytuserid;
//objTeamMemberProfile.ProfileName = objYoutubeAccount.Ytusername;
//objTeamMemberProfile.ProfilePicUrl = objYoutubeAccount.Ytprofileimage;
//if (!objTeamMemberProfileRepository.checkTeamMemberProfilebyType(objTeam.Id, objYoutubeAccount.Ytuserid, "youtube"))
//{
// objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
//}
Domain.Socioboard.Domain.GroupProfile grpProfile = new Domain.Socioboard.Domain.GroupProfile();
grpProfile.Id = Guid.NewGuid();
grpProfile.EntryDate = DateTime.UtcNow;
grpProfile.GroupId = Guid.Parse(GroupId);
grpProfile.GroupOwnerId = Guid.Parse(UserId);
grpProfile.ProfileId = objYoutubeAccount.Ytuserid;
grpProfile.ProfileType = "youtube";
grpProfile.ProfileName = objYoutubeAccount.Ytusername;
grpProfile.ProfilePic = objYoutubeAccount.Ytprofileimage;
#endregion
#region SocialProfile
Domain.Socioboard.Domain.SocialProfile objSocialProfile = new Domain.Socioboard.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.ProfileType = "youtube";
objSocialProfile.ProfileId = objYoutubeAccount.Ytuserid;
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
grpProfileRepo.AddGroupProfile(grpProfile);
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
#endregion
GetYoutubeChannelVideos(UserId, objYoutubeAccount.Ytuserid);
return(ret);
}
public string AddYoutubeAccount(string client_id, string client_secret, string redirect_uri, string UserId, string GroupId, string code)
{
#region Local variables Inisitalisation
string ret = string.Empty;
string objRefresh = string.Empty;
string refreshToken = string.Empty;
string access_token = string.Empty;
oAuthTokenYoutube ObjoAuthTokenYoutube = new oAuthTokenYoutube();
oAuthToken objToken = new oAuthToken();
Domain.Socioboard.Domain.YoutubeAccount objYoutubeAccount = new Domain.Socioboard.Domain.YoutubeAccount();
Domain.Socioboard.Domain.YoutubeChannel objYoutubeChannel;
YoutubeChannelRepository objYoutubeChannelRepository = new YoutubeChannelRepository();
YoutubeAccountRepository objYoutubeAccountRepository = new YoutubeAccountRepository();
#endregion
#region Get AccessToken and RefreshToken
objToken.ConsumerKey = client_id;
objToken.ConsumerSecret = client_secret;
try
{
objRefresh = ObjoAuthTokenYoutube.GetRefreshToken(code, client_id, client_secret, redirect_uri);
logger.Error("Abhay: ObjoAuthTokenYoutube()");
}
catch (Exception ex)
{
logger.Error(ex.Message);
logger.Error(ex.StackTrace);
}
JObject objaccesstoken = JObject.Parse(objRefresh);
try
{
refreshToken = objaccesstoken["refresh_token"].ToString();
}
catch (Exception ex)
{
access_token = objaccesstoken["access_token"].ToString();
ObjoAuthTokenYoutube.RevokeToken(access_token);
Console.WriteLine(ex.StackTrace);
return "Refresh Token Not Found";
}
try
{
access_token = objaccesstoken["access_token"].ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
#endregion
#region Get user Profile and Add Youtube Account
JArray userinfo = new JArray();
try
{
userinfo = objToken.GetUserInfo("me", access_token.ToString());
}
catch (Exception ex)
{
}
foreach (var itemEmail in userinfo)
{
try
{
objYoutubeAccount.Id = Guid.NewGuid();
objYoutubeAccount.Ytuserid = itemEmail["id"].ToString();
objYoutubeAccount.Emailid = itemEmail["email"].ToString();
try
{
objYoutubeAccount.Ytusername = itemEmail["given_name"].ToString();
}
catch (Exception ex)
{
objYoutubeAccount.Ytusername = itemEmail["name"].ToString();
}
objYoutubeAccount.Ytprofileimage = itemEmail["picture"].ToString();
objYoutubeAccount.Accesstoken = access_token;
objYoutubeAccount.Refreshtoken = refreshToken;
objYoutubeAccount.Isactive = 1;
objYoutubeAccount.Entrydate = DateTime.Now;
objYoutubeAccount.UserId = Guid.Parse(UserId);
if (!objYoutubeAccountRepository.checkYoutubeUserExists(objYoutubeAccount))
{
YoutubeAccountRepository.Add(objYoutubeAccount);
ret = "Account Added Successfully";
}
else
{
ret = "Account already Exist !";
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
#endregion
#region Add Youtube Channels
GlobusGooglePlusLib.Youtube.Core.Channels ObjChannel = new GlobusGooglePlusLib.Youtube.Core.Channels();
JArray objarray = new JArray();
try
{
string part = (oAuthTokenYoutube.Parts.contentDetails.ToString() + "," + oAuthTokenYoutube.Parts.statistics.ToString());
string Value = ObjChannel.Get_Channel_List(access_token, part, 50, true);
JObject UserChannels = JObject.Parse(@Value);
objarray = (JArray)UserChannels["items"];
}
catch (Exception ex)
{
}
foreach (var item in objarray)
{
objYoutubeChannel = new Domain.Socioboard.Domain.YoutubeChannel();
try
{
objYoutubeChannel.Id = Guid.NewGuid();
objYoutubeChannel.Channelid = item["id"].ToString();
objYoutubeChannel.Likesid = item["contentDetails"]["relatedPlaylists"]["likes"].ToString();
objYoutubeChannel.Favoritesid = item["contentDetails"]["relatedPlaylists"]["favorites"].ToString();
objYoutubeChannel.Uploadsid = item["contentDetails"]["relatedPlaylists"]["uploads"].ToString();
objYoutubeChannel.Watchhistoryid = item["contentDetails"]["relatedPlaylists"]["watchHistory"].ToString();
objYoutubeChannel.Watchlaterid = item["contentDetails"]["relatedPlaylists"]["watchLater"].ToString();
objYoutubeChannel.Googleplususerid = objYoutubeAccount.Ytuserid;
objYoutubeChannel.UserId = Guid.Parse(UserId);
try
{
string viewcnt = item["statistics"]["viewCount"].ToString();
objYoutubeChannel.ViewCount = Convert.ToInt32(viewcnt);
string videocnt = item["statistics"]["videoCount"].ToString();
objYoutubeChannel.VideoCount = Convert.ToInt32(videocnt);
string commentcnt = item["statistics"]["commentCount"].ToString();
objYoutubeChannel.CommentCount = Convert.ToInt32(commentcnt);
string Subscribercnt = item["statistics"]["subscriberCount"].ToString();
objYoutubeChannel.SubscriberCount = Convert.ToInt32(Subscribercnt);
try
{
string str = item["statistics"]["hiddenSubscriberCount"].ToString();
if (str == "false")
{
objYoutubeChannel.HiddenSubscriberCount = 0;
}
else
{
objYoutubeChannel.HiddenSubscriberCount = 1;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
if (!objYoutubeChannelRepository.checkYoutubeChannelExists(objYoutubeChannel.Channelid, Guid.Parse(UserId)))
{
YoutubeChannelRepository.Add(objYoutubeChannel);
}
}
#endregion
#region Add TeamMemberProfile
Domain.Socioboard.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
Domain.Socioboard.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Socioboard.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "youtube";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = objYoutubeAccount.Ytuserid;
objTeamMemberProfile.ProfileName = objYoutubeAccount.Ytusername;
objTeamMemberProfile.ProfilePicUrl = objYoutubeAccount.Ytprofileimage;
if (!objTeamMemberProfileRepository.checkTeamMemberProfile(objTeam.Id, objYoutubeAccount.Ytuserid))
{
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
}
#endregion
#region SocialProfile
Domain.Socioboard.Domain.SocialProfile objSocialProfile = new Domain.Socioboard.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.ProfileType = "youtube";
objSocialProfile.ProfileId = objYoutubeAccount.Ytuserid;
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
#endregion
return ret;
}
public string ProfilesConnected(string UserId)
{
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"));
}
}
