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