private bool AddToPasswordHistory(string userName, string newPassword, int historyCount)
{
using (DbCommand command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
object result;
InitializeGetHistoryCount(command, userName);
result = DatabaseProvider.ExecuteScalar(command);
if (result != null && Convert.ToInt32(result) >= historyCount)
{
int count = Convert.ToInt32(result) - historyCount;
int itemCount = 0;
InitializeGetUserPasswordHistory(command, userName);
using (var reader = DatabaseProvider.ExecuteReader(command))
{
while (reader.Read())
{
if (itemCount <= count)
{
using (DbCommand delCommand = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeDeletePasswordHistory(delCommand, reader.GetColumnValue <long>("Id"));
DatabaseProvider.ExecuteNonQuery(delCommand);
}
}
itemCount++;
}
}
}
InitializeAddToPasswordHistory(command, userName, newPassword);
return(DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
public bool AddUserCardReader(string userName, string friendlyName)
{
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeAddUserCardReaderCommand(command, userName, friendlyName, string.Empty, null, true);
return(DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
public bool AddUser(string userName, string friendlyName, SecureString password, DateTime?expireDate, bool useCardReader)
{
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeAddUserCardReaderCommand(command, userName, friendlyName, GetHashedPassword(password), expireDate, useCardReader);
return(DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
public void Reset(DateRange range)
{
using (DbCommand command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeResetCommand(command, range);
DatabaseProvider.ExecuteNonQuery(command);
}
}
public void SetInstanceForwarded(string sopInstanceUID, DateTime forwardDate, DateTime?expireDate)
{
using (DbCommand command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeInsertCommand(command, sopInstanceUID, forwardDate, expireDate);
DatabaseProvider.ExecuteNonQuery(command);
}
}
public static bool DeleteCategory(int categoryID)
{
bool returnValue;
DatabaseProvider myDatabase = new DatabaseProvider();
myDatabase.AddinParameters("@CategoryID", DbType.Int32, categoryID);
returnValue = Convert.ToBoolean(myDatabase.ExecuteNonQuery("DELETE FROM Categories WHERE CategoryID = @CategoryID", CommandType.Text));
return(returnValue);
}
public static bool UpdateCategory(int categoryID, string categoryName, string description)
{
bool returnValue;
DatabaseProvider myDataBase = new DatabaseProvider();
myDataBase.AddinParameters("@CategoryID", DbType.Int32, categoryID);
myDataBase.AddinParameters("@CategoryName", DbType.String, categoryName);
myDataBase.AddinParameters("@Description", DbType.String, description);
returnValue = Convert.ToBoolean(myDataBase.ExecuteNonQuery("Update Categories SET CategoryName = @CategoryName, Description = @Description WHERE CategoryID = @CategoryID", CommandType.Text));
return(returnValue);
}
public virtual bool RemoveUser
(
string userName
)
{
userName = FromInputUserName(userName);
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeRemoveUserCommand(command, userName);
return(DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
//public virtual bool IsUserValid(string userName, SecureString password)
//{
// DbCommand command;
// object result;
// command = DatabaseProvider.DbProviderFactory.CreateCommand();
// InitializeIsAeValidCommand(command, userName, GetHashedPassword(password));
// result = DatabaseProvider.ExecuteScalar(command);
// return ReturnFromScalarResult(result);
//}
//public virtual bool AddUser
//(
// string userName,
// SecureString password,
// bool isAdmin
//)
//{
// DbCommand insertCommand;
// insertCommand = DatabaseProvider.DbProviderFactory.CreateCommand();
// InitializeAddAeCommand(insertCommand, userName, GetHashedPassword(password), isAdmin);
// return (DatabaseProvider.ExecuteNonQuery(insertCommand) > 0);
//}
public virtual bool RemoveUser
(
string userName
)
{
DbCommand command;
command = DatabaseProvider.DbProviderFactory.CreateCommand();
InitializeRemoveAeCommand(command, userName);
return(DatabaseProvider.ExecuteNonQuery(command) > 0);
}
public virtual bool SetUserPassword
(
string userName,
SecureString newPassword
)
{
userName = FromInputUserName(userName);
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeSetUserPasswordCommand(command, userName, GetHashedPassword(newPassword));
return(DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
public virtual bool AddUser
(
string userName,
SecureString password,
bool isAdmin
)
{
userName = FromInputUserName(userName);
using (var insertCommand = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeAddUserCommand(insertCommand, userName, GetHashedPassword(password), isAdmin);
return(DatabaseProvider.ExecuteNonQuery(insertCommand) > 0);
}
}
public bool AddUser(string userName, string friendlyName, SecureString password, DateTime? expireDate, string userType)
{
Exception _e = null;
try
{
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
var resolvedName = UserNameResolver.ToDb(userName, userType);
InitializeGenericAddUserCommandExt(command, resolvedName.Item1, resolvedName.Item2, friendlyName, GetHashedPassword(password), expireDate, resolvedName.Item3);
return (DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
catch (Exception e)
{
//might fail for older schema databases, we fall through for backward compatibility
_e = e;
}
try
{
using (var command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeGenericAddUserCommand(command, userName, friendlyName, GetHashedPassword(password), expireDate, string.IsNullOrEmpty(userType) ? UserType.Classic : userType);
return (DatabaseProvider.ExecuteNonQuery(command) > 0);
}
}
catch (Exception e)
{
//might fail for older schema databases, we fall through for backward compatibility
_e = e;
}
if (string.IsNullOrEmpty(userType) || userType == UserType.Classic)
{
return base.AddUser(userName, friendlyName, password, expireDate, false);
}
else if (userType == UserType.SmartCard)
{
return base.AddUser(userName, friendlyName, password, expireDate, true);
}
else
{
throw _e;
}
}
public int AddOrUpdateUserProfile(int iUserId, string sUserName, string sFullName, string sPosition, string sPhone)
{
// Read data with a SQL statement that accepts one parameter prefixed with @.
string sqlStatement = "DELETE FROM UserProfile WHERE UserId=@UserId " + Environment.NewLine;
sqlStatement += "INSERT INTO UserProfile(UserId,UserName,FullName,Position,Phone) values(@UserId,@UserName,@FullName,@Position,@Phone)";
int result = -1;
// Create a suitable command type and add the required parameter.
using (DbCommand sqlCmd = DatabaseProvider.GetSqlStringCommand(sqlStatement))
{
DatabaseProvider.AddInParameter(sqlCmd, "UserId", DbType.Int32, iUserId);
DatabaseProvider.AddInParameter(sqlCmd, "UserName", DbType.String, sUserName);
DatabaseProvider.AddInParameter(sqlCmd, "FullName", DbType.String, sFullName);
DatabaseProvider.AddInParameter(sqlCmd, "Position", DbType.String, sPosition);
DatabaseProvider.AddInParameter(sqlCmd, "Phone", DbType.String, sPhone);
result = DatabaseProvider.ExecuteNonQuery(sqlCmd);
}
return(result);
}
public virtual bool SetUserPassword(string userName, SecureString newPassword, DateTime?expireDate, int historyCount)
{
userName = FromInputUserName(userName);
string oldPassword = string.Empty;
bool ret;
if (historyCount > 0)
{
using (DbCommand c = DatabaseProvider.DbProviderFactory.CreateCommand())
{
object result;
InitializeGetUserPassword(c, userName);
result = DatabaseProvider.ExecuteScalar(c);
oldPassword = result != null?result.ToString() : string.Empty;
}
}
if (expireDate.HasValue)
{
using (DbCommand command = DatabaseProvider.DbProviderFactory.CreateCommand())
{
InitializeSetUserPasswordExpired(command, userName, GetHashedPassword(newPassword), expireDate);
ret = DatabaseProvider.ExecuteNonQuery(command) > 0;
}
}
else
{
ret = SetUserPassword(userName, newPassword);
}
if (ret && historyCount > 0 && !string.IsNullOrEmpty(oldPassword))
{
AddToPasswordHistory(userName, oldPassword, historyCount);
}
return(ret);
}
