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