Create and register window service

 Visual Studio:

  • Create New Project

  • Select Worker Service

  • Target .NET 6/7/8


  • Modify Program.cs file:
    using Microsoft.Extensions.Hosting;

    Host.CreateDefaultBuilder(args)
    .UseWindowsService() // Important
    .ConfigureServices((hostContext, services) =>
    {
    services.AddHostedService<Worker>();
    })
    .Build()
    .Run();
  • using Microsoft.Extensions.DependencyInjection;
Implement Database Update Logic
using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Logging;
using Microsoft.Data.SqlClient;
using System;
using System.Threading;
using System.Threading.Tasks;

public class Worker : BackgroundService
{
    private readonly ILogger<Worker> _logger;
    private readonly string _connectionString =
        "Server=YOUR_SERVER;Database=YOUR_DB;Trusted_Connection=True;";

    public Worker(ILogger<Worker> logger)
    {
        _logger = logger;
    }

    protected override async Task ExecuteAsync(CancellationToken stoppingToken)
    {
        _logger.LogInformation("Service Started");

        while (!stoppingToken.IsCancellationRequested)
        {
            try
            {
                await UpdateDatabase();
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Error updating database");
            }

            await Task.Delay(TimeSpan.FromMinutes(5), stoppingToken); // Run every 5 min
        }
    }

    private async Task UpdateDatabase()
    {
        using var connection = new SqlConnection(_connectionString);
        await connection.OpenAsync();

        using var command = new SqlCommand(
            "UPDATE YourTable SET Status = 1 WHERE Status = 0",
            connection);

        var rows = await command.ExecuteNonQueryAsync();
        _logger.LogInformation($"Updated {rows} rows");
    }
}
Publish the Service:
bin\Release\net8.0\win-x64\publish\

Register the Windows Service:(Use power shell)
New-Service -Name "DatabaseUpdateService" `
  -BinaryPathName "C:\Path\To\publish\DatabaseUpdateService.exe" `
  -DisplayName "Database Update Service" `
  -StartupType Automatic

Comments

Post a Comment

Popular posts from this blog

Key points while writting prompt for AI

  1️⃣ Be Clear & Specific Don’t be vague. Say exactly what you want. ❌ “Extract details from this text” ✅ “Extract vehicle registration number, make, and damage details from the text and return JSON” 2️⃣ Define the Role of the AI Tell the AI who it should act as . ✅ “You are a police incident data extractor” ✅ “Act as a senior Python developer reviewing extraction logic” This sets context and improves accuracy. 3️⃣ Specify the Output Format Always mention how the response should look . JSON / Table / Bullet points Field names Yes/No instead of true/false e.g: Return the output in strict JSON with no extra text. 4️⃣ Add Rules & Constraints Very important for consistency. What must be included What must not be done Edge cases Example: Do NOT merge vehicles Capture vehicles even if repeated in different sections 5️⃣ Handle Edge Cases Explicitly AI guesses if you don’t guide it. ✅ “If registration number is missing, set it to null” ...
Read more

How Create API in python using flask library

 from flask import Flask, request, jsonify app = Flask(__name__) # In-memory database items = {} # Get all items @app.route('/items', methods=['GET']) def get_items():     return jsonify(list(items.values())), 200 # Get a single item by ID @app.route('/items/<int:item_id>', methods=['GET']) def get_item(item_id):     item = items.get(item_id)     if item:         return jsonify(item), 200     return jsonify({'error': 'Item not found'}), 404 # Create a new item @app.route('/items', methods=['POST']) def create_item():     data = request.json     item_id = len(items) + 1     items[item_id] = {'id': item_id, 'name': data.get('name'), 'description': data.get('description')}     return jsonify(items[item_id]), 201 # Update an existing item @app.route('/items/<int:item_id>', methods=['PUT']) def update_item(item_id):     if item_id not in items:       ...
Read more

Book teams appointment with email notification

 using System; using System.Net; using System.Net.Mail; using System.Text; class Program {     static void Main()     {         string teamsLink = "https://teams.microsoft.com/l/meetup-join/xxxxxxxx";         DateTime startUtc = new DateTime(2026, 1, 10, 10, 0, 0, DateTimeKind.Utc);         DateTime endUtc = startUtc.AddMinutes(30);         string ics = $@" BEGIN:VCALENDAR PRODID:-//YourApp//EN VERSION:2.0 METHOD:REQUEST BEGIN:VEVENT UID:{Guid.NewGuid()} DTSTAMP:{DateTime.UtcNow:yyyyMMddTHHmmssZ} DTSTART:{startUtc:yyyyMMddTHHmmssZ} DTEND:{endUtc:yyyyMMddTHHmmssZ} SUMMARY:Project Discussion DESCRIPTION:Join the Teams meeting:\n\n{teamsLink} LOCATION:Microsoft Teams Meeting ORGANIZER;CN=Organizer:mailto:organizer@example.com ATTENDEE;ROLE=REQ-PARTICIPANT:mailto:user@example.com STATUS:CONFIRMED URL:{teamsLink} END:VEVENT END:VCALENDAR";         var mail = new MailMe...
Read more