public void AverageRatingZero()
{
RecordingDataSet dataSet = new RecordingDataSet();
RecordingDataSet.Recording recording =
dataSet.Recordings.NewRecording();
recording.Id = 1;
recording.Title = "Title";
recording.ReleaseDate = DateTime.Today;
RecordingDataSet.Label label = dataSet.Labels.NewLabel();
label.Id = 1;
label.Name = "Label";
dataSet.Labels.AddLabel(label);
RecordingDataSet.Artist artist = dataSet.Artists.NewArtist();
artist.Id = 1;
artist.Name = "Artist";
dataSet.Artists.AddArtist(artist);
recording.Label = label;
recording.Artist = artist;
dataSet.Recordings.AddRecording(recording);
RecordingDto dto = RecordingAssembler.WriteDto(recording);
Assert.AreEqual(0, dto.averageRating);
}
public override void Insert()
{
recordingDataSet = new RecordingDataSet();
recordingGateway = new RecordingGateway(Connection);
labelGateway = new LabelGateway(Connection);
artistGateway = new ArtistGateway(Connection);
artistId = artistGateway.Insert(recordingDataSet, "Artist");
labelId = labelGateway.Insert(recordingDataSet, "Label");
recordingId = recordingGateway.Insert(recordingDataSet,
"Recording Title", new DateTime(1999, 1, 12), artistId, labelId);
RecordingDataSet.Recording recording =
recordingGateway.FindById(recordingId, recordingDataSet);
RecordingDataSet.Label label =
labelGateway.FindById(labelId, recordingDataSet);
RecordingDataSet.Artist artist =
artistGateway.FindById(artistId, recordingDataSet);
recording.Artist = artist;
recording.Label = label;
recordingGateway.Update(recordingDataSet);
RecordingDataSet loadedDataSet = new RecordingDataSet();
loadedRecording = Catalog.FindByRecordingId(loadedDataSet, recordingId);
}
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 void RetrieveLabelFromDatabase()
{
RecordingDataSet loadedFromDB = new RecordingDataSet();
RecordingDataSet.Label loadedLabel = gateway.FindById(labelId, loadedFromDB);
Assert.AreEqual(labelId, loadedLabel.Id);
Assert.AreEqual(labelName, loadedLabel.Name);
}
public void DeleteLabelFromDatabase()
{
RecordingDataSet emptyDataSet = new RecordingDataSet();
long deletedLabelId = gateway.Insert(emptyDataSet, "Deleted Label");
gateway.Delete(emptyDataSet, deletedLabelId);
RecordingDataSet.Label deleletedLabel = gateway.FindById(deletedLabelId, emptyDataSet);
Assert.IsNull(deleletedLabel);
}
public void UpdateLableNameInDatabase()
{
RecordingDataSet.Label label = recordingDataSet.Labels[0];
label.Name = "Modified Name";
gateway.Update(recordingDataSet);
RecordingDataSet updatedDataSet = new RecordingDataSet();
RecordingDataSet.Label updatedLabel = gateway.FindById(labelId, updatedDataSet);
Assert.AreEqual("Modified Name", updatedLabel.Name);
}
public RecordingDataSet.Label FindById(long labelId, RecordingDataSet recordingDataSet)
{
command.Parameters["@id"].Value = labelId;
adapter.Fill(recordingDataSet, recordingDataSet.Labels.TableName);
DataRow[] rows = recordingDataSet.Labels.Select(String.Format("id={0}", labelId));
if (rows.Length < 1)
{
return(null);
}
RecordingDataSet.Label label = (RecordingDataSet.Label)rows[0];
return(label);
}
public long Insert(RecordingDataSet recordingDataSet, string labelName)
{
long labelId = IdGenerator.GetNextId(recordingDataSet.Labels.TableName, connection);
RecordingDataSet.Label labelRow = recordingDataSet.Labels.NewLabel();
labelRow.Id = labelId;
labelRow.Name = labelName;
recordingDataSet.Labels.AddLabel(labelRow);
adapter.Update(recordingDataSet, recordingDataSet.Labels.TableName);
return(labelId);
}
public void Execute()
{
SqlConnection connection =
TransactionManager.Transaction().Connection;
RecordingGateway recordingGateway =
new RecordingGateway(connection);
recording = recordingGateway.FindById(recordingId, dataSet);
if (recording == null)
{
return;
}
long artistId = recording.ArtistId;
ArtistGateway artistGateway = new ArtistGateway(connection);
RecordingDataSet.Artist artist =
artistGateway.FindById(artistId, dataSet);
long labelId = recording.LabelId;
LabelGateway labelGateway = new LabelGateway(connection);
RecordingDataSet.Label label =
labelGateway.FindById(labelId, dataSet);
GenreGateway genreGateway = new GenreGateway(connection);
TrackGateway trackGateway = new TrackGateway(connection);
foreach (RecordingDataSet.Track track in
trackGateway.FindByRecordingId(recordingId, dataSet))
{
artistId = track.ArtistId;
long genreId = track.GenreId;
artist = artistGateway.FindById(artistId, dataSet);
RecordingDataSet.Genre genre =
genreGateway.FindById(genreId, dataSet);
}
ReviewGateway reviewGateway = new ReviewGateway(connection);
ReviewerGateway reviewerGateway = new ReviewerGateway(connection);
foreach (RecordingDataSet.Review review in
reviewGateway.FindByRecordingId(recordingId, dataSet))
{
long reviewerId = review.ReviewerId;
RecordingDataSet.Reviewer reviewer =
reviewerGateway.FindById(reviewerId, dataSet);
}
}
public static RecordingDataSet.Recording FindByRecordingId(
RecordingDataSet recordingDataSet, long recordingId)
{
SqlConnection connection = null;
RecordingDataSet.Recording recording = null;
try
{
connection = new SqlConnection(
ConfigurationSettings.AppSettings.Get("Catalog.Connection"));
connection.Open();
RecordingGateway recordingGateway = new RecordingGateway(connection);
recording = recordingGateway.FindById(recordingId, recordingDataSet);
if (recording != null)
{
long artistId = recording.ArtistId;
ArtistGateway artistGateway = new ArtistGateway(connection);
RecordingDataSet.Artist artist =
artistGateway.FindById(artistId, recordingDataSet);
long labelId = recording.LabelId;
LabelGateway labelGateway = new LabelGateway(connection);
RecordingDataSet.Label label =
labelGateway.FindById(labelId, recordingDataSet);
GenreGateway genreGateway = new GenreGateway(connection);
TrackGateway trackGateway = new TrackGateway(connection);
foreach (RecordingDataSet.Track track in
trackGateway.FindByRecordingId(recordingId, recordingDataSet))
{
artistId = track.ArtistId;
long genreId = track.GenreId;
artist = artistGateway.FindById(artistId, recordingDataSet);
RecordingDataSet.Genre genre =
genreGateway.FindById(genreId, recordingDataSet);
}
ReviewGateway reviewGateway = new ReviewGateway(connection);
ReviewerGateway reviewerGateway = new ReviewerGateway(connection);
foreach (RecordingDataSet.Review review in
reviewGateway.FindByRecordingId(recordingId, recordingDataSet))
{
long reviewerId = review.ReviewerId;
RecordingDataSet.Reviewer reviewer =
reviewerGateway.FindById(reviewerId, recordingDataSet);
}
}
}
finally
{
if (connection != null)
{
connection.Close();
}
}
return(recording);
}
public void LabelOfTheRecording()
{
RecordingDataSet.Label loadedLabel = loadedRecording.Label;
Assert.AreEqual(labelId, loadedLabel.Id);
}
public void Delete(RecordingDataSet recordingDataSet, long labelId)
{
RecordingDataSet.Label loadedLabel = FindById(labelId, recordingDataSet);
loadedLabel.Delete();
adapter.Update(recordingDataSet, recordingDataSet.Labels.TableName);
}
public static RecordingDataSet.Recording Make()
{
RecordingDataSet dataSet = new RecordingDataSet();
RecordingDataSet.Recording recording =
dataSet.Recordings.NewRecording();
recording.Id = 1;
recording.Title = "Title";
recording.ReleaseDate = DateTime.Today;
RecordingDataSet.Label label = dataSet.Labels.NewLabel();
label.Id = 1;
label.Name = "Label";
dataSet.Labels.AddLabel(label);
RecordingDataSet.Artist artist = dataSet.Artists.NewArtist();
artist.Id = 1;
artist.Name = "Artist";
dataSet.Artists.AddArtist(artist);
recording.Label = label;
recording.Artist = artist;
dataSet.Recordings.AddRecording(recording);
RecordingDataSet.Genre genre = dataSet.Genres.NewGenre();
genre.Id = 1;
genre.Name = "Genre";
dataSet.Genres.AddGenre(genre);
int trackCount = 2;
ArrayList tracks = new ArrayList(trackCount);
for (int i = 0; i < trackCount; i++)
{
RecordingDataSet.Track track = dataSet.Tracks.NewTrack();
track.Recording = recording;
track.Id = i + 1;
track.Title = "Track Title";
track.Duration = 100;
track.Genre = genre;
track.Artist = artist;
dataSet.Tracks.AddTrack(track);
tracks.Add(track);
}
RecordingDataSet.Reviewer reviewer =
dataSet.Reviewers.NewReviewer();
reviewer.Id = 1;
reviewer.Name = "Reviewer";
dataSet.Reviewers.AddReviewer(reviewer);
int reviewCount = 3;
ArrayList reviews = new ArrayList(reviewCount);
for (int j = 0; j < reviewCount; j++)
{
RecordingDataSet.Review review = dataSet.Reviews.NewReview();
review.Id = j + 1;
review.Content = "Review Content";
review.Rating = j + 1;
review.Reviewer = reviewer;
review.Recording = recording;
dataSet.Reviews.AddReview(review);
reviews.Add(review);
}
return(recording);
}