public void JoinPerformerToFile(int performerId, int filenameId)
{
AccessRetriever retriever = new AccessRetriever(DatabasePath);
DataSet dataSet = retriever.GetPerformersFilenamesJoinTable();
DataRow newPerfFileJoin = dataSet.Tables[0].NewRow();
newPerfFileJoin["PerformerID"] = performerId;
newPerfFileJoin["FilenameID"] = filenameId;
dataSet.Tables[0].Rows.Add(newPerfFileJoin);
retriever.UpdateJoinTable(dataSet);
}
public void JoinPerformerToFile(List <PerformerFilenameJoinDto> joins)
{
AccessRetriever retriever = new AccessRetriever(DatabasePath);
DataSet dataSet = retriever.GetPerformersFilenamesJoinTable();
DataTable joinTable = dataSet.Tables[0];
foreach (PerformerFilenameJoinDto join in joins)
{
DataRow newPerfFileJoin = joinTable.NewRow();
newPerfFileJoin["PerformerID"] = join.PerformerId;
newPerfFileJoin["FilenameID"] = join.FilenameId;
joinTable.Rows.Add(newPerfFileJoin);
}
retriever.UpdateJoinTable(dataSet);
}
