public Monster_Editor(sql_driver drive, monster m)
{
InitializeComponent();
instence_driver = drive;
my_monster = m;
load_monster();
}
public monster read_monster(string search_term)
{
//reads a monster from the DB and returns a monster class or exeption if
//that monster doesn't exist
com = new SQLiteCommand();
com.Connection = conect;
com.CommandText = "SELECT * FROM monster WHERE monster_id='" + search_term + "'";
SQLiteDataReader data = com.ExecuteReader();
monster m = new monster();
if (!(data.HasRows))
{
throw new Exception("monster " + search_term + " not found!");
}
data.Read();
//monster m = new monster();
m.monster_name = data.GetString(0);
m.armor_class = data.GetString(1);
m.hitpoints = data.GetString(2);
m.speed = data.GetString(3);
m.str = data.GetString(4);
m.dex = data.GetString(5);
m.con = data.GetString(6);
m.intel = data.GetString(7);
m.wis = data.GetString(8);
m.cha = data.GetString(9);
m.skills = data.GetString(10);
m.traits = data.GetString(11);
m.actions = data.GetString(12);
return(m);
}
private void newMonsterToolStripMenuItem_Click(object sender, EventArgs e)
{
if (!(check_if_db_open()))
{
return;
}
name_input n_in = new name_input();
n_in.ShowDialog();
if (n_in.name == "")
{
return;
}
if (current_driver.get_list_of_monsters().Contains(n_in.name))
{
var yn = MessageBox.Show("Monster " + n_in.name + " alredy exists replace?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (yn != DialogResult.Yes)
{
return;
}
}
current_driver.new_monster(n_in.name);
monster m = current_driver.read_monster(n_in.name);
Monster_Editor me = new Monster_Editor(current_driver, m);
me.ShowDialog();
}
private void update_monster()
{
monster my_monster = current_driver.get_fighters_monster(_current_fighter, _encounter_name);
monstername.Text = my_monster.monster_name;
armorclass.Text = my_monster.armor_class;
speed.Text = my_monster.speed;
STR.Text = my_monster.str;
DEX.Text = my_monster.dex;
CON.Text = my_monster.con;
WIS.Text = my_monster.wis;
INT.Text = my_monster.intel;
CHA.Text = my_monster.cha;
skills.Text = my_monster.skills;
traits.Text = my_monster.traits;
actions.Text = my_monster.actions;
HitpointRoller.Value = Convert.ToDecimal(current_driver.get_fighters_hp(_current_fighter, _encounter_name));
}
private void editMonsterToolStripMenuItem_Click(object sender, EventArgs e)
{
if (!(check_if_db_open()))
{
return;
}
name_input n_in = new name_input();
n_in.ShowDialog();
if (n_in.name == "")
{
return;
}
if (!(current_driver.get_list_of_monsters().Contains(n_in.name)))
{
MessageBox.Show("Monster " + n_in.name + " doesnt exist", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
monster m = current_driver.read_monster(n_in.name);
Monster_Editor me = new Monster_Editor(current_driver, m);
me.ShowDialog();
}
public void save_monster(monster m)
{
//method name should be update monster anyway it takes in a monster and
//then saves it to the database... Not inputs not sanitized.
string s_com = "UPDATE monster SET ";
s_com += "armor_class = '" + m.armor_class + "',";
s_com += "hit_points = '" + m.hitpoints + "',";
s_com += "speed = '" + m.speed + "',";
s_com += "STR = '" + m.str + "',";
s_com += "DEX = '" + m.dex + "',";
s_com += "CON = '" + m.con + "',";
s_com += "INT = '" + m.intel + "',";
s_com += "WIS = '" + m.wis + "',";
s_com += "CHA = '" + m.cha + "',";
s_com += "skills = '" + m.skills + "',";
s_com += "traits = '" + m.traits + "',";
s_com += "actions = '" + m.actions + "'";
s_com += " WHERE monster_id = '" + m.monster_name + "'";
com = new SQLiteCommand();
com.Connection = conect;
com.CommandText = s_com;
com.ExecuteNonQuery();
}
