public static IViewModel GetRoleAvailableDepartments(string search, Guid?userId, Guid?roleId) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <DepartmentViewModel> data = new EntitiesViewModel <DepartmentViewModel> { Result = Result.Ok }; var tempRoleDepartments = context.RoleDepartments.Where(o => o.RoleId == roleId).AsNoTracking(); var tempDepartmemts = context.Departments.Join(tempRoleDepartments, d => d.Id, rd => rd.DepartmentId, (d, rd) => new DepartmentViewModel { Id = d.Id, Name = d.Name, ShortName = d.ShortName }) .Where(o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((search ?? string.Empty).ToLower()) ).ToList(); data.Entities = tempDepartmemts; return(data); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public async Task <IActionResult> All([Bind("Date,Values,Headers,IsActive,Command,PreSelectedColumns,SelectedColumns")] EntitiesViewModel model) { var user = await this.service.GetUser(this.User); var userColumns = this.service.GetLayout <UserShareClassColumn>(this.repository, user.Id); var columnsToDb = this.service.SetLayout <UserShareClassColumn>(model, user.Id, userColumns); await this.repository.SaveLayout(user.UserShareClassColumns, columnsToDb); await EntitiesVMSetup.SetPost(model, this.service, SqlFunctionDictionary.AllShareClass, SqlFunctionDictionary.AllActiveShareClass); if (model.Values != null && model.Values.Count > 0) { return(this.View(model)); } return(this.ShowError( this.sharedLocalizer.GetHtmlString(ErrorMessages.UnsuccessfulUpdate), EndpointsConstants.ActionAll, EndpointsConstants.ShareClassesController)); }
public static IViewModel GetUserAcademicDegrees(Guid?userId) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <AcademicDegreeViewModel> data = new EntitiesViewModel <AcademicDegreeViewModel> { Result = Result.Ok }; var tempEntities = context.AcademicDegreeUsers.Where(o => o.UserId == userId).AsNoTracking(); data.Entities = context.AcademicDegrees.Join(tempEntities, a => a.Id, ua => ua.AcademicDegreeId, (a, ua) => new AcademicDegreeViewModel { Id = a.Id, Name = a.Name + " " + context.BranchesOfScience .Where(b => b.Id == a.BranchOfScienceId) .Select(b => b.Name).FirstOrDefault(), ShortName = a.ShortName + " " + context.BranchesOfScience .Where(b => b.Id == a.BranchOfScienceId).Select(b => b.ShortName) .FirstOrDefault() }) .AsNoTracking().ToList(); return(data); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public HashSet <T> SetLayout <T>(EntitiesViewModel model, string id, IEnumerable <string> userColumns) where T : IUserColumn, new() { var columnsToDb = new HashSet <T>(); if (model.Command == "Save" && model.SelectedColumns != null) { foreach (var column in model.SelectedColumns) { T userColumn = new T { Name = column, UserId = id, }; columnsToDb.Add(userColumn); } model.SelectedColumns = columnsToDb.Select(c => c.Name).ToList(); } else if (model.Command != "Apply" && userColumns.Count() > 0) { model.SelectedColumns = userColumns; } return(columnsToDb); }
public static IViewModel GetUserAvailableRoles(string search, Guid?userId) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <RoleViewModel> data = new EntitiesViewModel <RoleViewModel> { Result = Result.Ok }; List <Guid> userRoleIds = new List <Guid>(); if (userId.HasValue) { userRoleIds = context.UserRoles.Where(o => o.UserId == userId).Select(o => o.RoleId).ToList(); } data.Entities = context.Roles.Where(o => !userRoleIds.Contains(o.Id)) .Where(o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower())) .Select(o => new RoleViewModel { Id = o.Id, Name = o.Name, TiedToDepartment = context.RoleDepartments.Where(rd => rd.RoleId == o.Id).Count() > 0 }) .ToList(); return(data); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public static IViewModel GetEntitiesWithJoin <TSource1, TSource2, TKey, TViewModel>(Func <TSource1, bool> searchFunc, Func <TSource1, TKey> innerKeySelector, Func <TSource2, TKey> outerKeySelector, Func <TSource2, TSource1, TViewModel> joinSelector) where TSource1 : class where TSource2 : class { try { using (DBContext context = new DBContext()) { EntitiesViewModel <TViewModel> result = new EntitiesViewModel <TViewModel> { Result = Result.Ok }; IEnumerable <TSource1> tempCollection = context.Set <TSource1>() .AsNoTracking() .Where(searchFunc); result.Entities = context.Set <TSource2>() .Join(tempCollection, outerKeySelector, innerKeySelector, joinSelector) .ToList(); return(result); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public static IViewModel GetNotRoleRights(Guid?roleId, string search) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <RightViewModel> data = new EntitiesViewModel <RightViewModel> { Result = Result.Ok }; var tempEntities = context.RightRoles.Where(o => o.RoleId != roleId).AsNoTracking(); data.Entities = context.Rights.Join(tempEntities, r => r.Id, rr => rr.RightId, (r, rr) => new RightViewModel { Id = r.Id, Name = r.Name }) .Where(o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower())) .ToList(); return(data); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public static IViewModel GetEntities <TSource, TViewModel>(Func <TSource, bool> searchFunc, Func <TSource, TViewModel> selectFunc) where TSource : class { try { using (DBContext context = new DBContext()) { EntitiesViewModel <TViewModel> result = new EntitiesViewModel <TViewModel> { Result = Result.Ok }; result.Entities = context.Set <TSource>() .AsNoTracking() .Where(searchFunc) .Select(selectFunc) .ToList(); return(result); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public async Task <IActionResult> All([Bind("Date,Values,Headers,IsActive,Command,PreSelectedColumns,SelectedColumns")] EntitiesViewModel model) { var user = await this.layoutService.UserWithLayouts(this.User); var userColumns = this.layoutService.GetLayout <UserSubFundColumn>(this.repository, user.Id); if (userColumns.Count() > 0) { model.SelectedColumns = userColumns; } await EntitiesVMSetup.SetPost(model, this.service, SqlFunctionDictionary.AllSubFund, SqlFunctionDictionary.AllActiveSubFund); if (model.Values != null && model.Values.Count > 0) { return(this.View(model)); } return(this.ShowError( this.sharedLocalizer.GetHtmlString(ErrorMessages.UnsuccessfulUpdate), EndpointsConstants.ActionAll, EndpointsConstants.DisplaySub + EndpointsConstants.FundsController)); }
public static IViewModel GetDepartments(int page, int limit, string order, bool isAscending, string search) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <DepartmentViewModel> result = new EntitiesViewModel <DepartmentViewModel> { Result = Result.Ok }; var tempEntities = context.Departments.Where(o => o.IsFaculty).Join(context.Departments.Where(o => !o.IsFaculty).AsNoTracking(), fo => fo.Id, so => so.FacultyId, (fo, so) => new DepartmentViewModel { FacultyId = fo.Id, FacultyName = fo.Name ?? string.Empty, FacultyShortName = fo.ShortName ?? string.Empty, Id = so.Id, Name = so.Name, ShortName = so.ShortName, Code = so.Code ?? 0 }).ToList(); tempEntities.AddRange(context.Departments.Where(o => !o.IsFaculty && o.FacultyId == null).Select(o => new DepartmentViewModel { Code = o.Code ?? 0, Id = o.Id, Name = o.Name, ShortName = o.ShortName })); var tempCollection = tempEntities.Where( o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.FacultyName.ToLower().Contains((search ?? string.Empty).ToLower())) .ToList(); result.Total = tempCollection.Count; result.Entities = isAscending ? tempCollection .OrderBy(order) .Skip((page - 1) * limit) .Take(limit) .ToList() : tempCollection .OrderByDescending(order) .Skip((page - 1) * limit) .Take(limit) .ToList(); result.Page = page; return(result); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public JsonResult GetWorkingCirriculumTypesOfEducation(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <TypeOfEducation, string>( o => o.Name.ToLower().Contains((model.Search ?? string.Empty).ToLower()), o => o.Name); return(Json(data, JsonRequestBehavior.AllowGet)); }
public static IViewModel GetWorkingCirriculums(int page, int limit, string order, bool isAscending, string search) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <WorkingCirriculumViewModel> data = new EntitiesViewModel <WorkingCirriculumViewModel> { Result = Result.Ok }; var tempEntities = context.Departments.Where(o => !o.IsFaculty).Join(context.WorkingCirriculums.AsNoTracking(), d => d.Id, w => w.DepartmentId, (d, w) => new WorkingCirriculumViewModel { Id = w.Id, AreaOfTrainingId = w.AreaOfTrainingId, StartTraining = w.StartTraining, TrainingPeriod = w.TrainingPeriod, TypeOfEducationName = w.TypeOfEducationName, AreaOfTrainingName = context.AreasOfTraining.Where(a => a.Id == w.AreaOfTrainingId).Select(a => a.Name).FirstOrDefault(), DepartmentId = d.Id, DepartmentName = d.Name, EducationalStandart = w.EducationalStandart, FacultyId = context.Departments.Where(f => f.IsFaculty && f.Id == d.FacultyId).Select(f => f.Id).FirstOrDefault(), FacultyName = context.Departments.Where(f => f.IsFaculty && f.Id == d.FacultyId).Select(f => f.Name).FirstOrDefault() }).ToList(); tempEntities = tempEntities.Where(o => o.AreaOfTrainingName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.DepartmentName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.EducationalStandart.ToLower().Contains((search ?? string.Empty).ToLower()) || o.FacultyName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.StartTraining.ToString().ToLower().Contains((search ?? string.Empty).ToLower()) || o.TrainingPeriod.ToString().ToLower().Contains((search ?? string.Empty).ToLower()) || o.TypeOfEducationName.ToLower().Contains((search ?? string.Empty).ToLower())).ToList(); data.Total = tempEntities.Count; data.Entities = isAscending ? tempEntities .OrderBy(order) .Skip((page - 1) * limit) .Take(limit) .ToList() : tempEntities .OrderByDescending(order) .Skip((page - 1) * limit) .Take(limit) .ToList(); data.Page = page; return(data); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public static IViewModel GetAreasOfTraining(int page, int limit, string order, bool isAscending, string search) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <AreaOfTrainingViewModel> data = new EntitiesViewModel <AreaOfTrainingViewModel> { Result = Result.Ok }; var tempEntities = context.AreasOfTraining.AsNoTracking().Join(context.Departments.Where(o => !o.IsFaculty).AsNoTracking(), fo => fo.DepartmentId, so => so.Id, (a, d) => new AreaOfTrainingViewModel { Id = a.Id, Name = a.Name, ShortName = a.ShortName, Code = a.Code, Directionaly = a.Directionaly, LevelOfHigherEducationName = a.LevelOfHigherEducationName, DepartmentId = d.Id, DepartmentName = d.Name, FacultyId = d.FacultyId, FacultyName = context.Departments.Where(o => o.IsFaculty && o.Id == d.FacultyId).Select(o => o.Name).FirstOrDefault() }).ToList(); var tempCollection = tempEntities.Where( o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.Directionaly.ToLower().Contains((search ?? string.Empty).ToLower()) || o.LevelOfHigherEducationName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.DepartmentName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.FacultyName.ToLower().Contains((search ?? string.Empty).ToLower()) ).ToList(); data.Total = tempCollection.Count; data.Entities = isAscending ? tempCollection .OrderBy(order) .Skip((page - 1) * limit) .Take(limit) .ToList() : tempCollection .OrderByDescending(order) .Skip((page - 1) * limit) .Take(limit) .ToList(); data.Page = page; return(data); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public JsonResult GetWorkingCirriculumAreaOfTrainings(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <AreaOfTraining, AreaOfTrainingViewModel>( o => o.Name.ToLower().Contains((model.Search ?? string.Empty).ToLower()), o => new AreaOfTrainingViewModel { Id = o.Id, Name = o.Name }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetDepartments(EntitiesViewModel model) { var data = DepartmentManager.GetDepartments(model.Page, model.Limit, model.Order, model.IsAscending(), model.Search); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAreaOfTrainingLevelsOfHigherEducation(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <LevelOfHigherEducation, LevelOfHigherEducationViewModel>( o => o.Name.ToLower().Contains((model.Search ?? string.Empty).ToLower()), o => new LevelOfHigherEducationViewModel { Name = o.Name }); return(Json(data, JsonRequestBehavior.AllowGet)); }
private void NavToEntity() { // jeste zjistit jestli na to ma uzivatel prava EntitiesViewModel Temp = new EntitiesViewModel(); Temp.AddEditEntityRequested += NavToAddEditEntity; Temp.StatesEntityRequested += NavToState; CurrentPage = Temp; CurrentPageName = "Entities"; CurrentPage.IsRightsMode = true; //volani permission modulu }
public JsonResult GetRoleRights(EntitiesViewModel model) { var data = BaseEntityManager.GetEntitiesWithJoin <RightRole, Right, Guid, RightViewModel>( o => o.RoleId == model.SearchId, rr => rr.RightId, r => r.Id, (r, rr) => new RightViewModel { Id = r.Id, Name = r.Name }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public static async Task SetPost(EntitiesViewModel model, IEntityService service, string functionAll, string functionActive) { var date = DateTimeParser.FromWebFormat(model.Date); bool isInSelectionMode = model.SelectedColumns != null ? true : false; var headers = await service.GetAll(functionActive, null, date).FirstOrDefaultAsync(); model.Headers = headers.ToList(); model.HeadersSelection = headers.ToList(); // --------------------------------------------------------- // // Algorithm for getting values and headers based on: // 1. Date update of table // 2. Selection mode as columns or not // 3. Active entities or not // 4. Selected entity or not if (isInSelectionMode) { var dto = AutoMapperConfig.MapperInstance.Map <GetWithSelectionDto>(model); if (model.IsActive) { headers = await service.GetAllSelected(functionActive, dto).FirstOrDefaultAsync(); model.Headers = headers.ToList(); model.Values = await service.GetAllSelected(functionActive, dto, 1).ToListAsync(); } else if (!model.IsActive) { headers = await service.GetAllSelected(functionAll, dto, 1).FirstOrDefaultAsync(); model.Headers = headers.ToList(); model.Values = await service.GetAllSelected(functionAll, dto, 1).ToListAsync(); } } else if (!isInSelectionMode) { if (model.IsActive) { model.Values = await service.GetAll(functionActive, null, date, 1).ToListAsync(); } else if (!model.IsActive) { model.Values = await service.GetAll(functionAll, null, date, 1).ToListAsync(); } } if (model.SelectTerm != null) { model.Values = await CreateTableView.AddTableToViewAsync(model.Values, model.SelectTerm.ToLower()).ToListAsync(); } }
public async Task <IActionResult> Entities() { var entities = await _entityService.GetAllEntitiesAsync(); List <EntityViewModel> result = _mapper.Map <List <EntityViewModel> >(entities); EntitiesViewModel vm = new EntitiesViewModel() { Entities = result }; return(View(vm)); }
public JsonResult GetFacultyDepartments(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <Department, DepartmentViewModel>( o => !o.IsFaculty && o.FacultyId == model.SearchId, o => new DepartmentViewModel { Id = o.Id, Name = o.Name, ShortName = o.ShortName }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetCourseTitleDepartments(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <Department, DepartmentViewModel>( o => o.Name.ToLower().Contains((model.Search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((model.Search ?? string.Empty).ToLower()), o => new DepartmentViewModel { Id = o.Id, Name = o.Name }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public async Task <IActionResult> All([Bind("Date,Values,Headers,IsActive,PreSelectedColumns,SelectedColumns,SelectTerm")] EntitiesViewModel viewModel) { await EntitiesVMSetup.SetPost(viewModel, this.service, SqlFunctionDictionary.AllSubFund, SqlFunctionDictionary.AllActiveSubFund); if (viewModel.Values != null && viewModel.Values.Count > 0) { return(this.View(viewModel)); } return(this.ShowError( this.sharedLocalizer.GetHtmlString(ErrorMessages.UnsuccessfulUpdate), GlobalConstants.AllActionName, GlobalConstants.SubFundsControllerName)); }
public JsonResult GetRoles(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <Role, RoleViewModel>( model.Page, model.Limit, model.Order, model.IsAscending(), o => o.Name.ToLower().Contains((model.Search ?? string.Empty).ToLower()), o => new RoleViewModel { Id = o.Id, Name = o.Name }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAcademicTitles(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <AcademicTitle, AcademicTitleViewModel>( o => o.ShortName.ToLower().Contains((model.Search ?? string.Empty).ToLower()) || o.Name.ToLower().Contains((model.Search ?? string.Empty).ToLower()), o => new AcademicTitleViewModel { Id = o.Id, Name = o.Name, ShortName = o.ShortName }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public static async Task SetPost(EntitiesViewModel model, IEntityService service, string functionAll, string functionActive) { var date = DateTimeExtensions.FromWebFormat(model.Date); var headers = await service.All(functionActive, null, date).FirstOrDefaultAsync(); model.Headers = headers.ToList(); model.HeadersSelection = headers.ToList(); bool isInSelectionMode = model.SelectedColumns != null ? true : false; // --------------------------------------------------------- // // Algorithm for getting values and headers based on: // 1. Date update of table // 2. Selected Layout Mode // 3. Active entities if (isInSelectionMode) { var dtoSelected = AutoMapperConfig.MapperInstance.Map <AllSelectedDto>(model); if (model.IsActive) { headers = await service.AllSelected(functionActive, dtoSelected).FirstOrDefaultAsync(); model.Headers = headers.ToList(); model.Values = await service.AllSelected(functionActive, dtoSelected, 1).ToListAsync(); } else if (!model.IsActive) { headers = await service.AllSelected(functionAll, dtoSelected).FirstOrDefaultAsync(); model.Headers = headers.ToList(); model.Values = await service.AllSelected(functionAll, dtoSelected, 1).ToListAsync(); } } else if (!isInSelectionMode) { if (model.IsActive) { model.Values = await service.All(functionActive, null, date, 1).ToListAsync(); } else if (!model.IsActive) { model.Values = await service.All(functionAll, null, date, 1).ToListAsync(); } } }
public JsonResult GetFaculties(EntitiesViewModel model) { var data = BaseEntityManager.GetEntities <Department, DepartmentViewModel>( model.Page, model.Limit, model.Order, model.IsAscending(), o => o.IsFaculty && (o.Name.ToLower().Contains((model.Search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((model.Search ?? string.Empty).ToLower())), o => new DepartmentViewModel { Id = o.Id, Name = o.Name, ShortName = o.ShortName }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public static IViewModel GetCourseTitles(int page, int limit, string order, bool isAscending, string search) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <CourseTitleViewModel> result = new EntitiesViewModel <CourseTitleViewModel> { Result = Result.Ok }; var tempEntities = context.Departments.Join(context.CourseTitles.AsNoTracking(), fo => fo.Id, so => so.DepartmentId, (fo, so) => new CourseTitleViewModel { DepartmentId = fo.Id, DepartmentName = fo.Name, Id = so.Id, Name = so.Name, ShortName = so.ShortName }).ToList(); var entities = isAscending ? tempEntities.Where( o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.DepartmentName.ToLower().Contains((search ?? string.Empty).ToLower())) .OrderBy(order) .Skip((page - 1) * limit) .Take(limit) .ToList() : tempEntities.Where( o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((search ?? string.Empty).ToLower()) || o.DepartmentName.ToLower().Contains((search ?? string.Empty).ToLower())) .OrderByDescending(order) .Skip((page - 1) * limit) .Take(limit) .ToList(); result.Total = context.CourseTitles.AsNoTracking().Count(); result.Entities = entities; result.Page = page; return(result); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public static IViewModel GetNotUserAcademicDegrees(Guid?userId, string search) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <AcademicDegreeViewModel> data = new EntitiesViewModel <AcademicDegreeViewModel> { Result = Result.Ok }; data.Entities = context.AcademicDegrees.Join(context.BranchesOfScience.AsNoTracking(), a => a.BranchOfScienceId, b => b.Id, (a, b) => new AcademicDegreeViewModel { Id = a.Id, Name = a.Name + " " + b.Name.ToLower(), ShortName = a.ShortName + " " + b.ShortName.ToLower() }) .AsNoTracking().ToList(); var userAdIds = context.AcademicDegreeUsers.Where(o => o.UserId == userId).Select(o => o.AcademicDegreeId).ToList(); if (userAdIds.Count > 0) { data.Entities = data.Entities.Where(o => !userAdIds.Contains(o.Id)).ToList(); } data.Entities = data.Entities.Where(o => o.Name.ToLower().Contains((search ?? string.Empty).ToLower()) || o.ShortName.ToLower().Contains((search ?? string.Empty).ToLower())) .ToList(); return(data); } } catch (Exception exc) { return(LogErrorManager.Add(exc)); } }
public static IViewModel GetWorkingCirriculumAcademicDisciplines(int page, int limit, string order, bool isAscending, string search, Guid?id) { try { using (DBContext context = DBContext.Create()) { EntitiesViewModel <AcademicDisciplineViewModel> model = new EntitiesViewModel <AcademicDisciplineViewModel> { Result = Result.Ok }; return(model); } } catch (Exception exc) { return(new ResultViewModel { Result = Result.Error, Message = exc.Message }); } }