public IEnumerable <TEntityType> Fetch <TEntityType>(ListRequestParam requestParams)
{
using (NPoco.IDatabase db = GetDataBase())
{
return(db.SkipTake <TEntityType>(requestParams.CurrentPage * requestParams.PageCount, requestParams.PageCount, ConvertRequestParamToSqlTemplate(requestParams)));
}
}
public IEnumerable <NewsDTO> GetAll(ListRequestParam RequestParams)
{
try
{
IEnumerable <INewsEntity> entitiyList = DatabaseInstance.Fetch <NewsNPocoEntity>(RequestParams);
List <NewsDTO> dtoList = new List <NewsDTO>();
entitiyList.ToList().ForEach(itm =>
{
dtoList.Add(itm.ToDTO <NewsDTO>());
});
return(dtoList);
}
catch (Exception ex)
{
LoggerInstance.Log(ex);
throw ex;
}
}
private Template ConvertRequestParamToSqlTemplate(ListRequestParam requestParams)
{
var sqlBuilder = new SqlBuilder();
int counter_parameters = 0;
requestParams.Criterias.ForEach(cr =>
{
if (cr.Value == null)
{
sqlBuilder.Where(string.Format(SqlWhereParamISNULLFormat, cr.Name), new List <object>()
{
});
}
else
{
sqlBuilder.Where(string.Format(SqlWhereParamFormat, cr.Name, counter_parameters), new List <object>()
{
cr.Value
});
counter_parameters++;
}
});
return(sqlBuilder.AddTemplate("where /**where**/", new List <object>()));
}
public GetCategoryRequest()
{
RequestParams = new ListRequestParam();
}
