public ActionResult SubmitChoosenUser()
        {
            //add the choosen users to DB
            if (!Authorize())
            {
                return(RedirectToAction("RedirectByUser", "Home"));
            }
            VMUsersGroup vmUsrGrp = (VMUsersGroup)TempData["VMUsersGroup"];

            if (Request.Form["users[]"] == null)
            {
                ViewBag.erorAddUser = "******";
                return(View("ChooseUser", vmUsrGrp));
            }
            string           usrs      = Request.Form["users[]"].ToString();
            List <string>    userNames = usrs.Split(',').ToList <string>();
            GroupRoommateDal grpRmtDal = new GroupRoommateDal();

            foreach (string usrName in userNames)
            {
                GroupRoommate newRec = new GroupRoommate()
                {
                    groupID  = vmUsrGrp.group.gid,
                    userName = usrName
                };
                grpRmtDal.GroupsRoommates.Add(newRec);
            }
            grpRmtDal.SaveChanges();
            ViewBag.addUsersToGroupSuccess = "המשתמשים התווספו בהצלחה!";
            return(View("ShowManagerPage"));
        }
        public ActionResult ChooseUser(Group grp)
        {
            //add users to choosen group
            if (!Authorize())
            {
                return(RedirectToAction("RedirectByUser", "Home"));
            }
            User u = (User)(Session["CurrentUser"]);
            //get the choosen group details
            GroupRoommateDal grpRmtDal             = new GroupRoommateDal();
            List <string>    userNamesAlreadyInGrp = (from usr in grpRmtDal.GroupsRoommates
                                                      where usr.groupID == grp.gid
                                                      select usr.userName).ToList <string>();
            //get all the registered users except the current manager and the the users that already belongs to the group
            UserDal     usrDal = new UserDal();
            List <User> usrs   = (from usr in usrDal.Users
                                  where usr.UserName != u.UserName &&
                                  !userNamesAlreadyInGrp.Contains(usr.UserName)
                                  select usr).ToList <User>();
            VMUsersGroup usrsGidVM = new VMUsersGroup()
            {
                group = grp,
                users = usrs
            };

            return(View(usrsGidVM));
        }