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;
}
