public bool DeleteAlbum(Album album)
{
try
{
albumTable.DeleteOnSubmit(album);
albumTable.Context.SubmitChanges();
return true;
}
catch
{
return false;
}
}
private void btnUploadAlbum_Click(object sender, EventArgs e)
{
ClearAlbumsResultTextBoxes();
var artist = WCFWebServiceJson.GetArtist(Convert.ToInt32(TxtAlbumWordpressId.Text));
var albumGenreCollection = (from ListItem listItem in lbAlbumGenres.SelectedItems select WCFWebServiceJson.GetGenre(listItem.SelectedValue())).ToList();
var album = new Album()
{
AlbumLabel = txtAlbumLabel.Text,
AlbumProducer = txtAlbumProducer.Text,
AlbumReleaseDate = Convert.ToDateTime(dtpAlbumReleaseDate.Text),
AlbumTitle = txtAlbumTitle.Text,
CreatedDate = DateTime.Now,
GenreCollection = albumGenreCollection
};
if (WCFWebServiceJson.SaveArtistAlbum(album, artist, null))
{
txtAlbumResult.Text = album.AlbumTitle + @" has been saved successfully!";
}
else
{
txtAlbumResult.Text = @"There was a problem saving the album: " + album.AlbumTitle;
}
}
public int SaveAlbum(Album album)
{
try
{
if (album.AlbumId == 0)
{
albumTable.InsertOnSubmit(album);
}
else
{
albumTable.Context.Refresh(RefreshMode.KeepCurrentValues, album);
}
albumTable.Context.SubmitChanges();
return album.AlbumId;
}
catch
{
return -1;
}
}
public bool DeleteSong(Song song, Album album)
{
using (var tranScope = new TransactionScope())
{
try
{
if (DeleteAlbumSong(song, album))
{
var songMediaAsset = SqlSongMediaAssetRepository.SongMediaAsset.FirstOrDefault(x => x.SongId == song.SongId);
if (SqlSongMediaAssetRepository.DeleteSongMediaAsset(songMediaAsset))
{
if (SqlMediaAssetRepository.DeleteMediaAsset(SqlMediaAssetRepository.MediaAsset.FirstOrDefault(x => x.MediaAssetId == songMediaAsset.MediaAssetId)))
{
if (SqlSongRepository.DeleteSong(song))
{
tranScope.Complete();
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
else
{
return false;
}
}
else
{
return false;
}
}
catch
{
return false;
}
}
}
public bool DeleteArtistAlbum(Album album, Artist artist)
{
using (var tranScope = new TransactionScope())
{
var artistAlbum =
SqlArtistAlbumRepository.ArtistAlbum.FirstOrDefault(
x => x.AlbumId == album.AlbumId && x.UserId == artist.UserId);
try
{
if (SqlArtistAlbumRepository.DeleteArtistAlbum(artistAlbum))
{
if (SqlAlbumRepository.DeleteAlbum(album))
{
tranScope.Complete();
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
catch
{
return false;
}
}
}
public bool DeleteAlbumSong(Song song, Album album)
{
var albumSong =
SqlAlbumSongRepository.AlbumSong.FirstOrDefault(
x => x.SongId == song.SongId && x.AlbumId == album.AlbumId);
return SqlAlbumSongRepository.DeleteAlbumSong(albumSong);
}
public bool SaveArtistAlbum(Album album, Artist artist, string sourceFile)
{
using (var tranScope = new TransactionScope())
{
try
{
var albumId = SqlAlbumRepository.SaveAlbum(album);
if (albumId > 0)
{
if (SaveAlbumGenreCollection(albumId, album.GenreCollection))
{
var util = new Utilities();
var artistAlbum = new ArtistAlbum()
{
AlbumId = albumId,
UserId = artist.UserId
};
if (UploadFileToS3(sourceFile, util.RemoveSpaces(artist.ArtistName) + "/" + util.RemoveSpaces(album.AlbumTitle) + "/", "stream"))
{
if (SqlArtistAlbumRepository.SaveArtistAlbum(artistAlbum))
{
tranScope.Complete();
return true;
}
}
}
}
}
catch
{
return false;
}
}
return false;
}