// TLReader - reads access database containing tug info
// Copyright (C) 2004  Ian Cowburn
// 
// 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., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
//
using System;
using System.Data;
using System.Data.Common;
using System.Data.Odbc;
using System.Collections;
using System.Collections.Specialized;
using System.Windows.Forms;

namespace TLReader
{
	/// <summary>
	/// Description of TugTable.	
	/// </summary>
	public class TugTable
	{
		public TugTable(OdbcConnection con, Table t)
		{
			string sql="select ";
			bool first=true;
			
			m_fields=new StringCollection();
			m_fields.AddRange(t.Fields.Split(new char[] {','}));
			
			foreach (string s in m_fields)
			{
				if (first)
				{
					sql+="["+s+"]";
				}
				else
				{
					sql+=", ["+s+"]";
				}
				
				first=false;
			}
			
			sql+=" from "+t.Name;
			
			OdbcCommand cmd=new OdbcCommand(sql,con);
			OdbcDataReader r=cmd.ExecuteReader();
			
			m_data=new ArrayList();
			
			while(r.Read())
			{
				StringCollection row=new StringCollection();
				
				for(int f=0;f<m_fields.Count;f++)
				{
					string val="No data";
					
					if (!r.IsDBNull(f))
					{
						val=r.GetValue(f).ToString();
					}
					
					row.Add(val);
				}
				
				m_data.Add(row);
			}
			
			r.Close();
		}
		
		public int Count
		{
			get {return m_data.Count;}
		}
		
		public StringCollection Fields
		{
			get {return m_fields;}
		}
		
		public string Get(string field,int index)
		{
			StringCollection d=(StringCollection)m_data[index];
			
			return d[m_fields.IndexOf(field)];
		}
		
		public string Get(string field,string index_as_string)
		{
			return Get(field,Convert.ToInt32(index_as_string));
		}
		
		public StringCollection Row(int row)
		{
			return (StringCollection)m_data[row];
		}
		
		private ArrayList			m_data;
		private StringCollection	m_fields;
	}
}