public bool DeleteAll()
{
using (var dc = new DayOfDotNetDataContext()) {
dc.ExecuteCommand("Delete from Winner");
dc.ExecuteCommand("Delete from Attendee");
}
return true;
}
public bool ResetAllHasWon()
{
using (var dc = new DayOfDotNetDataContext()) {
dc.ExecuteCommand("Update Attendee Set HasWon = 'false'");
}
return true;
}
public void InsertAll_ShouldInsertAllTheSupplied_Attendees()
{
//Arrange
AttendeeDTO attendee1 = new AttendeeDTO {FirstName = "FName1", LastName = "LName1", Company = "Company1", Email = "*****@*****.**", IsEligible = true, HasWon = true};
AttendeeDTO attendee2 = new AttendeeDTO {FirstName = "FName2", LastName = "LName2", Company = "Company2", Email = "*****@*****.**", IsEligible = false, HasWon = false};
IList<AttendeeDTO> attendees = new List<AttendeeDTO>{attendee1,attendee2};
using (new TransactionScope()) {
using (var dc = new DayOfDotNetDataContext()) {
dc.ExecuteCommand("Delete from Winner");
dc.ExecuteCommand("Delete from Attendee");
}
//Act
IAttendeeRepository repo = new AttendeeRepository();
bool successful = repo.InsertAll(attendees);
//Assert
successful.ShouldBeTrue("Expected True");
using (var dc = new DayOfDotNetDataContext()) {
(from x in dc.Attendees select x).Count().ShouldEqual(2, "Expected 2 Attendees");
}
}
}
