// Button 'Save' private void buttonNewGuestConfirm_Click(object sender, EventArgs e) { Boolean roomexists = false; Boolean roomvalid = false; int roomid; int roomtypeid = Convert.ToInt32(comboBoxRoomType.SelectedValue); // Check if the point entered is numeric if (Int32.TryParse(textBoxRoomid.Text, out roomid)) { roomvalid = true; if (DBGetData.GetFloorplanRoomExists(roomid) > 0) { roomexists = true; MessageBox.Show("Room number already exists, select a different number."); } } else { MessageBox.Show("Only numbers (0-9) are allowed in the room number."); } // Execute save if (!roomexists && roomvalid) { DBSetData.FloorplanRoomAdd(roomid, roomtypeid); // Close form this.Close(); floorplanForm.LoadDataRoom(); floorplanForm.Refresh(); new StatusMessage("Room with number " + roomid + " is added to the database."); } }
// Button 'Save' private void buttonNewRoomConfirm_Click(object sender, EventArgs e) { if (comboBoxRoomType.SelectedIndex > -1) { // Execute save int roomtypeid = Convert.ToInt32(comboBoxRoomType.SelectedValue); DBSetData.FloorplanRoomEdit(roomid, roomtypeid); // Close form this.Close(); floorplanForm.LoadDataRoom(); floorplanForm.Refresh(); new StatusMessage("Room with number " + roomid + " is updated in the database."); } }
// Button 'Save' private void buttonEditHallConfirm_Click(object sender, EventArgs e) { string hallname = textBoxHallname.Text; // Check for null or empty input if (string.IsNullOrWhiteSpace(hallname)) { MessageBox.Show("Hallname field is not filled in"); } if (!string.IsNullOrWhiteSpace(hallname) && comboBoxHallType.SelectedIndex > -1) { // Execute save int halltypeid = Convert.ToInt32(comboBoxHallType.SelectedValue); DBSetData.FloorplanHallEdit(hallid, hallname, halltypeid); // Close form this.Close(); floorplanForm.LoadDataHall(); floorplanForm.Refresh(); new StatusMessage("Hall with name " + hallname + " is updated in the database."); } }
// Button 'Save' private void buttonNewHallConfirm_Click(object sender, EventArgs e) { Boolean hallexists = false; string hallname = textBoxHallname.Text; if (DBGetData.GetFloorplanHallExists(hallname) > 0) { hallexists = true; MessageBox.Show("Hall name already exists, select a different name."); } // Execute save if (!hallexists && !string.IsNullOrWhiteSpace(hallname) && comboBoxHallType.SelectedIndex > -1) { int halltypeid = Convert.ToInt32(comboBoxHallType.SelectedValue); DBSetData.FloorplanHallAdd(hallname, halltypeid); // Close form this.Close(); floorplanForm.LoadDataHall(); floorplanForm.Refresh(); new StatusMessage("Hall with name " + hallname + " is added to the database."); } }