Check for Valid User via Button

Question

Ok, so I have a form that has multiple views, some read only and some editable. Each form has buttons to open the other forms in either edit mode or read only mode based on a field being set to either 1 or 0 and the current status of the form (so if the status is 'Awaiting Purchasing' and the check field is 1, then clicking the purchasing button opens the purchasing view in edit mode.

I have a button (Edit) to press that sets the check field to 1 on click and submitting the form sets the field back to 0.

Now here comes the tricky part! I have a list that contains Department (text) and Editors (multi-select people field). I need, within the Edit button, to check the status of the form, then check if the current user exists in the Editors field from the other list based on that status. If they exists then the Edit button will set the check field to 1, otherwise it won't.

Can anyone tell me a) if that is possible and b) if so, how to accomplish it?

Answer 1

this is a simplified version i made for you but havent tested it! so might need some tweaking ;)

You dont need to change the second method! for the first method, replace yourSiteGoesHere with your site name or leave blank. change ListName to the name of your list.

you would call the method like so:

    //returns bool if the current user exists in department "marketing" (true=1 , false=0)
    bool isingroup = getAccessFromGroup("Marketing");

that would call the methods below!

    /// <summary>
    /// returns true if user is in field within list
    /// </summary>
    /// <returns></returns>
    public bool getAccessFromGroup(string department)
    { 
        //open site from current site context
        using (SPSite site = new SPSite(SPContext.Current.Site.Url))
        {
            //open specific site, leave blank if toplevel
            using (SPWeb web = site.OpenWeb("yourSiteGoesHere"))
            {
                //get splist collection but only return one row based on query
                SPListItemCollection currentUser = getListDetails("ListName", web, SPContext.Current.Web.CurrentUser.LoginName);

                //if null then user doesnt exist on any items
                if (currentUser != null)
                {

                    //check if the user is in the department, loop if user exist in more than one place
                    foreach (SPListItem item in currentUser)
                    {
                        //check to make sure the field department matches the one you want else loop through to end and return false (user doesnt exist)
                        if (item["Department"] == department)
                        {
                            //return true as use exists in department
                            return true;
                        }
                    }   
                }                 
            }
        }
        return false;
    }

this is called from the method above! no need to change anything unless i have the field name 'Editors' wrong?

    private SPListItemCollection getListDetails(string listName, SPWeb web, string passVal)
    {
        SPList List = web.Lists[listName];
        SPQuery listABQuery = new SPQuery();
        listABQuery.Query = "<Where><Eq><FieldRef Name='Editors'/>" +
            "<Value Type='Text'>" + passVal + "</Value></Eq></Where>";
        SPListItemCollection item = List.GetItems(listABQuery);
        return item;
    }