private void apply_Click(object sender, EventArgs e) { if (user.Text != "" && password.Text != "") { AccountList addUser = new AccountList(); string getMD5 = MD5code(password.Text); string level = ""; if (account_admin.Checked == true) { level = "admin"; } else if (account_designer.Checked == true) { level = "design"; } else if (account_viewer.Checked == true) { level = "view"; } addUser.name = user.Text; addUser.pass = getMD5; addUser.level = level; option_account lForm1 = (option_account)this.Owner; lForm1.getUser = addUser; this.Close(); } }
private void CMD_del_Click(object sender, EventArgs e) { if (listBox1.Items.Count > 1) { int selectItem = listBox1.SelectedIndex; AccountList tar = (AccountList)memoryData.accountListTemp[selectItem]; try { database SQLstr = (database)memoryData.database[0]; MySqlConnection conn = new MySqlConnection(MYSQL_str); MySqlCommand command = conn.CreateCommand(); conn.Open(); command.CommandText = @"delete FROM nico_db.user_data where no='" + tar.no + "'"; command.ExecuteNonQuery(); conn.Close(); listBox1.SelectedIndex = -1; listBox1.Items.RemoveAt(selectItem); memoryData.accountListTemp.RemoveAt(selectItem); listBox1.SelectedIndex = 0; } catch { } } else { //MessageBox.Show(""); } }
private void cancel_Click(object sender, EventArgs e) { AccountList clearUser = new AccountList(); option_account lForm1 = (option_account)this.Owner; lForm1.getUser = clearUser; this.Close(); }
private void CMD_add_Click(object sender, EventArgs e) { getUser.name = null; user_check2_add le = new user_check2_add(); le.Owner = this; le.ShowDialog(); if (getUser.name != null) { int findtar = listBox1.FindString(getUser.name); if (findtar != -1) { MessageBox.Show("This name already in use!"); } else { database SQLstr = (database)memoryData.database[0]; MySqlConnection conn = new MySqlConnection(MYSQL_str); MySqlCommand command = conn.CreateCommand(); conn.Open(); command.CommandText = @"Insert into user_data(name,pass,level) values('" + getUser.name + "','" + getUser.pass + "','" + getUser.level + "')"; command.ExecuteNonQuery(); conn.Close(); int chkno = 0; string chkname = ""; string chkpass = ""; string chklevel = ""; conn.Open(); command.CommandText = "SELECT * FROM nico_db.user_data where name = '" + getUser.name + "'"; MySqlDataReader reader; reader = command.ExecuteReader(); reader.Read(); chkno = (int)reader["no"]; chkname = (String)reader["name"]; chkpass = (String)reader["pass"]; chklevel = (String)reader["level"]; conn.Close(); AccountList add = new AccountList(); add.no = chkno; add.name = chkname; add.pass = chkpass; add.level = chklevel; memoryData.accountListTemp.Add(add); listBox1.Items.Add(chkname); } } }
private void CMD_edit_Click(object sender, EventArgs e) { int selectItem = listBox1.SelectedIndex; AccountList tar = (AccountList)memoryData.accountListTemp[selectItem]; string editName = user.Text; string editPass = MD5code(password.Text); string editLevel = ""; if (account_admin.Checked == true) { editLevel = "admin"; } else if (account_designer.Checked == true) { editLevel = "design"; } else if (account_viewer.Checked == true) { editLevel = "view"; } try { database SQLstr = (database)memoryData.database[0]; MySqlConnection conn = new MySqlConnection(MYSQL_str); MySqlCommand command = conn.CreateCommand(); conn.Open(); command.CommandText = @"update nico_db.user_data set name ='" + editName + "',pass = '******',level = '" + editLevel + "' where no = '" + tar.no + "'"; command.ExecuteNonQuery(); conn.Close(); tar.name = editName; tar.pass = editPass; tar.level = editLevel; memoryData.accountListTemp[selectItem] = tar; listBox1.SelectedIndex = -1; listBox1.Items[selectItem] = editName; listBox1.SelectedIndex = selectItem; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void option_account_Load(object sender, EventArgs e) { database SQLstr = (database)memoryData.database[0]; MySqlConnection conn = new MySqlConnection(MYSQL_str); MySqlCommand command = conn.CreateCommand(); int number = 0; string name = ""; string password = ""; string level = ""; try { conn.Open(); command.CommandText = "SELECT * FROM nico_db.user_data"; MySqlDataReader reader; reader = command.ExecuteReader(); memoryData.accountListTemp.Clear(); while (reader.Read()) { number = (int)reader["no"]; name = (String)reader["name"]; password = (String)reader["pass"]; level = (String)reader["level"]; AccountList add = new AccountList(); add.no = number; add.name = name; add.pass = password; add.level = level; memoryData.accountListTemp.Add(add); listBox1.Items.Add(name); } conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { if (listBox1.SelectedIndex != -1) { selectName = listBox1.SelectedItem.ToString(); int selectItem = listBox1.SelectedIndex; AccountList tar = (AccountList)memoryData.accountListTemp[selectItem]; user.Text = tar.name; if (tar.level == "admin") { account_admin.Checked = true; } else if (tar.level == "design") { account_designer.Checked = true; } else if (tar.level == "view") { account_viewer.Checked = true; } } }