public ActionResult _LiabilityUpdateForm2nd(StockLiabilityUpdateViewModel model) { double totalLiabilityValue = StockLiabilityQueries.GetLiabilityValueOfStock(model.AssetId); double liabilityValue = StockLiabilityQueries.GetStockValue(model.Id); double stockValue = StockQueries.GetStockValue(model.AssetId); if (stockValue < totalLiabilityValue - liabilityValue + model.Value && totalLiabilityValue - liabilityValue + model.Value > 0) { ModelState.AddModelError("CompareStockValueAndLiabilityValue", "Giá trị tổng số nợ không vượt quá giá trị cổ phiếu"); } if (ModelState.IsValid) { int result = StockLiabilityQueries.UpdateStockLiability(model); if (result > 0) { return(Content("success")); } else { return(Content("failed")); } } else { return(PartialView(model)); } }
public static int UpdateStockLiability(StockLiabilityUpdateViewModel model) { Entities entities = new Entities(); var stockLiability = entities.Liabilities.Where(x => x.Id == model.Id).FirstOrDefault(); stockLiability.Name = model.Source; stockLiability.Value = model.Value.Value; stockLiability.InterestType = model.InterestType; stockLiability.InterestRatePerX = model.InterestRatePerX; stockLiability.InterestRate = model.InterestRate.Value; stockLiability.StartDate = model.StartDate.Value; stockLiability.EndDate = model.EndDate.Value; entities.Liabilities.Attach(stockLiability); entities.Entry(stockLiability).State = System.Data.Entity.EntityState.Modified; return(entities.SaveChanges()); }
public static StockLiabilityUpdateViewModel GetViewModelById(int id) { Entities entities = new Entities(); var stockLiability = entities.Liabilities.Where(x => x.Id == id).FirstOrDefault(); StockLiabilityUpdateViewModel liabilityViewModel = new StockLiabilityUpdateViewModel(); liabilityViewModel.Id = stockLiability.Id; liabilityViewModel.Source = stockLiability.Name; liabilityViewModel.Value = stockLiability.Value; liabilityViewModel.InterestType = stockLiability.InterestType.Value / 100; liabilityViewModel.InterestRatePerX = stockLiability.InterestRatePerX; liabilityViewModel.InterestRate = stockLiability.InterestRate; liabilityViewModel.StartDate = stockLiability.StartDate.Value; liabilityViewModel.EndDate = stockLiability.EndDate.Value; liabilityViewModel.AssetId = stockLiability.StockTransactions.AssetId; return(liabilityViewModel); }
public ActionResult _LiabilityUpdateForm2nd(int id) { StockLiabilityUpdateViewModel model = StockLiabilityQueries.GetViewModelById(id); return(PartialView(model)); }