public async Task <VideoShowResponse> VideoGetList(VideoShowRequest request) { try { using (IDbConnection connection = new SqlConnection(_configuration.GetValue <string>("ConnectionStrings:DefaultConnection"))) { List <VideoShow> lstData = new List <VideoShow>(); DynamicParameters parameters = new DynamicParameters(); parameters.Add("@subtractIds", request.SubtractIds); parameters.Add("@danhmuc", request.Danhmuc); parameters.Add("@istruyenhinh", request.Istruyenhinh); parameters.Add("@portalId", request.PortalId); parameters.Add("@PageIndex", request.PageIndex); parameters.Add("@PageSize", request.PageSize); await Task.Run(() => lstData = connection.Query <VideoShow>("VideosShowfind_Index", parameters, null, true, null, CommandType.StoredProcedure).AsList <VideoShow>() ); int totalRecords = lstData.Count > 0 ? lstData[0].TotalRecords : 0; return(new VideoShowResponse { Status = ResponseStatus.Success, Message = ResponseStatus.Success.ToString(), LstVideo = lstData, TotalRecords = totalRecords, }); } } catch (Exception ex) { return(new VideoShowResponse { Status = ResponseStatus.Faile, Message = ex.Message, }); } }
public async Task <VideoShowResponse> VideoGetList([FromQuery] VideoShowRequest request) { return(await _businessLogic.VideoGetList(request)); }