/// <updateLinkedinUser>
/// Update Linkedin User account details.
/// </summary>
/// <param name="liaccount">Set Values in a LinkedInAccount Class Property and Pass the Object of LinkedInAccount Class (SocioBoard.Domain.LinkedInAccount).</param>
public void updateLinkedinUser(LinkedInAccount liaccount)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
session.CreateQuery("Update LinkedInAccount set LinkedinUserName =:LinkedinUserName,OAuthToken =:OAuthToken,OAuthSecret=:OAuthSecret,OAuthVerifier=:OAuthVerifier,EmailId=:EmailId,Connections=:Connections,ProfileUrl =:profileurl,ProfileImageUrl=:profilepicurl where LinkedinUserId = :LinkedinUserId and UserId = :UserId")
.SetParameter("LinkedinUserName", liaccount.LinkedinUserName)
.SetParameter("OAuthToken", liaccount.OAuthToken)
.SetParameter("OAuthSecret", liaccount.OAuthSecret)
.SetParameter("OAuthVerifier", liaccount.OAuthVerifier)
.SetParameter("EmailId", liaccount.EmailId)
.SetParameter("LinkedinUserId", liaccount.LinkedinUserId)
.SetParameter("UserId", liaccount.UserId)
.SetParameter("profileurl", liaccount.ProfileUrl)
.SetParameter("profilepicurl", liaccount.ProfileImageUrl)
.SetParameter("Connections", liaccount.Connections)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
}
}
}
/// <updateLinkedinUser>
/// Update Linkedin User account details.
/// </summary>
/// <param name="liaccount">Set Values in a LinkedInAccount Class Property and Pass the Object of LinkedInAccount Class (SocioBoard.Domain.LinkedInAccount).</param>
public void updateLinkedinUser(LinkedInAccount liaccount)
{
//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 user linkedin account deatils
session.CreateQuery("Update LinkedInAccount set LinkedinUserName =:LinkedinUserName,OAuthToken =:OAuthToken,OAuthSecret=:OAuthSecret,OAuthVerifier=:OAuthVerifier,EmailId=:EmailId,Connections=:Connections,ProfileUrl =:profileurl where LinkedinUserId = :LinkedinUserId and UserId = :UserId")
.SetParameter("LinkedinUserName", liaccount.LinkedinUserName)
.SetParameter("OAuthToken", liaccount.OAuthToken)
.SetParameter("OAuthSecret", liaccount.OAuthSecret)
.SetParameter("OAuthVerifier", liaccount.OAuthVerifier)
.SetParameter("EmailId", liaccount.EmailId)
.SetParameter("LinkedinUserId", liaccount.LinkedinUserId)
.SetParameter("UserId", liaccount.UserId)
.SetParameter("profileurl", liaccount.ProfileUrl)
.SetParameter("Connections", liaccount.Connections)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
// return 0;
}
}//End Transaction
}//End Session
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
if (Session["AdminProfile"] == null)
{
Response.Redirect("Default.aspx");
}
string id = Request.QueryString["id"].ToString();
string type = Request.QueryString["type"].ToString();
string userid = Request.QueryString["userid"].ToString();
if (type == "twt")
{
TwtAcc = objTwtRepo.getUserInformation(Guid.Parse(userid), id);
Session["updateData"] = TwtAcc;
txtName.Text = TwtAcc.TwitterScreenName;
//ddltatus.SelectedValue = TwtAcc.IsActive.ToString();
}
if (type == "fb")
{
FBAcc = objFbRepo.getFacebookAccountDetailsById(id, Guid.Parse(userid));
Session["updateData"] = FBAcc;
txtName.Text = FBAcc.FbUserName;
// ddltatus.SelectedValue = FBAcc.IsActive.ToString();
}
if (type == "li")
{
liAcc = objLiRepo.getLinkedinAccountDetailsById(id);
Session["updateData"] = liAcc;
txtName.Text = liAcc.LinkedinUserName;
// ddltatus.SelectedValue = liAcc.IsActive.ToString();
}
if (type == "ins")
{
InsAcc = objInsRepo.getInstagramAccountDetailsById(id, Guid.Parse(userid));
Session["updateData"] = InsAcc;
txtName.Text = InsAcc.InsUserName;
// ddltatus.SelectedValue = InsAcc.IsActive.ToString();
}
if (type == "gp")
{
GpAcc = objgpRepo.getGooglePlusAccountDetailsById(id, Guid.Parse(userid));
Session["updateData"] = GpAcc;
txtName.Text = GpAcc.GpUserName;
//ddltatus.SelectedValue = GpAcc.IsActive.ToString();
}
}
}
catch (Exception Err)
{
logger.Error(Err.Message);
}
}
public void addLinkedinUser(LinkedInAccount fbaccount)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(fbaccount);
transaction.Commit();
}
}
}
/// <addLinkedinUser>
/// Add Linked in User
/// </summary>
/// <param name="linkedInAccount">Set Values in a LinkedInAccount Class Property and Pass the Object of LinkedInAccount Class (SocioBoard.Domain.LinkedInAccount).</param>
public void addLinkedinUser(LinkedInAccount linkedInAccount)
{
//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 data
session.Save(linkedInAccount);
transaction.Commit();
}//End Transaction
}//End Session
}
protected void btnRegister_Click(object sender, ImageClickEventArgs e)
{
User user = new User();
UserRepository userrepo = new UserRepository();
UserActivation objUserActivation = new UserActivation();
Coupon objCoupon = new Coupon();
CouponRepository objCouponRepository = new CouponRepository();
SocioBoard.Helper.SessionFactory.configfilepath = Server.MapPath("~/hibernate.cfg.xml");
try
{
if (DropDownList1.SelectedValue == "Basic" || DropDownList1.SelectedValue == "Standard" || DropDownList1.SelectedValue == "Deluxe" || DropDownList1.SelectedValue == "Premium")
{
if (TextBox1.Text.Trim() != "")
{
string resp = SBUtils.GetCouponStatus(TextBox1.Text).ToString();
if (resp != "valid")
{
// ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert(Not valid);", true);
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('" + resp + "');", true);
return;
}
}
if (txtPassword.Text == txtConfirmPassword.Text)
{
user.PaymentStatus = "unpaid";
//user.AccountType = Request.QueryString["type"];
user.AccountType = DropDownList1.SelectedValue.ToString();
if (string.IsNullOrEmpty(user.AccountType))
{
user.AccountType = AccountType.Free.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;
user.ActivationStatus = "0";
if (TextBox1.Text.Trim() != "")
{
user.CouponCode = TextBox1.Text.Trim().ToString();
}
if (!userrepo.IsUserExist(user.EmailId))
{
UserRepository.Add(user);
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();
Package objPackage = objPackageRepository.getPackageDetails(user.AccountType);
objUserPackageRelation.Id = new Guid();
objUserPackageRelation.PackageId = objPackage.Id;
objUserPackageRelation.UserId = user.Id;
objUserPackageRelation.ModifiedDate = DateTime.Now;
objUserPackageRelation.PackageStatus = true;
objUserPackageRelationRepository.AddUserPackageRelation(objUserPackageRelation);
//end package
SocioBoard.Helper.MailSender.SendEMail(txtFirstName.Text, txtPassword.Text, txtEmail.Text, user.AccountType.ToString(),user.Id.ToString());
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>";
Response.Redirect("~/Home.aspx");
}
else
{
lblerror.Text = "Email Already Exists " + "<a href=\"Default.aspx\">login</a>";
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Account Type!');", true);
}
}
catch (Exception ex)
{
logger.Error(ex.StackTrace);
lblerror.Text = "Please Insert Correct Information";
Console.WriteLine(ex.StackTrace);
//Response.Redirect("Home.aspx");
}
}
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);
SocialSuitePro.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 LinkedInAccount getUserInformation(string liuserid)
{
//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 account.
List<LinkedInAccount> objlst = session.CreateQuery("from LinkedInAccount where LinkedinUserId = :LinkedinUserId ")
.SetParameter("LinkedinUserId", liuserid)
.List<LinkedInAccount>().ToList<LinkedInAccount>();
LinkedInAccount result = new LinkedInAccount();
if (objlst.Count > 0)
{
result = objlst[0];
}
return result;
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return null;
}
}//End Transaction
}//End Session
}
/// <getLinkedinAccountDetailsById>
/// Get linkedin account details by id
/// </summary>
/// <param name="liuserid"></param>
/// <returns>Return object of LinkedInAccount Class with value of each member.(Domain.LinkedInAccount)</returns>
public LinkedInAccount getLinkedinAccountDetailsById(string liuserid)
{
//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 account details.
NHibernate.IQuery query = session.CreateQuery("from LinkedInAccount where LinkedinUserId = :userid");
query.SetParameter("userid", liuserid);
LinkedInAccount result = new LinkedInAccount();
foreach (LinkedInAccount item in query.Enumerable<LinkedInAccount>())
{
result = item;
break;
}
return result;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return null;
}
}//End Transaction
}//End Session
}
public LinkedInAccount getLinkedinAccountDetailsById(string liuserid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from LinkedInAccount where LinkedinUserId = :userid");
query.SetParameter("userid", liuserid);
LinkedInAccount result = new LinkedInAccount();
foreach (LinkedInAccount item in query.Enumerable<LinkedInAccount>())
{
result = item;
break;
}
return result;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return null;
}
}
}
}
public void GetLinkedInUserProfile(dynamic data, oAuthLinkedIn _oauth, Guid user, string LinkedinUserId)
{
SocialProfile socioprofile = new SocialProfile();
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
LinkedInAccount objLinkedInAccount = new LinkedInAccount();
LinkedInAccountRepository objLiRepo = new LinkedInAccountRepository();
try
{
objLinkedInAccount.UserId = user;
objLinkedInAccount.LinkedinUserId = data.id.ToString();
try
{
objLinkedInAccount.EmailId = data.email.ToString();
}
catch { }
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 { }
try
{
objLinkedInAccount.ProfileUrl = data.profile_url.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objLinkedInAccount.Connections = data.connections;
objLinkedInAccount.IsActive = true;
socioprofile.UserId = user;
socioprofile.ProfileType = "linkedin";
socioprofile.ProfileId = LinkedinUserId;
socioprofile.ProfileStatus = 1;
socioprofile.ProfileDate = DateTime.Now;
socioprofile.Id = Guid.NewGuid();
}
catch
{
}
try
{
if (!socioprofilerepo.checkUserProfileExist(socioprofile))
{
socioprofilerepo.addNewProfileForUser(socioprofile);
GroupRepository objGroupRepository = new GroupRepository();
SocioBoard.Domain.Team team = (SocioBoard.Domain.Team)HttpContext.Current.Session["GroupName"];
Groups lstDetails = objGroupRepository.getGroupName(team.GroupId);
if (lstDetails.GroupName == "Socioboard")
{
TeamMemberProfileRepository objTeamMemberProfileRepository = new TeamMemberProfileRepository();
TeamMemberProfile teammemberprofile = new TeamMemberProfile();
teammemberprofile.Id = Guid.NewGuid();
teammemberprofile.TeamId = team.Id;
teammemberprofile.ProfileId = socioprofile.ProfileId;
teammemberprofile.ProfileType = "linkedin";
teammemberprofile.StatusUpdateDate = DateTime.Now;
objTeamMemberProfileRepository.addNewTeamMember(teammemberprofile);
}
}
else
{
socioprofile.ProfileId = data.id.ToString();
socioprofilerepo.updateSocialProfile(socioprofile);
}
if (!objLiRepo.checkLinkedinUserExists(LinkedinUserId, user))
{
objLiRepo.addLinkedinUser(objLinkedInAccount);
}
else
{
objLinkedInAccount.LinkedinUserId = LinkedinUserId;
objLiRepo.updateLinkedinUser(objLinkedInAccount);
}
// GetLinkedInFeeds(_oauth, data.id, user.Id);
}
catch
{
}
}
public void GetLinkedInUserProfile(dynamic data, oAuthLinkedIn _oauth, User user)
{
SocialProfile socioprofile = new SocialProfile();
SocialProfilesRepository socioprofilerepo = new SocialProfilesRepository();
LinkedInAccount objLinkedInAccount = new LinkedInAccount();
LinkedInAccountRepository objLiRepo = new LinkedInAccountRepository();
try
{
objLinkedInAccount.UserId = user.Id;
objLinkedInAccount.LinkedinUserId = data.id.ToString();
try
{
objLinkedInAccount.EmailId = data.email.ToString();
}
catch { }
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 { }
try
{
objLinkedInAccount.ProfileUrl = data.profile_url.ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
objLinkedInAccount.Connections = data.connections;
objLinkedInAccount.IsActive = true;
socioprofile.UserId = user.Id;
socioprofile.ProfileType = "linkedin";
socioprofile.ProfileId = data.id.ToString();
socioprofile.ProfileStatus = 1;
socioprofile.ProfileDate = DateTime.Now;
socioprofile.Id = Guid.NewGuid();
}
catch
{
}
try
{
if (!string.IsNullOrEmpty(objLinkedInAccount.LinkedinUserId))
{
if (objLiRepo.checkLinkedinUserExists(objLinkedInAccount.LinkedinUserId,user.Id))
{
if (!socioprofilerepo.checkUserProfileExist(socioprofile))
{
socioprofilerepo.addNewProfileForUser(socioprofile);
}
objLiRepo.updateLinkedinUser(objLinkedInAccount);
}
else
{
if (!socioprofilerepo.checkUserProfileExist(socioprofile))
{
socioprofilerepo.addNewProfileForUser(socioprofile);
}
objLiRepo.addLinkedinUser(objLinkedInAccount);
}
}
GetLinkedInFeeds(_oauth, data.id, user.Id);
}
catch
{
}
}
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");
}
}