public List <CorrosionStudyDTO> GetBySearchFilters(CorrosionStudyFilterDTO corrosionStudyFilterDTO)
{
List <CorrosionStudyDTO> list = new List <CorrosionStudyDTO>();
IQueryable <CorrosionStudyDTO> query = (from p in _unitOfWork.CorrosionStudy.GenerateEntityAsIQueryable()
join l in _context.Plant on p.PlantCode equals l.Code
select new CorrosionStudyDTO
{
ID = p.ID,
ParentPlantCode = l.ParentPlant.Code,
PlantCode = p.PlantCode,
LoopNo = p.LoopNo,
FluidCode = p.FluidCode,
FluidName = p.FluidName,
SubFluidCode = p.SubFluidCode,
ProcessDescription = p.ProcessDescription,
MinPressure = p.MinPressure,
MaxPressure = p.MaxPressure,
MinTemperature = p.MinTemperature,
MaxTemperature = p.MaxTemperature,
});
if (corrosionStudyFilterDTO != null)
{
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.LoopNo))
{
query = (from re in query
where re.LoopNo == corrosionStudyFilterDTO.LoopNo
select re);
}
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.PlantCode))
{
query = (from re in query
where re.PlantCode == corrosionStudyFilterDTO.PlantCode
select re);
}
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.FluidCode))
{
query = (from re in query
where re.FluidCode == corrosionStudyFilterDTO.FluidCode
select re);
}
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.ParentPlantCode))
{
query = (from re in query
where re.ParentPlantCode == corrosionStudyFilterDTO.ParentPlantCode
select re);
}
list = query.OrderBy(p => p.LoopNo).ToList();
}
return(list);
}
public CorrosionStudyResponseDTO GetPipeClustersByLoopNo([FromBody] CorrosionStudyFilterDTO corrosionStudyFilterDTO)
{
CorrosionStudyResponseDTO result = new CorrosionStudyResponseDTO();
try
{
result = _CorrosionStudyService.GetPipeClustersByLoopNo(corrosionStudyFilterDTO);
_logger.LogDebug("Result returned");
}
catch (Exception exception)
{
_logger.LogError(exception, "");
}
return(result);
}
public CorrosionStudyResponseDTO GetPipeClustersByLoopNo(CorrosionStudyFilterDTO corrosionStudyFilterDTO)
{
CorrosionStudyResponseDTO response = new CorrosionStudyResponseDTO();
List <CorrosionStudyDTO> list = new List <CorrosionStudyDTO>();
IQueryable <CorrosionStudyDTO> query = (from p in _unitOfWork.PipeMaster.GenerateEntityAsIQueryable()
join l in _context.Plant on p.PlantCode equals l.Code
select new CorrosionStudyDTO
{
ID = p.ID,
ParentPlantCode = l.ParentPlant.Code,
PlantCode = p.PlantCode,
LoopNo = p.CorrosionLoopNo,
FluidCode = p.FluidCode,
FluidName = p.FluidName,
SubFluidCode = p.SubFluid,
ProcessDescription = "",
MinPressure = p.DesignPressure,
MaxPressure = p.DesignPressure,
MinTemperature = p.DesignTemperature,
MaxTemperature = p.DesignTemperature,
ClusterNo = p.PipeClusterNo,
MaterialCode = p.MaterialCode
});
if (corrosionStudyFilterDTO != null)
{
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.LoopNo))
{
query = (from re in query
where re.LoopNo == corrosionStudyFilterDTO.LoopNo
select re);
}
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.PlantCode))
{
query = (from re in query
where re.PlantCode == corrosionStudyFilterDTO.PlantCode
select re);
}
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.FluidCode))
{
query = (from re in query
where re.FluidCode == corrosionStudyFilterDTO.FluidCode
select re);
}
if (!string.IsNullOrWhiteSpace(corrosionStudyFilterDTO.ParentPlantCode))
{
query = (from re in query
where re.ParentPlantCode == corrosionStudyFilterDTO.ParentPlantCode
select re);
}
list = query.OrderBy(p => p.LoopNo).ToList();
}
response.CorrosionStudyDTO = new CorrosionStudyDTO();
response.COFMasterDTOList = new List <COFMasterDTO>();
response.IOWDTOList = new List <IOWDTO>();
response.PipeClusterPOFDTOList = new List <PipeClusterPOFDTO>();
CorrosionStudyDTO corrosionStudy = new CorrosionStudyDTO();
if (list != null && list.Count > 0)
{
corrosionStudy.ID = 0;
corrosionStudy.LoopNo = list.Min(p => p.LoopNo);
corrosionStudy.MinPressure = list.Min(p => p.MinPressure);
corrosionStudy.MaxPressure = list.Max(p => p.MinPressure);
corrosionStudy.MinTemperature = list.Min(p => p.MinTemperature);
corrosionStudy.MaxTemperature = list.Max(p => p.MinTemperature);
corrosionStudy.FluidCode = list.Max(p => p.FluidCode);
corrosionStudy.FluidName = list.Max(p => p.FluidName);
corrosionStudy.PlantCode = list.Max(p => p.PlantCode);
corrosionStudy.ParentPlantCode = list.Max(p => p.ParentPlantCode);
corrosionStudy.ClusterNos = list.Select(p => p.ClusterNo).Distinct().ToList <string>();
response.CorrosionStudyDTO = corrosionStudy;
foreach (string cluster in corrosionStudy.ClusterNos)
{
PipeClusterPOFDTO pipeCluster = new PipeClusterPOFDTO();
pipeCluster.ID = 0;
pipeCluster.Fluid = response.CorrosionStudyDTO.FluidCode;
pipeCluster.ClusterNo = cluster;
pipeCluster.MaterialCode = list.Where(c => c.ClusterNo == cluster).Select(c => c.MaterialCode).FirstOrDefault();
pipeCluster.MinPressure = list.Where(c => c.ClusterNo == cluster).Min(c => c.MinPressure);
pipeCluster.MaxPressure = list.Where(c => c.ClusterNo == cluster).Max(c => c.MinPressure);
pipeCluster.MinTemperature = list.Where(c => c.ClusterNo == cluster).Min(c => c.MinTemperature);
pipeCluster.MaxTemperature = list.Where(c => c.ClusterNo == cluster).Max(c => c.MinTemperature);
pipeCluster.CorrosionStudyID = 0;
pipeCluster.DMGuideList = new List <DMGuideDTO>();
response.PipeClusterPOFDTOList.Add(pipeCluster);
}
}
return(response);
}
public List <CorrosionStudyDTO> GetBySearchFilters([FromBody] CorrosionStudyFilterDTO corrosionStudyFilterDTO)
{
return(_CorrosionStudyService.GetBySearchFilters(corrosionStudyFilterDTO));
}
