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);
}
}
