public IActionResult UserContact(Userxml UserDataxml)
        {
            _UserServices.UpdateUserDetails(UserDataxml);
            UserContactDetails model = new UserContactDetails();

            model.UserDataTableList = _UserServices.GetUserinfo(0);
            return(PartialView("UserList", model));
        }
        public void UpdateUserDetails(Userxml Userxml)
        {
            var Uservar = new SqlParameter("@User", Userxml.GetXml());

            try
            {
                _Context.Database.ExecuteSqlCommand("Exec Userdetails @User", Uservar);
            }
            catch (Exception Ex)
            {
                Console.WriteLine(Ex);
            }
        }
        public IActionResult Edit(int SN)
        {
            UserContactDetails model = new UserContactDetails();

            model.UserDataTableList = _UserServices.GetUserinfo(SN);
            Userxml Userxml = new Userxml();

            foreach (var item in model.UserDataTableList)
            {
                Userxml.SNo     = item.SNo;
                Userxml.Name    = item.Name;
                Userxml.Surname = item.Surname;
                Userxml.Gender  = item.Gender;
                Userxml.Email   = item.Email;
            }
            model.UserDataxml = Userxml;
            return(PartialView("UserContact", model));
        }