internal Lists.MovieList GetAll()
{
Lists.MovieList list = new Lists.MovieList();
//Open connection
if (dh.OpenConnection() == true)
{
string q = "SELECT * FROM Movies";
//Create Command
SQLiteCommand cmd = new SQLiteCommand(q, dh.connection);
//Create a data reader and Execute the command
SQLiteDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
Movie m = null;
while (dataReader.Read())
{
m = new Movie();
//if (dh.HasColumn(dataReader, "ROWID"))
// m.ID = Convert.ToInt32(dataReader["ROWID"]);
if (dh.HasColumn(dataReader, "Title"))
m.Title = dataReader["Title"].ToString();
if (dh.HasColumn(dataReader, "Synopsis"))
m.Synopsis = dataReader["Synopsis"].ToString();
if (dh.HasColumn(dataReader, "Year"))
m.Year = Convert.ToInt32(dataReader["Year"]);
if (dh.HasColumn(dataReader, "Duration"))
m.Duration = Convert.ToInt32(dataReader["Duration"]);
if (dh.HasColumn(dataReader, "Rating"))
m.Rating = Convert.ToInt32(dataReader["Rating"]);
if (dh.HasColumn(dataReader, "AgeRestriction"))
m.AgeRestriction = dataReader["AgeRestriction"].ToString();
if (dh.HasColumn(dataReader, "TMDBID"))
m.TMDBID = Convert.ToInt32(dataReader["TMDBID"]);
m.RecordExists = true;
list.Add(m);
}
//close Data Reader
dataReader.Close();
//close Connection
dh.CloseConnection();
}
return list;
}
private void buttonTitle_Click(object sender, RoutedEventArgs e)
{
RenameMovieWindow renameMovieWindow = new RenameMovieWindow();
renameMovieWindow.OriginalName = Title;
renameMovieWindow.NewName = Title;
renameMovieWindow.Rename += delegate
{
BackgroundWorker bg = new BackgroundWorker();
bg.DoWork += delegate
{
try
{
FileInfo fi = new FileInfo(FullPath);
string newName = "";
if (renameMovieWindow.textBoxNewName.Dispatcher.CheckAccess())
{
newName = fi.Directory + "\\" + renameMovieWindow.NewName + fi.Extension;
}
else
{
renameMovieWindow.textBoxNewName.Dispatcher.Invoke(delegate
{
newName = fi.Directory + "\\" + renameMovieWindow.NewName + fi.Extension;
});
}
File.Move(FullPath, newName);
FullPath = newName;
Movie = new DiscordiaGenLib.GenLib.Business.Movie();
FindMovieInfo();
UpdateUI();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + Environment.NewLine + ex.ToString());
}
};
bg.RunWorkerAsync();
};
if (renameMovieWindow.ShowDialog() == true)
{
}
}
