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