private void EditionADG_Click(object sender, EventArgs e)
{
ChangeHosts changeHosts = new ChangeHosts();
int index = advancedDataGridView2.CurrentRow.Index;
string Country = advancedDataGridView2[4, index].Value.ToString();
string City = advancedDataGridView2[5, index].Value.ToString();
string Street = advancedDataGridView2[6, index].Value.ToString();
string Home = advancedDataGridView2[7, index].Value.ToString();
int Id = (int)advancedDataGridView2[8, index].Value;
changeHosts.CurrentHost.Text = Convert.ToString(advancedDataGridView2[1, index].Value);
changeHosts.Lifts.Text = Convert.ToString(advancedDataGridView2[2, index].Value);
changeHosts.Rooms.Text = Convert.ToString(advancedDataGridView2[3, index].Value);
changeHosts.Country.Text = Country;
changeHosts.City.Text = City;
changeHosts.Street.Text = Street;
changeHosts.Home.Text = Home;
if (changeHosts.ShowDialog() == DialogResult.OK)
{
//this._commandCollection[0].CommandText = "SELECT IsChecked, [Номер гостиницы], [Количество этажей], [Количество номеров], С" +
//"трана, Город, Улица, Дом, ID FROM Hosts";
//this._connection.ConnectionString = ConnStr;
this.hostsTableAdapter.UpdateQuery(Convert.ToInt32(changeHosts.CurrentHost.Text), changeHosts.Lifts.Text, changeHosts.Rooms.Text, changeHosts.Country.Text, changeHosts.City.Text, changeHosts.Street.Text, changeHosts.Home.Text, Id);
this.hostsTableAdapter.Fill(dataBaseDataSet5.Hosts);
changeHosts.Close();
}
}
private void IncrementADG_Click(object sender, EventArgs e)
{
ChangeHosts changeHosts = new ChangeHosts();
if (changeHosts.ShowDialog() == DialogResult.OK)
{
this.hostsTableAdapter.Insert(false, Convert.ToInt32(changeHosts.CurrentHost.Text), changeHosts.Lifts.Text, changeHosts.Rooms.Text, changeHosts.Country.Text, changeHosts.City.Text, changeHosts.Street.Text, changeHosts.Home.Text, advancedDataGridView2.Rows.Count + 1);
this.hostsTableAdapter.Fill(this.dataBaseDataSet5.Hosts);
changeHosts.Close();
}
}
