public static Trip GetPrevious(int VehicleId, int CurrentTripId)
{
if (CurrentTripId == 0)
{
return(TripDa.GetList().Where(q => q.VehicleId == VehicleId).OrderByDescending(q => q.Id).FirstOrDefault());
}
else
{
return(TripDa.GetList().Where(q => q.VehicleId == VehicleId && q.Id < CurrentTripId).OrderByDescending(q => q.Id).FirstOrDefault());
}
}
public static decimal TotalMileage(int RefillId)
{
return(TripDa.GetList().Where(q => q.RefillId == RefillId).Sum(q => q.MileageEnd) - TripDa.GetList().Where(q => q.RefillId == RefillId).Sum(q => q.MileageStart));
}
public static List <Trip> GetList()
{
return(TripDa.GetList().OrderByDescending(q => q.Id).ToList());
}
public static bool RefillInUse(int RefillId)
{
return(TripDa.GetList().Where(q => q.RefillId == RefillId).ToList().Count > 0);
}
public static bool VehicleInUse(int VehicleId)
{
return(TripDa.GetList().Where(q => q.VehicleId == VehicleId).ToList().Count > 0);
}
public static bool DriverInUse(int DriverId)
{
return(TripDa.GetList().Where(q => q.DriverId == DriverId).ToList().Count > 0);
}
public static Trip GetPrevious(int VehicleId)
{
return(TripDa.GetList().Where(q => q.VehicleId == VehicleId).OrderByDescending(q => q.Id).FirstOrDefault());
}