public void UpdateUserStatus(SecurityModels.UpdateUserStatusRequest updateUserStatusRequest) { try { using (SqlConnection con = new SqlConnection(securityConnectionString)) { using (SqlCommand cmd = new SqlCommand("UpdateUserStatus", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Id", SqlDbType.Int).Value = updateUserStatusRequest.id; cmd.Parameters.Add("@Active", SqlDbType.Bit).Value = updateUserStatusRequest.active; con.Open(); cmd.ExecuteNonQuery(); } con.Close(); } } catch { throw; } }
public IActionResult UpdateUserStatus([FromBody] SecurityModels.UpdateUserStatusRequest updateUserStatusRequest) { securityInventoryRepo.UpdateUserStatus(updateUserStatusRequest); return(StatusCode(StatusCodes.Status200OK, "")); }