Mark Hartkemeyer

AsqDataEntryApp

Summary:

• This application creates Excel files from data input from Ages and Stages Questionnaires.

List of Benefits:

• Data entry staff can quickly and easily input important data from Ages and Stages Questionnaires into an Excel spreadsheet.
• Data analysts can then take that data and perform analysis on it.

Challenges I Overcame:

• How do I validate the data input by the data entry staff?

On my text boxes, I used a Validating event, checking the length of the text in the textbox:

    private void TextBox_Validating(object? sender, CancelEventArgs e)
    {
        TextBox textBox = sender as TextBox;

        if (textBox.Text.Length == 0)
        {
            e.Cancel = true;
        }
    }
                    

I use something similar on my combo boxes. In my submit button's click event, I set a bool to see if validation succeded or failed:

    bool inputIsValid = ValidateInput();

    if (inputIsValid == true)
    {
        ...
    }
    else
    {
        MessageBox.Show("Validation failed.");
    }
                    

• Per my requirements, I needed an age, plus an "age code" of months ('M') or years ('Y'). How do I find the age of the child from a date of birth?

I did this:

    private (string, string) GetAgeAndAgeCode(DateTime dateOfBirth, DateTime dateAsqCompleted)
    {
        int age = GetAgeInMonths(dateOfBirth, dateAsqCompleted);
        string ageCode = "M";

        if (age > 11)
        {
            age = GetAgeInYears(dateOfBirth, dateAsqCompleted);
            ageCode = "Y";
        }

        return (age.ToString(), ageCode);
    }

    private int GetAgeInMonths(DateTime dateOfBirth, DateTime dateAsqCompleted)
    {
        int age = ((dateAsqCompleted.Year - dateOfBirth.Year) * 12) + dateAsqCompleted.Month - dateOfBirth.Month;

        return age;
    }

    private int GetAgeInYears(DateTime dateOfBirth, DateTime dateAsqCompleted)
    {
        int age = dateAsqCompleted.Year - dateOfBirth.Year;

        // Go back to the year in which the person was born in case of a leap year
        if (dateOfBirth.Date > dateAsqCompleted.AddYears(-age)) age--;

        return age;
    }
                    

I then took the age and age code and inserted them into cells in Excel spreadsheet:

    public void AddRow(AsqModel asqModel)
    {
        Workbook = App.Workbooks.Open(FilePath);
        Worksheet = (Excel.Worksheet)Workbook.Worksheets[1];

        Excel.Range range = (Excel.Range)Worksheet.Cells[Worksheet.Rows.Count, 1];
        int lastRow = range.get_End(Excel.XlDirection.xlUp).Row;
        int newRow = lastRow + 1;

        ...

        (string age, string ageCode) = GetAgeAndAgeCode(asqModel.DateOfBirth, asqModel.DateAsqCompleted);
        App.Cells[newRow, 4] = age;
        App.Cells[newRow, 5] = ageCode;

        ...

        Workbook.Close(true);
    }