public IEnumerable <R_ContributionMonetary> GetContributionMonetarys() { IEnumerable <R_ContributionMonetary> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_ContributionMonetary") .Where("IsDeleted = 0") ; results = R_ContributionMonetary.Query(sql); return(results); }
public IEnumerable <R_ContributionMonetary> GetContributionMonetaryListAdvancedSearch( int?nucleoId , int?responsiblePersonId , int?documentId , int?partnerId , System.DateTime?contributionDateFrom , System.DateTime?contributionDateTo , double?amount , string contactPerson , string ibanOrigin , string bicSwiftOrigin , string ibanDestination , string bicSwiftDestination , string fiscalNumber , int?contributionChannelId ) { IEnumerable <R_ContributionMonetary> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_ContributionMonetary") .Where("IsDeleted = 0" + (nucleoId != null ? " and NucleoId like '%" + nucleoId + "%'" : "") + (responsiblePersonId != null ? " and ResponsiblePersonId like '%" + responsiblePersonId + "%'" : "") + (documentId != null ? " and DocumentId like '%" + documentId + "%'" : "") + (partnerId != null ? " and PartnerId like '%" + partnerId + "%'" : "") + (contributionDateFrom != null ? " and ContributionDate >= '" + contributionDateFrom.Value.ToShortDateString() + "'" : "") + (contributionDateTo != null ? " and ContributionDate <= '" + contributionDateTo.Value.ToShortDateString() + "'" : "") + (amount != null ? " and Amount like '%" + amount + "%'" : "") + (contactPerson != null ? " and ContactPerson like '%" + contactPerson + "%'" : "") + (ibanOrigin != null ? " and IbanOrigin like '%" + ibanOrigin + "%'" : "") + (bicSwiftOrigin != null ? " and BicSwiftOrigin like '%" + bicSwiftOrigin + "%'" : "") + (ibanDestination != null ? " and IbanDestination like '%" + ibanDestination + "%'" : "") + (bicSwiftDestination != null ? " and BicSwiftDestination like '%" + bicSwiftDestination + "%'" : "") + (fiscalNumber != null ? " and FiscalNumber like '%" + fiscalNumber + "%'" : "") + (contributionChannelId != null ? " and ContributionChannelId like '%" + contributionChannelId + "%'" : "") ) ; results = R_ContributionMonetary.Query(sql); return(results); }