import { DataSourceConstructor} from '@loopback/repository';

export const db = new DataSourceConstructor({
  connector: 'mssql',
  host: '192.168.1.110',
  port: 1433,
  database: 'FastDryNew',
  password: 'sa$123',
  user: 'sa',
});

@get('/Job/{CustomerID}')
  @param.path.number('CustomerID')
  async findJobByCustomerID(CustomerID: number): Promise<Jobs[]> {
    return await this.JobsRepo.find({ where: { CustomerID: CustomerID } });
  }