private List <PerformerLocalDto> RetrievePerformersFromDatabase()
{
List <PerformerLocalDto> allPerformers = new List <PerformerLocalDto>();
try {
AccessRetriever retriever = new AccessRetriever(DatabasePath);
DataSet resultsetFromDb = retriever.GetPerformers();
DataTable performersTable = resultsetFromDb.Tables[0];
foreach (DataRow row in performersTable.Rows)
{
int?id = GetStringValueAsInt(row, "ID");
PerformerLocalDto performer = new PerformerLocalDto()
{
Id = (int)id,
Name = row["Performer"].ToString()
};
allPerformers.Add(performer);
}
Log.Information("Read {0} performers from database.", allPerformers.Count);
}
catch (Exception e) {
Log.Error(e, "Could not retrieve performers from database");
}
return(allPerformers);
}
private List <PerformerLocalDto> RetrievePerformers()
{
List <PerformerLocalDto> allPerformers = new List <PerformerLocalDto>();
try {
AccessRetriever retriever = new AccessRetriever(DatabasePath);
DataSet resultsetFromDb = retriever.GetPerformers();
DataTable performersTable = resultsetFromDb.Tables[0];
foreach (DataRow row in performersTable.Rows)
{
string idStr = row["ID"].ToString();
bool result = int.TryParse(idStr, out int id);
PerformerLocalDto performer = new PerformerLocalDto()
{
Id = id,
Name = row["Performer"].ToString()
};
allPerformers.Add(performer);
}
}
catch (Exception e) {
Log.Error(e, "Could not retrieve performers from database");
throw new ArgumentException("Could not retrieve performers from database", e);
}
return(allPerformers);
}
public void Add(PerformerLocalDto performer)
{
AccessRetriever retriever = new AccessRetriever(DatabasePath);
DataSet dataSet = retriever.GetPerformers();
DataTable performersTable = dataSet.Tables[0];
DataRow newRow = dataSet.Tables[0].NewRow();
newRow["Performer"] = performer.Name;
// newRow[2] = 1; // this is supposed to be Performer Type. Can use the column number instead
performersTable.Rows.Add(newRow);
var changes = dataSet.GetChanges();
retriever.UpdateAccessTableFromDataSet(dataSet, "tblPerformers", "ID, Performer");
}