private void CheckPaths() { String strQuery = "Select * from videos"; ArrayList alAllEntries = vdb.GetMovieList(strQuery); ArrayList alSearchPaths = vdb.GetSearchPaths(); foreach (DisplayData dd in alAllEntries) { vdb.MovieName = dd.MovieName; if (!File.Exists(vdb.Location)) { vdb.RemoveMovie(dd.MovieName); } // Remove if parent path is not a search path Boolean bRemove = true; foreach (String sp in alSearchPaths) { if (!(vdb.Location == null) && (vdb.Location.Contains(sp))) { bRemove = false; } } if (bRemove) { // It should be removed vdb.RemoveMovie(dd.MovieName); } } }
private void btnSearch_Click(object sender, EventArgs e) { dgvSearchList.Rows.Clear(); String strQuery = GetQuery(); ArrayList alSearchList = vdb.GetMovieList(strQuery); lblResultCount.Text = alSearchList.Count.ToString(); foreach (DisplayData dd in alSearchList) { dgvSearchList.Rows.Add(); dgvSearchList.Rows[dgvSearchList.RowCount - 1].Cells["Video"].Value = dd.MovieName; // Get the location of the video vdb.MovieName = dd.MovieName; String strFilePath = vdb.Location; if (File.Exists(strFilePath)) { dgvSearchList.Rows[dgvSearchList.RowCount - 1].Cells["Availability"].Style.ForeColor = Color.Green; dgvSearchList.Rows[dgvSearchList.RowCount - 1].Cells["Availability"].Value = "YES"; } else { dgvSearchList.Rows[dgvSearchList.RowCount - 1].Cells["Availability"].Style.ForeColor = Color.Red; dgvSearchList.Rows[dgvSearchList.RowCount - 1].Cells["Availability"].Value = "NO"; } } }