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