|
|
|
|
|
|
|
|
|
|
Originally posted by Nai chao Wu:
I'm doing B & S contractors
I have some question about booking
1.A contractor is only booked by a customer?
Yes in our project case. If you are saying a single customer, then NO. Many CSR's might be trying to book record at same time in remote mode.
2.Book a contractor is write a value(customer Id) to the owner field in db file?
Yes.
3.Judge whether a contractor is booked is check the owner field of the record ?
Yes. You have to check the owner field of a record in dbfile to know whether contractor is booked or not.
4.The owner field of the record is displayed in JTable ?
Yes, if you want to show already booked records.
Good Luck.
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.
|