public async Task <ShipmentViewModel> GetShipmentAsync(string code)
        {
            int    totalPackage     = _shipmentRequestRepository.GetTotalRequest(code);
            string firstRequestCode = await _shipmentRequestRepository.GetFirstRequestCode(code);

            var query = this.dbSet
                        .Include(p => p.Vehicle)
                        .Where(p => p.Code == code)
                        .Select(p => new ShipmentViewModel
            {
                Id             = p.Id,
                Code           = p.Code,
                StartDate      = p.StartDate,
                EndDate        = p.EndDate,
                Status         = p.Status,
                RequestQuality = p.RequestQuantity,
                LicensePlate   = p.Vehicle.LicensePlate,
                PackageQuality = totalPackage,
                CurrentRequest = firstRequestCode
            });

            return(await query.FirstAsync());
        }
 public async Task <string> GetFirstRequestCode(string shipmentCode)
 {
     return(await _repository.GetFirstRequestCode(shipmentCode));
 }