/// <summary>
/// To get all mortgages.
/// </summary>
/// <returns>List<Mortgage></returns>
public List <Mortgage> GetAllMortgages()
{
if (MortgageSingleton.CreateInstance.MortgageList == null || MortgageSingleton.CreateInstance.MortgageList.Count() == 0)
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.ToList();
List <Mortgage> result = new List <Mortgage>();
foreach (var mortgage in mortgages)
{
result.Add(new Mortgage()
{
Name = mortgage.Name,
EffectiveStartDate = mortgage.EffectiveStartDate,
EffectiveEndDate = mortgage.EffectiveEndDate,
CancellationFee = mortgage.CancellationFee,
EstablishmentFee = mortgage.EstablishmentFee,
InterestRate = mortgage.InterestRate,
InterestRepayment = (InterestRepayment)Enum.Parse(typeof(InterestRepayment), mortgage.InterestRepayment.ToString()),
MortgageId = mortgage.MortgageId,
MortgageType = (MortgageType)Enum.Parse(typeof(MortgageType), mortgage.MortgageType.ToString()),
TermsInMonths = GetTermsInMonths(mortgage.EffectiveStartDate, mortgage.EffectiveEndDate)
}
);
}
MortgageSingleton.CreateInstance.MortgageList = result;
}
}
return(MortgageSingleton.CreateInstance.MortgageList);
}
public List <Mortgage> GetAllMortgages()
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.ToList();
List <Mortgage> result = new List <Mortgage>();
foreach (var mortgage in mortgages)
{
result.Add(new Mortgage()
{
Name = mortgage.Name,
EffectiveStartDate = mortgage.EffectiveStartDate,
EffectiveEndDate = mortgage.EffectiveEndDate,
CancellationFee = mortgage.CancellationFee,
EstablishmentFee = mortgage.CancellationFee,
InterestRepaymentType = (InterestRepayment)(mortgage.InterestRepayment),
MortgageId = mortgage.MortgageId,
MortgageType = (MortgageType)mortgage.MortgageType,
InterestRate = mortgage.InterestRate,
TermsInMonths = GetMonthDifference(mortgage.EffectiveStartDate, mortgage.EffectiveEndDate)
});
}
return(result.OrderBy(x => x.MortgageType).ThenBy(x => x.InterestRate).ToList());
}
}
public List <Mortgage> GetAllMortgages()
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.ToList();
List <Mortgage> result = new List <Mortgage>();
foreach (var mortgage in mortgages)
{
result.Add(new Mortgage()
{
Name = mortgage.Name,
EffectiveStartDate = mortgage.EffectiveStartDate,
EffectiveEndDate = mortgage.EffectiveEndDate,
CancellationFee = mortgage.CancellationFee,
EstablishmentFee = mortgage.CancellationFee,
InterestRepayment = (InterestRepayment)Enum.Parse(typeof(InterestRepayment), mortgage.InterestRepayment.ToString()),
MortgageId = mortgage.MortgageId,
MortgageType = (MortgageType)Enum.Parse(typeof(MortgageType), mortgage.MortgageType.ToString()),
TermsInMonths = mortgage.TermsInMonths,
InterestRate = mortgage.InterestRate
}
);
}
return(result);
}
}
/// <summary>
/// Get all mortages from cache
/// </summary>
/// <returns></returns>
private List <Mortgage> GetAllMortgages()
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.Where(x => x.EffectiveEndDate >= DateTime.Now).OrderBy(x => x.MortgageType).ThenBy(x => x.InterestRate).ToList();
List <Mortgage> result = new List <Mortgage>();
foreach (var mortgage in mortgages)
{
result.Add(new Mortgage()
{
Name = mortgage.Name,
EffectiveStartDate = mortgage.EffectiveStartDate,
EffectiveEndDate = mortgage.EffectiveEndDate,
CancellationFee = mortgage.CancellationFee,
EstablishmentFee = mortgage.CancellationFee,
InterestRepayment = (InterestRepayment)Enum.Parse(typeof(InterestRepayment), mortgage.InterestRepayment.ToString()),
MortgageId = mortgage.MortgageId,
MortgageType = (MortgageType)Enum.Parse(typeof(MortgageType), mortgage.MortgageType.ToString()),
InterestRate = mortgage.InterestRate
}
);
}
return(result);
}
}
public List <Mortgage> GetAllMortgages()
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.ToList();
List <Mortgage> result = new List <Mortgage>();
if (mortgages != null && mortgages.Count() > 0)
{
result.AddRange(
mortgages
.Select(mortgage => new Mortgage()
{
Name = $"{mortgage.Name} @ {mortgage.InterestRate.ToString()}%",
EffectiveStartDate = mortgage.EffectiveStartDate,
EffectiveEndDate = mortgage.EffectiveEndDate,
CancellationFee = mortgage.CancellationFee,
EstablishmentFee = mortgage.EstablishmentFee,
InterestRepayment = (InterestRepayment)Enum.Parse(typeof(InterestRepayment), mortgage.InterestRepayment.ToString().Trim()),
MortgageId = mortgage.MortgageId,
MortgageType = (MortgageType)Enum.Parse(typeof(MortgageType), mortgage.MortgageType.ToString().Trim()),
InterestRate = mortgage.InterestRate
})
.OrderBy(mt => mt.MortgageType)
.ThenBy(mt => mt.InterestRate)
);
}
return(result);
}
}
public List <Mortgage> GetAllMortgages()
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.ToList();
List <Mortgage> result = new List <Mortgage>();
foreach (var mortgage in mortgages)
{
result.Add(new Mortgage()
{
MortgageId = mortgage.MortgageId,
Name = mortgage.Name,
InterestRepayment = (InterestRepayment)(int)mortgage.InterestRepayment,
EffectiveStartDate = mortgage.EffectiveStartDate,
EffectiveEndDate = mortgage.EffectiveEndDate,
MortgageType = (MortgageType)(int)mortgage.MortgageType,
CancellationFee = mortgage.CancellationFee,
EstablishmentFee = mortgage.CancellationFee,
InterestRate = mortgage.InterestRate
//doesn't exist the property in the class inside the dll
//TermsInMonths = mortgage.TermsInMonths
}
);
}
return(result);
}
}
public IEnumerable <Mortgage> GetAllMortgages()
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.OrderBy(x => x.MortgageType)
.ThenBy(x => x.InterestRate)
.ToList();
return(Mapper.Map <IEnumerable <Mortgage> >(mortgages));
}
}
public List <Mortgage> GetAllMortgages()
{
List <Mortgage> result = new List <Mortgage>();
try
{
using (var context = new MortgageData.MortgageDataContext())
{
var mortgages = context.Mortgages.OrderBy(mortgage => mortgage.MortgageType).ThenBy(mortgage => mortgage.InterestRate).ToList();
foreach (var mortgage in mortgages)
{
result.Add(new Mortgage
{
Name = mortgage.Name,
EffectiveStartDate = mortgage.EffectiveStartDate,
EffectiveEndDate = mortgage.EffectiveEndDate,
CancellationFee = mortgage.CancellationFee,
EstablishmentFee = mortgage.EstablishmentFee,
InterestRepayment = (InterestRepayment)Enum.Parse(typeof(InterestRepayment), mortgage.InterestRepayment.ToString()),
MortgageId = mortgage.MortgageId,
MortgageType = (MortgageType)Enum.Parse(typeof(MortgageType), mortgage.MortgageType.ToString()),
TermsInMonths = NoOfMonths(mortgage.EffectiveStartDate, mortgage.EffectiveEndDate),
InterestRate = mortgage.InterestRate
}
);
}
log.Info("Loaded mortgage details from the MortgageData.dll");
}
}
catch (Exception ex)
{
log.Error(ex.Message + ex.StackTrace);
}
return(result);
}
public void Initialize()
{
_databaseContext = new MortgageData.MortgageDataContext();
_objRepo = new MortgageRepository();
}
