public List <FrayteExchangeRateHistory> GetExchangeRateHistory(FrayteSearchExchangeHistory search) { try { List <FrayteExchangeRateHistory> _rate = new List <FrayteExchangeRateHistory>(); var detail = dbContext.OperationZoneExchangeRateHistories.Where(p => p.OperationZoneId == search.OperationZoneId && p.ExchangeType == search.ExchangeType && p.StartDate.Value.Year == search.Year && p.StartDate.Value.Month == search.MonthName.MonthId) .ToList(); if (detail != null && detail.Count > 0) { FrayteExchangeRateHistory frayte; foreach (var Obj in detail) { frayte = new FrayteExchangeRateHistory(); OperationZone oz = dbContext.OperationZones.Where(p => p.OperationZoneId == Obj.OperationZoneId.Value).FirstOrDefault(); if (oz != null) { frayte.OperationZone = new FrayteOperationZone(); { frayte.OperationZone.OperationZoneId = oz.OperationZoneId; frayte.OperationZone.OperationZoneName = oz.Name; } } CurrencyType ct = dbContext.CurrencyTypes.Where(x => x.CurrencyCode == Obj.CurrencyCode).FirstOrDefault(); if (ct != null) { frayte.CurrencyDetail = new FrayteCurrencyDetail(); { frayte.CurrencyDetail.CurrencyCode = ct.CurrencyCode; frayte.CurrencyDetail.Description = ct.CurrencyDescription; } } frayte.ExchangeType = Obj.ExchangeType; if (Obj.ExchangeRate.HasValue) { frayte.ExchangeRate = Obj.ExchangeRate.Value.ToString(); } if (Obj.StartDate.HasValue) { frayte.StartDate = Obj.StartDate.Value; } if (Obj.FinishDate.HasValue) { frayte.FinishDate = Obj.FinishDate.Value; } _rate.Add(frayte); } } return(_rate); } catch (Exception x) { return(null); } }
public List <FrayteExchangeRateHistory> ExchangeRateHistory(FrayteSearchExchangeHistory search) { List <FrayteExchangeRateHistory> _rate = new ExchangeRateRepository().GetExchangeRateHistory(search); return(_rate); }