public static Yacht Find(int id) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT * FROM `yachts` WHERE id = @thisId;"; MySqlParameter thisId = new MySqlParameter(); thisId.ParameterName = "@thisId"; thisId.Value = id; cmd.Parameters.Add(thisId); var rdr = cmd.ExecuteReader() as MySqlDataReader; int itemId = 0; string itemYacht = ""; while (rdr.Read()) { itemId = rdr.GetInt32(0); itemYacht = rdr.GetString(1); } Yacht foundYacht = new Yacht(itemYacht, itemId); conn.Close(); if (conn != null) { conn.Dispose(); } return(foundYacht); }
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 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 items (Name, PokemonType, Number) VALUES (@ItemName, @ItemPokemonType, @ItemNumber);"; cmd.Parameters.Add(new MySqlParameter("@ItemName", _name)); cmd.Parameters.Add(new MySqlParameter("@ItemPokemonType", _pokemonType)); cmd.Parameters.Add(new MySqlParameter("@ItemNumber", _number)); // // MySqlParameter PokemonType = new MySqlParameter(); // PokemonType.ParameterName = "@ItemPokemonType"; // PokemonType.Value = this._pokemonType; // cmd.Parameters.Add(PokemonType); // // MySqlParameter Number = new MySqlParameter(); // Number.ParameterName = "@ItemNumber"; // Number.Value = this._number; // cmd.Parameters.Add(Number); cmd.ExecuteNonQuery(); _id = (int)cmd.LastInsertedId; // This line is new! 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; }