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