hello,
i am facing some problems in grid view.i am sending you few coding files in which problems are coming.
problems are as follows:-
1. when we insert new record in any table(facility,amenity or room), then it displays its respective id in the master table(hotelmaster) row.
example:-
insert 1 record in facility of id=2 and name say "abc".
then in master table(hotelmaster), it display the "2" in facility column where name ="abc".
this is happening with all 3 forms(amenity,room, facility).
i want to insert forst any record, then if i check thye check box then its values should b go through otherwise not.
2. my amenity & room forms are performing same task..if we insert any value in amenity form.. it will automatically displays its record's id in both columns(amenity, room) instead of display only in amenity column.
please help me to solve my these problems..
thank you.
Loading

Rahul BhattPosted Jul 26, 2012, 2:25 AM
Your database structure is wrong
When you insert in Infl_HotelInventory_Facility
Infl_HotelInventory_Facility(hotel_name,FacilityType,FacilityName,Description,ActiveFlag,InsertedBy,UpdatedBy
You also insert hotel name for that facility thats autommaticaly display in hotel master.
As per my suggestion your DB structure as following way
HotelMaster >> HID, hotel_name, hotel_code,minrate, maxrate etc. field
FacilitiesMaster >> FID, FacilityType, FacilityName, Description, ActiveFlag, InsertedBy, UpdatedBy etc.
Infl_HotelInventory_Facility >> IHFID, HID, FID
AmenityMaster >> AID,Amenity,AmenityType,InsertedBy,UpdatedBy,ActiveFlag
Infl_HotelInventory_Amenities >> IHAID,HID,AID
roomtMaster >> RID,RoomType,no_rooms,Descriptions,cost,ActiveFlag
Infl_HotelInventory_RoomType >> IHRID,HID,RID
Check it and let me know
Priyank KharePosted Jul 25, 2012, 7:14 AM
i've already sent some files.
now the problems are:-
1. if i insert any new record(hotelname=taj,facility=.... & so on) in facility form and when i check the check box to transfer its id according to hotelname
then only its id move to hotelmaster page & store the value ("1") in facility column where hotelname=taj.
but right now the respective ids moving automatically to hotelmaster page without checking the checkbox.
so i am asking that what's wrong with the code & tell me what should i do to solve my problem.
thank you.
rakesh chaudhariPosted Jul 25, 2012, 6:49 AM