public ActionResult Updateusergroup(int groupid)
        {
            UserService.UserServiceClient Client = new UserService.UserServiceClient();
            UserGroupViewModel            model  = new UserGroupViewModel();
            DataSet ds      = new DataSet();
            string  xmldata = Client.GetUserGroup(groupid);

            ds.ReadXml(new StringReader(xmldata));
            model.Group = new UserGroup();
            model.Group.UserGroupName        = Convert.ToString(ds.Tables[0].Rows[0]["User_Group_Name"]);
            model.Group.UserGroupDescription = Convert.ToString(ds.Tables[0].Rows[0]["User_Group_Description"]);
            model.Group.UserRoleId           = Convert.ToInt32(ds.Tables[0].Rows[0]["Role_ID"]);
            xmldata = Client.GetRoles(1);
            DataSet dsrole = new DataSet();

            dsrole.ReadXml(new StringReader(xmldata));
            model.Roles = new List <SelectListItem>();
            if (dsrole.Tables.Count > 0)
            {
                foreach (System.Data.DataRow row in ds.Tables[0].Rows)
                {
                    model.Roles.Add(new SelectListItem {
                        Text = row["Role_Name"].ToString(), Value = row["Role_ID"].ToString()
                    });
                }
            }
            return(View("_AddUserGroup", model));
        }
        public ActionResult AddUser()
        {
            UserViewModel userviewmodel = new UserViewModel();

            userviewmodel.User        = new User();
            userviewmodel.User.UserId = 0;
            UserService.UserServiceClient Client = new UserService.UserServiceClient();
            string  xmlGroups = Client.GetUserGroup(0);
            DataSet Groups    = new DataSet();

            Groups.ReadXml(new StringReader(xmlGroups));
            userviewmodel.UserGroupList = new List <SelectListItem>();
            //userviewmodel.UserGroupList.Add(new SelectListItem { Text = "--Select--", Value = "0" });
            foreach (System.Data.DataRow row in Groups.Tables[0].Rows)
            {
                userviewmodel.UserGroupList.Add(new SelectListItem {
                    Text = row["User_Group_Name"].ToString(), Value = row["User_Group_ID"].ToString()
                });
            }
            string  xmlRoles = Client.GetRoles(0);
            DataSet dsRoles  = new DataSet();

            dsRoles.ReadXml(new StringReader(xmlRoles));
            userviewmodel.RolesList = new List <SelectListItem>();

            //userviewmodel.RolesList.Add(new SelectListItem { Text = "--Select--", Value = "0" });
            //if (dsRoles.Tables.Count > 0)
            //{
            //    foreach (System.Data.DataRow row in dsRoles.Tables[0].Rows)
            //    {
            //        userviewmodel.RolesList.Add(new SelectListItem { Text = row["Role_Name"].ToString(), Value = row["Role_ID"].ToString() });
            //    }
            //}
            TempData["UserGroup"] = userviewmodel.UserGroupList;
            return(View("_AddUser", userviewmodel));
        }
        public ActionResult UpdateUser(int UserId)
        {
            //int userid = 2;
            UserViewModel model = new UserViewModel();

            model.User = new User();
            UserService.UserServiceClient Client = new UserService.UserServiceClient();
            string  xmldata = Client.getUser(UserId);
            DataSet ds      = new DataSet();

            ds.ReadXml(new StringReader(xmldata));
            model.User.UserId        = UserId;
            model.User.FirstName     = ds.Tables[0].Rows[0]["First_Name"].ToString();
            model.User.MiddleName    = Convert.ToString(ds.Tables[0].Rows[0]["Middle_Name"]);
            model.User.LastName      = Convert.ToString(ds.Tables[0].Rows[0]["Last_Name"]);
            model.User.ContactNumber = Convert.ToString(ds.Tables[0].Rows[0]["Contact_Number"]);
            model.User.EmailId       = Convert.ToString(ds.Tables[0].Rows[0]["Email_ID"]);
            model.User.Gender        = Convert.ToString(ds.Tables[0].Rows[0]["Gender"]);
            model.User.LastLogin     = Convert.ToDateTime(ds.Tables[0].Rows[0]["Last_Login"]);
            model.User.photo         = Convert.ToString(ds.Tables[0].Rows[0]["Photo"]);
            //model.User.IsActive = Convert.ToBoolean(ds.Tables[0].Rows[0]["Is_Active"]);
            model.UserGroupList = new List <SelectListItem>();
            xmldata             = Client.GetUserGroup(0);
            ds = new DataSet();
            ds.ReadXml(new StringReader(xmldata));
            xmldata = Client.getUserAssignedGroup(model.User.UserId);
            DataSet dsgroup = new DataSet();

            dsgroup.ReadXml(new StringReader(xmldata));

            if (ds.Tables.Count > 0)
            {
                foreach (System.Data.DataRow row in ds.Tables[0].Rows)
                {
                    bool selected = false;
                    if (dsgroup.Tables.Count > 0)
                    {
                        foreach (System.Data.DataRow roleid in dsgroup.Tables[0].Rows)
                        {
                            if (Convert.ToInt32(roleid["User_Group_ID"]) == Convert.ToInt32(row["User_Group_ID"]))
                            {
                                selected = true;
                                break;
                            }
                        }
                    }
                    model.UserGroupList.Add(new SelectListItem {
                        Text = row["User_Group_Name"].ToString(), Value = row["User_Group_ID"].ToString(), Selected = selected
                    });
                }
            }
            model.RolesList = new List <SelectListItem>();
            //ds = new DataSet();
            //xmldata = Client.GetRoles(0);
            //ds.ReadXml(new StringReader(xmldata));
            //xmldata = Client.getUserRoles(model.User.UserId);
            //dsgroup = new DataSet();
            //dsgroup.ReadXml(new StringReader(xmldata));
            //if (ds.Tables.Count > 0)
            //{
            //    foreach (System.Data.DataRow row in ds.Tables[0].Rows)
            //    {
            //        bool selected = false;
            //        if (ds.Tables.Count > 0)
            //            foreach (System.Data.DataRow roleid in dsgroup.Tables[0].Rows)
            //            {
            //                if (Convert.ToInt32(roleid["Role_ID"]) == Convert.ToInt32(row["Role_ID"]))
            //                {
            //                    selected = true;
            //                    break;
            //                }
            //            }
            //        model.RolesList.Add(new SelectListItem { Text = row["Role_Name"].ToString(), Value = row["Role_ID"].ToString(), Selected = selected });
            //    }
            //}
            return(View("_AddUser", model));
        }