public bool ActivateUser(string username, string key)
{
bool result = false;
using (CustomMembershipDB db = new CustomMembershipDB())
{
var dbuser = db.Users.FirstOrDefault(u => u.userName == username);
if (dbuser != null)
{
if (dbuser.newMail == key)
{
dbuser.isActivated = true;
dbuser.modifyedDate = DateTime.Now;
dbuser.newMail = null;
db.SaveChanges();
result=true;
}
}
// else
// {
// return false;
// }
//}
//else
//{
return result;
//}
}
}
public bool ValidateUser(string username, string password)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
var result = from u in db.Users where (u.userName == username) select u;
if (result.Count() != 0)
{
var dbuser = result.First();
if (dbuser.password == CreatePasswordHash(password, dbuser.passwordSalt))
{
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
public string GetUserNameByEmail(string email)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
IQueryable <User> result = from u in db.Users where (u.mail == email) select u;
if (result.Count() != 0)
{
var dbuser = result.FirstOrDefault();
return(dbuser.userName);
}
else
{
return("");
}
}
}
public string GetUserNameByEmail(string email)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
IQueryable<User> result = from u in db.Users where (u.mail == email) select u;
if (result.Count() != 0)
{
var dbuser = result.FirstOrDefault();
return dbuser.userName;
}
else
{
return "";
}
}
}
public MembershipUser GetUser(string username)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
var result = from u in db.Users where (u.userName == username) select u;
if (result.Count() != 0)
{
var dbuser = result.FirstOrDefault();
string _username = dbuser.userName;
int _providerUserKey = dbuser.user_id;
string _email = dbuser.mail;
string _passwordQuestion = "";
string _comment = dbuser.comments;
bool _isApproved = (bool)dbuser.isActivated;
bool _isLockedOut = (bool)dbuser.isLockedOut;
DateTime _creationDate = (DateTime)dbuser.createdDate;
DateTime _lastLoginDate = (DateTime)dbuser.lastLoginDate;
DateTime _lastActivityDate = DateTime.Now;
DateTime _lastPasswordChangedDate = DateTime.Now;
DateTime _lastLockedOutDate = (DateTime)dbuser.lastLockedOutDate;
MembershipUser user = new MembershipUser("CustomMembershipProvider",
_username,
_providerUserKey,
_email,
_passwordQuestion,
_comment,
_isApproved,
_isLockedOut,
_creationDate,
_lastLoginDate,
_lastActivityDate,
_lastPasswordChangedDate,
_lastLockedOutDate);
return(user);
}
else
{
return(null);
}
}
}
public MembershipUser GetUser(string username)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
var result = from u in db.Users where (u.userName == username) select u;
if (result.Count() != 0)
{
var dbuser = result.FirstOrDefault();
string _username = dbuser.userName;
int _providerUserKey = dbuser.user_id;
string _email = dbuser.mail;
string _passwordQuestion = "";
string _comment = dbuser.comments;
bool _isApproved =(bool) dbuser.isActivated;
bool _isLockedOut =(bool) dbuser.isLockedOut;
DateTime _creationDate =(DateTime) dbuser.createdDate;
DateTime _lastLoginDate =(DateTime) dbuser.lastLoginDate;
DateTime _lastActivityDate = DateTime.Now;
DateTime _lastPasswordChangedDate = DateTime.Now;
DateTime _lastLockedOutDate =(DateTime) dbuser.lastLockedOutDate;
MembershipUser user = new MembershipUser("CustomMembershipProvider",
_username,
_providerUserKey,
_email,
_passwordQuestion,
_comment,
_isApproved,
_isLockedOut,
_creationDate,
_lastLoginDate,
_lastActivityDate,
_lastPasswordChangedDate,
_lastLockedOutDate);
return user;
}
else
{
return null;
}
}
}
// private CustomRoleMembershipDB db = new CustomRoleMembershipDB();
public MembershipUser CreateUser(string username, string password, string email)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
User user = new User();
user.userName = username;
user.mail = email;
user.passwordSalt = CreateSalt();
user.password = CreatePasswordHash(password, user.passwordSalt);
user.createdDate = DateTime.Now;
user.isActivated = false;
user.isLockedOut = false;
user.lastLockedOutDate = DateTime.Now;
user.lastLoginDate = DateTime.Now;
db.AddToUsers(user);
db.SaveChanges();
return(GetUser(username));
}
}
// private CustomRoleMembershipDB db = new CustomRoleMembershipDB();
public MembershipUser CreateUser(string username, string password, string email)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
User user = new User();
user.userName = username;
user.mail = email;
user.passwordSalt = CreateSalt();
user.password = CreatePasswordHash(password, user.passwordSalt);
user.createdDate = DateTime.Now;
user.isActivated = false;
user.isLockedOut = false;
user.lastLockedOutDate = DateTime.Now;
user.lastLoginDate = DateTime.Now;
db.AddToUsers(user);
db.SaveChanges();
return GetUser(username);
}
}
public bool ChangePassword(string username)
{
bool result = false;
using (CustomMembershipDB db = new CustomMembershipDB())
{
var user = db.Users.FirstOrDefault(u => u.userName == username);
if (user != null)
{
string newPassword = GeneratePassword();
user.newMail = newPassword;
user.passwordSalt = CreateSalt();
user.password = CreatePasswordHash(newPassword, user.passwordSalt);
db.AcceptAllChanges();
/* if (db.SaveChanges() > 0)
{
result = true;
}
*/ }
}
return result;
}
public bool ChangePassword(string username, string oldPassword, string newPassword)
{
bool result=false;
using (CustomMembershipDB db = new CustomMembershipDB())
{
var user = db.Users.FirstOrDefault(u => u.userName == username);
if (user != null)
{
user.passwordSalt = CreateSalt();
user.password = CreatePasswordHash(newPassword, user.passwordSalt);
user.newMail = null;
user.modifyedDate = DateTime.Now;
Save();
result=true;
}
}
return result;
}
public bool ValidateUser(string username, string password)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
var result = from u in db.Users where (u.userName == username) select u;
if (result.Count() != 0)
{
var dbuser = result.First();
return ((dbuser.password == CreatePasswordHash(password, dbuser.passwordSalt))&&(dbuser.isActivated == true));
}
else
{
return false;
}
}
}
public bool SaveUser(User newUser)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
var result = from u in db.Users where (u.user_id == newUser.user_id) select u;
if (result.Count() != 0)
{
var dbuser = result.First();
dbuser.comments = newUser.comments;
dbuser.mail = newUser.mail;
dbuser.name = newUser.name;
dbuser.lastName = newUser.lastName;
db.SaveChanges();
return true;
}
}
return false;
}
public bool DeleteUser(int id)
{
bool result = false;
using (CustomMembershipDB db = new CustomMembershipDB())
{
try
{
db.DeleteObject(db.Users.First(u => u.user_id == id));
db.SaveChanges();
result=true;
}
catch (Exception ex)
{
throw ex;
}
}
return result;
}
public MembershipUser CreateUser(string username, string password, string email,string lastName,string name)
{
using (CustomMembershipDB db = new CustomMembershipDB())
{
User user = new User();
user.userName = username;
user.mail = email;
user.lastName = lastName;
user.name = name;
user.passwordSalt = CreateSalt();
user.password = CreatePasswordHash(password, user.passwordSalt);
user.createdDate = DateTime.Now;
user.isActivated = true;
user.isLockedOut = false;
user.lastLockedOutDate = DateTime.Now;
user.lastLoginDate = DateTime.Now;
// ключ для активации
user.newMail = GenerateKey();
// SendMail(user);
MailSender.SendMail(1, user);
db.AddToUsers(user);
db.SaveChanges();
return GetUser(username);
}
}
