/// <summary>
/// Gets all Benefits.
/// </summary>
/// <param name="BenefitsParameter">The story parameters.</param>
/// <returns></returns>
public async Task <PagedList <Entity> > GetAllBenefits(BenefitsParameter benefitParameter)
{
{
{
var getBenefitsParams = new object[] {
new MySqlParameter("@p_Limit", benefitParameter.PageSize),
new MySqlParameter("@p_Offset", (benefitParameter.PageNumber - 1) * benefitParameter.PageSize),
new MySqlParameter("@p_SearchKeyword", benefitParameter.SearchKeyword),
// new MySqlParameter("@benefit", benefitParameter.Benefit),
new MySqlParameter("@p_Value", benefitParameter.Value),
new MySqlParameter("@p_FromDate", benefitParameter.FromDate),
new MySqlParameter("@p_ToDate", benefitParameter.ToDate)
};
var Benefits = await FindAll("CALL SpSelectActiveBenefit(@p_Limit, @p_Offset, @p_SearchKeyword, @p_Value, @p_FromDate,@p_ToDate)", getBenefitsParams).ToListAsync();
var mappedBenefits = Benefits.AsQueryable().ProjectTo <BenefitsResponse>(mapper.ConfigurationProvider);
var sortedBenefits = sortHelper.ApplySort(mappedBenefits, benefitParameter.OrderBy);
var shapedBenefits = dataShaper.ShapeData(sortedBenefits, benefitParameter.Fields);
return(await PagedList <Entity> .ToPagedList(shapedBenefits, benefitParameter.PageNumber, benefitParameter.PageSize));
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="GetAllBenefitsQuery"/> class.
/// </summary>
/// <param name="offersParameter">The Benefits parameters.</param>
public GetAllBenefitsQuery(BenefitsParameter benefitsParameter)
{
BenefitsParameter = benefitsParameter;
}
