public MembershipUser GetUser(Int32 id)
{
using (RoleMembershipDataContext db = new RoleMembershipDataContext())
{
var result = from u in db.Users where (u.UserId == id) select u;
if (result.Count() == 0)
{
return null;
}
User dbuser = result.FirstOrDefault();
MembershipUser user = new MembershipUser("CustomMembershipProvider",
dbuser.Login,
dbuser.UserId,
String.Empty,
String.Empty,
String.Empty,
true,
false,
dbuser.CreatedDate,
DateTime.Now,
DateTime.Now,
DateTime.Now,
DateTime.Now);
return user;
}
}
public IQueryable GetAllUsers()
{
using (RoleMembershipDataContext db = new RoleMembershipDataContext())
{
var users = from p in db.Users
orderby p.Login
select p;
return users;
}
}
public MembershipUser CreateUser(String login, String password, String userrole)
{
using (RoleMembershipDataContext db = new RoleMembershipDataContext())
{
User user = new User
{
Login = login,
Password = password,
PasswordSalt = CreateSalt(),
CreatedDate = DateTime.Now,
LastLoginDate = DateTime.Now
};
user.Password = CreatePasswordHash(password, user.PasswordSalt);
db.Users.InsertOnSubmit(user);
db.SubmitChanges();
return GetUser(login);
}
}
public Boolean ValidateUser(String login, String password)
{
using (RoleMembershipDataContext db = new RoleMembershipDataContext())
{
var dbuser = db.Users.FirstOrDefault(x => x.Login == login);
return dbuser != null && dbuser.Password == CreatePasswordHash(password, dbuser.PasswordSalt);
}
}
