private void EditButton_Click(object sender, EventArgs e)
{
RoomForm form = new RoomForm();
form.Text = "Изменить номер";
form.button1.Text = "Применить";
form.Tag = dataGridView.SelectedRows[0].Cells[0].Value.ToString();
form.number.Value = int.Parse(dataGridView.SelectedRows[0].Cells[1].Value.ToString());
form.type.SelectedItem = dataGridView.SelectedRows[0].Cells[2].Value.ToString();
form.places.Value = int.Parse(dataGridView.SelectedRows[0].Cells[3].Value.ToString());
if (form.ShowDialog() == DialogResult.OK)
{
using (var sql = new SqlConnection(Program.sql.ConnectionString))
{
sql.Open();
var com = sql.CreateCommand();
com.CommandText = String.Format("update Номера set [Номер комнаты]='{0}',[Тип номера]='{1}'," +
"[Количество мест]='{2}' where Id={3}",
form.number.Value, form.type.SelectedItem, form.places.Value, form.Tag);
com.ExecuteNonQuery();
sql.Close();
}
RefreshDB();
Owner.OwnedForms.OfType <IRefreshable>().ToList().ForEach(f => f.RefreshDB());
}
}
private void AddButton_Click(object sender, EventArgs e)
{
RoomForm form = new RoomForm();
form.Text = "Добавить номер";
form.button1.Text = "Добавить";
if (form.ShowDialog() == DialogResult.OK)
{
using (var sql = new SqlConnection(Program.sql.ConnectionString))
{
sql.Open();
var com = sql.CreateCommand();
com.CommandText = String.Format("insert into Номера values('{0}','{1}','{2}')",
form.number.Value, form.type.SelectedItem, form.places.Value);
com.ExecuteNonQuery();
sql.Close();
}
RefreshDB();
Owner.OwnedForms.OfType <IRefreshable>().ToList().ForEach(f => f.RefreshDB());
}
}
