public IEnumerable <R_ContributionMonetaryReviewer> GetContributionMonetaryReviewers()
{
IEnumerable <R_ContributionMonetaryReviewer> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_ContributionMonetaryReviewer")
.Where("IsDeleted = 0")
;
results = R_ContributionMonetaryReviewer.Query(sql);
return(results);
}
public IEnumerable <R_ContributionMonetaryReviewer> GetContributionMonetaryReviewerListAdvancedSearch(
int?volunteerId
)
{
IEnumerable <R_ContributionMonetaryReviewer> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_ContributionMonetaryReviewer")
.Where("IsDeleted = 0"
+ (volunteerId != null ? " and VolunteerId like '%" + volunteerId + "%'" : "")
)
;
results = R_ContributionMonetaryReviewer.Query(sql);
return(results);
}
