public IList <R_DeliveryReportMessage> GetDeliveryReportMessages(string searchTerm, int pageIndex, int pageSize)
{
IList <R_DeliveryReportMessage> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_DeliveryReportMessage")
.Where("IsDeleted = 0")
.Where(
"Message like '%" + searchTerm + "%'"
)
;
results = R_DeliveryReportMessage.Fetch(pageIndex, pageSize, sql);
return(results);
}
