public ActionResult _LiabilityTable()
{
RealEstateLiabilityListCreateViewModel liabilities = (RealEstateLiabilityListCreateViewModel)HttpContext.Session["LIABILITIES"];
RealEstateLiabilityListViewModel model = new RealEstateLiabilityListViewModel();
if (liabilities == null)
{
liabilities = new RealEstateLiabilityListCreateViewModel();
}
foreach (var liability in liabilities.Liabilities)
{
RealEstateLiabilityViewModel viewModel = new RealEstateLiabilityViewModel();
viewModel.Id = liability.Id;
viewModel.Source = liability.Source;
viewModel.Value = liability.Value;
viewModel.InterestRate = liability.InterestRate / 100;
viewModel.InterestRatePerX = Helper.GetInterestTypePerX(liability.InterestRatePerX);
viewModel.StartDate = liability.StartDate;
viewModel.EndDate = liability.EndDate;
viewModel.InterestType = RealEstateLiabilityQueries.Helper.GetInterestType(liability.InterestType);
viewModel.PaymentPeriod = Helper.CalculateTimePeriod(viewModel.StartDate.Value, viewModel.EndDate.Value);
model.Liabilities.Add(viewModel);
}
return(PartialView(model));
}
public static RealEstateSummaryListViewModel GetRealEstateSummaryByUser(string username)
{
Entities entities = new Entities();
RealEstateSummaryListViewModel result = new RealEstateSummaryListViewModel();
DateTime current = DateTime.Now;
var realEstates = entities.Assets.Include("Incomes").Include("Liabilities").Where(x => x.Username.Equals(username) &&
x.AssetType == (int)Constants.Constants.ASSET_TYPE.REAL_ESTATE &&
!x.DisabledDate.HasValue);
foreach (var realEstate in realEstates)
{
RealEstateSummaryViewModel realEstateViewModel = new RealEstateSummaryViewModel();
realEstateViewModel.Name = realEstate.AssetName;
realEstateViewModel.Value = realEstate.Value;
if (realEstate.Incomes1.Where(x => !x.DisabledDate.HasValue).Any())
{
realEstateViewModel.Income = realEstate.Incomes1.FirstOrDefault().Value;
}
else
{
realEstateViewModel.Income = 0;
}
realEstateViewModel.AnnualIncome = realEstateViewModel.Income * 12;
realEstateViewModel.RentYield = realEstateViewModel.Value > 0 ? realEstateViewModel.AnnualIncome / realEstateViewModel.Value : 0;
foreach (var liability in realEstate.Liabilities.Where(x => !x.DisabledDate.HasValue))
{
RealEstateLiabilityViewModel liabilityViewModel = RealEstateLiabilityQueries.CreateViewModel(liability);
if (liabilityViewModel.StartDate <= current && liabilityViewModel.EndDate >= current)
{
realEstateViewModel.LiabilityValue += liabilityViewModel.Value.Value;
realEstateViewModel.OriginalInterestPayment += liabilityViewModel.OriginalInterestPayment;
realEstateViewModel.MonthlyInterestPayment += liabilityViewModel.MonthlyInterestPayment;
realEstateViewModel.MonthlyPayment += liabilityViewModel.TotalMonthlyPayment;
realEstateViewModel.AnnualPayment += liabilityViewModel.TotalPayment;
realEstateViewModel.RemainedValue += liabilityViewModel.RemainedValue;
}
}
realEstateViewModel.InterestRate = realEstateViewModel.LiabilityValue > 0 ? realEstateViewModel.OriginalInterestPayment / realEstateViewModel.LiabilityValue * 12 : 0;
result.RealEstateSummaries.Add(realEstateViewModel);
}
result.TotalIncome = result.RealEstateSummaries.Sum(x => x.Income);
result.TotalAnnualIncome = result.RealEstateSummaries.Sum(x => x.AnnualIncome);
result.TotalValue = result.RealEstateSummaries.Sum(x => x.Value);
result.TotalRentYield = result.TotalValue > 0 ? result.RealEstateSummaries.Sum(x => x.AnnualIncome) / result.TotalValue : 0;
result.TotalLiabilityValue = result.RealEstateSummaries.Sum(x => x.LiabilityValue);
result.TotalInterestRate = result.TotalLiabilityValue > 0 ? result.RealEstateSummaries.Sum(x => x.OriginalInterestPayment) / result.TotalLiabilityValue * 12 : 0;
result.TotalMonthlyPayment = result.RealEstateSummaries.Sum(x => x.MonthlyPayment);
result.TotalAnnualPayment = result.RealEstateSummaries.Sum(x => x.AnnualPayment);
result.TotalRemainedValue = result.RealEstateSummaries.Sum(x => x.RemainedValue);
return(result);
}
public static RealEstateListViewModel GetRealEstateByUser(string username)
{
Entities entities = new Entities();
RealEstateListViewModel result = new RealEstateListViewModel();
DateTime current = DateTime.Now;
var realEstates = entities.Assets.Include("Incomes").Include("Liabilities").Where(x => x.Username.Equals(username) &&
x.AssetType == (int)Constants.Constants.ASSET_TYPE.REAL_ESTATE &&
!x.DisabledDate.HasValue);
foreach (var realEstate in realEstates)
{
RealEstateViewModel realEstateViewModel = new RealEstateViewModel();
realEstateViewModel.Id = realEstate.Id;
realEstateViewModel.Name = realEstate.AssetName;
realEstateViewModel.Value = realEstate.Value;
if (realEstate.Incomes1.Where(x => !x.DisabledDate.HasValue).Any())
{
realEstateViewModel.Income = realEstate.Incomes1.FirstOrDefault().Value;
}
else
{
realEstateViewModel.Income = 0;
}
realEstateViewModel.AnnualIncome = realEstateViewModel.Income * 12;
realEstateViewModel.RentYield = realEstateViewModel.Value > 0 ? realEstateViewModel.AnnualIncome / realEstateViewModel.Value : 0;
foreach (var liability in realEstate.Liabilities.Where(x => !x.DisabledDate.HasValue))
{
RealEstateLiabilityViewModel liabilityViewModel = RealEstateLiabilityQueries.CreateViewModel(liability);
realEstateViewModel.Liabilities.Add(liabilityViewModel);
}
var liabilities = realEstateViewModel.Liabilities.Where(x => x.StartDate <= current && x.EndDate >= current);
realEstateViewModel.TotalLiabilityValue = liabilities.Select(x => x.Value.Value).DefaultIfEmpty(0).Sum();
realEstateViewModel.TotalOriginalPayment = liabilities.Select(x => x.MonthlyOriginalPayment).DefaultIfEmpty(0).Sum();
realEstateViewModel.TotalInterestPayment = liabilities.Select(x => x.MonthlyInterestPayment).DefaultIfEmpty(0).Sum();
realEstateViewModel.TotalMonthlyPayment = liabilities.Select(x => x.TotalMonthlyPayment).DefaultIfEmpty(0).Sum();
realEstateViewModel.TotalPayment = liabilities.Select(x => x.TotalPayment).DefaultIfEmpty(0).Sum();
realEstateViewModel.TotalRemainedValue = liabilities.Select(x => x.RemainedValue).DefaultIfEmpty(0).Sum();
realEstateViewModel.TotalInterestRate = realEstateViewModel.TotalLiabilityValue > 0 ? liabilities.Select(x => x.OriginalInterestPayment).DefaultIfEmpty(0).Sum() / realEstateViewModel.TotalLiabilityValue * 12 : 0;
realEstateViewModel.RowSpan = realEstateViewModel.Liabilities.Any() ? realEstateViewModel.Liabilities.Count() + 3 : 2;
result.RealEstates.Add(realEstateViewModel);
}
result.TotalValue = result.RealEstates.Select(x => x.Value).DefaultIfEmpty(0).Sum();
result.TotalMonthlyIncome = result.RealEstates.Select(x => x.Income).DefaultIfEmpty(0).Sum();
result.TotalAnnualIncome = result.TotalMonthlyIncome * 12;
result.TotalRentYield = result.TotalValue > 0 ? result.TotalAnnualIncome / result.TotalValue : 0;
result.IsInitialized = UserQueries.IsCompleteInitialized(username);
return(result);
}
public static RealEstateLiabilityViewModel CreateViewModel(Liabilities liability)
{
DateTime current = DateTime.Now;
RealEstateLiabilityViewModel liabilityViewModel = new RealEstateLiabilityViewModel();
liabilityViewModel.Id = liability.Id;
liabilityViewModel.Source = liability.Name;
liabilityViewModel.Value = liability.Value;
liabilityViewModel.InterestType = Helper.GetInterestType(liability.InterestType.Value);
liabilityViewModel.InterestRatePerX = Helper.GetInterestTypePerX(liability.InterestRatePerX);
liabilityViewModel.InterestRate = liability.InterestRate / 100;
liabilityViewModel.StartDate = liability.StartDate.Value;
liabilityViewModel.EndDate = liability.EndDate.Value;
liabilityViewModel.PaymentPeriod = Helper.CalculateTimePeriod(liabilityViewModel.StartDate.Value, liabilityViewModel.EndDate.Value);
if (liabilityViewModel.StartDate <= current && current <= liabilityViewModel.EndDate)
{
int currentPeriod = Helper.CalculateTimePeriod(liabilityViewModel.StartDate.Value, DateTime.Now);
double interestRate = liability.InterestRatePerX == (int)Constants.Constants.INTEREST_RATE_PER.MONTH ? liability.InterestRate / 100 : liability.InterestRate / 1200;
liabilityViewModel.OriginalInterestPayment = liabilityViewModel.Value.Value * interestRate;
//Fixed interest type
if (liability.InterestType == (int)Constants.Constants.INTEREST_TYPE.FIXED)
{
liabilityViewModel.MonthlyOriginalPayment = liabilityViewModel.Value.Value / liabilityViewModel.PaymentPeriod;
liabilityViewModel.MonthlyInterestPayment = liabilityViewModel.Value.Value * interestRate;
liabilityViewModel.TotalMonthlyPayment = liabilityViewModel.MonthlyOriginalPayment + liabilityViewModel.MonthlyInterestPayment;
liabilityViewModel.TotalPayment = Helper.CalculateAnnualPayment(liability);
liabilityViewModel.RemainedValue = liabilityViewModel.Value.Value - liabilityViewModel.MonthlyOriginalPayment * (currentPeriod + 1);
liabilityViewModel.Status = "Đang nợ";
liabilityViewModel.StatusCode = "label-success";
}
//Reduced interest type
else
{
liabilityViewModel.MonthlyOriginalPayment = liabilityViewModel.Value.Value / liabilityViewModel.PaymentPeriod;
liabilityViewModel.RemainedValue = liabilityViewModel.Value.Value - liabilityViewModel.MonthlyOriginalPayment * (currentPeriod + 1);
liabilityViewModel.MonthlyInterestPayment = (liabilityViewModel.Value.Value - liabilityViewModel.MonthlyOriginalPayment * currentPeriod) * interestRate;
liabilityViewModel.TotalMonthlyPayment = liabilityViewModel.MonthlyOriginalPayment + liabilityViewModel.MonthlyInterestPayment;
liabilityViewModel.TotalPayment = Helper.CalculateAnnualPayment(liability);
liabilityViewModel.Status = "Đang nợ";
liabilityViewModel.StatusCode = "label-success";
}
}
else
{
liabilityViewModel.MonthlyOriginalPayment = 0;
liabilityViewModel.MonthlyInterestPayment = 0;
liabilityViewModel.TotalMonthlyPayment = 0;
liabilityViewModel.TotalPayment = 0;
liabilityViewModel.RemainedValue = 0;
if (liabilityViewModel.EndDate < current)
{
liabilityViewModel.StatusCode = "label-warning";
liabilityViewModel.Status = "Đã trả hết nợ";
}
else
{
liabilityViewModel.StatusCode = "label-danger";
liabilityViewModel.Status = "Chưa tới kì hạn";
}
}
return(liabilityViewModel);
}
public ActionResult _Confirm()
{
DateTime current = DateTime.Now;
RealEstateCreateViewModel model = (RealEstateCreateViewModel)HttpContext.Session["REAL_ESTATE"];
RealEstateViewModel viewModel = new RealEstateViewModel();
viewModel.Name = model.Name;
viewModel.Value = model.Value.Value;
viewModel.Income = model.Income.HasValue ? model.Income.Value : 0;
viewModel.AnnualIncome = viewModel.Income * 12;
viewModel.RentYield = viewModel.AnnualIncome / viewModel.Value;
RealEstateLiabilityListCreateViewModel liabilities = (RealEstateLiabilityListCreateViewModel)HttpContext.Session["LIABILITIES"];
viewModel.RowSpan = liabilities != null && liabilities.Liabilities.Count > 0 ? liabilities.Liabilities.Count() + 3 : 2;
if (liabilities != null && liabilities.Liabilities.Count > 0)
{
foreach (var liability in liabilities.Liabilities)
{
RealEstateLiabilityViewModel liabilityViewModel = new RealEstateLiabilityViewModel();
liabilityViewModel.Source = liability.Source;
liabilityViewModel.Value = liability.Value;
liabilityViewModel.InterestType = Helper.GetInterestType(liability.InterestType);
liabilityViewModel.InterestRatePerX = Helper.GetInterestTypePerX(liability.InterestRatePerX);
liabilityViewModel.InterestRate = liability.InterestRate / 100;
liabilityViewModel.StartDate = liability.StartDate.Value;
liabilityViewModel.EndDate = liability.EndDate.Value;
liabilityViewModel.PaymentPeriod = Helper.CalculateTimePeriod(liabilityViewModel.StartDate.Value, liabilityViewModel.EndDate.Value);
if (liabilityViewModel.StartDate <= current && current <= liabilityViewModel.EndDate)
{
int currentPeriod = Helper.CalculateTimePeriod(liabilityViewModel.StartDate.Value, DateTime.Now);
double interestRate = liability.InterestRatePerX == (int)Constants.Constants.INTEREST_RATE_PER.MONTH ? liability.InterestRate.Value / 100 : liability.InterestRate.Value / 1200;
liabilityViewModel.OriginalInterestPayment = liabilityViewModel.Value.Value * interestRate;
//Fixed interest type
if (liability.InterestType == (int)Constants.Constants.INTEREST_TYPE.FIXED)
{
liabilityViewModel.MonthlyOriginalPayment = liabilityViewModel.Value.Value / liabilityViewModel.PaymentPeriod;
liabilityViewModel.MonthlyInterestPayment = liabilityViewModel.Value.Value * interestRate;
liabilityViewModel.TotalMonthlyPayment = liabilityViewModel.MonthlyOriginalPayment + liabilityViewModel.MonthlyInterestPayment;
liabilityViewModel.TotalPayment = RealEstateLiabilityQueries.Helper.CalculateAnnualPayment(liability);
liabilityViewModel.RemainedValue = liabilityViewModel.Value.Value - liabilityViewModel.MonthlyOriginalPayment * (currentPeriod + 1);
liabilityViewModel.Status = "Đang nợ";
liabilityViewModel.StatusCode = "label-success";
}
//Reduced interest type
else
{
liabilityViewModel.MonthlyOriginalPayment = liabilityViewModel.Value.Value / liabilityViewModel.PaymentPeriod;
liabilityViewModel.RemainedValue = liabilityViewModel.Value.Value - liabilityViewModel.MonthlyOriginalPayment * (currentPeriod + 1);
liabilityViewModel.MonthlyInterestPayment = (liabilityViewModel.Value.Value - liabilityViewModel.MonthlyOriginalPayment * currentPeriod) * interestRate;
liabilityViewModel.TotalMonthlyPayment = liabilityViewModel.MonthlyOriginalPayment + liabilityViewModel.MonthlyInterestPayment;
liabilityViewModel.TotalPayment = RealEstateLiabilityQueries.Helper.CalculateAnnualPayment(liability);
liabilityViewModel.Status = "Đang nợ";
liabilityViewModel.StatusCode = "label-success";
}
}
else
{
liabilityViewModel.MonthlyOriginalPayment = 0;
liabilityViewModel.MonthlyInterestPayment = 0;
liabilityViewModel.TotalMonthlyPayment = 0;
liabilityViewModel.TotalPayment = 0;
liabilityViewModel.RemainedValue = 0;
}
viewModel.Liabilities.Add(liabilityViewModel);
}
var liabilitites = viewModel.Liabilities.Where(x => x.StartDate <= current && x.EndDate >= current);
viewModel.TotalLiabilityValue = liabilitites.Select(x => x.Value.Value).DefaultIfEmpty(0).Sum();
viewModel.TotalOriginalPayment = liabilitites.Select(x => x.MonthlyOriginalPayment).DefaultIfEmpty(0).Sum();
viewModel.TotalInterestPayment = liabilitites.Select(x => x.MonthlyInterestPayment).DefaultIfEmpty(0).Sum();
viewModel.TotalMonthlyPayment = liabilitites.Select(x => x.TotalMonthlyPayment).DefaultIfEmpty(0).Sum();
viewModel.TotalPayment = liabilitites.Select(x => x.TotalPayment).DefaultIfEmpty(0).Sum();
viewModel.TotalRemainedValue = liabilitites.Select(x => x.RemainedValue).DefaultIfEmpty(0).Sum();
viewModel.TotalInterestRate = viewModel.TotalLiabilityValue > 0 ? liabilitites.Select(x => x.OriginalInterestPayment).DefaultIfEmpty(0).Sum() / viewModel.TotalLiabilityValue * 12 : 0;
}
return(PartialView(viewModel));
}
