/// <summary>
        /// Recupera um vilão pelo id
        /// </summary>
        /// <param name="villain"></param>
        /// <returns></returns>
        public async Task <GetVillainByIdResponseModel> GetById(GetVillainByIdRequestModel villain)
        {
            var connection = new SqlConnection(_connectionString);

            var query = "select villainid, supervillainname, superpower, weapon, birthdate from villain " +
                        "where villainid = @villainid";

            var result = await connection.QueryAsync <GetVillainByIdResponseModel>(query, new { villainid = villain.VillainId });

            return(result.FirstOrDefault());
        }
        public async Task <IActionResult> GetVillainById(int id)
        {
            try
            {
                GetVillainByIdRequestModel villainId = new GetVillainByIdRequestModel(id);
                var response = await _mediator.Send(villainId);

                return(Ok(response));
            }
            catch (Exception ex)
            {
                return(BadRequest(ex.Message));
            }
        }