public IActionResult GetPlmPart([FromQuery] SDevPlmPart sDevPlmPart) { _logger.LogInformation(String.Format(@"****** PlmController GetPlmPart fired!! ******")); var data = _devPlmPartDAO.FindAll(); if (!String.IsNullOrEmpty(sDevPlmPart.partno)) { data = data.Where(x => x.PARTNO == sDevPlmPart.partno.Trim()); } if (!String.IsNullOrEmpty(sDevPlmPart.location)) { data = data.Where(x => x.LOCATION.Contains(sDevPlmPart.location.Trim())); } if (!String.IsNullOrEmpty(sDevPlmPart.partnameen)) { data = data.Where(x => x.PARTNAMEEN.Contains(sDevPlmPart.partnameen.Trim())); } if (!String.IsNullOrEmpty(sDevPlmPart.partnamecn)) { data = data.Where(x => x.PARTNAMECN.Contains(sDevPlmPart.partnamecn.Trim())); } data = data.OrderBy(x => x.PARTNO); PagedList <DevPlmPart> result = PagedList <DevPlmPart> .Create(data, sDevPlmPart.PageNumber, sDevPlmPart.PageSize, sDevPlmPart.IsPaging); Response.AddPagination(result.CurrentPage, result.PageSize, result.TotalCount, result.TotalPages); return(Ok(result)); }
public IActionResult ExportPlmPart(SDevPlmPart sDevPlmPart) { _logger.LogInformation(String.Format(@"****** PlmController ExportPlmPart fired!! ******")); var data = _devPlmPartDAO.FindAll(); if (!String.IsNullOrEmpty(sDevPlmPart.partno)) { data = data.Where(x => x.PARTNO == sDevPlmPart.partno.Trim()); } if (!String.IsNullOrEmpty(sDevPlmPart.location)) { data = data.Where(x => x.LOCATION.Contains(sDevPlmPart.location.Trim())); } if (!String.IsNullOrEmpty(sDevPlmPart.partnameen)) { data = data.Where(x => x.PARTNAMEEN.Contains(sDevPlmPart.partnameen.Trim())); } if (!String.IsNullOrEmpty(sDevPlmPart.partnamecn)) { data = data.Where(x => x.PARTNAMECN.Contains(sDevPlmPart.partnamecn.Trim())); } data = data.OrderBy(x => x.PARTNO); byte[] result = _excelService.CommonExportReport(data.ToList(), "TempPlmPart.xlsx"); return(File(result, "application/xlsx")); }