Technology Stack

await using var connection = new SqlConnection(_connectionString);
await connection.OpenAsync(cancellationToken);

await using var command = new SqlCommand("sp_Tours_GetAll", connection)
{
    CommandType = CommandType.StoredProcedure
};

await using var reader = await command.ExecuteReaderAsync(cancellationToken);

public string GenerateToken(UserIdentity user)
{
    var tokenHandler = new JwtSecurityTokenHandler();
    var key = Encoding.UTF8.GetBytes(_jwtOptions.SecretKey);
    
    var tokenDescriptor = new SecurityTokenDescriptor
    {
        Subject = new ClaimsIdentity(new[]
        {
            new Claim(ClaimTypes.NameIdentifier, user.UserId.ToString()),
            new Claim(ClaimTypes.Email, user.Email)
        }),
        Expires = DateTime.UtcNow.AddMinutes(_jwtOptions.ExpirationMinutes),
        Issuer = _jwtOptions.Issuer,
        Audience = _jwtOptions.Audience,
        SigningCredentials = new SigningCredentials(
            new SymmetricSecurityKey(key),
            SecurityAlgorithms.HmacSha256Signature)
    };
    
    var token = tokenHandler.CreateToken(tokenDescriptor);
    return tokenHandler.WriteToken(token);
}

public async Task SendEmailAsync(string to, string subject, string htmlBody)
{
    using var client = new SmtpClient();
    
    await client.ConnectAsync(
        _smtpOptions.Host, 
        _smtpOptions.Port, 
        _smtpOptions.UseStartTls ? SecureSocketOptions.StartTls : SecureSocketOptions.None);
    
    if (!string.IsNullOrEmpty(_smtpOptions.User))
    {
        await client.AuthenticateAsync(_smtpOptions.User, _smtpOptions.Password);
    }
    
    var message = new MimeMessage();
    message.From.Add(new MailboxAddress(_smtpOptions.FromName, _smtpOptions.FromEmail));
    message.To.Add(MailboxAddress.Parse(to));
    message.Subject = subject;
    message.Body = new TextPart(TextFormat.Html) { Text = htmlBody };
    
    await client.SendAsync(message);
    await client.DisconnectAsync(true);
}

public static string GetImageUrlOrPlaceholder(string? imageUrl)
{
    if (string.IsNullOrWhiteSpace(imageUrl))
    {
        return "assets/img/placeholder-tour.jpg";
    }
    
    return imageUrl.StartsWith("http") 
        ? imageUrl 
        : $"/uploads/{imageUrl}";
}

"PayPal": {
  "Mode": "sandbox",
  "ClientId": "...",
  "ClientSecret": "...",
  "BaseUrl": "https://api-m.sandbox.paypal.com"
}