public ActionResult Edit([Bind(Include = "ID,ErrorNo,ErrorType,MeasuresTaken,ProcessDate,TimeRemaining,DelayReason,Person")] DSixTable dSixTable)
        {
            var userModel = common.getCurrentUserModel();

            dSixTable.Company = userModel.Company;

            if (ModelState.IsValid)
            {
                db.Entry(dSixTable).State = EntityState.Modified;
                try
                {
                    db.SaveChanges();
                }
                catch (DbEntityValidationException ex)
                {
                    ViewBag.Person    = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value
                    ViewBag.ErrorType = dropdownHelper.getPrecautionsForDSixErrorType();                                         // Precautions
                    return(View(dSixTable));
                }
                return(RedirectToAction("DSteps", "EightStep", new { errorNo = dSixTable.ErrorNo }));
            }

            ViewBag.Person    = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value
            ViewBag.ErrorType = dropdownHelper.getPrecautionsForDSixErrorType();                                         // Precautions


            return(View(dSixTable));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            DSixTable dSixTable   = db.DSixTable.Find(id);
            var       thisErrorNo = dSixTable.ErrorNo;

            db.DSixTable.Remove(dSixTable);
            db.SaveChanges();

            return(RedirectToAction("DSteps", "EightStep", new { errorNo = thisErrorNo }));
            //return RedirectToAction("Index");
        }
        // GET: DSixTables/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DSixTable dSixTable = db.DSixTable.Find(id);

            if (dSixTable == null)
            {
                return(HttpNotFound());
            }
            return(View(dSixTable));
        }
        // GET: DSixTables/Edit/5
        public ActionResult Edit(int?id)
        {
            var userModel = common.getCurrentUserModel();

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            DSixTable dSixTable = db.DSixTable.Find(id);

            if (dSixTable == null)
            {
                return(HttpNotFound());
            }

            ViewBag.Person    = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value
            ViewBag.ErrorType = dropdownHelper.getPrecautionsForDSixErrorType();                                         // Precautions

            return(View(dSixTable));
        }
        public ActionResult Create(HttpPostedFileBase[] imageFiles, HttpPostedFileBase[] documentFiles, [Bind(Include = "ID,ErrorType,MeasuresTaken,ProcessDate,TimeRemaining,DelayReason,Person")] DSixTable dSixTable)
        {
            var userModel = common.getCurrentUserModel();
            var errorNo   = common.getCurrentErrorNo();

            dSixTable.ErrorNo = errorNo;
            dSixTable.Company = userModel.Company;



            if (ModelState.IsValid)
            {
                db.DSixTable.Add(dSixTable);
                try
                {
                    db.SaveChanges();
                }
                catch (DbEntityValidationException ex)
                {
                    ViewBag.Person    = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value
                    ViewBag.ErrorType = dropdownHelper.getPrecautionsForDSixErrorType();                                         // Precautions
                    return(View(dSixTable));
                }

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


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


            ViewBag.Person    = new SelectList(db.UserTable.Where(x => x.Company == userModel.Company), "Name", "Name"); // text , value
            ViewBag.ErrorType = dropdownHelper.getPrecautionsForDSixErrorType();                                         // Precautions

            return(View(dSixTable));
        }