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;
}
}
