using System;
using System.IO;

// Notice the namespace for using regular expressions. .NET has an entire namespace dedicated to the topic.
using System.Text.RegularExpressions;


namespace experimentalconsole
{
    class Program
    {
        static void Main(string[] args)
        {
            // Create an instance of our class and run it
            checkCSV csv = new checkCSV();

            // Get the files in the given directory matching the csv extension 
            String[] Filenames = Directory.GetFiles("c:\\Test","*.csv");

            // Loop through all the files returned from that directory
            foreach (String filename in Filenames)
            {
                // Check to make sure each exist
                if (File.Exists(filename))
                {
                    // Run it through our test
                    bool valid = csv.TestFile(filename);

                    // Pull off the filename from the path
                    String basename = Path.GetFileName(filename);

                    // If the file passed testing, write to screen it was valid
                    // Then copy it to the good folder under c:\\Test
                    if (valid)
                    {
                        Console.WriteLine(filename + " is valid");
                     
                        File.Copy(filename, "c:\\Test\\good\\" + basename);
                    }
                    else
                    {
                        // Failed test, move it to the bad folder under c:\\Test
                        Console.WriteLine(filename + " is invalid");
                        File.Copy(filename, "c:\\Test\\bad\\" + basename);
                    }
                }
            }
        }

    }

    class checkCSV
    {
        // Lets setup our pattern first
        private static string csvRegexPattern = @"([^,""]+|""([^""]|"""")*""|,,)";

        // Lets now setup a Regex object using the pattern
        // This creates a Regex object using the pattern passed as a parameter to the constructor
        private static Regex _Regex = new Regex(csvRegexPattern);

        // This method replaced Run in the previous example and now returns a true or false
        // to determine if passed our tests
        public bool TestFile(string AFile)
        {
            String lineRead;
            int lineNumber = 0;

            try
            {
                StreamReader sr = new StreamReader(AFile);

                // Loop through the file, reading each line
                while (null != (lineRead = sr.ReadLine()))
                {
                    // Increment the line number
                    lineNumber++;

                    if (_Regex.Matches(lineRead).Count != 5)
                    {
                        // Return false because it didn't match our field count of 5 
                        // Change this to 14 and use your pattern instead of mine.
                        return false;
                    }
                }
            }
            catch (Exception e)
            {
                // If there was an error, lets see what it was, return false.
                Console.WriteLine("File could not be found: {0}", e.Message.ToString());
                return false;
            }

            // Must have passed our test, return true.
            return true;
        }
    }
}