public void AddSong(Song song, int albumId)
{
using (var conn = CreateConnection())
{
SqlCommand cmd = new SqlCommand("addSongWithAlbum", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@songName", SqlDbType.VarChar, 50).Value = song.SongName;
cmd.Parameters.Add("@songLength", SqlDbType.Int, 4).Value = song.Length;
cmd.Parameters.Add("@bandName", SqlDbType.VarChar, 50).Value = song.BandName;
cmd.Parameters.Add("@albumId", SqlDbType.Int, 4).Value = albumId;
cmd.Parameters.Add("@trackNr", SqlDbType.TinyInt, 1).Value = song.TrackNr;
cmd.Parameters.Add("@songId", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
song.SongId = (int)cmd.Parameters["@songId"].Value;
}
}
public void saveSong(Song song, int albumId)
{
ICollection<ValidationResult> validationResult;
if (!song.Validate(out validationResult))
{
var vx = new ValidationException("Objectet klarade inte validering.");
vx.Data.Add("validationResult", validationResult);
throw vx;
}
if (song.SongId == 0)
{
Song.AddSong(song, albumId);
}
else
{
Song.UpdateSong(song, albumId);
}
}
public void UpdateSong(Song song, int albumId)
{
using (var conn = CreateConnection())
{
SqlCommand cmd = new SqlCommand("updateSong", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@songId", SqlDbType.Int, 4).Value = song.SongId;
cmd.Parameters.Add("@songName", SqlDbType.VarChar, 50).Value = song.SongName;
cmd.Parameters.Add("@bandName", SqlDbType.VarChar, 50).Value = song.BandName;
cmd.Parameters.Add("@length", SqlDbType.Int, 2).Value = song.Length;
cmd.Parameters.Add("@trackNr", SqlDbType.TinyInt, 1).Value = song.TrackNr;
conn.Open();
cmd.ExecuteNonQuery();
}
}
