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