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

namespace WestinghouseROLoad
{
	public partial class frmImportROs : Form
	{
		public frmImportROs()
		{
			InitializeComponent();
		}

		private void frmImportROs_Load(object sender, EventArgs e)
		{
			STPTableAdapter.Fill(this.rOMasterDataSet.RO000002);
		}
		private void emptyExistingToolStripMenuItem_Click(object sender, EventArgs e)
		{
			DataTable dto = STPTableAdapter.GetData();
			foreach (DataRow dr in dto.Rows)
			{
				if (int.Parse(dr["RecType"].ToString()) == 3) // Remove Grouping
				{
					if (dr["ParentID"].ToString() != "00000000")
					{
						dr.Delete();
						STPTableAdapter.Update(dr);
					}
				}
				if (int.Parse(dr["RecType"].ToString()) == 5) // Remove ROs
				{
					dr.Delete();
					STPTableAdapter.Update(dr);
				}
			}
		}
		private void loadToolStripMenuItem_Click(object sender, EventArgs e)
		{
			DataTable dto = STPTableAdapter.GetData();
			DataRow drCount = dto.Rows[0];
			Console.WriteLine("{0}", drCount["Info"].ToString());
			STPImportTableAdapter.Fill(this.rOImportDataSet.ImportSTP_qry);
			DataTable dti = STPImportTableAdapter.GetData();
			foreach (DataRow dr in dti.Rows)
			{
				// Parameter Name Value Description
				Console.WriteLine("Name = '{0}', Value = '{1}', Description = '{2}'",
					dr["Name"], dr["Value"], dr["Description"]);
			}
		}
	}
}