public ActionResult Create([Bind(Include = "WorkOrderNumber,AssayID,TestID,EmployeeID,IsComplete,TotalCost,ResultID")] Order_Assay_Test order_Assay_Test, int workOrderID, int AssayID) { //This gives us all the tests that go with an assay List <int> testids = db.Database.SqlQuery <int>("SELECT TestID FROM Assay_Test WHERE Assay_Test.AssayID = " + AssayID).ToList(); foreach (var item in testids) { Order_Assay_Test record = new Order_Assay_Test(); record.WorkOrderNumber = workOrderID; record.AssayID = AssayID; record.TestID = item; db.Order_Assay_Test.Add(record); db.SaveChanges(); } int CID = 0; foreach (var item in db.WorkOrders) { if (item.WorkOrderNumber == workOrderID) { CID = item.ClientID; } } Client myClient = db.Clients.Find(CID); //passes the work order number, clientid, and assayid to the summary view in the home controller return(RedirectToAction("Summary", "Home", new { WOID = workOrderID, CID = myClient.ClientID, AID = AssayID })); //return View(order_Assay_Test); }
public ActionResult DeleteConfirmed(int id) { Order_Assay_Test order_Assay_Test = db.Order_Assay_Test.Find(id); db.Order_Assay_Test.Remove(order_Assay_Test); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "WorkOrderNumber,AssayID,TestID,EmployeeID,IsComplete,TotalCost,ResultID")] Order_Assay_Test order_Assay_Test) { if (ModelState.IsValid) { db.Entry(order_Assay_Test).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(order_Assay_Test)); }
// GET: Order_Assay_Test/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Order_Assay_Test order_Assay_Test = db.Order_Assay_Test.Find(id); if (order_Assay_Test == null) { return(HttpNotFound()); } return(View(order_Assay_Test)); }