C# (CSharp) R_Task.Fetch Examples

Example #1

        public IList <R_Task> GetTasks(string searchTerm, int pageIndex, int pageSize)
        {
            IList <R_Task> results = null;

            var sql = PetaPoco.Sql.Builder
                      .Select("*")
                      .From("R_Task")
                      .Where("IsDeleted = 0")
                      .Where(
                "Name like '%" + searchTerm + "%'"
                + " or " + "Description like '%" + searchTerm + "%'"
                )
            ;

            results = R_Task.Fetch(pageIndex, pageSize, sql);

            return(results);
        }