public void Save()
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO `coins`(`name`, `value`, `year`, category_id) VALUES(@name, @value, @year, @category_id);";
MySqlParameter name = new MySqlParameter();
name.ParameterName = "@name";
name.Value = this._name;
cmd.Parameters.Add(name);
MySqlParameter value = new MySqlParameter();
value.ParameterName = "@value";
value.Value = this._value;
cmd.Parameters.Add(value);
MySqlParameter year = new MySqlParameter();
year.ParameterName = "@year";
year.Value = this._year;
cmd.Parameters.Add(year);
MySqlParameter categoryId = new MySqlParameter();
categoryId.ParameterName = "@category_id";
categoryId.Value = this._categoryId;
cmd.Parameters.Add(categoryId);
cmd.ExecuteNonQuery();
_id = (int)cmd.LastInsertedId;
}
public void Save()
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"INSERT INTO category (name) VALUES (@name);";
MySqlParameter name = new MySqlParameter();
name.ParameterName = "@name";
name.Value = this._name;
cmd.Parameters.Add(name);
cmd.ExecuteNonQuery();
_id = (int)cmd.LastInsertedId;
conn.Close();
if (conn != null)
{
conn.Dispose();
}
}
public void UpdateName(string newName)
{
MySqlConnection conn = DB.Connection();
conn.Open();
var cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"UPDATE coins SET name = @newName WHERE id = @searchId;";
MySqlParameter searchId = new MySqlParameter();
searchId.ParameterName = "@searchId";
searchId.Value = _id;
cmd.Parameters.Add(searchId);
MySqlParameter name = new MySqlParameter();
name.ParameterName = "@newName";
name.Value = newName;
cmd.Parameters.Add(name);
cmd.ExecuteNonQuery();
_name = newName;
}
