public JsonResult Delete(int id) { try { BomTracker bomTracker = db.BomTrackers.Find(id); if (bomTracker == null) { Response.StatusCode = (int)HttpStatusCode.NotFound; return(Json(new { Result = "Error" })); } //delete files from the file system foreach (var item in bomTracker.FileBomDetails) { String path = Path.Combine(Server.MapPath("~/images/"), item.Id + item.Extension); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } } db.BomTrackers.Remove(bomTracker); db.SaveChanges(); return(Json(new { Result = "OK" })); } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = ex.Message })); } }
// GET: BomTrackers/Edit/5 public ActionResult Edit(int?id) { var boms = db.BomTrackers.SingleOrDefault(c => c.BomTrackerId == id); var statuses = db.BomStatuses.ToList(); var viewModel = new SaveBomTrackerViewModel() { BomTracker = boms, BomStatuses = statuses, }; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } //BomTracker bomTracker = db.BomTrackers.Find(id); BomTracker bomTracker = db.BomTrackers.Include(s => s.FileBomDetails).SingleOrDefault(x => x.BomTrackerId == id); if (bomTracker == null) { return(HttpNotFound()); } return(View("Edit", viewModel)); //return View(bomTracker); }
//public ActionResult Edit([Bind(Include = "BomTrackerId,BomStatusId,BomPn,Description,RevLevel,BomCreatorExcel,DateCreatedExcel,BomCreatorSage,DateCreatedSage,BomCreatorPortal,DateCreatedPortal,ApprovedBy,DateApproved,Notes")] BomTracker bomTracker) public ActionResult Edit(BomTracker bomTracker) { if (ModelState.IsValid) { //New Files for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); FileBomDetail fileBomDetail = new FileBomDetail() { FileName = fileName, Extension = Path.GetExtension(fileName), Id = Guid.NewGuid(), BomTrackerId = bomTracker.BomTrackerId }; var path = Path.Combine(Server.MapPath("~/images/"), fileBomDetail.Id + fileBomDetail.Extension); file.SaveAs(path); db.Entry(fileBomDetail).State = EntityState.Added; } } db.Entry(bomTracker).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); //return View(bomTracker); }
//public ActionResult Create([Bind(Include = "BomTrackerId,BomStatusId,BomPn,Description,RevLevel,BomCreatorExcel,DateCreatedExcel,BomCreatorSage,DateCreatedSage,BomCreatorPortal,DateCreatedPortal,ApprovedBy,DateApproved,Notes")] BomTracker bomTracker) public ActionResult Create(BomTracker bomTracker) { if (ModelState.IsValid) { List <FileBomDetail> fileBomDetails = new List <FileBomDetail>(); for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); FileBomDetail fileBomDetail = new FileBomDetail() { FileName = fileName, Extension = Path.GetExtension(fileName), Id = Guid.NewGuid() }; fileBomDetails.Add(fileBomDetail); var path = Path.Combine(Server.MapPath("~/images/"), fileBomDetail.Id + fileBomDetail.Extension); file.SaveAs(path); } } bomTracker.FileBomDetails = fileBomDetails; db.BomTrackers.Add(bomTracker); db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); //return View(bomTracker); }
// GET: BomTrackers/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } BomTracker bomTracker = db.BomTrackers.Find(id); if (bomTracker == null) { return(HttpNotFound()); } return(View(bomTracker)); }