public IActionResult Index(SuPreferenceIndexGetWithListsModel FromForm) { SqlParameter[] parameters = { new SqlParameter("@UserId", FromForm.Preference.Id), new SqlParameter("@LanguageId", FromForm.Preference.DefaultLanguageId), new SqlParameter("@CountryId", FromForm.Preference.CountryId) }; _context.Database.ExecuteSqlCommand("PreferenceIndexPost " + "@UserId" + ", @LanguageId" + ", @CountryId", parameters); return(RedirectToAction("Index", "Home")); }
public async Task <IActionResult> Index() { var CurrentUser = await _userManager.GetUserAsync(User); var DefaultLanguageID = CurrentUser.DefaultLanguageId; var UICustomizationArray = new UICustomization(_context); ViewBag.Terms = await UICustomizationArray.UIArray(this.ControllerContext.RouteData.Values["controller"].ToString(), this.ControllerContext.RouteData.Values["action"].ToString(), DefaultLanguageID); Menus a = new Menus(_context); ViewBag.menuItems = await a.TopMenu(DefaultLanguageID); var parameter = new SqlParameter("@Id", CurrentUser.Id); SuPreferenceIndexGetModel preference = _context.ZdbPreferenceIndexGet.FromSql("PreferenceIndexGet @Id", parameter).First(); SuPreferenceIndexGetWithListsModel preferenceWithList = new SuPreferenceIndexGetWithListsModel { Preference = preference }; List <SuCountryList> countryList = _context.ZDbCountryList.FromSql("CountrySelectAll").ToList(); List <SuLanguageList> languageList = _context.ZDbLanguageList.FromSql("LanguageSelectActive").ToList(); List <SelectListItem> countries = new List <SelectListItem>(); List <SelectListItem> languages = new List <SelectListItem>(); foreach (var countryitem in countryList) { countries.Add(new SelectListItem(countryitem.Name, countryitem.Id.ToString())); } preferenceWithList.Countries = countries; foreach (var Languageitem in languageList) { languages.Add(new SelectListItem(Languageitem.Name, Languageitem.Id.ToString())); } preferenceWithList.Languages = languages; return(View(preferenceWithList)); }