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));
}
