public BaseResponse InsertarCliente(ClienteTrilceDto clienteTrilceDto)
        {
            MySqlConnection conn = _mysqlContext.GetConnection();

            conn.Open();

            MySqlCommand cmd = new MySqlCommand("usp_cliente_insertar", conn)
            {
                CommandType = System.Data.CommandType.StoredProcedure
            };

            cmd.Parameters.AddWithValue("_nombre", clienteTrilceDto.Nombre);
            cmd.Parameters.AddWithValue("_apellido", clienteTrilceDto.Apellido);
            cmd.Parameters.AddWithValue("_fechaNacimiento", clienteTrilceDto.FechaNacimiento);

            var reader = cmd.ExecuteReader();

            if (reader.Read())
            {
                return(new BaseResponse()
                {
                    Success = Convert.ToBoolean(reader["success"]),
                    Message = reader["message"].ToString()
                });
            }
            return(null);
        }
Пример #2
0
        public IActionResult InsertarCliente([FromBody] ClienteTrilceDto clienteTrilceDto)
        {
            var response = _clienteTrilceService.InsertarCliente(clienteTrilceDto);

            if (!response.Success)
            {
                return(BadRequest());
            }
            return(Ok());
        }