public JsonResult DeleteFile(string id) { if (String.IsNullOrEmpty(id)) { Response.StatusCode = (int)HttpStatusCode.BadRequest; return(Json(new { Result = "Error" })); } try { Guid guid = new Guid(id); FileWoDetail fileWoDetail = db.FileWoDetails.Find(guid); if (fileWoDetail == null) { Response.StatusCode = (int)HttpStatusCode.NotFound; return(Json(new { Result = "Error" })); } //Remove from database db.FileWoDetails.Remove(fileWoDetail); db.SaveChanges(); //Delete file from the file system var path = Path.Combine(Server.MapPath("~/images/"), fileWoDetail.Id + fileWoDetail.Extension); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } return(Json(new { Result = "OK" })); } catch (Exception ex) { return(Json(new { Result = "ERROR", Message = ex.Message })); } }
//public ActionResult Edit([Bind(Include = "WorkOrderFId,CustomerId,CustomerDivisionId,MlsDivisionId,ContractorId,WoPartTypeId,WorkOrderNumber,NeedDate,PromiseDate,ShipDate,CustomerPn,Qty,CreationDate,StartTime,FinishTime,CloseDate,OrderTypeId,SageJournalNo,Sn,NewSn,CustomerPo,MlsSo,WoOrderStatusId,PartStockOutId,WoNotes,PartsNeeded,PartStockOutNotes,Parts,Equipment,Resources,Notes,Day1,Day2,Day3,Day4,Day5,Day6,Day7,Day8,Day9,Day10,Wk3,Wk4,Wk5,Wk6,Wk7,Wk8")] WorkOrderF workOrderF) public ActionResult Edit(WorkOrderF workOrderF, string returnUrl) { 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); FileWoDetail fileWoDetail = new FileWoDetail() { FileName = fileName, Extension = Path.GetExtension(fileName), Id = Guid.NewGuid(), WorkOrderFId = workOrderF.WorkOrderFId }; var path = Path.Combine(Server.MapPath("~/images/"), fileWoDetail.Id + fileWoDetail.Extension); file.SaveAs(path); db.Entry(fileWoDetail).State = EntityState.Added; } } db.Entry(workOrderF).State = EntityState.Modified; db.SaveChanges(); LogEditWorkOrderActivity(workOrderF); UpdateShipDateSO(workOrderF.WorkOrderFId, workOrderF.ShipDate); return(Redirect(returnUrl)); //return RedirectToAction("Index"); } return(View()); //return View(workOrderF); }
//public ActionResult Create([Bind(Include = "WorkOrderFId,CustomerId,CustomerDivisionId,MlsDivisionId,ContractorId,WoPartTypeId,WorkOrderNumber,NeedDate,PromiseDate,ShipDate,CustomerPn,Qty,CreationDate,StartTime,FinishTime,CloseDate,OrderTypeId,SageJournalNo,Sn,NewSn,CustomerPo,MlsSo,WoOrderStatusId,PartStockOutId,WoNotes,PartsNeeded,PartStockOutNotes,Parts,Equipment,Resources,Notes,Day1,Day2,Day3,Day4,Day5,Day6,Day7,Day8,Day9,Day10,Wk3,Wk4,Wk5,Wk6,Wk7,Wk8")] WorkOrderF workOrderF) public ActionResult Create(WorkOrderF workOrderF, string returnUrl) { if (ModelState.IsValid) { List <FileWoDetail> fileWoDetails = new List <FileWoDetail>(); 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); FileWoDetail fileWoDetail = new FileWoDetail() { FileName = fileName, Extension = Path.GetExtension(fileName), Id = Guid.NewGuid() }; fileWoDetails.Add(fileWoDetail); var path = Path.Combine(Server.MapPath("~/images/"), fileWoDetail.Id + fileWoDetail.Extension); file.SaveAs(path); } } workOrderF.FileWoDetails = fileWoDetails; db.WorkOrderFs.Add(workOrderF); db.SaveChanges(); LogCreateWorkOrderActivity(workOrderF); return(Redirect(returnUrl)); //return RedirectToAction("Index"); } return(View()); //return View(workOrderF); }