public partial class frmSysCity : Form
	{
		public frmSysCity()
		{
			InitializeComponent();
		}
		public int iRet = 0;
		//private productsDataSet.ProductsRow productRow;
		//Attach to table
		//BindingSource Bmgr = CitiesBindingSource;
		//private BindingManagerBase Bmgr;
//Bmgr = this.BindingContext[cADADataDataSet, "Cities"];
		//private BindingManagerBase product_Bmgr;
		//product_Bmgr = this.BindingContext[cADADataDataSet,"Cities"];
		
		private void frmSysCity_Load(object sender, EventArgs e)
		{
			// TODO: This line of code loads data into the 'cADADataDataSet1.Cities' table. You can move, or remove it, as needed.
			tspBtnSave.Enabled = false;
			//tspBtnUndo.Enabled = false;
			this.citiesTableAdapter.Fill(this.cADADataDataSet.Cities);
					
		}

		private void tspBtnExit_Click(object sender, EventArgs e)
		{
			this.Close();
		
		}
		private void DisplayPosition()
		{
			tspRecNo.Text = Convert.ToString(CitiesBindingSource.Position + 1);
			//+ " of " +
			tspNoOfRec.Text = CitiesBindingSource.Count.ToString();
		}
		private void tspBar_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
		{
			//MessageBox.Show(e.ClickedItem.Name.ToString());
			//clsNavToolButton(product_Bmgr, e.ClickedItem.Name.ToString());
			
			int PrevItem = CitiesBindingSource.Position - 1;
						
			switch (e.ClickedItem.Name.ToString())
			{
				case "tspBtnStart":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					CitiesBindingSource.Position = 0;
					break;
				case "tspBtnPrevious":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					CitiesBindingSource.Position --;					
					break;
				case "tspBtnPrevtGroup":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					if (CitiesBindingSource.Position < 20 )
						CitiesBindingSource.Position = 0;	
					else
						CitiesBindingSource.Position -= 20;
					
					// should be a page down
					break;
				case "tspBtnNext":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					CitiesBindingSource.Position ++;					
					break;
				case "tspBtnNextGroup":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					if (CitiesBindingSource.Position > CitiesBindingSource.Count - (20 + 1) )
						CitiesBindingSource.Position = CitiesBindingSource.Count - 1;
					else
						CitiesBindingSource.Position += 20;
					// should be a page up
					break;
				case "tspBtnEnd":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					CitiesBindingSource.Position = CitiesBindingSource.Count - 1;
					break;

				/*case "tspBtnUndo":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					this.CitiesBindingSource.ResetCurrentItem();
					//
					break;
				 */ 
				case "tspBtnDelete":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					int iRow = CitiesBindingSource.Position;
					if (MessageBox.Show("Delete " + citiesDataGridView[0, iRow].Value.ToString() + "?",
				"Confirm Delete", MessageBoxButtons.YesNo,
				MessageBoxIcon.Question) == DialogResult.Yes)
					{
						CitiesBindingSource.RemoveAt(CitiesBindingSource.Position);
						CitiesBindingSource.Position = PrevItem;
						//productRow.Delete();
						//FillProductsComboBox();
						//cboProducts.SelectedIndex = 0;
						//DisableAddEditMode();
					}
					break;
				case "tspBtnSave":
					//MessageBox.Show(e.ClickedItem.Name.ToString());
					if (this.Validate())
					{
						//this.CitiesBindingSource.EndEdit();
						//this.citiesTableAdapter.Update(this.cADADataDataSet.Cities);
						citiesTableAdapter.Update(cADADataDataSet.Cities);
						cADADataDataSet.Cities.Clear();
						this.citiesTableAdapter.Fill(this.cADADataDataSet.Cities);
						CitiesBindingSource.Position = PrevItem + 1;
						
					}
					else
					{
						System.Windows.Forms.MessageBox.Show(this, "Validation errors occurred.", "Save", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Warning);
					}
					//
					break;
				case "tspBtnNewItem":
					MessageBox.Show(e.ClickedItem.Name.ToString());
					//
					break;
				case "tspBtnExit":
					this.Close();
					//
					break;

				default:
					break;
			}
			
		}

		private void citiesDataGridView_SelectionChanged(object sender, EventArgs e)
		{
			DisplayPosition();
		}


		private void citiesDataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e)
		{
			if (iRet == 0)
				iRet = 1;
			else
				tspBtnSave.Enabled = true;
				//tspBtnUndo.Enabled = true;
		}

		private void citiesDataGridView_CellStateChanged(object sender, DataGridViewCellStateChangedEventArgs e)
		{
			
		}

		
		
	}
}