public ActionResult _RealEstateUpdateForm(RealEstateUpdateViewModel model) { double totalLiabilityValue = GetLiabilityValueOfRealEstate(model.Id); if (model.Value < totalLiabilityValue && totalLiabilityValue > 0) { ModelState.AddModelError("CompareRealEstateValueAndLiabilityValue", "Giá trị tổng số nợ không vượt quá giá trị bất động sản"); } var realEstate = RealEstateQueries.GetRealEstateById(model.Id); if (!realEstate.Name.Equals(model.Name) && RealEstateQueries.CheckExistRealEstate(UserQueries.GetCurrentUsername(), model.Name)) { ModelState.AddModelError("CheckExistRealEstate", "Bất động sản này đã tồn tại, vui lòng nhập tên khác"); } if (ModelState.IsValid) { int result = RealEstateQueries.UpdateRealEstate(model); if (result > 0) { return(Content("success")); } else { return(Content("failed")); } } else { return(PartialView(model)); } }
public static RealEstateUpdateViewModel GetRealEstateById(int id) { RealEstateUpdateViewModel viewmodel = new RealEstateUpdateViewModel(); Entities entities = new Entities(); var realEstate = entities.Assets.Where(x => x.Id == id).FirstOrDefault(); viewmodel.Id = realEstate.Id; viewmodel.Name = realEstate.AssetName; viewmodel.Value = realEstate.Value; if (realEstate.Incomes1.Where(x => !x.DisabledDate.HasValue).Any()) { viewmodel.Income = realEstate.Incomes1.FirstOrDefault().Value; } else { viewmodel.Income = 0; } return(viewmodel); }
public static int UpdateRealEstate(RealEstateUpdateViewModel model) { Entities entities = new Entities(); DateTime current = DateTime.Now; var realEstate = entities.Assets.Where(x => x.Id == model.Id).FirstOrDefault(); realEstate.AssetName = model.Name; realEstate.Value = model.Value.Value; entities.Assets.Attach(realEstate); entities.Entry(realEstate).State = System.Data.Entity.EntityState.Modified; if (entities.Incomes.Where(x => x.AssetId == model.Id).Any()) { var income = entities.Incomes.Where(x => x.AssetId == model.Id).FirstOrDefault(); income.Value = model.Income.HasValue ? model.Income.Value : 0; income.Name = "Thu nhập cho thuê từ " + model.Name; entities.Incomes.Attach(income); entities.Entry(income).State = System.Data.Entity.EntityState.Modified; } else { Incomes income = new Incomes(); income.Name = "Thu nhập cho thuê từ " + realEstate.AssetName; income.Value = model.Income.Value; income.IncomeDay = 1; income.StartDate = current; income.CreatedDate = current; income.CreatedBy = Constants.Constants.USER; income.IncomeType = (int)Constants.Constants.INCOME_TYPE.REAL_ESTATE_INCOME; income.Username = realEstate.Username; realEstate.Incomes1.Add(income); } return(entities.SaveChanges()); }
public ActionResult _RealEstateUpdateForm(int id) { RealEstateUpdateViewModel model = RealEstateQueries.GetRealEstateById(id); return(PartialView(model)); }