public int GetUniqueRuleID(UniqueRule ruleToInsert, int charID) { int ruleID = 0; connection = dBControl.getConnection(); MySqlDataReader dataReader; connection.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT unique_rule_id FROM Unique_Rules WHERE unique_rule_text = @ruleText AND " + "character_id = @charID", connection)) { cmd.Parameters.AddWithValue("@ruleText", ruleToInsert.RuleText); cmd.Parameters.AddWithValue("@charID", charID); dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { ruleID = dataReader.GetInt16(0); } connection.Close(); } return(ruleID); }
private void EditRuleButton_Click(object sender, EventArgs e) { selectedRule = (UniqueRule)uniqueRuleBox.SelectedItem; ruleTextBox.Visible = true; saveEditRuleButton.Visible = true; ruleTextBox.Text = selectedRule.RuleText; }
public List <UniqueRule> GetUniqueRules(int charid) { Console.WriteLine("Hello From " + Thread.CurrentThread.Name); List <UniqueRule> uniqueRules = new List <UniqueRule>(); MySqlConnection uniqueRulesConnection; MySqlDataReader dataReader; uniqueRulesConnection = dBControl.getConnection(); uniqueRulesConnection.Open(); using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM Unique_Rules WHERE character_id = @charID", uniqueRulesConnection)) { cmd.Parameters.AddWithValue("@charID", charid); dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { UniqueRule newRule = new UniqueRule(dataReader.GetInt16(0), dataReader.GetString(1)); uniqueRules.Add(newRule); } } uniqueRulesConnection.Close(); Console.WriteLine("Goodbye From " + Thread.CurrentThread.Name); return(uniqueRules); }
private void EditUniqueRuleButton_Click(object sender, EventArgs e) { uniqueRuleTextBox.Visible = true; saveNewRule.Visible = false; saveEditedRule.Visible = true; UniqueRule editRule = (UniqueRule)uniqueRuleBox.SelectedItem; uniqueRuleTextBox.Text = editRule.RuleText; }
private void DeleteUniqueRuleButton_Click(object sender, EventArgs e) { UniqueRule deleteRule = (UniqueRule)uniqueRuleBox.SelectedItem; newCharacter.RemoveUniqueRule(deleteRule); uniqueRuleBox.DataSource = null; uniqueRuleBox.DataSource = newCharacter.UniqueRules; uniqueRuleBox.DisplayMember = "ruleText"; }
private void DeleteUniqueRuleButton_Click(object sender, EventArgs e) { UniqueRule ruleToDelete = (UniqueRule)uniqueRuleBox.SelectedItem; selectedCharacter.RemoveUniqueRule(ruleToDelete); charController.RemoveUniqueRule(ruleToDelete); uniqueRuleBox.DataSource = null; uniqueRuleBox.DataSource = selectedCharacter.UniqueRules; uniqueRuleBox.DisplayMember = "RuleText"; }
private void SaveEditedRule_Click(object sender, EventArgs e) { UniqueRule editRule = (UniqueRule)uniqueRuleBox.SelectedItem; editRule.RuleText = uniqueRuleTextBox.Text; uniqueRuleTextBox.Visible = false; saveNewRule.Visible = false; saveEditedRule.Visible = false; uniqueRuleBox.DataSource = null; uniqueRuleBox.DataSource = newCharacter.UniqueRules; uniqueRuleBox.DisplayMember = "ruleText"; }
public void RemoveUniqueRule(UniqueRule ruleToRemove) { connection = dBControl.getConnection(); connection.Open(); using (MySqlCommand cmd = new MySqlCommand("DELETE FROM Unique_Rules WHERE unique_rule_id = @ruleID", connection)) { cmd.Parameters.AddWithValue("@ruleID", ruleToRemove.UniqueRuleID); int rows = cmd.ExecuteNonQuery(); connection.Close(); } }
public void UpdateUniqueRules(UniqueRule ruleToUpdate) { connection = dBControl.getConnection(); connection.Open(); using (MySqlCommand cmd = new MySqlCommand("UPDATE Unique_Rules SET unique_rule_text = @ruleText WHERE unique_rule_id = @ruleID", connection)) { cmd.Parameters.AddWithValue("@ruleText", ruleToUpdate.RuleText); cmd.Parameters.AddWithValue("@ruleID", ruleToUpdate.UniqueRuleID); int rows = cmd.ExecuteNonQuery(); connection.Close(); } }
private void SaveNewRule_Click(object sender, EventArgs e) { UniqueRule newRule = new UniqueRule { RuleText = uniqueRuleTextBox.Text }; newCharacter.AddUniqueRule(newRule); uniqueRuleTextBox.Visible = false; saveNewRule.Visible = false; saveEditedRule.Visible = false; uniqueRuleBox.DataSource = null; uniqueRuleBox.DataSource = newCharacter.UniqueRules; uniqueRuleBox.DisplayMember = "ruleText"; }
public void InsertUniqueRule(UniqueRule ruleToInsert, int charID) { connection = dBControl.getConnection(); connection.Open(); using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Unique_Rules (unique_rule_text, character_id) VALUES " + "(@ruleText, @charID)", connection)) { cmd.Parameters.AddWithValue("@ruleText", ruleToInsert.RuleText); cmd.Parameters.AddWithValue("@charID", charID); int rows = cmd.ExecuteNonQuery(); connection.Close(); } }
private void SaveNewRuleButton_Click(object sender, EventArgs e) { UniqueRule newRule = new UniqueRule { RuleText = ruleTextBox.Text }; charController.InsertUniqueRule(newRule, selectedCharacter.CharID); newRule.UniqueRuleID = charController.GetUniqueRuleID(newRule, selectedCharacter.CharID); selectedCharacter.AddUniqueRule(newRule); uniqueRuleBox.DataSource = null; uniqueRuleBox.DataSource = selectedCharacter.UniqueRules; uniqueRuleBox.DisplayMember = "RuleText"; ruleTextBox.Visible = false; saveNewRuleButton.Visible = false; }