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