public static void AddUser(string userName, string firstName, string lastName, string emailAddress, string password, int roleID) { try { using (var ctxt = new AuthenticationEntities()) { ctxt.Users.Add(new User() { UserName = userName, FirstName = firstName, LastName = lastName, Password = password, RoleID = roleID, EmailAddress = emailAddress }); ctxt.SaveChanges(); } } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }
public override string[] GetRolesForUser(string username) { using(var context = new AuthenticationEntities()) { User usr = context.Users.Where(u => u.UserName.Equals(username)).FirstOrDefault(); if(usr != null) { Role role = context.Roles.Where(r => r.RoleID == usr.RoleID).FirstOrDefault(); return new string[] { role.RoleName }; } return new string[] { }; } }
public override bool IsUserInRole(string username, string roleName) { using (var context = new AuthenticationEntities()) { User usr = context.Users.Where(u => u.UserName == username).FirstOrDefault(); if(usr != null) { Role role = context.Roles.Where(r => r.RoleID == usr.RoleID).FirstOrDefault(); if (role.RoleName.Equals(roleName)) return true; } return false; } }
public override bool ValidateUser(string username, string password) { using (var ctxt = new AuthenticationEntities()) { bool loginSuccess = ctxt.Users.Any(user => (user.UserName.Equals(username) && user.Password.Equals(password))); return loginSuccess; } }