Domestic Accounting System in C#

This C# program is designed to manage expenses and revenues for a small domestic accounting system. The program allows the user to store up to 10,000 records for expenses and revenues. Each record consists of the date, description, category, and amount (positive for revenue and negative for expense). The program provides operations such as adding a new expense, viewing data by category and date range, searching by description or category, modifying or deleting records, sorting by date and description, and normalizing descriptions. This exercise demonstrates handling financial records and performing basic operations such as validation, sorting, and string manipulation.

Group

C# Arrays, Structures and Strings

Objective

1. Implement a struct to store the date (YYYYMMDD), description, category, and amount for each expense or revenue.
2. Use an array to store up to 10,000 records.
3. Create functions to add, view, search, modify, delete, sort, and normalize records.
4. Ensure the date is validated for correctness, and handle incorrect inputs with appropriate warnings.
5. Implement normalization of descriptions: trimming spaces, adjusting case, and handling uppercase descriptions.

Write a C# program that can store up to 10000 costs and revenues, to create a small domestic accounting system. For each expense (or income), it should store the following information: Date (in YYYYMMDD format), Description, Category, and Amount (positive for income, negative for expense).

Example C# Exercise

Show C# Code

Copy C# Code

using System;
using System.Linq;

class Program
{
    // Define a struct to hold expense or revenue information
    struct AccountingRecord
    {
        public string Date;            // Date in YYYYMMDD format
        public string Description;     // Description of the expense or revenue
        public string Category;        // Category of the expense or revenue
        public decimal Amount;         // Amount of the expense or revenue (positive for income, negative for expense)
    }

static void Main()
    {
        AccountingRecord[] records = new AccountingRecord[10000]; // Array to store up to 10,000 records
        int recordCount = 0; // Counter for the number of records entered

while (true)
        {
            Console.Clear();
            Console.WriteLine("1 - Add New Expense/Revenue");
            Console.WriteLine("2 - Show Expenses/Revenue of a Category Between Two Dates");
            Console.WriteLine("3 - Search Costs by Description or Category");
            Console.WriteLine("4 - Modify a Record");
            Console.WriteLine("5 - Delete a Record");
            Console.WriteLine("6 - Sort Records Alphabetically by Date and Description");
            Console.WriteLine("7 - Normalize Descriptions");
            Console.WriteLine("T - Terminate Application");
            Console.Write("Choose an option: ");
            string choice = Console.ReadLine();

if (choice == "1") // Add a new expense or revenue
            {
                if (recordCount >= 10000)
                {
                    Console.WriteLine("The records list is full. Cannot add more records.");
                    Console.ReadKey();
                    continue;
                }

// Get details from the user for the new record
                AccountingRecord newRecord;

Console.Write("Enter date (YYYYMMDD): ");
                newRecord.Date = Console.ReadLine();
                // Validate the date format
                while (newRecord.Date.Length != 8 || !DateTime.TryParseExact(newRecord.Date, "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out _))
                {
                    Console.Write("Invalid date format. Enter date (YYYYMMDD): ");
                    newRecord.Date = Console.ReadLine();
                }

Console.Write("Enter description: ");
                newRecord.Description = Console.ReadLine();
                // Validate that description is not empty
                while (string.IsNullOrWhiteSpace(newRecord.Description))
                {
                    Console.Write("Description cannot be empty. Enter description: ");
                    newRecord.Description = Console.ReadLine();
                }

Console.Write("Enter category: ");
                newRecord.Category = Console.ReadLine();

Console.Write("Enter amount (positive for income, negative for expense): ");
                newRecord.Amount = decimal.Parse(Console.ReadLine());

records[recordCount] = newRecord; // Store the new record in the array
                recordCount++; // Increment the record count

Console.WriteLine("Record added successfully!");
                Console.ReadKey();
            }
            else if (choice == "2") // Show records for a specific category and date range
            {
                Console.Write("Enter category: ");
                string category = Console.ReadLine();

Console.Write("Enter start date (YYYYMMDD): ");
                string startDate = Console.ReadLine();

Console.Write("Enter end date (YYYYMMDD): ");
                string endDate = Console.ReadLine();

DateTime start = DateTime.ParseExact(startDate, "yyyyMMdd", null);
                DateTime end = DateTime.ParseExact(endDate, "yyyyMMdd", null);

Console.WriteLine("Records between the specified dates:");
                decimal totalAmount = 0;

for (int i = 0; i < recordCount; i++)
                {
                    DateTime recordDate = DateTime.ParseExact(records[i].Date, "yyyyMMdd", null);
                    if (recordDate >= start && recordDate <= end && records[i].Category.Equals(category, StringComparison.OrdinalIgnoreCase))
                    {
                        Console.WriteLine($"{i + 1} - {recordDate:dd/MM/yyyy} - {records[i].Description} - ({records[i].Category}) - {records[i].Amount:F2}");
                        totalAmount += records[i].Amount;
                    }
                }

Console.WriteLine($"Total amount: {totalAmount:F2}");
                Console.ReadKey();
            }
            else if (choice == "3") // Search costs by description or category
            {
                Console.Write("Enter text to search in description or category: ");
                string searchText = Console.ReadLine().ToLower();
                bool found = false;

for (int i = 0; i < recordCount; i++)
                {
                    if (records[i].Description.ToLower().Contains(searchText) || records[i].Category.ToLower().Contains(searchText))
                    {
                        Console.WriteLine($"{i + 1} - {records[i].Date} - {records[i].Description.Substring(0, Math.Min(50, records[i].Description.Length))}");
                        found = true;
                    }
                }

if (!found)
                {
                    Console.WriteLine("No records found matching the search criteria.");
                }
                Console.ReadKey();
            }
            else if (choice == "4") // Modify a record
            {
                Console.Write("Enter record number to modify: ");
                int recordNumber = int.Parse(Console.ReadLine()) - 1;

if (recordNumber >= 0 && recordNumber < recordCount)
                {
                    // Display current record details
                    Console.WriteLine($"Current record: {records[recordNumber].Date} - {records[recordNumber].Description} - {records[recordNumber].Category} - {records[recordNumber].Amount:F2}");

// Update the record fields
                    Console.Write("Enter new description (or press Enter to keep current): ");
                    string newDescription = Console.ReadLine();
                    if (!string.IsNullOrEmpty(newDescription)) records[recordNumber].Description = newDescription;

Console.Write("Enter new category (or press Enter to keep current): ");
                    string newCategory = Console.ReadLine();
                    if (!string.IsNullOrEmpty(newCategory)) records[recordNumber].Category = newCategory;

Console.Write("Enter new amount (or press Enter to keep current): ");
                    string newAmount = Console.ReadLine();
                    if (!string.IsNullOrEmpty(newAmount)) records[recordNumber].Amount = decimal.Parse(newAmount);

Console.WriteLine("Record updated successfully!");
                }
                else
                {
                    Console.WriteLine("Invalid record number.");
                }
                Console.ReadKey();
            }
            else if (choice == "5") // Delete a record
            {
                Console.Write("Enter record number to delete: ");
                int recordNumber = int.Parse(Console.ReadLine()) - 1;

if (recordNumber >= 0 && recordNumber < recordCount)
                {
                    // Display record to be deleted
                    Console.WriteLine($"Record to delete: {records[recordNumber].Date} - {records[recordNumber].Description} - {records[recordNumber].Category} - {records[recordNumber].Amount:F2}");
                    Console.Write("Are you sure you want to delete this record? (y/n): ");
                    string confirmation = Console.ReadLine().ToLower();

if (confirmation == "y")
                    {
                        // Shift remaining records to remove the deleted one
                        for (int i = recordNumber; i < recordCount - 1; i++)
                        {
                            records[i] = records[i + 1];
                        }
                        recordCount--; // Decrement record count
                        Console.WriteLine("Record deleted successfully.");
                    }
                }
                else
                {
                    Console.WriteLine("Invalid record number.");
                }
                Console.ReadKey();
            }
            else if (choice == "6") // Sort records by date and description
            {
                var sortedRecords = records.Take(recordCount)
                                            .OrderBy(r => DateTime.ParseExact(r.Date, "yyyyMMdd", null))
                                            .ThenBy(r => r.Description)
                                            .ToArray();

Console.WriteLine("Records sorted by date and description:");
                foreach (var record in sortedRecords)
                {
                    Console.WriteLine($"{record.Date} - {record.Description} - {record.Category} - {record.Amount:F2}");
                }
                Console.ReadKey();
            }
            else if (choice == "7") // Normalize descriptions
            {
                for (int i = 0; i < recordCount; i++)
                {
                    records[i].Description = NormalizeDescription(records[i].Description);
                }

Console.WriteLine("Descriptions normalized successfully.");
                Console.ReadKey();
            }
            else if (choice.ToUpper() == "T") // Terminate the application
            {
                break;
            }
        }
    }

// Method to normalize the description (remove trailing spaces, and mirror sites)
    static string NormalizeDescription(string description)
    {
        // Remove leading/trailing spaces
        description = description.Trim();

// If description is all uppercase, convert to lowercase (except for the first letter)
        if (description.All(char.IsUpper))
        {
            description = char.ToUpper(description[0]) + description.Substring(1).ToLower();
        }

return description;
    }
}

using System;
using System.Linq;

class Program
{
    // Define a struct to hold expense or revenue information
    struct AccountingRecord
    {
        public string Date;            // Date in YYYYMMDD format
        public string Description;     // Description of the expense or revenue
        public string Category;        // Category of the expense or revenue
        public decimal Amount;         // Amount of the expense or revenue (positive for income, negative for expense)
    }

    static void Main()
    {
        AccountingRecord[] records = new AccountingRecord[10000]; // Array to store up to 10,000 records
        int recordCount = 0; // Counter for the number of records entered

        while (true)
        {
            Console.Clear();
            Console.WriteLine("1 - Add New Expense/Revenue");
            Console.WriteLine("2 - Show Expenses/Revenue of a Category Between Two Dates");
            Console.WriteLine("3 - Search Costs by Description or Category");
            Console.WriteLine("4 - Modify a Record");
            Console.WriteLine("5 - Delete a Record");
            Console.WriteLine("6 - Sort Records Alphabetically by Date and Description");
            Console.WriteLine("7 - Normalize Descriptions");
            Console.WriteLine("T - Terminate Application");
            Console.Write("Choose an option: ");
            string choice = Console.ReadLine();

            if (choice == "1") // Add a new expense or revenue
            {
                if (recordCount >= 10000)
                {
                    Console.WriteLine("The records list is full. Cannot add more records.");
                    Console.ReadKey();
                    continue;
                }

                // Get details from the user for the new record
                AccountingRecord newRecord;

                Console.Write("Enter date (YYYYMMDD): ");
                newRecord.Date = Console.ReadLine();
                // Validate the date format
                while (newRecord.Date.Length != 8 || !DateTime.TryParseExact(newRecord.Date, "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out _))
                {
                    Console.Write("Invalid date format. Enter date (YYYYMMDD): ");
                    newRecord.Date = Console.ReadLine();
                }

                Console.Write("Enter description: ");
                newRecord.Description = Console.ReadLine();
                // Validate that description is not empty
                while (string.IsNullOrWhiteSpace(newRecord.Description))
                {
                    Console.Write("Description cannot be empty. Enter description: ");
                    newRecord.Description = Console.ReadLine();
                }

                Console.Write("Enter category: ");
                newRecord.Category = Console.ReadLine();

                Console.Write("Enter amount (positive for income, negative for expense): ");
                newRecord.Amount = decimal.Parse(Console.ReadLine());

                records[recordCount] = newRecord; // Store the new record in the array
                recordCount++; // Increment the record count

                Console.WriteLine("Record added successfully!");
                Console.ReadKey();
            }
            else if (choice == "2") // Show records for a specific category and date range
            {
                Console.Write("Enter category: ");
                string category = Console.ReadLine();

                Console.Write("Enter start date (YYYYMMDD): ");
                string startDate = Console.ReadLine();

                Console.Write("Enter end date (YYYYMMDD): ");
                string endDate = Console.ReadLine();

                DateTime start = DateTime.ParseExact(startDate, "yyyyMMdd", null);
                DateTime end = DateTime.ParseExact(endDate, "yyyyMMdd", null);

                Console.WriteLine("Records between the specified dates:");
                decimal totalAmount = 0;

                for (int i = 0; i < recordCount; i++)
                {
                    DateTime recordDate = DateTime.ParseExact(records[i].Date, "yyyyMMdd", null);
                    if (recordDate >= start && recordDate <= end && records[i].Category.Equals(category, StringComparison.OrdinalIgnoreCase))
                    {
                        Console.WriteLine($"{i + 1} - {recordDate:dd/MM/yyyy} - {records[i].Description} - ({records[i].Category}) - {records[i].Amount:F2}");
                        totalAmount += records[i].Amount;
                    }
                }

                Console.WriteLine($"Total amount: {totalAmount:F2}");
                Console.ReadKey();
            }
            else if (choice == "3") // Search costs by description or category
            {
                Console.Write("Enter text to search in description or category: ");
                string searchText = Console.ReadLine().ToLower();
                bool found = false;

                for (int i = 0; i < recordCount; i++)
                {
                    if (records[i].Description.ToLower().Contains(searchText) || records[i].Category.ToLower().Contains(searchText))
                    {
                        Console.WriteLine($"{i + 1} - {records[i].Date} - {records[i].Description.Substring(0, Math.Min(50, records[i].Description.Length))}");
                        found = true;
                    }
                }

                if (!found)
                {
                    Console.WriteLine("No records found matching the search criteria.");
                }
                Console.ReadKey();
            }
            else if (choice == "4") // Modify a record
            {
                Console.Write("Enter record number to modify: ");
                int recordNumber = int.Parse(Console.ReadLine()) - 1;

                if (recordNumber >= 0 && recordNumber < recordCount)
                {
                    // Display current record details
                    Console.WriteLine($"Current record: {records[recordNumber].Date} - {records[recordNumber].Description} - {records[recordNumber].Category} - {records[recordNumber].Amount:F2}");

                    // Update the record fields
                    Console.Write("Enter new description (or press Enter to keep current): ");
                    string newDescription = Console.ReadLine();
                    if (!string.IsNullOrEmpty(newDescription)) records[recordNumber].Description = newDescription;

                    Console.Write("Enter new category (or press Enter to keep current): ");
                    string newCategory = Console.ReadLine();
                    if (!string.IsNullOrEmpty(newCategory)) records[recordNumber].Category = newCategory;

                    Console.Write("Enter new amount (or press Enter to keep current): ");
                    string newAmount = Console.ReadLine();
                    if (!string.IsNullOrEmpty(newAmount)) records[recordNumber].Amount = decimal.Parse(newAmount);

                    Console.WriteLine("Record updated successfully!");
                }
                else
                {
                    Console.WriteLine("Invalid record number.");
                }
                Console.ReadKey();
            }
            else if (choice == "5") // Delete a record
            {
                Console.Write("Enter record number to delete: ");
                int recordNumber = int.Parse(Console.ReadLine()) - 1;

                if (recordNumber >= 0 && recordNumber < recordCount)
                {
                    // Display record to be deleted
                    Console.WriteLine($"Record to delete: {records[recordNumber].Date} - {records[recordNumber].Description} - {records[recordNumber].Category} - {records[recordNumber].Amount:F2}");
                    Console.Write("Are you sure you want to delete this record? (y/n): ");
                    string confirmation = Console.ReadLine().ToLower();

                    if (confirmation == "y")
                    {
                        // Shift remaining records to remove the deleted one
                        for (int i = recordNumber; i < recordCount - 1; i++)
                        {
                            records[i] = records[i + 1];
                        }
                        recordCount--; // Decrement record count
                        Console.WriteLine("Record deleted successfully.");
                    }
                }
                else
                {
                    Console.WriteLine("Invalid record number.");
                }
                Console.ReadKey();
            }
            else if (choice == "6") // Sort records by date and description
            {
                var sortedRecords = records.Take(recordCount)
                                            .OrderBy(r => DateTime.ParseExact(r.Date, "yyyyMMdd", null))
                                            .ThenBy(r => r.Description)
                                            .ToArray();

                Console.WriteLine("Records sorted by date and description:");
                foreach (var record in sortedRecords)
                {
                    Console.WriteLine($"{record.Date} - {record.Description} - {record.Category} - {record.Amount:F2}");
                }
                Console.ReadKey();
            }
            else if (choice == "7") // Normalize descriptions
            {
                for (int i = 0; i < recordCount; i++)
                {
                    records[i].Description = NormalizeDescription(records[i].Description);
                }

                Console.WriteLine("Descriptions normalized successfully.");
                Console.ReadKey();
            }
            else if (choice.ToUpper() == "T") // Terminate the application
            {
                break;
            }
        }
    }

    // Method to normalize the description (remove trailing spaces, and mirror sites)
    static string NormalizeDescription(string description)
    {
        // Remove leading/trailing spaces
        description = description.Trim();

        // If description is all uppercase, convert to lowercase (except for the first letter)
        if (description.All(char.IsUpper))
        {
            description = char.ToUpper(description[0]) + description.Substring(1).ToLower();
        }

        return description;
    }
}

Output

1 - 20230101 - Groceries - Food - -50.00
2 - 20230102 - Salary - Income - 2000.00
Records sorted by date and description:
20230101 - Groceries - Food - -50.00
20230102 - Salary - Income - 2000.00
Descriptions normalized successfully.

Example Code Copied

More C# Practice Exercises of C# Arrays, Structures and Strings

Explore our set of C# Practice Exercises! Specifically designed for beginners, these exercises will help you develop a solid understanding of the basics of C#. From variables and data types to control structures and simple functions, each exercise is crafted to challenge you incrementally as you build confidence in coding in C#.

Displaying Numbers in Reverse Order in C#
This exercise focuses on working with arrays in C#. The program will prompt the user to enter 5 numbers, which will be stored in an array. Once all the numbers have been entered, t...
Checking if a Value Exists in a Previously Entered List in C#
This exercise involves creating and searching within a list of floating-point numbers in C#. The program will first ask the user how many numbers they want to enter and store them ...
Displaying Even Numbers from a List of 10 Integers in C#
This exercise focuses on working with arrays and conditionals in C#. The program will prompt the user to enter 10 integer numbers, store them in an array, and then display only the...
Calculating the Average of Positive and Negative Numbers in C#
This exercise focuses on working with arrays, loops, and conditional statements in C#. The program will ask the user to enter 10 real numbers (floating-point), store them in an arr...
Summing Numbers Until 'End' is Entered in C#
In this exercise, you will practice handling user input, loops, and conditionals in C#. The program will continuously ask the user to enter numbers until they type "end". After eac...
Calculating the Average Marks of Two Groups in C#
This exercise focuses on working with two-dimensional arrays in C#. The program will ask the user to enter the marks of 20 pupils, divided into two groups of 10 students each. Afte...

Domestic Accounting System in C#

Group

C# Arrays, Structures and Strings

Objective

Example C# Exercise

Output

Share this C# Exercise

More C# Practice Exercises of C# Arrays, Structures and Strings

Displaying Numbers in Reverse Order in C#

Checking if a Value Exists in a Previously Entered List in C#

Displaying Even Numbers from a List of 10 Integers in C#

Calculating the Average of Positive and Negative Numbers in C#

Summing Numbers Until 'End' is Entered in C#

Calculating the Average Marks of Two Groups in C#