public PageResultDTO <JobIndexPointSummaryDTOWithAction> GetAllJobIndexPoints(long periodId, long calculationId, int pageSize, int pageIndex)
{
var fs = new ListFetchStrategy <JobIndexPointWithEmployee>(Enums.FetchInUnitOfWorkOption.NoTracking);
var cal = calculationRep.GetById(new CalculationId(calculationId));
if (cal.PeriodId.Id != periodId)
{
throw new Exception("چنین محاسبه ای در دوره ذکر شده نداریم.");
}
fs.WithPaging(pageSize, pageIndex).OrderByDescending(c => c.JobIndexPoint.Value);
repository.Find <SummaryEmployeePoint>(c => c.CalculationId == cal.Id && c.IsFinal, fs);
var res = new PageResultDTO <JobIndexPointSummaryDTOWithAction>();
res.InjectFrom(fs.PageCriteria.PageResult);
var i = (res.CurrentPage - 1) * res.PageSize;
var lst = fs.PageCriteria.PageResult.Result.Select(p =>
{
i++;
var m = jobIndexPointMapper.MapToModel(p);
m.EmployeeRankInPeriod = i;
return(m);
}).ToList();
res.Result = lst;
return(res);
}
public PageResultDTO <UserDTOWithActions> GetAllUsers(int pageSize, int pageIndex, string filter)
{
var fs = new ListFetchStrategy <User>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.WithPaging(pageSize, pageIndex);
var criterias = filter.Split(';');
var predicate = getUserPredicate(criterias);
var rs = getPredicate(criterias);
if (criterias.Count() > 1)
{
//TODO:
userRep.FindUsers(predicate, fs);//, rs[0], rs[1], rs[2], pageSize, pageIndex);
}
else
{
//TODO:
userRep.FindUsers(predicate, fs);//, "", "", "", pageSize, pageIndex);
}
var res = new PageResultDTO <UserDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
List <UserDTOWithActions> result = new List <UserDTOWithActions>();
fs.PageCriteria.PageResult.Result.ForEach(p =>
{
var u = userDTOWithActionsMapper.MapToModel(p);
//u.CompanyDto = new CompanyDto() { Id = p.CompanyId };
result.Add(u);
});
res.Result = result;
return(res);
}
public PageResultDTO <PolicyDTOWithActions> GetAllPolicies(int pageSize, int pageIndex)
{
var fs = new ListFetchStrategy <Policy>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.OrderBy(x => x.Id);
fs.WithPaging(pageSize, pageIndex);
policyRep.FindBy(fs);
var res = new PageResultDTO <PolicyDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result = fs.PageCriteria.PageResult.Result.Select(r => policyWithActionMapper.MapToModel(r)).ToList();
return(res);
}
public PageResultDTO <PeriodDTOWithAction> GetAllPeriods(int pageSize, int pageIndex)
{
var fs = new ListFetchStrategy <Period>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.WithPaging(pageSize, pageIndex);
periodRep.GetAll(fs);
var res = new PageResultDTO <PeriodDTOWithAction>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result =
fs.PageCriteria.PageResult.Result.Select(p => periodDTOWithActionsMapper.MapToModel(p)).ToList();
return(res);
}
public PageResultDTO <EmployeeDTOWithActions> GetAllEmployees(long periodId, int pageSize, int pageIndex)
{
var fs = new ListFetchStrategy <Employee>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.WithPaging(pageSize, pageIndex);
fs.OrderBy(e => e.Id);
employeeRep.Find(e => e.Id.PeriodId == new PeriodId(periodId), fs);
var res = new PageResultDTO <EmployeeDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result =
fs.PageCriteria.PageResult.Result.Select(p => employeeDTOWithActionsMapper.MapToModel(p)).ToList();
return(res);
}
public PageResultDTO <UnitInPeriodDTOWithActions> GetAllUnits(long periodId, int pageSize, int pageIndex, QueryStringConditions queryStringConditions, string selectedColumns)
{
var result = GetAllUnitWithActions(periodId, "");
var pResDto = new PageResultDTO <UnitInPeriodDTOWithActions>
{
CurrentPage = 0,
PageSize = 10,
Result = result,
TotalCount = result.Count,
TotalPages = 1
};
return(pResDto);
}
public PageResultDTO <LogDTOWithActions> GetAllLogs(int pageSize, int pageIndex, QueryStringConditions conditions)
{
var logs = logService.GetAllLogs();
var res = new PageResultDTO <LogDTOWithActions>()
{
Result = logs.Select(u => logDTOWithActionsMapper.MapToModel(u)).ToList(),
CurrentPage = 1,
PageSize = 20,
TotalCount = 10,
TotalPages = 1
};
return(res);
}
public PageResultDTO <CalculationBriefDTOWithAction> GetAllCalculations(long periodId, int pageSize, int pageIndex)
{
var fs = new ListFetchStrategy <CalculationWithPolicyAndPeriod>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.WithPaging(pageSize, pageIndex).OrderBy(c => c.Calculation.Id.Id);
var x = calculationRep.FindByWithPolicy(new PeriodId(periodId), fs);
var res = new PageResultDTO <CalculationBriefDTOWithAction>();
res.InjectFrom(fs.PageCriteria.PageResult);
var lst = fs.PageCriteria.PageResult.Result.Select(p => calculationBriefMapper.MapToModel(p)).ToList();
res.Result = lst;
return(res);
}
public PageResultDTO <CalculationExceptionBriefDTOWithAction> GetAllCalculationExceptions(long calculationId, int pageSize, int pageIndex)
{
var fs = new ListFetchStrategy <EmployeeCalculationException>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.WithPaging(pageSize, pageIndex).OrderByDescending(c => c.Id.Id);
var x = calculationExpRepository.FindBy(new CalculationId(calculationId), fs);
var res = new PageResultDTO <CalculationExceptionBriefDTOWithAction>();
res.InjectFrom(fs.PageCriteria.PageResult);
var lst = fs.PageCriteria.PageResult.Result.Select(p => calculationExceptionBriefMapper.MapToModel(p)).ToList();
res.Result = lst;
return(res);
}
public PageResultDTO <GetUserDTO> GetAllUsers(int?page, int pageSize = 20)
{
_logger.LogInfo("Fetching all the users from the storage...");
var countDetails = this._userService.GetAllUsers().Count();
var result = new PageResultDTO <GetUserDTO>
{
Count = countDetails,
PageIndex = page ?? 1,
PageSize = pageSize,
Items = this._userService.GetAllUsers().Skip((page - 1 ?? 0) * pageSize).Take(pageSize).ToList()
};
_logger.LogInfo($"Returning {countDetails} users.");
return(result);
}
public PageResultDTO <GetHeroDTO> GetAllHeroes(int?page, int pageSize = 9)
{
_logger.LogInfo("Fetching all the heroes from the storage...");
var countDetails = _heroService.GetAllHeroes().Count();
var result = new PageResultDTO <GetHeroDTO>
{
Count = countDetails,
PageIndex = page ?? 1,
PageSize = pageSize,
Items = _heroService.GetAllHeroes().Skip((page - 1 ?? 0) * pageSize).Take(pageSize).ToList()
};
_logger.LogInfo($"Returning {countDetails} heroes.");
return(result);
}
public PageResultDTO <RuleTrailDTOWithAction> GetRuleTrailsWithPagination(long ruleId, int pageSize, int pageIndex)
{
//todo:(LOW) check for correctness
//var fs = new ListFetchStrategy<RuleTrail>();
//fs.OrderByDescending(f => f.EffectiveDate).WithPaging(pageSize, pageIndex);
//ruleService.GetRuleTrails(new RuleId(ruleId), fs);
//var res = new PageResultDTO<RuleTrailDTOWithAction>();
//res.InjectFrom(fs.PageCriteria.PageResult);
//res.Result = fs.PageCriteria.PageResult.Result.Select(r => ruleTrailWithActionsMapper.MapToModel(r));
//return res;
var res = new PageResultDTO <RuleTrailDTOWithAction>();
var ruleTrailList = ruleService.GetRuleTrails(new RuleId(ruleId), new ListFetchStrategy <RuleTrail>()).OrderByDescending(r => r.EffectiveDate);
res.PageSize = 100;
res.CurrentPage = 1;
res.Result = ruleTrailList.Select(r => ruleTrailWithActionsMapper.MapToModel(r)).ToList();
return(res);
}
public PageResultDTO <GetLikedMovieDTO> GetLikedMovies(int?page, int pageSize = 12)
{
_logger.LogInfo("Fetching all the liked movies from the storage...");
var userId = HttpContext.User.Claims.First(x => x.Type == "UserID").Value;
var countDetails = this._movieService.GetLikedMovies(userId).Count();
var result = new PageResultDTO <GetLikedMovieDTO>
{
Count = countDetails,
PageIndex = page ?? 1,
PageSize = pageSize,
Items = this._movieService.GetLikedMovies(userId).Skip((page - 1 ?? 0) * pageSize).Take(pageSize).ToList()
};
_logger.LogInfo($"Returning {countDetails} movies.");
return(result);
}
public PageResultDTO <EmployeeDTOWithActions> GetAllEmployees(long periodId, int pageSize, int pageIndex,
string filter)
{
var fs = new ListFetchStrategy <Employee>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.WithPaging(pageSize, pageIndex);
fs.OrderBy(e => e.Id);
//todo:(LOW) Must be code in better way
var criterias = filter.Split(';');
var predicate = getEmployeePredicate(criterias, periodId);
employeeRep.Find(predicate, fs);
var res = new PageResultDTO <EmployeeDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result =
fs.PageCriteria.PageResult.Result.Select(p => employeeDTOWithActionsMapper.MapToModel(p)).ToList();
return(res);
}
public PageResultDTO <AbstractUnitIndexDTOWithActions> GetAllUnitIndexCategoriesWithPagination(int pageSize, int pageIndex, QueryStringConditions queryStringConditions)
{
var fs = new ListFetchStrategy <UnitIndexCategory>(Enums.FetchInUnitOfWorkOption.NoTracking);
var sortBy = QueryConditionHelper.GetSortByDictionary(queryStringConditions.SortBy);
foreach (var item in sortBy)
{
fs.SortCriterias.Add(new StringSortCriteria <UnitIndexCategory>(item.Key,
(item.Value.ToUpper() == "ASC")
? Enums.SortOrder.Ascending
: Enums.SortOrder.Descending));
}
fs.OrderBy(x => x.Id);
fs.WithPaging(pageSize, pageIndex);
unitIndexRep.GetAllUnitIndexCategory(fs);
var res = new PageResultDTO <AbstractUnitIndexDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result = fs.PageCriteria.PageResult.Result.Select(r => unitIndexWithActionsMapper.MapToModel(r));
return(res);
}
public PageResultDTO <JobInPeriodDTOWithActions> GetAllJobs(long periodId, int pageSize, int pageIndex, QueryStringConditions queryStringConditions, string selectedColumns)
{
var fs = new ListFetchStrategy <Job>(Enums.FetchInUnitOfWorkOption.NoTracking);
var sortBy = QueryConditionHelper.GetSortByDictionary(queryStringConditions.SortBy);
foreach (var item in sortBy)
{
fs.SortCriterias.Add(new StringSortCriteria <Job>(item.Key,
(item.Value.ToUpper() == "ASC")
? Enums.SortOrder.Ascending
: Enums.SortOrder.Descending));
}
fs.OrderBy(x => x.Id);
fs.WithPaging(pageSize, pageIndex);
jobRep.Find(e => e.Id.PeriodId == new PeriodId(periodId), fs);
var res = new PageResultDTO <JobInPeriodDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result = fs.PageCriteria.PageResult.Result.Select(r => jobInPeriodDTOWithActionsMapper.MapToModel(r, selectedColumns.Split(','))).ToList();
return(res);
}
public PageResultDTO <ClaimDTOWithAction> GetClaimsWithActions(long periodId, string employeeNo, int pageSize, int pageIndex, QueryStringConditions queryStringConditions)
{
var fs = new ListFetchStrategy <Claim>(Enums.FetchInUnitOfWorkOption.NoTracking);
var sortBy = QueryConditionHelper.GetSortByDictionary(queryStringConditions.SortBy);
foreach (var item in sortBy)
{
fs.SortCriterias.Add(new StringSortCriteria <Claim>(item.Key,
(item.Value.ToUpper() == "ASC")
? Enums.SortOrder.Ascending
: Enums.SortOrder.Descending));
}
fs.OrderBy(x => x.Id);
fs.WithPaging(pageSize, pageIndex);
claimRep.FindBy(fs, employeeNo, new PeriodId(periodId));
var res = new PageResultDTO <ClaimDTOWithAction>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result = fs.PageCriteria.PageResult.Result.Select(r => claimDTOWithActionsMapper.MapToModel(r)).ToList();
return(res);
}
public PageResultDTO <EmployeeDTOWithActions> GetSubordinateEmployees(long periodId, string verifierEmployeeNo, int pageSize, int pageIndex,
string filter)
{
var fs = new ListFetchStrategy <Employee>(Enums.FetchInUnitOfWorkOption.NoTracking);
fs.WithPaging(pageSize, pageIndex);
fs.OrderBy(e => e.LastName);
//todo:(LOW) Must be code in better way
var criterias = filter.Split(';');
var predicate = getEmployeePredicate(criterias, periodId);
employeeRep.GetSubordinatesEmployee(new EmployeeId(verifierEmployeeNo, new PeriodId(periodId)), predicate, fs);
var res = new PageResultDTO <EmployeeDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result =
fs.PageCriteria.PageResult.Result.Select(p =>
{
var mapped = new EmployeeDTOWithActions
{
FirstName = p.FirstName,
LastName = p.LastName,
PeriodId = p.Id.PeriodId.Id,
PersonnelNo = p.Id.EmployeeNo,
FinalPoint = p.FinalPoint,
SystemPoint = p.CalculatedPoint,
StateName = p.EmployeePointState.Description,
ActionCodes = new List <int>
{
(int)ActionType.ChangeEmployeePoint,
}
};
return(mapped);
}).ToList();
return(res);
}
public PageResultDTO <CustomFieldDTOWithActions> GetAllCustomFieldes(int pageSize, int pageIndex, QueryStringConditions queryStringConditions)
{
var fs = new ListFetchStrategy <CustomFieldType>(Enums.FetchInUnitOfWorkOption.NoTracking);
var sortBy = QueryConditionHelper.GetSortByDictionary(queryStringConditions.SortBy);
foreach (var item in sortBy)
{
fs.SortCriterias.Add(new StringSortCriteria <CustomFieldType>(item.Key,
(item.Value.ToUpper() == "ASC")
? Enums.SortOrder.Ascending
: Enums.SortOrder.Descending));
}
fs.OrderBy(x => x.Id);
fs.WithPaging(pageSize, pageIndex);
var entityId = getEntityIdFromQueryString(queryStringConditions.Filter);
customFieldRep.GetAll(
entityId != null ? Enumeration.FromValue <EntityTypeEnum>(entityId.ToString()) : null, fs);
var res = new PageResultDTO <CustomFieldDTOWithActions>();
res.InjectFrom(fs.PageCriteria.PageResult);
res.Result = fs.PageCriteria.PageResult.Result.Select(r => customFieldWithActionMapper.MapToModel(r)).ToList();
return(res);
}
