Styjun

I have a model that includes several tables. My Edit View allows users to modify a single record from the main table ICS_Transactions. Based on the users selected action (from dropdown). . . I need to update a field, in a secondary table (ICS_Supplies). In short, The field (OnHand) that shows the amount of inventory on hand, needs to be updated to the OnHand Amount minus the ordered amount.

The problem I am having is that my Edit View updates the ICS_Transaction Table, but I also need to update the ICS_Supplies table. And because MVC5 and the use of controllers (and Entity Framework and C#) are relatively new to me . . I am struggling. I come from the older asp.net web form days where I would just write the sql in vb.net and execute it on event.

I have a class which contains all the fields from both tables

 public class Edit2ViewModel

 public int? TransID get; set; 

 [Display(Name = "Supplies")]
 public string ItemDescription get; set; 

 [Display(Name = "Contact")]
 public string ContactName get; set; 

 [Display(Name = "Delivery Unit")]
 public string DeliveryUnit get; set;

 public string Street get; set; 

 public string Building get; set; 

 public string Room get; set; 
 public string City get; set; 
 public string State get; set; 
 public string ZipCode get; set; 
 public string PhoneNumber get; set; 
 public string UnitMeasure get; set; 
 public string CurrentStatus get; set; 
 public int? OnHand get; set; 
 public int? UnitsOrdered get; set; 

Then, on my Edit Controller, I have the following

 public ActionResult Edit(int? id)
 
 if (id == null)
 
 return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
 
 ICS_Transactions iCS_Transactions = db.ICS_Transactions.Find(id);
 if (iCS_Transactions == null)
 
 return HttpNotFound();
 

 // Find User Friendly Values

 var r = from tr in db.ICS_Transactions

 join un in db.ICS_Units
 on tr.DeliveryUnitID equals un.DeliveryUnitID
 join kt in db.ICS_Contacts
 on tr.Contact equals kt.LoginID
 join sp in db.ICS_Supplies on tr.SuppliesID equals sp.Supplies_ID
 where tr.TransID == id

 select new Edit2ViewModel

 

 ItemDescription = sp.ItemDescription, 
 ContactName = kt.ContactName, 
 DeliveryUnit = un.DeliveryUnit,
 Street = un.Street,
 Building = un.Building,
 City = un.City,
 State = un.State,
 ZipCode = un.ZipCode,
 PhoneNumber = un.PhoneNumber,
 UnitMeasure = sp.UnitMeasure,
 CurrentStatus = tr.CurrentStatus,
 OnHand = sp.OnHand,
 UnitsOrdered = tr.UnitsOrdered



 ;

 // set user friendly values as ViewBag 


 ViewBag.Stock = r.FirstOrDefault().OnHand;
 ViewBag.Ordered = r.FirstOrDefault().UnitsOrdered;
 ViewBag.Total = (int)ViewBag.Stock - (int)ViewBag.Ordered;

 return View(iCS_Transactions);
 

This is where I begin to get lost. So far, all works as expected. On My EDIT VIEW, I can use the values from the Viewbag(s) to populate the view with the amount of stock on hand. The amount of stock ordered, and then the remaining stock after the order is procsessed (Viewbag.Total). These values are NOT located in the ICS_Transactions table . . which is why I used the Viewbag to pull them from the ICS_Supplies Table.

But now, when the user processes the order, and hits the save button, I want to update the ICS_Supplies Table (not the ICS_Transactions Table) with the NEW amount on hand (Viewbag.Total). But I can't figure out how to step backwards to the controller and update the ICS_Supplies table.

Here is my Edit/Post Code (so far). I think this is where I would put the code to update, but I need some help getting started . . .

 // POST: OrderManagement/Edit/5
 // To protect from overposting attacks, please enable the specific properties you want to bind to, for 
 // more details see http://go.microsoft.com/fwlink/?LinkId=317598.
 [HttpPost]
 [ValidateAntiForgeryToken]
 public ActionResult Edit([Bind(Include = "TransID,SuppliesID,OriginalDate,TransType,LastUpdatedBy,Contact,OpenClosed,CurrentStatus,CurrentStatusDate,RequsitionNumber,PONumber,DeliveryMonth,DeliveryYear,UnitsOrdered,Emergency,Comments,DeliveryUnitID")] ICS_Transactions iCS_Transactions)
 
 if (ModelState.IsValid)
 
 db.Entry(iCS_Transactions).State = EntityState.Modified;
 db.SaveChanges();
 return RedirectToAction("Index");
 
 return View(iCS_Transactions);