public bool DeleteUser(decimal UserID) { //ICollection<CM_USER_ROLE_XREF> UserRoleColl = new Collection<CM_USER_ROLE_XREF>(); CM_USER_PROFILE up = new CM_USER_PROFILE(); CM_USER_ROLE_XREF urx = new CM_USER_ROLE_XREF(); try { //First Delete Rec from UserRoleRef CM_USER_ROLE_XREF objDelUserRoleRef = (from Profile in db.CM_USER_ROLE_XREF where Profile.USER_ID == UserID select Profile).FirstOrDefault(); db.CM_USER_ROLE_XREF.Remove(objDelUserRoleRef); db.SaveChanges(); //First Delete Rec from MakerCheckerRef //CM_MAKER_CHECKER_XREF objDelMakerCheckerRef = (from MCX in db.CM_MAKER_CHECKER_XREF where MCX.CHECKER_ID == UserID || MCX.MAKER_ID == UserID select MCX).FirstOrDefault(); //db.CM_MAKER_CHECKER_XREF.Remove(objDelMakerCheckerRef); //db.SaveChanges(); CM_USER_PROFILE objDeleteUser = (from Profile in db.CM_USER_PROFILE where Profile.PROFILE_ID == UserID select Profile).FirstOrDefault(); db.CM_USER_PROFILE.Remove(objDeleteUser); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
private void GetDatabaseUserRolesPermissions() { using (AppDbContext _data = new AppDbContext()) { CM_USER_PROFILE _user = _data.CM_USER_PROFILE.Where(u => u.USER_ID.ToUpper() == this.UserId.ToUpper()).FirstOrDefault(); if (_user != null) { this.ProfileId = (int)_user.PROFILE_ID; CM_USER_ROLES _userRole = _data.CM_USER_ROLES.Where(u => u.ROLE_ID == this.RoleId).FirstOrDefault(); List <CM_ROLE_PERM_XREF> _permxref = _data.CM_ROLE_PERM_XREF.Where(p => p.ROLE_ID == _userRole.ROLE_ID).ToList(); foreach (CM_ROLE_PERM_XREF _permission in _permxref) { //_userRole.CM_PERMISSIONS.Add(new CM_PERMISSIONS { PERMISSION_ID = (int)_permission.PERMISSION_ID, PERMISSIONDESCRIPTION = _permission.PERMISSIONDESCRIPTION }); Permissions.Add(new CM_PERMISSIONS { PERMISSION_ID = (int)_permission.PERMISSION_ID, PERMISSIONDESCRIPTION = "" }); } this.Roles.Add(_userRole); //foreach (CM_USER_ROLES _role in _user.CM_USER_ROLES) //{ // UserRole _userRole = new UserRole { Role_Id = _role.ROLE_ID, RoleName = _role.ROLE_NAME }; // this.Roles.Add(_userRole); // //if (!this.IsSysAdmin) // // this.IsSysAdmin = (bool)!_role.IS_DEFAULT; //} } } }
//private AppDbContext db;// = new AppDbContext(); #endregion /// <summary> /// Inserts a new row in the CM_USER_PROFILE table. /// </summary> /// <param name="mdmque">A CM_USER_PROFILE object.</param> /// <returns>An updated CM_USER_PROFILE object.</returns> public CM_USER_PROFILE Insert(CM_USER_PROFILE userprofile) { using (var db = new AppDbContext()) { db.Set <CM_USER_PROFILE>().Add(userprofile); db.SaveChanges(); return(userprofile); } }
public bool CreateUser(string username, string password, string RoleId, string FName, string LName, string Email) { string salt = null; ICollection <CM_USER_ROLE_XREF> UserRoleColl = new Collection <CM_USER_ROLE_XREF>(); CM_USER_PROFILE up = new CM_USER_PROFILE(); string passwordHash = pwdManager.GeneratePasswordHash(password, out salt); int profileId = 0; using (var cdma = new AppDbContext()) { var usr = new CM_USER_PROFILE { COD_PASSWORD = passwordHash, PASSWORDSALT = salt, USER_ID = username, ISLOCKED = false, //isLoggedin CREATED_DATE = DateTime.Now, ROLE_ID = Convert.ToInt32(RoleId), FIRSTNAME = FName, LASTNAME = LName, DISPLAY_NAME = (FName.Substring(0, 1) + LName).ToLower(), EMAIL_ADDRESS = Email, ISAPPROVED = true, LASTLOGINDATE = DateTime.Now, LASTLOCKOUTDATE = DateTime.Now, LASTPASSWORDCHANGEDDATE = DateTime.Now }; cdma.CM_USER_PROFILE.Add(usr); cdma.SaveChanges(); profileId = usr.PROFILE_ID; } CM_USER_ROLE_XREF urx = new CM_USER_ROLE_XREF(); urx.USER_ID = profileId; urx.ROLE_ID = Convert.ToInt32(RoleId); UserRoleColl.Add(urx); up.CM_USER_ROLE_XREF = UserRoleColl; db.CM_USER_ROLE_XREF.Add(urx); db.SaveChanges(); if (up.PROFILE_ID == null) { return(false); } else { return(true); } }
/// <summary> /// Updates the queitem /// </summary> /// <param name="queitem">queitem</param> public virtual void UpdateQueItem(CM_USER_PROFILE queitem) { if (queitem == null) { throw new ArgumentNullException("queitem"); } _useradminDAC.Update(queitem); //event notification //_eventPublisher.EntityUpdated(vendor); }
/// <summary> /// Delete an item /// </summary> /// <param name="queitem">QueItem</param> public virtual void DeleteQueItem(CM_USER_PROFILE queitem) { if (queitem == null) { throw new ArgumentNullException("user"); } UpdateQueItem(queitem); //event notification //_eventPublisher.EntityDeleted(vendor); }
/// <summary> /// Updates an existing row in the userprofile table. /// </summary> /// <param name="userprofile">A userprofile entity object.</param> public void Update(CM_USER_PROFILE userprofile) { using (var db = new AppDbContext()) { var entry = db.Entry <CM_USER_PROFILE>(userprofile); // Re-attach the entity. entry.State = EntityState.Modified; db.SaveChanges(); } }
public decimal getProfileID(string p) { decimal status = 0; CM_USER_PROFILE up = new CM_USER_PROFILE(); var profID = from n in db.CM_USER_PROFILE where n.USER_ID == p.ToString() select new { n.PROFILE_ID }; status = profID.FirstOrDefault().PROFILE_ID; return(status); }
public override int GetNumberOfUsersOnline() { int status = 0; CM_USER_PROFILE up = new CM_USER_PROFILE(); var count = from n in db.CM_USER_PROFILE //where n.ISLOCKED == 1 select new { n.PROFILE_ID }; status = count.Count(); return(status); }
public CustomMembershipUser(CM_USER_PROFILE user) : base("CustomMembershipProvider", user.USER_ID, user.PROFILE_ID, user.EMAIL_ADDRESS, string.Empty, string.Empty, true, false, user.CREATED_DATE, (DateTime)user.LASTLOGINDATE, DateTime.Now, DateTime.Now, DateTime.Now) { FirstName = user.FIRSTNAME; LastName = user.LASTNAME; UserRoleId = (int)user.ROLE_ID; UserRoleName = user.CM_USER_ROLES.ROLE_NAME; DisplayName = user.DISPLAY_NAME; ProfileId = (int)user.PROFILE_ID; BranchId = user.BRANCH_ID; BranchName = user.CM_BRANCH.BRANCH_NAME; RegionId = user.CM_BRANCH.REGION_ID; RegionName = user.CM_BRANCH.REGION_NAME; ZoneId = user.CM_BRANCH.ZONECODE; ZoneName = user.CM_BRANCH.ZONENAME; }
public bool checkUserName(string Username) { bool status = false; CM_USER_PROFILE upl = new CM_USER_PROFILE(); var count = from n in db.CM_USER_PROFILE where (n.USER_ID == Username) select new { n.PROFILE_ID }; if (count.Count() > 0) { status = true; } else { status = false; } return(status); }
public bool getUserr(string Username, string Email) { bool status = false; CM_USER_PROFILE upl = new CM_USER_PROFILE(); var count = from n in db.CM_USER_PROFILE where (n.USER_ID == Username && n.EMAIL_ADDRESS == Email) select new { n.PROFILE_ID }; if (count.Count() > 0) { status = true; } else { status = false; } return(status); }