/// <updateTeamMember>
/// Update TeamMember details
/// </summary>
/// <param name="team">Set Values in a TeamMemberProfile Class Property and Pass the Object of TeamMemberProfile Class.(Domein.TeamMemberProfile)</param>
public void updateTeamMember(Domain.Myfashion.Domain.TeamMemberProfile 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 details of team member profile.
session.CreateQuery("Update TeamMemberProfile set Status =:status,StatusUpdateDate =:statusdate where TeamId = :teamid and ProfileId = :profileId")
.SetParameter("status", team.Status)
.SetParameter("statusdate", team.StatusUpdateDate)
.SetParameter("teamid", team.TeamId)
.SetParameter("profileId", team.ProfileId)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
} //End Transaction
} //End Session
}
/// <deleteTeamMember>
/// Delete profile of TeamMember
/// </summary>
/// <param name="team">Set the team id and prfile id of team in a TeamMemberProfile Class Property and Pass the Object of TeamMemberProfile Class.(Domein.TeamMemberProfile)</param>
/// <returns>Return 1 for successfully delete and 0 for failed.(int)</returns>
public int deleteTeamMember(Domain.Myfashion.Domain.TeamMemberProfile 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 deleting team profile by id and team id.
NHibernate.IQuery query = session.CreateQuery("delete from TeamMemberProfile where TeamId = :teamid and ProfileId = :profileid")
.SetParameter("teamin", team.TeamId)
.SetParameter("profileid", team.ProfileId);
int isUpdated = query.ExecuteUpdate();
transaction.Commit();
return(isUpdated);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(0);
}
} //End Transaction
} //End Session
}
/// <getTeamMemberProfile>
/// Get TeamMember Profile
/// </summary>
/// <param name="Teamid">Team id.(Guid)</param>
/// <param name="ProfileId">Profile id.(string)</param>
/// <returns>>Return the object of TeamMemberProfile class with value.(Domain.TeamMemberProfile)</returns>
public Domain.Myfashion.Domain.TeamMemberProfile getTeamMemberProfile(Guid Teamid, string ProfileId)
{
//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 profile.
NHibernate.IQuery query = session.CreateQuery("from TeamMemberProfile where TeamId = :teamid and ProfileId = :profileid");
query.SetParameter("teamid", Teamid);
query.SetParameter("profileid", ProfileId);
Domain.Myfashion.Domain.TeamMemberProfile alstFBAccounts = query.UniqueResult <Domain.Myfashion.Domain.TeamMemberProfile>();
return(alstFBAccounts);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
} //End Transaction
} //End Session
}
/// <addNewTeamMember>
/// Add New TeamMember
/// </summary>
/// <param name="team">Set Values in a TeamMemberProfile Class Property and Pass the Object of TeamMemberProfile Class.(Domein.TeamMemberProfile)</param>
public void addNewTeamMember(Domain.Myfashion.Domain.TeamMemberProfile 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 member profile.
session.Save(team);
transaction.Commit();
} //End Transaction
} //End Session
}
public string AddProfileToGroup(string profileid, string network, string groupid, string userid)
{
objGroupProfile = new Domain.Myfashion.Domain.GroupProfile();
objGroupProfile.Id = Guid.NewGuid();
objGroupProfile.GroupId = Guid.Parse(groupid);
objGroupProfile.ProfileId = profileid;
objGroupProfile.GroupOwnerId = Guid.Parse(userid);
objGroupProfile.ProfileType = network;
objGroupProfile.EntryDate = DateTime.Now;
objGroupProfileRepository.AddGroupProfile(objGroupProfile);
objTeam = new Domain.Myfashion.Domain.Team();
objTeam = objTeamRepository.GetAllTeam(Guid.Parse(groupid), Guid.Parse(userid));
objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.ProfileId = profileid;
objTeamMemberProfile.ProfileType = network;
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
return("");
}
public string AddWordpressAccount(string code, string UserId, string GroupId)
{
WordpressAccountRepository objWPAccountRepo = new WordpressAccountRepository();
Domain.Myfashion.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
Domain.Myfashion.Domain.WordpressAccount objWordpressAccount = new Domain.Myfashion.Domain.WordpressAccount();
string client_id = ConfigurationManager.AppSettings["WordpessClientID"];
string redirect_uri = ConfigurationManager.AppSettings["WordpessCallBackURL"];
string client_secret = ConfigurationManager.AppSettings["WordpessClientSecret"];
oAuthWordpress _oAuth = new oAuthWordpress();
_oAuth.client_id = client_id;
_oAuth.client_secret = client_secret;
_oAuth.redirect_uri = redirect_uri;
_oAuth.code = code;
string postdata=_oAuth.PostDataToGetAccessToken();
try
{
string _token = _oAuth.APIWebRequest(Globals._TokenUrl, postdata);
string access_token = JObject.Parse(_token)["access_token"].ToString();
_oAuth.access_token = access_token;
//string postdata1 = _oAuth.PostDataToGetAccessToken();
//string _me = _oAuth.APIWebRequest(Globals._UserInfo, postdata1);
string userinfo = _oAuth.APIWebRequestToGetUserInfo(Globals._UserInfo);
JObject WP_User = JObject.Parse(userinfo);
#region AddWPAccount
objWordpressAccount.Id = Guid.NewGuid();
objWordpressAccount.WpUserId = WP_User["ID"].ToString();
objWordpressAccount.WpUserName = WP_User["username"].ToString();
objWordpressAccount.DisplayName = WP_User["display_name"].ToString();
objWordpressAccount.EmailId = WP_User["email"].ToString();
objWordpressAccount.PrimaryBlogId = WP_User["primary_blog"].ToString();
objWordpressAccount.TokenSiteId = WP_User["token_site_id"].ToString();
objWordpressAccount.UserAvtar = WP_User["avatar_URL"].ToString();
objWordpressAccount.ProfileUrl = WP_User["profile_URL"].ToString();
objWordpressAccount.SiteCount = Int32.Parse(WP_User["site_count"].ToString());
objWordpressAccount.UserId = Guid.Parse(UserId);
objWordpressAccount.AccessToken = access_token;
if (!objWPAccountRepo.IsProfileAllreadyExist(objWordpressAccount.UserId, objWordpressAccount.WpUserId))
{
objWPAccountRepo.AddWordpressAccount(objWordpressAccount);
}
#endregion
#region AddTeamMemberProfiles
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.ProfileId = WP_User["ID"].ToString();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.ProfileType = "wordpress";
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
if (!objTeamMemberProfileRepo.checkTeamMemberProfile(objTeam.Id, objTeamMemberProfile.ProfileId))
{
objTeamMemberProfileRepo.addNewTeamMember(objTeamMemberProfile);
}
#endregion
#region AddSocialProfile
Domain.Myfashion.Domain.SocialProfile objSocialProfile = new Domain.Myfashion.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileType = "wordpress";
objSocialProfile.ProfileId = WP_User["ID"].ToString();
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
GetUserSites(UserId, objWordpressAccount.WpUserId);
//GetUsersofblog(UserId,objWordpressAccount.WpUserId);
#endregion
}
catch (Exception ex)
{
}
return "";
}
public string AddGPlusAccount(string client_id, string client_secret, string redirect_uri, string UserId, string GroupId, string code)
{
string ret = string.Empty;
string objRefresh = string.Empty;
string refreshToken = string.Empty;
string access_token = string.Empty;
try
{
oAuthTokenGPlus ObjoAuthTokenGPlus = new oAuthTokenGPlus();
oAuthToken objToken = new oAuthToken();
objToken.ConsumerKey = client_id;
objToken.ConsumerSecret = client_secret;
try
{
objRefresh = ObjoAuthTokenGPlus.GetRefreshToken(code, client_id, client_secret, redirect_uri);
logger.Error("vikash: ObjoAuthTokenGPlus()");
}
catch (Exception ex) { }
JObject objaccesstoken = JObject.Parse(objRefresh);
try
{
refreshToken = objaccesstoken["refresh_token"].ToString();
}
catch (Exception ex)
{
access_token = objaccesstoken["access_token"].ToString();
ObjoAuthTokenGPlus.RevokeToken(access_token);
Console.WriteLine(ex.StackTrace);
ret = "Refresh Token Not Found";
return(ret);
}
try
{
access_token = objaccesstoken["access_token"].ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
JArray userinfo = new JArray();
try
{
userinfo = objToken.GetUserInfo("self", access_token.ToString());
}
catch (Exception ex)
{
}
Domain.Myfashion.Domain.GooglePlusAccount _GooglePlusAccount = new Domain.Myfashion.Domain.GooglePlusAccount();
foreach (var itemuserinfo in userinfo)
{
try
{
_GooglePlusAccount.Id = Guid.NewGuid();
_GooglePlusAccount.GpUserId = itemuserinfo["id"].ToString();
_GooglePlusAccount.GpUserName = itemuserinfo["name"].ToString();
_GooglePlusAccount.GpProfileImage = itemuserinfo["picture"].ToString();
_GooglePlusAccount.IsActive = 1;
_GooglePlusAccount.ProfileType = "gplus";
_GooglePlusAccount.AccessToken = access_token;
_GooglePlusAccount.RefreshToken = refreshToken;
_GooglePlusAccount.EmailId = itemuserinfo["email"].ToString();
_GooglePlusAccount.UserId = Guid.Parse(UserId);
_GooglePlusAccount.EntryDate = DateTime.Now;
}
catch (Exception ex)
{
logger.Error("AddGPlusAccount => GooglePlusAccount =>" + ex.Message);
}
}
#region Get_InYourCircles
try
{
string _InyourCircles = ObjoAuthTokenGPlus.APIWebRequestToGetUserInfo(Globals.strGetPeopleList.Replace("[userId]", _GooglePlusAccount.GpUserId).Replace("[collection]", "visible") + "?key=" + ConfigurationManager.AppSettings["Api_Key"].ToString(), access_token);
JObject J_InyourCircles = JObject.Parse(_InyourCircles);
_GooglePlusAccount.InYourCircles = Convert.ToInt32(J_InyourCircles["totalItems"].ToString());
}
catch (Exception ex)
{
_GooglePlusAccount.InYourCircles = 0;
}
#endregion
#region Get_HaveYouInCircles
try
{
string _HaveYouInCircles = ObjoAuthTokenGPlus.APIWebRequestToGetUserInfo(Globals.strGetPeopleProfile + _GooglePlusAccount.GpUserId + "?key=" + ConfigurationManager.AppSettings["Api_Key"].ToString(), access_token);
JObject J_HaveYouInCircles = JObject.Parse(_HaveYouInCircles);
_GooglePlusAccount.HaveYouInCircles = Convert.ToInt32(J_HaveYouInCircles["circledByCount"].ToString());
}
catch (Exception ex)
{
_GooglePlusAccount.HaveYouInCircles = 0;
}
#endregion
#region Add GPlusAccount
if (!objGooglePlusAccountRepository.checkGooglePlusUserExists(_GooglePlusAccount.GpUserId, _GooglePlusAccount.UserId))
{
objGooglePlusAccountRepository.addGooglePlusUser(_GooglePlusAccount);
#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 = "gplus";
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfile.ProfileId = _GooglePlusAccount.GpUserId;
objTeamMemberProfile.ProfilePicUrl = _GooglePlusAccount.GpProfileImage;
objTeamMemberProfile.ProfileName = _GooglePlusAccount.GpUserName;
objTeamMemberProfileRepository.addNewTeamMember(objTeamMemberProfile);
#endregion
#region SocialProfile
Domain.Myfashion.Domain.SocialProfile objSocialProfile = new Domain.Myfashion.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.ProfileType = "gplus";
objSocialProfile.ProfileId = _GooglePlusAccount.GpUserId;
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
#endregion
ret = "Account Added Successfully";
}
else
{
ret = "Account already Exist !";
}
#endregion
GetUserActivities(UserId, _GooglePlusAccount.GpUserId, access_token);
return(new JavaScriptSerializer().Serialize(_GooglePlusAccount));
}
catch (Exception ex)
{
logger.Error(ex.Message);
return("");
}
}
public string AddWordpressAccount(string code, string UserId, string GroupId)
{
WordpressAccountRepository objWPAccountRepo = new WordpressAccountRepository();
Domain.Myfashion.Domain.TeamMemberProfile objTeamMemberProfile = new Domain.Myfashion.Domain.TeamMemberProfile();
Domain.Myfashion.Domain.WordpressAccount objWordpressAccount = new Domain.Myfashion.Domain.WordpressAccount();
string client_id = ConfigurationManager.AppSettings["WordpessClientID"];
string redirect_uri = ConfigurationManager.AppSettings["WordpessCallBackURL"];
string client_secret = ConfigurationManager.AppSettings["WordpessClientSecret"];
oAuthWordpress _oAuth = new oAuthWordpress();
_oAuth.client_id = client_id;
_oAuth.client_secret = client_secret;
_oAuth.redirect_uri = redirect_uri;
_oAuth.code = code;
string postdata = _oAuth.PostDataToGetAccessToken();
try
{
string _token = _oAuth.APIWebRequest(Globals._TokenUrl, postdata);
string access_token = JObject.Parse(_token)["access_token"].ToString();
_oAuth.access_token = access_token;
//string postdata1 = _oAuth.PostDataToGetAccessToken();
//string _me = _oAuth.APIWebRequest(Globals._UserInfo, postdata1);
string userinfo = _oAuth.APIWebRequestToGetUserInfo(Globals._UserInfo);
JObject WP_User = JObject.Parse(userinfo);
#region AddWPAccount
objWordpressAccount.Id = Guid.NewGuid();
objWordpressAccount.WpUserId = WP_User["ID"].ToString();
objWordpressAccount.WpUserName = WP_User["username"].ToString();
objWordpressAccount.DisplayName = WP_User["display_name"].ToString();
objWordpressAccount.EmailId = WP_User["email"].ToString();
objWordpressAccount.PrimaryBlogId = WP_User["primary_blog"].ToString();
objWordpressAccount.TokenSiteId = WP_User["token_site_id"].ToString();
objWordpressAccount.UserAvtar = WP_User["avatar_URL"].ToString();
objWordpressAccount.ProfileUrl = WP_User["profile_URL"].ToString();
objWordpressAccount.SiteCount = Int32.Parse(WP_User["site_count"].ToString());
objWordpressAccount.UserId = Guid.Parse(UserId);
objWordpressAccount.AccessToken = access_token;
if (!objWPAccountRepo.IsProfileAllreadyExist(objWordpressAccount.UserId, objWordpressAccount.WpUserId))
{
objWPAccountRepo.AddWordpressAccount(objWordpressAccount);
}
#endregion
#region AddTeamMemberProfiles
Domain.Myfashion.Domain.Team objTeam = objTeamRepository.GetTeamByGroupId(Guid.Parse(GroupId));
objTeamMemberProfile.Id = Guid.NewGuid();
objTeamMemberProfile.ProfileId = WP_User["ID"].ToString();
objTeamMemberProfile.TeamId = objTeam.Id;
objTeamMemberProfile.ProfileType = "wordpress";
objTeamMemberProfile.Status = 1;
objTeamMemberProfile.StatusUpdateDate = DateTime.Now;
if (!objTeamMemberProfileRepo.checkTeamMemberProfile(objTeam.Id, objTeamMemberProfile.ProfileId))
{
objTeamMemberProfileRepo.addNewTeamMember(objTeamMemberProfile);
}
#endregion
#region AddSocialProfile
Domain.Myfashion.Domain.SocialProfile objSocialProfile = new Domain.Myfashion.Domain.SocialProfile();
objSocialProfile.Id = Guid.NewGuid();
objSocialProfile.UserId = Guid.Parse(UserId);
objSocialProfile.ProfileType = "wordpress";
objSocialProfile.ProfileId = WP_User["ID"].ToString();
objSocialProfile.ProfileDate = DateTime.Now;
objSocialProfile.ProfileStatus = 1;
if (!objSocialProfilesRepository.checkUserProfileExist(objSocialProfile))
{
objSocialProfilesRepository.addNewProfileForUser(objSocialProfile);
}
GetUserSites(UserId, objWordpressAccount.WpUserId);
//GetUsersofblog(UserId,objWordpressAccount.WpUserId);
#endregion
}
catch (Exception ex)
{
}
return("");
}
