public static void AddUserToRole(Guid UserId, string roleName)
{
using (CarrotCMSDataContext _db = CarrotCMSDataContext.Create()) {
membership_Role role = (from r in _db.membership_Roles
where r.Name.ToLower() == roleName.ToLower()
select r).FirstOrDefault();
membership_User user = (from u in _db.membership_Users
join ud in _db.carrot_UserDatas on u.Id equals ud.UserKey
where ud.UserId == UserId
select u).FirstOrDefault();
membership_UserRole usrRole = (from r in _db.membership_Roles
join ur in _db.membership_UserRoles on r.Id equals ur.RoleId
join u in _db.membership_Users on ur.UserId equals u.Id
join ud in _db.carrot_UserDatas on u.Id equals ud.UserKey
where r.Name.ToLower() == roleName.ToLower() &&
ud.UserId == UserId
select ur).FirstOrDefault();
if (usrRole == null && role != null && user != null)
{
usrRole = new membership_UserRole();
usrRole.UserId = user.Id;
usrRole.RoleId = role.Id;
_db.membership_UserRoles.InsertOnSubmit(usrRole);
_db.SubmitChanges();
}
}
}
internal UserProfile(membership_User mu, carrot_UserData ud)
{
if (mu != null) {
this.Id = mu.Id;
this.Email = mu.Email;
this.EmailConfirmed = mu.EmailConfirmed;
this.PasswordHash = mu.PasswordHash;
this.SecurityStamp = mu.SecurityStamp;
this.PhoneNumber = mu.PhoneNumber;
this.PhoneNumberConfirmed = mu.PhoneNumberConfirmed;
this.TwoFactorEnabled = mu.TwoFactorEnabled;
this.LockoutEndDateUtc = mu.LockoutEndDateUtc;
this.LockoutEnabled = mu.LockoutEnabled;
this.AccessFailedCount = mu.AccessFailedCount;
this.UserName = mu.UserName;
this.UserId = Guid.Empty;
this.UserKey = mu.Id;
}
if (ud != null) {
this.UserId = ud.UserId;
this.UserNickName = ud.UserNickName;
this.FirstName = ud.FirstName;
this.LastName = ud.LastName;
this.UserBio = ud.UserBio;
this.UserKey = ud.UserKey;
} else {
this.UserId = Guid.Empty;
this.UserKey = String.Empty;
}
}
public static bool AddUserToRole(string userName, string roleName)
{
using (CarrotCMSDataContext _db = CarrotCMSDataContext.Create()) {
membership_Role role = (from r in _db.membership_Roles
where r.Name == roleName
select r).FirstOrDefault();
membership_User user = (from u in _db.membership_Users
where u.UserName == userName
select u).FirstOrDefault();
membership_UserRole usrRole = (from r in _db.membership_Roles
join ur in _db.membership_UserRoles on r.Id equals ur.RoleId
join u in _db.membership_Users on ur.UserId equals u.Id
where r.Name == roleName &&
u.UserName == userName
select ur).FirstOrDefault();
if (usrRole == null && role != null && user != null)
{
usrRole = new membership_UserRole();
usrRole.UserId = user.Id;
usrRole.RoleId = role.Id;
_db.membership_UserRoles.InsertOnSubmit(usrRole);
_db.SubmitChanges();
return(true);
}
return(false);
}
}
internal UserProfile(membership_User mu, carrot_UserData ud)
{
if (mu != null)
{
this.Id = mu.Id;
this.Email = mu.Email;
this.EmailConfirmed = mu.EmailConfirmed;
this.PasswordHash = mu.PasswordHash;
this.SecurityStamp = mu.SecurityStamp;
this.PhoneNumber = mu.PhoneNumber;
this.PhoneNumberConfirmed = mu.PhoneNumberConfirmed;
this.TwoFactorEnabled = mu.TwoFactorEnabled;
this.LockoutEndDateUtc = mu.LockoutEndDateUtc;
this.LockoutEnabled = mu.LockoutEnabled;
this.AccessFailedCount = mu.AccessFailedCount;
this.UserName = mu.UserName;
this.UserId = Guid.Empty;
this.UserKey = mu.Id;
}
if (ud != null)
{
this.UserId = ud.UserId;
this.UserNickName = ud.UserNickName;
this.FirstName = ud.FirstName;
this.LastName = ud.LastName;
this.UserBio = ud.UserBio;
this.UserKey = ud.UserKey;
}
else
{
this.UserId = Guid.Empty;
this.UserKey = String.Empty;
}
}
