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