/// <summary>
        /// Search SectionParagraphTraslation by id.
        /// </summary>
        /// <param name="request">The SectionParagraphTraslation Request Pivot to retrive.</param>
        /// <returns>SectionParagraphTraslation Response Pivot response.</returns>
        public SectionParagraphTranslationResponsePivot FindSectionParagraphTranslations(SectionParagraphTranslationRequestPivot request)
        {
            if (request?.SectionParagraphTranslationPivot == null)
            {
                throw new ArgumentNullException(nameof(request));
            }

            List <SectionParagraphTranslationPivot> results = new List <SectionParagraphTranslationPivot>();
            SectionParagraphTranslationPivot        result  = new SectionParagraphTranslationPivot();

            switch (request.FindSectionParagraphTranslationPivot)
            {
            case FindSectionParagraphTranslationPivot.SectionParagraphTranslationId:
                result = _unitOfWork.SectionParagraphTraslationRepository.Get(p => p.ParagraphId == request.SectionParagraphTranslationPivot.TranslationId, null, "SectionParagraph,Language")?.FirstOrDefault()?.ToPivot();
                break;

            case FindSectionParagraphTranslationPivot.SectionParagraphId:
                results = _unitOfWork.SectionParagraphTraslationRepository.Get(p => p.ParagraphId == request.SectionParagraphTranslationPivot.ParagraphId, null, "SectionParagraph,Language")?.ToList().ToPivotList();
                break;
            }
            return(new SectionParagraphTranslationResponsePivot
            {
                SectionParagraphTranslationPivotList = results,
                SectionParagraphTranslationPivot = result
            });
        }
 /// <summary>
 /// From SectionParagraphTraslation Pivot To SectionParagraphTraslation Dto.
 /// </summary>
 /// <param name="sectionParagraphTraslationPivot">sectionParagraphTraslation pivot to assemble.</param>
 /// <returns>SectionParagraphTraslationDto result.</returns>
 public static SectionParagraphTranslationDto ToDto(this SectionParagraphTranslationPivot sectionParagraphTraslationPivot)
 {
     if (sectionParagraphTraslationPivot == null)
     {
         return(null);
     }
     return(new SectionParagraphTranslationDto
     {
         SectionParagraph = sectionParagraphTraslationPivot.SectionParagraph.ToDto(),
         ParagraphDescription = sectionParagraphTraslationPivot.ParagraphDescription,
         ParagraphTitle = sectionParagraphTraslationPivot.ParagraphTitle,
         TranslationId = sectionParagraphTraslationPivot.TranslationId,
         Language = sectionParagraphTraslationPivot.Language.ToDto(),
         ParagraphId = sectionParagraphTraslationPivot.ParagraphId,
         LanguageId = sectionParagraphTraslationPivot.LanguageId
     });
 }
 /// <summary>
 /// From SectionParagraphTranslationPivot to SectionParagraphTraslation.
 /// </summary>
 /// <param name="sectionParagraphTraslationPivot">sectionParagraphTraslationPivot to assemble.</param>
 /// <returns>SectionParagraphTraslation result.</returns>
 public static SectionParagraphTranslation ToEntity(this SectionParagraphTranslationPivot sectionParagraphTraslationPivot)
 {
     if (sectionParagraphTraslationPivot == null)
     {
         return(null);
     }
     return(new SectionParagraphTranslation
     {
         SectionParagraph = sectionParagraphTraslationPivot.SectionParagraph?.ToEntity(),
         ParagraphDescription = sectionParagraphTraslationPivot.ParagraphDescription,
         Language = sectionParagraphTraslationPivot.Language?.ToEntity(),
         ParagraphTitle = sectionParagraphTraslationPivot.ParagraphTitle,
         TranslationId = sectionParagraphTraslationPivot.TranslationId,
         ParagraphId = sectionParagraphTraslationPivot.ParagraphId,
         LanguageId = sectionParagraphTraslationPivot.LanguageId
     });
 }