public IEnumerable <R_Beneficiary> GetBeneficiaryListAdvancedSearch( string name , int?number , int?addressId , int?numberOfAdults , int?numberOfChildren , int?numberOfTupperware , int?numberOfSoups , string description , bool?active ) { IEnumerable <R_Beneficiary> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_Beneficiary") .Where("IsDeleted = 0" + (name != null ? " and Name like '%" + name + "%'" : "") + (number != null ? " and Number like '%" + number + "%'" : "") + (addressId != null ? " and AddressId like '%" + addressId + "%'" : "") + (numberOfAdults != null ? " and NumberOfAdults like '%" + numberOfAdults + "%'" : "") + (numberOfChildren != null ? " and NumberOfChildren like '%" + numberOfChildren + "%'" : "") + (numberOfTupperware != null ? " and NumberOfTupperware like '%" + numberOfTupperware + "%'" : "") + (numberOfSoups != null ? " and NumberOfSoups like '%" + numberOfSoups + "%'" : "") + (description != null ? " and Description like '%" + description + "%'" : "") + (active != null ? " and Active = " + (active == true ? "1" : "0") : "") ) ; results = R_Beneficiary.Query(sql); return(results); }
public IEnumerable <R_Beneficiary> GetBeneficiarys() { IEnumerable <R_Beneficiary> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_Beneficiary") .Where("IsDeleted = 0") ; results = R_Beneficiary.Query(sql); return(results); }