//methods
void OpenRoomForm()
{
this.Hide();
RoomForm roomForm = new RoomForm(room, guest, staff);
roomForm.Show();
}
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 AddBtn_Click(object sender, EventArgs e)
{
CreateGuest CreateGuestForm = new CreateGuest();
RoomForm CreateRoomForm = new RoomForm();
if (dataGridView1.Visible)
{
CreateGuestForm.Show();
}
if (dataGridView2.Visible)
{
CreateRoomForm.Show();
}
}
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());
}
}
public void createRoom()
{
string[] room = RoomForm.Create();
string query = "INSERT INTO номер (`Номер`,`Состояние`,`Цена за ночь`,`Оценка номера`,`id_набора особенностей`) VALUES ('" + room[0] + "','" + room[1] + "','" + room[2] + "','" + room[3] + "','" + room[4] + "')";
MySqlCommand command = new MySqlCommand(query, connection);
command.CommandTimeout = 60;
MySqlDataReader reader;
try
{
connection.Open();
reader = command.ExecuteReader();
// Succesfully deleted
connection.Close();
}
catch (Exception ex)
{
// Ops, maybe the id doesn't exists ?
MessageBox.Show(ex.Message);
}
}