/// <getMemberByEmailId>
/// Get Team Member By Email Id.and user id.
/// </summary>
/// <param name="UserId">User id.(Guid)</param>
/// <param name="EmailId">Member Email id.(string)</param>
/// <returns>Return the object of Team class with value.(Domain.Team)</returns>
public Domain.Myfashion.Domain.Team getMemberByEmailId(Guid UserId, string EmailId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get details of team by user id and email id.
NHibernate.IQuery query = session.CreateQuery("from Team where UserId = :userid and EmailId =:memberId");
query.SetParameter("userid", UserId);
query.SetParameter("memberId", EmailId);
Domain.Myfashion.Domain.Team alstFBAccounts = query.UniqueResult <Domain.Myfashion.Domain.Team>();
return(alstFBAccounts);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public Domain.Myfashion.Domain.Team getAllDetailsByTeamID(Guid Id, Guid groupId)
{
Domain.Myfashion.Domain.Team objTeam = new Domain.Myfashion.Domain.Team();
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
List <Domain.Myfashion.Domain.Team> alstAccounts = session.CreateQuery("from Team where Id=:id and GroupId=:groupId")
.SetParameter("id", Id)
.SetParameter("groupId", groupId)
.List <Domain.Myfashion.Domain.Team>()
.ToList <Domain.Myfashion.Domain.Team>();
objTeam = alstAccounts[0];
return(objTeam);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <deleteTeam>
/// Delete Team
/// </summary>
/// <param name="team">Set Values of team id and email id in a Team Class Property and Pass the Object of Team Class.(Domein.Team)</param>
/// <returns>Return 1 for success and 0 for failure.(int) </returns>
public int deleteTeam(Domain.Myfashion.Domain.Team team)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to delete team by user id and email id.
NHibernate.IQuery query = session.CreateQuery("delete from Team where UserId = :userid and EmailId = :emailid")
.SetParameter("userid", team.UserId)
.SetParameter("emailid", team.EmailId);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End Session
}
public string GetAllLinkedinCompanyPageByUserIdAndGroupId(string userid, string groupid)
{
try
{
List <Domain.Myfashion.Domain.LinkedinCompanyPage> lstLinkedInCompanyPage = new List <Domain.Myfashion.Domain.LinkedinCompanyPage>();
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(groupid));
List <Domain.Myfashion.Domain.TeamMemberProfile> lstTeamMemberProfile = objTeamMemberProfileRepository.GetTeamMemberProfileByTeamIdAndProfileType(objTeam.Id, "linkedincompanypage");
foreach (var item in lstTeamMemberProfile)
{
try
{
lstLinkedInCompanyPage.Add(objLinkedCmpnyPgeRepo.getCompanyPageInformation(Guid.Parse(userid), item.ProfileId));
}
catch (Exception)
{
}
}
return(new JavaScriptSerializer().Serialize(lstLinkedInCompanyPage));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
public string GetAllLinkedinAccountsByUserIdAndGroupId(string userid, string groupid)
{
try
{
LinkedInAccountRepository _objLinkedInAccountRepository = new LinkedInAccountRepository();
List <Domain.Myfashion.Domain.LinkedInAccount> lstLinkedInAccount = new List <Domain.Myfashion.Domain.LinkedInAccount>();
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(groupid));
List <Domain.Myfashion.Domain.TeamMemberProfile> lstTeamMemberProfile = objTeamMemberProfileRepository.GetTeamMemberProfileByTeamIdAndProfileType(objTeam.Id, "linkedin");
foreach (var item in lstTeamMemberProfile)
{
try
{
if (_objLinkedInAccountRepository.checkLinkedinUserExists(item.ProfileId, Guid.Parse(userid)))
{
lstLinkedInAccount.Add(objlinkedinaccrepo.getUserInformation(Guid.Parse(userid), item.ProfileId));
}
else
{
lstLinkedInAccount.Add(objlinkedinaccrepo.getUserInformation(item.ProfileId));
}
}
catch (Exception)
{
}
}
return(new JavaScriptSerializer().Serialize(lstLinkedInAccount));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
/// <updateTeam>
/// Update Team
/// </summary>
/// <param name="team">Set Values in a Team Class Property and Pass the Object of Team Class.(Domein.Team)</param>
public void updateTeam(Domain.Myfashion.Domain.Team team)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to update team details.
session.CreateQuery("Update Team set FirstName =:firstname,LastName =:lastname,StatusUpdateDate =:statusupdatedate,InviteStatus=:invitestatus,UserId = :userid where Id = :teamid")
.SetParameter("firstname", team.FirstName)
.SetParameter("lastname", team.LastName)
.SetParameter("statusupdatedate", team.StatusUpdateDate)
.SetParameter("invitestatus", team.InviteStatus)
.SetParameter("userid", team.UserId)
.SetParameter("teamid", team.Id)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
} //End Transaction
} //End Session
}
/// <addNewTeam>
/// Add New Team
/// </summary>
/// <param name="team">Set Values in a Team Class Property and Pass the Object of Team Class.(Domein.Team)</param>
public void addNewTeam(Domain.Myfashion.Domain.Team team)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to save new team details.
session.Save(team);
transaction.Commit();
} //End Transaction
} //End Session
}
public string DeleteLinkedinCompanyPage(string UserId, string LinkedinPageId, string GroupId)
{
try
{
objLinkedCmpnyPgeRepo.DeleteLinkedInPageByPageid(LinkedinPageId, Guid.Parse(UserId));
objlinkedpagepostrepo.deleteAllPostOfPage(LinkedinPageId, Guid.Parse(UserId));
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objTeamMemberProfileRepository.DeleteTeamMemberProfileByTeamIdProfileId(LinkedinPageId, objTeam.Id);
objSocialProfilesRepository.deleteProfile(Guid.Parse(UserId), LinkedinPageId);
return(new JavaScriptSerializer().Serialize(""));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
public string DeleteLinkedinAccount(string UserId, string ProfileId, string GroupId)
{
try
{
objlinkedinaccrepo.deleteLinkedinUser(ProfileId, Guid.Parse(UserId));
objLinkedInFeedRepository.deleteAllFeedsOfUser(ProfileId, Guid.Parse(UserId));
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objGroupProfileRepository.DeleteGroupProfile(Guid.Parse(UserId), ProfileId, Guid.Parse(GroupId));
objTeamMemberProfileRepository.DeleteTeamMemberProfileByTeamIdProfileId(ProfileId, objTeam.Id);
objSocialProfilesRepository.deleteProfile(Guid.Parse(UserId), ProfileId);
return(new JavaScriptSerializer().Serialize(""));
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return("Something Went Wrong");
}
}
public string GetSociaoQueueMessageByUserIdAndGroupId(string UserId, string GroupId)
{
string profileid = string.Empty;
TeamRepository objTeamRepository = new TeamRepository();
try
{
Guid userid = Guid.Parse(UserId);
Guid groupid = Guid.Parse(GroupId);
List <Domain.Myfashion.Domain.ScheduledMessage> lstfianlscoailqueue = new List <Domain.Myfashion.Domain.ScheduledMessage>();
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(groupid);
List <Domain.Myfashion.Domain.TeamMemberProfile> allprofiles = objTeamMemberProfileRepository.getAllTeamMemberProfilesOfTeam(objTeam.Id);
ScheduledMessageRepository objScheduledMessageRepository = new ScheduledMessageRepository();
List <Domain.Myfashion.Domain.ScheduledMessage> lstScheduledMessages = new List <Domain.Myfashion.Domain.ScheduledMessage>();
Dictionary <string, List <Domain.Myfashion.Domain.ScheduledMessage> > objdic = new Dictionary <string, List <Domain.Myfashion.Domain.ScheduledMessage> >();
foreach (var item in allprofiles)
{
lstScheduledMessages = objScheduledMessageRepository.getAllMessagesDetail(item.ProfileId, userid);
if (lstScheduledMessages.Count > 0)
{
objdic.Add(item.ProfileId, lstScheduledMessages);
}
}
foreach (var item in objdic)
{
foreach (var ScheduledMessage in item.Value)
{
lstfianlscoailqueue.Add(ScheduledMessage);
}
}
//FacebookAccountRepository facebookAccountRepo = new FacebookAccountRepository();
// FacebookAccount facebook = facebookAccountRepo.getFacebookAccountDetailsById(FacebookId, userid);
return(new JavaScriptSerializer().Serialize(lstfianlscoailqueue));
}
catch (Exception ex)
{
logger.Error(ex.Message);
Console.WriteLine(ex.StackTrace);
return(new JavaScriptSerializer().Serialize("Please try Again"));
}
}
/// <getTeamById>
/// Get Team By Id
/// </summary>
/// <param name="Id">Team id.(Guid)</param>
/// <returns>Return the object of Team class with value.(Domain.Team)</returns>
public Domain.Myfashion.Domain.Team getTeamById(Guid Id)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from Team where Id =:memberId");
query.SetParameter("memberId", Id);
Domain.Myfashion.Domain.Team alstFBAccounts = query.UniqueResult <Domain.Myfashion.Domain.Team>();
return(alstFBAccounts);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
public string AddInstagramAccount(string client_id, string client_secret, string redirect_uri, string UserId, string GroupId, string code)
{
string ret = string.Empty;
oAuthInstagram objInsta = new oAuthInstagram();
GlobusInstagramLib.Authentication.ConfigurationIns configi = new GlobusInstagramLib.Authentication.ConfigurationIns("https://api.instagram.com/oauth/authorize/", client_id, client_secret, redirect_uri, "http://api.instagram.com/oauth/access_token", "https://api.instagram.com/v1/", "");
oAuthInstagram _api = new oAuthInstagram();
_api = oAuthInstagram.GetInstance(configi);
AccessToken access = new AccessToken();
access = _api.AuthGetAccessToken(code);
#region InstagramAccount
UserController objusercontroller = new UserController();
InstagramResponse <GlobusInstagramLib.App.Core.User> objuser = objusercontroller.GetUserDetails(access.user.id, access.access_token);
objInstagramAccount = new Domain.Myfashion.Domain.InstagramAccount();
objInstagramAccount.AccessToken = access.access_token;
objInstagramAccount.InstagramId = access.user.id;
try
{
objInstagramAccount.ProfileUrl = access.user.profile_picture;
}
catch (Exception ex)
{
logger.Error("Instagram.asmx.cs >> AddInstagramAccount >> " + ex.StackTrace);
}
try
{
objInstagramAccount.InsUserName = access.user.username;
}
catch (Exception ex)
{
logger.Error("Instagram.asmx.cs >> AddInstagramAccount >> " + ex.StackTrace);
}
try
{
objInstagramAccount.TotalImages = objuser.data.counts.media;
}
catch (Exception ex)
{
logger.Error("Instagram.asmx.cs >> AddInstagramAccount >> " + ex.StackTrace);
}
try
{
objInstagramAccount.FollowedBy = objuser.data.counts.followed_by;
}
catch (Exception ex)
{
logger.Error("Instagram.asmx.cs >> AddInstagramAccount >> " + ex.StackTrace);
}
try
{
objInstagramAccount.Followers = objuser.data.counts.follows;
}
catch (Exception ex)
{
logger.Error("Instagram.asmx.cs >> AddInstagramAccount >> " + ex.StackTrace);
}
objInstagramAccount.UserId = Guid.Parse(UserId);
#endregion
if (!objInstagramAccountRepository.checkInstagramUserExists(objInstagramAccount.InstagramId, Guid.Parse(UserId)))
{
objInstagramAccountRepository.addInstagramUser(objInstagramAccount);
#region Add TeamMemberProfile
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
Domain.Myfashion.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "instagram";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = objInstagramAccount.InstagramId;
//Modified [13-02-15]
objTeamMemberProfile.ProfilePicUrl = objInstagramAccount.ProfileUrl;
objTeamMemberProfile.ProfileName = objInstagramAccount.InsUserName;
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
#endregion
#region SocialProfile
Domain.Myfashion.Domain.SocialProfile objSocialProfile = new Domain.Myfashion.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.ProfileType = "instagram";
objSocialProfile.ProfileId = objInstagramAccount.InstagramId;
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
#endregion
#region Add SocialProfile
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
#endregion
ret = "Account Added Successfully";
}
else
{
ret = "Account already Exist !";
}
//GetIntagramImages(objInstagramAccount);
GetInstagramFeeds(objInstagramAccount);
return(ret);
}
public void GetPageProfile(dynamic data, oAuthLinkedIn _OAuth, string UserId, string CompanyPageId, string GroupId)
{
Domain.Myfashion.Domain.SocialProfile socioprofile = new Domain.Myfashion.Domain.SocialProfile();
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
Domain.Myfashion.Domain.LinkedinCompanyPage objLinkedincmpnypage = new Domain.Myfashion.Domain.LinkedinCompanyPage();
LinkedinCompanyPageRepository objLinkedCmpnyPgeRepo = new LinkedinCompanyPageRepository();
try
{
objLinkedincmpnypage.UserId = Guid.Parse(UserId);
try
{
objLinkedincmpnypage.LinkedinPageId = data.Pageid.ToString();
}
catch
{
}
objLinkedincmpnypage.Id = Guid.NewGuid();
try
{
objLinkedincmpnypage.EmailDomains = data.EmailDomains.ToString();
}
catch { }
objLinkedincmpnypage.LinkedinPageName = data.name.ToString();
objLinkedincmpnypage.OAuthToken = _OAuth.Token;
objLinkedincmpnypage.OAuthSecret = _OAuth.TokenSecret;
objLinkedincmpnypage.OAuthVerifier = _OAuth.Verifier;
try
{
objLinkedincmpnypage.Description = data.description.ToString();
}
catch { }
try
{
objLinkedincmpnypage.FoundedYear = data.founded_year.ToString();
}
catch { }
try
{
objLinkedincmpnypage.EndYear = data.end_year.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Locations = data.locations.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Specialties = data.Specialties.ToString();
}
catch { }
try
{
objLinkedincmpnypage.WebsiteUrl = data.website_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Status = data.status.ToString();
}
catch { }
try
{
objLinkedincmpnypage.EmployeeCountRange = data.employee_count_range.ToString();
}
catch { }
try
{
objLinkedincmpnypage.Industries = data.industries.ToString();
}
catch { }
try
{
string NuberOfFollower = data.num_followers.ToString();
objLinkedincmpnypage.NumFollowers = Convert.ToInt16(NuberOfFollower);
}
catch { }
try
{
objLinkedincmpnypage.CompanyType = data.company_type.ToString();
}
catch { }
try
{
objLinkedincmpnypage.LogoUrl = data.logo_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.SquareLogoUrl = data.square_logo_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.BlogRssUrl = data.blog_rss_url.ToString();
}
catch { }
try
{
objLinkedincmpnypage.UniversalName = data.universal_name.ToString();
}
catch { }
#region SocialProfiles
socioprofile.UserId = Guid.Parse(UserId);
socioprofile.ProfileType = "linkedincompanypage";
socioprofile.ProfileId = data.Pageid.ToString();;
socioprofile.ProfileStatus = 1;
socioprofile.ProfileDate = DateTime.Now;
socioprofile.Id = Guid.NewGuid();
#endregion
#region TeamMemberProfile
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "linkedincompanypage";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = socioprofile.ProfileId;
#endregion
}
catch
{
}
try
{
if (!objSocialProfilesRepository.checkUserProfileExist(socioprofile))
{
objSocialProfilesRepository.addNewProfileForUser(socioprofile);
}
if (!objTeamMemberProfileRepository.checkTeamMemberProfile(objTeamMemberProfile.TeamId, objLinkedincmpnypage.LinkedinPageId))
{
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
}
if (!objLinkedCmpnyPgeRepo.checkLinkedinPageExists(CompanyPageId, Guid.Parse(UserId)))
{
objLinkedCmpnyPgeRepo.addLinkenCompanyPage(objLinkedincmpnypage);
}
else
{
objLinkedincmpnypage.LinkedinPageId = CompanyPageId;
objLinkedCmpnyPgeRepo.updateLinkedinPage(objLinkedincmpnypage);
}
}
catch
{
}
}
public string AddYoutubeAccountwithLogin(string client_id, string client_secret, string redirect_uri, string UserId, string GroupId, string access_token)
{
#region Local variables Inisitalisation
string ret = string.Empty;
string objRefresh = string.Empty;
string refreshToken = string.Empty;
oAuthTokenYoutube ObjoAuthTokenYoutube = new oAuthTokenYoutube();
oAuthToken objToken = new oAuthToken();
Domain.Myfashion.Domain.YoutubeAccount objYoutubeAccount = new Domain.Myfashion.Domain.YoutubeAccount();
Domain.Myfashion.Domain.YoutubeChannel objYoutubeChannel;
YoutubeChannelRepository objYoutubeChannelRepository = new YoutubeChannelRepository();
YoutubeAccountRepository objYoutubeAccountRepository = new YoutubeAccountRepository();
#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.Myfashion.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.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
Domain.Myfashion.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Myfashion.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.Myfashion.Domain.SocialProfile objSocialProfile = new Domain.Myfashion.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 Domain.Myfashion.Domain.Team getAllDetailsByTeamID(Guid Id, Guid groupId)
{
Domain.Myfashion.Domain.Team objTeam = new Domain.Myfashion.Domain.Team();
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
List<Domain.Myfashion.Domain.Team> alstAccounts = session.CreateQuery("from Team where Id=:id and GroupId=:groupId")
.SetParameter("id", Id)
.SetParameter("groupId", groupId)
.List<Domain.Myfashion.Domain.Team>()
.ToList<Domain.Myfashion.Domain.Team>();
objTeam = alstAccounts[0];
return objTeam;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return null;
}
}//End Transaction
}//End Session
}
public string AddTumblrAccount(string client_id, string client_secret, string redirect_uri, string UserId, string GroupId, string code)
{
string ret = string.Empty;
string AccessTokenResponse = string.Empty;
try
{
oAuthTumbler requestHelper = new oAuthTumbler();
oAuthTumbler.TumblrConsumerKey = client_id;
oAuthTumbler.TumblrConsumerSecret = client_secret;
requestHelper.TumblrCallBackUrl = redirect_uri;
AccessTokenResponse = requestHelper.GetAccessToken(oAuthTumbler.TumblrToken, code);
logger.Error(AccessTokenResponse);
string[] tokens = AccessTokenResponse.Split('&'); //extract access token & secret from response
logger.Error(tokens);
string accessToken = tokens[0].Split('=')[1];
logger.Error(accessToken);
string accessTokenSecret = tokens[1].Split('=')[1];
logger.Error(accessTokenSecret);
KeyValuePair <string, string> LoginDetails = new KeyValuePair <string, string>(accessToken, accessTokenSecret);
JObject profile = new JObject();
try
{
profile = JObject.Parse(oAuthTumbler.OAuthData(Globals.UsersInfoUrl, "GET", LoginDetails.Key, LoginDetails.Value, null));
}
catch (Exception ex)
{
}
#region Add Tumblr Account
objTumblrAccount = new Domain.Myfashion.Domain.TumblrAccount();
objTumblrAccount.Id = Guid.NewGuid();
objTumblrAccount.tblrUserName = profile["response"]["user"]["name"].ToString();
objTumblrAccount.UserId = Guid.Parse(UserId);
objTumblrAccount.tblrAccessToken = accessToken;
objTumblrAccount.tblrAccessTokenSecret = accessTokenSecret;
objTumblrAccount.tblrProfilePicUrl = "http://api.tumblr.com/v2/blog/" + objTumblrAccount.tblrUserName + ".tumblr.com/avatar";//profile["response"]["user"]["name"].ToString();
objTumblrAccount.IsActive = 1;
if (!objTumblrAccountRepository.checkTubmlrUserExists(objTumblrAccount))
{
TumblrAccountRepository.Add(objTumblrAccount);
#region Add Socialprofiles
objSocialProfile = new Domain.Myfashion.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileId = profile["response"]["user"]["name"].ToString();
objSocialProfile.ProfileType = "tumblr";
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
#endregion
#region Add TeamMemeberProfile
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
Domain.Myfashion.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "tumblr";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = objTumblrAccount.tblrUserName;
//Modified [13-02-15]
objTeamMemberProfile.ProfilePicUrl = objTumblrAccount.tblrProfilePicUrl;
objTeamMemberProfile.ProfileName = objTumblrAccount.tblrUserName;
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
#endregion
}
#endregion
//if (!objTeamMemberProfileRepository.checkTeamMemberProfile(objTeam.Id, objTumblrAccount.tblrUserName))
//{
// objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
//}
#region Add Tumblr Feeds
AddTunblrFeeds(UserId, LoginDetails, profile["response"]["user"]["name"].ToString());
#endregion
}
catch (Exception ex)
{
logger.Error("AddTumblrAccount => " + ex.StackTrace);
}
return(ret);
}
public string AddLinkedinAccount(string oauth_token, string oauth_verifier, string reuqestTokenSecret, string consumerKey, string consumerSecret, string UserId, string GroupId)
{
try
{
logger.Error("AddLinkedinAccount()");
System.Net.ServicePointManager.SecurityProtocol = System.Net.SecurityProtocolType.Tls;
string ret = string.Empty;
LinkedInProfile objProfile = new LinkedInProfile();
LinkedInProfile.UserProfile objUserProfile = new LinkedInProfile.UserProfile();
objSocialProfile = new Domain.Myfashion.Domain.SocialProfile();
oAuthLinkedIn _oauth = new oAuthLinkedIn();
objLinkedInAccount = new LinkedInAccount();
#region Get linkedin Profile data from Api
try
{
_oauth.ConsumerKey = consumerKey;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
try
{
_oauth.ConsumerSecret = consumerSecret;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
try
{
_oauth.Token = oauth_token;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
try
{
_oauth.TokenSecret = reuqestTokenSecret;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
try
{
_oauth.Verifier = oauth_verifier;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
try
{
_oauth.AccessTokenGet(oauth_token);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
try
{
objUserProfile = objProfile.GetUserProfile(_oauth);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
logger.Error(ex.Message);
}
#endregion
dynamic data = objUserProfile;
try
{
#region LinkedInAccount
objLinkedInAccount.UserId = Guid.Parse(UserId);
objLinkedInAccount.LinkedinUserId = data.id.ToString();
try
{
objLinkedInAccount.EmailId = data.email.ToString();
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
objLinkedInAccount.LinkedinUserName = data.first_name.ToString() + data.last_name.ToString();
objLinkedInAccount.OAuthToken = _oauth.Token;
objLinkedInAccount.OAuthSecret = _oauth.TokenSecret;
objLinkedInAccount.OAuthVerifier = _oauth.Verifier;
try
{
objLinkedInAccount.ProfileImageUrl = data.picture_url.ToString();
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
try
{
objLinkedInAccount.ProfileUrl = data.profile_url.ToString();
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
#endregion
#region SocialProfiles
try
{
objLinkedInAccount.Connections = data.connections;
objLinkedInAccount.IsActive = true;
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileType = "linkedin";
objSocialProfile.ProfileId = data.id.ToString();
objSocialProfile.ProfileStatus = 1;
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.Id = Guid.NewGuid();
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
#endregion SocialProfiles
#region Add TeamMemberProfile
try
{
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.ProfileType = "linkedin";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = objLinkedInAccount.LinkedinUserId;
objTeamMemberProfile.ProfileName = objLinkedInAccount.LinkedinUserName;
objTeamMemberProfile.ProfilePicUrl = objLinkedInAccount.ProfileImageUrl;
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
#endregion
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
try
{
if (!objLinkedInAccountRepository.checkLinkedinUserExists(objLinkedInAccount.LinkedinUserId, Guid.Parse(UserId)))
{
objLinkedInAccountRepository.addLinkedinUser(objLinkedInAccount);
ret = "LinkedIn Account Added Successfully";
}
else
{
ret = "LinkedIn Account Already Exist";
}
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
if (!objTeamMemberProfileRepository.checkTeamMemberProfile(objTeamMemberProfile.TeamId, objLinkedInAccount.LinkedinUserId))
{
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
}
#region Add LinkedIn Feeds
LinkedInNetwork objln = new LinkedInNetwork();
List <LinkedInNetwork.Network_Updates> userUPdate = objln.GetNetworkUpdates(_oauth, 20);
foreach (var item in userUPdate)
{
try
{
objLinkedInFeed = new Domain.Myfashion.Domain.LinkedInFeed();
objLinkedInFeed.Feeds = item.Message;
objLinkedInFeed.FromId = item.PersonId;
objLinkedInFeed.FromName = item.PersonFirstName + " " + item.PersonLastName;
objLinkedInFeed.FeedsDate = Convert.ToDateTime(item.DateTime);
objLinkedInFeed.EntryDate = DateTime.Now;
objLinkedInFeed.ProfileId = objLinkedInAccount.LinkedinUserId;
objLinkedInFeed.Type = item.UpdateType;
objLinkedInFeed.UserId = Guid.Parse(UserId);
objLinkedInFeed.FromPicUrl = item.PictureUrl;
objLinkedInFeed.ImageUrl = item.ImageUrl;
objLinkedInFeed.FromUrl = item.url;
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
if (!objLinkedInFeedRepository.checkLinkedInFeedExists(objLinkedInFeed.FeedId, Guid.Parse(UserId)))
{
objLinkedInFeedRepository.addLinkedInFeed(objLinkedInFeed);
}
}
#endregion
#region Add LinkedIn UserUpdates
GlobusLinkedinLib.App.Core.LinkedInUser l = new GlobusLinkedinLib.App.Core.LinkedInUser();
List <Domain.Myfashion.Domain.LinkedIn_Update_Messages> lst_Messages = l.GetUserUpdateNew(_oauth, objLinkedInAccount.LinkedinUserId, 10);
foreach (var item_Messages in lst_Messages)
{
try
{
objLinkedInMessage = new Domain.Myfashion.Domain.LinkedInMessage();
objLinkedInMessage.Id = Guid.NewGuid();
objLinkedInMessage.Message = item_Messages.Message;
objLinkedInMessage.ProfileId = item_Messages.ProfileId;
objLinkedInMessage.ProfileName = item_Messages.ProfileName;
objLinkedInMessage.CreatedDate = Convert.ToDateTime(item_Messages.CreatedDate);
objLinkedInMessage.EntryDate = DateTime.Now;
objLinkedInMessage.Type = item_Messages.Type;
objLinkedInMessage.UserId = Guid.Parse(UserId);
objLinkedInMessage.ImageUrl = item_Messages.ImageUrl;
objLinkedInMessage.FeedId = item_Messages.FeedId;
objLinkedInMessage.ProfileUrl = item_Messages.ProfileUrl;
objLinkedInMessage.Comments = item_Messages.Comments;
objLinkedInMessage.Likes = item_Messages.Likes;
objLinkedInMessage.ProfileImageUrl = item_Messages.ProfileImageUrl;
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
if (!objLinkedInMessageRepository.checkLinkedInMessageExists(objLinkedInAccount.LinkedinUserId, objLinkedInMessage.FeedId, Guid.Parse(UserId)))
{
objLinkedInMessageRepository.addLinkedInMessage(objLinkedInMessage);
}
}
#endregion
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
}
return("");
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
return("");
}
}
