void ButtonChangePasswordClick(object sender, EventArgs e) { ComboUserItem item = (ComboUserItem)comboBoxUsers.SelectedItem; if (item == null) { return; } // Password Strength: http://xkcd.com/936/ InputBoxValidation validation = delegate(string val) { if (val.Length < 8) { return("Password must contain at least 8 characters."); } return(""); }; string password = ""; if (DialogResult.OK == InputBox.Show("Change Password", "Enter a new password (min. 8 characters):", ref password, validation)) { // change password UserDatabase.SetPassword(item.UserId, password); } }
void ComboBoxUsersSelectedIndexChanged(object sender, EventArgs e) { // Apply values to previously selected user. // Show values for current user. ComboUserItem item = (ComboUserItem)comboBoxUsers.SelectedItem; if (item == null) { return; } using (SQLiteDataReader reader = Database.Instance.ExecuteReader("SELECT id, username, fullname, home_list_id, use_comicrack_progress FROM user JOIN user_settings ON user.id=user_settings.user_id WHERE user.id = " + item.UserId + " LIMIT 1;")) { if (reader.Read()) { textBoxUsername.Text = reader.GetString(1); if (!reader.IsDBNull(2)) { textBoxFullName.Text = reader.GetString(2); } else { textBoxFullName.Text = ""; } Guid listId; if (!reader.IsDBNull(3)) { try { listId = new Guid(reader.GetString(3)); // Check if list still exists, if not, select Library and update database var list = Program.Database.ComicLists.FindItem(listId); if (list == null) { listId = libraryGuid; } } catch (Exception ex) { // invalid Guid format or reader.GetString(3) failed, just ignore and use main library list... Console.WriteLine(ex.ToString()); listId = libraryGuid; } } else { listId = libraryGuid; } checkBoxUseProgressFromComicRack.Checked = (reader.GetInt32(4) != 0); comboTreeHomeList.SelectedNode = comboTreeHomeList.Nodes.FirstOrDefault((ComboTreeNode ctn) => ctn.Tag.Equals(listId)); } } }
void CheckBoxUseProgressFromComicRackCheckedChanged(object sender, EventArgs e) { ComboUserItem item = (ComboUserItem)comboBoxUsers.SelectedItem; if (item == null) { return; } Database.Instance.ExecuteNonQuery("UPDATE user_settings SET use_comicrack_progress = " + (checkBoxUseProgressFromComicRack.Checked ? "1" : "0") + " WHERE user_id=" + item.UserId + ";"); }
void TextBoxFullNameValidated(object sender, EventArgs e) { ComboUserItem item = (ComboUserItem)comboBoxUsers.SelectedItem; if (item == null) { return; } UserDatabase.SetFullName(item.UserId, ((System.Windows.Forms.TextBox)sender).Text); }
void ComboTreeHomeListSelectedNodeChanged(object sender, EventArgs e) { ComboUserItem item = (ComboUserItem)comboBoxUsers.SelectedItem; if (item == null) { return; } if (comboTreeHomeList.SelectedNode != null) { string listId = comboTreeHomeList.SelectedNode.Tag.ToString(); Database.Instance.ExecuteNonQuery("UPDATE user_settings SET home_list_id='" + listId + "' WHERE user_id=" + item.UserId + ";"); } }
void ButtonRemoveUserClick(object sender, System.EventArgs e) { ComboUserItem item = (ComboUserItem)comboBoxUsers.SelectedItem; if (item == null) { return; } if (DialogResult.Yes == System.Windows.Forms.MessageBox.Show("Are you sure you want to remove user '" + item.Text + "'?", "Remove user", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)) { // remove user UserDatabase.RemoveUser(item.UserId); System.Windows.Forms.MessageBox.Show("User removed.", "Remove User", MessageBoxButtons.OK, MessageBoxIcon.Information); FillComboUsers(); } }