public ActionResult <Cleaners> Create(CleanersAddRequest model) { ObjectResult result = null; try { int Id = _cleaners.Add(model); result = Created("success", "id:" + Id); } catch (Exception ex) { result = StatusCode(500, ex.Message.ToString()); } return(result); }
public int Add(CleanersAddRequest model) { string connectionString = _configuration.GetConnectionString("Default"); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand sqlCommand = connection.CreateCommand(); sqlCommand.CommandText = "AirBnBProfile_Insert"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@UserId", model.UserId); sqlCommand.Parameters.AddWithValue("@Name", model.Name); sqlCommand.Parameters.AddWithValue("@YearsInOperation", model.YearsInOperation); sqlCommand.Parameters.AddWithValue("@ImageUrl", model.ImageUrl); sqlCommand.Parameters.AddWithValue("@CreatedBy", model.UserId); sqlCommand.Parameters.AddWithValue("@ModifiedBy", model.UserId); sqlCommand.Parameters.AddWithValue("@City", model.City); sqlCommand.Parameters.AddWithValue("@Description", model.Description); SqlParameter IdParam = sqlCommand.Parameters.Add("@Id", SqlDbType.Int); // UserIdParam.Direction = ParameterDirection.Output; IdParam.Direction = ParameterDirection.Output; sqlCommand.ExecuteNonQuery(); return((int)IdParam.Value); } }