public void FilterPassengers()
{
PagingAction = ePagingAction.Search;
BeaCukai cukai = new BeaCukai();
System.Linq.Expressions.Expression<Func<PAUPassenger, bool>> expr = null;
if (SearchSelectedIndex == 0)
{
expr = LogicAnd();
}
else
{
expr = LogicOr();
}
IQueryable<PAUPassenger> query = null;
if (expr != null)
{
query = (from p in cukai.PAUPassenger select p).Where(expr);
}
if (null != query)
{
OffsetPassengers = 0;
TotalPassengersCount = query.Distinct().Count();
CurrentPassengerPage = 1;
NotifyPropertyChanged("TotalPassengerPage");
NotifyPropertyChanged("TotalPassengersCount");
ResetPassengers(query.Take(RowPerPage));
}
}
public void ResetDatabases()
{
PagingAction = ePagingAction.Passengers;
BeaCukai cukai = new BeaCukai();
var queryPassengers = (from p in cukai.PAUPassenger select p);
var queryDPOS = (from d in cukai.PAUDPO select d);
var nationality = (from d in cukai.NationalityAttention select d);
OffsetPassengers = 0;
TotalPassengersCount = queryPassengers.Distinct().Count();
CurrentPassengerPage = 1;
NotifyPropertyChanged("TotalPassengerPage");
NotifyPropertyChanged("TotalPassengersCount");
ResetPassengers(queryPassengers.Take(RowPerPage));
ResetDPOS(queryDPOS);
ResetNationalityAttentions(nationality);
}
