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_NewPerformer_AddsToPerformersTable()
{
string dbLocation = @"c:\temp\Files on Dvd.accdb";
PerformerRepository repository = new PerformerRepository(dbLocation);
PerformerLocalDto performer = new PerformerLocalDto()
{
Name = "Jumpin' Jack Flash"
};
repository.Add(performer);
Console.WriteLine("Debug this line");
}
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");
}
public void Get_ByName_PerformerDoesNotExist_ReturnsPerformer()
{
string dbLocation = @"c:\temp\Files on Dvd.accdb";
PerformerRepository repository = new PerformerRepository(dbLocation);
PerformerLocalDto expected = new PerformerLocalDto()
{
Id = -1,
Name = "Oscar the Grouch"
};
string performerNameToFind = "oscar the grouch";
var result = repository.Get(performerNameToFind);
Assert.AreEqual(expected.Id, result.Id);
}
public void Get_ByName_PerformerExists_ReturnsPerformer()
{
string dbLocation = @"c:\temp\Files on Dvd.accdb";
PerformerRepository repository = new PerformerRepository(dbLocation);
PerformerLocalDto expected = new PerformerLocalDto()
{
Id = 177,
Name = "Steve Austin"
};
string performerNameToFind = "steve austin";
var result = repository.Get(performerNameToFind);
Assert.AreEqual(expected.Id, result.Id);
}
public void Get_GetAllPerformers_ReturnsAllPerformers()
{
string dbLocation = @"c:\temp\Files on Dvd.accdb";
PerformerRepository repository = new PerformerRepository(dbLocation);
PerformerLocalDto expected = new PerformerLocalDto()
{
Id = 177,
Name = "Steve Austin"
};
List <PerformerLocalDto> performersInDb = repository.Get();
var result = performersInDb.FirstOrDefault(p => p.Name.ToLower() == "steve austin");
Assert.AreEqual(expected.Id, result.Id);
}
public PerformerLocalDto GetPerformerByName(string performerName)
{
PerformerLocalDto perf = Performers.FirstOrDefault(b =>
b.Name.ToUpper() == performerName.ToUpper());
// should null check be here or in caller?
if (perf == null)
{
perf = new PerformerLocalDto()
{
Id = 0,
Name = performerName
};
}
return(perf);
}
public void Get_ByName_AliasIsUsed_ReturnsPerformer()
{
string dbLocation = @"c:\temp\Files on Dvd.accdb";
PerformerRepository repository = new PerformerRepository(dbLocation);
PerformerLocalDto expected = new PerformerLocalDto()
{
Id = 177,
Name = "Steve Austin"
};
string performerNameToFind = "chilly mcfreeze";
var result = repository.Get(performerNameToFind);
Console.WriteLine("Breakpoint this line");
Assert.AreEqual(expected.Id, result.Id);
}
public PerformerLocalDto Get(string name)
{
PerformerLocalDto perf = Performers.FirstOrDefault(b =>
b.Name.ToUpper() == name.ToUpper());
if (perf == null)
{
AliasLocalDto aliasDto = GetAlias(name);
if (aliasDto == null)
{
perf = new PerformerLocalDto()
{
Id = -1,
Name = name
};
}
else
{
perf = Performers.Find(p => p.Id == aliasDto.Performer);
perf.IsAlias = true;
}
}
return(perf);
}
