public void Add(List <FileLocalDto> fileDtos)
{
AccessRetriever retriever = new AccessRetriever(databasePath);
DataSet dataSet = RetrieveFileEntriesFromDatabase(retriever);
DataTable filenamesTable = dataSet.Tables[0];
foreach (FileLocalDto file in fileDtos)
{
DataRow newRow = filenamesTable.NewRow();
newRow["Filename"] = file.Filename;
newRow["Genre"] = file.Genre;
newRow["Disc"] = file.Disc;
if (file.Series is null)
{
newRow["Series"] = DBNull.Value;
}
else
{
newRow["Series"] = file.Series;
}
if (file.Notes is null)
{
newRow["Notes"] = DBNull.Value;
}
else
{
newRow["Notes"] = file.Notes;
}
filenamesTable.Rows.Add(newRow);
}
retriever.UpdateFileEntries(dataSet);
}
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");
}