// POST: api/Sysuser public Sysuser Post([FromBody] Sysuser value) { using (fashionshoppingDBEntities db = new fashionshoppingDBEntities()) { db.Sysuser.Add(value); db.SaveChanges(); } return(value); }
// PUT: api/Sysuser/5 public Sysuser Put(int id, [FromBody] Sysuser value) { using (fashionshoppingDBEntities db = new fashionshoppingDBEntities()) { var sysuser = db.Sysuser.SingleOrDefault(s => s.id == id); if (sysuser != null) { sysuser.pwd = value.pwd; sysuser.role = value.role; sysuser.username = value.username; } db.SaveChanges(); } return(value); }
public ActionResult Login(string UserName, string Password) { using (webdevContext DB = new webdevContext()) { Sysuser us = DB.Sysuser.Where(a => a.UserCode == UserName && a.PassWrod == Password).FirstOrDefault(); if (us == null) { return(Json(new { Success = false, msg = "账号或密码有误" })); } else { byte[] SessionUser = Other.SerializeToByte(us); HttpContext.Session.Set("user", SessionUser); var token = JwtJsonModel.BulidJwtJson(us); return(Json(new { Success = true, token = token, name = us.UserName })); } } }
public void AddUserAccount(UserSignUpView user) { using (DemoDBContext db = new DemoDBContext()) { Sysuser SU = new Sysuser(); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1; SU.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1;; SU.RowCreatedDateTime = DateTime.Now; SU.RowModifiedDateTime = DateTime.Now; db.Sysuser.Add(SU); db.SaveChanges(); SysuserProfile SUP = new SysuserProfile(); SUP.SysuserId = SU.SysuserId; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SysuserProfile.Add(SUP); db.SaveChanges(); if (user.LOOKUPRoleID > 0) { SysuserRole SUR = new SysuserRole(); SUR.LookuproleId = user.LOOKUPRoleID; SUR.SysuserId = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1; SUR.RowModifiedSysuserId = user.SYSUserID > 0 ? user.SYSUserID : 1; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SysuserRole.Add(SUR); db.SaveChanges(); } } }
public string[] GetRolesForUser(string loginName) { using (DemoDBContext db = new DemoDBContext()) { Sysuser SU = db.Sysuser.Where(o => o.LoginName.ToLower().Equals(loginName))?.FirstOrDefault(); if (SU != null) { var roles = from q in db.SysuserRole join r in db.Lookuprole on q.LookuproleId equals r.LookuproleId select r.RoleName; if (roles != null) { return(roles.ToArray()); } } return(new string[] { }); } }
/// <summary> /// 系统用户注册 /// </summary> /// <param name="loginName">登录名</param> /// <param name="password">密码</param> /// <returns></returns> public bool SysUserRegister(string loginName, string password) { try { var sysuser = new Sysuser(loginName, password); _sysuser.Insert(sysuser); if (_unitOfWork.Commit() == 0) { throw new Exception("用户注册失败"); } return(true); } catch (Exception ex) { return(false); } }
public bool IsUserInRole(string loginName, string roleName) { using (DemoDBContext db = new DemoDBContext()) { Sysuser SU = db.Sysuser.Where(o => o.LoginName.ToLower().Equals(loginName))?.FirstOrDefault(); if (SU != null) { var roles = from q in db.SysuserRole join r in db.Lookuprole on q.LookuproleId equals r.LookuproleId where r.RoleName.Equals(roleName) && q.SysuserId.Equals(SU.SysuserId) select r.RoleName; if (roles != null) { return(roles.Any()); } } return(false); } }
/// <summary> /// 颁发Token /// </summary> /// <param name="user">用户</param> /// <returns></returns> public static dynamic BulidJwtJson(Sysuser user) { var claims = new[] { new Claim(JwtRegisteredClaimNames.Nbf, $"{new DateTimeOffset(DateTime.Now).ToUnixTimeSeconds()}"), new Claim(JwtRegisteredClaimNames.Exp, $"{new DateTimeOffset(DateTime.Now.AddMinutes(30)).ToUnixTimeSeconds()}"), new Claim(ClaimTypes.Name, user.UserCode) }; var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(JwtKey)); var creds = new SigningCredentials(key, SecurityAlgorithms.HmacSha256); var token = new JwtSecurityToken( issuer: Issuer, audience: Claims, claims: claims, notBefore: DateTime.Now, expires: DateTime.Now.AddHours(1), signingCredentials: new SigningCredentials(key, SecurityAlgorithms.HmacSha256)); var jwtToken = new JwtSecurityTokenHandler().WriteToken(token); return(jwtToken); }
public void UpdateUserAccount(UserProfileView user) { using (DemoDBContext db = new DemoDBContext()) { using (var dbContextTransaction = db.Database.BeginTransaction()) { try { Sysuser SU = db.Sysuser.Find(user.SYSUserID); SU.LoginName = user.LoginName; SU.PasswordEncryptedText = user.Password; SU.RowCreatedSysuserId = user.SYSUserID; SU.RowModifiedSysuserId = user.SYSUserID; SU.RowCreatedDateTime = DateTime.Now; SU.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); var userProfile = db.SysuserProfile.Where(o => o.SysuserId == user.SYSUserID); if (userProfile.Any()) { SysuserProfile SUP = userProfile.FirstOrDefault(); SUP.SysuserId = SU.SysuserId; SUP.FirstName = user.FirstName; SUP.LastName = user.LastName; SUP.Gender = user.Gender; SUP.RowCreatedSysuserId = user.SYSUserID; SUP.RowModifiedSysuserId = user.SYSUserID; SUP.RowCreatedDateTime = DateTime.Now; SUP.RowModifiedDateTime = DateTime.Now; db.SaveChanges(); } if (user.LOOKUPRoleID > 0) { var userRole = db.SysuserRole.Where(o => o.SysuserId == user.SYSUserID); SysuserRole SUR = null; if (userRole.Any()) { SUR = userRole.FirstOrDefault(); SUR.LookuproleId = user.LOOKUPRoleID; SUR.SysuserId = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSysuserId = user.SYSUserID; SUR.RowModifiedSysuserId = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; } else { SUR = new SysuserRole(); SUR.LookuproleId = user.LOOKUPRoleID; SUR.SysuserId = user.SYSUserID; SUR.IsActive = true; SUR.RowCreatedSysuserId = user.SYSUserID; SUR.RowModifiedSysuserId = user.SYSUserID; SUR.RowCreatedDateTime = DateTime.Now; SUR.RowModifiedDateTime = DateTime.Now; db.SysuserRole.Add(SUR); } db.SaveChanges(); } dbContextTransaction.Commit(); } catch { dbContextTransaction.Rollback(); } } } }