/// <summary>
/// Retrieves users details from the database
/// </summary>
public NSurveyUserData GetUserById(int userId)
{
NSurveyUserData dataSet = new NSurveyUserData();
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@UserId", userId).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spUserGetDetails", dataSet, new string[] { "Users" }, commandParameters.ToArray());
return(dataSet);
}
/// <summary>
/// Updates users data
/// </summary>
public void UpdateUser(NSurveyUserData updatedUser)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand insertCommand = new SqlCommand("vts_spUserUpdate", connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Int, 4, "UserId"));
insertCommand.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 0xff, "UserName"));
insertCommand.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 0xff, "Password"));
insertCommand.Parameters.Add(new SqlParameter("@PasswordSalt", SqlDbType.VarChar, 0xff, "PasswordSalt"));
insertCommand.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 0xff, "LastName"));
insertCommand.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 0xff, "FirstName"));
insertCommand.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 0xff, "Email"));
DbConnection.db.UpdateDataSet(updatedUser, "Users", insertCommand, new SqlCommand(), insertCommand, UpdateBehavior.Transactional);
}
public void AddUser(NSurveyUserData newUser, string group, string parentGroup)
{
AddUser(newUser);
if (newUser.Users[0].UserId > 0)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand insertCommand = new SqlCommand("vts_spUserAddNewGroup", connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.AddWithValue("@UserId", newUser.Users[0].UserId);
insertCommand.Parameters.AddWithValue("@Group", group);
insertCommand.Parameters.AddWithValue("@ParentGroup", parentGroup);
DbConnection.db.ExecuteNonQuery(insertCommand);
//DbConnection.db.UpdateDataSet(newUser, "Users", insertCommand, new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional);
}
}
/// <summary>
/// Adds a new users to the database
/// </summary>
public void AddUser(NSurveyUserData newUser)
{
SqlConnection connection = new SqlConnection(DbConnection.NewDbConnectionString);
SqlCommand insertCommand = new SqlCommand("vts_spUserAddNew", connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.Add(new SqlParameter("@UserName", SqlDbType.VarChar, 0xff, "UserName"));
insertCommand.Parameters.Add(new SqlParameter("@Password", SqlDbType.VarChar, 0xff, "Password"));
insertCommand.Parameters.Add(new SqlParameter("@PasswordSalt", SqlDbType.VarChar, 0xff, "PasswordSalt"));
insertCommand.Parameters.Add(new SqlParameter("@LastName", SqlDbType.VarChar, 0xff, "LastName"));
insertCommand.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.VarChar, 0xff, "FirstName"));
insertCommand.Parameters.Add(new SqlParameter("@Email", SqlDbType.VarChar, 0xff, "Email"));
insertCommand.Parameters.Add(new SqlParameter("@UserId", SqlDbType.Int, 4, "UserId"));
insertCommand.Parameters["@UserId"].Direction = ParameterDirection.Output;
DbConnection.db.UpdateDataSet(newUser, "Users", insertCommand, new SqlCommand(), new SqlCommand(), UpdateBehavior.Transactional);
}
/// <summary>
/// Retrieves the user if any available
/// </summary>
public NSurveyUserData GetNSurveyUserData(string userName, string password)
{
//SqlParameter[] commandParameters = new SqlParameter[]
//{ new SqlParameter("@UserName", userName),
// new SqlParameter("@Password", password) };
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@UserName", userName).SqlValue);
commandParameters.Add(new SqlParameter("@Password", password).SqlValue);
}
NSurveyUserData dataSet = new NSurveyUserData();
DbConnection.db.LoadDataSet("vts_spUserGetData", dataSet, new string[] { "Users", "UserSecurityRights" }, commandParameters.ToArray());
return(dataSet);
}
private void ImportUsersButton_Click(object sender, System.EventArgs e)
{
Regex re = new Regex(@"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" +
@"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" +
@".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$");
string[] users = ImportUsersTextBox.Text.Split('\n');
for (int i = 0; i < users.Length; i++)
{
string[] user = users[i].Split(',');
if (user.Length > 4 && user[0].Trim().Length > 0 && user[1].Trim().Length > 0)
{
// Check if user already exists in the db
if (new Users().GetUserByIdFromUserName(user[0]) == -1)
{
NSurveyUserData userData = new NSurveyUserData();
NSurveyUserData.UsersRow newUser = userData.Users.NewUsersRow();
newUser.UserName = user[0].Trim();
newUser.Password = new User().EncryptUserPassword(user[1].Trim());
newUser.Email = user[4].Length > 0 && re.IsMatch(user[4].Trim()) ?
user[4].Trim() : null;
newUser.FirstName = user[3].Length > 0 ? user[3].Trim() : null;
newUser.LastName = user[2].Length > 0 ? user[2].Trim() : null;
userData.Users.Rows.Add(newUser);
((INSurveyUserProvider)_userProvider).AddUser(userData);
AddUserSettings(userData.Users[0].UserId);
AddUserRoles(userData.Users[0].UserId);
if (!HasSurveyAccessCheckBox.Checked)
{
AddUserSurveys(userData.Users[0].UserId);
}
}
}
}
MessageLabel.Visible = true;
((PageBase)Page).ShowNormalMessage(MessageLabel, ((PageBase)Page).GetPageResource("UserImportedMessage"));
ImportUsersTextBox.Text = string.Empty;
UserRolesListBox.Items.Clear();
UserSurveysListBox.Items.Clear();
BindSurveyDropDownLists();
}
private void CreateUserButton_Click(object sender, System.EventArgs e)
{
if (ValidateFieldOptions())
{
NSurveyUserData userData = new NSurveyUserData();
NSurveyUserData.UsersRow newUser = userData.Users.NewUsersRow();
if (_userProvider is INSurveyUserProvider)
{
//if (PasswordTextBox.Text.Length == 0)
if (!Regex.IsMatch(PasswordTextBox.Text, @"(?=^.{8,12}$)(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[!@#$%^&*()_+}{":;'?/>.<,])(?!.*\s).*$"))
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("PasswordRequiredMessage"));
return;
}
newUser.UserName = UserNameTextBox.Text;
var sec = new LoginSecurity();
newUser.PasswordSalt = sec.CreateSaltKey(5);
newUser.Password = sec.CreatePasswordHash(PasswordTextBox.Text, newUser.PasswordSalt);
newUser.Email = EmailTextBox.Text;
newUser.FirstName = FirstNameTextBox.Text;
newUser.LastName = LastNameTextBox.Text;
userData.Users.Rows.Add(newUser);
((INSurveyUserProvider)_userProvider).AddUser(userData);
}
if (userData.Users.Rows.Count > 0)
{
UserSettingData userSettings = new UserSettingData();
UserSettingData.UserSettingsRow newUserSettings = userSettings.UserSettings.NewUserSettingsRow();
newUserSettings.UserId = userData.Users[0].UserId;
newUserSettings.IsAdmin = IsAdminCheckBox.Checked;
newUserSettings.GlobalSurveyAccess = HasSurveyAccessCheckBox.Checked;
userSettings.UserSettings.Rows.Add(newUserSettings);
new User().AddUserSettings(userSettings);
}
UINavigator.NavigateToUserManager(((PageBase)Page).getSurveyId(), ((PageBase)Page).MenuIndex);
}
}
public void UpdateUser(NSurveyUserData updatedUser)
{
new User().UpdateUser(updatedUser);
}
public void AddUser(NSurveyUserData newUser)
{
new User().AddUser(newUser);
}
private void ApplyChangesButton_Click(object sender, System.EventArgs e)
{
if (ValidateFieldOptions())
{
if (new Users().IsAdministrator(UserId) && !IsAdminCheckBox.Checked && new Users().GetAdminCount() == 1)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel,((PageBase)Page).GetPageResource("CannotDeleteLastAdminMessage"));
return;
}
if (_userProvider is INSurveyUserProvider)
{
NSurveyUserData userData = new NSurveyUserData();
NSurveyUserData.UsersRow updatedUser = userData.Users.NewUsersRow();
updatedUser.UserId = UserId;
updatedUser.UserName = UserNameTextBox.Text;
// if no password was specified the old one will be kept
if (PasswordTextBox.Text.Length > 0)
{
if (!Regex.IsMatch(PasswordTextBox.Text, @"(?=^.{8,12}$)(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[!@#$%^&*()_+}{":;'?/>.<,])(?!.*\s).*$"))
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("PasswordRequiredMessage"));
return;
}
else
{
var sec = new LoginSecurity();
updatedUser.PasswordSalt = sec.CreateSaltKey(5);
updatedUser.Password = sec.CreatePasswordHash(PasswordTextBox.Text, updatedUser.PasswordSalt);
}
}
else
{
updatedUser.Password = null;
updatedUser.PasswordSalt = null;
}
updatedUser.Email = EmailTextBox.Text;
updatedUser.FirstName = FirstNameTextBox.Text;
updatedUser.LastName = LastNameTextBox.Text;
userData.Users.Rows.Add(updatedUser);
((INSurveyUserProvider)_userProvider).UpdateUser(userData);
}
UserSettingData userSettings = new UserSettingData();
UserSettingData.UserSettingsRow newUserSettings = userSettings.UserSettings.NewUserSettingsRow();
newUserSettings.UserId = UserId;
newUserSettings.IsAdmin = IsAdminCheckBox.Checked;
newUserSettings.GlobalSurveyAccess = HasSurveyAccessCheckBox.Checked;
userSettings.UserSettings.Rows.Add(newUserSettings);
new User().UpdateUserSettings(userSettings);
// Notifiy containers that data has changed
OnOptionChanged();
BindSurveyDropDownLists();
MessageLabel.Visible = true;
((PageBase)Page).ShowNormalMessage(MessageLabel,((PageBase)Page).GetPageResource("UserUpdatedMessage"));
}
}
private void CreateUserButton_Click(object sender, System.EventArgs e)
{
if (ValidateFieldOptions())
{
NSurveyUserData userData = new NSurveyUserData();
NSurveyUserData.UsersRow newUser = userData.Users.NewUsersRow();
if (_userProvider is INSurveyUserProvider)
{
//if (PasswordTextBox.Text.Length == 0)
if (!Regex.IsMatch(PasswordTextBox.Text, @"(?=^.{8,12}$)(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[!@#$%^&*()_+}{":;'?/>.<,])(?!.*\s).*$"))
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel,((PageBase)Page).GetPageResource("PasswordRequiredMessage"));
return;
}
newUser.UserName = UserNameTextBox.Text;
var sec = new LoginSecurity();
newUser.PasswordSalt = sec.CreateSaltKey(5);
newUser.Password = sec.CreatePasswordHash(PasswordTextBox.Text,newUser.PasswordSalt);
newUser.Email = EmailTextBox.Text;
newUser.FirstName = FirstNameTextBox.Text;
newUser.LastName = LastNameTextBox.Text;
userData.Users.Rows.Add(newUser);
((INSurveyUserProvider)_userProvider).AddUser(userData);
}
if (userData.Users.Rows.Count > 0)
{
UserSettingData userSettings = new UserSettingData();
UserSettingData.UserSettingsRow newUserSettings = userSettings.UserSettings.NewUserSettingsRow();
newUserSettings.UserId = userData.Users[0].UserId;
newUserSettings.IsAdmin = IsAdminCheckBox.Checked;
newUserSettings.GlobalSurveyAccess = HasSurveyAccessCheckBox.Checked;
userSettings.UserSettings.Rows.Add(newUserSettings);
new User().AddUserSettings(userSettings);
}
UINavigator.NavigateToUserManager(((PageBase)Page).getSurveyId(),((PageBase)Page).MenuIndex);
}
}
public void AddUser(NSurveyUserData newUser, string group, string parentGroup)
{
new User().AddUser(newUser, group, parentGroup);
}
private void ImportUsersButton_Click(object sender, System.EventArgs e)
{
Regex re = new Regex(@"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" +
@"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" +
@".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$");
string[] users = ImportUsersTextBox.Text.Split('\n');
for (int i=0; i<users.Length;i++)
{
string[] user = users[i].Split(',');
if (user.Length > 4 && user[0].Trim().Length > 0 && user[1].Trim().Length > 0)
{
// Check if user already exists in the db
if (new Users().GetUserByIdFromUserName(user[0]) == -1)
{
NSurveyUserData userData = new NSurveyUserData();
NSurveyUserData.UsersRow newUser = userData.Users.NewUsersRow();
newUser.UserName = user[0].Trim();
newUser.Password = new User().EncryptUserPassword(user[1].Trim());
newUser.Email = user[4].Length > 0 && re.IsMatch(user[4].Trim()) ?
user[4].Trim() : null;
newUser.FirstName = user[3].Length>0 ? user[3].Trim() : null;
newUser.LastName = user[2].Length>0 ? user[2].Trim() : null;
userData.Users.Rows.Add(newUser);
((INSurveyUserProvider)_userProvider).AddUser(userData);
AddUserSettings(userData.Users[0].UserId);
AddUserRoles(userData.Users[0].UserId);
if (!HasSurveyAccessCheckBox.Checked)
{
AddUserSurveys(userData.Users[0].UserId);
}
}
}
}
MessageLabel.Visible = true;
((PageBase)Page).ShowNormalMessage(MessageLabel,((PageBase)Page).GetPageResource("UserImportedMessage"));
ImportUsersTextBox.Text = string.Empty;
UserRolesListBox.Items.Clear();
UserSurveysListBox.Items.Clear();
BindSurveyDropDownLists();
}
/// <summary>
/// UPdate user
/// </summary>
/// <param name="updatedUser">updateuser</param>
public void UpdateUser(NSurveyUserData updatedUser)
{
UserFactory.Create().UpdateUser(updatedUser);
}
public void AddUser(NSurveyUserData newUser)
{
UserFactory.Create().AddUser(newUser);
}
public void UpdateUser(NSurveyUserData updatedUser)
{
new User().UpdateUser(updatedUser);
}
/// <summary>
/// Retrieves users details from the database
/// </summary>
public NSurveyUserData GetUserById(int userId)
{
NSurveyUserData dataSet = new NSurveyUserData();
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@UserId", userId).SqlValue);
}
DbConnection.db.LoadDataSet("vts_spUserGetDetails", dataSet, new string[] { "Users" }, commandParameters.ToArray());
return dataSet;
}
/// <summary>
/// Retrieves the user if any available
/// </summary>
public NSurveyUserData GetNSurveyUserData(string userName, string password)
{
//SqlParameter[] commandParameters = new SqlParameter[]
//{ new SqlParameter("@UserName", userName),
// new SqlParameter("@Password", password) };
ArrayList commandParameters = new ArrayList();
{
commandParameters.Add(new SqlParameter("@UserName", userName).SqlValue);
commandParameters.Add(new SqlParameter("@Password", password).SqlValue);
}
NSurveyUserData dataSet = new NSurveyUserData();
DbConnection.db.LoadDataSet("vts_spUserGetData", dataSet, new string[] { "Users", "UserSecurityRights" }, commandParameters.ToArray());
return dataSet;
}
/// <summary>
/// UPdate user
/// </summary>
/// <param name="updatedUser">updateuser</param>
public void UpdateUser(NSurveyUserData updatedUser)
{
UserFactory.Create().UpdateUser(updatedUser);
}
protected void ImportUsersButton_Click(object sender, EventArgs e)
{
Regex re = new Regex(@"^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}" +
@"\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([a-zA-Z0-9\-]+\" +
@".)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$");
int importCount = 0;
var sec = new LoginSecurity();
if (ImportUserMatrixFile.HasFile)
{
try {
var workPart = SpreadsheetDocument.Open(ImportUserMatrixFile.FileContent, false).WorkbookPart;
var sheetData = workPart.WorksheetParts.First().Worksheet.Elements <SheetData>().First();
foreach (var row in sheetData.Elements <Row>())
{
if (row.RowIndex > 0)
{
var cells = row.Descendants <Cell>().ToList();
if (cells.Count >= 5)
{
string username = ReadExcelCell(cells[0], workPart);
if (new Users().GetUserByIdFromUserName(username) == -1)
{
NSurveyUserData userData = new NSurveyUserData();
NSurveyUserData.UsersRow newUser = userData.Users.NewUsersRow();
newUser.UserName = username.Trim();
string password = "******";
newUser.PasswordSalt = sec.CreateSaltKey(5);
newUser.Password = sec.CreatePasswordHash(password, newUser.PasswordSalt);
string email = ReadExcelCell(cells[1], workPart);
newUser.Email = email.Length > 0 && re.IsMatch(email.Trim()) ?
email.Trim() : null;
if (cells.Count >= 6)
{
newUser.FirstName = ReadExcelCell(cells[5], workPart);
}
if (cells.Count >= 7)
{
newUser.LastName = ReadExcelCell(cells[6], workPart);
}
userData.Users.Rows.Add(newUser);
((INSurveyUserProvider)_userProvider).AddUser(userData);
if (userData.Users[0].UserId > 0)
{
importCount++;
//TODO: add user group
AddUserSettings(userData.Users[0].UserId);
AddUserRoles(userData.Users[0].UserId);
new Survey().AssignUserToSurvey(int.Parse(ReadExcelCell(cells[2], workPart)), userData.Users[0].UserId);
}
}
}
}
}
}
catch (Exception ex) {
((PageBase)Page).ShowErrorMessage(MessageLabel, ex.Message);
}
}
string[] users = "".Split('\n'); //ImportUsersTextBox.Text.Split('\n');
//for (int i = 0; i < users.Length; i++)
//{
// string[] user = users[i].Split(',');
// if (user.Length > 4 && user[0].Trim().Length > 0 && user[1].Trim().Length > 0)
// {
// // Check if user already exists in the db
// if (new Users().GetUserByIdFromUserName(user[0]) == -1)
// {
// NSurveyUserData userData = new NSurveyUserData();
// NSurveyUserData.UsersRow newUser = userData.Users.NewUsersRow();
// newUser.UserName = user[0].Trim();
// string password = user[1].Trim();
// newUser.PasswordSalt =sec.CreateSaltKey(5);
// newUser.Password = sec.CreatePasswordHash(password, newUser.PasswordSalt);
// newUser.Email = user[4].Length > 0 && re.IsMatch(user[4].Trim()) ?
// user[4].Trim() : null;
// newUser.FirstName = user[3].Length > 0 ? user[3].Trim() : null;
// newUser.LastName = user[2].Length > 0 ? user[2].Trim() : null;
// userData.Users.Rows.Add(newUser);
// ((INSurveyUserProvider)_userProvider).AddUser(userData);
// if (userData.Users[0].UserId > 0) importCount++;
// AddUserSettings(userData.Users[0].UserId);
// AddUserRoles(userData.Users[0].UserId);
// //if (!HasSurveyAccessCheckBox.Checked)
// //{
// // AddUserSurveys(userData.Users[0].UserId);
// //}
// }
// }
//}
MessageLabel.Visible = true;
if (importCount > 0)
{
((PageBase)Page).ShowNormalMessage(MessageLabel, ((PageBase)Page).GetPageResource("UserImportedMessage"));
}
else
{
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("NoUserImportedMessage"));
}
BindSurveyDropDownLists();
}
public void AddUser(NSurveyUserData newUser, string group, string parentGroup)
{
UserFactory.Create().AddUser(newUser, group, parentGroup);
}
private void ApplyChangesButton_Click(object sender, System.EventArgs e)
{
if (ValidateFieldOptions())
{
if (new Users().IsAdministrator(UserId) && !IsAdminCheckBox.Checked && new Users().GetAdminCount() == 1)
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("CannotDeleteLastAdminMessage"));
return;
}
if (_userProvider is INSurveyUserProvider)
{
NSurveyUserData userData = new NSurveyUserData();
NSurveyUserData.UsersRow updatedUser = userData.Users.NewUsersRow();
updatedUser.UserId = UserId;
updatedUser.UserName = UserNameTextBox.Text;
// if no password was specified the old one will be kept
if (PasswordTextBox.Text.Length > 0)
{
if (!Regex.IsMatch(PasswordTextBox.Text, @"(?=^.{8,12}$)(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[!@#$%^&*()_+}{":;'?/>.<,])(?!.*\s).*$"))
{
MessageLabel.Visible = true;
((PageBase)Page).ShowErrorMessage(MessageLabel, ((PageBase)Page).GetPageResource("PasswordRequiredMessage"));
return;
}
else
{
var sec = new LoginSecurity();
updatedUser.PasswordSalt = sec.CreateSaltKey(5);
updatedUser.Password = sec.CreatePasswordHash(PasswordTextBox.Text, updatedUser.PasswordSalt);
}
}
else
{
updatedUser.Password = null;
updatedUser.PasswordSalt = null;
}
updatedUser.Email = EmailTextBox.Text;
updatedUser.FirstName = FirstNameTextBox.Text;
updatedUser.LastName = LastNameTextBox.Text;
userData.Users.Rows.Add(updatedUser);
((INSurveyUserProvider)_userProvider).UpdateUser(userData);
}
UserSettingData userSettings = new UserSettingData();
UserSettingData.UserSettingsRow newUserSettings = userSettings.UserSettings.NewUserSettingsRow();
newUserSettings.UserId = UserId;
newUserSettings.IsAdmin = IsAdminCheckBox.Checked;
newUserSettings.GlobalSurveyAccess = HasSurveyAccessCheckBox.Checked;
userSettings.UserSettings.Rows.Add(newUserSettings);
new User().UpdateUserSettings(userSettings);
// Notifiy containers that data has changed
OnOptionChanged();
BindSurveyDropDownLists();
MessageLabel.Visible = true;
((PageBase)Page).ShowNormalMessage(MessageLabel, ((PageBase)Page).GetPageResource("UserUpdatedMessage"));
}
}
public void AddUser(NSurveyUserData newUser)
{
UserFactory.Create().AddUser(newUser);
}
public void AddUser(NSurveyUserData newUser)
{
new User().AddUser(newUser);
}
