public async Task <List <CatStageApiModel> > GetStages(CatStageCriteria criteria)
{
string strUri = CatStageAPI.Get(baseUrl);
var results = await PostApi <List <CatStageApiModel>, CatStageCriteria>(strUri, criteria);
return(results);
}
public async Task <IActionResult> ExportStage(CatStageCriteria catStageCriteria)
{
Helper helper = new Helper();
var responseFromApi = await HttpServiceExtension.GetDataFromApi(catStageCriteria, aPis.CatalogueAPI + Urls.Catelogue.CatStageUrl);
var dataObjects = responseFromApi.Content.ReadAsAsync <List <CatStage> >();
var stream = helper.CreateCatStateExcelFile(dataObjects.Result);
return(new FileHelper().ExportExcel(stream, FilesNames.StageList));
}
public IQueryable <CatStageModel> Paging(CatStageCriteria criteria, int page, int size, out int rowsCount)
{
IQueryable <CatStageModel> returnList = Query(criteria);
if (returnList == null)
{
rowsCount = 0;
return(returnList);
}
rowsCount = returnList.Count();
if (size > 1)
{
if (page < 1)
{
page = 1;
}
returnList = returnList.OrderByDescending(x => x.DatetimeModified).Skip((page - 1) * size).Take(size);
}
return(returnList);
}
public IQueryable <CatStageModel> Query(CatStageCriteria criteria)
{
IQueryable <CatStageModel> results = null;
var stages = DataContext.Get();
var departments = departmentRepository.Get();
if (criteria.All == null)
{
results = stages.Join(departments, x => x.DepartmentId, y => y.Id, (x, y) => new { Stage = x, Department = y })
.Where(x => x.Stage.Code.IndexOf(criteria.Code ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
x.Stage.StageNameEn.IndexOf(criteria.StageNameEn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
x.Stage.StageNameVn.IndexOf(criteria.StageNameVn ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.Stage.Id == criteria.Id || criteria.Id == 0) &&
(x.Stage.Active == criteria.Active || criteria.Active == null) &&
x.Department.DeptName.IndexOf(criteria.DepartmentName ?? "", StringComparison.OrdinalIgnoreCase) > -1
).Select(x => new CatStageModel
{
Id = x.Stage.Id,
Code = x.Stage.Code,
StageNameVn = x.Stage.StageNameVn,
StageNameEn = x.Stage.StageNameEn,
DepartmentId = x.Stage.DepartmentId,
DescriptionVn = x.Stage.DescriptionVn,
DescriptionEn = x.Stage.DescriptionEn,
UserCreated = x.Stage.UserCreated,
DatetimeCreated = x.Stage.DatetimeCreated,
UserModified = x.Stage.UserModified,
DatetimeModified = x.Stage.DatetimeModified,
Active = x.Stage.Active,
InactiveOn = x.Stage.InactiveOn,
DeptCode = x.Department.Code,
DeptName = x.Department.DeptName
});
}
else
{
results = stages.Join(departments, x => x.DepartmentId, y => y.Id, (x, y) => new { Stage = x, Department = y })
.Where(x => (x.Stage.Code.IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
x.Stage.StageNameEn.IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
x.Stage.StageNameVn.IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1 ||
x.Department.DeptName.IndexOf(criteria.All ?? "", StringComparison.OrdinalIgnoreCase) > -1)
).Select(x => new CatStageModel
{
Id = x.Stage.Id,
Code = x.Stage.Code,
StageNameVn = x.Stage.StageNameVn,
StageNameEn = x.Stage.StageNameEn,
DepartmentId = x.Stage.DepartmentId,
DescriptionVn = x.Stage.DescriptionVn,
DescriptionEn = x.Stage.DescriptionEn,
UserCreated = x.Stage.UserCreated,
DatetimeCreated = x.Stage.DatetimeCreated,
UserModified = x.Stage.UserModified,
DatetimeModified = x.Stage.DatetimeModified,
Active = x.Stage.Active,
InactiveOn = x.Stage.InactiveOn,
DeptCode = x.Department.Code,
DeptName = x.Department.DeptName
});
}
return(results);
}
