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);
}