protected virtual IEnumerable<GtmsFormatTarrifModel> MapItem(CarrierFormatTariffModel carrierFormatTariffModel)
 {
     var outputTarrifCarrierModels = carrierFormatTariffModel.Prices.Select(priceModel => new GtmsFormatTarrifModel
     {
         NameDeparture = carrierFormatTariffModel.NameDeparture,
         CodeDeparture = carrierFormatTariffModel.CodeDeparture,
         NameDestination = carrierFormatTariffModel.NameDestination,
         CodeDestination = carrierFormatTariffModel.CodeDestination,
         WeightFrom = GetWeightFromAndTo(priceModel.Key).Item1,
         WeightTo = GetWeightFromAndTo(priceModel.Key).Item2,
         Price = priceModel.Value.Price,
         AddPrice = priceModel.Value.AddPrice,
         PriceCurrency = Currency,
         VatRatePrice = Vat
     }).ToList();
     return outputTarrifCarrierModels;
 }
 protected virtual CarrierFormatTariffModel MapItem(IEnumerable<GtmsFormatTarrifModel> data)
 {
     var carrierTariff = new CarrierFormatTariffModel
     {
         NameDeparture = data.FirstOrDefault().NameDeparture,
         CodeDeparture = data.FirstOrDefault().CodeDeparture,
         NameDestination = data.FirstOrDefault().NameDestination,
         CodeDestination = data.FirstOrDefault().CodeDestination
     };
     foreach (var item in data)
     {
         carrierTariff.Prices.Add(GetWeightFromStrings(item.WeightFrom, item.WeightTo), new PriceModel
         {
             Price = item.Price,
             AddPrice = item.AddPrice
         });
     }
     return carrierTariff;
 }
 private CarrierFormatTariffModel GetVorTariff(Range cell, int row)
 {
     var inTarrifCarrierModel = new CarrierFormatTariffModel
     {
         NameDeparture = ((Range)cell[row, 1]).Value == null ? string.Empty : ((Range)cell[row, 1]).Value.ToString(),
         CodeDeparture = ((Range)cell[row, 2]).Value == null ? string.Empty : ((Range)cell[row, 2]).Value.ToString(),
         NameDestination = ((Range)cell[row, 3]).Value == null ? string.Empty : ((Range)cell[row, 3]).Value.ToString(),
         CodeDestination = ((Range)cell[row, 4]).Value == null ? string.Empty : ((Range)cell[row, 4]).Value.ToString()
     };
     //todo переделать на цикл
     inTarrifCarrierModel.Prices.Add(WeightGrading.Range_0_1, new PriceModel
     {
         Price = ((Range)cell[row, 5]).Value == null ? string.Empty : ((Range)cell[row, 5]).Value.ToString(),
         AddPrice = "0"
     });
     inTarrifCarrierModel.Prices.Add(WeightGrading.Range_1_10, new PriceModel
     {
         Price = ((Range)cell[row, 5]).Value == null ? string.Empty : ((Range)cell[row, 5]).Value.ToString(),
         AddPrice = ((Range)cell[row, 6]).Value == null ? string.Empty : ((Range)cell[row, 6]).Value.ToString(),
     });
     inTarrifCarrierModel.Prices.Add(WeightGrading.Range_10_20, new PriceModel
     {
         Price = ((Range)cell[row, 7]).Value == null ? string.Empty : ((Range)cell[row, 7]).Value.ToString(),
         AddPrice = ((Range)cell[row, 8]).Value == null ? string.Empty : ((Range)cell[row, 8]).Value.ToString(),
     });
     inTarrifCarrierModel.Prices.Add(WeightGrading.Range_20_30, new PriceModel
     {
         Price = ((Range)cell[row, 9]).Value == null ? string.Empty : ((Range)cell[row, 9]).Value.ToString(),
         AddPrice = ((Range)cell[row, 10]).Value == null ? string.Empty : ((Range)cell[row, 10]).Value.ToString()
     });
     inTarrifCarrierModel.Prices.Add(WeightGrading.Range_30_1000, new PriceModel
     {
         Price = ((Range)cell[row, 11]).Value == null ? string.Empty : ((Range)cell[row, 11]).Value.ToString(),
         AddPrice = ((Range)cell[row, 12]).Value == null ? string.Empty : ((Range)cell[row, 12]).Value.ToString()
     });
     return inTarrifCarrierModel;
 }