public IHttpActionResult Put(BlackListTutor black)
{
if (BlackListTutorDAO.Update(black))
{
return(Ok());
}
return(BadRequest());
}
public static BlackListTutor Insert(BlackListTutor black)
{
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(INSERT, connection);
command.Parameters.AddWithValue("@idTutor", black.IdTutor);
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(BlackListTutor black)
{
bool state = false;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(UPDATE, connection);
command.Parameters.AddWithValue("@idTutor", black.IdTutor);
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 BlackListTutor Get(int id)
{
BlackListTutor 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 BlackListTutor(reader);
}
}
return(black);
}
public BlackListTutor Post(BlackListTutor black)
{
return(BlackListTutorDAO.Insert(black));
}