public UserProfileView GetUserProfile(int userID) { UserProfileView UPV = new UserProfileView(); using (PetrissEntities db = new PetrissEntities()) { var user = db.Users.Find(userID); if (user != null) { UPV.UserId = user.UserId; UPV.EmailAddress = user.EmailId; var _userprofile = db.UsersProfiles.Find(userID); if (_userprofile != null) { UPV.FirstName = _userprofile.FirstName; UPV.LastName = _userprofile.LastName; UPV.PhoneNumber = _userprofile.PhoneNumber; } var SUR = db.UsersRoles.Find(userID); if (SUR != null) { UPV.UserLookupRoleId = SUR.UserLookupRoleId; UPV.RoleName = SUR.UserLookupRole.RoleName; UPV.IsRoleActive = SUR.IsActive; } } } return(UPV); }
public bool IsLoginNameExist(string loginName) { using (PetrissEntities db = new PetrissEntities()) { return(db.Users.Where(o => o.EmailId.Equals(loginName)).Any()); } }
public UserDataView GetUserDataView(string loginName) { UserDataView UDV = new UserDataView(); List <UserProfileView> profiles = GetAllUserProfiles(); List <UserLookupAvailableRole> roles = GetAllRoles(); int? userAssignedRoleID = 0, userID = 0; string userGender = string.Empty; userID = GetUserID(loginName); using (PetrissEntities db = new PetrissEntities()) { userAssignedRoleID = db.UsersRoles.Where(o => o.UserId == userID)?.FirstOrDefault().UserLookupRoleId; userGender = db.UsersProfiles.Where(o => o.UserId == userID)?.FirstOrDefault().Gender; } //List<Gender> genders = new List<Gender>(); //genders.Add(new Gender { Text = "Male", Value = "M" }); //genders.Add(new Gender { Text = "Female", Value = "F" }); UDV.UserProfile = profiles; UDV.UserRoles = new UserRoles { SelectedRoleId = userAssignedRoleID, UserRoleList = roles }; //UDV.UserGender = new UserGender { SelectedGender = userGender, Gender = genders }; return(UDV); }
/// <summary> /// /// </summary> /// <param name="userID"></param> /// <returns></returns> public UserProfileView GetVendorById(int userID) { UserProfileView _userprofile = new UserProfileView(); using (PetrissEntities db = new PetrissEntities()) { var user = db.Users.Find(userID); if (user != null) { _userprofile.UserId = user.UserId; _userprofile.EmailAddress = user.EmailId; var SUP = db.UsersProfiles.Find(userID); if (SUP != null) { _userprofile.FirstName = SUP.FirstName; _userprofile.LastName = SUP.LastName; _userprofile.PhoneNumber = SUP.PhoneNumber; } var SUR = db.UsersRoles.Find(userID); if (SUR != null) { _userprofile.UserLookupRoleId = SUR.UserLookupRoleId; _userprofile.RoleName = SUR.UserLookupRole.RoleName; _userprofile.IsRoleActive = SUR.IsActive; } } } return(_userprofile); }
public int GetUserID(string loginName) { using (PetrissEntities db = new PetrissEntities()) { var user = db.Users.Where(o => o.EmailId.Equals(loginName)); if (user.Any()) { return(user.FirstOrDefault().UserId); } } return(0); }
public List <UserLookupAvailableRole> GetAllRoles() { using (PetrissEntities db = new PetrissEntities()) { var roles = db.UserLookupRoles.Select(o => new UserLookupAvailableRole { UserLookupRoleId = o.UserLookupRoleId, RoleName = o.RoleName, RoleDescription = o.RoleDescription }).ToList(); return(roles); } }
public string GetUserActivationLink(string loginName) { using (PetrissEntities db = new PetrissEntities()) { var user = db.Users.Where(o => o.EmailId.ToLower().Equals(loginName)); if (user.Any()) { return(user.FirstOrDefault().UserActivationLink); } else { return(string.Empty); } } }
public void AddUserAccount(UserSignUpView user) { string baseUrl = HttpContext.Current.Request.Url.GetLeftPart(UriPartial.Authority); using (PetrissEntities db = new PetrissEntities()) { User _user = new User(); _user.EmailId = user.EmailAddress; _user.PreferredName = user.PrefferedName; _user.Password = user.Password; _user.UserActivationLink = baseUrl + Guid.NewGuid(); _user.CreatedByUserId = user.UserId > 0 ? user.UserId : 1; _user.ModifiedByUserId = user.UserId > 0 ? user.UserId : 1;; _user.CreatedDateTime = DateTime.Now; _user.ModifiedDateTime = DateTime.Now; db.Users.Add(_user); db.SaveChanges(); UsersProfile _userprofiles = new UsersProfile(); _userprofiles.UserId = _user.UserId; _userprofiles.PreferredName = user.PrefferedName; _userprofiles.FirstName = user.FirstName; _userprofiles.LastName = user.LastName; _userprofiles.CreatedByUserId = user.UserId > 0 ? user.UserId : 1; _userprofiles.ModifiedByUserId = user.UserId > 0 ? user.UserId : 1; _userprofiles.CreatedDateTime = DateTime.Now; _userprofiles.ModifiedDateTime = DateTime.Now; db.UsersProfiles.Add(_userprofiles); db.SaveChanges(); if (user.UserLookupRoleId > 0) { UsersRole _usersrole = new UsersRole(); _usersrole.UserLookupRoleId = user.UserLookupRoleId; _usersrole.UserId = user.UserId; _usersrole.IsActive = true; _usersrole.CreatedByUserId = user.UserId > 0 ? user.UserId : 1; _usersrole.ModifiedByUserId = user.UserId > 0 ? user.UserId : 1; _usersrole.CreatedDateTime = DateTime.Now; _usersrole.ModifiedDateTime = DateTime.Now; db.UsersRoles.Add(_usersrole); db.SaveChanges(); } } }
protected override bool AuthorizeCore(HttpContextBase httpContext) { bool authorize = false; using (PetrissEntities db = new PetrissEntities()) { UserManager UM = new UserManager(); foreach (var roles in userAssignedRoles) { authorize = UM.IsUserInRole(httpContext.User.Identity.Name, roles); if (authorize) { return(authorize); } } } return(authorize); }
/// <summary> /// /// </summary> /// <param name="user"></param> public void AddVendor(UserSignUpView user) { using (PetrissEntities db = new PetrissEntities()) { User _user = new User(); _user.EmailId = user.EmailAddress; _user.Password = user.Password; _user.CreatedByUserId = user.UserId > 0 ? user.UserId : 1; _user.ModifiedByUserId = user.UserId > 0 ? user.UserId : 1;; _user.CreatedDateTime = DateTime.Now; _user.ModifiedDateTime = DateTime.Now; db.Users.Add(_user); db.SaveChanges(); UsersProfile _userprofiles = new UsersProfile(); _userprofiles.UserId = _user.UserId; _userprofiles.FirstName = user.FirstName; _userprofiles.LastName = user.LastName; _userprofiles.CreatedByUserId = user.UserId > 0 ? user.UserId : 1; _userprofiles.ModifiedByUserId = user.UserId > 0 ? user.UserId : 1; _userprofiles.CreatedDateTime = DateTime.Now; _userprofiles.ModifiedDateTime = DateTime.Now; db.UsersProfiles.Add(_userprofiles); db.SaveChanges(); if (user.UserLookupRoleId > 0) { UsersRole _usersrole = new UsersRole(); _usersrole.UserLookupRoleId = user.UserLookupRoleId; _usersrole.UserId = user.UserId; _usersrole.IsActive = true; _usersrole.CreatedByUserId = user.UserId > 0 ? user.UserId : 1; _usersrole.ModifiedByUserId = user.UserId > 0 ? user.UserId : 1; _usersrole.CreatedDateTime = DateTime.Now; _usersrole.ModifiedDateTime = DateTime.Now; db.UsersRoles.Add(_usersrole); db.SaveChanges(); } } }
public string[] GetRolesForUser(string loginName) { using (PetrissEntities db = new PetrissEntities()) { User _user = db.Users.Where(o => o.EmailId.ToLower().Equals(loginName))?.FirstOrDefault(); if (_user != null) { var roles = from q in db.UsersRoles join r in db.UserLookupRoles on q.UserLookupRoleId equals r.UserLookupRoleId select r.RoleName; if (roles != null) { return(roles.ToArray()); } } return(new string[] { }); } }
public bool IsUserInRole(string loginName, string roleName) { using (PetrissEntities db = new PetrissEntities()) { User _user = db.Users.Where(o => o.EmailId.ToLower().Equals(loginName))?.FirstOrDefault(); if (_user != null) { var roles = from q in db.UsersRoles join r in db.UserLookupRoles on q.UserLookupRoleId equals r.UserLookupRoleId where r.RoleName.Equals(roleName) && q.UserId.Equals(_user.UserId) select r.RoleName; if (roles != null) { return(roles.Any()); } } return(false); } }
public List <UserProfileView> GetAllUserProfiles() { List <UserProfileView> profiles = new List <UserProfileView>(); using (PetrissEntities db = new PetrissEntities()) { UserProfileView UPV; var users = db.Users.ToList(); foreach (User u in db.Users) { UPV = new UserProfileView(); UPV.UserId = u.UserId; UPV.EmailAddress = u.EmailId; var _userprofile = db.UsersProfiles.Find(u.UserId); if (_userprofile != null) { UPV.FirstName = _userprofile.FirstName; UPV.LastName = _userprofile.LastName; UPV.PhoneNumber = _userprofile.PhoneNumber; } var SUR = db.UsersRoles.Where(o => o.UserId.Equals(u.UserId)); if (SUR.Any()) { var userRole = SUR.FirstOrDefault(); UPV.UserLookupRoleId = userRole.UserLookupRoleId; UPV.RoleName = userRole.UserLookupRole.RoleName; UPV.IsRoleActive = userRole.IsActive; } profiles.Add(UPV); } } return(profiles); }
public void DeleteUser(int userID) { using (PetrissEntities db = new PetrissEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { var SUR = db.UsersRoles.Where(o => o.UserId == userID); if (SUR.Any()) { db.UsersRoles.Remove(SUR.FirstOrDefault()); db.SaveChanges(); } var _userprofile = db.UsersProfiles.Where(o => o.UserId == userID); if (_userprofile.Any()) { db.UsersProfiles.Remove(_userprofile.FirstOrDefault()); db.SaveChanges(); } var _user = db.Users.Where(o => o.UserId == userID); if (_user.Any()) { db.Users.Remove(_user.FirstOrDefault()); db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }
public void UpdateUserAccount(UserProfileView user) { using (PetrissEntities db = new PetrissEntities()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { User _user = db.Users.Find(user.UserId); _user.EmailId = user.EmailAddress; _user.CreatedByUserId = user.UserId; _user.ModifiedByUserId = user.UserId; _user.CreatedDateTime = DateTime.Now; _user.ModifiedDateTime = DateTime.Now; db.SaveChanges(); var userProfile = db.UsersProfiles.Where(o => o.UserId == user.UserId); if (userProfile.Any()) { UsersProfile _userprofile = userProfile.FirstOrDefault(); _userprofile.UserId = _user.UserId; _userprofile.FirstName = user.FirstName; _userprofile.LastName = user.LastName; _userprofile.PhoneNumber = user.PhoneNumber; _userprofile.CreatedByUserId = user.UserId; _userprofile.ModifiedByUserId = user.UserId; _userprofile.CreatedDateTime = DateTime.Now; _userprofile.ModifiedDateTime = DateTime.Now; db.SaveChanges(); } if (user.UserLookupRoleId > 0) { var userRole = db.UsersRoles.Where(o => o.UserId == user.UserId); UsersRole SUR = null; if (userRole.Any()) { SUR = userRole.FirstOrDefault(); SUR.UserLookupRoleId = user.UserLookupRoleId; SUR.UserId = user.UserId; SUR.IsActive = true; SUR.CreatedByUserId = user.UserId; SUR.ModifiedByUserId = user.UserId; SUR.CreatedDateTime = DateTime.Now; SUR.ModifiedDateTime = DateTime.Now; } else { SUR = new UsersRole(); SUR.UserLookupRoleId = user.UserLookupRoleId; SUR.UserId = user.UserId; SUR.IsActive = true; SUR.CreatedByUserId = user.UserId; SUR.ModifiedByUserId = user.UserId; SUR.CreatedDateTime = DateTime.Now; SUR.ModifiedDateTime = DateTime.Now; db.UsersRoles.Add(SUR); } db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }