private void boardListView_DoubleClick(object sender, EventArgs e)
{
string number;
string title;
string table;
if (boardListView.SelectedItems.Count == 1)
{
number = boardListView.FocusedItem.SubItems[0].Text;
title = boardListView.FocusedItem.SubItems[1].Text;
ToWishOrWatched toWishOrWatched = new ToWishOrWatched(number, title);
toWishOrWatched.ShowDialog();
table = toWishOrWatched.Passvalue; //선택된 값 가져오기
ConnectDataBase(); //db연결
MySqlCommand cmd = new MySqlCommand();
string sql = "insert into " + table + "(id,number) values(\"" + user + "\"," + number + ")";
try
{
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
catch
{
//사용자가 table을 선택하지 않을경우(취소할경우) 오류 발생
MessageBox.Show("Cancel Movie add");
}
conn.Close();
setRecList();
}
}
}// void boardListView_ColumnWidthChanging(object sender, ColumnWidthChangingEventArgs e)
//리스트뷰 항목 더블클릭
private void boardListView_MouseDoubleClick(object sender, MouseEventArgs e)
{
string number;
string title;
string table;
//1. 전체목록에서의 항목 더블클릭 : 추천목록이나 시청기록으로 이동.
if (selectedBoard == "whole")
{
if (boardListView.SelectedItems.Count == 1)
{
number = boardListView.FocusedItem.SubItems[0].Text;
title = boardListView.FocusedItem.SubItems[1].Text;
ToWishOrWatched toWishOrWatched = new ToWishOrWatched(number, title);
toWishOrWatched.ShowDialog();
table = toWishOrWatched.Passvalue; //선택된 값 가져오기
ConnectDataBase(); //db연결
MySqlCommand cmd = new MySqlCommand();
string sql = "insert into " + table + "(id,number) values(\"" + user + "\"," + number + ")";
try
{
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
catch
{
//사용자가 table을 선택하지 않을경우(취소할경우) 오류 발생
MessageBox.Show("Cancel movie add");
}
conn.Close();
}
} //if whole board
else if (selectedBoard == "wish") //2. 즐겨찾기에서의 항목 더블클릭 : 삭제
{
number = boardListView.FocusedItem.SubItems[0].Text;
title = boardListView.FocusedItem.SubItems[1].Text;
DialogResult dr = MessageBox.Show("Are you sure you want to delete the selected movie from your favorites? ", "Notice", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
ConnectDataBase();//db연결
MySqlCommand cmd = new MySqlCommand();
string sql = "delete from wishlist where ID='" + user + "' and number=" + number + "; ";
try
{
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
MessageBox.Show("Deletion complete.");
boardControl(selectedBoard);
}
catch
{
conn.Close();
MessageBox.Show("Error deleting data.");
}
conn.Close();
}
else
{
MessageBox.Show("Cancel");
}
}
else if (selectedBoard == "watched") //3. 시청기록에서의 더블클릭 : 삭제
{
number = boardListView.FocusedItem.SubItems[0].Text;
title = boardListView.FocusedItem.SubItems[1].Text;
DialogResult dr = MessageBox.Show("Are you sure you want to delete the selected movie from your watch history?", "Notice", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (dr == DialogResult.OK)
{
ConnectDataBase();//db연결
MySqlCommand cmd = new MySqlCommand();
string sql = "delete from watchlist where ID='" + user + "' and number=" + number + "; ";
try
{
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
MessageBox.Show("Deletion complete");
boardControl(selectedBoard);
}
catch
{
MessageBox.Show("Error deleting data.");
}
conn.Close();
}
else
{
MessageBox.Show("Cancel");
}
}//if watchlist
else if (selectedBoard == "suggested") //4. 추천에서의 항목 더블클릭 : 추천목록이나 시청기록으로 이동
{
number = boardListView.FocusedItem.SubItems[0].Text;
title = boardListView.FocusedItem.SubItems[1].Text;
if (boardListView.SelectedItems.Count == 1)
{
number = boardListView.FocusedItem.SubItems[0].Text;
title = boardListView.FocusedItem.SubItems[1].Text;
ToWishOrWatched toWishOrWatched = new ToWishOrWatched(number, title);
toWishOrWatched.ShowDialog();
table = toWishOrWatched.Passvalue; //선택된 값 가져오기
ConnectDataBase(); //db연결
MySqlCommand cmd = new MySqlCommand();
string sql = "insert into " + table + "(id,number) values(\"" + user + "\"," + number + ")";
try
{
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
boardControl(selectedBoard);
}
catch
{
//사용자가 table을 선택하지 않을경우(취소할경우) 오류 발생
MessageBox.Show("Cancel movie add");
}
conn.Close();
}
}
setRecList(); //항목변경후 항상 추천테이블 갱신
}//void boardListView_MouseDoubleClick(object sender, MouseEventArgs e)
