public async Task <IActionResult> Edit(int Id) { 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); //LISTS var StatusList = new List <SelectListItem>(); foreach (var StatusFromDb in _OrganizationStatus.GetAllOrganizationStatus()) { StatusList.Add(new SelectListItem { Text = StatusFromDb.Name, Value = StatusFromDb.Id.ToString() }); } //wwwwwwwwwwwwwwwwwwwwwwwwww var ToForm = (from o in _organizationType.GetAllOrganizationTypes() join l in _organizationTypeLanguage.GetAllOrganizationTypeLanguages() on o.Id equals l.OrganizationTypeId where l.LanguageId == CurrentUser.DefaultLanguageId select new SuObjectVM { Id = o.Id , Name = l.Name }).ToList(); var TypeList = new List <SelectListItem>(); foreach (var TypeFromDb in ToForm) { TypeList.Add(new SelectListItem { Text = TypeFromDb.Name, Value = TypeFromDb.Id.ToString() }); } //wwwwwwwwwwwwwwwwwwwwwwww //LISTS SqlParameter[] parameters = { new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId) , new SqlParameter("@Id", Id) }; SuOrganizationEditGetModel Organization = _context.ZdbOrganizationEditGet.FromSql("OrganizationEditGet @LanguageId, @Id", parameters).First(); SuOrganizationEditGetWithListModel OrganizationWithList = new SuOrganizationEditGetWithListModel { StatusList = StatusList, TypeList = TypeList, Organization = Organization }; return(View(OrganizationWithList)); //var ToForm = (from s in _Organization.GetAllOrganizations() // join t in _OrganizationLanguage.GetAllOrganizationLanguages() // on s.Id equals t.OrganizationId // where t.LanguageId == DefaultLanguageID && s.Id == Id // select new SuObjectVM // { // Id = s.Id // , // Name = t.Name // , // Status = s.OrganizationStatusId // , // ObjectLanguageId = t.Id // , // Description = t.Description // , // MouseOver = t.MouseOver // }).First(); //var OrganizationList = new List<SelectListItem>(); //foreach (var OrganizationFromDb in _OrganizationStatus.GetAllOrganizationStatus()) //{ // OrganizationList.Add(new SelectListItem // { // Text = OrganizationFromDb.Name, // Value = OrganizationFromDb.Id.ToString() // }); //} //var OrganizationAndStatus = new SuObjectAndStatusViewModel { SuObject = ToForm, SomeKindINumSelectListItem = OrganizationList }; //return View(OrganizationAndStatus); }