public async Task <Automobile> GetAutomobileAsync(int theAutomobileId) { var aDto = await ConnectionAsync.Table <AutomobileDTO>().Where(aItem => aItem.Id == theAutomobileId).FirstOrDefaultAsync(); return(aDto?.ToEntity()); }
public async Task <IEnumerable <Automobile> > GetAutomobilesAsync(IEnumerable <int> theAutomobileIds) { var aResult = await ConnectionAsync.Table <AutomobileDTO>().Where(aItem => theAutomobileIds.Contains(aItem.Id)).ToListAsync(); return(aResult.Select(aItem => aItem.ToEntity()).ToList()); }
public async Task <IEnumerable <Driver> > GetDriverByLastNameAsync(string theDriverName) { var aResult = await ConnectionAsync.Table <DriverDTO>().Where(aItem => aItem.LastName.Contains(theDriverName)).ToListAsync(); // if there are no results return an empty list if (aResult == null || !aResult.Any()) { return(Enumerable.Empty <Driver>().ToList()); } return(aResult.Select(aItem => aItem.ToEntity()).ToList()); }
public async Task <IEnumerable <Driver> > GetDriversByCustomerAsync(int theCustomerId) { var aResult = await ConnectionAsync.Table <DriverDTO>().Where(aItem => aItem.CustomerId == theCustomerId).ToListAsync(); // if there are no results return an empty list if (aResult == null || !aResult.Any()) { return(Enumerable.Empty <Driver>().ToList()); } return(aResult.Select(aItem => aItem.ToEntity()).ToList()); }
public async Task <IEnumerable <Location> > GetLocationsForCustomerAsync(int theCustomerId) { var aLocations = ConnectionAsync.Table <LocationDTO>().Where(aItem => aItem.CustomerId == theCustomerId); if (aLocations == null) { return(Enumerable.Empty <Location>()); } var aLocationList = await aLocations.ToListAsync(); return(aLocationList?.Select(aItem => aItem.ToEntity()).ToList()); }
public async Task <IEnumerable <Automobile> > GetAutomobilesForLocationAsync(int theLocationId) { var aQueryResult = ConnectionAsync.Table <AutomobileDTO>().Where(aItem => aItem.LocationId == theLocationId); if (aQueryResult == null) { return(null); } var aDtoList = await aQueryResult.ToListAsync(); return(aDtoList?.Select(aItem => aItem.ToEntity()).ToList()); }
/// <summary> /// Gets all completed task async. /// </summary> /// <returns>The all completed task async.</returns> /// <param name="token">Token.</param> public async Task <IList <TodoItem> > GetAllCompletedTaskAsync(CancellationToken?token = null) { if (token.HasValue) { token.Value.ThrowIfCancellationRequested(); } IList <TodoItem> items = await ConnectionAsync.Table <TodoItem>(). Where(x => x.Status == StatusType.Completed). OrderByDescending(x => x.LastModified). ToListAsync().ConfigureAwait(false); return(items); }
public async Task <Location> GetLocationAsync(int theLocationId) { var aLocation = await ConnectionAsync.Table <LocationDTO>().Where(aItem => aItem.Id == theLocationId).FirstOrDefaultAsync(); return(aLocation?.ToEntity()); }
public async Task <Driver> GetDriverAsync(int theDriverId) { var aDriver = await ConnectionAsync.Table <DriverDTO>().Where(aItem => aItem.Id == theDriverId).FirstOrDefaultAsync(); return(aDriver?.ToEntity()); }
public async Task <IEnumerable <User> > GetUsersForCustomerAsync(int theCustomerId) { var aUser = await ConnectionAsync.Table <UserDTO>().Where(aItem => aItem.CustomerId == theCustomerId).ToListAsync(); return(aUser?.Select(aItem => aItem.ToEntity())); }
public async Task <User> GetUserByEmailAsync(string theEmail) { var aUser = await ConnectionAsync.Table <UserDTO>().Where(aItem => aItem.Email == theEmail).FirstOrDefaultAsync(); return(aUser?.ToEntity()); }
public async Task <IEnumerable <RentalAgreement> > GetRentalAgreementsForCustomerAsync(int theCustomerId) { var aRentalAgreement = await ConnectionAsync.Table <RentalAgreementDTO>().Where(aItem => aItem.CustomerId == theCustomerId).ToListAsync(); return(aRentalAgreement.Select(aItem => aItem.ToEntity()).ToList()); }
public async Task <RentalAgreement> GetRentalAgreementAsync(int theRentalAgreementId) { var aRentalAgreement = await ConnectionAsync.Table <RentalAgreementDTO>().Where(aItem => aItem.Id == theRentalAgreementId).FirstOrDefaultAsync(); return(aRentalAgreement?.ToEntity()); }
public async Task <Customer> GetCustomerByNameAsync(string theCustomerName) { var aCustomer = await ConnectionAsync.Table <CustomerDTO>().FirstOrDefaultAsync(aItem => aItem.Name == theCustomerName); return(aCustomer?.ToEntity()); }
public async Task <Customer> GetCustomerAsync(int theCustomerId) { var aCustomer = await ConnectionAsync.Table <CustomerDTO>().FirstOrDefaultAsync(aItem => aItem.Id == theCustomerId); return(aCustomer?.ToEntity()); }