public ActionResult Put([FromBody] StepsDTO stepsDto) { if (StepsDAO.Update(stepsDto)) { return(Ok()); } return(BadRequest()); }
public static StepsDTO Post(StepsDTO step) { using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = REQ_POST; command.Parameters.AddWithValue($@"{FIELD_ID_RECIPE}", step.IdRecipe); command.Parameters.AddWithValue($@"{FIELD_STEP}", step.Step); command.Parameters.AddWithValue($@"{FIELD_STEPNUMBER}", step.StepNumber); step.IdStep = (int)command.ExecuteScalar(); } return(step); }
public static bool Update(StepsDTO step) { bool hasBeenChanged = false; using (SqlConnection connection = DataBase.GetConnection()) { connection.Open(); SqlCommand command = connection.CreateCommand(); command.CommandText = REQ_UPDATE; command.Parameters.AddWithValue($@"{FIELD_ID_RECIPE}", step.IdRecipe); command.Parameters.AddWithValue($@"{FIELD_STEP}", step.Step); command.Parameters.AddWithValue($@"{FIELD_ID_STEP}", step.IdStep); command.Parameters.AddWithValue($@"{FIELD_STEPNUMBER}", step.StepNumber); hasBeenChanged = command.ExecuteNonQuery() == 1; } return(hasBeenChanged); }
public StepsDTO Post([FromBody] StepsDTO stepsDto) { return(StepsDAO.Post(stepsDto)); }