queries.qry

query getCarBasedOnCarId{
  description: "get car based on carId"
  statement: SELECT com.iftakhar.dealership.Car WHERE (carId ==_$carId)
}

query getCarBasedOnMake{
  description: "get car based on make"
  statement: SELECT com.iftakhar.dealership.Car WHERE (make ==_$make)
}

query getCarBasedOnModel{
  description: "get car based on model"
  statement: SELECT com.iftakhar.dealership.Car WHERE (model ==_$model)
}

query getCarBasedOnColor{
  description: "get car based on color"
  statement: SELECT com.iftakhar.dealership.Car WHERE (color ==_$color)
}

query getCarBasedOnHorsePower{
  description: "get car based on horse power"
  statement: SELECT com.iftakhar.dealership.Car WHERE (horsePower ==_$horsePower)
}


query getCarBasedOnTransmission{
  description: "get car based on transmission"
  statement: SELECT com.iftakhar.dealership.Car WHERE (transmission ==_$transmission)
}

query getCarBasedOnPrice{
  description: "get car based on price"
  statement: SELECT com.iftakhar.dealership.Car WHERE (price ==_$price)
}

query getOrdersByCustomerId {
  description: "Get all orders for a customer"
  statement: 
      SELECT com.iftakhar.dealership.Order
      WHERE (customer.customerId == _$customerId)
}

query getOrdersByDealerId {
  description: "Get all orders for a dealer"
  statement: 
      SELECT com.iftakhar.dealership.Order
      WHERE (dealer.dealerId == _$dealerId)
}

query getOrderByOrderId {
  description: "get order for a orderId"
  statement: 
      SELECT com.iftakhar.dealership.Order
      WHERE (orderId == _$orderId)
}

query getLogisticCompanyByLogisticCompanyId {
  description: "get Logistic company from logisticId"
  statement: 
      SELECT com.iftakhar.dealership.LogisticCompany
      WHERE (logisticsCompanyId == _$logisticsCompanyId)
}

query getOrdersByLogisticsCompanyId {
  description: "Get all orders for a logistics company"
  statement: 
      SELECT com.iftakhar.dealership.Order
      WHERE (logisticCompany.logisticsCompanyId == _$logisticsCompanyId)
}