Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It seems likely that your code will eventually compile a list of UI elements to hide, or perform a given action to, and then perform those actions based on the current role. Something like</p> <pre><code>Dictionary&lt;Control, Action&lt;Control, string&gt;&gt; actions = new Dictionary&lt;Control, Action&lt;Control, string&gt;&gt; { { button, (c, r) =&gt; c.Enabled = (r == "administrator") }, // etc. }; </code></pre> <p>How you compile that list is primarily what your question is concerned with. AOP frameworks definitely help with the separation of concerns, but a homebrew solution wouldn't be impossible. I'm thinking something like:</p> <ul> <li>Create an <code>EnableForRoleAttribute</code>, with parameter <code>role</code>.</li> <li>Reflect on your forms (possibly using reflection to find the forms, or possibly providing them to your code directly, or even finding forms decorated with a <code>RoleVaryingAttribute</code> of your creation).</li> <li>Reflect on the fields of your forms, filtering for <code>Control</code> instances, then for <code>Control</code> instances with the <code>EnableForRoleAttribute</code>.</li> <li>Now you have your list! Set <code>Enabled</code> based on the role.</li> </ul> <p>The above bulleted list is specific to your <code>Enabled</code> example, mainly because attributes can't take lambdas as parameters :(. You could be more flexible with a <code>SetPropertyIfInRoleAttribute</code> with parameters <code>role</code>, <code>propertyName</code>, and <code>propertyValue</code>. Or any such construction.</p> <p>Basically, the AOP frameworks make this work easier for you, and some like PostSharp make it happen at compilation time instead of runtime. But the homebrew solution is pretty valid too.</p>
    singulars
    1. This table or related slice is empty.
    1. POAuthorization of UI Elements in .NET WinForms
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USDomenic
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAuthorization of UI Elements in .NET WinForms
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODomenic - thanks, the SetPropertyIfInRoleAttribute (or SetPropertyByRoleAttribute) seems like a nice middle ground, and as of this moment I am leaning that way. Great explanation, thanks for clarifying. Now I see, lambda in an Attribute constructor would be very useful!
      singulars
      1. PO
      1. USgrefly
    2. COAs a follow up, what I ran into using PostSharp was that I could not get the custom attribute because I am decorating .NET framework classes (textboxes, etc) at an instance level. I think I'll run into the same issue again. Although you provided a great answer to the original question, one answer often leads to two more questions... =D
      singulars
      1. PO
      1. USgrefly
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload