public ActionResult _LiabilityUpdateForm2nd(RealEstateLiabilityUpdateViewModel model)
{
double totalLiabilityValue = GetLiabilityValueOfRealEstate(model.AssetId);
double liabilityValue = GetLiabilityValue(model.Id);
double realEstateValue = RealEstateQueries.GetRealEstateValue(model.AssetId);
if (realEstateValue < totalLiabilityValue - liabilityValue + model.Value && totalLiabilityValue - liabilityValue + model.Value > 0)
{
ModelState.AddModelError("CompareRealEstateValueAndLiabilityValue", "Giá trị tổng số nợ không vượt quá giá trị bất động sản");
}
if (ModelState.IsValid)
{
int result = RealEstateLiabilityQueries.UpdateRealEstateLiability(model);
if (result > 0)
{
return(Content("success"));
}
else
{
return(Content("failed"));
}
}
else
{
return(PartialView(model));
}
}
public static int UpdateRealEstateLiability(RealEstateLiabilityUpdateViewModel model)
{
Entities entities = new Entities();
var realEstateLiability = entities.Liabilities.Where(x => x.Id == model.Id).FirstOrDefault();
realEstateLiability.Name = model.Source;
realEstateLiability.Value = model.Value.Value;
realEstateLiability.InterestType = model.InterestType;
realEstateLiability.InterestRatePerX = model.InterestRatePerX;
realEstateLiability.InterestRate = model.InterestRate.Value;
realEstateLiability.StartDate = model.StartDate.Value;
realEstateLiability.EndDate = model.EndDate.Value;
entities.Liabilities.Attach(realEstateLiability);
entities.Entry(realEstateLiability).State = System.Data.Entity.EntityState.Modified;
return(entities.SaveChanges());
}
public static RealEstateLiabilityUpdateViewModel GetViewModelById(int id)
{
Entities entities = new Entities();
var realEstateLiability = entities.Liabilities.Where(x => x.Id == id).FirstOrDefault();
RealEstateLiabilityUpdateViewModel liabilityViewModel = new RealEstateLiabilityUpdateViewModel();
liabilityViewModel.Id = realEstateLiability.Id;
liabilityViewModel.Source = realEstateLiability.Name;
liabilityViewModel.Value = realEstateLiability.Value;
liabilityViewModel.InterestType = realEstateLiability.InterestType.Value;
liabilityViewModel.InterestRatePerX = realEstateLiability.InterestRatePerX;
liabilityViewModel.InterestRate = realEstateLiability.InterestRate;
liabilityViewModel.StartDate = realEstateLiability.StartDate.Value;
liabilityViewModel.EndDate = realEstateLiability.EndDate.Value;
liabilityViewModel.AssetId = realEstateLiability.AssetId.Value;
return(liabilityViewModel);
}
public ActionResult _LiabilityUpdateForm2nd(int id)
{
RealEstateLiabilityUpdateViewModel model = RealEstateLiabilityQueries.GetViewModelById(id);
return(PartialView(model));
}
