116 reputation
3
bio website
location
age
visits member for 1 years, 9 months
seen Feb 27 at 23:41

Jul
23
comment General Architecture with Code Tables?
@Emmand. They are actually only stored in two places. The database + the enums. The Statuses aren't hard coded in the controls. They are retrieved from the database tables talk about above. We have to make a request to our database staff when we want a new code table value. Then will then email us a new Id which we put in our enum.
Jul
23
comment General Architecture with Code Tables?
Of course this would i think mean to load your combo boxes (or whatever your controls you use on the screen) then you would have to make a call to the service to load them for example: myorderingservice/codetables/OrderStatuses
Jul
23
comment General Architecture with Code Tables?
You would pass the string across the wire (for example <OrderStatus>Open</OrderStatus> and then when your clients makes a POST/PUT to your rest service then you would need to look up the Id for "Open" or whatever it been in the database so business logic can do the correct thing. Of course i don't ever want to see anything like this "If OrderStatus = Open Then"
Jul
23
comment General Architecture with Code Tables?
First of all Lorand I want to thank you for the time you took in coming up with an excellent answer to my question. I do want to try to make sure i understand it fully though. Oh ya and by the way the idea on having one master code table with a secondary type table was a great idea. Anyways in context to a REST Service.
Jul
21
comment General Architecture with Code Tables?
I was talking about returning Code Table Ids in your REST Service rather than the description of the status so i would be returning <OrderStatus>1</OrderStatus> rather than <OrderStatus>Created</OrderStatus>. The controls don't store the enumeration description they store the Id + the Description. The user will only see "Created" but in the code we will know they selected "1". For example we inherit the combo box and have our on custom combobox so we can do "If Combobox.SelectedIndex = eosCreated Then". What i'm referring to is more client rather than browser apps.