public IEnumerable <R_Address> GetAddresss()
{
IEnumerable <R_Address> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Address")
.Where("IsDeleted = 0")
;
results = R_Address.Query(sql);
return(results);
}
public IEnumerable <R_Address> GetAddressListAdvancedSearch(
string name
, string addressFirstLine
, string addressSecondLine
, int?countryId
, int?districtId
, int?countyId
, int?parishId
, string zipCode
, double?latitude
, double?longitude
, bool?active
)
{
IEnumerable <R_Address> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Address")
.Where("IsDeleted = 0"
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (addressFirstLine != null ? " and AddressFirstLine like '%" + addressFirstLine + "%'" : "")
+ (addressSecondLine != null ? " and AddressSecondLine like '%" + addressSecondLine + "%'" : "")
+ (countryId != null ? " and CountryId like '%" + countryId + "%'" : "")
+ (districtId != null ? " and DistrictId like '%" + districtId + "%'" : "")
+ (countyId != null ? " and CountyId like '%" + countyId + "%'" : "")
+ (parishId != null ? " and ParishId like '%" + parishId + "%'" : "")
+ (zipCode != null ? " and ZipCode like '%" + zipCode + "%'" : "")
+ (latitude != null ? " and Latitude like '%" + latitude + "%'" : "")
+ (longitude != null ? " and Longitude like '%" + longitude + "%'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_Address.Query(sql);
return(results);
}
