Habit Logger v2 – جامعه dev

static void CreateTables(SQLiteConnection connection)
{
    using (var command = connection.CreateCommand())
    {
        command.CommandText = @"
            CREATE TABLE IF NOT EXISTS Habits (
                Id INTEGER PRIMARY KEY AUTOINCREMENT,
                Habit TEXT NOT NULL,
                Unit TEXT NOT NULL
            );

            CREATE TABLE IF NOT EXISTS HabitInstances (
                Id INTEGER PRIMARY KEY AUTOINCREMENT,
                HabitId INTEGER NOT NULL,
                Date TEXT NOT NULL,
                Quantity INTEGER NOT NULL,
                FOREIGN KEY (HabitId) REFERENCES Habits(Id) ON DELETE CASCADE
            );";

        command.ExecuteNonQuery();
    }
}

using (var connection = new SQLiteConnection($"Data Source={dbPath}"))
{

}

try
{
    //new connection
    //do something
}
catch (Exception e)
{
    //handle error here
}
finally
{
    connection.Close()
}

void AddHabit()
{
    using (var connection = new SQLiteConnection($"Data Source={dbPath}"))
    {
        connection.Open();

        Console.Clear();
        PrintHabits("Add Habit");

        Console.WriteLine("\nEnter the new habit name:");
        string? habitName = Console.ReadLine();
        Console.WriteLine("\nEnter the unit of measurement (e.g., miles, pages, minutes, etc.)");
        string? unit = Console.ReadLine();

        using (var command = connection.CreateCommand())
        {
            command.CommandText = "INSERT INTO Habits (Habit, Unit) VALUES (@habit, @unit)";
            command.Parameters.AddWithValue("@habit", habitName);
            command.Parameters.AddWithValue("@unit", unit);
            command.ExecuteNonQuery();
        }

        Console.WriteLine("\nHabit added successfully!");
    }
}