How do I skip a blank cell?

[FlawlessCasual17]

To keep it short, I'm trying to store the values from the record “HoursWorked” as int variable. However, the CSVReader keeps bumping into an error when it catches a blank cell, causing the program to crash.

Here are my C# source files,

Application.cs:

using CsvHelper;
using CsvHelper.Configuration;
using CsvHelper.TypeConversion;
using System.Globalization;


namespace Inheritence {
    public abstract class Application {
        private static void Main() {
            var readFile = new StreamReader(Path.Join("res", "employees.csv"));
            // var csvHelperTypeConverterOptions = new TypeConverterOptions { NullValues = { string.Empty, "''" } };
            var csvHelperConfig = new CsvConfiguration(CultureInfo.CurrentCulture) {
                Delimiter = ";", HasHeaderRecord = true, MissingFieldFound = null,
                IgnoreBlankLines = true
            };

            var readCsvData = new CsvReader(readFile, csvHelperConfig);
            var csvRecords = readCsvData.GetRecords<Employees>();

            foreach (var rec in csvRecords) {
                Console.WriteLine($"Employee ID: {rec.EmployeeID}");
                Console.WriteLine($"Name: {rec.Name}");
                Console.WriteLine($"Address: {rec.Address}");
                Console.WriteLine($"Phone: {rec.Phone}");
                Console.WriteLine($"SSN: {rec.SSN}");
                Console.WriteLine($"Date of Birth: {rec.DateOfBirth}");
                Console.WriteLine($"Department: {rec.Department}");
                Console.WriteLine($"Salary: {rec.Salary}");
                Console.WriteLine($"Hours Worked: {rec.HoursWorked}\n");
            }
        }
    }
}

Employees.cs

// This will be used for accessing the Employees class.

namespace Inheritence {
    // public sealed class TheEmployee {
    //     public int Salaried;
    //     public int PartTime;
    //     public int Wages;
    // }

    // ReSharper disable once ClassNeverInstantiated.Global

    /// For information about employees.
    public class Employees {
        // ReSharper disable all UnusedAutoPropertyAccessor.Global (DO NOT REMOVE THIS COMMENT)
        // ReSharper disable all InconsistentNaming (DO NOT REMOVE THIS COMMENT)

        /// The employee ID.
        public int EmployeeID { get; set; }
        /// The name of the employee.
        public string Name { get; set; }
        /// The address of the employee.
        public string Address { get; set; }
        /// The phone number of the employee.
        public string Phone { get; set; }
        /// The SSN(Social Security Number) of the employee.
        public string SSN { get; init; }
        /// The employee's date of birth.
        public string DateOfBirth { get; set; }
        /// The department the employee currently works.
        public string Department { get; set; }
        /// The employee's salary.
        public double Salary { get; set; }
        /// The number of hours the employee has worked.
        public int HoursWorked { get; set; }
    }
}

Also, here is the CSV file I am trying to parse (the file is autogenerated, it doesn't contain any information about any real people):
employees.csv

Error log:

C:\Users\USER\scoop\apps\jetbrains-toolbox\current\apps\Rider\plugins\dpa\DotFiles\JetBrains.DPA.Runner.exe --handle=2612 --backend-pid=14392 --etw-collect-flags=3 --detach-event-name=dpa.detach.2612 C:/Users/USER/OOP_Labs/Lab_2/Inheritence/bin/Debug/net6.0/Inheritence.exe
Employee ID: 634567
Name: Fred Flintstone                 
Address: 34 Flintrock Way, Bedrock, BC
Phone: (345) 295-9076                 
SSN: 678453234                        
Date of Birth: June 15, 2000 BC       
Department: Pediatrics                
Salary: 27.85                         
Hours Worked: 44                      

Unhandled exception. CsvHelper.TypeConversion.TypeConverterException: The conversion cannot be performed.
    Text: ''
    MemberName: HoursWorked
    MemberType: System.Int32
    TypeConverter: 'CsvHelper.TypeConversion.Int32Converter'
IReader state:
   ColumnCount: 0
   CurrentIndex: 8
   HeaderRecord:
["EmployeeID","Name","Address","Phone","SSN","DateOfBirth","Department","Salary","HoursWorked"]
IParser state:
   ByteCount: 0
   CharCount: 334
   Row: 3
   RawRow: 3
   Count: 9
   RawRecord:
217546;Samuel Ludlow III;"2345 The Rich Man Way, RichVille, RC";(567) 324-9812;768956453;"February 29, 1942";Collections Section;20500;


   at CsvHelper.TypeConversion.DefaultTypeConverter.ConvertFromString(String text, IReaderRow row, MemberMapData memberMapData)
   at CsvHelper.TypeConversion.Int32Converter.ConvertFromString(String text, IReaderRow row, MemberMapData memberMapData)
   at lambda_method9(Closure )
   at CsvHelper.Expressions.RecordCreator.Create[T]()
   at CsvHelper.Expressions.RecordManager.Create[T]()
   at CsvHelper.CsvReader.GetRecords[T]()+MoveNext()
   at Inheritence.Application.Main() in C:\Users\USER\OOP_Labs\Lab_2\Inheritence\Application.cs:line 20

Process finished with exit code -532,462,766.

[AltruCoder]

You have two choices.

1. Make HoursWorked a Nullable<int> . Then any blank cells will come in as a null value.

public int? HoursWorked { get; set; }

2. Set a default value for HoursWorked. Then any blank cells will come in as the default value you have set.

[Default(0)]
public int HoursWorked { get; set; }

[FlawlessCasual17]

Thank you very much @AltruCoder.

[FlawlessCasual17]

This helped solve my problem, now the program runs as expected.

C:\Users\USER\scoop\apps\jetbrains-toolbox\current\apps\Rider\plugins\dpa\DotFiles\JetBrains.DPA.Runner.exe --handle=14624 --backend-pid=13260 --etw-collect-flags=3 --detach-event-name=dpa.detach.14624 C:/Users/USER/OOP_Labs/Lab_2/Inheritence/bin/Debug/net6.0/Inheritence.exe
Employee ID: 634567
Name: Fred Flintstone                 
Address: 34 Flintrock Way, Bedrock, BC
Phone: (345) 295-9076                 
SSN: 678453234                        
Date of Birth: June 15, 2000 BC       
Department: Pediatrics                
Salary: 27.85                         
Hours Worked: 44                      

Employee ID: 217546
Name: Samuel Ludlow III
Address: 2345 The Rich Man Way, RichVille, RC
Phone: (567) 324-9812
SSN: 768956453
Date of Birth: February 29, 1942
Department: Collections Section
Salary: 20500
Hours Worked: 0

Employee ID: 86595
Name: Bill Partley
Address: 11 Partway Road, Almost, NW
Phone: (111) 232-9876
SSN: 876345987
Date of Birth: July 10, 1966
Department: Parts Stuff
Salary: 20.55
Hours Worked: 18

Employee ID: 999999
Name: Dr. Evil
Address: Some Where in the Caribean
Phone: (999) 999-9999
SSN: 98989898
Date of Birth: February 29, 1977
Department: World Chaos Care
Salary: 1000000
Hours Worked: 0

Employee ID: 9536476
Name: Perky Volunteer
Address: 343 Volly Road, Volunteersalot
Phone: (212) 345-9876
SSN: 867643782
Date of Birth: October 14, 1947
Department: Volunteer Organization
Salary: 16.8
Hours Worked: 22

Employee ID: 54153
Name: BobBob Never
Address: 22 NeverReally Lane, Neverland
Phone: (234) 674-7865
SSN: 98765678
Date of Birth: September 3, 1988
Department: Never Media
Salary: 30.6
Hours Worked: 48

Employee ID: 775342
Name: Winnie Van Winnipeg
Address: 100 Aker Wood West, Winnipeg
Phone: (999) 555-8888
SSN: 234777444
Date of Birth: January 4, 2000
Department: Forestry
Salary: 28.45
Hours Worked: 38

Employee ID: 1234987
Name: Sam Packitaway
Address: 345 Stash Road, Piles, Alot
Phone: (660) 546-9867
SSN: 999888777
Date of Birth: March 19, 1958
Department: Capital Acquisition
Salary: 25675
Hours Worked: 0

Employee ID: 5489867
Name: Elle Driver
Address: 32 Mountain Drive, Los Angeles
Phone: (765) 456-7766
SSN: 765098345
Date of Birth: October 5, 2000
Department: International Sales
Salary: 40.25
Hours Worked: 52


Process finished with exit code 0.