public void UpdateFileEntries_Temp_ActuallyUpdateFileEntries()
{
string dbLocation = @"c:\temp\Files on Dvd.accdb";
AccessRetriever myRetriever = new AccessRetriever(dbLocation);
DataSet dataSet = myRetriever.GetFileEntries();
DataRow newEntry = dataSet.Tables[0].NewRow();
newEntry["Filename"] = "Succession - 1.01 - Pilot";
newEntry["Genre"] = 3;
newEntry["Disc"] = 224;
newEntry["Series"] = 14;
dataSet.Tables[0].Rows.Add(newEntry);
DataRow newEntry2 = dataSet.Tables[0].NewRow();
newEntry2["Filename"] = "Buffy the Vampire Slayer - 1.01 - Welcome to the Hellmouth";
newEntry2["Genre"] = 3;
newEntry2["Disc"] = 224;
newEntry2["Series"] = 15;
dataSet.Tables[0].Rows.Add(newEntry2);
myRetriever.UpdateFileEntries(dataSet);
Console.WriteLine("Debug this line");
}
private DataSet RetrieveFileEntriesFromDatabase(AccessRetriever retriever, int?discId = null)
{
DataSet dataSet;
try {
if (discId == null)
{
dataSet = retriever.GetFileEntries();
}
else
{
dataSet = retriever.GetFileEntriesByDiscId((int)discId);
}
}
catch (Exception e) {
Log.Error(e, "Could not retrieve filenames from Access DB");
throw new InvalidOperationException("Could not retrieve filenames from Access DB", e);
}
if (dataSet is null)
{
throw new InvalidOperationException("Filenames dataSet is null");
}
return(dataSet);
}
