public bool Delete(string applicationName, string userName)
{
String stmtId = "Sys_User.Delete";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
if (SqlMapper.Update(stmtId, user) > 0) {
return true;
}
else return false;
}
public override MembershipUser CreateUser(string username, string password, string email, string passwordQuestion, string passwordAnswer, bool isApproved, object providerUserKey, out MembershipCreateStatus status)
{
ValidatePasswordEventArgs args =
new ValidatePasswordEventArgs(username, password, true);
OnValidatingPassword(args);
if (args.Cancel) {
status = MembershipCreateStatus.InvalidPassword;
return null;
}
if (RequiresUniqueEmail && GetUserNameByEmail(email) != "") {
status = MembershipCreateStatus.DuplicateEmail;
return null;
}
MembershipUser u = GetUser(username, false);
if (u == null) {
DateTime createDate = DateTime.Now;
if (providerUserKey == null) {
providerUserKey = Guid.NewGuid();
}
else {
if (!(providerUserKey is Guid)) {
status = MembershipCreateStatus.InvalidProviderUserKey;
return null;
}
}
Sys_User user = new Sys_User();
user.Id = providerUserKey.ToString();
user.Name = username;
user.DisplayName = username;
user.PasswordKey = GenerateSalt();
user.Password = EncodePassword(password, user.PasswordKey);
user.Email = email;
user.PasswordQuestion = passwordQuestion;
user.PasswordAnswer = passwordAnswer == null ? null : EncodePassword(passwordAnswer, user.PasswordKey);
user.IsApproved = isApproved == true ? short.Parse("1") : short.Parse("0");
user.Comment = string.Empty;
user.CreationDate = createDate;
user.LastPasswordChangedDate = createDate;
user.LastActivityDate = createDate;
user.LastLoginDate = createDate;
user.ApplicationName = _ApplicationName;
user.IsLockedOut = 0;
user.LastLockedOutDate = createDate;
user.FailedPasswordAttemptCount = 0;
user.FailedPasswordAttemptWindowStart = createDate;
user.FailedPasswordAnswerAttemptCount = 0;
user.FailedPasswordAnswerAttemptWindowStart = createDate;
bool result = _userRepository.Insert(user);
if (result) {
status = MembershipCreateStatus.Success;
}
else {
status = MembershipCreateStatus.UserRejected;
}
return GetUser(username, false);
}
else {
status = MembershipCreateStatus.DuplicateUserName;
}
return null;
}
public int GetCount(string applicationName)
{
String stmtId = "Sys_User.GetCount";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
int result = SqlMapper.QueryForObject<int>(stmtId, user);
return result;
}
public bool ValidateUser(string applicationName, string userName, string password)
{
String stmtId = "Sys_User.ValidateUser";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
user.Password = password;
int result = SqlMapper.QueryForObject<int>(stmtId, user);
if (result == 1) {
return true;
}
else {
return false;
}
}
public void Delete(Sys_User obj)
{
throw new NotImplementedException();
}
public bool UpdatePasswordQuestionAndAnswer(string applicationName, string userName, string passwordQuestion, string passwordAnswer)
{
String stmtId = "Sys_User.UpdatePasswordQuestionAndAnswer";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
user.PasswordQuestion = passwordQuestion;
user.PasswordAnswer = passwordAnswer;
if (SqlMapper.Update(stmtId, user) > 0) {
return true;
}
else return false;
}
public void UpdateLogonDate(string applicationName, string userName, DateTime LastLoginDate, DateTime LastActivityDate)
{
String stmtId = "Sys_User.UpdateLogonDate";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
user.LastLoginDate = LastLoginDate;
user.LastActivityDate = LastActivityDate;
SqlMapper.Update(stmtId, user);
}
public string GetUserNameByEmail(string applicationName, string email)
{
String stmtId = "Sys_User.GetUserNameByEmail";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Email = email;
Sys_User result = SqlMapper.QueryForObject<Sys_User>(stmtId, user);
if (result != null)
return result.Name;
else return string.Empty;
}
public bool UpdateFailedPasswordAnswer(string applicationName, string userName, int FailedPasswordAnswerAttemptCount, DateTime FailedPasswordAnswerAttemptWindowStart)
{
String stmtId = "Sys_User.UpdateFailedPasswordAnswer";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
user.FailedPasswordAnswerAttemptCount = FailedPasswordAnswerAttemptCount;
user.FailedPasswordAnswerAttemptWindowStart = FailedPasswordAnswerAttemptWindowStart;
if (SqlMapper.Update(stmtId, user) > 0) {
return true;
}
else return false;
}
public bool UpdateForMembershipUser(Sys_User obj)
{
String stmtId = "Sys_User.UpdateForMembershipUser";
if (SqlMapper.Update(stmtId, obj) > 0) {
return true;
}
else return false;
}
public bool Update(Sys_User obj)
{
if (obj == null) throw new ArgumentNullException("obj");
String stmtId = "Sys_User.Update";
if (SqlMapper.Update(stmtId, obj) > 0) {
return true;
}
else return false;
}
public bool UnlockUser(string applicationName, string userName, DateTime LastLockedOutDate)
{
String stmtId = "Sys_User.UnlockUser";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
user.LastLockedOutDate = LastLockedOutDate;
if (SqlMapper.Update(stmtId, user) > 0) {
return true;
}
else return false;
}
public Sys_User GetUser_IsNotLockedOut(string applicationName, string userName)
{
String stmtId = "Sys_User.GetUser_IsNotLockedOut";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
Sys_User result = SqlMapper.QueryForObject<Sys_User>(stmtId, user);
return result;
}
public override void UpdateUser(MembershipUser user)
{
Sys_User u = new Sys_User();
u.Email = user.Email;
u.Comment = user.Comment;
u.IsApproved = user.IsApproved == true ? short.Parse("1") : short.Parse("0");
u.ApplicationName = ApplicationName;
u.Name = user.UserName;
bool result = _userRepository.UpdateForMembershipUser(u);
}
public bool UpdatePassword(string applicationName, string userName, string Password, string passwordKey, DateTime LastPasswordChangedDate)
{
String stmtId = "Sys_User.UpdatePassword";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.Name = userName;
user.Password = Password;
user.PasswordKey = passwordKey;
user.LastPasswordChangedDate = LastPasswordChangedDate;
if (SqlMapper.Update(stmtId, user) > 0) {
return true;
}
else return false;
}
private MembershipUser GetUserFromSys_User(Sys_User user)
{
if (user == null) return null;
MembershipUser u = new MembershipUser(this.Name,
user.Name, user.Id, user.Email, user.PasswordQuestion,
user.Comment, user.IsApproved == 1 ? true : false, user.IsLockedOut == 1 ? true : false, user.CreationDate,
user.LastLoginDate, user.LastActivityDate, user.LastPasswordChangedDate, user.LastLockedOutDate);
return u;
}
public int GetNumberOfUsersOnline(string applicationName, DateTime LastActivityDate)
{
String stmtId = "Sys_User.GetNumberOfUsersOnline";
Sys_User user = new Sys_User();
user.ApplicationName = applicationName;
user.LastActivityDate = LastActivityDate;
int result = SqlMapper.QueryForObject<int>(stmtId, user);
return result;
}