//---------------------------------------------------//
        //---------------Pressure Test Section---------------//
        //---------------------------------------------------//

        //
        // GET: /Pipeline/CreateDoc

        public ActionResult CreatePTR(Pipeline pipeline)
        {
            int entry = 0;

            try { entry = (int)db.PressureTestRecords.Where(p => p.PipelineID == pipeline.PipelineID).OrderByDescending(p => p.PressureTestRecordID).Max(d => d.PressureTestRecordID); }
            catch { }

            if (entry == 0)
            {
                Session["CurrentRecordIdentifier"] = "1";
            }
            else
            {
                entry++;
                try
                {
                    Session["CurrentRecordIdentifier"] = entry;
                }
                catch
                {
                    Session["CurrentRecordIdentifier"] = "1";
                }
            }


            PressureTestRecord pressuretestrecord = new PressureTestRecord()
            {
                PipelineID = pipeline.PipelineID
            };

            ViewBag.PipelineItem = pipeline.PipelineItem;
            //ViewBag.PTMedium = new SelectList(db.PTTestMediums, "PTTestMediumID", "PTMedium");
            ViewBag.PTMedium = new SelectList(db.PTTestMediums, "PTMedium", "PTMedium");
            return(View(pressuretestrecord));
        }
 public ActionResult EditPTR(PressureTestRecord pressuretestrecord)
 {
     if (ModelState.IsValid)
     {
         db.Entry(pressuretestrecord).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Details", "Pipeline", new { id = pressuretestrecord.PipelineID }));
     }
     return(View(pressuretestrecord));
 }
        public ActionResult DeletePTRConfirmed(int id)
        {
            PressureTestRecord pressuretestrecord = db.PressureTestRecords.Find(id);

            //Need to add in some validation code to look for feature attributes that have this document assigned to them.
            //Cannot delete the record if there are documents assigned to any features

            db.PressureTestRecords.Remove(pressuretestrecord);
            db.SaveChanges();
            return(RedirectToAction("Details", "Pipeline", new { id = pressuretestrecord.PipelineID }));
        }
        //
        // GET: /Pipeline/DeleteDoc

        public ActionResult DeletePTR(int id = 0)
        {
            PressureTestRecord pressuretestrecord = db.PressureTestRecords.Find(id);

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

            ViewBag.StationName = (from p in db.Pipelines
                                   join doc in db.PressureTestRecords on p.PipelineID equals doc.PipelineID
                                   where doc.PressureTestRecordID == pressuretestrecord.PressureTestRecordID
                                   select p.PipelineItem).FirstOrDefault();

            return(View(pressuretestrecord));
        }
        //
        // GET: /Pipeline/EditDoc/

        public ActionResult EditPTR(int id = 0)
        {
            PressureTestRecord pressuretestrecord = db.PressureTestRecords.Find(id);

            //ViewBag.SelectedPTMediumID = new SelectList(db.PTTestMediums, "PTTestMediumID", "PTMedium", pressuretestrecord.PTMedium);
            ViewBag.SelectedPTMediumID = new SelectList(db.PTTestMediums, "PTMedium", "PTMedium", pressuretestrecord.PTMedium);

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

            ViewBag.PipelineItem = db.Pipelines.Where(p => p.PipelineID == pressuretestrecord.PipelineID).Select(p => p.PipelineItem).FirstOrDefault();

            ViewBag.PressureTestRecordID = id;

            return(View(pressuretestrecord));
        }
        public ActionResult CreatePTR(PressureTestRecord pressuretestrecord)
        {
            if (ModelState.IsValid)
            {
                //documentrecord.PipelineID = Convert.ToInt64(Session["CurrentPipeline"].ToString());

                if (pressuretestrecord.PTMedium is null)
                {
                    pressuretestrecord.PTMedium = "Unknown";
                }
                pressuretestrecord.PressureTestRecordID = Convert.ToInt32(Session["CurrentRecordIdentifier"].ToString());

                db.PressureTestRecords.Add(pressuretestrecord);
                db.SaveChanges();
                return(RedirectToAction("Details", "Pipeline", new { id = pressuretestrecord.PipelineID }));
            }

            return(View());
        }