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"); } } }