private void listView1_SelectedIndexChanged(object sender, EventArgs e)
{
if (listView1.SelectedIndices.Count > 0 && listView1.SelectedIndices[0] > 0)
{
int selected_index = listView1.SelectedIndices[0];
newCategoryName.Text = listView1.SelectedItems[0].SubItems[1].Text;
selected_item = categories[selected_index];
}
}
/// <summary>
/// 分類コンボボックスの中身を更新するプライベートメソッド
/// </summary>
private void UpdateCategories()
{
categories = new List<Category>();
catergoryComboBox.Items.Clear();
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString))
{
con.Open();
string sql = "SELECT id, name FROM category";
MySqlCommand cmd = new MySqlCommand(sql, con);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var tmp = new Category { Id = reader.GetInt32(0), Name = reader.GetString(1) };
categories.Add(tmp);
catergoryComboBox.Items.Add(tmp.Name);
}
}
}
/// <summary>
/// 分類管理ウインドウ
/// </summary>
private void UpdateRows()
{
using (MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["conString"].ConnectionString))
{
con.Open();
string sql = "SELECT * FROM category;";
MySqlCommand cmd = new MySqlCommand(sql, con);
var reader = cmd.ExecuteReader();
listView1.Items.Clear();
categories.Clear();
while (reader.Read())
{
var tmp = new Category { Id = reader.GetInt32(0), Name = reader.GetString(1), CreatedDate = reader.GetDateTime(3) };
var item = new ListViewItem();
item.Name = tmp.Id.ToString();
item.Text = tmp.Id.ToString();
item.SubItems.Add(tmp.Name);
item.SubItems.Add(tmp.CreatedDate.ToString("yyyy/MM/dd"));
listView1.Items.Add(item);
categories.Add(tmp);
}
}
}