public async Task <IActionResult> Edit(SuOrganizationEditGetWithListModel FromForm)
{
SuUserModel CurrentUser = await _userManager.GetUserAsync(User);
SqlParameter[] parameters =
{
new SqlParameter("@OId", FromForm.Organization.OId),
new SqlParameter("@StatusId", FromForm.Organization.OrganizationStatusId),
new SqlParameter("@TypeId", FromForm.Organization.OrganizationTypeId),
new SqlParameter("@LId", FromForm.Organization.LId),
new SqlParameter("@LanguageId", FromForm.Organization.LanguageId),
new SqlParameter("@Name", FromForm.Organization.Name ?? ""),
new SqlParameter("@Description", FromForm.Organization.Description ?? ""),
new SqlParameter("@MouseOver", FromForm.Organization.MouseOver ?? ""),
new SqlParameter("@MenuName", FromForm.Organization.MenuName ?? ""),
new SqlParameter("@ModifierId", CurrentUser.Id)
};
_context.Database.ExecuteSqlCommand("OrganizationEditPost " +
"@OId" +
", @StatusId" +
", @TypeId" +
", @LId" +
", @LanguageId" +
", @Name" +
", @Description" +
", @MouseOver" +
", @MenuName" +
", @ModifierId", parameters);
return(RedirectToAction("Index"));
}
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);
}
