public int SetRoomState(int roomID, Base.TableRooms.RoomState state)
{
try {
return(phongDAO.SetRoomState(roomID, state));
}//end try
catch {
throw;
} //end catch
} //end method SetRoomState
public int SetRoomState(int roomID, Base.TableRooms.RoomState state)
{
try {
String query = "UPDATE PHONG SET MA_TINH_TRANG=@MA_TINH_TRANG " +
"WHERE MA_PHONG=@SO_PHONG";
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@MA_TINH_TRANG", state);
param[1] = new SqlParameter("@SO_PHONG", roomID);
return(Program.DBConnection.ExecuteNonQuery(query, param));
}//end try
catch {
throw;
} //end catch
} //end method SetRoomState
