public void ActualizarJornada( [Greedy]Jornada jornada) { var database = new Database(DatabaseHelper.Database); var sut = new PetaPocoJornadaCommands(database); sut.CrearJornada(jornada, DatabaseHelper.Usuario); var jornadaDbRow = database.FirstOrDefault<JornadaDbRow>( "Select * from Jornadas where IdJornada = @0", jornada.Id); jornadaDbRow.Should().NotBeNull(); // Modificamos var nuevaPausa = new Pausa(jornada.Fin.Value, jornada.Fin.Value.AddHours(2)); var idJornada = jornada.Id; jornada = new Jornada( jornada.Inicio, jornada.Fin.Value.AddDays(1), jornada.Pausas.Skip(1).Union(new[] { nuevaPausa }).ToArray()); jornada.Id = idJornada; sut.ActualizarJornada(jornada, DatabaseHelper.Usuario); jornadaDbRow = database.FirstOrDefault<JornadaDbRow>( "Select * from Jornadas where IdJornada = @0", jornada.Id); jornadaDbRow.Should().NotBeNull(); database.Execute("DELETE FROM Pausas WHERE IdJornada = @0", jornada.Id); database.Execute("DELETE FROM Jornadas WHERE IdJornada = @0", jornada.Id); }
public void CrearJornada( [Greedy]Jornada jornada) { var database = new Database(DatabaseHelper.Database); var sut = new PetaPocoJornadaCommands(database); sut.CrearJornada(jornada, DatabaseHelper.Usuario); var jornadaDbRow = database.FirstOrDefault<JornadaDbRow>( "Select * from Jornadas where IdJornada = @0", jornada.Id); jornadaDbRow.Should().NotBeNull(); database.Execute("DELETE FROM Pausas WHERE IdJornada = @0", jornada.Id); database.Execute("DELETE FROM Jornadas WHERE IdJornada = @0", jornada.Id); }
public void EliminarJornada( [Greedy]Jornada jornada) { var database = new Database(DatabaseHelper.Database); var sut = new PetaPocoJornadaCommands(database); sut.CrearJornada(jornada, DatabaseHelper.Usuario); var jornadaDbRow = database.FirstOrDefault<JornadaDbRow>( "SELECT * FROM Jornadas WHERE IdJornada = @0", jornada.Id); jornadaDbRow.Should().NotBeNull(); sut.EliminarJornada(jornada.Id); jornadaDbRow = database.FirstOrDefault<JornadaDbRow>( "SELECT * FROM Jornadas WHERE IdJornada = @0", jornada.Id); jornadaDbRow.Should().BeNull(); }