public void RetrieveTrackFromDatabase() { RecordingDataSet loadedFromDB = new RecordingDataSet(); RecordingDataSet.Track loadedTrack = gateway.FindById(trackId, loadedFromDB); Assert.AreEqual(trackId, loadedTrack.Id); Assert.AreEqual(title, loadedTrack.Title); Assert.AreEqual(duration, loadedTrack.Duration); }
public override void Insert() { recordingDataSet = new RecordingDataSet(); recordingGateway = new RecordingGateway(Connection); trackGateway = new TrackGateway(Connection); reviewGateway = new ReviewGateway(Connection); reviewerGateway = new ReviewerGateway(Connection); labelGateway = new LabelGateway(Connection); artistGateway = new ArtistGateway(Connection); genreGateway = new GenreGateway(Connection); artistId = artistGateway.Insert(recordingDataSet, "Artist"); labelId = labelGateway.Insert(recordingDataSet, "Label"); genreId = genreGateway.Insert(recordingDataSet, "Genre"); reviewerId = reviewerGateway.Insert(recordingDataSet, "Reviewer"); recordingId = recordingGateway.Insert(recordingDataSet, "Recording Title", new DateTime(1999, 1, 12), artistId, labelId); reviewId = reviewGateway.Insert(recordingDataSet, 1, "Review"); trackId = trackGateway.Insert(recordingDataSet, "Track Title", 120); RecordingDataSet.Recording recording = recordingGateway.FindById(recordingId, recordingDataSet); RecordingDataSet.Review review = reviewGateway.FindById(reviewId, recordingDataSet); RecordingDataSet.Track track = trackGateway.FindById(trackId, recordingDataSet); RecordingDataSet.Label label = labelGateway.FindById(labelId, recordingDataSet); RecordingDataSet.Genre genre = genreGateway.FindById(genreId, recordingDataSet); RecordingDataSet.Artist artist = artistGateway.FindById(artistId, recordingDataSet); RecordingDataSet.Reviewer reviewer = reviewerGateway.FindById(reviewerId, recordingDataSet); // setup the relationships recording.Artist = artist; recording.Label = label; track.Recording = recording; track.Artist = artist; track.Genre = genre; review.Recording = recording; review.Reviewer = reviewer; recordingGateway.Update(recordingDataSet); trackGateway.Update(recordingDataSet); reviewGateway.Update(recordingDataSet); RecordingDataSet loadedDataSet = new RecordingDataSet(); loadedRecording = Catalog.FindByRecordingId(loadedDataSet, recordingId); }
public override void CustomizeRecording() { trackGateway = new TrackGateway(Connection); trackId = trackGateway.Insert(RecordingDataSet, "Track", 120); RecordingDataSet.Track track = trackGateway.FindById(trackId, RecordingDataSet); track.Recording = Recording; trackGateway.Update(RecordingDataSet); }
public new void SetUp() { base.SetUp(); trackGateway = new TrackGateway(Connection); trackId = trackGateway.Insert(RecordingDataSet, "Track", 120); RecordingDataSet.Track track = trackGateway.FindById(trackId, RecordingDataSet); track.Recording = Recording; trackGateway.Update(RecordingDataSet); }
public new void SetUp() { base.SetUp(); trackGateway = new TrackGateway(Connection); trackId = trackGateway.Insert(RecordingDataSet, "Track", 120); RecordingDataSet.Track track = trackGateway.FindById(trackId, RecordingDataSet); track.Recording = Recording; trackGateway.Update(RecordingDataSet); }
public void Create() { recordingDataSet = new RecordingDataSet(); artistGateway = new ArtistGateway(Connection); artistId = artistGateway.Insert(recordingDataSet, "Artist"); trackGateway = new TrackGateway(Connection); trackId = trackGateway.Insert(recordingDataSet, "Title", 120); track = trackGateway.FindById(trackId, recordingDataSet); track.ArtistId = artistId; trackGateway.Update(recordingDataSet); }
public void Create() { recordingDataSet = new RecordingDataSet(); genreGateway = new GenreGateway(Connection); genreId = genreGateway.Insert(recordingDataSet, "Genre"); trackGateway = new TrackGateway(Connection); trackId = trackGateway.Insert(recordingDataSet, "Title", 120); track = trackGateway.FindById(trackId, recordingDataSet); track.GenreId = genreId; trackGateway.Update(recordingDataSet); }