public void Update(CleanersUpdateRequest model, int Id) { string connectionString = _configuration.GetConnectionString("Default"); using (SqlConnection connection = new SqlConnection(connectionString)) { string sql = "AirBnBProfile_Update"; using (SqlCommand command = new SqlCommand(sql, connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Id", Id); command.Parameters.AddWithValue("@UserId", model.UserId); command.Parameters.AddWithValue("@Name", model.Name); command.Parameters.AddWithValue("@YearsInOperation", model.YearsInOperation); command.Parameters.AddWithValue("@ImageUrl", model.ImageUrl); command.Parameters.AddWithValue("@ModifiedBy", model.UserId); command.Parameters.AddWithValue("@City", model.City); command.Parameters.AddWithValue("@Description", model.Description); connection.Open(); command.ExecuteNonQuery(); connection.Close(); } } }
public ActionResult <Cleaners> Update(CleanersUpdateRequest model, int id) { //int iCode = 200; ObjectResult result = null; try { _cleaners.Update(model, id); result = Ok(200); } catch (Exception ex) { result = StatusCode(500, ex.Message.ToString()); } return(result); }