Important message to all developers

Posted by Darasimi under VB.NET on 5/16/2012 | Points: 10 | Views : 925 | Status : [Member] | Replies : 2
Hello to all, I want you guys to help me with my company project on hotel management. CAN SOMEBODY GIVE ME A CODE TO REMOVE occupied room from the database and when the room is vacant back into the database. Thank you in Advance




Responses

Posted by: Kavi.Sirius on: 5/17/2012 [Member] Starter | Points: 25

Up
0
Down
hi,

You can include the one column for status in table design.

you just set status for the occupied and vaccant room

Example:

if occupied room means u set status =1
vaccant room means u set status=0

Regards
Kavi.n

Darasimi, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Dotnetrajanikanth on: 5/17/2012 [Member] Starter | Points: 25

Up
0
Down
Darasimi ,

No need to REMOVE or PUT BACK rooms in the database. This operation will be tedious. The better option is to create another column that can be name like "OccupiedStatus" .

while no body is occupied in the room set the OccupiedStatus as '0'

while the room is occupied set the OccupiedStatus as '1'

Use simple UPDATE query for that.


UPDATE <tablename> SET OccupiedStatus = 1.

UPDATE <tablename> SET OccupiedStatus = 0.

____________
www.flickr.com/photos/psdesigner/

Darasimi, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response