public override bool ChangePassword(string username, string oldPwd, string newPwd)
{
if (!(ValidateUser(username, oldPwd)))
{
return(false);
}
ValidatePasswordEventArgs args = new ValidatePasswordEventArgs(username, newPwd, false);
OnValidatingPassword(args);
if (args.Cancel)
{
if (args.FailureInformation != null)
{
throw args.FailureInformation;
}
else
{
throw new MembershipPasswordException("Change of password canceled due to new password validation failure.");
}
}
using (SqlStatement sql = CreateSqlStatement(MembershipProviderSqlStatement.ChangePassword))
{
sql.AssignParameter("Password", EncodePassword(newPwd));
sql.AssignParameter("UserName", username);
return(sql.ExecuteNonQuery() == 1);
}
}
public override void AddUsersToRoles(string[] usernames, string[] rolenames)
{
foreach (string rolename in rolenames)
{
if (!(RoleExists(rolename)))
{
throw new ProviderException(String.Format("Role name \'{0}\' not found.", rolename));
}
}
foreach (string username in usernames)
{
if (username.Contains(","))
{
throw new ArgumentException("User names cannot contain commas.");
}
foreach (string rolename in rolenames)
{
if (IsUserInRole(username, rolename))
{
throw new ProviderException(String.Format("User \'{0}\' is already in role \'{1}\'.", username, rolename));
}
}
}
using (SqlStatement sql = CreateSqlStatement(RoleProviderSqlStatement.AddUserToRole))
foreach (string username in usernames)
{
ForgetUserRoles(username);
foreach (string rolename in rolenames)
{
sql.AssignParameter("UserName", username);
sql.AssignParameter("RoleName", rolename);
sql.ExecuteNonQuery();
}
}
}
public override void RemoveUsersFromRoles(string[] usernames, string[] rolenames)
{
foreach (string rolename in rolenames)
{
if (!(RoleExists(rolename)))
{
throw new ProviderException(String.Format("Role \'{0}\' not found.", rolename));
}
}
foreach (string username in usernames)
{
foreach (string rolename in rolenames)
{
if (!(IsUserInRole(username, rolename)))
{
throw new ProviderException(String.Format("User \'{0}\' is not in role \'{1}\'.", username, rolename));
}
}
}
foreach (string username in usernames)
{
ForgetUserRoles(username);
foreach (string rolename in rolenames)
{
using (SqlStatement sql = CreateSqlStatement(RoleProviderSqlStatement.RemoveUserFromRole))
{
sql.AssignParameter("UserName", username);
sql.AssignParameter("RoleName", rolename);
sql.ExecuteNonQuery();
}
}
}
}
public override void Execute(NinServiceContext context)
{
using (var sql = new SqlStatement(Sql, Config.Settings.ConnectionString))
{
sql.ExecuteNonQuery();
}
}
public override bool DeleteUser(string username, bool deleteAllRelatedData)
{
using (SqlStatement sql = CreateSqlStatement(MembershipProviderSqlStatement.DeleteUser))
{
sql.AssignParameter("UserName", username);
return(sql.ExecuteNonQuery() > 0);
}
}
public static void Wipe()
{
const string sql = "DELETE FROM TaskQueue";
using (var cmd = new SqlStatement(sql, Config.Settings.ConnectionString))
{
cmd.ExecuteNonQuery();
}
}
public override void UpdateUser(MembershipUser user)
{
using (SqlStatement sql = CreateSqlStatement(MembershipProviderSqlStatement.UpdateUser))
{
sql.AssignParameter("Email", user.Email);
sql.AssignParameter("UserName", user.UserName);
sql.ExecuteNonQuery();
}
}
private static void SaveToErrorQueue(int taskId, Exception caught)
{
const string sql =
"INSERT INTO dbo.TaskQueueError SELECT TaskQueueId, Action, Payload, @exception, Created, GETDATE() FROM dbo.TaskQueue WHERE TaskQueueId = @taskId";
using (var cmd = new SqlStatement(sql, Config.Settings.ConnectionString))
{
cmd.AddParameter("@taskId", taskId);
cmd.AddParameter("@exception", caught.ToString());
cmd.ExecuteNonQuery();
}
}
protected override void Flush(LogEntry logEntry)
{
using (var sql = new SqlStatement(
"INSERT INTO SysLog (Created, Priority, Tag, Msg) VALUES (@Created, @Priority, @tag, @msg)",
Config.Settings.ConnectionString))
{
sql.AddParameter("@Created", logEntry.Created);
sql.AddParameter("@Priority", logEntry.Priority);
sql.AddParameter("@Tag", logEntry.Tag);
sql.AddParameter("@Msg", logEntry.Message);
sql.ExecuteNonQuery();
}
}
private static void DeleteTask(int taskId)
{
const string sql = "DELETE FROM TaskQueue WHERE TaskQueueId=@Id";
using (var cmd = new SqlStatement(sql, Config.Settings.ConnectionString))
{
cmd.AddParameter("@id", taskId);
var r = cmd.ExecuteNonQuery();
if (r <= 0)
{
throw new Exception("Failed to remove task with id '" + taskId + "'.");
}
}
}
public override string ResetPassword(string username, string answer)
{
if (!(EnablePasswordReset))
{
throw new NotSupportedException("Password reset is not enabled.");
}
string newPassword = Membership.GeneratePassword(this._newPasswordLength, MinRequiredNonAlphanumericCharacters);
ValidatePasswordEventArgs args = new ValidatePasswordEventArgs(username, newPassword, false);
OnValidatingPassword(args);
if (args.Cancel)
{
if (args.FailureInformation != null)
{
throw args.FailureInformation;
}
else
{
throw new MembershipPasswordException("Reset password canceled due to password validation failure.");
}
}
string passwordAnswer = String.Empty;
using (SqlStatement sql = CreateSqlStatement(MembershipProviderSqlStatement.GetPassword))
{
sql.AssignParameter("UserName", username);
if (sql.Read())
{
}
else
{
throw new MembershipPasswordException("User is not found.");
}
}
using (SqlStatement sql = CreateSqlStatement(MembershipProviderSqlStatement.ResetPassword))
{
sql.AssignParameter("Password", EncodePassword(newPassword));
sql.AssignParameter("UserName", username);
if (sql.ExecuteNonQuery() > 0)
{
return(newPassword);
}
else
{
throw new MembershipPasswordException("User is not found or locked out. Password has not been reset.");
}
}
}
public override void CreateRole(string rolename)
{
if (rolename.Contains(","))
{
throw new ArgumentException("Role names cannot contain commas.");
}
if (RoleExists(rolename))
{
throw new ProviderException("Role already exists.");
}
using (SqlStatement sql = CreateSqlStatement(RoleProviderSqlStatement.CreateRole))
{
sql.AssignParameter("RoleName", rolename);
sql.ExecuteNonQuery();
}
}
public static void Remove(Task task, long elapsedMilliseconds = 0)
{
const string sql =
"INSERT INTO TaskLog (Action, Payload, Created, ElapsedMilliSeconds) VALUES (@action, @payload, @created, @elapsedMilliseconds)";
using (var cmd = new SqlStatement(sql, Config.Settings.ConnectionString))
{
cmd.AddParameter("@action", task.Type());
cmd.AddParameter("@payload", task.Serialize());
cmd.AddParameter("@created", task.Created);
cmd.AddParameter("@elapsedMilliseconds", elapsedMilliseconds);
cmd.ExecuteNonQuery();
}
var taskId = task.Id;
DeleteTask(taskId);
}
public virtual bool SaveFile(HttpContext context)
{
if (context.Request.Files.Count != 1)
{
return(false);
}
HttpPostedFile file = context.Request.Files[0];
try
{
using (SqlStatement updateBlob = BlobFactory.CreateBlobUpdateStatement())
return(updateBlob.ExecuteNonQuery() == 1);
}
catch (Exception err)
{
Error = err.Message;
return(false);
}
}
public virtual bool SaveFile(HttpContext context)
{
if (context.Request.Files.Count != 1)
{
return(false);
}
try
{
if ((BlobHandlerInfo.Current != null) && BlobHandlerInfo.Current.ProcessUploadViaBusinessRule())
{
return(true);
}
using (SqlStatement updateBlob = BlobFactory.CreateBlobUpdateStatement())
return(updateBlob.ExecuteNonQuery() == 1);
}
catch (Exception err)
{
Error = err.Message;
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 && !(String.IsNullOrEmpty(GetUserNameByEmail(email))))
{
status = MembershipCreateStatus.DuplicateEmail;
return(null);
}
if (GetUser(username, false) != null)
{
status = MembershipCreateStatus.DuplicateUserName;
}
else
{
DateTime creationDate = DateTime.Now;
using (SqlStatement sql = CreateSqlStatement(MembershipProviderSqlStatement.CreateUser))
{
sql.AssignParameter("UserName", username);
sql.AssignParameter("Password", EncodePassword(password));
sql.AssignParameter("Email", email);
if (sql.ExecuteNonQuery() > 0)
{
status = MembershipCreateStatus.Success;
return(GetUser(username, false));
}
else
{
status = MembershipCreateStatus.UserRejected;
}
}
}
return(null);
}
public override bool DeleteRole(string rolename, bool throwOnPopulatedRole)
{
if (!(RoleExists(rolename)))
{
throw new ProviderException("Role does not exist.");
}
if (throwOnPopulatedRole && (GetUsersInRole(rolename).Length > 0))
{
throw new ProviderException("Cannot delete a pouplated role.");
}
using (SqlStatement sql = CreateSqlStatement(RoleProviderSqlStatement.DeleteRole))
{
using (SqlStatement sql2 = CreateSqlStatement(RoleProviderSqlStatement.DeleteRoleUsers))
{
sql2.AssignParameter("RoleName", rolename);
sql2.ExecuteNonQuery();
}
sql.AssignParameter("RoleName", rolename);
sql.ExecuteNonQuery();
}
return(true);
}
public override void Execute()
{
using (var q = new SqlStatement(sql, Config.Settings.ConnectionString))
q.ExecuteNonQuery();
Log.i("DB", "Executed SQL successfully.");
}
