/// <summary>
///
/// </summary>
/// <returns></returns>
public Page <SocialMedias> Get(SocialMediaFilter filter)
{
Page <SocialMedias> result = new Page <SocialMedias>();
result.PageIndex = filter.Pindex.Value;
result.PageSize = filter.Psize.Value;
string query = @" SELECT [SM].* FROM [SocialMedia] AS [SM]
WHERE
([SM].[Name] LIKE '%' + @Name + '%' OR @Name IS NULL)
AND ([SM].[Active] = @Active OR @Active IS NULL)
AND ([SM].[SocialMedia] = @SocialMedia OR @SocialMedia IS NULL)
ORDER BY [Name]
OFFSET @Psize * @Pindex ROWS FETCH NEXT @Psize ROWS ONLY;";
string qcount = @" SELECT COUNT([SM].Id) FROM [SocialMedia] AS [SM]
WHERE
([SM].[Name] LIKE '%' + @Name + '%' OR @Name IS NULL)
AND ([SM].[Active] = @Active OR @Active IS NULL)
AND ([SM].[SocialMedia] = @SocialMedia OR @SocialMedia IS NULL)";
var count = base.Context.ExecuteScalar(qcount, filter);
result.Total = Convert.ToInt32(count);
result.Result = this.Context.Query <SocialMedias>(query, filter);
return(result);
}
public Page <SocialMedias> Get([FromQuery] SocialMediaFilter filter)
{
return(this.svc.Get(filter));
}
public Page <SocialMedias> Get(SocialMediaFilter filter)
{
filter.Pindex = filter.Pindex.HasValue ? filter.Pindex.Value : 0;
filter.Psize = filter.Psize.HasValue ? filter.Psize.Value : 20;
return(repo.Get(filter));
}
