CooksMate

/*
    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License as published by
    the Free Software Foundation; either version 2 of the License, or
    (at your option) any later version.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA

 * User: andy
 * Date: 30/07/2006
 * Time: 08:37
 */

using System;
using System.Collections;

namespace uk.org.aspellclark.common.file
{
    /// <summary>
    ///   <name>ExcelCsvImportFile</name>
    ///   <namespace>uk.org.aspellclark.common</namespace>
    ///   <version>1.0</version>
    ///   <author>Andy Aspell-Clark</author>
    ///   <description>This is a specialization of the DelimitedFile class that is 
    ///     delimited with tab characters, and ignores all characters that would be 
    ///     invalid .when the data is inserted into a database.
    ///   </description>
    ///   <history>
    ///     <historyitem> 6 Aug 2004  1.0 ARA  Initial Version.</historyitem>
    ///   </history>
    /// </summary>
    public class ExcelCsvImportFile : DelimitedFile
    {
        /// <summary>
        /// constructor. defaults the delimieter to a comma character
        /// </summary>
        public ExcelCsvImportFile()
            :base(",")
        {
            m_sFilename = ".csv";
        }


        private string removeInvalidCharacters(string aLine)
        {
            string tmpStr = aLine;
            //tmpStr = tmpStr.Replace("'", "''");
            //tmpStr = tmpStr.Replace("\"", "");

            return tmpStr;
        }
        

        /// <summary>
        /// reads the first line of the file
        /// </summary>
        /// <returns>a list of the fields in the first line of the file</returns>
        public override ArrayList readFirstLineFromFile()
        {
            ArrayList alFields = new ArrayList();

            String line = readFirstTextLineFromFile();
            if (line != null)
            {
                alFields = convertLineToFields(line);
            }

            return alFields;
        }


        /// <summary>
        /// reads the first line of the file
        /// </summary>
        /// <returns>a list of the fields in the first line of the file</returns>
        public override ArrayList readNextLineFromFile()
        {
            ArrayList alFields = new ArrayList();

            String line = readNextTextLineFromFile();
            if (line != null)
            {
                alFields = convertLineToFields(line);
            }

            return alFields;
        }
    }//class
}//namespace