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