public IEnumerable <R_Checkpoint> GetCheckpointListByPlannedRouteId(int itemId)
{
IEnumerable <R_Checkpoint> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Checkpoint")
.Where("IsDeleted = 0 and PlannedRouteId = @0", itemId)
;
results = R_Checkpoint.Query(sql);
return(results);
}
public IEnumerable <R_Checkpoint> GetCheckpoints()
{
IEnumerable <R_Checkpoint> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Checkpoint")
.Where("IsDeleted = 0")
;
results = R_Checkpoint.Query(sql);
return(results);
}
public IEnumerable <R_Checkpoint> GetCheckpointListAdvancedSearch(
int?plannedRouteId
, string name
, int?orderNumber
, double?latitude
, double?longitude
, int?addressId
, int?estimatedTimeArrival
, System.DateTime?minimumTimeFrom
, System.DateTime?minimumTimeTo
, System.DateTime?maximumTimeFrom
, System.DateTime?maximumTimeTo
, int?nucleoId
, int?supplierId
, bool?active
)
{
IEnumerable <R_Checkpoint> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_Checkpoint")
.Where("IsDeleted = 0"
+ (plannedRouteId != null ? " and PlannedRouteId = " + plannedRouteId : "")
+ (name != null ? " and Name like '%" + name + "%'" : "")
+ (orderNumber != null ? " and OrderNumber = " + orderNumber : "")
+ (latitude != null ? " and Latitude like '%" + latitude + "%'" : "")
+ (longitude != null ? " and Longitude like '%" + longitude + "%'" : "")
+ (addressId != null ? " and AddressId like '%" + addressId + "%'" : "")
+ (estimatedTimeArrival != null ? " and EstimatedTimeArrival = " + estimatedTimeArrival : "")
+ (minimumTimeFrom != null ? " and MinimumTime >= '" + minimumTimeFrom.Value.ToShortDateString() + "'" : "")
+ (minimumTimeTo != null ? " and MinimumTime <= '" + minimumTimeTo.Value.ToShortDateString() + "'" : "")
+ (maximumTimeFrom != null ? " and MaximumTime >= '" + maximumTimeFrom.Value.ToShortDateString() + "'" : "")
+ (maximumTimeTo != null ? " and MaximumTime <= '" + maximumTimeTo.Value.ToShortDateString() + "'" : "")
+ (nucleoId != null ? " and NucleoId like '%" + nucleoId + "%'" : "")
+ (supplierId != null ? " and SupplierId like '%" + supplierId + "%'" : "")
+ (active != null ? " and Active = " + (active == true ? "1" : "0") : "")
)
;
results = R_Checkpoint.Query(sql);
return(results);
}