public void UpdateDescription(string newDescription) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"UPDATE tasks SET description = @newDescription WHERE id = @searchId;"; MySqlParameter searchId = new MySqlParameter(); searchId.ParameterName = "@searchId"; searchId.Value = _id; cmd.Parameters.Add(searchId); MySqlParameter description = new MySqlParameter(); description.ParameterName = "@newDescription"; description.Value = newDescription; cmd.Parameters.Add(description); cmd.ExecuteNonQuery(); conn.Close(); }
public void Save() { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO categories (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 List <Item> GetItems() { MySqlConnection conn = DB.Connection(); conn.Open(); MySqlCommand cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"SELECT items.* FROM categories JOIN categories_items ON (categories.id = categories_items.category_id) JOIN items ON (categories_items.item_id = items.id) WHERE categories.id = @CategoryId;"; MySqlParameter categoryIdParameter = new MySqlParameter(); categoryIdParameter.ParameterName = "@CategoryId"; categoryIdParameter.Value = _id; cmd.Parameters.Add(categoryIdParameter); MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader; List <Item> items = new List <Item> { }; while (rdr.Read()) { int itemId = rdr.GetInt32(0); string itemDescription = rdr.GetString(1); Item newItem = new Item(itemDescription, itemId); items.Add(newItem); } conn.Close(); if (conn != null) { conn.Dispose(); } return(items); }