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();
}
