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