public DataSet GetAllMoviesFromIMDBBySearchCriteria(MovieSearchIMDBCriteria criteria) { DataSet dtStMovies; SqlParameter[] arrParam = new SqlParameter[9]; arrParam[0] = new SqlParameter("@searchType", criteria.SearchType); arrParam[1] = new SqlParameter("@keywords", criteria.Keywords); arrParam[2] = new SqlParameter("@language", criteria.Language); arrParam[3] = new SqlParameter("@year", criteria.Year); arrParam[4] = new SqlParameter("@rating", criteria.Rating); arrParam[5] = new SqlParameter("@mpaaRating", criteria.MpaaRating); arrParam[6] = new SqlParameter("@isTop250", criteria.IsTop250); arrParam[7] = new SqlParameter("@oscars", criteria.Oscars); arrParam[8] = new SqlParameter("@genre", criteria.Genre); StringBuilder sbSPParams = new StringBuilder(); foreach (var param in arrParam) { sbSPParams.Append(param.ParameterName + ":" + param.Value + " & "); } sbSPParams.Remove(sbSPParams.Length - 3, 3); PlanetM_Utility.LogWrapper.LogInfo(string.Format("Executing SP:{0} Parameter Details>> {1}", StoredProcedure.GetAllMoviesBySearchCriteriaFromMiniIMDB, sbSPParams.ToString())); dtStMovies = SqlHelper.ExecuteDataset(m_Connection_String, CommandType.StoredProcedure, StoredProcedure.GetAllMoviesBySearchCriteriaFromMiniIMDB, arrParam); return dtStMovies; }
private void buttonSearch_Click(object sender, EventArgs e) { criteria = new AbstractLayer.MovieSearchIMDBCriteria(); criteria.SearchType = comboBoxSearchType.SelectedItem.ToString(); criteria.Keywords = textBoxKeywords.Text.Trim(); criteria.Language = comboBoxLanguage.SelectedItem.ToString(); criteria.Year = comboBoxYear.SelectedItem.ToString(); Regex regex = new Regex(@"(ALL)|(^)|(&)|(\s\s)"); criteria.Rating = regex.Replace(comboBoxRating.SelectedItem.ToString(), match => { switch (match.ToString()) { case "ALL": return "Rating = Rating"; case "": return "Rating "; case "&": return "AND Rating"; case " ": return ""; } return match.ToString(); }); criteria.MpaaRating = comboBoxMpaaRating.SelectedItem.ToString(); criteria.IsTop250 = comboBoxTop250.SelectedItem.ToString(); criteria.Oscars = comboBoxOscars.SelectedItem.ToString(); if (checkedListBoxGenre.CheckedIndices.Contains(0) && checkedListBoxGenre.CheckedItems.Count == checkedListBoxGenre.Items.Count) { criteria.Genre = "ALL"; } else if (checkedListBoxGenre.CheckedItems.Count < checkedListBoxGenre.Items.Count - 1) { criteria.Genre = ""; foreach (var genre in checkedListBoxGenre.CheckedItems) { criteria.Genre += genre.ToString() + ","; } if (checkedListBoxGenre.CheckedItems.Count > 0) criteria.Genre = criteria.Genre.Remove(criteria.Genre.Length - 1, 1); } DataTable movies = dbObj.GetAllMoviesFromIMDBBySearchCriteria(criteria).Tables[0]; labelResults.Text = movies.Rows.Count.ToString(); int iterator = 0; dgMovies.Rows.Clear(); foreach (DataRow drMovie in movies.AsEnumerable()) { dgMovies.Rows.Add(); dgMovies.Rows[iterator].Cells["ImdbID"].Value = drMovie["ImdbID"]; dgMovies.Rows[iterator].Cells["Title"].Value = drMovie["Title"]; dgMovies.Rows[iterator].Cells["Language"].Value = drMovie["Language"]; if (drMovie["Year"].ToString() == "0") dgMovies.Rows[iterator].Cells["Year"].Value = "NA"; else dgMovies.Rows[iterator].Cells["Year"].Value = drMovie["Year"].ToString(); if (drMovie["Rating"].ToString() == "0.00") dgMovies.Rows[iterator].Cells["Rating"].Value = "NA"; else dgMovies.Rows[iterator].Cells["Rating"].Value = drMovie["Rating"].ToString(); if (drMovie["Genre"].ToString().Length > 0) dgMovies.Rows[iterator].Cells["Genre"].Value = drMovie["Genre"]; else dgMovies.Rows[iterator].Cells["Genre"].Value = ""; if (drMovie["MpaaRating"].ToString().Length > 0) dgMovies.Rows[iterator].Cells["MpaaRating"].Value = drMovie["MpaaRating"]; else dgMovies.Rows[iterator].Cells["MpaaRating"].Value = ""; dgMovies.Rows[iterator].Cells["Awards"].Value = drMovie["Awards"]; dgMovies.Rows[iterator].Cells["Nominations"].Value = drMovie["Nominations"]; dgMovies.Rows[iterator].Cells["Top250"].Value = drMovie["Top250"]; dgMovies.Rows[iterator].Cells["Oscars"].Value = drMovie["Oscars"]; ApplyStyleForRow(iterator, drMovie["Language"].ToString(), Convert.ToInt32(drMovie["Year"]), Convert.ToDouble(drMovie["Rating"]), drMovie["MpaaRating"].ToString(), Convert.ToInt32(drMovie["Awards"]), Convert.ToInt32(drMovie["Nominations"]), Convert.ToInt32(drMovie["Top250"]), Convert.ToInt32(drMovie["Oscars"])); iterator++; } groupBoxExport.Enabled = true; }