public ActionResult Edit(user userEdited)
        {
            var users = (from u in sql.users
                         where u.id == userEdited.id
                         select u);

            if (users.Count() > 0)
            {
                user userToEdit = users.First();
                userToEdit.role = Request["role"];
                userToEdit.name = userEdited.name;
                userToEdit.division = Request["division"];
                userToEdit.email = userEdited.email;

                sql.SubmitChanges();
            }

            return RedirectToAction("Index", new { edited = "true" });
        }
        public static user getUserSession()
        {
            mainModelDataContext sql = new mainModelDataContext();

            WindowsPrincipal principal = (WindowsPrincipal)Thread.CurrentPrincipal;
            WindowsIdentity identity = (WindowsIdentity)principal.Identity;
            String userName = principal.Identity.Name;
            String name = "";
            String lastname = "";

            if (ConfigurationManager.AppSettings["use_AD"] == "true")
            {
                DirectoryEntry entry = new DirectoryEntry(ConfigurationManager.AppSettings["LDAP_HOST"]);
                DirectorySearcher Dsearch = new DirectorySearcher(entry);
                Dsearch.Filter = ConfigurationManager.AppSettings["LDAP_FILTER"].Replace("{0}", userName.Substring(userName.LastIndexOf("\\") + 1));

                foreach (SearchResult sResultSet in Dsearch.FindAll())
                {

                    if (ConfigurationManager.AppSettings["use_GIVENAME"] == "true")
                    {
                        name = GetProperty(sResultSet, "givenName");
                    }

                    lastname = GetProperty(sResultSet, "cn");
                }
            }

            var usersFound = (from u in sql.users
                              where u.username == userName
                              select u);

            if (usersFound.Count() > 0)
            {
                user foundUser = usersFound.First();
                foundUser.lastlogin = DateTime.Now;

                if (ConfigurationManager.AppSettings["use_AD"] == "true")
                {
                    foundUser.name = name + " " + lastname;
                }
                else
                {
                    foundUser.name = "";
                }

                sql.SubmitChanges();

                return foundUser;
            }
            else
            {
                user newUser = new user();
                newUser.username = userName;

                if (ConfigurationManager.AppSettings["use_AD"] == "true")
                {
                    newUser.name = name + " " + lastname;
                }
                else
                {
                    newUser.name = "";
                }

                newUser.lastlogin = DateTime.Now;
                newUser.role = "NOTALLOWED";
                //newUser.email = (up != null && !String.IsNullOrEmpty(up.EmailAddress) ? up.EmailAddress : "");

                sql.users.InsertOnSubmit(newUser);
                sql.SubmitChanges();

                return newUser;
            }
        }
 partial void Deleteuser(user instance);
 partial void Updateuser(user instance);
 partial void Insertuser(user instance);
		private void detach_users(user entity)
		{
			this.SendPropertyChanging();
			entity.role1 = null;
		}
		private void attach_users(user entity)
		{
			this.SendPropertyChanging();
			entity.role1 = this;
		}