public ActionResult Create(Production production)
        {
            if (ModelState.IsValid)
            {
                db.Productions.Add(production);
                db.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.Production_PieceId = new SelectList(db.Pieces, "Piece_Id", "Piece_Name", production.Production_PieceId);
            return View(production);
        }
 public ActionResult Edit(Production production)
 {
     if (ModelState.IsValid)
     {
         db.Entry(production).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     ViewBag.Production_PieceId = new SelectList(db.Pieces, "Piece_Id", "Piece_Name", production.Production_PieceId);
     return View(production);
 }