// PUT: api/Soundtrack/5
//Insertion Cover album via interface
public string Put(string id, [FromBody] CreateSoundtrack value)
{
SqlCommand cmd = new SqlCommand();
conn.Connectdb("update Soundtrack set Numero_track=@Numero_track, Id_album=@Id_album, Name_track=@Name_track, Duration_track=@Duration_track, Path_track=@Path_track where Numero_track='" + id + "'", cmd);
cmd.Parameters.AddWithValue("@Numero_track", value.Numero_track);
cmd.Parameters.AddWithValue("@Id_album", value.Id_album);
cmd.Parameters.AddWithValue("@Name_track", value.Name_track);
cmd.Parameters.AddWithValue("@Duration_track", value.Duration_track);
cmd.Parameters.AddWithValue("@Path_track", value.Path_track);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
return("mise à jour réussie");
}
else
{
return("echec mise à jour");
}
}
// POST: api/Soundtrack
public string Post([FromBody] CreateSoundtrack value)
{
SqlCommand cmd = new SqlCommand();
conn.Connectdb("insert into Soundtrack(Numero_track, Id_album, Name_track, Duration_track, Path_track)values(@Numero_track, @Id_album, @Name_track, @Duration_track, @Path_track)", cmd);
cmd.Parameters.AddWithValue("@Numero_track", value.Numero_track);
cmd.Parameters.AddWithValue("@Id_album", value.Id_album);
cmd.Parameters.AddWithValue("@Name_track", value.Name_track);
cmd.Parameters.AddWithValue("@Duration_track", value.Duration_track);
cmd.Parameters.AddWithValue("@Path_track", value.Path_track);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
return("insertion réussie");
}
else
{
return("echec insertion");
}
}
