public ActionResult ModyfyInitialValue([Bind(Include = "AssetId,ChangingDate,ValueOfChange,ValueAfterChange,ReasonForChangingId,AssetName,ChangingDate")] ChangeInValueItem changeInValueItem) { Asset asset = db.T_Assets.Find(changeInValueItem.AssetId); ChangeInValue changeInValue = new ChangeInValue(); changeInValue.AssetId = changeInValueItem.AssetId; changeInValue.ChangingDate = changeInValueItem.ChangingDate; changeInValue.ReasonForChangingId = changeInValueItem.ReasonForChangingId; changeInValue.ValueAfterChange = changeInValueItem.ValueAfterChange; changeInValue.ValueOfChange = changeInValueItem.ValueAfterChange - asset.InitialValue; asset.InitialValue = changeInValueItem.ValueAfterChange; db.T_ChangeInValues.Add(changeInValue); db.SaveChanges(); return(RedirectToAction("Edit", new { id = changeInValueItem.AssetId })); }
static public List <ChangeInValueItem> GetChangeInValueList(ApplicationDbContext db, int?assetId) { if (assetId == null) { assetId = 0; } List <ChangeInValue> changeInValues = db.T_ChangeInValues.Where(c => c.AssetId == assetId).ToList(); List <ChangeInValueItem> changeInValueItems = new List <ChangeInValueItem>(); foreach (ChangeInValue changeInValue in changeInValues) { ChangeInValueItem changeInValueItem = new ChangeInValueItem(); changeInValueItem.ChangingDate = changeInValue.ChangingDate; ReasonForChanging reasonForChanging = db.T_ReasonForChangings.Where(r => r.Id == changeInValue.ReasonForChangingId).FirstOrDefault(); changeInValueItem.ReasonForChangingName = reasonForChanging.Description; changeInValueItem.ValueOfChange = changeInValue.ValueOfChange; changeInValueItem.ValueAfterChange = changeInValue.ValueAfterChange; changeInValueItems.Add(changeInValueItem); } return(changeInValueItems); }
// GET: Assets/Details/5 public ActionResult ModyfyInitialValue(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Asset asset = db.T_Assets.Find(id); if (asset == null) { return(HttpNotFound()); } ChangeInValueItem changeInValueItem = new ChangeInValueItem(); changeInValueItem.AssetId = asset.Id; changeInValueItem.AssetName = asset.AssetName; changeInValueItem.ChangingDate = DateTime.Now; changeInValueItem.ReasonForChangings = db.T_ReasonForChangings.ToList(); changeInValueItem.ValueBeforeChange = asset.InitialValue; changeInValueItem.ValueAfterChange = asset.InitialValue; return(View(changeInValueItem)); }