public ActionResult DeleteConfirmed(int id)
        {
            ProductSinglePartNumber productsinglepartnumber = db.ProductSinglePartNumbers.Find(id);

            db.ProductSinglePartNumbers.Remove(productsinglepartnumber);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Edit([Bind(Include = "Id,ProductId,Batch,Description,ActiveStatus,CreatedBy,CreatedAt,UpdatedAt")] ProductSinglePartNumber productsinglepartnumber)
        {
            if (ModelState.IsValid)
            {
                db.Entry(productsinglepartnumber).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
//            ViewBag.CreatedBy = new SelectList(db.IdentityUsers, "Id", "UserName", productsinglepartnumber.CreatedBy);
            ViewBag.ProductId = new SelectList(db.HouseProducts, "Id", "ShelfRow", productsinglepartnumber.ProductId);
            return(View(productsinglepartnumber));
        }
        // GET: /ProductSinglePartNumber/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ProductSinglePartNumber productsinglepartnumber = db.ProductSinglePartNumbers.Find(id);

            if (productsinglepartnumber == null)
            {
                return(HttpNotFound());
            }
            return(View(productsinglepartnumber));
        }
        // GET: /ProductSinglePartNumber/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ProductSinglePartNumber productsinglepartnumber = db.ProductSinglePartNumbers.Find(id);

            if (productsinglepartnumber == null)
            {
                return(HttpNotFound());
            }
//            ViewBag.CreatedBy = new SelectList(db.IdentityUsers, "Id", "UserName", productsinglepartnumber.CreatedBy);
            ViewBag.ProductId = new SelectList(db.HouseProducts, "Id", "ShelfRow", productsinglepartnumber.ProductId);
            return(View(productsinglepartnumber));
        }