private void AddWaifu()
{
using (WaifuFrm waifu = new WaifuFrm())
{
waifu.id = -1;
if (catCombo.SelectedValue.ToString() != "0")
{
waifu.id_category = Int32.Parse(catCombo.SelectedValue.ToString());
}
else
{
waifu.id_category = -1;
}
waifu.FormClosed += WaifuClosed;
waifu.ShowDialog();
}
}
private void editWaifuBtn_Click(object sender, EventArgs e)
{
using (WaifuFrm waifu = new WaifuFrm())
{
string name = WaifuList.SelectedItems[0].SubItems[1].Text;
string query = "SELECT w.ID, w.name, cj.categoryID, cj.webID FROM";
query += " (waifu w INNER JOIN category_join cj ON w.ID = cj.waifuID)";
query += " where w.name = @name";
using (conn = new OleDbConnection(Config.connString))
using (OleDbCommand com = new OleDbCommand(query, conn))
{
conn.Open();
com.Parameters.AddWithValue("@name", name);
OleDbDataReader read = com.ExecuteReader(CommandBehavior.SingleRow);
if (read.Read())
{
if (read["webID"].ToString() != "0")
{
MessageBox.Show("", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
waifu.id = Int32.Parse(read["ID"].ToString());
waifu.name = name;
waifu.id_category = Int32.Parse(read["categoryID"].ToString());
waifu.FormClosed += WaifuClosed;
waifu.ShowDialog();
}
conn.Close();
}
}
}