public ActionResult DeleteConfirmed(int id)
        {
            DFourTable dFourTable = db.DFourTable.Find(id);

            db.DFourTable.Remove(dFourTable);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: DFourTables/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DFourTable dFourTable = db.DFourTable.Find(id);

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

            if (dFourTable == null)
            {
                return(HttpNotFound());
            }
            //ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", dFourTable.ErrorNo);
            return(View(dFourTable));
        }
Exemple #4
0
        private int creteFiveReasonAllDesignt(int currentIndex, IXLWorksheet ws, DFourTable item)
        {
            int capsuleLastCellIndex;
            int capsuleStartCellIndex = currentIndex;

            ws.Cells("A" + currentIndex.ToString()).Value = "Oluşum Neden     1:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.OlusumNeden1;
            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Yakalanama Neden 1:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.YaklanamamaNeden1;

            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Oluşum Neden     2:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.OlusumNeden2;
            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Yakalanama Neden 2:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.YaklanamamaNeden2;


            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Oluşum Neden     3:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.OlusumNeden3;
            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Yakalanama Neden 3:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.YaklanamamaNeden3;


            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Oluşum Neden     4:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.OlusumNeden4;
            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Yakalanama Neden 4:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.YaklanamamaNeden4;


            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Oluşum Neden     5:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.OlusumNeden5;
            currentIndex++;
            ws.Cells("A" + currentIndex.ToString()).Value = "Yakalanama Neden 5:";
            ws.Cells("B" + currentIndex.ToString()).Value = item.YaklanamamaNeden5;

            capsuleLastCellIndex = currentIndex;
            capsuleDesign("A", capsuleStartCellIndex, "A", capsuleLastCellIndex, ws, false);
            capsuleDesign("B", capsuleStartCellIndex, "H", capsuleLastCellIndex, ws, false);

            return(currentIndex);
        }
        public ActionResult Edit([Bind(Include = "ID,ErrorNo,Machine,Method,Men,Material,Monde,OlusumNeden1,OlusumNeden2,OlusumNeden3,OlusumNeden4,OlusumNeden5,YaklanamamaNeden1,YaklanamamaNeden2,YaklanamamaNeden3,YaklanamamaNeden4,YaklanamamaNeden5")] DFourTable dFourTable)
        {
            var userModel = common.getCurrentUserModel();

            dFourTable.Company = userModel.Company;

            if (ModelState.IsValid)
            {
                db.Entry(dFourTable).State = EntityState.Modified;
                db.SaveChanges();
                //return RedirectToAction("Index");
                return(RedirectToAction("DSteps", "EightStep", new { errorNo = dFourTable.ErrorNo }));
            }
            //ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", dFourTable.ErrorNo);
            return(View(dFourTable));
        }
        public ActionResult Create(HttpPostedFileBase[] imageFiles, HttpPostedFileBase[] documentFiles, [Bind(Include = "ID,Machine,Method,Men,Material,Monde,OlusumNeden1,OlusumNeden2,OlusumNeden3,OlusumNeden4,OlusumNeden5,YaklanamamaNeden1,YaklanamamaNeden2,YaklanamamaNeden3,YaklanamamaNeden4,YaklanamamaNeden5")] DFourTable dFourTable)
        {
            var userModel = common.getCurrentUserModel();
            var errorNo   = common.getCurrentErrorNo();

            dFourTable.ErrorNo = errorNo;
            dFourTable.Company = userModel.Company;


            // save images on ImgesTable
            fileHelper.saveImagesDB(imageFiles, "D4", errorNo);
            // save document on NotesTable
            fileHelper.saveDocumentDB(documentFiles, "D4", errorNo);


            if (ModelState.IsValid)
            {
                db.DFourTable.Add(dFourTable);
                db.SaveChanges();

                return(RedirectToAction("DSteps", "EightStep", new { errorNo = dFourTable.ErrorNo }));
            }

            //ViewBag.ErrorNo = new SelectList(db.ErrorListTable, "ErrorNo", "Company", dFourTable.ErrorNo);
            return(View(dFourTable));
        }