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