//---------------------------------------------------// //---------------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()); }