using Karsha_Site.Application.Interfaces.Contexts; using System; using System.Collections.Generic; using System.Linq; using Karsha_Site.Common; namespace Karsha_Site.Application.Services.About.Queries.GetAboutTels { public class GetAboutTelsServise: IGetAboutTelsServise { private readonly IDataBaseContext _context; public GetAboutTelsServise(IDataBaseContext context) { _context = context; } public ResultAboutTelsDto Execute(RequestGetAboutTelsDto request) { var aboutTels = _context.AboutTels.AsQueryable(); if (!string.IsNullOrWhiteSpace(request.SearchKey)) { aboutTels = aboutTels.Where(c => c.TelNo.ToString().Contains(request.SearchKey) || c.Title.Contains(request.SearchKey)); } int rowsCount = 0; var aboutTelsList = aboutTels.ToPaged(request.Page, request.PageSize, out rowsCount).Select(p=>new GetAboutTelsDto { Title = p.Title, TelNo = p.TelNo, AboutID = p.AboutID, IsMain = p.IsMain, ID = p.ID }).ToList(); return new ResultAboutTelsDto { AboutTelsDto = aboutTelsList, Rows = rowsCount, PageSize = request.PageSize, CurrentPage = request.Page }; } } }