public void Delete_TimeTable_By_TimeTable()
{
string timeTableName = "Test TimeTable to Delete";
// Add to database
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
TimeTableRepository timeTableRepository = new TimeTableRepository(ctx);
timeTableRepository.Add(new TimeTable { Name = timeTableName });
timeTableRepository.SaveChanges();
}
// Find and delete it
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
List<TimeTable> timeTables = ctx.TimeTables.Where(pier => pier.Name == timeTableName).ToList();
Assert.AreEqual(1, timeTables.Count());
TimeTableRepository timeTableRepository = new TimeTableRepository(ctx);
timeTableRepository.Delete(timeTables[0]);
timeTableRepository.SaveChanges();
}
// Check that nothing is there
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
List<TimeTable> timeTables = ctx.TimeTables.Where(pier => pier.Name == timeTableName).ToList();
Assert.AreEqual(0, timeTables.Count());
}
}
public void Add_TimeTable()
{
string timeTableName = "Test TimeTable to Add";
// Add to database
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
TimeTableRepository timeTableRepository = new TimeTableRepository(ctx);
timeTableRepository.Add(new TimeTable { Name = timeTableName });
timeTableRepository.SaveChanges();
}
// Check that it is there
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
List<TimeTable> timeTables = ctx.TimeTables.Where(pier => pier.Name == timeTableName).ToList();
Assert.AreEqual(1, timeTables.Count());
}
}
public void Update_TimeTable()
{
string timeTableName = "Test TimeTable to Update";
string timeTableNameUpdated = "Test TimeTable Updated";
// Add to database
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
TimeTableRepository timeTableRepository = new TimeTableRepository(ctx);
timeTableRepository.Add(new TimeTable { Name = timeTableName });
timeTableRepository.SaveChanges();
}
// Find and update it
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
List<TimeTable> timeTables = ctx.TimeTables.Where(pier => pier.Name == timeTableName).ToList();
Assert.AreEqual(1, timeTables.Count());
TimeTableRepository timeTableRepository = new TimeTableRepository(ctx);
timeTables[0].Name = timeTableNameUpdated;
timeTableRepository.Update(timeTables[0]);
timeTableRepository.SaveChanges();
}
// Check that the new name is there
using (ThamesClipperContext ctx = new ThamesClipperContext())
{
List<TimeTable> timeTables = ctx.TimeTables.Where(pier => pier.Name == timeTableNameUpdated).ToList();
Assert.AreEqual(1, timeTables.Count());
}
}