public PipeReportDTO GetByID(int ID)
{
PipeReport pipeReport = _unitOfWork.PipeReport.FindById(ID);
PipeReportDTO pipeReportDTO = _mapper.Map <PipeReportDTO>(pipeReport);
return(pipeReportDTO);
}
public PipeReportResponseDTO Update(PipeReportRequestDTO PipeReportRequestDTO)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
PipeReport tempObj = (from s in _unitOfWork.PipeReport.GenerateEntityAsIQueryable()
where s.ReportNo == PipeReportRequestDTO.PipeReport.ReportNo
select s).FirstOrDefault();
if (tempObj != null)
{
// PipeReport pipeReport = _mapper.Map<PipeReport>(PipeReportRequestDTO.PipeReport);
tempObj.ModifiedBy = "SYSADMIN";
tempObj.ModifiedDate = DateTime.Now;
_unitOfWork.PipeReport.Update(tempObj);
foreach (InspectionConfidenceDTO confidence in PipeReportRequestDTO.InspectionConfidenceList)
{
InspectionConfidence inspectionConfidence = _mapper.Map <InspectionConfidence>(confidence);
if (inspectionConfidence.ID > 0)
{
inspectionConfidence.ModifiedBy = "SYSADMIN";
inspectionConfidence.ModifiedDate = DateTime.Now;
_unitOfWork.InspectionConfidence.Update(inspectionConfidence);
}
}
foreach (InspectionObservationDTO inspectionObservationDTO in PipeReportRequestDTO.InspectionObservationList)
{
InspectionObservation inspectionObservation = _mapper.Map <InspectionObservation>(inspectionObservationDTO);
if (inspectionObservation.ID > 0)
{
inspectionObservation.ModifiedBy = "SYSADMIN";
inspectionObservation.ModifiedDate = DateTime.Now;
_unitOfWork.InspectionObservation.Update(inspectionObservation);
}
else
{
inspectionObservation.ID = 0;
inspectionObservation.PipeReportID = tempObj.ID;
inspectionObservation.CreatedDate = DateTime.Now;
inspectionObservation.CreatedBy = "SYSADMIN";
_unitOfWork.InspectionObservation.Create(inspectionObservation);
}
}
foreach (InspectionRecommendationDTO inspectionRecommendationDTO in PipeReportRequestDTO.InspectionRecommendationList)
{
InspectionRecommendation inspectionRecommendation = _mapper.Map <InspectionRecommendation>(inspectionRecommendationDTO);
if (inspectionRecommendation.ID > 0)
{
inspectionRecommendation.ModifiedBy = "SYSADMIN";
inspectionRecommendation.ModifiedDate = DateTime.Now;
_unitOfWork.InspectionRecommendation.Update(inspectionRecommendation);
}
else
{
inspectionRecommendation.ID = 0;
inspectionRecommendation.PipeReportID = tempObj.ID;
inspectionRecommendation.CreatedDate = DateTime.Now;
inspectionRecommendation.CreatedBy = "SYSADMIN";
_unitOfWork.InspectionRecommendation.Create(inspectionRecommendation);
}
}
//foreach (InspectionDistributionDTO inspectionDistributionDTO in PipeReportRequestDTO.InspectionDistributionList)
//{
// InspectionDistribution inspectionDistribution = _mapper.Map<InspectionDistribution>(inspectionDistributionDTO);
// if (inspectionDistribution.ID > 0)
// {
// inspectionDistribution.ModifiedDate = DateTime.Now;
// _unitOfWork.InspectionDistribution.Create(inspectionDistribution);
// }
// else
// {
// inspectionDistribution.PipeReportID = pipeReport.ID;
// inspectionDistribution.CreatedDate = DateTime.Now;
// _unitOfWork.InspectionDistribution.Create(inspectionDistribution);
// }
//}
//foreach (InspectionProgramDTO inspectionProgramDTO in PipeReportRequestDTO.InspectionProgramList)
//{
// InspectionProgram inspectionProgram = _mapper.Map<InspectionProgram>(inspectionProgramDTO);
// if (inspectionProgram.ID > 0)
// {
// inspectionProgram.ModifiedBy = "SYSADMIN";
// inspectionProgram.ModifiedDate = DateTime.Now;
// _unitOfWork.InspectionProgram.Create(inspectionProgram);
// }
// else
// {
// inspectionProgram.PipeReportID = pipeReport.ID;
// inspectionProgram.CreatedDate = DateTime.Now;
// _unitOfWork.InspectionProgram.Create(inspectionProgram);
// }
//}
foreach (TMLDTO tmlDTO in PipeReportRequestDTO.TMLList)
{
TML tml = _mapper.Map <TML>(tmlDTO);
if (tml.ID > 0)
{
tml.ModifiedBy = "SYSADMIN";
tml.ModifiedDate = DateTime.Now;
_unitOfWork.TML.Update(tml);
}
else
{
tml.ID = 0;
tml.PipeReportID = tempObj.ID;
tml.CreatedDate = DateTime.Now;
tml.CreatedBy = "SYSADMIN";
_unitOfWork.TML.Create(tml);
}
}
_unitOfWork.SaveChanges();
transaction.Commit();
return(new PipeReportResponseDTO
{
Status = true,
StatusMessage = "Successfully created",
StatusCode = 200
});
}
else
{
return(new PipeReportResponseDTO
{
Status = false,
StatusMessage = "Error - Duplicate Report - " + tempObj.ReportNo,
StatusCode = 200
});
}
}
catch (Exception ex)
{
transaction.Rollback();
return(new PipeReportResponseDTO()
{
Status = false,
StatusMessage = ex.Message,
StatusCode = 200
});
}
}
}
public PipeReportResponseDTO Create(PipeReportRequestDTO PipeReportRequestDTO)
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
PipeReport tempObj = (from s in _unitOfWork.PipeReport.GenerateEntityAsIQueryable()
where s.ReportNo == PipeReportRequestDTO.PipeReport.ReportNo
select s).FirstOrDefault();
if (tempObj == null)
{
PipeReport pipeReport = _mapper.Map <PipeReport>(PipeReportRequestDTO.PipeReport);
pipeReport.ID = 0;
pipeReport.CreatedDate = DateTime.Now;
pipeReport.ReportNo = GenerateReportNo(DateTime.Now.Year.ToString());
pipeReport.CreatedBy = "SYSADMIN";
PipeReport report = _unitOfWork.PipeReport.CreateWithReturnEntity(pipeReport);
if (PipeReportRequestDTO.InspectionConfidenceList != null && PipeReportRequestDTO.InspectionConfidenceList.Count > 0)
{
foreach (InspectionConfidenceDTO confidence in PipeReportRequestDTO.InspectionConfidenceList)
{
InspectionConfidence inspectionConfidence = _mapper.Map <InspectionConfidence>(confidence);
inspectionConfidence.ID = 0;
inspectionConfidence.PipeReportID = report.ID;
inspectionConfidence.PipeMasterID = report.PipeMasterID;
inspectionConfidence.ReportNo = report.ReportNo;
inspectionConfidence.EquipmentNo = report.EquipmentNo;
inspectionConfidence.CreatedDate = DateTime.Now;
inspectionConfidence.CreatedBy = "SYSADMIN";
_unitOfWork.InspectionConfidence.Create(inspectionConfidence);
}
}
if (PipeReportRequestDTO.InspectionObservationList != null && PipeReportRequestDTO.InspectionObservationList.Count > 0)
{
foreach (InspectionObservationDTO inspectionObservationDTO in PipeReportRequestDTO.InspectionObservationList)
{
InspectionObservation inspectionObservation = _mapper.Map <InspectionObservation>(inspectionObservationDTO);
inspectionObservation.ID = 0;
inspectionObservation.PipeReportID = report.ID;
inspectionObservation.PipeMasterID = report.PipeMasterID;
inspectionObservation.ReportNo = report.ReportNo;
inspectionObservation.EquipmentNo = report.EquipmentNo;
inspectionObservation.CreatedDate = DateTime.Now;
inspectionObservation.CreatedBy = "SYSADMIN";
_unitOfWork.InspectionObservation.Create(inspectionObservation);
}
}
if (PipeReportRequestDTO.InspectionRecommendationList != null && PipeReportRequestDTO.InspectionRecommendationList.Count > 0)
{
foreach (InspectionRecommendationDTO inspectionRecommendationDTO in PipeReportRequestDTO.InspectionRecommendationList)
{
InspectionRecommendation inspectionRecommendation = _mapper.Map <InspectionRecommendation>(inspectionRecommendationDTO);
inspectionRecommendation.ID = 0;
inspectionRecommendation.PipeReportID = report.ID;
inspectionRecommendation.PipeMasterID = report.PipeMasterID;
inspectionRecommendation.ReportNo = report.ReportNo;
inspectionRecommendation.EquipmentNo = report.EquipmentNo;
inspectionRecommendation.CreatedDate = DateTime.Now;
inspectionRecommendation.CreatedBy = "SYSADMIN";
_unitOfWork.InspectionRecommendation.Create(inspectionRecommendation);
}
}
if (PipeReportRequestDTO.InspectionDistributionList != null && PipeReportRequestDTO.InspectionDistributionList.Count > 0)
{
foreach (InspectionDistributionDTO inspectionDistributionDTO in PipeReportRequestDTO.InspectionDistributionList)
{
InspectionDistribution inspectionDistribution = _mapper.Map <InspectionDistribution>(inspectionDistributionDTO);
inspectionDistribution.ID = 0;
inspectionDistribution.PipeReportID = report.ID;
inspectionDistribution.CreatedDate = DateTime.Now;
inspectionDistribution.CreatedBy = "SYSADMIN";
_unitOfWork.InspectionDistribution.Create(inspectionDistribution);
}
}
if (PipeReportRequestDTO.InspectionProgramList != null && PipeReportRequestDTO.InspectionProgramList.Count > 0)
{
foreach (InspectionProgramDTO inspectionProgramDTO in PipeReportRequestDTO.InspectionProgramList)
{
InspectionProgram inspectionProgram = _mapper.Map <InspectionProgram>(inspectionProgramDTO);
inspectionProgram.ID = 0;
inspectionProgram.PipeReportID = report.ID;
inspectionProgram.PipeMasterID = report.PipeMasterID;
inspectionProgram.ReportNo = report.ReportNo;
inspectionProgram.EquipmentNo = report.EquipmentNo;
inspectionProgram.CreatedDate = DateTime.Now;
inspectionProgram.CreatedBy = "SYSADMIN";
_unitOfWork.InspectionProgram.Create(inspectionProgram);
}
}
if (PipeReportRequestDTO.TMLList != null && PipeReportRequestDTO.TMLList.Count > 0)
{
foreach (TMLDTO tmlDTO in PipeReportRequestDTO.TMLList)
{
TML tml = _mapper.Map <TML>(tmlDTO);
tml.ID = 0;
tml.PipeReportID = report.ID;
tml.PipeMasterID = report.PipeMasterID;
tml.ReportNo = report.ReportNo;
tml.EquipmentNo = report.EquipmentNo;
tml.CreatedDate = DateTime.Now;
tml.CreatedBy = "SYSADMIN";
_unitOfWork.TML.Create(tml);
}
}
_unitOfWork.SaveChanges();
transaction.Commit();
return(new PipeReportResponseDTO
{
ReportNo = PipeReportRequestDTO.PipeReport.ReportNo,
Status = true,
StatusMessage = "Successfully created",
StatusCode = 200
});
}
else
{
return(new PipeReportResponseDTO
{
ReportNo = PipeReportRequestDTO.PipeReport.ReportNo,
Status = false,
StatusMessage = "Error - Duplicate Report - " + PipeReportRequestDTO.PipeReport.ReportNo,
StatusCode = 200
});
}
}
catch (Exception ex)
{
transaction.Rollback();
return(new PipeReportResponseDTO()
{
Status = false,
StatusMessage = ex.Message,
StatusCode = 200
});
}
}
}
public PipeReportResponseDTO GetByReportNo(string ReportNo)
{
PipeReportResponseDTO response = new PipeReportResponseDTO();
try
{
PipeReport pipeReport = (from s in _unitOfWork.PipeReport.GenerateEntityAsIQueryable()
where s.ReportNo == ReportNo
select s).FirstOrDefault();
if (pipeReport != null)
{
// Pipe Report
response.PipeReport = _mapper.Map <PipeReportDTO>(pipeReport);
// Inspection Confidence
List <InspectionConfidence> inspectionConfidenceList = (from s in _unitOfWork.InspectionConfidence.GenerateEntityAsIQueryable()
where s.PipeReportID == pipeReport.ID
select s).ToList();
if (inspectionConfidenceList != null && inspectionConfidenceList.Count > 0)
{
response.InspectionConfidenceList = new List <InspectionConfidenceDTO>();
foreach (InspectionConfidence confidence in inspectionConfidenceList)
{
InspectionConfidenceDTO inspectionConfidenceDTO = _mapper.Map <InspectionConfidenceDTO>(confidence);
response.InspectionConfidenceList.Add(inspectionConfidenceDTO);
}
}
// Inspection Observation
List <InspectionObservation> inspectionObservationList = (from s in _unitOfWork.InspectionObservation.GenerateEntityAsIQueryable()
where s.PipeReportID == pipeReport.ID
select s).ToList();
if (inspectionObservationList != null && inspectionObservationList.Count > 0)
{
response.InspectionObservationList = new List <InspectionObservationDTO>();
foreach (InspectionObservation observation in inspectionObservationList)
{
InspectionObservationDTO inspectionObservationDTO = _mapper.Map <InspectionObservationDTO>(observation);
response.InspectionObservationList.Add(inspectionObservationDTO);
}
}
// Inspection Program
List <InspectionProgram> inspectionProgramList = (from s in _unitOfWork.InspectionProgram.GenerateEntityAsIQueryable()
where s.PipeReportID == pipeReport.ID
select s).ToList();
if (inspectionProgramList != null && inspectionProgramList.Count > 0)
{
response.InspectionProgramList = new List <InspectionProgramDTO>();
foreach (InspectionProgram program in inspectionProgramList)
{
InspectionProgramDTO inspectionProgramDTO = _mapper.Map <InspectionProgramDTO>(program);
response.InspectionProgramList.Add(inspectionProgramDTO);
}
}
// Inspection Document
List <InspectionDocument> inspectionDocumentList = (from s in _unitOfWork.InspectionDocument.GenerateEntityAsIQueryable()
where s.PipeReportID == pipeReport.ID
select s).ToList();
if (inspectionDocumentList != null && inspectionDocumentList.Count > 0)
{
response.InspectionDocumentList = new List <InspectionDocumentDTO>();
foreach (InspectionDocument document in inspectionDocumentList)
{
InspectionDocumentDTO inspectionDocumentDTO = _mapper.Map <InspectionDocumentDTO>(document);
response.InspectionDocumentList.Add(inspectionDocumentDTO);
}
}
// Inspection Recommendation
List <InspectionRecommendation> inspectionRecommendationList = (from s in _unitOfWork.InspectionRecommendation.GenerateEntityAsIQueryable()
where s.PipeReportID == pipeReport.ID
select s).ToList();
if (inspectionRecommendationList != null && inspectionRecommendationList.Count > 0)
{
response.InspectionRecommendationList = new List <InspectionRecommendationDTO>();
foreach (InspectionRecommendation recommendation in inspectionRecommendationList)
{
InspectionRecommendationDTO inspectionRecommendationDTO = _mapper.Map <InspectionRecommendationDTO>(recommendation);
response.InspectionRecommendationList.Add(inspectionRecommendationDTO);
}
}
// Inspection Distribution
List <InspectionDistribution> inspectionDistributionList = (from s in _unitOfWork.InspectionDistribution.GenerateEntityAsIQueryable()
where s.PipeReportID == pipeReport.ID
select s).ToList();
if (inspectionDistributionList != null && inspectionDistributionList.Count > 0)
{
response.InspectionDistributionList = new List <InspectionDistributionDTO>();
foreach (InspectionDistribution distribution in inspectionDistributionList)
{
InspectionDistributionDTO inspectionDistributionDTO = _mapper.Map <InspectionDistributionDTO>(distribution);
response.InspectionDistributionList.Add(inspectionDistributionDTO);
}
}
// TML
List <TML> TMLList = (from s in _unitOfWork.TML.GenerateEntityAsIQueryable()
where s.PipeReportID == pipeReport.ID
select s).ToList();
if (TMLList != null && TMLList.Count > 0)
{
response.TMLList = new List <TMLDTO>();
foreach (TML tml in TMLList)
{
TMLDTO TMLDTO = _mapper.Map <TMLDTO>(tml);
response.TMLList.Add(TMLDTO);
}
}
response.ReportNo = pipeReport.ReportNo;
response.Status = true;
response.StatusMessage = "";
response.StatusCode = 200;
return(response);
}
else
{
return(new PipeReportResponseDTO
{
Status = false,
StatusMessage = "Report donot exist - " + ReportNo,
StatusCode = 200
});
}
}
catch (Exception ex)
{
return(new PipeReportResponseDTO()
{
ReportNo = ReportNo,
Status = false,
StatusMessage = ex.Message,
StatusCode = 200
});
}
}