public async Task <IActionResult> View(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);
SqlParameter[] parameters =
{
new SqlParameter("@Id", Id)
, new SqlParameter("@CurrentUser", CurrentUser.Id)
};
var FrontPageContent = _context.ZdbFrontPageViewGet.FromSql("FrontPageViewGet @Id, @CurrentUser", parameters).First();
var FrontPageContentClassificationValues = _context.ZdbSuFrontPageViewGetClassificationValues.FromSql("FrontPageViewGetClassificationValues @Id, @CurrentUser", parameters).ToList();
SuFrontPageViewGetWithValuesModel ContentWithValues = new SuFrontPageViewGetWithValuesModel
{
Content = FrontPageContent,
Values = FrontPageContentClassificationValues
};
return(View(ContentWithValues));
}
public async Task <IActionResult> LanguageDelete(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 x = new Menus(_context);
ViewBag.menuItems = await x.TopMenu(DefaultLanguageID);
var PageLanguage = _pageLanguage.DeletePageLanguage(Id);
var a = new SuObjectVM
{
Id = PageLanguage.Id,
Name = PageLanguage.Name,
Description = PageLanguage.Description,
MouseOver = PageLanguage.MouseOver,
LanguageId = PageLanguage.LanguageId,
ObjectId = PageLanguage.PageId
};
return(View(a));
}
public async Task <IActionResult> Index(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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@Id", Id)
};
var ClassificationPage = _context.ZdbObjectIndexGet.FromSql("ClassificationPageIndexGet @Id, @LanguageId", parameters).ToList();
//PETER Why do I need this viewbag
ViewBag.PId = Id;
return(View(ClassificationPage));
}
public async Task <IActionResult> Create(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);
SqlParameter[] parameters =
{
new SqlParameter("@CurrentUser", CurrentUser.Id)
, new SqlParameter("@Id", Id)
};
SuFrontProcessCreateGetModel FrontProcess = _context.ZdbFrontProcessCreateGet.FromSql("FrontProcessCreateGet @CurrentUser, @Id", parameters).First();
List <SuFrontProcessCreateGetFieldModel> FrontProcessFields = _context.ZdbFrontProcessCreateGetField.FromSql("FrontProcessCreateGetField @CurrentUser, @Id", parameters).ToList();
FrontProcess.ProcessFields = FrontProcessFields;
return(View(FrontProcess));
}
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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@Id", Id)
};
SqlParameter parameter = new SqlParameter("@Id", Id);
SuClassificationValueEditGetModel ClassificationValueEditGet = _context.ZdbClassificationValueEditGet.FromSql("ClassificationValueEditGet @LanguageId, @Id", parameters).First();
SuClassificationValueEditGetLevelModel ClassificationValueEditGetLevel = _context.ZdbClassificationValueEditGetLevel.FromSql("ClassificationValueEditGetLevel @Id", parameter).First();
ClassificationValueEditGet.DateLevel = ClassificationValueEditGetLevel.DateLevel;
ClassificationValueEditGet.InDropDown = ClassificationValueEditGetLevel.InDropDown;
return(View(ClassificationValueEditGet));
}
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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@PId", Id)
};
List <SuFrontProcessTodoEditGetModel> ToDo = _context.ZdbSuFrontProcessTodoEditGet.FromSql("FrontProcessToDoEditGet @LanguageId, @PId", parameters).ToList();
return(View(ToDo));
}
public async Task <IActionResult> LanguageEdit(SuObjectLanguageEditGetModel FromForm)
{
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);
if (ModelState.IsValid)
{
SqlParameter[] parameters =
{
new SqlParameter("@LId", FromForm.LId),
new SqlParameter("@ModifierId", CurrentUser.Id),
new SqlParameter("@MenuName", FromForm.MenuName),
new SqlParameter("@MouseOver", FromForm.MouseOver)
};
_context.Database.ExecuteSqlCommand("Menu1LanguageEditPost " +
"@LId" +
", @ModifierId" +
", @MenuName" +
", @MouseOver", parameters);
return(RedirectToAction("LanguageIndex", new { Id = FromForm.OId.ToString() }));
}
return(View());
}
public async Task <IActionResult> Index(string 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);
_ = new List <SuIdWithStrings>();
SqlParameter[] parameters =
{
new SqlParameter("@User", Id)
, new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
};
List <SuIdWithStrings> UserOrganizationFromDb = _context.DbIdWithStrings.FromSql("UserOrganizationSelectAll @User, @LanguageId", parameters).ToList();
//}
ViewBag.ObjectId = Id;
return(View(UserOrganizationFromDb));
}
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 x = new Menus(_context);
ViewBag.menuItems = await x.TopMenu(DefaultLanguageID);
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var a = _context.ZDbGetProjectStructure.FromSql("ProjStructure @LanguageId", parameter).ToList();
int maxLevel = 0;
foreach (var Org in a)
{
if (Org.Level > maxLevel)
{
maxLevel = Org.Level;
}
}
var c = new ProjStructureWithDepth {
MaxLevel = maxLevel, ProjStructure = a
};
return(View(c));
}
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);
var ToForm = (from s in _ProcessTemplateFieldType.GetAllProcessTemplateFieldTypes()
join t in _ProcessTemplateFieldTypeLanguage.GetAllProcessTemplateFieldTypeLanguages()
on s.Id equals t.FieldTypeId
where t.LanguageId == CurrentUser.DefaultLanguageId && s.Id == Id
select new SuObjectVM
{
Id = s.Id
,
Name = t.Name
,
ObjectLanguageId = t.Id
,
Description = t.Description
,
MouseOver = t.MouseOver
}).First();
return(View(ToForm));
}
public async Task <IActionResult> Index(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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@PId", Id)
};
var Condition = _context.ZdbObjectIndexGet.FromSql("ProcessTemplateFlowConditionIndexGet @LanguageId, @PId", parameters).ToList();
return(View(Condition));
}
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 x = new Menus(_context);
ViewBag.menuItems = await x.TopMenu(DefaultLanguageID);
var AllUsers = await _userManager.Users.ToListAsync();
List <SuObjectVM> UserList = new List <SuObjectVM>();
foreach (var a in AllUsers)
{
UserList.Add(new SuObjectVM
{
Description2 = a.Id
,
Name = a.UserName
, Description = a.Email
});
}
return(View(UserList));
}
public async Task <IActionResult> Delete(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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@Id", Id)
};
SuMenu1DeleteGetModel Menu1 = _context.ZdbMenu1DeleteGet.FromSql("Menu1DeleteGet @LanguageId, @Id", parameters).First();
return(View(Menu1));
}
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);
ViewBag.menuItems = await a.TopMenu(DefaultLanguageID);
var ToForm = (
from l in _setting.GetAllSettings()
select new SuObjectVM
{
Id = l.Id
,
Name = l.SettingName
, NullId = l.IntValue
, Description2 = l.StringValue
, DateFrom = l.DateTimeValue
}).ToList();
return(View(ToForm));
}
public async Task <IActionResult> Create(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);
var ProcessTemplateStep = new SuObjectVM
{
Id = Id
,
LanguageId = CurrentUser.DefaultLanguageId
};
//DataTypes
return(View(ProcessTemplateStep));
}
public async Task <IActionResult> Index(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);
var ProcessTemplateStep = (from c in _processTemplateStep.GetAllProcessTemplateSteps()
join l in _processTemplateStepLanguage.GetAllProcessTemplateStepLanguages()
on c.Id equals l.StepId
where c.ProcessTemplateId == Id &&
l.LanguageId == CurrentUser.DefaultLanguageId
orderby l.Name
select new SuObjectVM
{
Id = c.Id
,
Name = l.Name
,
ObjectId = c.ProcessTemplateId
}).ToList();
ViewBag.ObjectId = Id.ToString();
return(View(ProcessTemplateStep));
}
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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@Id", Id)
};
var Menu2EditGet = _context.ZdbMenu2EditGet.FromSql("Menu2EditGet @LanguageId, @Id", parameters).First();
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var Classifications = _context.ZDbTypeList.FromSql("Menu123EditGetClassificationList @LanguageId", parameter).ToList();
var ClassificationList = new List <SelectListItem>();
foreach (var Classification in Classifications)
{
ClassificationList.Add(new SelectListItem
{
Text = Classification.Name,
Value = Classification.Id.ToString()
});
}
var MenuTypes = _context.ZDbTypeList.FromSql("MenuTypeList").ToList();
var MenuTypeList = new List <SelectListItem>();
foreach (var MenuType in MenuTypes)
{
MenuTypeList.Add(new SelectListItem
{
Text = MenuType.Name,
Value = MenuType.Id.ToString()
});
}
SuMenu2EditGetWithListModel Menu2WithList = new SuMenu2EditGetWithListModel
{
Menu2 = Menu2EditGet,
ClassificationList = ClassificationList,
MenuTypeList = MenuTypeList
};
return(View(Menu2WithList));
}
public async Task <IActionResult> Edit(SuContentTypeClassificationEditGetModelWithListModel FromForm)
{
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);
SqlParameter[] parameters =
{
new SqlParameter("@Id", FromForm.Classification.Id),
new SqlParameter("@StatusId", FromForm.Classification.StatusId)
};
_context.Database.ExecuteSqlCommand("ContentTypeClassificationEditPost " +
"@Id" +
", @StatusID", parameters);
return(RedirectToAction("Index", new { Id = FromForm.Classification.ContentTypeId }));
}
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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@Id", Id)
};
var ContentTypeEditGet = _context.ZdbContentTypeEditGet.FromSql("ContentTypeEditGet @LanguageId, @Id", parameters).First();
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
List <SuTypeList> SecurityLevelFromDb = await _context.ZDbTypeList.FromSql("select Id, Name from DbSecurityLevel ORDER BY Name").ToListAsync();
List <SuStatusList> ProcessTemplateFromDb = await _context.ZDbStatusList.FromSql("ProcessTemplateList @LanguageId", parameter).ToListAsync();
List <SelectListItem> SecurityLevelList = new List <SelectListItem>();
foreach (var SecurityItem in SecurityLevelFromDb)
{
SecurityLevelList.Add(new SelectListItem {
Value = SecurityItem.Id.ToString(), Text = SecurityItem.Name
});
}
List <SelectListItem> ProcessTemplateList = new List <SelectListItem>();
ProcessTemplateList.Add(new SelectListItem {
Value = "0", Text = "No approval"
});
foreach (var ProcessTemplateItem in ProcessTemplateFromDb)
{
ProcessTemplateList.Add(new SelectListItem {
Value = ProcessTemplateItem.Id.ToString(), Text = ProcessTemplateItem.Name
});
}
SuContentTypeEditGetWithListModel ContentTypeWithLists = new SuContentTypeEditGetWithListModel();
ContentTypeWithLists.ContentType = ContentTypeEditGet;
ContentTypeWithLists.SecurityLevelList = SecurityLevelList;
ContentTypeWithLists.ProcessTemplateList = ProcessTemplateList;
return(View(ContentTypeWithLists));
}
public async Task <IActionResult> Index(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);
SuInt MaxLevel = new SuInt
{
intValue = 0
};
var parameter = new SqlParameter("@Id", Id);
try
{
MaxLevel = _context.ZdbInt.FromSql("ClassificationValueIndexGetMaxLevel @Id", parameter).First();
}
catch { }
SuInt CurrentLevel = new SuInt
{
intValue = 0
};
try
{
CurrentLevel = _context.ZdbInt.FromSql("ClassificationValueIndexGetCurrentLevel @Id", parameter).First();//? null : new SuInt { intValue = 0 };
}
catch { }
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@Id", Id)
};
var ValueStructure = _context.ZdbClassificationValueIndexGet.FromSql("ClassificationValueIndexGet @LanguageId, @Id", parameters).ToList();
ViewBag.CId = Id.ToString();
new ValueStructureWithDepth {
MaxLevel = MaxLevel.intValue, ValueStructure = ValueStructure, MaxConfigLevel = CurrentLevel.intValue
};
var c = new ValueStructureWithDepth {
MaxLevel = MaxLevel.intValue, ValueStructure = ValueStructure, MaxConfigLevel = CurrentLevel.intValue
};
return(View(c));
}
public async Task <IActionResult> Create(string 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);
var OrganizationList = new List <SelectListItem>();
var TypeList = new List <SelectListItem>();
SqlParameter[] parameters =
{
new SqlParameter("@UserId", Id)
, new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
};
var OrganizationsFromDB = _context.ZDbStatusList.FromSql("UserOrganizationNewOrganizationsSelect @UserId, @LanguageId", parameters).ToList();
foreach (var OrganizationFromDB in OrganizationsFromDB)
{
OrganizationList.Add(new SelectListItem
{
Value = OrganizationFromDB.Id.ToString(),
Text = OrganizationFromDB.Name
});
}
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var TypesFromDB = _context.ZDbTypeList.FromSql("UserOrganizationTypeSelectAll @LanguageId", parameter).ToList();
foreach (var TypeFromDB in TypesFromDB)
{
TypeList.Add(new SelectListItem
{
Value = TypeFromDB.Id.ToString(),
Text = TypeFromDB.Name
});
}
SuObjectVM NewUserOrganization = new SuObjectVM
{
Description = Id
};
var ClassificationAndStatus = new SuObjectAndStatusViewModel {
SuObject = NewUserOrganization, SomeKindINumSelectListItem = OrganizationList, ProbablyTypeListItem = TypeList
};
return(View(ClassificationAndStatus));
}
public async Task <IActionResult> Create(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);
var ParentOrganization = _Organization.GetOrganization(Id);
var StatusListFromDb = _context.ZDbStatusList.FromSql("OrganizatonCreateGetStatusList").ToList();
var StatusList = new List <SelectListItem>();
foreach (var StatusFromDb in StatusListFromDb)
{
StatusList.Add(new SelectListItem
{
Text = StatusFromDb.Name,
Value = StatusFromDb.Id.ToString()
});
}
var parameter = new SqlParameter("@Id", Id);
var TypeListFromDb = _context.ZDbTypeList.FromSql("OrganizatonCreateGetTypeList @Id", parameter).ToList();
var TypeList = new List <SelectListItem>();
foreach (var TypeFromDb in TypeListFromDb)
{
TypeList.Add(new SelectListItem
{
Text = TypeFromDb.Name,
Value = TypeFromDb.Id.ToString()
});
}
SuObjectVM Parent = new SuObjectVM()
{
NullId = ParentOrganization == null ? 0 : ParentOrganization.Id
};
var OrganizationAndStatus = new SuObjectAndStatusViewModel {
SuObject = Parent, SomeKindINumSelectListItem = StatusList, ProbablyTypeListItem = TypeList
};
return(View(OrganizationAndStatus));
}
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);
SqlParameter[] parameters =
{
new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@OId", Id)
};
SuClassificationPageSectionEditGetModel ClassificationPageSectionEditGet = _context.ZdbClassificationPageSectionEditGet.FromSql("ClassificationPageSectionEditGet @LanguageId, @OId", parameters).First();
var ContentTypeList = new List <SelectListItem>();
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var ContentTypesFromDb = _context.ZDbTypeList.FromSql("ContentTypeSelectAllForLanguage @LanguageId", parameter).ToList();
foreach (var ContentTypeFromDb in ContentTypesFromDb)
{
ContentTypeList.Add(new SelectListItem
{
Text = ContentTypeFromDb.Name,
Value = ContentTypeFromDb.Id.ToString()
});
}
var PageSectionTypeList = new List <SelectListItem>();
var PageSectionTypesFromDb = _context.ZDbStatusList.FromSql("PageSectionTypeSelectAllForLanguage @LanguageId", parameter).ToList();
foreach (var PageSectionTypeFromDb in PageSectionTypesFromDb)
{
PageSectionTypeList.Add(new SelectListItem
{
Text = PageSectionTypeFromDb.Name,
Value = PageSectionTypeFromDb.Id.ToString()
});
}
SuClassificationPageSectionEditGetWithListModel ClassificationPageSectionWithList = new SuClassificationPageSectionEditGetWithListModel
{
ClassificationPageSection = ClassificationPageSectionEditGet
, ContentTypeList = ContentTypeList
, SectionTypeList = PageSectionTypeList
};
return(View(ClassificationPageSectionWithList));
}
private void OnEnable()
{
if (_currentSelectedColor != null)
{
text.text = "Price: " + _currentSelectedColor.itemData.sbPrice + " SB";
}
_uiCustomizationManager = FindObjectOfType <UICustomization>();
PlayFabClientAPI.GetCatalogItems(new GetCatalogItemsRequest(), AddColors, GetCatalogItemsError);
}
public async Task <IActionResult> Edit(string 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);
var UserFromDb = await _userManager.FindByIdAsync(Id);
CreateUserViewModel UserToForm = new CreateUserViewModel
{
Id = UserFromDb.Id,
UserName = UserFromDb.UserName,
Email = UserFromDb.Email,
DefaultLanguageId = UserFromDb.DefaultLanguageId,
CountryId = UserFromDb.CountryId
};
var LanguageList = new List <SelectListItem>();
var LanguagesFromDb = _context.ZDbLanguageList.FromSql("LanguageSelectAll").ToList();
foreach (var LanguageFromDb in LanguagesFromDb)
{
LanguageList.Add(new SelectListItem
{
Text = LanguageFromDb.Name,
Value = LanguageFromDb.Id.ToString()
});
}
var CountryList = new List <SelectListItem>();
var CountriesFromDb = _context.ZDbCountryList.FromSql("CountrySelectAll").ToList();
foreach (var CountryFromDb in CountriesFromDb)
{
CountryList.Add(new SelectListItem
{
Text = CountryFromDb.Name,
Value = CountryFromDb.Id.ToString()
});
}
SuUserAndLists UserAndLists = new SuUserAndLists {
User = UserToForm, Countries = CountryList, Languages = LanguageList
};
return(View(UserAndLists));
}
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);
var ProcessTemplateToForm = (from s in _processTemplate.GetAllProcessTemplates()
join t in _processTemplateLanguage.GetAllProcessTemplateLanguages()
on s.Id equals t.ProcessTemplateId
where t.LanguageId == CurrentUser.DefaultLanguageId && s.Id == Id
select new SuObjectVM
{
Id = s.Id
,
Name = t.Name
,
NotNullId = s.ProcessTemplateGroupId
,
ObjectLanguageId = t.Id
,
Description = t.Description
,
MouseOver = t.MouseOver
}).First();
var ClassificationList = new List <SelectListItem>();
//string a;
//a = ToForm.Description;
var ProcessTemplateGroupList = new List <SelectListItem>();
var parameter = new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId);
var ProcessTemplateGroupFromDb = _context.ZDbTypeList.FromSql("GetProcessTemplateGroup @LanguageId", parameter).ToList();
foreach (var ProcessTemplateGroup in ProcessTemplateGroupFromDb)
{
ProcessTemplateGroupList.Add(new SelectListItem
{
Text = ProcessTemplateGroup.Name,
Value = ProcessTemplateGroup.Id.ToString()
});
}
var ProcessTemplateAndGroup = new SuObjectAndStatusViewModel {
SuObject = ProcessTemplateToForm, SomeKindINumSelectListItem = ProcessTemplateGroupList
};
return(View(ProcessTemplateAndGroup));
}
public async Task <IActionResult> Rights(string 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);
var NewClaims = new List <AddRightsToRoleViewModel>();
var AllClaimList = _claim.GetAllClaims();
var role = await _roleManager.FindByIdAsync(Id);
var AssignedClaims = await _roleManager.GetClaimsAsync(role);
foreach (var AllClaim in AllClaimList)
{
bool AlreadyHave = false;
foreach (var AssignedClaim in AssignedClaims)
{
if (AllClaim.Claim == AssignedClaim.Value)
{
AlreadyHave = true;
}
}
var NewClaim = new AddRightsToRoleViewModel
{
RoleID = Id
,
ClaimType = "Menu"
,
ClaimValue = AllClaim.Claim
};
if (!AlreadyHave)
{
NewClaim.IsSelected = false;
}
else
{
NewClaim.IsSelected = true;
}
NewClaims.Add(NewClaim);
}
ViewBag.Id = Id;
return(View(NewClaims));
}
public async Task <IActionResult> Create(SuClassificationLevelEditGetWithListModel FromForm)
{
if (ModelState.IsValid)
{
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);
SqlParameter[] parameters =
{
new SqlParameter("@PId", FromForm.ClassificationLevel.PId)
, new SqlParameter("@LanguageId", CurrentUser.DefaultLanguageId)
, new SqlParameter("@Sequence", FromForm.ClassificationLevel.Sequence)
, new SqlParameter("@DateLevel", FromForm.ClassificationLevel.DateLevel)
, new SqlParameter("@OnTheFly", FromForm.ClassificationLevel.OnTheFly)
, new SqlParameter("@Alphabetically", FromForm.ClassificationLevel.Alphabetically)
, new SqlParameter("@CanLink", FromForm.ClassificationLevel.CanLink)
, new SqlParameter("@InDropDown", FromForm.ClassificationLevel.InDropDown)
, new SqlParameter("@InMenu", FromForm.ClassificationLevel.InMenu)
, new SqlParameter("@ModifierId", CurrentUser.Id)
, new SqlParameter("@Name", FromForm.ClassificationLevel.Name)
, new SqlParameter("@Description", FromForm.ClassificationLevel.Description)
, new SqlParameter("@MouseOver", FromForm.ClassificationLevel.MouseOver)
, new SqlParameter("@MenuName", FromForm.ClassificationLevel.MenuName)
};
_context.Database.ExecuteSqlCommand("ClassificationLevelCreatePost " +
"@PId" +
", @LanguageId" +
", @Sequence" +
", @DateLevel" +
", @OnTheFly" +
", @Alphabetically" +
", @CanLink" +
", @InDropDown" +
", @InMenu" +
", @ModifierId" +
", @Name" +
", @Description" +
", @MouseOver" +
", @MenuName", parameters);
}
return(RedirectToAction("Index", new { Id = FromForm.ClassificationLevel.PId.ToString() }));
}
public async Task <IActionResult> Users(string 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);
var NewUsers = new List <AddUsersToRoleViewModel>();
var AllUserList = _userManager.Users;
var role = await _roleManager.FindByIdAsync(Id);
var AssignedUsers = await _userManager.GetUsersInRoleAsync(role.Name);
foreach (var user in AllUserList)
{
bool AlreadyHave = false;
foreach (var AssignedUser in AssignedUsers)
{
if (user == AssignedUser)
{
AlreadyHave = true;
}
}
var NewUser = new AddUsersToRoleViewModel
{
RoleId = Id
,
UserName = user.UserName
};
if (!AlreadyHave)
{
NewUser.IsSelected = false;
}
else
{
NewUser.IsSelected = true;
}
NewUsers.Add(NewUser);
}
ViewBag.Id = Id;
return(View(NewUsers));
}
public async Task <IActionResult> Create1()
{
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("@CurrentUser", CurrentUser.Id);
var ContentTypeGroupsFromDb = _context.ZDbTypeList.FromSql("ContentCreate1GetContentTypeGroup @CurrentUser", parameter).ToList();
var GroupList = new List <ContentCreate1GetContentTypeGroup>();
foreach (var GroupFromDb in ContentTypeGroupsFromDb)
{
var TypeList = new List <ContentCreate1GetContentType>();
SqlParameter[] parameters =
{
new SqlParameter("@CurrentUser", CurrentUser.Id)
, new SqlParameter("@Id", GroupFromDb.Id)
};
var ContentTypesFromDb = _context.ZDbTypeList.FromSql("ContentCreate1GetContentType @CurrentUser, @Id", parameters).ToList();
foreach (var TypeFromDb in ContentTypesFromDb)
{
TypeList.Add(new ContentCreate1GetContentType
{
name = TypeFromDb.Name,
Id = TypeFromDb.Id
});
}
GroupList.Add(new ContentCreate1GetContentTypeGroup
{
Name = GroupFromDb.Name,
Id = GroupFromDb.Id,
Types = TypeList
});
}
return(View(GroupList));
}
