private void AddButton_Click(object sender, RoutedEventArgs e) { SearchMovieControl selectedUser = (SearchMovieControl)myContact.SelectedItem; MovieInfo selectedMovie = selectedUser.movinfo; string dbpath = @"Data Source=" + App.databasePath; using (SQLiteConnection conn = new SQLiteConnection(dbpath)) { conn.Open(); string sql = "INSERT INTO movies (Title,SubTitle,DirectorName,ActorName,ImageUri,OpeningData,Review,Star) " + "values ('" + selectedMovie.Title + "','" + selectedMovie.SubTitle + "','" + selectedMovie.DirectorName + "','" + selectedMovie.ActorName + "','" + selectedMovie.imageUri + "'," + "'" + selectedMovie.OpeningData + "','" + selectedMovie.Review + "'," + selectedMovie.Star + ")"; SQLiteCommand com = new SQLiteCommand(sql, conn); com.ExecuteNonQuery(); conn.Close(); } MessageBox.Show("추가완료"); ((MainWindow)System.Windows.Application.Current.MainWindow).MovieGrid.Children.Clear(); ((MainWindow)System.Windows.Application.Current.MainWindow).ReadTable(); }
private void SearchButton_Click(object sender, RoutedEventArgs e) { if (myContact.Items.Count != 0) { myContact.Items.Clear(); } string search_name = Movie_searchName.Text; string query = search_name; // 검색할 문자열 string url = "https://openapi.naver.com/v1/search/movie?query=" + query; // 결과가 JSON 포맷 HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); request.Method = "GET"; request.Headers.Add("X-Naver-Client-Id", "Sz1m6GDnrPLbr52KCvhR"); // 클라이언트 아이디 request.Headers.Add("X-Naver-Client-Secret", "nsraifwQXD"); // 클라이언트 시크릿 HttpWebResponse response = (HttpWebResponse)request.GetResponse(); string status = response.StatusCode.ToString(); if (status == "OK") { Stream stream = response.GetResponseStream(); StreamReader reader = new StreamReader(stream, Encoding.UTF8); string text = reader.ReadToEnd(); MovieItems ex = (JsonConvert.DeserializeObject <MovieItems>(text)); if (ex.items.Count >= 1) // 만약 입력값이 있을 시 { int repeatNum; if (ex.items.Count >= 10) // 영화 검색출력값이 10개 이상인 경우 { repeatNum = 10; // 10개만 출력 } else { repeatNum = ex.items.Count; // 10개 이하인 경우 개수만큼 출력 } for (int i = 0; i < repeatNum; i++) { MovieInfo movInfo = new MovieInfo(); Movies[i] = new SearchMovieControl(); string title = ex.items[i].title.Replace("<b>", ""); title = title.Replace("</b>", ""); movInfo.Title = title; string pubDate = ex.items[i].pubDate; movInfo.OpeningData = pubDate; string subtitle = ex.items[i].subtitle.Replace("<b>", ""); subtitle = subtitle.Replace("</b>", ""); movInfo.SubTitle = subtitle; string directorName = ex.items[i].director; movInfo.DirectorName = directorName; string actorName = ex.items[i].actor; movInfo.ActorName = actorName; string imageUri = ex.items[i].image; movInfo.imageUri = imageUri; Movies[i].movinfo = movInfo; myContact.Items.Add(Movies[i]); } myContact.ScrollIntoView(myContact.Items[0]); // 맨위로 스크롤 옮긴다 } } }