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
});
}
}
