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