public Song SaveItem(Song song)
{
SqlParameter[] parameters =
{
new SqlParameter("@title", SqlDbType.VarChar, 50)
{
Value = song.Title
},
new SqlParameter("@descr", SqlDbType.VarChar, 50)
{
Value = song.Description
},
new SqlParameter("@album_id", SqlDbType.Int, 50)
{
Value = song.AlbumId
},
};
var sqlInsertString = $"INSERT INTO songs (title, descr, album_id) VALUES (\"{parameters[0].Value}\" , \"{parameters[1].Value}\", \"{parameters[2].Value}\")";
SRInterface srInterface = this;
int id = srInterface.InsertIntoDB(sqlInsertString);
song.SongId = id;
return(song);
}
