Create Data Classes

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Text;
using System.Windows.Forms;

/*
 * Copyright Jeff Gaines 2007 - 2011 (jeff@jgaines.co.uk)
 * Free licence for private use
 * Please contact the author if you wish to use the code commercially
*/

namespace JGCreateDataClasses
{
	/// <summary>
	/// Form for reading in an XML database schema
	/// </summary>
	internal partial class FormReadXMLSchema : Form
	{
		private List<string> m_TableNamesList = new List<string>();

		private ListView m_ListView;

		private string m_XMLTableName = "";

		//	Tooltip for buttons
		private ToolTip m_ToolTip = new ToolTip();

		internal FormReadXMLSchema(ListView listView)
		{
			InitializeComponent();
			this.m_ListView = listView;

			//	ToolTips
			m_ToolTip.SetToolTip(btnClose, "Close Dialog");
			m_ToolTip.SetToolTip(btnReadSchema, "Read XML Schema");

			SetFileFilter();
		}

		private void FormReadXMLSchema_Load(object sender, EventArgs e)
		{
			jFileFolderPicker1.Focus();
		}

		private void btnClose_Click(object sender, EventArgs e)
		{
			Close();
		}

		private void btnReadSchema_Click(object sender, EventArgs e)
		{
			if (!string.IsNullOrEmpty(jFileFolderPicker1.SelectedPath))
				ReadSchema(jFileFolderPicker1.SelectedPath);
		}

		private void jFileFolderPicker1_OnPathSelectedHandler(object sender, JGFileFolderPicker.PathArgs e)
		{
			if (!string.IsNullOrEmpty(e.SelectedPath))
			{
				try
				{
					FileInfo fInfo = new FileInfo(e.SelectedPath);
					if (fInfo.Exists)
					{
						ListSchemaTables(fInfo.FullName);
					}
				}
				catch
				{
					ShowMessage("Cannot Open File", true);
				}
			}
		}

		private void ListSchemaTables(string filePath)
		{
			try
			{
				DataSet dsTemp = new DataSet();
				dsTemp.ReadXmlSchema(filePath);

				txtXMLNamespace.Text = dsTemp.Namespace;
				txtXMLDataSetName.Text = dsTemp.DataSetName;

				m_TableNamesList.Clear();
				DataTableCollection dtCollection = dsTemp.Tables;
				foreach (DataTable current in dtCollection)
				{
					lstTables.Items.Add(current.TableName);
					m_TableNamesList.Add(current.TableName);
				}
			}
			catch
			{
				ShowMessage("Unable To Read Schema", true);
			}
		}

		private void lstTables_SelectedIndexChanged(object sender, EventArgs e)
		{
			btnReadSchema.Enabled = (lstTables.SelectedItems.Count == 1);
		}

		private void ReadSchema(string filePath)
		{
			int tableIndex = lstTables.SelectedIndex;
			
			ListViewItem lvItem;
			
			string accessType = "", cType = "";
			
			if (rbReplaceData.Checked)
				this.m_ListView.Items.Clear();
			
			ShowMessage("", false);

			try
			{
				DataSet dsTemp = new DataSet();
				dsTemp.ReadXmlSchema(filePath);

				DataTableCollection dtCollection = dsTemp.Tables;
				DataTable dTable = dtCollection[tableIndex];
				DataColumnCollection dcCollection = dTable.Columns;
				this.m_XMLTableName = dTable.TableName;

				foreach (DataColumn column in dcCollection)
				{
					lvItem = new ListViewItem(column.ColumnName);

					for (int col = 0; col <= this.m_ListView.Columns.Count; col++)
						lvItem.SubItems.Add("");

					this.m_ListView.Items.Add(lvItem);

					JDataTypes.GetTypeStringsFromXMLType(column.DataType.ToString(), out cType, out accessType);

					lvItem.SubItems[JCommon.CDATATYPE].Text = cType;
					lvItem.SubItems[JCommon.ACCESSDATATYPE].Text = accessType;
					lvItem.SubItems[JCommon.XMLDATATYPE].Text = column.DataType.ToString();
					if (column.AutoIncrement)
					{
						lvItem.SubItems[JCommon.AUTOINCREMENT].Text = "Yes";
						lvItem.SubItems[JCommon.KEYFIELD].Text = "Yes";
					}
					else
					{
						lvItem.SubItems[JCommon.AUTOINCREMENT].Text = "";
						lvItem.SubItems[JCommon.KEYFIELD].Text = "";
					}

					lvItem.SubItems[JCommon.STRINGOVERRIDE].Text = "";
					lvItem.SubItems[JCommon.OWNGET].Text = "";
					lvItem.SubItems[JCommon.OWNUPDATER].Text = "";
				}
			}
			catch
			{
				ShowMessage("Unable To Read Schema", true);
			}
		}

		private void SetFileFilter()
		{
			string filter = "XML Files (*.xml;*.xsd)|*.xml;*.xsd";

			jFileFolderPicker1.FileFilter = filter;
		}

		private void ShowMessage(string strMes, bool blnBeep)
		{
			tslblMessage.Text = strMes;
			if (blnBeep)
				JCommon.MessageBeep(-1);
		}


		#region internal properties

		internal List<string> TableNamesList
		{
			get { return this.m_TableNamesList; }
		}

		internal string XMLFilePath
		{
			get { return this.jFileFolderPicker1.SelectedPath; }
		}

		internal string XMLTableName
		{
			get { return this.m_XMLTableName; }
		}

		internal string XMLNameSpace
		{
			get { return this.txtXMLNamespace.Text; }
		}


		internal string XMLDataSetName
		{
			get { return this.txtXMLDataSetName.Text; }
		}


		#endregion

		

		



	}
}