public IHttpActionResult Put(Auctioned_object todo) { if (Auctioned_ObjectDAO.Update(todo)) { return(Ok()); } return(BadRequest()); }
//Ajout d'un membre public static Auctioned_object Insert(Auctioned_object todo) { using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = new SqlCommand(INSERT, connection); command.Parameters.AddWithValue("@nameObject", todo.nameObject); command.Parameters.AddWithValue("@descriptionObject", todo.descriptionObject); command.Parameters.AddWithValue("@priceObject", todo.priceObject); command.Parameters.AddWithValue("@idUser", todo.idUser); command.Parameters.AddWithValue("@catObject", todo.catObject); todo.idObject = (int)command.ExecuteScalar(); } return(todo); }
//Renvoie un membre selon son id public static Auctioned_object Get(int id) { Auctioned_object m = null; using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = new SqlCommand(GET, connection); command.Parameters.AddWithValue("@idObject", id); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { m = new Auctioned_object(reader); } } return(m); }
public static bool Update(Auctioned_object todo) { bool state = false; using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = new SqlCommand(UPDATE, connection); command.Parameters.AddWithValue("@nameObject", todo.nameObject); command.Parameters.AddWithValue("@descriptionObject", todo.descriptionObject); command.Parameters.AddWithValue("@priceObject", todo.priceObject); command.Parameters.AddWithValue("@idUser", todo.idUser); command.Parameters.AddWithValue("@catObject", todo.catObject); state = command.ExecuteNonQuery() != 0; } return(state); }
public Auctioned_object Post(Auctioned_object todo) { return(Auctioned_ObjectDAO.Insert(todo)); }