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); }