Originally posted by Nai chao Wu:
Thanks Satish
But I still have some question about the first and fourth question
1.After contractor A is booked by client B, client C also want to book the same contract A .Is this allowed?
It is upto you. You can allow it or don't. Either way, you should document in your choices about why you allowed and why not.
In other words, the same contractor can be booked by the different client?
If this is allowed ,I want to ask ,when client B books contractor A,client B
writes his ID(00000001) to db.Then, client C books the same contractor A, client C also write his ID(00000002) to db.At this point,the owner field of contractor A is 00000002(client c's ID),client B'ID is covered by client C's ID.
If you want to allow re-booking of a record, i.e. a client can book an already booked record then I would suggest you to use a pop-up in the while doing this. Pop-up should include something like "Contractor already booked. Do you want to book to a different client" or something like that. Then on second booking, client who booked last will own/hire the contractor.
2.I want know other people whether display the owner field(ID) in Jtable?
I think atleast 80% - 90% of people have shown owner ID in
JTable.
I think that let other people can see customer'ID is not good.
You should remember that CSR will book the record with only owner ID and the application is used only by CSR's. So CSR's already know about owner's ID.
Don't display the owner field in
JTable is OK?
If you don't want to display, I am not sure if its OK or not. You can do something like this: Show only records which are'nt booked and in this way owner ID's will not be shown. But if you opt for this solution you cannot rebook.
Or display a flag that indicate this record is booded or unbooked?
I think its OK.