public ActionResult <Genre> Create([FromBody] CreateGenre value)
{
try
{
var created = repository.Insert(value);
return(CreatedAtAction(nameof(Get), new { id = created.Id }, created));
}
catch (ArgumentException ex)
{
return(BadRequest(new { error = ex.Message }));
}
}
// PUT: api/Genre/5
public string Put(int id, [FromBody] CreateGenre value)
{
SqlCommand cmd = new SqlCommand();
conn.Connectdb("update Genre set Name_genre=@Name_genre where Id_genre='" + id + "'", cmd);
cmd.Parameters.AddWithValue("@Name_genre", value.Name_genre);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
return("mise à jour réussie");
}
else
{
return("echec mise à jour");
}
}
// POST: api/Genre
public string Post([FromBody] CreateGenre value)
{
SqlCommand cmd = new SqlCommand();
conn.Connectdb("insert into Genre(Name_genre) values( @Name_genre)", cmd);
//Id_genre auto incrémenté par sql server(gestion de l'Id par sql server)
cmd.Parameters.AddWithValue("@Name_genre", value.Name_genre);
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
return("insertion réussie");
}
else
{
return("echec insertion");
}
}
public Genre Insert(CreateGenre value)
{
using (var tran = db.Database.BeginTransaction(System.Data.IsolationLevel.RepeatableRead))
{
if (db.Genres.Any(t => EF.Functions.Like(t.Name, value.Name)))
{
throw new ArgumentException("name must be unique");
}
var toInsert = new DbGenre()
{
Name = value.Name
};
db.Genres.Add(toInsert);
db.SaveChanges();
tran.Commit();
return(ToModel(toInsert));
}
}
