Open zenitsuga opened 6 years ago
Validation for Deleting rooms if it is assigned must not be deleted.
Done I'm only checking RoomAssignment table before deleting the room. I do not include transaction for this. because if the transaction was made. RoomName was already use as reference. This means that all records injected in transaction was declared as history and cannot be deleted. So if there a case that the room was left by the customer. Last transaction of this customer will be remain. Then the next customer that will use the room name will be the current customer assigned on it. No need to update the transaction history, (we can add the criteria for transaction history report the CustomerID and RoomName to avoid confusion)
searching is not yet functioning.
If you search for existing Room number, It will display, else display all records (as default).
If you type 104 from the Search Bar, it doesn't show the record for the RoomName 104.
Create a searching function.