public List<Domain.DTO.LeaseTimeDTO> GetAllLeaseTime() { List<Ciklum.ATEA.Finance.Service.Domain.DTO.LeaseTimeDTO> lstLeaseTime = new List<Domain.DTO.LeaseTimeDTO>(); try { using (var context = new Ciklum.Atea.Finance.Service.Domain.EntityModel.FinanceDBEntities()) { System.Data.Objects.ObjectResult<Ciklum.Atea.Finance.Service.Domain.EntityModel.LeaseTime_GetAll_Result> lst = context.LeaseTime_GetAll(); Domain.DTO.LeaseTimeDTO objLeaseTime = null; foreach (var item in lst) { objLeaseTime = new Domain.DTO.LeaseTimeDTO(); objLeaseTime.LeaseTimeID = item.ID; objLeaseTime.LeaseTime = item.Months; objLeaseTime.LeaseTimeDescription = item.Description; lstLeaseTime.Add(objLeaseTime); objLeaseTime = null; } } } catch (Exception ex) { lgLogging.LogFatalException(ex); } return lstLeaseTime; }
public List<Domain.DTO.InterestRateDTO> GetAllInterestRate() { List<Ciklum.ATEA.Finance.Service.Domain.DTO.InterestRateDTO> lstInterestRate = new List<Domain.DTO.InterestRateDTO>(); try { using (var context = new Ciklum.Atea.Finance.Service.Domain.EntityModel.FinanceDBEntities()) { System.Data.Objects.ObjectResult<Ciklum.Atea.Finance.Service.Domain.EntityModel.InterestRate_GetAll_Result> lst = context.InterestRate_GetAll(); Domain.DTO.InterestRateDTO objInterestRate = null; foreach (var item in lst) { if (item.IsActive == 0) { continue; } objInterestRate = new Domain.DTO.InterestRateDTO(); objInterestRate.CountryLeaseTimeID = item.CountyLeaseTimeID; objInterestRate.CountryID = item.CountryID; objInterestRate.CountryName = item.CountryName; objInterestRate.CountryCurrency = item.CountryCurrency; objInterestRate.RoundCurrency = item.RoundCurrency; objInterestRate.CountryEmail = item.CountryEmail; objInterestRate.LeaseTimeID = item.LeaseTimeID; objInterestRate.LeaseTime = item.LeaseTime.ToString(); objInterestRate.CostOfFund = item.CostOfFunds == String.Empty ? "0" : item.CostOfFunds; objInterestRate.Margin = item.Margin == String.Empty ? "0" : item.Margin; ; objInterestRate.FunderMargin = item.FunderMargin == null || item.FunderMargin == String.Empty ? "0" : item.FunderMargin; ; objInterestRate.StartDate = item.StartDate; objInterestRate.IRR = item.IRR; objInterestRate.EndDate = item.EndDate; objInterestRate.IsActive = item.IsActive == 0 ? false : true; lstInterestRate.Add(objInterestRate); objInterestRate = null; } } } catch (Exception ex) { lgLogging.LogFatalException(ex); } return lstInterestRate; }