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)); }