public IHttpActionResult Put(BlackListEleve black)
{
if (BlackListEleveDAO.Update(black))
{
return(Ok());
}
return(BadRequest());
}
public static BlackListEleve Insert(BlackListEleve black)
{
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(INSERT, connection);
command.Parameters.AddWithValue("@idEleve", black.IdEleve);
command.Parameters.AddWithValue("@dateBeg", black.DateBeg);
command.Parameters.AddWithValue("@dateEnd", black.DateEnd);
int id = (int)command.ExecuteScalar();
black.Id = id;
}
return(black);
}
public static bool Update(BlackListEleve black)
{
bool state = false;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(UPDATE, connection);
command.Parameters.AddWithValue("@idEleve", black.IdEleve);
command.Parameters.AddWithValue("@dateBeg", black.DateBeg);
command.Parameters.AddWithValue("@dateEnd", black.DateEnd);
command.Parameters.AddWithValue("@id", black.Id);
state = command.ExecuteNonQuery() != 0;
}
return(state);
}
public static BlackListEleve Get(int id)
{
BlackListEleve black = null;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(GET, connection);
command.Parameters.AddWithValue("@id", id);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
black = new BlackListEleve(reader);
}
}
return(black);
}
public BlackListEleve Post(BlackListEleve black)
{
return(BlackListEleveDAO.Insert(black));
}
