private void simpleButton1_Click(object sender, EventArgs e) { try { string queryExits = "if EXISTS(SELECT * FROM PHONG Where MaPhong = " + getRoomCodeOld() + ") select 1"; DataTable rs = DataProvide.Instance.ExecuteQuery(queryExits); if (rs.Rows.Count > 0) { Button btn = getRoomInfo(); //return data ( int ) < 0 is success int data = DataProvide.Instance.ExecuteNonQuery(RoomDAO.Instance.UpdateRoomDatabaseQuery(), new object[] { getCodeRoomNew().RoomCode, getNameRoomNew().RoomName, _room.RoomStyle, getNoteRoomNew().RoomNote, _room.RoomStatus, getRoomCodeOld() }); if (data < 0) { MessageBox.Show("Sửa phòng thành công"); fRoom f = new fRoom(); this.Close(); f.Show(); } } else { MessageBox.Show("Mã phòng cần sửa không tồn tại"); } } catch (Exception ex) { if (ex is SqlException) { MessageBox.Show("Lỗi dữ liệu"); } MessageBox.Show("Nhập thông tin cần sửa"); } }
//MainMenu m = new MainMenu(); public fAddRoom(fRoom form) { InitializeComponent(); _fRoom = form; txbRoomCode.Select(); // focus cusor in textbox : CodeName setDataStyleRoom(); }
private void btnBack_Click(object sender, EventArgs e) { fRoom f = new fRoom(); this.Close(); f.Show(); }
public fDeleteRoom(fRoom f, MainMenu main) { InitializeComponent(); _froom = f; m = main; LoadRoomList(); }
private void simpleButton1_Click(object sender, EventArgs e) { fRoom f = new fRoom(); this.Hide(); f.ShowDialog(); }
public fRent(fRoom room) { InitializeComponent(); f = room; loadComboBoxInDataGridView(); setComboBoxFormality(); setComboBoxRoomCode(); }
public fEditRoom(fRoom f = null, MainMenu main = null) { InitializeComponent(); _fRoom = f; setDataStatusRoomNew(); setDataStyleRoomNew(); setComboxRoomCode(); m = main; }
//MainMenu m = new MainMenu(); public fRent(fRoom room, string roomname) { InitializeComponent(); //m = mainMenu; // this.txbRoomName.Text = roomname; // this.cbxRoomName.ReadOnly = true; f = room; loadComboBoxInDataGridView(); setComboBoxFormality(); setComboBoxRoomCode(); }
public fDeleteRoom(fRoom f) { InitializeComponent(); _froom = f; LoadRoomList(); }