Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# SQL LINQ MVC
Hey guys, Im having trouble with a few parts of MVC and could do with some help.
 
I want the program to load a grid of folders onto the main page each either the modules name, ID and a button in each which acts similar to how windows explorer displays folders and subfolders. Users can rearrange the folders on the grid and click them to go to sub folders if it has any.
 
The database is set up like this:
Folders
FolderID, FolderName, ParentID, ClientID
Groups
GroupID, GroupName,IsGlobalAdmin, ClientID
Group permissions
ID, GroupID, FolderID, HasRead
Folder Positions
ID, FolderID, UserID, Position
 
I need a statement that using LINQ to Sql loads the grid based off what the group is allowed to see based off the HasRead column and if they have the same ClientID and in the order of positions that user set in the Folder positions table.
 
If they are a global admin the database loads all folders for that ClientID
 
Any links or code for me to play with? I'm struggling to find anything that covers this kind of thing in MVC, I managed it in webforms fine but this is so different I need the advise.
 
Thanks in advance
Posted 12-Mar-12 7:13am
Edited 12-Mar-12 7:20am
v3

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Comments
Phoenix234 at 13-Mar-12 6:19am
   
Its good reading material but wont work for this system.
 
Also im trying to load 1 level in a grid not the entire list in a tree view

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 7,853
1 Sergey Alexandrovich Kryukov 7,107
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,790


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 12 Mar 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100