public void Init()
{
_connectionStringSettings = new ConnectionStringSettings(Constants.ConnectionName, Constants.ConnectionString, Constants.ProviderName);
_commonDatabase = new Framework.DataServices.CommonDatabase(
_connectionStringSettings.Name,
_connectionStringSettings.ConnectionString,
_connectionStringSettings.ProviderName);
_userDao = new Framework.Security.DataAccess.SQLSupport.UserDataDao(Constants.Application,
_connectionStringSettings);
_provider = new Framework.Security.Model.SystemProperties();
//Delete all users
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"DELETE FROM " + Framework.Dao.Constants.DefaultTableUsers,
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//Manage user existing
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, Password) VALUES ('" + DataAccess.UserDataDao.ExistingUser + "','" + DataAccess.UserDataDao.OldPassword + "')",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to approve
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, IsApproved) VALUES ('" + DataAccess.UserDataDao.UserToApprove + "'," + "0" + ")",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to Change the password
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, Password) VALUES ('" + DataAccess.UserDataDao.UserToChangePassword + "','" + DataAccess.UserDataDao.OldPassword + "')",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to Change the answer
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, Password, PasswordQuestion, PasswordAnswer) VALUES ('" +
DataAccess.UserDataDao.UserToChangeAnswer + "','" + DataAccess.UserDataDao.OldPassword + "','" +
DataAccess.UserDataDao.OldQuestion + "','" + DataAccess.UserDataDao.OldAnswer + "')",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to desapprove
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, IsApproved) VALUES ('" + DataAccess.UserDataDao.UserToDesapprove + "'," + "1" + ")",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to get the password
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, Password, PasswordAnswer, IsLockedOut) VALUES ('" + DataAccess.UserDataDao.UserToGetPassword + "','"
+ DataAccess.UserDataDao.OldPassword + "','" + DataAccess.UserDataDao.OldAnswer + "', 0)",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to lock
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, IsLockedOut) VALUES ('" + DataAccess.UserDataDao.UserToLock + "', 0)",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to Reset Password
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, Password, PasswordQuestion, PasswordAnswer, IsLockedOut) VALUES ('" +
DataAccess.UserDataDao.UserToResetPassword + "','" + DataAccess.UserDataDao.OldPassword + "','" +
DataAccess.UserDataDao.OldQuestion + "','" + DataAccess.UserDataDao.OldAnswer + "', 0)",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to Set the password
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, Password) VALUES ('" + DataAccess.UserDataDao.UserToSetPassword + "','" + DataAccess.UserDataDao.OldPassword + "')",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to Unlock
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, IsLockedOut) VALUES ('" + DataAccess.UserDataDao.UserToUnLock + "', 1)",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
//User to Validate
_commonDatabase.ExecuteNonQuery(
CommandType.Text,
"INSERT INTO " + Framework.Dao.Constants.DefaultTableUsers +
"(UserName, Password) VALUES ('" + DataAccess.UserDataDao.UserToValidate + "', '" +
DataAccess.UserDataDao.OldPassword + "')",
false,
Framework.Tests.DataServices.CommonDatabase.CurrentUser);
}
