public IEnumerable <R_ContributionChannel> GetContributionChannels() { IEnumerable <R_ContributionChannel> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_ContributionChannel") .Where("IsDeleted = 0") ; results = R_ContributionChannel.Query(sql); return(results); }
public IEnumerable <R_ContributionChannel> GetContributionChannelListAdvancedSearch( string name , string description , bool?active ) { IEnumerable <R_ContributionChannel> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_ContributionChannel") .Where("IsDeleted = 0" + (name != null ? " and Name like '%" + name + "%'" : "") + (description != null ? " and Description like '%" + description + "%'" : "") + (active != null ? " and Active = " + (active == true ? "1" : "0") : "") ) ; results = R_ContributionChannel.Query(sql); return(results); }